Schema for knownToGnfAtlas2
  Database: hg17    Primary Table: knownToGnfAtlas2    Row Count: 32,458   Data last updated: 2005-10-27
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 NM_018390varchar(255) values primary ID
value 218951_s_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToGnfAtlas2.name)
      hg17.ccdsKgMap.geneId (via knownToGnfAtlas2.name)
      hg17.ceBlastTab.query (via knownToGnfAtlas2.name)
      hg17.dmBlastTab.query (via knownToGnfAtlas2.name)
      hg17.drBlastTab.query (via knownToGnfAtlas2.name)
      hg17.dupSpMrna.mrnaID (via knownToGnfAtlas2.name)
      hg17.foldUtr3.name (via knownToGnfAtlas2.name)
      hg17.foldUtr5.name (via knownToGnfAtlas2.name)
      hg17.gladHumESDistance.query (via knownToGnfAtlas2.name)
      hg17.gladHumESDistance.target (via knownToGnfAtlas2.name)
      hg17.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      hg17.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      hg17.gnfU95Distance.query (via knownToGnfAtlas2.name)
      hg17.gnfU95Distance.target (via knownToGnfAtlas2.name)
      hg17.humanHprdP2P.query (via knownToGnfAtlas2.name)
      hg17.humanHprdP2P.target (via knownToGnfAtlas2.name)
      hg17.humanVidalP2P.query (via knownToGnfAtlas2.name)
      hg17.humanVidalP2P.target (via knownToGnfAtlas2.name)
      hg17.humanWankerP2P.query (via knownToGnfAtlas2.name)
      hg17.humanWankerP2P.target (via knownToGnfAtlas2.name)
      hg17.keggPathway.kgID (via knownToGnfAtlas2.name)
      hg17.kgAlias.kgID (via knownToGnfAtlas2.name)
      hg17.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      hg17.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      hg17.kgTargetAli.qName (via knownToGnfAtlas2.name)
      hg17.kgXref.kgID (via knownToGnfAtlas2.name)
      hg17.knownBlastTab.query (via knownToGnfAtlas2.name)
      hg17.knownBlastTab.target (via knownToGnfAtlas2.name)
      hg17.knownCanonical.transcript (via knownToGnfAtlas2.name)
      hg17.knownExpDistance.query (via knownToGnfAtlas2.name)
      hg17.knownExpDistance.target (via knownToGnfAtlas2.name)
      hg17.knownGene.name (via knownToGnfAtlas2.name)
      hg17.knownGeneLink.name (via knownToGnfAtlas2.name)
      hg17.knownGeneMrna.name (via knownToGnfAtlas2.name)
      hg17.knownGenePep.name (via knownToGnfAtlas2.name)
      hg17.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      hg17.knownToAllenBrain.name (via knownToGnfAtlas2.name)
      hg17.knownToEnsembl.name (via knownToGnfAtlas2.name)
      hg17.knownToGnf1h.name (via knownToGnfAtlas2.name)
      hg17.knownToHInv.name (via knownToGnfAtlas2.name)
      hg17.knownToHprd.name (via knownToGnfAtlas2.name)
      hg17.knownToKeggEntrez.name (via knownToGnfAtlas2.name)
      hg17.knownToLocusLink.name (via knownToGnfAtlas2.name)
      hg17.knownToPfam.name (via knownToGnfAtlas2.name)
      hg17.knownToRefSeq.name (via knownToGnfAtlas2.name)
      hg17.knownToSuper.gene (via knownToGnfAtlas2.name)
      hg17.knownToU133.name (via knownToGnfAtlas2.name)
      hg17.knownToU133Plus2.name (via knownToGnfAtlas2.name)
      hg17.knownToU95.name (via knownToGnfAtlas2.name)
      hg17.knownToVisiGene.name (via knownToGnfAtlas2.name)
      hg17.mmBlastTab.query (via knownToGnfAtlas2.name)
      hg17.rankProp.query (via knownToGnfAtlas2.name)
      hg17.rankProp.target (via knownToGnfAtlas2.name)
      hg17.rnBlastTab.query (via knownToGnfAtlas2.name)
      hg17.scBlastTab.query (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)
      hg17.affyGnf1h.qName (via knownToGnfAtlas2.value)
      hg17.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
NM_018390218951_s_at
NM_000451207570_at
NM_006883207570_at
NM_002183206148_at
AK023392207288_at
NM_005088203624_at
L03426203624_at
BC028151203624_at
NM_004043206779_s_at
BC001620206779_s_at

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