NMR-STAR dictionary: detail of HeteronuclNOE table

NMR-STAR dictionary: database table: HeteronuclNOE

Detailed description of the fields

_Heteronucl_NOE.ID (HeteronuclNOEID)

NMR-STAR tag name	_Heteronucl_NOE.ID
Description	NMR-STAR name: _Heteronucl_NOE.ID Unique identifier for the reported heteronuclear NOE value in this set of heteronuclear NOE values.
Database field name	HeteronuclNOEID
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	1
Help text

_Heteronucl_NOE.Assembly_atom_ID_1 (AssemblyAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Assembly_atom_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	264
Help text

_Heteronucl_NOE.Entity_assembly_ID_1 (EntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Entity_assembly_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	1
Help text

_Heteronucl_NOE.Entity_ID_1 (EntityID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Entity_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	1
Help text

_Heteronucl_NOE.Comp_index_ID_1 (CompIndexID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Comp_index_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	5
Help text

_Heteronucl_NOE.Seq_ID_1 (SeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Seq_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	5
Help text

_Heteronucl_NOE.Comp_ID_1 (CompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Comp_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	LYS
Help text

_Heteronucl_NOE.Atom_ID_1 (AtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Atom_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	N
Help text

_Heteronucl_NOE.Atom_type_1 (AtomType1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Atom_type_1
Description	NMR-STAR name: _Heteronucl_NOE.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	N
Help text

_Heteronucl_NOE.Atom_isotope_number_1 (AtomIsotopeNumber1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Atom_isotope_number_1
Description	NMR-STAR name: _Heteronucl_NOE.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

_Heteronucl_NOE.Assembly_atom_ID_2 (AssemblyAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Assembly_atom_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	265
Help text

_Heteronucl_NOE.Entity_assembly_ID_2 (EntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Entity_assembly_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	1
Help text

_Heteronucl_NOE.Entity_ID_2 (EntityID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Entity_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	1
Help text

_Heteronucl_NOE.Comp_index_ID_2 (CompIndexID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Comp_index_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	5
Help text

_Heteronucl_NOE.Seq_ID_2 (SeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Seq_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	5
Help text

_Heteronucl_NOE.Comp_ID_2 (CompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Comp_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	LYS
Help text

_Heteronucl_NOE.Atom_ID_2 (AtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Atom_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	H
Help text

_Heteronucl_NOE.Atom_type_2 (AtomType2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Atom_type_2
Description	NMR-STAR name: _Heteronucl_NOE.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	H
Help text

_Heteronucl_NOE.Atom_isotope_number_2 (AtomIsotopeNumber2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Atom_isotope_number_2
Description	NMR-STAR name: _Heteronucl_NOE.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

_Heteronucl_NOE.Val (Val)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Val
Description	NMR-STAR name: _Heteronucl_NOE.Val Heteronuclear NOE value
Database field name	Val
SQL Database type	FLOAT
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	Val
Examples	?
Help text

_Heteronucl_NOE.Val_err (ValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Val_err
Description	NMR-STAR name: _Heteronucl_NOE.Val_err Estimated error in the heteronuclear NOE value
Database field name	ValErr
SQL Database type	FLOAT
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	Val err
Examples	?
Help text

_Heteronucl_NOE.Resonance_ID_1 (ResonanceID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Resonance_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.Resonance_ID_1 Pointer to '_Resonance.ID'
Database field name	ResonanceID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Resonance, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Resonance ID 1
Examples	?
Help text

_Heteronucl_NOE.Resonance_ID_2 (ResonanceID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Resonance_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.Resonance_ID_2 Pointer to '_Resonance.ID'
Database field name	ResonanceID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Resonance, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Resonance ID 2
Examples	?
Help text

_Heteronucl_NOE.Auth_entity_assembly_ID_1 (AuthEntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Auth_entity_assembly_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.Auth_entity_assembly_ID_1 ?
Database field name	AuthEntityAssemblyID1
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 entity assembly ID 1
Examples	?
Help text

_Heteronucl_NOE.Auth_seq_ID_1 (AuthSeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Auth_seq_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	265
Help text

_Heteronucl_NOE.Auth_comp_ID_1 (AuthCompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Auth_comp_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	LYS
Help text

_Heteronucl_NOE.Auth_atom_ID_1 (AuthAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Auth_atom_ID_1
Description	NMR-STAR name: _Heteronucl_NOE.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	N
Help text

_Heteronucl_NOE.Auth_entity_assembly_ID_2 (AuthEntityAssemblyID2)

(go to parent tag category listing)

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

_Heteronucl_NOE.Auth_seq_ID_2 (AuthSeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Auth_seq_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	265
Help text

_Heteronucl_NOE.Auth_comp_ID_2 (AuthCompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Auth_comp_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	LYS
Help text

_Heteronucl_NOE.Auth_atom_ID_2 (AuthAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Auth_atom_ID_2
Description	NMR-STAR name: _Heteronucl_NOE.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	HN
Help text

_Heteronucl_NOE.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Sf_ID
Description	NMR-STAR name: _Heteronucl_NOE.Sf_ID Pointer to '_Heteronucl_NOE_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Heteronucl_NOE_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	1
Help text

_Heteronucl_NOE.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Entry_ID
Description	NMR-STAR name: _Heteronucl_NOE.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	3456
Help text

_Heteronucl_NOE.Heteronucl_NOE_list_ID (HeteronuclNOEListID)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE.Heteronucl_NOE_list_ID
Description	NMR-STAR name: _Heteronucl_NOE.Heteronucl_NOE_list_ID Pointer to '_Heteronucl_NOE_list.ID'
Database field name	HeteronuclNOEListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Heteronucl_NOE_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Heteronucl NOE list ID
Examples	1
Help text