NMR-STAR dictionary: detail of AssemblySubsystem table

NMR-STAR dictionary: database table: AssemblySubsystem

Detailed description of the fields

_Assembly_subsystem.Sf_category (SfCategory)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.Sf_category
Description	NMR-STAR name: _Assembly_subsystem.Sf_category Category assigned to the information in the saveframe.
Database field name	SfCategory
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	Sf category
Examples	?
Help text

_Assembly_subsystem.Sf_framecode (SfFramecode)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.Sf_framecode
Description	NMR-STAR name: _Assembly_subsystem.Sf_framecode A descriptive label that uniquely identifies this molecular subsystem from all other subsystems of the molecular assembly studied.
Database field name	SfFramecode
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	Molecular assembly subsystem label
Examples	?
Help text

_Assembly_subsystem.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Assembly_subsystem.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.Sf_ID
Description	NMR-STAR name: _Assembly_subsystem.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 name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	,
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

_Assembly_subsystem.ID (AssemblySubsystemID)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.ID
Description	NMR-STAR name: _Assembly_subsystem.ID An integer value that uniquely defines the subsystem of the molecular assembly described. An assembly subsystem contains a subset of the components of the full molecular assembly, but does not consist of fragments of the molecular assembly components.
Database field name	AssemblySubsystemID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Subsystem list ID
Examples	?
Help text

_Assembly_subsystem.Name (Name)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.Name
Description	NMR-STAR name: _Assembly_subsystem.Name Author supplied name for the assembly subsystem.
Database field name	Name
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	Name
Examples	?
Help text

_Assembly_subsystem.CAS_name (CASName)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.CAS_name
Description	NMR-STAR name: _Assembly_subsystem.CAS_name Chemical Abstract Services name that applies to the assembly subsystem.
Database field name	CASName
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	CAS name
Examples	?
Help text

_Assembly_subsystem.CAS_registry_number (CASRegistryNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.CAS_registry_number
Description	NMR-STAR name: _Assembly_subsystem.CAS_registry_number Chemical Abstract Services registry number that applies to the assembly subsystem.
Database field name	CASRegistryNumber
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	CAS registry number
Examples	?
Help text

_Assembly_subsystem.Enzyme_commission_number (EnzymeCommissionNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.Enzyme_commission_number
Description	NMR-STAR name: _Assembly_subsystem.Enzyme_commission_number Identification number defined by the Enzyme Commission for the protein molecular system, or biological molecular system described in the saveframe.
Database field name	EnzymeCommissionNumber
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	Enzyme commission number
Examples	3.1.3.5.3
Help text

_Assembly_subsystem.Molecular_mass (MolecularMass)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.Molecular_mass
Description	NMR-STAR name: _Assembly_subsystem.Molecular_mass The approximate mass of the system as defined by the authors and is intended to approximate the sum of the masses of all of the atoms in the system. No attempt is made to define the mass at a specific pH value, in terms of the protonation state of any pH titratable groups, or according to the incorporation of isotopes.
Database field name	MolecularMass
SQL Database type	FLOAT
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	Molecular mass
Examples	24000
Help text

_Assembly_subsystem.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.Details
Description	NMR-STAR name: _Assembly_subsystem.Details Additional information relevant to the data in the current saveframe or to a specific data item is entered as a value to this tag. The information entered must supplement information already present. Whenever possible data should associated with specific data tags and not included in the value to a '_Details' tag.
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	Additional comments or details describing the contents of the citation are entered in this field.
Examples	?
Help text

_Assembly_subsystem.DB_query_date (DBQueryDate)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.DB_query_date
Description	NMR-STAR name: _Assembly_subsystem.DB_query_date Date that the last query has been conducted to locate entries in external databases that are related to the assembly subsystem.
Database field name	DBQueryDate
SQL Database type	DATETIME year to day
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	DB query date
Examples	?
Help text

_Assembly_subsystem.DB_last_query_revised_last_date (DBLastQueryRevisedLastDate)

(go to parent tag category listing)

NMR-STAR tag name	_Assembly_subsystem.DB_last_query_revised_last_date
Description	NMR-STAR name: _Assembly_subsystem.DB_last_query_revised_last_date Date that this table was updated with links to external databases.
Database field name	DBLastQueryRevisedLastDate
SQL Database type	DATETIME year to day
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	DB last query revised last date
Examples	?
Help text