Schema for knownToGnfAtlas2
  Database: hg18    Primary Table: knownToGnfAtlas2    Row Count: 53,513   Data last updated: 2009-03-04
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 uc004fon.1varchar(255) values primary ID
value 218951_s_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToGnfAtlas2.name)
      hg18.ccdsKgMap.geneId (via knownToGnfAtlas2.name)
      hg18.ceBlastTab.query (via knownToGnfAtlas2.name)
      hg18.dmBlastTab.query (via knownToGnfAtlas2.name)
      hg18.drBlastTab.query (via knownToGnfAtlas2.name)
      hg18.foldUtr3.name (via knownToGnfAtlas2.name)
      hg18.foldUtr5.name (via knownToGnfAtlas2.name)
      hg18.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      hg18.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      hg18.gnfU95Distance.query (via knownToGnfAtlas2.name)
      hg18.gnfU95Distance.target (via knownToGnfAtlas2.name)
      hg18.humanHprdP2P.query (via knownToGnfAtlas2.name)
      hg18.humanHprdP2P.target (via knownToGnfAtlas2.name)
      hg18.humanVidalP2P.query (via knownToGnfAtlas2.name)
      hg18.humanVidalP2P.target (via knownToGnfAtlas2.name)
      hg18.humanWankerP2P.query (via knownToGnfAtlas2.name)
      hg18.humanWankerP2P.target (via knownToGnfAtlas2.name)
      hg18.keggPathway.kgID (via knownToGnfAtlas2.name)
      hg18.kgAlias.kgID (via knownToGnfAtlas2.name)
      hg18.kgColor.kgID (via knownToGnfAtlas2.name)
      hg18.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      hg18.kgProtMap2.qName (via knownToGnfAtlas2.name)
      hg18.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      hg18.kgTargetAli.qName (via knownToGnfAtlas2.name)
      hg18.kgTxInfo.name (via knownToGnfAtlas2.name)
      hg18.kgXref.kgID (via knownToGnfAtlas2.name)
      hg18.knownBlastTab.query (via knownToGnfAtlas2.name)
      hg18.knownBlastTab.target (via knownToGnfAtlas2.name)
      hg18.knownCanonToDecipher.name (via knownToGnfAtlas2.name)
      hg18.knownCanonical.protein (via knownToGnfAtlas2.name)
      hg18.knownCanonical.transcript (via knownToGnfAtlas2.name)
      hg18.knownGene.name (via knownToGnfAtlas2.name)
      hg18.knownGeneMrna.name (via knownToGnfAtlas2.name)
      hg18.knownGenePep.name (via knownToGnfAtlas2.name)
      hg18.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      hg18.knownToAllenBrain.name (via knownToGnfAtlas2.name)
      hg18.knownToDecipher.name (via knownToGnfAtlas2.name)
      hg18.knownToEnsembl.name (via knownToGnfAtlas2.name)
      hg18.knownToGnf1h.name (via knownToGnfAtlas2.name)
      hg18.knownToHInv.name (via knownToGnfAtlas2.name)
      hg18.knownToHprd.name (via knownToGnfAtlas2.name)
      hg18.knownToKeggEntrez.name (via knownToGnfAtlas2.name)
      hg18.knownToLocusLink.name (via knownToGnfAtlas2.name)
      hg18.knownToMupit.name (via knownToGnfAtlas2.name)
      hg18.knownToPfam.name (via knownToGnfAtlas2.name)
      hg18.knownToRefSeq.name (via knownToGnfAtlas2.name)
      hg18.knownToSuper.gene (via knownToGnfAtlas2.name)
      hg18.knownToTreefam.name (via knownToGnfAtlas2.name)
      hg18.knownToU133.name (via knownToGnfAtlas2.name)
      hg18.knownToU133Plus2.name (via knownToGnfAtlas2.name)
      hg18.knownToU95.name (via knownToGnfAtlas2.name)
      hg18.knownToVisiGene.name (via knownToGnfAtlas2.name)
      hg18.mmBlastTab.query (via knownToGnfAtlas2.name)
      hg18.rnBlastTab.query (via knownToGnfAtlas2.name)
      hg18.scBlastTab.query (via knownToGnfAtlas2.name)
      hg18.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)
      hg18.affyGnf1h.qName (via knownToGnfAtlas2.value)
      hg18.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
uc004fon.1218951_s_at
uc004foo.1218951_s_at
uc004fop.1218951_s_at
uc004fou.1207570_at
uc004fov.1207570_at
uc004fpa.1210340_s_at
uc004fpb.1210340_s_at
uc004fpc.1210340_s_at
uc004fpd.1210340_s_at
uc010nvt.1210340_s_at

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