NMR-STAR dictionary: detail of Bond table

NMR-STAR dictionary: database table: Bond

Detailed description of the fields

_Bond.ID (BondID)

NMR-STAR tag name	_Bond.ID
Description	NMR-STAR name: _Bond.ID Unique identifier for the bond being defined. The value can be a unique integer (i.e., 1, 2, 3, etc.).
Database field name	BondID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	yes: This tag contains the identifier for this saveframe in the entry.
Row Index	yes: This tag contains the index of this row in the loop, which is used when the data is loaded into a database which has a relational model in which ordering doesn't matter
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Unique bond identifier
Examples	1
Help text

_Bond.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Type
Description	NMR-STAR name: _Bond.Type A descriptive phrase or word that characterized the bond.
Database field name	Type
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Bond type
Examples	disulfide
Help text

_Bond.Order (BondOrder)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Order
Description	NMR-STAR name: _Bond.Order The order of the bond between two atoms (i.e., single, double, etc.)
Database field name	BondOrder
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Enumerations	[click for a list of enumerations] This is a closed enumeration. The list of values are the only ones allowed.
Prompt	Bond order
Examples	SING
Help text

_Bond.Assembly_atom_ID_1 (AssemblyAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Assembly_atom_ID_1
Description	NMR-STAR name: _Bond.Assembly_atom_ID_1 Pointer to '_Atom.Assembly_atom_ID'
Database field name	AssemblyAtomID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Atom, Assembly_atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Assembly atom ID 1
Examples	?
Help text

_Bond.Entity_assembly_ID_1 (EntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Entity_assembly_ID_1
Description	NMR-STAR name: _Bond.Entity_assembly_ID_1 Pointer to '_Entity_assembly.ID'
Database field name	EntityAssemblyID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Atom 1 entity assembly component ID
Examples	?
Help text

_Bond.Entity_assembly_name_1 (EntityAssemblyName1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Entity_assembly_name_1
Description	NMR-STAR name: _Bond.Entity_assembly_name_1 Pointer to '_Entity_assembly.Entity_assembly_name'
Database field name	EntityAssemblyName1
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, Entity_assembly_name
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entity assembly name 1
Examples	?
Help text

_Bond.Entity_ID_1 (EntityID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Entity_ID_1
Description	NMR-STAR name: _Bond.Entity_ID_1 Pointer to '_Entity.ID'
Database field name	EntityID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Atom 1 entity ID
Examples	?
Help text

_Bond.Comp_ID_1 (CompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Comp_ID_1
Description	NMR-STAR name: _Bond.Comp_ID_1 Pointer to '_Chem_comp.ID'
Database field name	CompID1
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Atom 1 comp ID
Examples	?
Help text

_Bond.Comp_index_ID_1 (CompIndexID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Comp_index_ID_1
Description	NMR-STAR name: _Bond.Comp_index_ID_1 Pointer to '_Entity_comp_index.ID'
Database field name	CompIndexID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_comp_index, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp index ID 1
Examples	?
Help text

_Bond.Seq_ID_1 (SeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Seq_ID_1
Description	NMR-STAR name: _Bond.Seq_ID_1 Pointer to '_PDBX_poly_seq_scheme.Seq_ID'
Database field name	SeqID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_poly_seq, Num
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	First bonded atom's residue sequence number
Examples	36
Help text

_Bond.Atom_ID_1 (AtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Atom_ID_1
Description	NMR-STAR name: _Bond.Atom_ID_1 Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtomID1
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp_atom, Atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	First bonded atom's name
Examples	SG
Help text

_Bond.Assembly_atom_ID_2 (AssemblyAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Assembly_atom_ID_2
Description	NMR-STAR name: _Bond.Assembly_atom_ID_2 Pointer to '_Atom.Assembly_atom_ID'
Database field name	AssemblyAtomID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Atom, Assembly_atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Assembly atom ID 2
Examples	?
Help text

_Bond.Entity_assembly_ID_2 (EntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Entity_assembly_ID_2
Description	NMR-STAR name: _Bond.Entity_assembly_ID_2 Pointer to '_Entity_assembly.ID'
Database field name	EntityAssemblyID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Atom 2 entity assembly component ID
Examples	?
Help text

_Bond.Entity_assembly_name_2 (EntityAssemblyName2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Entity_assembly_name_2
Description	NMR-STAR name: _Bond.Entity_assembly_name_2 Pointer to '_Entity_assembly.Entity_assembly_name'
Database field name	EntityAssemblyName2
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, Entity_assembly_name
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entity assembly name 2
Examples	?
Help text

_Bond.Entity_ID_2 (EntityID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Entity_ID_2
Description	NMR-STAR name: _Bond.Entity_ID_2 Pointer to '_Entity.ID'
Database field name	EntityID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Atom 2 entity ID
Examples	?
Help text

_Bond.Comp_ID_2 (CompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Comp_ID_2
Description	NMR-STAR name: _Bond.Comp_ID_2 Pointer to '_Chem_comp.ID'
Database field name	CompID2
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Atom 2 comp ID
Examples	?
Help text

_Bond.Comp_index_ID_2 (CompIndexID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Comp_index_ID_2
Description	NMR-STAR name: _Bond.Comp_index_ID_2 Pointer to '_Entity_comp_index.ID'
Database field name	CompIndexID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_comp_index, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp index ID 2
Examples	?
Help text

_Bond.Seq_ID_2 (SeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Seq_ID_2
Description	NMR-STAR name: _Bond.Seq_ID_2 Pointer to '_PDBX_poly_seq_scheme.Seq_ID'
Database field name	SeqID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_poly_seq, Num
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Second bonded atom residue sequence number
Examples	5
Help text

_Bond.Atom_ID_2 (AtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Atom_ID_2
Description	NMR-STAR name: _Bond.Atom_ID_2 Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtomID2
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp_atom, Atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Name for the second atom
Examples	SG
Help text

_Bond.Auth_entity_assembly_ID_1 (AuthEntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_entity_assembly_ID_1
Description	NMR-STAR name: _Bond.Auth_entity_assembly_ID_1 Enter the name given to the biopolymer or ligand as a component of the molecular system where the first atom in the bond is located. For complex systems that have many components, this might be something like 'alpha chain 1' or 'heme 3'. A pull down list of the names assigned to the molecular system components in the section above is provided.
Database field name	AuthEntityAssemblyID1
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	First bonded atom molecular assembly component
Examples	monomer 1
Help text

_Bond.Auth_entity_assembly_name_1 (AuthEntityAssemblyName1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_entity_assembly_name_1
Description	NMR-STAR name: _Bond.Auth_entity_assembly_name_1 Enter the name given to the biopolymer or ligand as a component of the molecular system where the first atom in the bond is located. For complex systems that have many components, this might be something like 'alpha chain 1' or 'heme 3'. A pull down list of the names assigned to the molecular system components in the section above is provided.
Database field name	AuthEntityAssemblyName1
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	First bonded atom molecular assembly component
Examples	monomer 1
Help text

_Bond.Auth_seq_ID_1 (AuthSeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_seq_ID_1
Description	NMR-STAR name: _Bond.Auth_seq_ID_1 Enter the residue sequence number or code for the first atom in the bond. If the atom is located in a ligand a residue sequence number does not apply, enter 'na'.
Database field name	AuthSeqID1
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	First bonded atom residue sequence number
Examples	13
Help text

_Bond.Auth_comp_ID_1 (AuthCompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_comp_ID_1
Description	NMR-STAR name: _Bond.Auth_comp_ID_1 Enter the residue code (three-letter code for amino acids or one-letter code for nucleic acids) for the first atom in the bond. If the atom is located in a ligand an 'residue code' does not apply, enter 'na'.
Database field name	AuthCompID1
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	First bonded atom residue code
Examples	CYS
Help text

_Bond.Auth_atom_ID_1 (AuthAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_atom_ID_1
Description	NMR-STAR name: _Bond.Auth_atom_ID_1 Enter the name for the first atom in the bond. For amino acids and nucleic acids, the IUPAC atom nomenclature is prefered.
Database field name	AuthAtomID1
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	First bonded atom name
Examples	SG
Help text

_Bond.Auth_entity_assembly_ID_2 (AuthEntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_entity_assembly_ID_2
Description	NMR-STAR name: _Bond.Auth_entity_assembly_ID_2 Enter the name given to the biopolymer or ligand as a component of the molecular system where the second atom in the bond is located. For complex systems that have many components, this might be something like 'alpha chain 1' or 'heme 3'. A pull down list of the names assigned to the molecular system components in the section above is provided.
Database field name	AuthEntityAssemblyID2
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Second bonded atom molecular assembly component
Examples	monomer 2
Help text

_Bond.Auth_entity_assembly_name_2 (AuthEntityAssemblyName2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_entity_assembly_name_2
Description	NMR-STAR name: _Bond.Auth_entity_assembly_name_2 Enter the name given to the biopolymer or ligand as a component of the molecular system where the second atom in the bond is located. For complex systems that have many components, this might be something like 'alpha chain 1' or 'heme 3'. A pull down list of the names assigned to the molecular system components in the section above is provided.
Database field name	AuthEntityAssemblyName2
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Second bonded atom molecular assembly component
Examples	monomer 2
Help text

_Bond.Auth_seq_ID_2 (AuthSeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_seq_ID_2
Description	NMR-STAR name: _Bond.Auth_seq_ID_2 Enter the residue sequence number or code for the first atom in the bond. If the atom is located in a ligand a residue sequence number does not apply, enter 'na'.
Database field name	AuthSeqID2
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Second bonded atom residue sequence number
Examples	42
Help text

_Bond.Auth_comp_ID_2 (AuthCompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_comp_ID_2
Description	NMR-STAR name: _Bond.Auth_comp_ID_2 Enter the residue code (three-letter code for amino acids or one-letter code for nucleic acids) for the first atom in the bond. If the atom is located in a ligand an 'residue code' does not apply, enter 'na'.
Database field name	AuthCompID2
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Second bonded atom residue code
Examples	CYS
Help text

_Bond.Auth_atom_ID_2 (AuthAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Auth_atom_ID_2
Description	NMR-STAR name: _Bond.Auth_atom_ID_2 Enter the name for the first atom in the bond. For amino acids and nucleic acids, the IUPAC atom nomenclature is prefered.
Database field name	AuthAtomID2
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Second bonded atom name
Examples	SG
Help text

_Bond.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Sf_ID
Description	NMR-STAR name: _Bond.Sf_ID Pointer to '_Assembly.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Assembly, Sf_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	yes This field's data is for internal use only and should be hidden in public versiond of the data.
Nulls allowed in database?	yes
Prompt	Sf ID
Examples	?
Help text

_Bond.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Entry_ID
Description	NMR-STAR name: _Bond.Entry_ID Pointer to '_Entry.ID'
Database field name	EntryID
SQL Database type	CHAR(12)
Part of primary Key	yes
Foreign Key on table, column	Assembly, Entry_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entry ID
Examples	?
Help text

_Bond.Assembly_ID (AssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Bond.Assembly_ID
Description	NMR-STAR name: _Bond.Assembly_ID Pointer to '_Assembly.ID'
Database field name	AssemblyID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Assembly ID
Examples	?
Help text