Nucleotide
- Nucleotide comes from the National Center for Biotechnology Information, and is described by its creators thusly:
- The Entrez Nucleotides database is a collection of sequences from several sources, including GenBank, RefSeq, and PDB. The number of bases grows at an exponential rate.
- [online; accessed 10/21/03; http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=Nucleotide/
Schema in CLSD
Nucleotide nicknames are found under the 'ncbi' schema. These nicknames use the Entrez wrapper to make queries directly against the NCBI's database.Nucelotide is accessed via the Entrez wrapper and its nicknames require a special syntax.
| Table | Field | Type | Description | Q | F |
|---|---|---|---|---|---|
| GBSeq | PRIMARYACCESSION | VARCHAR(16) | PACC | Y | |
| SEQUENCEKEY | VARCHAR(32) | ||||
| LOCUSNAME | VARCHAR(16) | ACCN | |||
| SEQLENGTH | INTEGER | SLEN | |||
| STRANDEDNESS | VARCHAR(32) | ||||
| MOLECULETYPE | VARCHAR(16) | PROP | |||
| TOPOLOGY | VARCHAR(16) | ||||
| DIVISION | CHARACTER(3) | PROP | |||
| UPDATEDATE | DATE | MDAT | |||
| CREATEDATE | DATE | ||||
| DEFINITION | VARCHAR(7000) | TITL | |||
| VERSION | INTEGER | ||||
| GI | VARCHAR(16) | UID | |||
| KEYWORDLIST | VARCHAR(7000) | KYWD | |||
| SEGMENT | VARCHAR(250) | ||||
| SOURCE | VARCHAR(200) | ORGN | |||
| ORGANISM | VARCHAR(7000) | ORGN | |||
| TAXONOMY | VARCHAR(7000) | ||||
| COMMENT | VARCHAR(7000) | ||||
| PRIMARY | VARCHAR(7000) | ||||
| SOURCEDB | VARCHAR(250) | ||||
| SEQUENCE | VARCHAR(32000) | ||||
| ALLTEXT | VARCHAR(1) | ALL | |||
| FREETEXT | VARCHAR(1) | WORD | |||
| GBFeatures | SEQUENCEKEY | VARCHAR(32) | |||
| FEATUREJOINKEY | VARCHAR(32) | ||||
| FEATUREKEY | VARCHAR(20) | FKEY | |||
| FEATURELOCATION | VARCHAR(200) | ||||
| GBIntervals | FEATUREJOINKEY | VARCHAR(32) | |||
| INTERVALFROM | INTEGER | ||||
| INTERVALTO | INTEGER | ||||
| INTERVALPOINT | INTEGER | ||||
| INTERVALACCESSION | VARCHAR(32) | ||||
| GBQualifiers | FEATUREJOINKEY | VARCHAR(32) | |||
| QUALIFIERNAME | VARCHAR(50) | ||||
| QUALIFIERVALUE | VARCHAR(3200) | ||||
| GBReference | SEQUENCEKEY | VARCHAR(32) | |||
| REFERENCENUM | INTEGER | ||||
| RANGELOW | INTEGER | ||||
| RANGEHIGH | INTEGER | ||||
| AUTHORS | VARCHAR(3200) | AUTH | |||
| CONSORTIUM | VARCHAR(250) | ||||
| TITLE | VARCHAR(250) | WORD | |||
| JOURNALTITLE | VARCHAR(250) | JOUR | |||
| MEDLINEID | VARCHAR(10) | ||||
| PUBMEDID | VARCHAR(10) | ||||
| REMARKS | VARCHAR(3200) |
