NMR-STAR dictionary: detail of DeletedAtom table

NMR-STAR dictionary: database table: DeletedAtom

Detailed description of the fields

_Deleted_atom.ID (DeletedAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.ID
Description	NMR-STAR name: _Deleted_atom.ID Unique identifier used to index the rows of deleted atoms.
Database field name	DeletedAtomID
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	ID
Examples	?
Help text

_Deleted_atom.Assembly_atom_ID (AssemblyAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Assembly_atom_ID
Description	NMR-STAR name: _Deleted_atom.Assembly_atom_ID Pointer to '_Atom.Assembly_atom_ID'
Database field name	AssemblyAtomID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Atom, Assembly_atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Assembly atom ID
Examples	?
Help text

_Deleted_atom.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Entity_assembly_ID
Description	NMR-STAR name: _Deleted_atom.Entity_assembly_ID Pointer to '_Entity_assembly.ID'
Database field name	EntityAssemblyID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Assembly component ID
Examples	2
Help text

_Deleted_atom.Entity_assembly_name (EntityAssemblyName)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Entity_assembly_name
Description	NMR-STAR name: _Deleted_atom.Entity_assembly_name Provide the name given to the molecule in the molecular assembly where the deleted atom is located. There may be several identical biopolymers in the system, but the one where the specific atom has been deleted needs to be specified. If the same atom is missing from multiple polymers in the system, a row in this table needs to be created for each deleted atom. In this way a complete and accurate chemical structure for the molecular system can be constructed.
Database field name	EntityAssemblyName
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	Deleted atom molecular assembly component name
Examples	?
Help text

_Deleted_atom.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Entity_ID
Description	NMR-STAR name: _Deleted_atom.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?	yes
Prompt	Entity ID
Examples	?
Help text

_Deleted_atom.Entity_label (EntityLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Entity_label
Description	NMR-STAR name: _Deleted_atom.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?	yes
Prompt	Name of the molecule
Examples	?
Help text

_Deleted_atom.Comp_index_ID (CompIndexID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Comp_index_ID
Description	NMR-STAR name: _Deleted_atom.Comp_index_ID Pointer to '_Entity_comp_index.ID'
Database field name	CompIndexID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_comp_index, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Chem comp index ID
Examples	?
Help text

_Deleted_atom.Seq_ID (SeqID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Seq_ID
Description	NMR-STAR name: _Deleted_atom.Seq_ID Pointer to '_Entity_poly_seq.Num'.
Database field name	SeqID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_poly_seq, Num
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Residue sequence number
Examples	13
Help text

_Deleted_atom.Comp_ID (CompID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Comp_ID
Description	NMR-STAR name: _Deleted_atom.Comp_ID Pointer to '_Chem_comp.ID'
Database field name	CompID
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp ID
Examples	?
Help text

_Deleted_atom.Comp_label (CompLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Comp_label
Description	NMR-STAR name: _Deleted_atom.Comp_label Pointer to a saveframe of the category 'chem_comp'
Database field name	CompLabel
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Chem_comp, Sf_framecode
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Ligand or residue label
Examples	CYS
Help text

_Deleted_atom.Atom_ID (AtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Atom_ID
Description	NMR-STAR name: _Deleted_atom.Atom_ID Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtomID
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp_atom, Atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Atom name
Examples	HG
Help text

_Deleted_atom.Auth_entity_assembly_ID (AuthEntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Auth_entity_assembly_ID
Description	NMR-STAR name: _Deleted_atom.Auth_entity_assembly_ID ?
Database field name	AuthEntityAssemblyID
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	Auth entity assembly ID
Examples	A
Help text

_Deleted_atom.Auth_seq_ID (AuthSeqID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Auth_seq_ID
Description	NMR-STAR name: _Deleted_atom.Auth_seq_ID Enter the sequence number or code for the residue where the atom has been deleted. If the atom has been deleted from a ligand, enter 'na'.
Database field name	AuthSeqID
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
Prompt	Deleted atom residue sequence number
Examples	42
Help text

_Deleted_atom.Auth_comp_ID (AuthCompID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Auth_comp_ID
Description	NMR-STAR name: _Deleted_atom.Auth_comp_ID Enter the residue three-letter code or other appropriate code for the residue where the atom has been deleted. If the atom has been deleted from a ligand that does not contain multiple residues, enter 'na'.
Database field name	AuthCompID
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
Prompt	Deleted atom residue code
Examples	CYS
Help text

_Deleted_atom.Auth_atom_ID (AuthAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Auth_atom_ID
Description	NMR-STAR name: _Deleted_atom.Auth_atom_ID Enter the name of the deleted atom. Please use IUPAC atom nomenclature, if at all possible.
Database field name	AuthAtomID
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
Prompt	Deleted atom name
Examples	HG
Help text

_Deleted_atom.Atom_type (AtomType)

(go to parent tag category listing)

NMR-STAR tag name	_Deleted_atom.Atom_type
Description	NMR-STAR name: _Deleted_atom.Atom_type Please enter the standard symbol used to define the atom element type. It is not always possible to determine the type of atom that has been deleted from the name for the atom.
Database field name	AtomType
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?	yes
Prompt	Atom type
Examples	H
Help text

_Deleted_atom.Sf_ID (SfID)

(go to parent tag category listing)

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

_Deleted_atom.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Deleted_atom.Assembly_ID (AssemblyID)

(go to parent tag category listing)

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