Schema for knownToGnfAtlas2
  Database: mm9    Primary Table: knownToGnfAtlas2    Row Count: 38,970   Data last updated: 2011-03-03
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 uc012hsu.1varchar(255) values primary ID
value gnf1m15448_a_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        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)
      mm9.affyGnfU74ADistance.query (via knownToGnfAtlas2.name)
      mm9.affyGnfU74ADistance.target (via knownToGnfAtlas2.name)
      mm9.affyGnfU74BDistance.query (via knownToGnfAtlas2.name)
      mm9.affyGnfU74BDistance.target (via knownToGnfAtlas2.name)
      mm9.affyGnfU74CDistance.query (via knownToGnfAtlas2.name)
      mm9.affyGnfU74CDistance.target (via knownToGnfAtlas2.name)
      mm9.bioCycPathway.kgID (via knownToGnfAtlas2.name)
      mm9.ccdsKgMap.geneId (via knownToGnfAtlas2.name)
      mm9.ceBlastTab.query (via knownToGnfAtlas2.name)
      mm9.dmBlastTab.query (via knownToGnfAtlas2.name)
      mm9.drBlastTab.query (via knownToGnfAtlas2.name)
      mm9.foldUtr3.name (via knownToGnfAtlas2.name)
      mm9.foldUtr5.name (via knownToGnfAtlas2.name)
      mm9.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      mm9.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      mm9.hgBlastTab.query (via knownToGnfAtlas2.name)
      mm9.keggPathway.kgID (via knownToGnfAtlas2.name)
      mm9.kgAlias.kgID (via knownToGnfAtlas2.name)
      mm9.kgColor.kgID (via knownToGnfAtlas2.name)
      mm9.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      mm9.kgProtMap2.qName (via knownToGnfAtlas2.name)
      mm9.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      mm9.kgTargetAli.qName (via knownToGnfAtlas2.name)
      mm9.kgTxInfo.name (via knownToGnfAtlas2.name)
      mm9.kgXref.kgID (via knownToGnfAtlas2.name)
      mm9.knownBlastTab.query (via knownToGnfAtlas2.name)
      mm9.knownBlastTab.target (via knownToGnfAtlas2.name)
      mm9.knownCanonical.protein (via knownToGnfAtlas2.name)
      mm9.knownCanonical.transcript (via knownToGnfAtlas2.name)
      mm9.knownGene.name (via knownToGnfAtlas2.name)
      mm9.knownGeneMrna.name (via knownToGnfAtlas2.name)
      mm9.knownGenePep.name (via knownToGnfAtlas2.name)
      mm9.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      mm9.knownToAllenBrain.name (via knownToGnfAtlas2.name)
      mm9.knownToEnsembl.name (via knownToGnfAtlas2.name)
      mm9.knownToKeggEntrez.name (via knownToGnfAtlas2.name)
      mm9.knownToLocusLink.name (via knownToGnfAtlas2.name)
      mm9.knownToPfam.name (via knownToGnfAtlas2.name)
      mm9.knownToRefSeq.name (via knownToGnfAtlas2.name)
      mm9.knownToSuper.gene (via knownToGnfAtlas2.name)
      mm9.knownToVisiGene.name (via knownToGnfAtlas2.name)
      mm9.rnBlastTab.query (via knownToGnfAtlas2.name)
      mm9.scBlastTab.query (via knownToGnfAtlas2.name)
      mm9.ucscScop.ucscId (via knownToGnfAtlas2.name)

Sample Rows
 
namevalue
uc012hsu.1gnf1m15448_a_at
uc009vhq.1gnf1m23851_a_at
uc009vht.1gnf1m02907_a_at
uc009vhu.1gnf1m02907_a_at
uc012hsj.1gnf1m14542_a_at
uc009vfv.1gnf1m01774_x_at
uc009vfw.1gnf1m01774_x_at
uc009vfx.1gnf1m23851_a_at
uc012hsp.1gnf1m22677_s_at
uc009vgj.1gnf1m15448_a_at

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