Schema for knownToGnf1h
  Database: hg17    Primary Table: knownToGnf1h    Row Count: 8,847   Data last updated: 2005-06-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 NM_002414varchar(255) values primary ID
value gnf1h01802_s_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToGnf1h.name)
      hg17.ccdsKgMap.geneId (via knownToGnf1h.name)
      hg17.ceBlastTab.query (via knownToGnf1h.name)
      hg17.dmBlastTab.query (via knownToGnf1h.name)
      hg17.drBlastTab.query (via knownToGnf1h.name)
      hg17.dupSpMrna.mrnaID (via knownToGnf1h.name)
      hg17.foldUtr3.name (via knownToGnf1h.name)
      hg17.foldUtr5.name (via knownToGnf1h.name)
      hg17.gladHumESDistance.query (via knownToGnf1h.name)
      hg17.gladHumESDistance.target (via knownToGnf1h.name)
      hg17.gnfAtlas2Distance.query (via knownToGnf1h.name)
      hg17.gnfAtlas2Distance.target (via knownToGnf1h.name)
      hg17.gnfU95Distance.query (via knownToGnf1h.name)
      hg17.gnfU95Distance.target (via knownToGnf1h.name)
      hg17.humanHprdP2P.query (via knownToGnf1h.name)
      hg17.humanHprdP2P.target (via knownToGnf1h.name)
      hg17.humanVidalP2P.query (via knownToGnf1h.name)
      hg17.humanVidalP2P.target (via knownToGnf1h.name)
      hg17.humanWankerP2P.query (via knownToGnf1h.name)
      hg17.humanWankerP2P.target (via knownToGnf1h.name)
      hg17.keggPathway.kgID (via knownToGnf1h.name)
      hg17.kgAlias.kgID (via knownToGnf1h.name)
      hg17.kgProtAlias.kgID (via knownToGnf1h.name)
      hg17.kgSpAlias.kgID (via knownToGnf1h.name)
      hg17.kgTargetAli.qName (via knownToGnf1h.name)
      hg17.kgXref.kgID (via knownToGnf1h.name)
      hg17.knownBlastTab.query (via knownToGnf1h.name)
      hg17.knownBlastTab.target (via knownToGnf1h.name)
      hg17.knownCanonical.transcript (via knownToGnf1h.name)
      hg17.knownExpDistance.query (via knownToGnf1h.name)
      hg17.knownExpDistance.target (via knownToGnf1h.name)
      hg17.knownGene.name (via knownToGnf1h.name)
      hg17.knownGeneLink.name (via knownToGnf1h.name)
      hg17.knownGeneMrna.name (via knownToGnf1h.name)
      hg17.knownGenePep.name (via knownToGnf1h.name)
      hg17.knownIsoforms.transcript (via knownToGnf1h.name)
      hg17.knownToAllenBrain.name (via knownToGnf1h.name)
      hg17.knownToEnsembl.name (via knownToGnf1h.name)
      hg17.knownToGnfAtlas2.name (via knownToGnf1h.name)
      hg17.knownToHInv.name (via knownToGnf1h.name)
      hg17.knownToHprd.name (via knownToGnf1h.name)
      hg17.knownToKeggEntrez.name (via knownToGnf1h.name)
      hg17.knownToLocusLink.name (via knownToGnf1h.name)
      hg17.knownToPfam.name (via knownToGnf1h.name)
      hg17.knownToRefSeq.name (via knownToGnf1h.name)
      hg17.knownToSuper.gene (via knownToGnf1h.name)
      hg17.knownToU133.name (via knownToGnf1h.name)
      hg17.knownToU133Plus2.name (via knownToGnf1h.name)
      hg17.knownToU95.name (via knownToGnf1h.name)
      hg17.knownToVisiGene.name (via knownToGnf1h.name)
      hg17.mmBlastTab.query (via knownToGnf1h.name)
      hg17.rankProp.query (via knownToGnf1h.name)
      hg17.rankProp.target (via knownToGnf1h.name)
      hg17.rnBlastTab.query (via knownToGnf1h.name)
      hg17.scBlastTab.query (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
NM_002414gnf1h01802_s_at
CR599762gnf1h01802_s_at
NM_001008gnf1h06580_s_at
NM_139214gnf1h07259_at
NM_033284gnf1h09521_s_at
AF332241gnf1h00550_at
BC026100gnf1h00831_at
NM_033108gnf1h01080_at
NM_001001871gnf1h05040_at
NM_152584gnf1h05040_at

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