Schema for knownToMrnaSingle
  Database: mm39    Primary Table: knownToMrnaSingle    Row Count: 160,518   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 ENSMUST00000082388.1varchar(255) values primary ID
value AK142736varchar(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)
      mm39.bioCycPathway.kgID (via knownToMrnaSingle.name)
      mm39.ceBlastTab.query (via knownToMrnaSingle.name)
      mm39.dmBlastTab.query (via knownToMrnaSingle.name)
      mm39.drBlastTab.query (via knownToMrnaSingle.name)
      mm39.foldUtr3.name (via knownToMrnaSingle.name)
      mm39.foldUtr5.name (via knownToMrnaSingle.name)
      mm39.hgBlastTab.query (via knownToMrnaSingle.name)
      mm39.kgAlias.kgID (via knownToMrnaSingle.name)
      mm39.kgColor.kgID (via knownToMrnaSingle.name)
      mm39.kgProtAlias.kgID (via knownToMrnaSingle.name)
      mm39.kgSpAlias.kgID (via knownToMrnaSingle.name)
      mm39.kgTargetAli.qName (via knownToMrnaSingle.name)
      mm39.kgXref.kgID (via knownToMrnaSingle.name)
      mm39.knownAttrs.kgID (via knownToMrnaSingle.name)
      mm39.knownBlastTab.query (via knownToMrnaSingle.name)
      mm39.knownBlastTab.target (via knownToMrnaSingle.name)
      mm39.knownCanonical.transcript (via knownToMrnaSingle.name)
      mm39.knownCds.name (via knownToMrnaSingle.name)
      mm39.knownGene.name (via knownToMrnaSingle.name)
      mm39.knownGeneMrna.name (via knownToMrnaSingle.name)
      mm39.knownIsoforms.transcript (via knownToMrnaSingle.name)
      mm39.knownToEnsembl.name (via knownToMrnaSingle.name)
      mm39.knownToLocusLink.name (via knownToMrnaSingle.name)
      mm39.knownToMrna.name (via knownToMrnaSingle.name)
      mm39.knownToMupit.name (via knownToMrnaSingle.name)
      mm39.knownToNextProt.name (via knownToMrnaSingle.name)
      mm39.knownToPfam.name (via knownToMrnaSingle.name)
      mm39.knownToRefSeq.name (via knownToMrnaSingle.name)
      mm39.knownToSuper.gene (via knownToMrnaSingle.name)
      mm39.knownToTag.name (via knownToMrnaSingle.name)
      mm39.knownToVisiGene.name (via knownToMrnaSingle.name)
      mm39.knownToWikipedia.name (via knownToMrnaSingle.name)
      mm39.rnBlastTab.query (via knownToMrnaSingle.name)
      mm39.scBlastTab.query (via knownToMrnaSingle.name)
      mm39.ucscScop.ucscId (via knownToMrnaSingle.name)

Sample Rows
 
namevalue
ENSMUST00000082388.1AK142736
ENSMUST00000082390.1AK131596
ENSMUST00000082391.1BC052873
ENSMUST00000082392.1AK131578
ENSMUST00000082395.1AK139000
ENSMUST00000082396.1AK163440
ENSMUST00000082402.1AK166684
ENSMUST00000082404.1AF378830
ENSMUST00000082405.1AK131586
ENSMUST00000082406.1AK131587

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