NMR-STAR dictionary: database table: Sample

Detailed description of the fields

_Sample.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Sf_category 
DescriptionNMR-STAR name: _Sample.Sf_category
Category assigned to the information in the saveframe.  
Database field nameSfCategory 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSf category  
Examples
Help text 

_Sample.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Sf_framecode 
DescriptionNMR-STAR name: _Sample.Sf_framecode
Provide a name for the sample that uniquely identifies this sample from the other samples listed in the entry.  
Database field nameSfFramecode 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSample label  
Examples
Help text 

_Sample.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Entry_ID 
DescriptionNMR-STAR name: _Sample.Entry_ID
Pointer to '_Entry.ID'  
Database field nameEntryID 
SQL Database typeCHAR(12) 
Part of primary Keyyes 
Foreign Key on table, columnEntry, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptEntry ID  
Examples
Help text 

_Sample.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Sf_ID 
DescriptionNMR-STAR name: _Sample.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 nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagyes
This field's data is for internal use only and should be hidden in public versiond of the data. 
Nulls allowed in database?yes 
PromptSf ID  
Examples
Help text 

_Sample.ID (SampleID)

(go to parent tag category listing)
NMR-STAR tag name_Sample.ID 
DescriptionNMR-STAR name: _Sample.ID
A value that uniquely identifies the sample described from the other samples listed in the entry.  
Database field nameSampleID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptID  
Examples
Help text 

_Sample.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Type 
DescriptionNMR-STAR name: _Sample.Type
Please select a descriptive term for the sample that defines the general physical properties of the sample.  
Database field nameType 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
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. 
PromptSample type  
Examplessolution  
Help text 

_Sample.Sub_type (SubType)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Sub_type 
DescriptionNMR-STAR name: _Sample.Sub_type
Solid and solution NMR samples of different types are often used. Please select the specific type of sample used.  
Database field nameSubType 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptSub type  
Examplespolycrystalline  
Help text 

_Sample.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Details 
DescriptionNMR-STAR name: _Sample.Details
A more detailed description of the sample may be provided. Any atypical components, conditions, or handling procedures may be noted and their importance discussed.  
Database field nameDetails 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptSample details  
ExamplesThe added glycerol was used to raise the viscosity of the solution to 1.05 poisson.  
Help text 

_Sample.Aggregate_sample_number (AggregateSampleNumber)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Aggregate_sample_number 
DescriptionNMR-STAR name: _Sample.Aggregate_sample_number
Enter the total number of samples represented by the concentration value (range) reported. Often more than one 15N or 13C;15N labeled sample is required to collect all of the data required to assign the spectra of a protein or nucleic acid. If this is the case for the study reported in this deposition, the total number of samples used matching the contents and concentrations supplied can be entered in this field.  
Database field nameAggregateSampleNumber 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAggregate sample number  
Examples3  
Help text 

_Sample.Solvent_system (SolventSystem)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Solvent_system 
DescriptionNMR-STAR name: _Sample.Solvent_system
The solvent components of the sample are entered in this field.  
Database field nameSolventSystem 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
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. 
PromptSolvent system  
Examples95% H2O/5% D2O  
Help text 

_Sample.Preparation_date (PreparationDate)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Preparation_date 
DescriptionNMR-STAR name: _Sample.Preparation_date
Date the sample was prepared.  
Database field namePreparationDate 
SQL Database typeDATETIME year to day 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPreparation date  
Examples
Help text 

_Sample.Preparation_expiration_date (PreparationExpirationDate)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Preparation_expiration_date 
DescriptionNMR-STAR name: _Sample.Preparation_expiration_date
Date after which the sample should not be used.  
Database field namePreparationExpirationDate 
SQL Database typeDATETIME year to day 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPreparation expiration date  
Examples
Help text 

_Sample.Polycrystallization_protocol (PolycrystallizationProtocol)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Polycrystallization_protocol 
DescriptionNMR-STAR name: _Sample.Polycrystallization_protocol
Protocol used for preparing polycrystalline samples.  
Database field namePolycrystallizationProtocol 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPreparation protocol  
Examples
Help text 

_Sample.Single_crystal_protocol (SingleCrystalProtocol)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Single_crystal_protocol 
DescriptionNMR-STAR name: _Sample.Single_crystal_protocol
Text protocol used to prepare single crystals.  
Database field nameSingleCrystalProtocol 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptSingle crystal protocol  
Examples
Help text 

_Sample.Crystal_grow_apparatus (CrystalGrowApparatus)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_apparatus 
DescriptionNMR-STAR name: _Sample.Crystal_grow_apparatus
Apparatus used to grow the crystals  
Database field nameCrystalGrowApparatus 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow apparatus  
Examples
Help text 

_Sample.Crystal_grow_atmosphere (CrystalGrowAtmosphere)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_atmosphere 
DescriptionNMR-STAR name: _Sample.Crystal_grow_atmosphere
Atmosphere used to grow the crystals.  
Database field nameCrystalGrowAtmosphere 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow atmosphere  
Examples
Help text 

