Schema for knownToMrna
  Database: mm10    Primary Table: knownToMrna    Row Count: 1,300,038   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 description
name ENSMUST00000179436.1varchar(255) primary ID
value AK002762varchar(255) associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENSMUST00000179436.1AK002762
ENSMUST00000096791.11AF011412
ENSMUST00000096791.11BC038260
ENSMUST00000096791.11AF011422
ENSMUST00000096791.11BC166002
ENSMUST00000071277.13AF011412
ENSMUST00000071277.13BC038260
ENSMUST00000071277.13AF011422
ENSMUST00000071277.13BC166002
ENSMUST00000179115.1AF011412

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