Schema for knownToGnf1h
  Database: hg18    Primary Table: knownToGnf1h    Row Count: 14,011   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 uc004fpz.1varchar(255) values primary ID
value gnf1h01802_s_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToGnf1h.name)
      hg18.ccdsKgMap.geneId (via knownToGnf1h.name)
      hg18.ceBlastTab.query (via knownToGnf1h.name)
      hg18.dmBlastTab.query (via knownToGnf1h.name)
      hg18.drBlastTab.query (via knownToGnf1h.name)
      hg18.foldUtr3.name (via knownToGnf1h.name)
      hg18.foldUtr5.name (via knownToGnf1h.name)
      hg18.gnfAtlas2Distance.query (via knownToGnf1h.name)
      hg18.gnfAtlas2Distance.target (via knownToGnf1h.name)
      hg18.gnfU95Distance.query (via knownToGnf1h.name)
      hg18.gnfU95Distance.target (via knownToGnf1h.name)
      hg18.humanHprdP2P.query (via knownToGnf1h.name)
      hg18.humanHprdP2P.target (via knownToGnf1h.name)
      hg18.humanVidalP2P.query (via knownToGnf1h.name)
      hg18.humanVidalP2P.target (via knownToGnf1h.name)
      hg18.humanWankerP2P.query (via knownToGnf1h.name)
      hg18.humanWankerP2P.target (via knownToGnf1h.name)
      hg18.keggPathway.kgID (via knownToGnf1h.name)
      hg18.kgAlias.kgID (via knownToGnf1h.name)
      hg18.kgColor.kgID (via knownToGnf1h.name)
      hg18.kgProtAlias.kgID (via knownToGnf1h.name)
      hg18.kgProtMap2.qName (via knownToGnf1h.name)
      hg18.kgSpAlias.kgID (via knownToGnf1h.name)
      hg18.kgTargetAli.qName (via knownToGnf1h.name)
      hg18.kgTxInfo.name (via knownToGnf1h.name)
      hg18.kgXref.kgID (via knownToGnf1h.name)
      hg18.knownBlastTab.query (via knownToGnf1h.name)
      hg18.knownBlastTab.target (via knownToGnf1h.name)
      hg18.knownCanonToDecipher.name (via knownToGnf1h.name)
      hg18.knownCanonical.protein (via knownToGnf1h.name)
      hg18.knownCanonical.transcript (via knownToGnf1h.name)
      hg18.knownGene.name (via knownToGnf1h.name)
      hg18.knownGeneMrna.name (via knownToGnf1h.name)
      hg18.knownGenePep.name (via knownToGnf1h.name)
      hg18.knownIsoforms.transcript (via knownToGnf1h.name)
      hg18.knownToAllenBrain.name (via knownToGnf1h.name)
      hg18.knownToDecipher.name (via knownToGnf1h.name)
      hg18.knownToEnsembl.name (via knownToGnf1h.name)
      hg18.knownToGnfAtlas2.name (via knownToGnf1h.name)
      hg18.knownToHInv.name (via knownToGnf1h.name)
      hg18.knownToHprd.name (via knownToGnf1h.name)
      hg18.knownToKeggEntrez.name (via knownToGnf1h.name)
      hg18.knownToLocusLink.name (via knownToGnf1h.name)
      hg18.knownToMupit.name (via knownToGnf1h.name)
      hg18.knownToPfam.name (via knownToGnf1h.name)
      hg18.knownToRefSeq.name (via knownToGnf1h.name)
      hg18.knownToSuper.gene (via knownToGnf1h.name)
      hg18.knownToTreefam.name (via knownToGnf1h.name)
      hg18.knownToU133.name (via knownToGnf1h.name)
      hg18.knownToU133Plus2.name (via knownToGnf1h.name)
      hg18.knownToU95.name (via knownToGnf1h.name)
      hg18.knownToVisiGene.name (via knownToGnf1h.name)
      hg18.mmBlastTab.query (via knownToGnf1h.name)
      hg18.rnBlastTab.query (via knownToGnf1h.name)
      hg18.scBlastTab.query (via knownToGnf1h.name)
      hg18.ucscScop.ucscId (via knownToGnf1h.name)
      knownGeneV39.bioCycPathway.kgID (via knownToGnf1h.name)
      knownGeneV39.ceBlastTab.query (via knownToGnf1h.name)
      knownGeneV39.dmBlastTab.query (via knownToGnf1h.name)
      knownGeneV39.drBlastTab.query (via knownToGnf1h.name)
      knownGeneV39.foldUtr3.name (via knownToGnf1h.name)
      knownGeneV39.foldUtr5.name (via knownToGnf1h.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToGnf1h.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToGnf1h.name)
      knownGeneV39.kgAlias.kgID (via knownToGnf1h.name)
      knownGeneV39.kgColor.kgID (via knownToGnf1h.name)
      knownGeneV39.kgProtAlias.kgID (via knownToGnf1h.name)
      knownGeneV39.kgSpAlias.kgID (via knownToGnf1h.name)
      knownGeneV39.kgTargetAli.qName (via knownToGnf1h.name)
      knownGeneV39.kgXref.kgID (via knownToGnf1h.name)
      knownGeneV39.knownAttrs.kgID (via knownToGnf1h.name)
      knownGeneV39.knownBlastTab.query (via knownToGnf1h.name)
      knownGeneV39.knownBlastTab.target (via knownToGnf1h.name)
      knownGeneV39.knownCanonical.protein (via knownToGnf1h.name)
      knownGeneV39.knownCanonical.transcript (via knownToGnf1h.name)
      knownGeneV39.knownCds.name (via knownToGnf1h.name)
      knownGeneV39.knownGene.name (via knownToGnf1h.name)
      knownGeneV39.knownGeneMrna.name (via knownToGnf1h.name)
      knownGeneV39.knownGenePep.name (via knownToGnf1h.name)
      knownGeneV39.knownIsoforms.transcript (via knownToGnf1h.name)
      knownGeneV39.knownToEnsembl.name (via knownToGnf1h.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToGnf1h.name)
      knownGeneV39.knownToHprd.name (via knownToGnf1h.name)
      knownGeneV39.knownToLocusLink.name (via knownToGnf1h.name)
      knownGeneV39.knownToMrna.name (via knownToGnf1h.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToGnf1h.name)
      knownGeneV39.knownToMupit.name (via knownToGnf1h.name)
      knownGeneV39.knownToPfam.name (via knownToGnf1h.name)
      knownGeneV39.knownToRefSeq.name (via knownToGnf1h.name)
      knownGeneV39.knownToSuper.gene (via knownToGnf1h.name)
      knownGeneV39.knownToTag.name (via knownToGnf1h.name)
      knownGeneV39.knownToU133.name (via knownToGnf1h.name)
      knownGeneV39.knownToU95.name (via knownToGnf1h.name)
      knownGeneV39.knownToVisiGene.name (via knownToGnf1h.name)
      knownGeneV39.knownToWikipedia.name (via knownToGnf1h.name)
      knownGeneV39.mmBlastTab.query (via knownToGnf1h.name)
      knownGeneV39.rnBlastTab.query (via knownToGnf1h.name)
      knownGeneV39.scBlastTab.query (via knownToGnf1h.name)
      knownGeneV39.ucscScop.ucscId (via knownToGnf1h.name)

Sample Rows
 
namevalue
uc004fpz.1gnf1h01802_s_at
uc010nwa.1gnf1h01802_s_at
uc004fqa.1gnf1h01802_s_at
uc004fqb.1gnf1h01802_s_at
uc004fqe.1gnf1h06580_s_at
uc004fqf.1gnf1h06580_s_at
uc004fqi.1gnf1h06580_s_at
uc004fqk.1gnf1h07259_at
uc010nwf.1gnf1h07259_at
uc004fqw.1gnf1h05039_at

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