Schema for knownToGnfAtlas2
  Database: hg19    Primary Table: knownToGnfAtlas2    Row Count: 144,685   Data last updated: 2024-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 ENST00000361899.2_2varchar(255) values primary ID
value gnf1h00654_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToGnfAtlas2.name)
      hg19.ceBlastTab.query (via knownToGnfAtlas2.name)
      hg19.dmBlastTab.query (via knownToGnfAtlas2.name)
      hg19.drBlastTab.query (via knownToGnfAtlas2.name)
      hg19.foldUtr3.name (via knownToGnfAtlas2.name)
      hg19.foldUtr5.name (via knownToGnfAtlas2.name)
      hg19.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      hg19.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      hg19.gnfU95Distance.query (via knownToGnfAtlas2.name)
      hg19.gnfU95Distance.target (via knownToGnfAtlas2.name)
      hg19.humanHprdP2P.query (via knownToGnfAtlas2.name)
      hg19.humanHprdP2P.target (via knownToGnfAtlas2.name)
      hg19.humanVidalP2P.query (via knownToGnfAtlas2.name)
      hg19.humanVidalP2P.target (via knownToGnfAtlas2.name)
      hg19.humanWankerP2P.query (via knownToGnfAtlas2.name)
      hg19.humanWankerP2P.target (via knownToGnfAtlas2.name)
      hg19.keggPathway.kgID (via knownToGnfAtlas2.name)
      hg19.kgAlias.kgID (via knownToGnfAtlas2.name)
      hg19.kgColor.kgID (via knownToGnfAtlas2.name)
      hg19.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      hg19.kgProtMap2.qName (via knownToGnfAtlas2.name)
      hg19.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      hg19.kgTargetAli.qName (via knownToGnfAtlas2.name)
      hg19.kgTxInfo.name (via knownToGnfAtlas2.name)
      hg19.kgXref.kgID (via knownToGnfAtlas2.name)
      hg19.knownAttrs.kgID (via knownToGnfAtlas2.name)
      hg19.knownBlastTab.query (via knownToGnfAtlas2.name)
      hg19.knownBlastTab.target (via knownToGnfAtlas2.name)
      hg19.knownCanonToDecipher.name (via knownToGnfAtlas2.name)
      hg19.knownCanonical.transcript (via knownToGnfAtlas2.name)
      hg19.knownCds.name (via knownToGnfAtlas2.name)
      hg19.knownGene.name (via knownToGnfAtlas2.name)
      hg19.knownGeneMrna.name (via knownToGnfAtlas2.name)
      hg19.knownGenePep.name (via knownToGnfAtlas2.name)
      hg19.knownGeneTxMrna.name (via knownToGnfAtlas2.name)
      hg19.knownGeneTxPep.name (via knownToGnfAtlas2.name)
      hg19.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      hg19.knownToAllenBrain.name (via knownToGnfAtlas2.name)
      hg19.knownToDecipher.name (via knownToGnfAtlas2.name)
      hg19.knownToEnsembl.name (via knownToGnfAtlas2.name)
      hg19.knownToHInv.name (via knownToGnfAtlas2.name)
      hg19.knownToHprd.name (via knownToGnfAtlas2.name)
      hg19.knownToKeggEntrez.name (via knownToGnfAtlas2.name)
      hg19.knownToLocusLink.name (via knownToGnfAtlas2.name)
      hg19.knownToLynx.name (via knownToGnfAtlas2.name)
      hg19.knownToMrna.name (via knownToGnfAtlas2.name)
      hg19.knownToMrnaSingle.name (via knownToGnfAtlas2.name)
      hg19.knownToMupit.name (via knownToGnfAtlas2.name)
      hg19.knownToNextProt.name (via knownToGnfAtlas2.name)
      hg19.knownToPfam.name (via knownToGnfAtlas2.name)
      hg19.knownToRefSeq.name (via knownToGnfAtlas2.name)
      hg19.knownToSuper.gene (via knownToGnfAtlas2.name)
      hg19.knownToTag.name (via knownToGnfAtlas2.name)
      hg19.knownToTreefam.name (via knownToGnfAtlas2.name)
      hg19.knownToU133.name (via knownToGnfAtlas2.name)
      hg19.knownToU133Plus2.name (via knownToGnfAtlas2.name)
      hg19.knownToU95.name (via knownToGnfAtlas2.name)
      hg19.knownToVisiGene.name (via knownToGnfAtlas2.name)
      hg19.knownToWikipedia.name (via knownToGnfAtlas2.name)
      hg19.mmBlastTab.query (via knownToGnfAtlas2.name)
      hg19.rnBlastTab.query (via knownToGnfAtlas2.name)
      hg19.scBlastTab.query (via knownToGnfAtlas2.name)
      hg19.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)
      hg19.affyGnf1h.qName (via knownToGnfAtlas2.value)
      hg19.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.2_2gnf1h00654_at
ENST00000620442.4_2gnf1h02552_s_at
ENST00000299443.6_4gnf1h02552_s_at
ENST00000623131.1_3gnf1h01903_x_at
ENST00000431297.1_2gnf1h01903_x_at
ENST00000461088.1_1gnf1h01348_at
ENST00000468788.5_1gnf1h01348_at
ENST00000475864.1_1gnf1h01348_at
ENST00000495055.1_1gnf1h01348_at
ENST00000468643.5_1gnf1h01348_at

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