Schema for knownToRefSeq
  Database: mm39    Primary Table: knownToRefSeq    Row Count: 107,960   Data last updated: 2023-08-17
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 ENSMUST00000179505.8varchar(255) values primary ID
value NR_003518varchar(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)
      mm39.bioCycPathway.kgID (via knownToRefSeq.name)
      mm39.ceBlastTab.query (via knownToRefSeq.name)
      mm39.dmBlastTab.query (via knownToRefSeq.name)
      mm39.drBlastTab.query (via knownToRefSeq.name)
      mm39.foldUtr3.name (via knownToRefSeq.name)
      mm39.foldUtr5.name (via knownToRefSeq.name)
      mm39.hgBlastTab.query (via knownToRefSeq.name)
      mm39.kgAlias.kgID (via knownToRefSeq.name)
      mm39.kgColor.kgID (via knownToRefSeq.name)
      mm39.kgProtAlias.kgID (via knownToRefSeq.name)
      mm39.kgSpAlias.kgID (via knownToRefSeq.name)
      mm39.kgTargetAli.qName (via knownToRefSeq.name)
      mm39.kgXref.kgID (via knownToRefSeq.name)
      mm39.knownAttrs.kgID (via knownToRefSeq.name)
      mm39.knownBlastTab.query (via knownToRefSeq.name)
      mm39.knownBlastTab.target (via knownToRefSeq.name)
      mm39.knownCanonical.transcript (via knownToRefSeq.name)
      mm39.knownCds.name (via knownToRefSeq.name)
      mm39.knownGene.name (via knownToRefSeq.name)
      mm39.knownGeneMrna.name (via knownToRefSeq.name)
      mm39.knownIsoforms.transcript (via knownToRefSeq.name)
      mm39.knownToEnsembl.name (via knownToRefSeq.name)
      mm39.knownToLocusLink.name (via knownToRefSeq.name)
      mm39.knownToMrna.name (via knownToRefSeq.name)
      mm39.knownToMrnaSingle.name (via knownToRefSeq.name)
      mm39.knownToMupit.name (via knownToRefSeq.name)
      mm39.knownToNextProt.name (via knownToRefSeq.name)
      mm39.knownToPfam.name (via knownToRefSeq.name)
      mm39.knownToSuper.gene (via knownToRefSeq.name)
      mm39.knownToTag.name (via knownToRefSeq.name)
      mm39.knownToVisiGene.name (via knownToRefSeq.name)
      mm39.knownToWikipedia.name (via knownToRefSeq.name)
      mm39.rnBlastTab.query (via knownToRefSeq.name)
      mm39.scBlastTab.query (via knownToRefSeq.name)
      mm39.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)
      mm39.kgXref.refseq (via knownToRefSeq.value)
      mm39.mrnaOrientInfo.name (via knownToRefSeq.value)
      mm39.refFlat.name (via knownToRefSeq.value)
      mm39.refGene.name (via knownToRefSeq.value)
      mm39.refSeqAli.qName (via knownToRefSeq.value)

Sample Rows
 
namevalue
ENSMUST00000179505.8NR_003518
ENSMUST00000178343.2NR_003518
ENSMUST00000179715.2NR_165476
ENSMUST00000115924.3NM_001378739
ENSMUST00000177783.2NM_001167567
ENSMUST00000177979.2NM_001167568
ENSMUST00000180291.2NM_001031622
ENSMUST00000179146.2NM_177913
ENSMUST00000178291.2NM_177913
ENSMUST00000178296.2NM_001270457

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