Schema for knownToMrnaSingle
  Database: mm10    Primary Table: knownToMrnaSingle    Row Count: 111,136   Data last updated: 2019-09-20
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 ENSMUST00000179436.1varchar(255) values primary ID
value AK002762varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToMrnaSingle.name)
      knownGeneV39.ceBlastTab.query (via knownToMrnaSingle.name)
      knownGeneV39.dmBlastTab.query (via knownToMrnaSingle.name)
      knownGeneV39.drBlastTab.query (via knownToMrnaSingle.name)
      knownGeneV39.foldUtr3.name (via knownToMrnaSingle.name)
      knownGeneV39.foldUtr5.name (via knownToMrnaSingle.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToMrnaSingle.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToMrnaSingle.name)
      knownGeneV39.kgAlias.kgID (via knownToMrnaSingle.name)
      knownGeneV39.kgColor.kgID (via knownToMrnaSingle.name)
      knownGeneV39.kgProtAlias.kgID (via knownToMrnaSingle.name)
      knownGeneV39.kgSpAlias.kgID (via knownToMrnaSingle.name)
      knownGeneV39.kgTargetAli.qName (via knownToMrnaSingle.name)
      knownGeneV39.kgXref.kgID (via knownToMrnaSingle.name)
      knownGeneV39.knownAttrs.kgID (via knownToMrnaSingle.name)
      knownGeneV39.knownBlastTab.query (via knownToMrnaSingle.name)
      knownGeneV39.knownBlastTab.target (via knownToMrnaSingle.name)
      knownGeneV39.knownCanonical.protein (via knownToMrnaSingle.name)
      knownGeneV39.knownCanonical.transcript (via knownToMrnaSingle.name)
      knownGeneV39.knownCds.name (via knownToMrnaSingle.name)
      knownGeneV39.knownGene.name (via knownToMrnaSingle.name)
      knownGeneV39.knownGeneMrna.name (via knownToMrnaSingle.name)
      knownGeneV39.knownGenePep.name (via knownToMrnaSingle.name)
      knownGeneV39.knownIsoforms.transcript (via knownToMrnaSingle.name)
      knownGeneV39.knownToEnsembl.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToHprd.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToLocusLink.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToMrna.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToMupit.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToPfam.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToRefSeq.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToSuper.gene (via knownToMrnaSingle.name)
      knownGeneV39.knownToTag.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToU133.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToU95.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToVisiGene.name (via knownToMrnaSingle.name)
      knownGeneV39.knownToWikipedia.name (via knownToMrnaSingle.name)
      knownGeneV39.mmBlastTab.query (via knownToMrnaSingle.name)
      knownGeneV39.rnBlastTab.query (via knownToMrnaSingle.name)
      knownGeneV39.scBlastTab.query (via knownToMrnaSingle.name)
      knownGeneV39.ucscScop.ucscId (via knownToMrnaSingle.name)
      mm10.bioCycPathway.kgID (via knownToMrnaSingle.name)
      mm10.ccdsKgMap.geneId (via knownToMrnaSingle.name)
      mm10.ceBlastTab.query (via knownToMrnaSingle.name)
      mm10.dmBlastTab.query (via knownToMrnaSingle.name)
      mm10.drBlastTab.query (via knownToMrnaSingle.name)
      mm10.foldUtr3.name (via knownToMrnaSingle.name)
      mm10.foldUtr5.name (via knownToMrnaSingle.name)
      mm10.hgBlastTab.query (via knownToMrnaSingle.name)
      mm10.keggPathway.kgID (via knownToMrnaSingle.name)
      mm10.kgAlias.kgID (via knownToMrnaSingle.name)
      mm10.kgColor.kgID (via knownToMrnaSingle.name)
      mm10.kgProtAlias.kgID (via knownToMrnaSingle.name)
      mm10.kgProtMap2.qName (via knownToMrnaSingle.name)
      mm10.kgSpAlias.kgID (via knownToMrnaSingle.name)
      mm10.kgTargetAli.qName (via knownToMrnaSingle.name)
      mm10.kgTxInfo.name (via knownToMrnaSingle.name)
      mm10.kgXref.kgID (via knownToMrnaSingle.name)
      mm10.knownAttrs.kgID (via knownToMrnaSingle.name)
      mm10.knownBlastTab.query (via knownToMrnaSingle.name)
      mm10.knownBlastTab.target (via knownToMrnaSingle.name)
      mm10.knownCanonical.transcript (via knownToMrnaSingle.name)
      mm10.knownCds.name (via knownToMrnaSingle.name)
      mm10.knownGene.name (via knownToMrnaSingle.name)
      mm10.knownGeneMrna.name (via knownToMrnaSingle.name)
      mm10.knownGenePep.name (via knownToMrnaSingle.name)
      mm10.knownIsoforms.transcript (via knownToMrnaSingle.name)
      mm10.knownToEnsembl.name (via knownToMrnaSingle.name)
      mm10.knownToKeggEntrez.name (via knownToMrnaSingle.name)
      mm10.knownToLocusLink.name (via knownToMrnaSingle.name)
      mm10.knownToLynx.name (via knownToMrnaSingle.name)
      mm10.knownToMrna.name (via knownToMrnaSingle.name)
      mm10.knownToPfam.name (via knownToMrnaSingle.name)
      mm10.knownToRefSeq.name (via knownToMrnaSingle.name)
      mm10.knownToSuper.gene (via knownToMrnaSingle.name)
      mm10.knownToTag.name (via knownToMrnaSingle.name)
      mm10.knownToVisiGene.name (via knownToMrnaSingle.name)
      mm10.knownToWikipedia.name (via knownToMrnaSingle.name)
      mm10.rnBlastTab.query (via knownToMrnaSingle.name)
      mm10.scBlastTab.query (via knownToMrnaSingle.name)
      mm10.ucscScop.ucscId (via knownToMrnaSingle.name)

Sample Rows
 
namevalue
ENSMUST00000179436.1AK002762
ENSMUST00000096791.11AF011412
ENSMUST00000071277.13AF011422
ENSMUST00000179115.1AF011412
ENSMUST00000099422.4AF011412
ENSMUST00000178970.7AF011422
ENSMUST00000082388.1AK142736
ENSMUST00000082390.1AK131596
ENSMUST00000082391.1BC052873
ENSMUST00000082392.1AK131578

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