Schema for knownToU95
  Database: hg38    Primary Table: knownToU95    Row Count: 94,013   Data last updated: 2023-08-23
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 ENST00000615646.4varchar(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)
      hg38.affyU95.qName (via knownToU95.value)

Sample Rows
 
namevalue
ENST00000615646.436774_f_at
ENST00000625471.236774_f_at
ENST00000620127.336774_f_at
ENST00000628976.236774_f_at
ENST00000612920.232885_f_at
ENST00000612198.337216_at
ENST00000631948.137216_at
ENST00000622719.237216_at
ENST00000634172.137216_at
ENST00000631689.137216_at

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