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

Sample Rows
 
namevalue
ENSMUST00000082388.1AK140219
ENSMUST00000082388.1AK153841
ENSMUST00000082388.1AK142736
ENSMUST00000082388.1AK140265
ENSMUST00000082390.1AK131596
ENSMUST00000082390.1BC052873
ENSMUST00000082390.1AK153874
ENSMUST00000082390.1AK142700
ENSMUST00000082390.1AK131588
ENSMUST00000082390.1AK138995

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