NMR-STAR dictionary: detail of BindingResult table

NMR-STAR dictionary: database table: BindingResult

Detailed description of the fields

_Binding_result.ID (BindingResultID)

NMR-STAR tag name	_Binding_result.ID
Description	NMR-STAR name: _Binding_result.ID Unique identifier for the observed binding constant.
Database field name	BindingResultID
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

_Binding_result.Experiment_ID (ExperimentID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Experiment_ID
Description	NMR-STAR name: _Binding_result.Experiment_ID Pointer to '_Experiment.ID'
Database field name	ExperimentID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Experiment, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Experiment ID
Examples	?
Help text

_Binding_result.Assembly_ID (AssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Assembly_ID
Description	NMR-STAR name: _Binding_result.Assembly_ID Pointer to '_Assembly.ID'
Database field name	AssemblyID
SQL Database type	INTEGER
Part of primary Key	no
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

_Binding_result.Atm_obs_assembly_atom_ID (AtmObsAssemblyAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_assembly_atom_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_assembly_atom_ID Pointer to '_Atom.Assembly_atom_ID'
Database field name	AtmObsAssemblyAtomID
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	Atm obs assembly atom ID
Examples	?
Help text

_Binding_result.Atm_obs_entity_assembly_ID (AtmObsEntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_entity_assembly_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_entity_assembly_ID Pointer to '_Entity_assembly.ID'
Database field name	AtmObsEntityAssemblyID
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	Atm obs entity assembly ID
Examples	?
Help text

_Binding_result.Atm_obs_entity_ID (AtmObsEntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_entity_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_entity_ID Pointer to '_Entity.ID'
Database field name	AtmObsEntityID
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	Atm obs entity ID
Examples	?
Help text

_Binding_result.Atm_obs_comp_index_ID (AtmObsCompIndexID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_comp_index_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_comp_index_ID Pointer to '_Entity_comp_index.ID'
Database field name	AtmObsCompIndexID
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	Atm obs comp index ID
Examples	?
Help text

_Binding_result.Atm_obs_seq_ID (AtmObsSeqID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_seq_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_seq_ID Pointer to '_Entity_poly_seq.Num'
Database field name	AtmObsSeqID
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	Atm obs seq ID
Examples	?
Help text

_Binding_result.Atm_obs_comp_ID (AtmObsCompID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_comp_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_comp_ID Pointer to '_Chem_comp.ID'
Database field name	AtmObsCompID
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	Atm obs comp ID
Examples	?
Help text

_Binding_result.Atm_obs_atom_ID (AtmObsAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_atom_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_atom_ID Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtmObsAtomID
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	Atm obs atom ID
Examples	?
Help text

_Binding_result.Atm_obs_atom_type (AtmObsAtomType)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_atom_type
Description	NMR-STAR name: _Binding_result.Atm_obs_atom_type Standard symbol used to define the atom element type.
Database field name	AtmObsAtomType
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	Atm obs atom type
Examples	?
Help text

_Binding_result.Atm_obs_atom_isotope_number (AtmObsAtomIsotopeNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_atom_isotope_number
Description	NMR-STAR name: _Binding_result.Atm_obs_atom_isotope_number ?
Database field name	AtmObsAtomIsotopeNumber
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	Atm obs atom isotope number
Examples	?
Help text

_Binding_result.Resonance_ID (ResonanceID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Resonance_ID
Description	NMR-STAR name: _Binding_result.Resonance_ID Pointer to '_Resonance.ID'
Database field name	ResonanceID
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
Examples	?
Help text

_Binding_result.Atm_obs_auth_entity_assembly_ID (AtmObsAuthEntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_auth_entity_assembly_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_auth_entity_assembly_ID ?
Database field name	AtmObsAuthEntityAssemblyID
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	Atm obs auth entity assembly ID
Examples	?
Help text

_Binding_result.Atm_obs_auth_seq_ID (AtmObsAuthSeqID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_auth_seq_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_auth_seq_ID 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	AtmObsAuthSeqID
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	Atm obs auth seq ID
Examples	-3
Help text

_Binding_result.Atm_obs_auth_comp_ID (AtmObsAuthCompID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_auth_comp_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_auth_comp_ID 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	AtmObsAuthCompID
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	Atm obs auth comp ID
Examples	DPN
Help text

_Binding_result.Atm_obs_auth_atom_ID (AtmObsAuthAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Atm_obs_auth_atom_ID
Description	NMR-STAR name: _Binding_result.Atm_obs_auth_atom_ID 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	AtmObsAuthAtomID
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	Atm obs auth atom ID
Examples	HB1
Help text

_Binding_result.Expt_observed_param (ExptObservedParam)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Expt_observed_param
Description	NMR-STAR name: _Binding_result.Expt_observed_param ?
Database field name	ExptObservedParam
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?	no
Prompt	Expt observed param
Examples	?
Help text

_Binding_result.Val_type (ValType)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Val_type
Description	NMR-STAR name: _Binding_result.Val_type ?
Database field name	ValType
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?	no
Prompt	Val type
Examples	?
Help text

_Binding_result.Val (Val)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Val
Description	NMR-STAR name: _Binding_result.Val Binding value estimated from a fit of a binding titration data set.
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?	no
Prompt	Val
Examples	?
Help text

_Binding_result.Val_err (ValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Val_err
Description	NMR-STAR name: _Binding_result.Val_err Estimated error in the binding constant.
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

_Binding_result.Val_units (ValUnits)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Val_units
Description	NMR-STAR name: _Binding_result.Val_units ?
Database field name	ValUnits
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	Val units
Examples	?
Help text

_Binding_result.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Sf_ID
Description	NMR-STAR name: _Binding_result.Sf_ID Pointer to '_Binding_value_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Binding_value_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

_Binding_result.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Entry_ID
Description	NMR-STAR name: _Binding_result.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

_Binding_result.Binding_value_list_ID (BindingValueListID)

(go to parent tag category listing)

NMR-STAR tag name	_Binding_result.Binding_value_list_ID
Description	NMR-STAR name: _Binding_result.Binding_value_list_ID Pointer to '_Binding_value_list.ID'
Database field name	BindingValueListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Binding_value_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Binding value list ID
Examples	?
Help text