NMR-STAR dictionary: detail of NMRSpecExpt table

NMR-STAR dictionary: database table: NMRSpecExpt

Detailed description of the fields

_NMR_spec_expt.Sf_category (SfCategory)

NMR-STAR tag name	_NMR_spec_expt.Sf_category
Description	NMR-STAR name: _NMR_spec_expt.Sf_category Category assigned to the information in the saveframe.
Database field name	SfCategory
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
Prompt	Sf category
Examples	?
Help text

_NMR_spec_expt.Sf_framecode (SfFramecode)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Sf_framecode
Description	NMR-STAR name: _NMR_spec_expt.Sf_framecode Descriptive label used to uniquely identify the NMR experiment and its parameters.
Database field name	SfFramecode
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
Prompt	NMR experiment label (name)
Examples	?
Help text

_NMR_spec_expt.Entry_ID (EntryID)

(go to parent tag category listing)

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

_NMR_spec_expt.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Sf_ID
Description	NMR-STAR name: _NMR_spec_expt.Sf_ID An integer value that is the unique identifier for the saveframe that applies across the archive. This value is not stable and may be reassigned each time the data are loaded into a database system.
Database field name	SfID
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	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

_NMR_spec_expt.ID (NMRSpecExptID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.ID
Description	NMR-STAR name: _NMR_spec_expt.ID A value that uniquely identifies the NMR experiment from other NMR experiments listed in the entry.
Database field name	NMRSpecExptID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Experiment ID
Examples	?
Help text

_NMR_spec_expt.Name (Name)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Name
Description	NMR-STAR name: _NMR_spec_expt.Name A commonly used name for the NMR experiment found in the literature.
Database field name	Name
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	NMR experiment name
Examples	HNCO; 1H15N HSQC
Help text

_NMR_spec_expt.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Type
Description	NMR-STAR name: _NMR_spec_expt.Type The type of NMR experiment.
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
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Experiment type
Examples	?
Help text

_NMR_spec_expt.Sample_volume (SampleVolume)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Sample_volume
Description	NMR-STAR name: _NMR_spec_expt.Sample_volume Volume of the sample during data collection
Database field name	SampleVolume
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	Sample volume
Examples	300
Help text

_NMR_spec_expt.Sample_volume_units (SampleVolumeUnits)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Sample_volume_units
Description	NMR-STAR name: _NMR_spec_expt.Sample_volume_units Provide the units appropriate for the sample volume.
Database field name	SampleVolumeUnits
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
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Units for the sample volume
Examples	uL
Help text

_NMR_spec_expt.NMR_tube_type (NMRTubeType)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.NMR_tube_type
Description	NMR-STAR name: _NMR_spec_expt.NMR_tube_type Type of NMR tube used to contain the sample during data acquisition.
Database field name	NMRTubeType
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	NMR tube type
Examples	standard
Help text

_NMR_spec_expt.Sample_spinning_rate (SampleSpinningRate)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Sample_spinning_rate
Description	NMR-STAR name: _NMR_spec_expt.Sample_spinning_rate The spinning rate of the sample during data collection (in Hz).
Database field name	SampleSpinningRate
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	Sample spinning rate
Examples	20
Help text

_NMR_spec_expt.Sample_angle (SampleAngle)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Sample_angle
Description	NMR-STAR name: _NMR_spec_expt.Sample_angle The angle of the sample relative to the external magnetic field.
Database field name	SampleAngle
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	Sample spinning angle
Examples	54 degrees
Help text

_NMR_spec_expt.NMR_spectrometer_ID (NMRSpectrometerID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.NMR_spectrometer_ID
Description	NMR-STAR name: _NMR_spec_expt.NMR_spectrometer_ID Pointer to '_NMR_spectrometer.ID'
Database field name	NMRSpectrometerID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	NMR_spectrometer, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	NMR spectrometer ID
Examples	?
Help text

_NMR_spec_expt.NMR_spectrometer_label (NMRSpectrometerLabel)

(go to parent tag category listing)

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

_NMR_spec_expt.NMR_spectrometer_probe_ID (NMRSpectrometerProbeID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.NMR_spectrometer_probe_ID
Description	NMR-STAR name: _NMR_spec_expt.NMR_spectrometer_probe_ID Pointer to '_NMR_spectrometer_probe.ID'
Database field name	NMRSpectrometerProbeID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	NMR_spectrometer_probe, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	NMR spectrometer probe ID
Examples	?
Help text

_NMR_spec_expt.NMR_spectrometer_probe_label (NMRSpectrometerProbeLabel)

(go to parent tag category listing)

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

_NMR_spec_expt.Carrier_freq_switch_time (CarrierFreqSwitchTime)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Carrier_freq_switch_time
Description	NMR-STAR name: _NMR_spec_expt.Carrier_freq_switch_time The time required to switch between carrier frequencies.
Database field name	CarrierFreqSwitchTime
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	Carrier freq switch time
Examples	?
Help text

_NMR_spec_expt.Software_ID (SoftwareID)

(go to parent tag category listing)

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

_NMR_spec_expt.Software_label (SoftwareLabel)

(go to parent tag category listing)

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

_NMR_spec_expt.Method_ID (MethodID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Method_ID
Description	NMR-STAR name: _NMR_spec_expt.Method_ID Pointer to '_Method.ID'
Database field name	MethodID
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	Method ID
Examples	?
Help text

_NMR_spec_expt.Method_label (MethodLabel)

(go to parent tag category listing)

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

_NMR_spec_expt.Pulse_seq_accession_BMRB_code (PulseSeqAccessionBMRBCode)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Pulse_seq_accession_BMRB_code
Description	NMR-STAR name: _NMR_spec_expt.Pulse_seq_accession_BMRB_code An accession code assigned by BMRB that uniquely identifies the NMR experiment pulse sequence within the BMRB pulse sequence library.
Database field name	PulseSeqAccessionBMRBCode
SQL Database type	CHAR(12)
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	BMRB pulse seq accession code
Examples	?
Help text

_NMR_spec_expt.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spec_expt.Details
Description	NMR-STAR name: _NMR_spec_expt.Details Summarize and provide details on what type of spectrometer was used, magnetic field, how the data were recorded, and the information obtained from the data.
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