Schema for knownToMrnaSingle
  Database: hg38    Primary Table: knownToMrnaSingle    Row Count: 222,448   Data last updated: 2023-08-22
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 ENST00000387314.1varchar(255) values primary ID
value DQ598675varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000387314.1DQ598675
ENST00000389680.2MS906565
ENST00000387342.1DQ582264
ENST00000387347.2LF641695
ENST00000386347.1AB026838
ENST00000361390.2AK074482
ENST00000387365.1AB043958
ENST00000387377.1AK074482
ENST00000361453.3AK074482
ENST00000387382.1S75895

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