Schema for ncbiRefSeqLink
|
|
Database: ochPri3 Primary Table: ncbiRefSeqLink Row Count: 26,253   Data last updated: 2020-03-20
Format description: Metadata for NCBI RefSeq tracks On download server: MariaDB table dump directory
field | example | SQL type | info | description |
id | NM_001279815.1 | varchar(255) | values | id for this gene or curated item |
status | Provisional | varchar(255) | values | Inferred, Model, Predicted, Provisional, Reviewed, Validated, Unknown |
name | AOX1 | varchar(255) | values | gene name |
product | aldehyde oxidase-like | varchar(255) | values | product |
mrnaAcc | NM_001279815.1 | varchar(255) | values | transcript_id |
protAcc | NP_001266744.1 | varchar(255) | values | protein_id |
locusLinkId | 101522997 | varchar(255) | values | locus link identifier, from Dbxref |
omimId | | varchar(255) | values | OMIM identifier, from Dbxref |
hgnc | | varchar(255) | values | HGNC identifier, from Dbxref |
genbank | NM_001279815.1 | varchar(255) | values | genbank identifier from Dbxref |
pseudo | | varchar(255) | values | 'true' if pseudo gene, or n/a |
gbkey | mRNA | varchar(255) | values | genbank key: Gene, mRNA, ncRNA, rRNA, tRNA, etc... |
source | BestRefSeq | varchar(255) | values | source: RefSeq, tRNAscan-SE, Gnomon, Curated Genomic, BestRefSeq |
gene_biotype | protein_coding | varchar(255) | values | bio type: protein_coding, pseudogene, C_region, J_segment_pseudogene, other |
gene_synonym | | varchar(255) | values | list of synonym names |
ncrna_class | | varchar(255) | values | type of RNA: miRNA, lncRNA, snoRNA, etc... |
note | The RefSeq transcript has 1... | longblob | | other notes from genbank record |
description | | longblob | | description from rna gbff record via gbProcess |
externalId | | varchar(255) | values | for outside URL link, WormBase, FlyBase, RGD, SGD, etc... from Dbxref |
|
| |
|
|
Connected Tables and Joining Fields
|
|
Sample Rows
|
|
id | status | name | product | mrnaAcc | protAcc | locusLinkId | omimId | hgnc | genbank | pseudo | gbkey | source | gene_biotype | gene_synonym | ncrna_class | note | description | externalId |
---|
NM_001279815.1 | Provisional | AOX1 | aldehyde oxidase-like | NM_001279815.1 | NP_001266744.1 | 101522997 | | | NM_001279815.1 | | mRNA | BestRefSeq | protein_coding | | | The RefSeq transcript has 13 substitutions compared to this genomic sequence | | |
NM_001279818.1 | Provisional | PRNP | prion protein | NM_001279818.1 | NP_001266747.1 | 101521014 | | | NM_001279818.1 | | mRNA | BestRefSeq | protein_coding | | | The RefSeq transcript has 2 substitutions compared to this genomic sequence | | |
NM_001281962.1 | Validated | TVP23B | Golgi apparatus membrane protein TVP23 homolog B | NM_001281962.1 | NP_001268891.1 | 101528901 | | | NM_001281962.1 | | mRNA | BestRefSeq | protein_coding | | | | | |
NM_001282160.1 | Validated | LRRC51 | leucine-rich repeat-containing protein 51 | NM_001282160.1 | NP_001269089.1 | 101521569 | | | NM_001282160.1 | | mRNA | BestRefSeq | protein_coding | | | | | |
NM_001286019.1 | Validated | RNASEH1 | ribonuclease H1 | NM_001286019.1 | NP_001272948.1 | 101530098 | | | NM_001286019.1 | | mRNA | BestRefSeq | protein_coding | | | | | |
NM_001289825.1 | Reviewed | OAZ1 | ornithine decarboxylase antizyme 1 | NM_001289825.1 | NP_001276754.1 | 101520135 | | | NM_001289825.1 | | mRNA | BestRefSeq | protein_coding | | | protein translation is dependent on +1 polyamine-induced ribosomal frameshift | The protein encoded by this gene belongs to the ornithine decarboxylase antizyme family, which plays a role in cell growth and p ... | |
NM_001290035.1 | Reviewed | OAZ2 | ornithine decarboxylase antizyme 2 | NM_001290035.1 | NP_001276964.1 | 101519480 | | | NM_001290035.1 | | mRNA | BestRefSeq | protein_coding | | | protein translation is dependent on polyamine-induced +1 ribosomal frameshift | The protein encoded by this gene belongs to the ornithine decarboxylase antizyme family, which plays a role in cell growth and p ... | |
NM_001290401.1 | Reviewed | OAZ3 | ornithine decarboxylase antizyme 3 | NM_001290401.1 | NP_001277330.1 | 101534879 | | | NM_001290401.1 | | mRNA | BestRefSeq | protein_coding | | | protein translation is dependent on polyamine-induced +1 ribosomal frameshift; non-AUG (CUG) translation initiation codon | The protein encoded by this gene belongs to the ornithine decarboxylase antizyme family, which plays a role in cell growth and p ... | |
NM_001291519.1 | Reviewed | AZIN1 | antizyme inhibitor 1, transcript variant 1 | NM_001291519.1 | NP_001278448.1 | 101526222 | | | NM_001291519.1 | | mRNA | BestRefSeq | protein_coding | | | | The protein encoded by this gene belongs to the antizyme inhibitor family, which plays a role in cell growth and proliferation b ... | |
NM_001293732.1 | Reviewed | AZIN2 | antizyme inhibitor 2 | NM_001293732.1 | NP_001280661.1 | 101535476 | | | NM_001293732.1 | | mRNA | BestRefSeq | protein_coding | ADC | | | The protein encoded by this gene belongs to the antizyme inhibitor family, which plays a role in cell growth and proliferation b ... | |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|