NMR-STAR dictionary: detail of SampleComponent table

NMR-STAR dictionary: database table: SampleComponent

Detailed description of the fields

_Sample_component.ID (SampleComponentID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.ID
Description	NMR-STAR name: _Sample_component.ID A value that uniquely identifies each component of the sample in the component list.
Database field name	SampleComponentID
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	Component ID
Examples	?
Help text

_Sample_component.Mol_common_name (MolCommonName)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Mol_common_name
Description	NMR-STAR name: _Sample_component.Mol_common_name Enter the common name for the component of the sample, include the molecules in the study (biopolymers and ligands) as well as buffers, salts, reducing agents, anti-bacterial agents, etc. Common buffers, salts, and other compounds can be selected from the pull down list.
Database field name	MolCommonName
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	Molecule common name
Examples	CheY; DTT; PMSF
Help text

_Sample_component.Isotopic_labeling (IsotopicLabeling)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Isotopic_labeling
Description	NMR-STAR name: _Sample_component.Isotopic_labeling If the molecule was isotopically labeled, provide a description of the labeling using the format recommended by the IUPAC/IUBMB/IUPAB Interunion Task Group. Commonly used labeling patterns are provide in the pull down list in the IUPAC format. If a different labeling pattern was used, please enter the correct value using the examples in the pull down list as a guide to the proper format.
Database field name	IsotopicLabeling
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
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Isotopic labeling
Examples	[U-95% 13C; U-90% 15N]
Help text

_Sample_component.Assembly_ID (AssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Assembly_ID
Description	NMR-STAR name: _Sample_component.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?	no
Prompt	Assembly ID
Examples
Help text

_Sample_component.Assembly_label (AssemblyLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Assembly_label
Description	NMR-STAR name: _Sample_component.Assembly_label Pointer to a saveframe of the category assembly.
Database field name	AssemblyLabel
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Assembly, Sf_framecode
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Assembly label
Examples
Help text

_Sample_component.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Entity_ID
Description	NMR-STAR name: _Sample_component.Entity_ID Pointer to '_Entity.ID'
Database field name	EntityID
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?	no
Prompt	Entity ID
Examples	?
Help text

_Sample_component.Entity_label (EntityLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Entity_label
Description	NMR-STAR name: _Sample_component.Entity_label Pointer to a saveframe of the category entity.
Database field name	EntityLabel
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Entity, Sf_framecode
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entity label
Examples	?
Help text

_Sample_component.Product_ID (ProductID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Product_ID
Description	NMR-STAR name: _Sample_component.Product_ID Not currently modeled. This ID would be a pointer to the categories describing the production and purification of the sample component.
Database field name	ProductID
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	Product ID
Examples	?
Help text

_Sample_component.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Type
Description	NMR-STAR name: _Sample_component.Type Enter the class of molecule ( proteins DNA buffer salt) to which the sample component belongs.
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?	no
Prompt	Sample component type
Examples	protein DNA RNA carbohydrate buffer salt
Help text

_Sample_component.Concentration_val (ConcentrationVal)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Concentration_val
Description	NMR-STAR name: _Sample_component.Concentration_val Enter a value for the concentration of the sample component (units will be entered below). This may be either a single value (prefered, if available), but may also be a range (0.9-1.2), if appropriate.
Database field name	ConcentrationVal
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	Concentration value (or range)
Examples	2 or 0.7-1.2
Help text

_Sample_component.Concentration_val_min (ConcentrationValMin)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Concentration_val_min
Description	NMR-STAR name: _Sample_component.Concentration_val_min If entering a range for the concentration of the component provide the minimal value.
Database field name	ConcentrationValMin
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	Concentration minimum value
Examples	0.5
Help text

_Sample_component.Concentration_val_max (ConcentrationValMax)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Concentration_val_max
Description	NMR-STAR name: _Sample_component.Concentration_val_max If entering a range for the concentration of the sample component provide the maximal value.
Database field name	ConcentrationValMax
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	Concentration maximum value
Examples	3
Help text

_Sample_component.Concentration_val_units (ConcentrationValUnits)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Concentration_val_units
Description	NMR-STAR name: _Sample_component.Concentration_val_units Enter the units appropriate for the concentration value enter earlier for the sample component.
Database field name	ConcentrationValUnits
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
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Concentration value units
Examples	millimolar
Help text

_Sample_component.Concentration_val_err (ConcentrationValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Concentration_val_err
Description	NMR-STAR name: _Sample_component.Concentration_val_err Enter an estimate for the standard error associated with the concentration value of the sample component.
Database field name	ConcentrationValErr
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	Concentration value error
Examples	0.2
Help text

_Sample_component.Vendor (Vendor)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Vendor
Description	NMR-STAR name: _Sample_component.Vendor Enter the name of the vendor for the sample component
Database field name	Vendor
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	Vendor name
Examples	Aldrich
Help text

_Sample_component.Vendor_product_name (VendorProductName)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Vendor_product_name
Description	NMR-STAR name: _Sample_component.Vendor_product_name Enter the product name assigned by the vendor
Database field name	VendorProductName
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	Vendor product name
Examples	sucrose
Help text

_Sample_component.Vendor_product_code (VendorProductCode)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component.Vendor_product_code
Description	NMR-STAR name: _Sample_component.Vendor_product_code Enter the product code assigned by the vendor
Database field name	VendorProductCode
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	Vendor product code
Examples	1456378
Help text

_Sample_component.Sf_ID (SfID)

(go to parent tag category listing)

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

_Sample_component.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Sample_component.Sample_ID (SampleID)

(go to parent tag category listing)

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