Skip to main content
Schema for knownToU95
  Database: hg38    Primary Table: knownToU95    Row Count: 168,910   Data last updated: 2025-09-26
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 ENST00000625471.3varchar(255) values primary ID
value 36774_f_atvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000625471.336774_f_at
ENST00000620127.436774_f_at
ENST00000628976.336774_f_at
ENST00000753504.140406_at
ENST00000753505.140406_at
ENST00000632999.137216_at
ENST00000631689.137216_at
ENST00000631951.137216_at
ENST00000622719.237216_at
ENST00000631752.136336_s_at

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