Schema for knownToRefSeq
  Database: mm39    Primary Table: knownToRefSeq    Row Count: 195,502   Data last updated: 2024-08-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 ENSMUST00000082387.1varchar(255) values primary ID
value TrnFvarchar(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
ENSMUST00000082387.1TrnF
ENSMUST00000082388.1mt-Rnr1
ENSMUST00000082389.1TrnV
ENSMUST00000082390.1mt-Rnr2
ENSMUST00000082391.1TrnL1
ENSMUST00000082392.1ND1
ENSMUST00000082393.1TrnI
ENSMUST00000082395.1TrnM
ENSMUST00000082396.1ND2
ENSMUST00000082397.1TrnW

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