NMR-STAR dictionary: database table: Atom

Detailed description of the fields

_Atom.Assembly_atom_ID (AssemblyAtomID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Assembly_atom_ID 
DescriptionNMR-STAR name: _Atom.Assembly_atom_ID
A value that uniquely identifies the atom from all other atoms in the molecular assembly.  
Database field nameAssemblyAtomID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID yes: This tag contains the identifier for this saveframe in the entry. 
Row Indexyes: 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 Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAssembly atom ID  
Examples
Help text 

_Atom.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Entity_assembly_ID 
DescriptionNMR-STAR name: _Atom.Entity_assembly_ID
Pointer to '_Entity_assembly.ID'  
Database field nameEntityAssemblyID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_assembly, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptEntity assembly ID  
Examples
Help text 

_Atom.Entity_ID (EntityID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Entity_ID 
DescriptionNMR-STAR name: _Atom.Entity_ID
Pointer to '_Entity.ID'  
Database field nameEntityID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptEntity ID  
Examples
Help text 

_Atom.Comp_index_ID (CompIndexID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Comp_index_ID 
DescriptionNMR-STAR name: _Atom.Comp_index_ID
Pointer to '_Entity_comp_index.ID'  
Database field nameCompIndexID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_comp_index, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptComp index ID  
Examples
Help text 

_Atom.Seq_ID (SeqID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Seq_ID 
DescriptionNMR-STAR name: _Atom.Seq_ID
Pointer to '_PDBX_poly_seq_scheme.Seq_ID'  
Database field nameSeqID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_poly_seq, Num 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSeq ID  
Examples
Help text 

_Atom.Comp_ID (CompID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Comp_ID 
DescriptionNMR-STAR name: _Atom.Comp_ID
Pointer to '_Chem_comp.ID'  
Database field nameCompID 
SQL Database typeCHAR(12) 
Part of primary Keyno 
Foreign Key on table, columnChem_comp, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptComp ID  
Examples
Help text 

_Atom.Atom_type_ID (AtomTypeID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Atom_type_ID 
DescriptionNMR-STAR name: _Atom.Atom_type_ID
Pointer to '_Atom_type.ID'  
Database field nameAtomTypeID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAtom_type, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAtom type ID  
Examples
Help text 

_Atom.Atom_ID (AtomID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Atom_ID 
DescriptionNMR-STAR name: _Atom.Atom_ID
The value of _Atom.Atom_id must uniquely identify a record in the atom list.  
Database field nameAtomID 
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?yes 
PromptAtom ID  
Examples
Help text 

_Atom.Type_symbol (TypeSymbol)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Type_symbol 
DescriptionNMR-STAR name: _Atom.Type_symbol
The code used to identify the atom specie(s) representing this atom type. Normally this code is the element symbol. The code may be composed of any character except an underline with the additional proviso that digits designate an oxidation state and must be followed by a + or - character.  
Database field nameTypeSymbol 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptType symbol  
Examples
Help text 

_Atom.PDB_one_letter_code (PDBOneLetterCode)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_one_letter_code 
DescriptionNMR-STAR name: _Atom.PDB_one_letter_code
One-letter code used by the PDB for amino acids and nucleic acids.  
Database field namePDBOneLetterCode 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB one letter code  
Examples
Help text 

_Atom.PDB_strand_ID (PDBStrandID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_strand_ID 
DescriptionNMR-STAR name: _Atom.PDB_strand_ID
PDB strand/chain id.  
Database field namePDBStrandID 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB strand ID  
Examples
Help text 

_Atom.PDB_ins_code (PDBInsCode)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_ins_code 
DescriptionNMR-STAR name: _Atom.PDB_ins_code
PDB insertion code.  
Database field namePDBInsCode 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB ins code  
Examples
Help text 

_Atom.PDB_asym_ID (PDBAsymID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_asym_ID 
DescriptionNMR-STAR name: _Atom.PDB_asym_ID
Pointer to _Atom_site.PDBX_label_asym_id'.  
Database field namePDBAsymID 
SQL Database typeCHAR(12) 
Part of primary Keyno 
Foreign Key on table, columnAtom_site, PDBX_label_asym_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB asym ID  
Examples
Help text 

_Atom.PDB_seq_ID (PDBSeqID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_seq_ID 
DescriptionNMR-STAR name: _Atom.PDB_seq_ID
Pointer to '_PDBX_poly_seq_scheme.Seq_ID'  
Database field namePDBSeqID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_poly_seq, Num 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB seq ID  
Examples
Help text 

_Atom.PDB_comp_ID (PDBCompID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_comp_ID 
DescriptionNMR-STAR name: _Atom.PDB_comp_ID
Pointer to '_Chem_comp.ID'  
Database field namePDBCompID 
SQL Database typeCHAR(12) 
Part of primary Keyno 
Foreign Key on table, columnChem_comp, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB comp ID  
Examples
Help text 

_Atom.PDB_group (PDBGroup)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_group 
DescriptionNMR-STAR name: _Atom.PDB_group
The group of atoms to which the atom site belongs. This data item is provided for compatibility with the original Protein Data Bank format, and only for that purpose.  
Database field namePDBGroup 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB group  
Examples
Help text 

_Atom.PDB_atom_ID (PDBAtomID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_atom_ID 
DescriptionNMR-STAR name: _Atom.PDB_atom_ID
This data item is a pointer to '_Chem_comp_atom.Atom_id in the chem_comp_atom category.  
Database field namePDBAtomID 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB atom ID  
Examples
Help text 

_Atom.PDB_atom_type (PDBAtomType)

(go to parent tag category listing)
NMR-STAR tag name_Atom.PDB_atom_type 
DescriptionNMR-STAR name: _Atom.PDB_atom_type
Standard symbol used to define the atom element type.  
Database field namePDBAtomType 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptPDB atom type  
Examples
Help text 

_Atom.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Sf_ID 
DescriptionNMR-STAR name: _Atom.Sf_ID
Pointer to '_Assembly.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAssembly, Sf_ID 
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 

_Atom.Entry_ID (EntryID)

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

_Atom.Assembly_ID (AssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_Atom.Assembly_ID 
DescriptionNMR-STAR name: _Atom.Assembly_ID
Pointer to '_Assembly.ID'  
Database field nameAssemblyID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnAssembly, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAssembly ID  
Examples
Help text