NMR-STAR dictionary: database table: Assembly

Detailed description of the fields

_Assembly.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Sf_category 
DescriptionNMR-STAR name: _Assembly.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 

_Assembly.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Sf_framecode 
DescriptionNMR-STAR name: _Assembly.Sf_framecode
A descriptive label for the molecular assembly studied.  
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 
PromptMolecular assembly label  
Examples
Help text 

_Assembly.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Entry_ID 
DescriptionNMR-STAR name: _Assembly.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 

_Assembly.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Sf_ID 
DescriptionNMR-STAR name: _Assembly.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 

_Assembly.ID (AssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.ID 
DescriptionNMR-STAR name: _Assembly.ID
A code that uniquely identifies the molecular assembly described in the saveframe.  
Database field nameAssemblyID 
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 
PromptMolecular assembly identifier  
Examples
Help text 

_Assembly.Name (Name)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Name 
DescriptionNMR-STAR name: _Assembly.Name
Brief descriptive name for the molecular assembly studied.  
Database field nameName 
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 
PromptMolecular assembly name  
Examples'p53 tetramer'  
Help text 

_Assembly.BMRB_code (BMRBCode)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.BMRB_code 
DescriptionNMR-STAR name: _Assembly.BMRB_code
Unique identifier for the molecular system in the BMRB library of molecular system definitions.  
Database field nameBMRBCode 
SQL Database typeCHAR(12) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptBMRB ID  
Examples
Help text 

_Assembly.Number_of_components (NumberOfComponents)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Number_of_components 
DescriptionNMR-STAR name: _Assembly.Number_of_components
Enter the total number of molecular components (biopolymers and ligands) that comprise the molecular system.  
Database field nameNumberOfComponents 
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 
PromptTotal number of biopolymers and ligands  
Examples4  
Help text 

_Assembly.Organic_ligands (OrganicLigands)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Organic_ligands 
DescriptionNMR-STAR name: _Assembly.Organic_ligands
Enter the total number of organic ligands known to exist in the full molecular system.  
Database field nameOrganicLigands 
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 
PromptNumber of organic ligands present  
Examples1  
Help text 

_Assembly.Metal_ions (MetalIons)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Metal_ions 
DescriptionNMR-STAR name: _Assembly.Metal_ions
Enter the total number of metal ions known to exist in the molecular system  
Database field nameMetalIons 
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 
PromptNumber of metal ions present  
Examples1  
Help text 

_Assembly.Non_standard_bonds (NonStandardBonds)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Non_standard_bonds 
DescriptionNMR-STAR name: _Assembly.Non_standard_bonds
Select 'yes', if the molecular assembly contains covalent bonds such as cross-linking disulfide bonds, non-standard residue-residue bonds, ligand-residue bonds, or metal coordination bonds, etc.  
Database field nameNonStandardBonds 
SQL Database typeVARCHAR(3) 
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 a closed enumeration. The list of values are the only ones allowed. 
PromptAre there cross-linking or other intermolecular bonds in the system  
Examplesyes  
Help text 

_Assembly.Ambiguous_conformational_states (AmbiguousConformationalStates)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Ambiguous_conformational_states 
DescriptionNMR-STAR name: _Assembly.Ambiguous_conformational_states
Answer 'yes', if the molecule contains multiple conformational states (e.g., cis/trans isomerization at one or more proline residues or ligands undergoing conformational equilibria).  
Database field nameAmbiguousConformationalStates 
SQL Database typeVARCHAR(3) 
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 a closed enumeration. The list of values are the only ones allowed. 
PromptAre there ambiguous conformational states in the biopolymers or ligands  
Examplesyes  
Help text 

_Assembly.Ambiguous_chem_comp_sites (AmbiguousChemCompSites)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Ambiguous_chem_comp_sites 
DescriptionNMR-STAR name: _Assembly.Ambiguous_chem_comp_sites
Answer this question yes, if the residue sequence for any of the biopolymers in the molecular system has sites known to be occupied by more than one residue type (e.g., position 12 in a protein is in some cases a serine and other cases a threonine).  
Database field nameAmbiguousChemCompSites 
SQL Database typeVARCHAR(3) 
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 a closed enumeration. The list of values are the only ones allowed. 
PromptDo ambiguous residue sites exist in any biopolymer  
Examplesyes  
Help text 

_Assembly.Molecules_in_chemical_exchange (MoleculesInChemicalExchange)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Molecules_in_chemical_exchange 
DescriptionNMR-STAR name: _Assembly.Molecules_in_chemical_exchange
Select 'yes', if two molecular components in the system are in chemical exchange (e.g., a ligand exists in both the free and bound state).  
Database field nameMoleculesInChemicalExchange 
SQL Database typeVARCHAR(3) 
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 a closed enumeration. The list of values are the only ones allowed. 
PromptAre the polymers or ligands in chemical exchange  
Examplesyes  
Help text 

_Assembly.Paramagnetic (Paramagnetic)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Paramagnetic 
DescriptionNMR-STAR name: _Assembly.Paramagnetic
Select 'yes', if the molecular system contains a paramagnetic metal ion, organic ligand, or residue with an unpaired electron.  
Database field nameParamagnetic 
SQL Database typeVARCHAR(3) 
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 a closed enumeration. The list of values are the only ones allowed. 
PromptIs the system paramagnetic  
Examplesyes  
Help text 

_Assembly.Thiol_state (ThiolState)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Thiol_state 
DescriptionNMR-STAR name: _Assembly.Thiol_state
Please select the item that best describes the overal status of the thiol groups in the molecular system.  
Database field nameThiolState 
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. 
PromptMolecular assembly thiol state  
Examplesall disulfide bound  
Help text 

_Assembly.Molecular_mass (MolecularMass)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Molecular_mass 
DescriptionNMR-STAR name: _Assembly.Molecular_mass
Mass of the molecular system in Daltons. This value may be approximate.  
Database field nameMolecularMass 
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 
PromptMolecular mass  
Examples17600  
Help text 

_Assembly.Enzyme_commission_number (EnzymeCommissionNumber)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Enzyme_commission_number 
DescriptionNMR-STAR name: _Assembly.Enzyme_commission_number
If available, enter the Enzyme Commission decimal code (3.4.2.3.1) assigned to the protein or molecular assembly.  
Database field nameEnzymeCommissionNumber 
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 
PromptEnzyme commission number  
Examples2.1.5.8.2  
Help text 

_Assembly.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.Details 
DescriptionNMR-STAR name: _Assembly.Details
Text description for the molecular system studied.  
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 
PromptMolecular assembly description  
Examples
Help text 

_Assembly.DB_query_date (DBQueryDate)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.DB_query_date 
DescriptionNMR-STAR name: _Assembly.DB_query_date
Date the database was queried to derive links to the molecular assembly studied. GenBank is the database queried for these links.  
Database field nameDBQueryDate 
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 
PromptDB query date  
Examples
Help text 

_Assembly.DB_query_revised_last_date (DBQueryRevisedLastDate)

(go to parent tag category listing)
NMR-STAR tag name_Assembly.DB_query_revised_last_date 
DescriptionNMR-STAR name: _Assembly.DB_query_revised_last_date
The last date when new links to the molecular assembly were found through the database query.  
Database field nameDBQueryRevisedLastDate 
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 
PromptDB query revised last date  
Examples
Help text