Schema for keggPathway
  Database: mm9    Primary Table: keggPathway    Row Count: 40,563   Data last updated: 2011-05-03
Format description: KEGG pathway cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc008vfo.2varchar(40) values Known Gene ID
locusID 100017varchar(40) values LocusLink ID
mapID mmu04144varchar(40) values KEGG pathway map ID

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via keggPathway.kgID)
      knownGeneV39.ceBlastTab.query (via keggPathway.kgID)
      knownGeneV39.dmBlastTab.query (via keggPathway.kgID)
      knownGeneV39.drBlastTab.query (via keggPathway.kgID)
      knownGeneV39.foldUtr3.name (via keggPathway.kgID)
      knownGeneV39.foldUtr5.name (via keggPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via keggPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via keggPathway.kgID)
      knownGeneV39.kgAlias.kgID (via keggPathway.kgID)
      knownGeneV39.kgColor.kgID (via keggPathway.kgID)
      knownGeneV39.kgProtAlias.kgID (via keggPathway.kgID)
      knownGeneV39.kgSpAlias.kgID (via keggPathway.kgID)
      knownGeneV39.kgTargetAli.qName (via keggPathway.kgID)
      knownGeneV39.kgXref.kgID (via keggPathway.kgID)
      knownGeneV39.knownAttrs.kgID (via keggPathway.kgID)
      knownGeneV39.knownBlastTab.query (via keggPathway.kgID)
      knownGeneV39.knownBlastTab.target (via keggPathway.kgID)
      knownGeneV39.knownCanonical.protein (via keggPathway.kgID)
      knownGeneV39.knownCanonical.transcript (via keggPathway.kgID)
      knownGeneV39.knownCds.name (via keggPathway.kgID)
      knownGeneV39.knownGene.name (via keggPathway.kgID)
      knownGeneV39.knownGeneMrna.name (via keggPathway.kgID)
      knownGeneV39.knownGenePep.name (via keggPathway.kgID)
      knownGeneV39.knownIsoforms.transcript (via keggPathway.kgID)
      knownGeneV39.knownToEnsembl.name (via keggPathway.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via keggPathway.kgID)
      knownGeneV39.knownToHprd.name (via keggPathway.kgID)
      knownGeneV39.knownToLocusLink.name (via keggPathway.kgID)
      knownGeneV39.knownToMrna.name (via keggPathway.kgID)
      knownGeneV39.knownToMrnaSingle.name (via keggPathway.kgID)
      knownGeneV39.knownToMupit.name (via keggPathway.kgID)
      knownGeneV39.knownToPfam.name (via keggPathway.kgID)
      knownGeneV39.knownToRefSeq.name (via keggPathway.kgID)
      knownGeneV39.knownToSuper.gene (via keggPathway.kgID)
      knownGeneV39.knownToTag.name (via keggPathway.kgID)
      knownGeneV39.knownToU133.name (via keggPathway.kgID)
      knownGeneV39.knownToU95.name (via keggPathway.kgID)
      knownGeneV39.knownToVisiGene.name (via keggPathway.kgID)
      knownGeneV39.knownToWikipedia.name (via keggPathway.kgID)
      knownGeneV39.mmBlastTab.query (via keggPathway.kgID)
      knownGeneV39.rnBlastTab.query (via keggPathway.kgID)
      knownGeneV39.scBlastTab.query (via keggPathway.kgID)
      knownGeneV39.ucscScop.ucscId (via keggPathway.kgID)
      mm9.affyGnfU74ADistance.query (via keggPathway.kgID)
      mm9.affyGnfU74ADistance.target (via keggPathway.kgID)
      mm9.affyGnfU74BDistance.query (via keggPathway.kgID)
      mm9.affyGnfU74BDistance.target (via keggPathway.kgID)
      mm9.affyGnfU74CDistance.query (via keggPathway.kgID)
      mm9.affyGnfU74CDistance.target (via keggPathway.kgID)
      mm9.bioCycPathway.kgID (via keggPathway.kgID)
      mm9.ccdsKgMap.geneId (via keggPathway.kgID)
      mm9.ceBlastTab.query (via keggPathway.kgID)
      mm9.dmBlastTab.query (via keggPathway.kgID)
      mm9.drBlastTab.query (via keggPathway.kgID)
      mm9.foldUtr3.name (via keggPathway.kgID)
      mm9.foldUtr5.name (via keggPathway.kgID)
      mm9.gnfAtlas2Distance.query (via keggPathway.kgID)
      mm9.gnfAtlas2Distance.target (via keggPathway.kgID)
      mm9.hgBlastTab.query (via keggPathway.kgID)
      mm9.kgAlias.kgID (via keggPathway.kgID)
      mm9.kgColor.kgID (via keggPathway.kgID)
      mm9.kgProtAlias.kgID (via keggPathway.kgID)
      mm9.kgProtMap2.qName (via keggPathway.kgID)
      mm9.kgSpAlias.kgID (via keggPathway.kgID)
      mm9.kgTargetAli.qName (via keggPathway.kgID)
      mm9.kgTxInfo.name (via keggPathway.kgID)
      mm9.kgXref.kgID (via keggPathway.kgID)
      mm9.knownBlastTab.query (via keggPathway.kgID)
      mm9.knownBlastTab.target (via keggPathway.kgID)
      mm9.knownCanonical.protein (via keggPathway.kgID)
      mm9.knownCanonical.transcript (via keggPathway.kgID)
      mm9.knownGene.name (via keggPathway.kgID)
      mm9.knownGeneMrna.name (via keggPathway.kgID)
      mm9.knownGenePep.name (via keggPathway.kgID)
      mm9.knownIsoforms.transcript (via keggPathway.kgID)
      mm9.knownToAllenBrain.name (via keggPathway.kgID)
      mm9.knownToEnsembl.name (via keggPathway.kgID)
      mm9.knownToGnfAtlas2.name (via keggPathway.kgID)
      mm9.knownToKeggEntrez.name (via keggPathway.kgID)
      mm9.knownToLocusLink.name (via keggPathway.kgID)
      mm9.knownToPfam.name (via keggPathway.kgID)
      mm9.knownToRefSeq.name (via keggPathway.kgID)
      mm9.knownToSuper.gene (via keggPathway.kgID)
      mm9.knownToVisiGene.name (via keggPathway.kgID)
      mm9.rnBlastTab.query (via keggPathway.kgID)
      mm9.scBlastTab.query (via keggPathway.kgID)
      mm9.ucscScop.ucscId (via keggPathway.kgID)
      hgFixed.refLink.locusLinkId (via keggPathway.locusID)
      knownGeneV39.knownToLocusLink.value (via keggPathway.locusID)
      mm9.knownToLocusLink.value (via keggPathway.locusID)
      mm9.keggMapDesc.mapID (via keggPathway.mapID)
      mm9.knownToKeggEntrez.value (via keggPathway.mapID)

Sample Rows
 
kgIDlocusIDmapID
uc008vfo.2100017mmu04144
uc012dmx.1100017mmu04144
uc008sey.1100019mmu03008
uc008sez.1100019mmu03008
uc008sfa.1100019mmu03008
uc008sfb.1100019mmu03008
uc008sfc.1100019mmu03008
uc008sfd.1100019mmu03008
uc007uzd.2100037258mmu04141
uc008byd.1100038859mmu04740

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