Schema for knownToGnfAtlas2
  Database: hg38    Primary Table: knownToGnfAtlas2    Row Count: 154,797   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 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
ENST00000612198.3204166_at
ENST00000631948.1204166_at

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