NMR-STAR dictionary: detail of EntityAssembly table

NMR-STAR dictionary: database table: EntityAssembly

Detailed description of the fields

_Entity_assembly.ID (EntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.ID
Description	NMR-STAR name: _Entity_assembly.ID Unique identifier for each component in the entity assembly.
Database field name	EntityAssemblyID
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	Integer ID for assembly component
Examples	1
Help text

_Entity_assembly.Entity_assembly_name (EntityAssemblyName)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Entity_assembly_name
Description	NMR-STAR name: _Entity_assembly.Entity_assembly_name Name for the molecular component in the molecular assembly
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?	no
Prompt	Assembly component name
Examples	subunit 1
Help text

_Entity_assembly.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Entity_ID
Description	NMR-STAR name: _Entity_assembly.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

_Entity_assembly.Entity_label (EntityLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Entity_label
Description	NMR-STAR name: _Entity_assembly.Entity_label This value points to the section of the entry where the chemical description is given for all assembly components of this type. For a homodimer a chemical description of the monomer is given only once and is pointed to by this value although the assembly contains two monomers.
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?	no
Prompt	Molecular entity name to assign to this assembly component
Examples	HIV protease polypeptide
Help text

_Entity_assembly.Asym_ID (AsymID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Asym_ID
Description	NMR-STAR name: _Entity_assembly.Asym_ID The PDB chain ID for the molecule in the molecular assembly. For example each molecule of a homodimer would be assigned a unique chain ID. Metal ions and cofactors when tightly bound to a biopolymer should be given the same chain ID as the biopolymer where they are attached.
Database field name	AsymID
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Struct_asym, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Chain ID
Examples	A
Help text

_Entity_assembly.PDB_chain_ID (PDBChainID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.PDB_chain_ID
Description	NMR-STAR name: _Entity_assembly.PDB_chain_ID The PDB chain ID for the molecule in the molecular assembly. For example each molecule of a homodimer would be assigned a unique chain ID. Metal ions and cofactors when tightly bound to a biopolymer should be given the same chain ID as the biopolymer where they are attached.
Database field name	PDBChainID
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	Chain ID
Examples	A
Help text

_Entity_assembly.Experimental_data_reported (ExperimentalDataReported)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Experimental_data_reported
Description	NMR-STAR name: _Entity_assembly.Experimental_data_reported Select 'yes' if experimental data are provided for this particular component in the system. Data are usually, but not always, provided for the biopolymers in the system, but are often not provided for metal ligands.
Database field name	ExperimentalDataReported
SQL Database type	VARCHAR(3)
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 a closed enumeration. The list of values are the only ones allowed.
Prompt	Experimental data reported
Examples	yes
Help text

_Entity_assembly.Physical_state (PhysicalState)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Physical_state
Description	NMR-STAR name: _Entity_assembly.Physical_state An enumerated list of descriptive terms used to define the conformational state of the component of the assembly.
Database field name	PhysicalState
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	Physical state (biopolymers only)
Examples	native
Help text

_Entity_assembly.Conformational_isomer (ConformationalIsomer)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Conformational_isomer
Description	NMR-STAR name: _Entity_assembly.Conformational_isomer For biopolymers or ligands, does the indicated component of the system represent an observed conformational isomer of another component of the system. For example, component one may represent a polypeptide chain with proline 34 in the cis conformation and component two may represent the polypeptide chain with proline 34 in the trans conformation. In another example, component one may be alpha-D-glucose and component two beta-D-glucose.
Database field name	ConformationalIsomer
SQL Database type	VARCHAR(3)
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 a closed enumeration. The list of values are the only ones allowed.
Prompt	NMR observable conformational isomer
Examples	yes
Help text

_Entity_assembly.Chemical_exchange_state (ChemicalExchangeState)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Chemical_exchange_state
Description	NMR-STAR name: _Entity_assembly.Chemical_exchange_state A flag indicating whether the component of the system is in chemical exchange with another component of the system. Check 'yes' if the component is in chemical exchange with another component in the system, for example ligands that are present in both the free and bound states.
Database field name	ChemicalExchangeState
SQL Database type	VARCHAR(3)
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 a closed enumeration. The list of values are the only ones allowed.
Prompt	Chemical exchange state
Examples	no
Help text

_Entity_assembly.Magnetic_equivalence_group_code (MagneticEquivalenceGroupCode)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Magnetic_equivalence_group_code
Description	NMR-STAR name: _Entity_assembly.Magnetic_equivalence_group_code Unique identifier for the group of assembly components within the assembly that are magnetically equivalent in that only one set of NMR peaks are observed for the group. For example, this is the usual situation for a protein homodimer. Thus one enters the same number in the boxes for component #1 and comonent #2, if these represent the two proteins making up the homodimer.
Database field name	MagneticEquivalenceGroupCode
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	Magnetic equivalence group code
Examples	1
Help text

_Entity_assembly.Role (Role)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Role
Description	NMR-STAR name: _Entity_assembly.Role The function the listed component of the assembly plays within the assembly.
Database field name	Role
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
Prompt	Role of the component in the assembly
Examples	catalytic unit
Help text

_Entity_assembly.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Details
Description	NMR-STAR name: _Entity_assembly.Details If appropriate, please provide text information describing this component of the assembly that is pertinent to the component as found in the assembly. Specific details about the chemical nature of the component and other information can be given in the molecular entity category.
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 for this assembly component
Examples	The bound ATP is in slow exchange with the free form
Help text

_Entity_assembly.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Sf_ID
Description	NMR-STAR name: _Entity_assembly.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

_Entity_assembly.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Entity_assembly.Assembly_ID (AssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_assembly.Assembly_ID
Description	NMR-STAR name: _Entity_assembly.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