Schema for knownToMrna
  Database: hg38    Primary Table: knownToMrna    Row Count: 6,804,665   Data last updated: 2024-08-19
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 ENST00000387314.1varchar(255) primary ID
value LP895143varchar(255) associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via knownToMrna.name)
      hg38.ccdsKgMap.geneId (via knownToMrna.name)
      hg38.ceBlastTab.query (via knownToMrna.name)
      hg38.dmBlastTab.query (via knownToMrna.name)
      hg38.drBlastTab.query (via knownToMrna.name)
      hg38.foldUtr3.name (via knownToMrna.name)
      hg38.foldUtr5.name (via knownToMrna.name)
      hg38.gnfAtlas2Distance.query (via knownToMrna.name)
      hg38.gnfAtlas2Distance.target (via knownToMrna.name)
      hg38.gnfU95Distance.query (via knownToMrna.name)
      hg38.gnfU95Distance.target (via knownToMrna.name)
      hg38.humanHprdP2P.query (via knownToMrna.name)
      hg38.humanHprdP2P.target (via knownToMrna.name)
      hg38.humanVidalP2P.query (via knownToMrna.name)
      hg38.humanVidalP2P.target (via knownToMrna.name)
      hg38.humanWankerP2P.query (via knownToMrna.name)
      hg38.humanWankerP2P.target (via knownToMrna.name)
      hg38.keggPathway.kgID (via knownToMrna.name)
      hg38.kgAlias.kgID (via knownToMrna.name)
      hg38.kgColor.kgID (via knownToMrna.name)
      hg38.kgProtAlias.kgID (via knownToMrna.name)
      hg38.kgSpAlias.kgID (via knownToMrna.name)
      hg38.kgTargetAli.qName (via knownToMrna.name)
      hg38.kgXref.kgID (via knownToMrna.name)
      hg38.knownAttrs.kgID (via knownToMrna.name)
      hg38.knownBlastTab.query (via knownToMrna.name)
      hg38.knownBlastTab.target (via knownToMrna.name)
      hg38.knownCanonical.transcript (via knownToMrna.name)
      hg38.knownCds.name (via knownToMrna.name)
      hg38.knownGene.name (via knownToMrna.name)
      hg38.knownGeneMrna.name (via knownToMrna.name)
      hg38.knownGenePep.name (via knownToMrna.name)
      hg38.knownIsoforms.transcript (via knownToMrna.name)
      hg38.knownToEnsembl.name (via knownToMrna.name)
      hg38.knownToGnfAtlas2.name (via knownToMrna.name)
      hg38.knownToHprd.name (via knownToMrna.name)
      hg38.knownToKeggEntrez.name (via knownToMrna.name)
      hg38.knownToLocusLink.name (via knownToMrna.name)
      hg38.knownToLynx.name (via knownToMrna.name)
      hg38.knownToMrnaSingle.name (via knownToMrna.name)
      hg38.knownToMupit.name (via knownToMrna.name)
      hg38.knownToNextProt.name (via knownToMrna.name)
      hg38.knownToPfam.name (via knownToMrna.name)
      hg38.knownToRefSeq.name (via knownToMrna.name)
      hg38.knownToSuper.gene (via knownToMrna.name)
      hg38.knownToTag.name (via knownToMrna.name)
      hg38.knownToU133.name (via knownToMrna.name)
      hg38.knownToU95.name (via knownToMrna.name)
      hg38.knownToVisiGene.name (via knownToMrna.name)
      hg38.knownToWikipedia.name (via knownToMrna.name)
      hg38.mmBlastTab.query (via knownToMrna.name)
      hg38.rnBlastTab.query (via knownToMrna.name)
      hg38.scBlastTab.query (via knownToMrna.name)
      hg38.ucscScop.ucscId (via knownToMrna.name)
      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)

Sample Rows
 
namevalue
ENST00000387314.1LP895143
ENST00000387314.1DQ598675
ENST00000387314.1JB137817
ENST00000387314.1MK671731
ENST00000389680.2LP895143
ENST00000389680.2JB137817
ENST00000389680.2DQ571525
ENST00000389680.2DQ571526
ENST00000389680.2HI965324
ENST00000389680.2HV555498

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