_Sample.Crystal_grow_details (CrystalGrowDetails)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_details 
DescriptionNMR-STAR name: _Sample.Crystal_grow_details
Text providing additional information regarding the methods used to grow crystals.  
Database field nameCrystalGrowDetails 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow details  
Examples
Help text 

_Sample.Crystal_grow_method (CrystalGrowMethod)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_method 
DescriptionNMR-STAR name: _Sample.Crystal_grow_method
Name for the method used to grow the crystals.  
Database field nameCrystalGrowMethod 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow method  
Examples
Help text 

_Sample.Crystal_grow_method_cit_ID (CrystalGrowMethodCitID)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_method_cit_ID 
DescriptionNMR-STAR name: _Sample.Crystal_grow_method_cit_ID
Pointer to '_Citation.ID' The citation referenced provides a description of the method used to grow the crystals.  
Database field nameCrystalGrowMethodCitID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnCitation, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow method cit ID  
Examples
Help text 

_Sample.Crystal_grow_pH (CrystalGrowPH)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_pH 
DescriptionNMR-STAR name: _Sample.Crystal_grow_pH
The pH used to grow the crystals, if a specific value was used.  
Database field nameCrystalGrowPH 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow pH  
Examples
Help text 

_Sample.Crystal_grow_pH_range (CrystalGrowPHRange)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_pH_range 
DescriptionNMR-STAR name: _Sample.Crystal_grow_pH_range
The pH range over which the crystals were grown, where a single pH value was not used or known.  
Database field nameCrystalGrowPHRange 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow pH range  
Examples
Help text 

_Sample.Crystal_grow_pressure (CrystalGrowPressure)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_pressure 
DescriptionNMR-STAR name: _Sample.Crystal_grow_pressure
Pressure under which the crystals were grown.  
Database field nameCrystalGrowPressure 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow pressure  
Examplesambient  
Help text 

_Sample.Crystal_grow_pressure_esd (CrystalGrowPressureEsd)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_pressure_esd 
DescriptionNMR-STAR name: _Sample.Crystal_grow_pressure_esd
Estemated error in the pressure value used to grow the crystals.  
Database field nameCrystalGrowPressureEsd 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow pressure esd  
Examples
Help text 

_Sample.Crystal_grow_seeding (CrystalGrowSeeding)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_seeding 
DescriptionNMR-STAR name: _Sample.Crystal_grow_seeding
Code defining the type of seeding used to initiate the growth of the crystals.  
Database field nameCrystalGrowSeeding 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow seeding  
Examples
Help text 

_Sample.Crystal_grow_seeding_cit_ID (CrystalGrowSeedingCitID)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_seeding_cit_ID 
DescriptionNMR-STAR name: _Sample.Crystal_grow_seeding_cit_ID
Pointer to '_Citation.ID' The citation referenced provides a description of the method used to seed the crystallization.  
Database field nameCrystalGrowSeedingCitID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnCitation, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow seeding cit ID  
Examples
Help text 

_Sample.Crystal_grow_temp (CrystalGrowTemp)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_temp 
DescriptionNMR-STAR name: _Sample.Crystal_grow_temp
Temperature used to grw the crystals.  
Database field nameCrystalGrowTemp 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow temp  
Examples
Help text 

_Sample.Crystal_grow_temp_details (CrystalGrowTempDetails)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_temp_details 
DescriptionNMR-STAR name: _Sample.Crystal_grow_temp_details
Text providing additional information regarding the temperature used to grow the crystals.  
Database field nameCrystalGrowTempDetails 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow temp details  
Examples
Help text 

_Sample.Crystal_grow_temp_esd (CrystalGrowTempEsd)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_temp_esd 
DescriptionNMR-STAR name: _Sample.Crystal_grow_temp_esd
Estimated error in the reported temperature value used to grow the crystals.  
Database field nameCrystalGrowTempEsd 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow temp esd  
Examples
Help text 

_Sample.Crystal_grow_time (CrystalGrowTime)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Crystal_grow_time 
DescriptionNMR-STAR name: _Sample.Crystal_grow_time
The time required to grow the crystals.  
Database field nameCrystalGrowTime 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptCrystal grow time  
Examples
Help text 

_Sample.Oriented_sample_prep_protocol (OrientedSamplePrepProtocol)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Oriented_sample_prep_protocol 
DescriptionNMR-STAR name: _Sample.Oriented_sample_prep_protocol
Protocol used to prepare oriented crystal samples.  
Database field nameOrientedSamplePrepProtocol 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptOriented sample prep protocol  
Examples
Help text 

_Sample.Lyophilization_cryo_protectant (LyophilizationCryoProtectant)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Lyophilization_cryo_protectant 
DescriptionNMR-STAR name: _Sample.Lyophilization_cryo_protectant
Chemical used to protect the sample during lyophilization.  
Database field nameLyophilizationCryoProtectant 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptLyophilization cryo protectant  
Examples
Help text 

_Sample.Storage_protocol (StorageProtocol)

(go to parent tag category listing)
NMR-STAR tag name_Sample.Storage_protocol 
DescriptionNMR-STAR name: _Sample.Storage_protocol
Protocol used for storing the sample.  
Database field nameStorageProtocol 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptStorage protocol  
Examples
Help text