Schema for knownToRefSeq
  Database: mm7    Primary Table: knownToRefSeq    Row Count: 26,500   Data last updated: 2005-11-15
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_008483varchar(255) values primary ID
value NM_008483varchar(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)
      mm7.affyGnfU74ADistance.query (via knownToRefSeq.name)
      mm7.affyGnfU74ADistance.target (via knownToRefSeq.name)
      mm7.affyGnfU74BDistance.query (via knownToRefSeq.name)
      mm7.affyGnfU74BDistance.target (via knownToRefSeq.name)
      mm7.affyGnfU74CDistance.query (via knownToRefSeq.name)
      mm7.affyGnfU74CDistance.target (via knownToRefSeq.name)
      mm7.dmBlastTab.query (via knownToRefSeq.name)
      mm7.drBlastTab.query (via knownToRefSeq.name)
      mm7.dupSpMrna.mrnaID (via knownToRefSeq.name)
      mm7.foldUtr3.name (via knownToRefSeq.name)
      mm7.foldUtr5.name (via knownToRefSeq.name)
      mm7.gnfAtlas2Distance.query (via knownToRefSeq.name)
      mm7.gnfAtlas2Distance.target (via knownToRefSeq.name)
      mm7.hgBlastTab.query (via knownToRefSeq.name)
      mm7.keggPathway.kgID (via knownToRefSeq.name)
      mm7.kgAlias.kgID (via knownToRefSeq.name)
      mm7.kgProtAlias.kgID (via knownToRefSeq.name)
      mm7.kgSpAlias.kgID (via knownToRefSeq.name)
      mm7.kgXref.kgID (via knownToRefSeq.name)
      mm7.knownBlastTab.query (via knownToRefSeq.name)
      mm7.knownBlastTab.target (via knownToRefSeq.name)
      mm7.knownCanonical.transcript (via knownToRefSeq.name)
      mm7.knownGene.name (via knownToRefSeq.name)
      mm7.knownGeneLink.name (via knownToRefSeq.name)
      mm7.knownGeneMrna.name (via knownToRefSeq.name)
      mm7.knownGenePep.name (via knownToRefSeq.name)
      mm7.knownIsoforms.transcript (via knownToRefSeq.name)
      mm7.knownToAllenBrain.name (via knownToRefSeq.name)
      mm7.knownToEnsembl.name (via knownToRefSeq.name)
      mm7.knownToGnfAtlas2.name (via knownToRefSeq.name)
      mm7.knownToKeggEntrez.name (via knownToRefSeq.name)
      mm7.knownToLocusLink.name (via knownToRefSeq.name)
      mm7.knownToPfam.name (via knownToRefSeq.name)
      mm7.knownToVisiGene.name (via knownToRefSeq.name)
      mm7.rnBlastTab.query (via knownToRefSeq.name)
      mm7.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)
      mm7.dupSpMrna.dupMrnaID (via knownToRefSeq.value)
      mm7.dupSpMrna.mrnaID (via knownToRefSeq.value)
      mm7.geneNetworkId.id (via knownToRefSeq.value)
      mm7.kgXref.refseq (via knownToRefSeq.value)
      mm7.mrnaOrientInfo.name (via knownToRefSeq.value)
      mm7.mrnaRefseq.mrna (via knownToRefSeq.value)
      mm7.mrnaRefseq.refseq (via knownToRefSeq.value)
      mm7.refFlat.name (via knownToRefSeq.value)
      mm7.refGene.name (via knownToRefSeq.value)
      mm7.refSeqAli.qName (via knownToRefSeq.value)

Sample Rows
 
namevalue
NM_008483NM_008483
AK141751NM_025534
AK079850NM_031395
NM_001004153NM_001004153
BC086454NM_001004153
NM_030740NM_030740
BC057991NM_028245
NM_028245NM_028245
AK162903NM_028245
NM_011124NM_011124

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