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
fieldexampleSQL type info description
id NM_001279815.1varchar(255) values id for this gene or curated item
status Provisionalvarchar(255) values Inferred, Model, Predicted, Provisional, Reviewed, Validated, Unknown
name AOX1varchar(255) values gene name
product aldehyde oxidase-likevarchar(255) values product
mrnaAcc NM_001279815.1varchar(255) values transcript_id
protAcc NP_001266744.1varchar(255) values protein_id
locusLinkId 101522997varchar(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.1varchar(255) values genbank identifier from Dbxref
pseudo  varchar(255) values 'true' if pseudo gene, or n/a
gbkey mRNAvarchar(255) values genbank key: Gene, mRNA, ncRNA, rRNA, tRNA, etc...
source BestRefSeqvarchar(255) values source: RefSeq, tRNAscan-SE, Gnomon, Curated Genomic, BestRefSeq
gene_biotype protein_codingvarchar(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
        ochPri3.ncbiRefSeq.name (via ncbiRefSeqLink.id)
      ochPri3.ncbiRefSeqCds.id (via ncbiRefSeqLink.id)
      ochPri3.ncbiRefSeqCurated.name (via ncbiRefSeqLink.id)
      ochPri3.ncbiRefSeqPredicted.name (via ncbiRefSeqLink.id)
      ochPri3.ncbiRefSeqPsl.qName (via ncbiRefSeqLink.id)
      ochPri3.seqNcbiRefSeq.acc (via ncbiRefSeqLink.id)
      ochPri3.ncbiRefSeqPepTable.name (via ncbiRefSeqLink.protAcc)

Sample Rows
 
idstatusnameproductmrnaAccprotAcclocusLinkIdomimIdhgncgenbankpseudogbkeysourcegene_biotypegene_synonymncrna_classnotedescriptionexternalId
NM_001279815.1ProvisionalAOX1aldehyde oxidase-likeNM_001279815.1NP_001266744.1101522997NM_001279815.1mRNABestRefSeqprotein_codingThe RefSeq transcript has 13 substitutions compared to this genomic sequence
NM_001279818.1ProvisionalPRNPprion proteinNM_001279818.1NP_001266747.1101521014NM_001279818.1mRNABestRefSeqprotein_codingThe RefSeq transcript has 2 substitutions compared to this genomic sequence
NM_001281962.1ValidatedTVP23BGolgi apparatus membrane protein TVP23 homolog BNM_001281962.1NP_001268891.1101528901NM_001281962.1mRNABestRefSeqprotein_coding
NM_001282160.1ValidatedLRRC51leucine-rich repeat-containing protein 51NM_001282160.1NP_001269089.1101521569NM_001282160.1mRNABestRefSeqprotein_coding
NM_001286019.1ValidatedRNASEH1ribonuclease H1NM_001286019.1NP_001272948.1101530098NM_001286019.1mRNABestRefSeqprotein_coding
NM_001289825.1ReviewedOAZ1ornithine decarboxylase antizyme 1NM_001289825.1NP_001276754.1101520135NM_001289825.1mRNABestRefSeqprotein_codingprotein translation is dependent on +1 polyamine-induced ribosomal frameshiftThe protein encoded by this gene belongs to the ornithine decarboxylase antizyme family, which plays a role in cell growth and p ...
NM_001290035.1ReviewedOAZ2ornithine decarboxylase antizyme 2NM_001290035.1NP_001276964.1101519480NM_001290035.1mRNABestRefSeqprotein_codingprotein translation is dependent on polyamine-induced +1 ribosomal frameshiftThe protein encoded by this gene belongs to the ornithine decarboxylase antizyme family, which plays a role in cell growth and p ...
NM_001290401.1ReviewedOAZ3ornithine decarboxylase antizyme 3NM_001290401.1NP_001277330.1101534879NM_001290401.1mRNABestRefSeqprotein_codingprotein translation is dependent on polyamine-induced +1 ribosomal frameshift; non-AUG (CUG) translation initiation codonThe protein encoded by this gene belongs to the ornithine decarboxylase antizyme family, which plays a role in cell growth and p ...
NM_001291519.1ReviewedAZIN1antizyme inhibitor 1, transcript variant 1NM_001291519.1NP_001278448.1101526222NM_001291519.1mRNABestRefSeqprotein_codingThe protein encoded by this gene belongs to the antizyme inhibitor family, which plays a role in cell growth and proliferation b ...
NM_001293732.1ReviewedAZIN2antizyme inhibitor 2NM_001293732.1NP_001280661.1101535476NM_001293732.1mRNABestRefSeqprotein_codingADCThe 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.