Skip to main content
Schema for knownToGnfAtlas2
  Database: hg38    Primary Table: knownToGnfAtlas2    Row Count: 259,702   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 ENST00000361899.2varchar(255) values primary ID
value gnf1h00654_atvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000361899.2gnf1h00654_at
ENST00000625471.3207752_x_at
ENST00000620127.4207752_x_at
ENST00000628976.3207752_x_at
ENST00000753504.1215563_s_at
ENST00000753505.1215563_s_at
ENST00000614336.4212854_x_at
ENST00000612640.4212854_x_at
ENST00000632999.1215760_s_at
ENST00000631689.1215760_s_at

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