Schema for knownToGnfAtlas2
  Database: mm7    Primary Table: knownToGnfAtlas2    Row Count: 22,296   Data last updated: 2005-11-17
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_008483varchar(255) values primary ID
value gnf1m01371_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)
      mm7.affyGnfU74ADistance.query (via knownToGnfAtlas2.name)
      mm7.affyGnfU74ADistance.target (via knownToGnfAtlas2.name)
      mm7.affyGnfU74BDistance.query (via knownToGnfAtlas2.name)
      mm7.affyGnfU74BDistance.target (via knownToGnfAtlas2.name)
      mm7.affyGnfU74CDistance.query (via knownToGnfAtlas2.name)
      mm7.affyGnfU74CDistance.target (via knownToGnfAtlas2.name)
      mm7.dmBlastTab.query (via knownToGnfAtlas2.name)
      mm7.drBlastTab.query (via knownToGnfAtlas2.name)
      mm7.dupSpMrna.mrnaID (via knownToGnfAtlas2.name)
      mm7.foldUtr3.name (via knownToGnfAtlas2.name)
      mm7.foldUtr5.name (via knownToGnfAtlas2.name)
      mm7.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      mm7.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      mm7.hgBlastTab.query (via knownToGnfAtlas2.name)
      mm7.keggPathway.kgID (via knownToGnfAtlas2.name)
      mm7.kgAlias.kgID (via knownToGnfAtlas2.name)
      mm7.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      mm7.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      mm7.kgXref.kgID (via knownToGnfAtlas2.name)
      mm7.knownBlastTab.query (via knownToGnfAtlas2.name)
      mm7.knownBlastTab.target (via knownToGnfAtlas2.name)
      mm7.knownCanonical.transcript (via knownToGnfAtlas2.name)
      mm7.knownGene.name (via knownToGnfAtlas2.name)
      mm7.knownGeneLink.name (via knownToGnfAtlas2.name)
      mm7.knownGeneMrna.name (via knownToGnfAtlas2.name)
      mm7.knownGenePep.name (via knownToGnfAtlas2.name)
      mm7.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      mm7.knownToAllenBrain.name (via knownToGnfAtlas2.name)
      mm7.knownToEnsembl.name (via knownToGnfAtlas2.name)
      mm7.knownToKeggEntrez.name (via knownToGnfAtlas2.name)
      mm7.knownToLocusLink.name (via knownToGnfAtlas2.name)
      mm7.knownToPfam.name (via knownToGnfAtlas2.name)
      mm7.knownToRefSeq.name (via knownToGnfAtlas2.name)
      mm7.knownToVisiGene.name (via knownToGnfAtlas2.name)
      mm7.rnBlastTab.query (via knownToGnfAtlas2.name)
      mm7.scBlastTab.query (via knownToGnfAtlas2.name)

Sample Rows
 
namevalue
NM_008483gnf1m01371_a_at
AK141751gnf1m04579_at
AK079850gnf1m25640_at
NM_001004153gnf1m29978_at
BC086454gnf1m29978_at
NM_030740gnf1m05611_a_at
AK030037gnf1m19278_at
NM_028245gnf1m05285_a_at
NM_011124gnf1m02750_a_at
NM_011888gnf1m03009_at

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