NMR-STAR dictionary: detail of NaturalSourceDb table

NMR-STAR dictionary: database table: NaturalSourceDb

Detailed description of the fields

_Natural_source_db.Entity_natural_src_ID (EntityNaturalSrcID)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Entity_natural_src_ID
Description	NMR-STAR name: _Natural_source_db.Entity_natural_src_ID Pointer to '_Entity_natural_src.ID'
Database field name	EntityNaturalSrcID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Entity_natural_src, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Natural source ID
Examples	?
Help text

_Natural_source_db.Entity_ID (EntityID)

(go to parent tag category listing)

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

_Natural_source_db.Entity_label (EntityLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Entity_label
Description	NMR-STAR name: _Natural_source_db.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	Biopolymer label
Examples	?
Help text

_Natural_source_db.Entity_chimera_segment_ID (EntityChimeraSegmentID)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Entity_chimera_segment_ID
Description	NMR-STAR name: _Natural_source_db.Entity_chimera_segment_ID Pointer to '_Entity_chimera_segment.ID'
Database field name	EntityChimeraSegmentID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_chimera_segment, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entity chimera segment ID
Examples	?
Help text

_Natural_source_db.Database_code (DatabaseCode)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Database_code
Description	NMR-STAR name: _Natural_source_db.Database_code Code or abbreviation used by a database organization.
Database field name	DatabaseCode
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	DB code
Examples	TAIR
Help text

_Natural_source_db.Database_type (DatabaseType)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Database_type
Description	NMR-STAR name: _Natural_source_db.Database_type The kind of database where the data are located.
Database field name	DatabaseType
SQL Database type	VARCHAR(31)
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	DB type
Examples	sequence; structure; genome
Help text

_Natural_source_db.Entry_code (EntryCode)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Entry_code
Description	NMR-STAR name: _Natural_source_db.Entry_code The accession code assigned to the entry by the database.
Database field name	EntryCode
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	Entry code
Examples	?
Help text

_Natural_source_db.Entry_type (EntryType)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Entry_type
Description	NMR-STAR name: _Natural_source_db.Entry_type Defines whether the current version of the entry is the original version or an updated version.
Database field name	EntryType
SQL Database type	VARCHAR(31)
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	Entry type
Examples	original
Help text

_Natural_source_db.ORF_code (ORFCode)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.ORF_code
Description	NMR-STAR name: _Natural_source_db.ORF_code Code assigned to the open reading frame coding for a protein or nucleic acid.
Database field name	ORFCode
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	ORF code
Examples	at1g01020
Help text

_Natural_source_db.Gene_locus_code (GeneLocusCode)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Gene_locus_code
Description	NMR-STAR name: _Natural_source_db.Gene_locus_code Unique code assigned to the locus for the gene in the genome.
Database field name	GeneLocusCode
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	Gene locus code
Examples	?
Help text

_Natural_source_db.Gene_cDNA_code (GeneCDNACode)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Gene_cDNA_code
Description	NMR-STAR name: _Natural_source_db.Gene_cDNA_code The unique code assigned to a cDNA sequence for the gene.
Database field name	GeneCDNACode
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	Gene cDNA code
Examples	?
Help text

_Natural_source_db.Sf_ID (SfID)

(go to parent tag category listing)

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

_Natural_source_db.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Natural_source_db.Entity_natural_src_list_ID (EntityNaturalSrcListID)

(go to parent tag category listing)

NMR-STAR tag name	_Natural_source_db.Entity_natural_src_list_ID
Description	NMR-STAR name: _Natural_source_db.Entity_natural_src_list_ID Pointer to '_Entity_natural_src_list.ID'
Database field name	EntityNaturalSrcListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Entity_natural_src_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entity natural src list ID
Examples	?
Help text