NMR-STAR dictionary: detail of EntityDbLink table

NMR-STAR dictionary: database table: EntityDbLink

Detailed description of the fields

_Entity_db_link.Author_supplied (AuthorSupplied)

NMR-STAR tag name	_Entity_db_link.Author_supplied
Description	NMR-STAR name: _Entity_db_link.Author_supplied A code indicating that the link to a related database was provided by an author (yes) or obtained through another method (no).
Database field name	AuthorSupplied
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	Author supplied
Examples	yes
Help text

_Entity_db_link.Database_code (DatabaseCode)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Database_code
Description	NMR-STAR name: _Entity_db_link.Database_code Select the name (code) that defines the sequence database.
Database field name	DatabaseCode
SQL Database type	VARCHAR(127)
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
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Sequence database name
Examples	SWS
Help text

_Entity_db_link.Accession_code (AccessionCode)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Accession_code
Description	NMR-STAR name: _Entity_db_link.Accession_code Please enter the code for the entry in the sequence database.
Database field name	AccessionCode
SQL Database type	VARCHAR(31)
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	Sequence database entry code
Examples	P09020
Help text

_Entity_db_link.Entry_mol_code (EntryMolCode)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Entry_mol_code
Description	NMR-STAR name: _Entity_db_link.Entry_mol_code Code assigned by the database to the molecule in the database entry.
Database field name	EntryMolCode
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	Entry mol code
Examples	?
Help text

_Entity_db_link.Entry_mol_name (EntryMolName)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Entry_mol_name
Description	NMR-STAR name: _Entity_db_link.Entry_mol_name Name or acronym for the molecule (biopolymer) in the database entry.
Database field name	EntryMolName
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	Molecule name/acronym
Examples	Cyt c
Help text

_Entity_db_link.Entry_experimental_method (EntryExperimentalMethod)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Entry_experimental_method
Description	NMR-STAR name: _Entity_db_link.Entry_experimental_method For structural databases, the method used to determine the structure.
Database field name	EntryExperimentalMethod
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	Entry experimental method
Examples	?
Help text

_Entity_db_link.Entry_structure_resolution (EntryStructureResolution)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Entry_structure_resolution
Description	NMR-STAR name: _Entity_db_link.Entry_structure_resolution A value taken from the database that is a measure of the quality of the structure.
Database field name	EntryStructureResolution
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	Entry structure resolution
Examples	?
Help text

_Entity_db_link.Entry_relation_type (EntryRelationType)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Entry_relation_type
Description	NMR-STAR name: _Entity_db_link.Entry_relation_type A brief description of how the database entry is related to the molecular entity or the title for a PDB entry.
Database field name	EntryRelationType
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	Entry relation type
Examples	?
Help text

_Entity_db_link.Entry_details (EntryDetails)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Entry_details
Description	NMR-STAR name: _Entity_db_link.Entry_details Text providing additional information about the matching entry.
Database field name	EntryDetails
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	Entry details
Examples	?
Help text

_Entity_db_link.Chimera_segment (ChimeraSegment)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Chimera_segment
Description	NMR-STAR name: _Entity_db_link.Chimera_segment Code indicating if the listed database link is specific to the fragment of the entity described by the tag '_Entity.Fragment'.
Database field name	ChimeraSegment
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	no
Nulls allowed in database?	no
Prompt	Chimera segment
Examples	?
Help text

_Entity_db_link.Seq_query_to_submitted_percent (SeqQueryToSubmittedPercent)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_query_to_submitted_percent
Description	NMR-STAR name: _Entity_db_link.Seq_query_to_submitted_percent In percent, the ratio of the length of retrieve sequence to the length of the sequence of the molecular entity. This value can be used to determine if the retrieved sequence is a subset or superset of the molecular entity.
Database field name	SeqQueryToSubmittedPercent
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	Seq query to submitted percent
Examples	?
Help text

_Entity_db_link.Seq_subject_length (SeqSubjectLength)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_subject_length
Description	NMR-STAR name: _Entity_db_link.Seq_subject_length Length of the polymer sequence retrieve from the database.
Database field name	SeqSubjectLength
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	no
Nulls allowed in database?	no
Prompt	Seq subject length
Examples	?
Help text

_Entity_db_link.Seq_identity (SeqIdentity)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_identity
Description	NMR-STAR name: _Entity_db_link.Seq_identity Number of residues in the retrieved sequence that have identical positions in the molecular entity determined by a homology alignment method.
Database field name	SeqIdentity
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	Seq identity
Examples	?
Help text

_Entity_db_link.Seq_positive (SeqPositive)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_positive
Description	NMR-STAR name: _Entity_db_link.Seq_positive Number of residues in the retrieved sequence where the corresponding residue in the molecular entity sequence has similar physical characteristics (hydrophobicity, charge, etc.)
Database field name	SeqPositive
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	Seq positive
Examples	?
Help text

_Entity_db_link.Seq_homology_expectation_val (SeqHomologyExpectationVal)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_homology_expectation_val
Description	NMR-STAR name: _Entity_db_link.Seq_homology_expectation_val The BLAST expectation value for the homology between the retrieved polymer and the molecular entity.
Database field name	SeqHomologyExpectationVal
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	Seq homology expectation val
Examples	?
Help text

_Entity_db_link.Seq_align_begin (SeqAlignBegin)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_align_begin
Description	NMR-STAR name: _Entity_db_link.Seq_align_begin The sequence position in the database sequence at which the alignment with your sequence begins.
Database field name	SeqAlignBegin
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	Beginning sequence position
Examples	10
Help text

_Entity_db_link.Seq_align_end (SeqAlignEnd)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_align_end
Description	NMR-STAR name: _Entity_db_link.Seq_align_end The sequence position in the database sequence at which the alignment with your sequence ends.
Database field name	SeqAlignEnd
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	Ending sequence position
Examples	95
Help text

_Entity_db_link.Seq_difference_details (SeqDifferenceDetails)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_difference_details
Description	NMR-STAR name: _Entity_db_link.Seq_difference_details Text describing the differences in the sequences for the matched polymers.
Database field name	SeqDifferenceDetails
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	Seq difference details
Examples	?
Help text

_Entity_db_link.Seq_alignment_details (SeqAlignmentDetails)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Seq_alignment_details
Description	NMR-STAR name: _Entity_db_link.Seq_alignment_details Text describing the alignment between the matched polymer sequences.
Database field name	SeqAlignmentDetails
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	Seq alignment details
Examples	?
Help text

_Entity_db_link.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Sf_ID
Description	NMR-STAR name: _Entity_db_link.Sf_ID Pointer to '_Entity.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity, 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_db_link.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Entry_ID
Description	NMR-STAR name: _Entity_db_link.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	Entity, 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_db_link.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_db_link.Entity_ID
Description	NMR-STAR name: _Entity_db_link.Entity_ID Pointer to '_Entity.ID'
Database field name	EntityID
SQL Database type	INTEGER
Part of primary Key	yes
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