Schema for knownToRefSeq
  Database: mm8    Primary Table: knownToRefSeq    Row Count: 27,636   Data last updated: 2006-03-09
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name NM_030175varchar(255) values primary ID
value NM_030175varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToRefSeq.name)
      knownGeneV39.ceBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.dmBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.drBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.foldUtr3.name (via knownToRefSeq.name)
      knownGeneV39.foldUtr5.name (via knownToRefSeq.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToRefSeq.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToRefSeq.name)
      knownGeneV39.kgAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgColor.kgID (via knownToRefSeq.name)
      knownGeneV39.kgProtAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgSpAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgTargetAli.qName (via knownToRefSeq.name)
      knownGeneV39.kgXref.kgID (via knownToRefSeq.name)
      knownGeneV39.knownAttrs.kgID (via knownToRefSeq.name)
      knownGeneV39.knownBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.knownBlastTab.target (via knownToRefSeq.name)
      knownGeneV39.knownCanonical.protein (via knownToRefSeq.name)
      knownGeneV39.knownCanonical.transcript (via knownToRefSeq.name)
      knownGeneV39.knownCds.name (via knownToRefSeq.name)
      knownGeneV39.knownGene.name (via knownToRefSeq.name)
      knownGeneV39.knownGeneMrna.name (via knownToRefSeq.name)
      knownGeneV39.knownGenePep.name (via knownToRefSeq.name)
      knownGeneV39.knownIsoforms.transcript (via knownToRefSeq.name)
      knownGeneV39.knownToEnsembl.name (via knownToRefSeq.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToRefSeq.name)
      knownGeneV39.knownToHprd.name (via knownToRefSeq.name)
      knownGeneV39.knownToLocusLink.name (via knownToRefSeq.name)
      knownGeneV39.knownToMrna.name (via knownToRefSeq.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToRefSeq.name)
      knownGeneV39.knownToMupit.name (via knownToRefSeq.name)
      knownGeneV39.knownToPfam.name (via knownToRefSeq.name)
      knownGeneV39.knownToRefSeq.name (via knownToRefSeq.name)
      knownGeneV39.knownToSuper.gene (via knownToRefSeq.name)
      knownGeneV39.knownToTag.name (via knownToRefSeq.name)
      knownGeneV39.knownToU133.name (via knownToRefSeq.name)
      knownGeneV39.knownToU95.name (via knownToRefSeq.name)
      knownGeneV39.knownToVisiGene.name (via knownToRefSeq.name)
      knownGeneV39.knownToWikipedia.name (via knownToRefSeq.name)
      knownGeneV39.mmBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.rnBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.scBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.ucscScop.ucscId (via knownToRefSeq.name)
      mm8.affyGnfU74ADistance.query (via knownToRefSeq.name)
      mm8.affyGnfU74ADistance.target (via knownToRefSeq.name)
      mm8.affyGnfU74BDistance.query (via knownToRefSeq.name)
      mm8.affyGnfU74BDistance.target (via knownToRefSeq.name)
      mm8.affyGnfU74CDistance.query (via knownToRefSeq.name)
      mm8.affyGnfU74CDistance.target (via knownToRefSeq.name)
      mm8.ccdsKgMap.geneId (via knownToRefSeq.name)
      mm8.ceBlastTab.query (via knownToRefSeq.name)
      mm8.dmBlastTab.query (via knownToRefSeq.name)
      mm8.drBlastTab.query (via knownToRefSeq.name)
      mm8.dupSpMrna.mrnaID (via knownToRefSeq.name)
      mm8.foldUtr3.name (via knownToRefSeq.name)
      mm8.foldUtr5.name (via knownToRefSeq.name)
      mm8.gnfAtlas2Distance.query (via knownToRefSeq.name)
      mm8.gnfAtlas2Distance.target (via knownToRefSeq.name)
      mm8.hgBlastTab.query (via knownToRefSeq.name)
      mm8.keggPathway.kgID (via knownToRefSeq.name)
      mm8.kgAlias.kgID (via knownToRefSeq.name)
      mm8.kgProtAlias.kgID (via knownToRefSeq.name)
      mm8.kgSpAlias.kgID (via knownToRefSeq.name)
      mm8.kgTargetAli.qName (via knownToRefSeq.name)
      mm8.kgXref.kgID (via knownToRefSeq.name)
      mm8.knownBlastTab.query (via knownToRefSeq.name)
      mm8.knownBlastTab.target (via knownToRefSeq.name)
      mm8.knownCanonical.transcript (via knownToRefSeq.name)
      mm8.knownGene.name (via knownToRefSeq.name)
      mm8.knownGeneMrna.name (via knownToRefSeq.name)
      mm8.knownGenePep.name (via knownToRefSeq.name)
      mm8.knownIsoforms.transcript (via knownToRefSeq.name)
      mm8.knownToAllenBrain.name (via knownToRefSeq.name)
      mm8.knownToEnsembl.name (via knownToRefSeq.name)
      mm8.knownToGnfAtlas2.name (via knownToRefSeq.name)
      mm8.knownToKeggEntrez.name (via knownToRefSeq.name)
      mm8.knownToLocusLink.name (via knownToRefSeq.name)
      mm8.knownToPfam.name (via knownToRefSeq.name)
      mm8.knownToSuper.gene (via knownToRefSeq.name)
      mm8.knownToVisiGene.name (via knownToRefSeq.name)
      mm8.rnBlastTab.query (via knownToRefSeq.name)
      mm8.scBlastTab.query (via knownToRefSeq.name)
      hgFixed.gbCdnaInfo.acc (via knownToRefSeq.value)
      hgFixed.gbSeq.acc (via knownToRefSeq.value)
      hgFixed.imageClone.acc (via knownToRefSeq.value)
      hgFixed.refLink.mrnaAcc (via knownToRefSeq.value)
      hgFixed.refSeqStatus.mrnaAcc (via knownToRefSeq.value)
      hgFixed.refSeqSummary.mrnaAcc (via knownToRefSeq.value)
      knownGeneV39.kgXref.refseq (via knownToRefSeq.value)
      knownGeneV39.knownToRefSeq.value (via knownToRefSeq.value)
      mm8.ccdsInfo.mrnaAcc (via knownToRefSeq.value)
      mm8.dupSpMrna.dupMrnaID (via knownToRefSeq.value)
      mm8.dupSpMrna.mrnaID (via knownToRefSeq.value)
      mm8.geneNetworkId.id (via knownToRefSeq.value)
      mm8.kgXref.refseq (via knownToRefSeq.value)
      mm8.mrnaOrientInfo.name (via knownToRefSeq.value)
      mm8.mrnaRefseq.mrna (via knownToRefSeq.value)
      mm8.mrnaRefseq.refseq (via knownToRefSeq.value)
      mm8.refFlat.name (via knownToRefSeq.value)
      mm8.refGene.name (via knownToRefSeq.value)
      mm8.refSeqAli.qName (via knownToRefSeq.value)

Sample Rows
 
namevalue
NM_030175NM_030175
NM_001030293NM_001030293
NM_153523NM_153523
NM_001037925NM_001037925
NM_172505NM_172505
BC100378NM_172505
NM_027861NM_027861
AK002489NM_027861
AK015946NM_026136
NM_026136NM_026136

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.