Schema for knownToRefSeq
  Database: mm9    Primary Table: knownToRefSeq    Row Count: 48,256   Data last updated: 2011-03-02
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 uc009vfk.1varchar(255) values primary ID
value NM_201530varchar(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)
      mm9.affyGnfU74ADistance.query (via knownToRefSeq.name)
      mm9.affyGnfU74ADistance.target (via knownToRefSeq.name)
      mm9.affyGnfU74BDistance.query (via knownToRefSeq.name)
      mm9.affyGnfU74BDistance.target (via knownToRefSeq.name)
      mm9.affyGnfU74CDistance.query (via knownToRefSeq.name)
      mm9.affyGnfU74CDistance.target (via knownToRefSeq.name)
      mm9.bioCycPathway.kgID (via knownToRefSeq.name)
      mm9.ccdsKgMap.geneId (via knownToRefSeq.name)
      mm9.ceBlastTab.query (via knownToRefSeq.name)
      mm9.dmBlastTab.query (via knownToRefSeq.name)
      mm9.drBlastTab.query (via knownToRefSeq.name)
      mm9.foldUtr3.name (via knownToRefSeq.name)
      mm9.foldUtr5.name (via knownToRefSeq.name)
      mm9.gnfAtlas2Distance.query (via knownToRefSeq.name)
      mm9.gnfAtlas2Distance.target (via knownToRefSeq.name)
      mm9.hgBlastTab.query (via knownToRefSeq.name)
      mm9.keggPathway.kgID (via knownToRefSeq.name)
      mm9.kgAlias.kgID (via knownToRefSeq.name)
      mm9.kgColor.kgID (via knownToRefSeq.name)
      mm9.kgProtAlias.kgID (via knownToRefSeq.name)
      mm9.kgProtMap2.qName (via knownToRefSeq.name)
      mm9.kgSpAlias.kgID (via knownToRefSeq.name)
      mm9.kgTargetAli.qName (via knownToRefSeq.name)
      mm9.kgTxInfo.name (via knownToRefSeq.name)
      mm9.kgXref.kgID (via knownToRefSeq.name)
      mm9.knownBlastTab.query (via knownToRefSeq.name)
      mm9.knownBlastTab.target (via knownToRefSeq.name)
      mm9.knownCanonical.protein (via knownToRefSeq.name)
      mm9.knownCanonical.transcript (via knownToRefSeq.name)
      mm9.knownGene.name (via knownToRefSeq.name)
      mm9.knownGeneMrna.name (via knownToRefSeq.name)
      mm9.knownGenePep.name (via knownToRefSeq.name)
      mm9.knownIsoforms.transcript (via knownToRefSeq.name)
      mm9.knownToAllenBrain.name (via knownToRefSeq.name)
      mm9.knownToEnsembl.name (via knownToRefSeq.name)
      mm9.knownToGnfAtlas2.name (via knownToRefSeq.name)
      mm9.knownToKeggEntrez.name (via knownToRefSeq.name)
      mm9.knownToLocusLink.name (via knownToRefSeq.name)
      mm9.knownToPfam.name (via knownToRefSeq.name)
      mm9.knownToSuper.gene (via knownToRefSeq.name)
      mm9.knownToVisiGene.name (via knownToRefSeq.name)
      mm9.rnBlastTab.query (via knownToRefSeq.name)
      mm9.scBlastTab.query (via knownToRefSeq.name)
      mm9.ucscScop.ucscId (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)
      mm9.ccdsInfo.mrnaAcc (via knownToRefSeq.value)
      mm9.geneNetworkId.id (via knownToRefSeq.value)
      mm9.kgXref.refseq (via knownToRefSeq.value)
      mm9.mrnaOrientInfo.name (via knownToRefSeq.value)
      mm9.refFlat.name (via knownToRefSeq.value)
      mm9.refGene.name (via knownToRefSeq.value)
      mm9.refSeqAli.qName (via knownToRefSeq.value)

Sample Rows
 
namevalue
uc009vfk.1NM_201530
uc009vfo.1NM_001037748
uc009vfp.1NM_001037748
uc009vfq.1NM_001160144
uc012hsg.1NM_001199331
uc009vgb.1NM_001037748
uc009vgc.1NM_001037748
uc009vgg.1NM_001160143
uc012hsn.1NM_001101623
uc012hsq.1NM_001160131

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