NMR-STAR dictionary: detail of BondAnnotation table

NMR-STAR dictionary: database table: BondAnnotation

Detailed description of the fields

_Bond_annotation.ID (BondAnnotationID)

NMR-STAR tag name	_Bond_annotation.ID
Description	NMR-STAR name: _Bond_annotation.ID Unique identifier for the reported bond annotation.
Database field name	BondAnnotationID
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	ID
Examples	?
Help text

_Bond_annotation.Bond_type (BondType)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Bond_type
Description	NMR-STAR name: _Bond_annotation.Bond_type A commonly used term that describes the chemical nature of the bond.
Database field name	BondType
SQL Database type	VARCHAR(31)
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	disufide
Help text

_Bond_annotation.Bond_order (BondOrder)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Bond_order
Description	NMR-STAR name: _Bond_annotation.Bond_order The order of the defined bond.
Database field name	BondOrder
SQL Database type	VARCHAR(31)
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 order
Examples	single
Help text

_Bond_annotation.Selection_method_ID (SelectionMethodID)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Selection_method_ID
Description	NMR-STAR name: _Bond_annotation.Selection_method_ID Pointer to '_Method.ID'
Database field name	SelectionMethodID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Method, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Selection method ID
Examples	?
Help text

_Bond_annotation.Assembly_atom_ID_1 (AssemblyAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Assembly_atom_ID_1
Description	NMR-STAR name: _Bond_annotation.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_annotation.Entity_assembly_ID_1 (EntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Entity_assembly_ID_1
Description	NMR-STAR name: _Bond_annotation.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	Entity assembly ID 1
Examples	?
Help text

_Bond_annotation.Entity_ID_1 (EntityID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Entity_ID_1
Description	NMR-STAR name: _Bond_annotation.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	Entity ID 1
Examples	?
Help text

_Bond_annotation.Comp_index_ID_1 (CompIndexID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Comp_index_ID_1
Description	NMR-STAR name: _Bond_annotation.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_annotation.Seq_ID_1 (SeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Seq_ID_1
Description	NMR-STAR name: _Bond_annotation.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	Seq ID 1
Examples	?
Help text

_Bond_annotation.Comp_ID_1 (CompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Comp_ID_1
Description	NMR-STAR name: _Bond_annotation.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	Comp ID 1
Examples	?
Help text

_Bond_annotation.Atom_ID_1 (AtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Atom_ID_1
Description	NMR-STAR name: _Bond_annotation.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	Atom ID 1
Examples	?
Help text

_Bond_annotation.Atom_type_1 (AtomType1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Atom_type_1
Description	NMR-STAR name: _Bond_annotation.Atom_type_1 Standard symbol used to define the atom element type.
Database field name	AtomType1
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?	yes
Prompt	Atom type 1
Examples	?
Help text

_Bond_annotation.Atom_isotope_number_1 (AtomIsotopeNumber1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Atom_isotope_number_1
Description	NMR-STAR name: _Bond_annotation.Atom_isotope_number_1 ?
Database field name	AtomIsotopeNumber1
SQL Database type	INTEGER
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	Atom isotope number 1
Examples	?
Help text

_Bond_annotation.Assembly_atom_ID_2 (AssemblyAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Assembly_atom_ID_2
Description	NMR-STAR name: _Bond_annotation.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_annotation.Entity_assembly_ID_2 (EntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Entity_assembly_ID_2
Description	NMR-STAR name: _Bond_annotation.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	Entity assembly ID 2
Examples	?
Help text

_Bond_annotation.Entity_ID_2 (EntityID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Entity_ID_2
Description	NMR-STAR name: _Bond_annotation.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	Entity ID 2
Examples	?
Help text

_Bond_annotation.Comp_index_ID_2 (CompIndexID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Comp_index_ID_2
Description	NMR-STAR name: _Bond_annotation.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_annotation.Seq_ID_2 (SeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Seq_ID_2
Description	NMR-STAR name: _Bond_annotation.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	Seq ID 2
Examples	?
Help text

_Bond_annotation.Comp_ID_2 (CompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Comp_ID_2
Description	NMR-STAR name: _Bond_annotation.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	Comp ID 2
Examples	?
Help text

_Bond_annotation.Atom_ID_2 (AtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Atom_ID_2
Description	NMR-STAR name: _Bond_annotation.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	Atom ID 2
Examples	?
Help text

_Bond_annotation.Atom_type_2 (AtomType2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Atom_type_2
Description	NMR-STAR name: _Bond_annotation.Atom_type_2 Standard symbol used to define the atom element type.
Database field name	AtomType2
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?	yes
Prompt	Atom type 2
Examples	?
Help text

_Bond_annotation.Atom_isotope_number_2 (AtomIsotopeNumber2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Atom_isotope_number_2
Description	NMR-STAR name: _Bond_annotation.Atom_isotope_number_2 ?
Database field name	AtomIsotopeNumber2
SQL Database type	INTEGER
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	Atom isotope number 2
Examples	?
Help text

_Bond_annotation.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Details
Description	NMR-STAR name: _Bond_annotation.Details Text description providing additional information about the reported bond.
Database field name	Details
SQL Database type	TEXT
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	Details
Examples	?
Help text

_Bond_annotation.Auth_entity_assembly_ID_1 (AuthEntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Auth_entity_assembly_ID_1
Description	NMR-STAR name: _Bond_annotation.Auth_entity_assembly_ID_1 ?
Database field name	AuthEntityAssemblyID1
SQL Database type	INTEGER
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	Auth entity assembly ID 1
Examples	2
Help text

_Bond_annotation.Auth_seq_ID_1 (AuthSeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Auth_seq_ID_1
Description	NMR-STAR name: _Bond_annotation.Auth_seq_ID_1 An alternative identifier for Seq_id that may be provided by an author in order to match that used in the publication that describes the experimental data. Note that the value is not required to be a number and does not need to correspond to the value for Seq_ID or Comp_index_ID.
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	Auth seq ID 1
Examples	-3
Help text

_Bond_annotation.Auth_comp_ID_1 (AuthCompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Auth_comp_ID_1
Description	NMR-STAR name: _Bond_annotation.Auth_comp_ID_1 An alternative identifier for Comp_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
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	Auth comp ID 1
Examples	DPN
Help text

_Bond_annotation.Auth_atom_ID_1 (AuthAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Auth_atom_ID_1
Description	NMR-STAR name: _Bond_annotation.Auth_atom_ID_1 An alternative identifier for Atom_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
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	Auth atom ID 1
Examples	HB1
Help text

_Bond_annotation.Auth_entity_assembly_ID_2 (AuthEntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Auth_entity_assembly_ID_2
Description	NMR-STAR name: _Bond_annotation.Auth_entity_assembly_ID_2 ?
Database field name	AuthEntityAssemblyID2
SQL Database type	INTEGER
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	Auth entity assembly ID 2
Examples	2
Help text

_Bond_annotation.Auth_seq_ID_2 (AuthSeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Auth_seq_ID_2
Description	NMR-STAR name: _Bond_annotation.Auth_seq_ID_2 An alternative identifier for Seq_id that may be provided by an author in order to match that used in the publication that describes the experimental data. Note that the value is not required to be a number and does not need to correspond to the value for Seq_ID or Comp_index_ID.
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	Auth seq ID 2
Examples	-3
Help text

_Bond_annotation.Auth_comp_ID_2 (AuthCompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Auth_comp_ID_2
Description	NMR-STAR name: _Bond_annotation.Auth_comp_ID_2 An alternative identifier for Comp_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
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	Auth comp ID 2
Examples	DPN
Help text

_Bond_annotation.Auth_atom_ID_2 (AuthAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Auth_atom_ID_2
Description	NMR-STAR name: _Bond_annotation.Auth_atom_ID_2 An alternative identifier for Atom_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
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	Auth atom ID 2
Examples	HB1
Help text

_Bond_annotation.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Sf_ID
Description	NMR-STAR name: _Bond_annotation.Sf_ID Pointer to '_Bond_annotation_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Bond_annotation_list, 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_annotation.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Entry_ID
Description	NMR-STAR name: _Bond_annotation.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	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_annotation.Bond_annotation_list_ID (BondAnnotationListID)

(go to parent tag category listing)

NMR-STAR tag name	_Bond_annotation.Bond_annotation_list_ID
Description	NMR-STAR name: _Bond_annotation.Bond_annotation_list_ID Pointer to '_Bond_annotation_list.ID'
Database field name	BondAnnotationListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Bond_annotation_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Bond annotation list ID
Examples	?
Help text