Schema for keggPathway
  Database: mm8    Primary Table: keggPathway    Row Count: 22,131   Data last updated: 2010-06-18
Format description: KEGG pathway cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID NM_145554varchar(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)
      mm8.affyGnfU74ADistance.query (via keggPathway.kgID)
      mm8.affyGnfU74ADistance.target (via keggPathway.kgID)
      mm8.affyGnfU74BDistance.query (via keggPathway.kgID)
      mm8.affyGnfU74BDistance.target (via keggPathway.kgID)
      mm8.affyGnfU74CDistance.query (via keggPathway.kgID)
      mm8.affyGnfU74CDistance.target (via keggPathway.kgID)
      mm8.ccdsKgMap.geneId (via keggPathway.kgID)
      mm8.ceBlastTab.query (via keggPathway.kgID)
      mm8.dmBlastTab.query (via keggPathway.kgID)
      mm8.drBlastTab.query (via keggPathway.kgID)
      mm8.dupSpMrna.mrnaID (via keggPathway.kgID)
      mm8.foldUtr3.name (via keggPathway.kgID)
      mm8.foldUtr5.name (via keggPathway.kgID)
      mm8.gnfAtlas2Distance.query (via keggPathway.kgID)
      mm8.gnfAtlas2Distance.target (via keggPathway.kgID)
      mm8.hgBlastTab.query (via keggPathway.kgID)
      mm8.kgAlias.kgID (via keggPathway.kgID)
      mm8.kgProtAlias.kgID (via keggPathway.kgID)
      mm8.kgSpAlias.kgID (via keggPathway.kgID)
      mm8.kgTargetAli.qName (via keggPathway.kgID)
      mm8.kgXref.kgID (via keggPathway.kgID)
      mm8.knownBlastTab.query (via keggPathway.kgID)
      mm8.knownBlastTab.target (via keggPathway.kgID)
      mm8.knownCanonical.transcript (via keggPathway.kgID)
      mm8.knownGene.name (via keggPathway.kgID)
      mm8.knownGeneMrna.name (via keggPathway.kgID)
      mm8.knownGenePep.name (via keggPathway.kgID)
      mm8.knownIsoforms.transcript (via keggPathway.kgID)
      mm8.knownToAllenBrain.name (via keggPathway.kgID)
      mm8.knownToEnsembl.name (via keggPathway.kgID)
      mm8.knownToGnfAtlas2.name (via keggPathway.kgID)
      mm8.knownToKeggEntrez.name (via keggPathway.kgID)
      mm8.knownToLocusLink.name (via keggPathway.kgID)
      mm8.knownToPfam.name (via keggPathway.kgID)
      mm8.knownToRefSeq.name (via keggPathway.kgID)
      mm8.knownToSuper.gene (via keggPathway.kgID)
      mm8.knownToVisiGene.name (via keggPathway.kgID)
      mm8.rnBlastTab.query (via keggPathway.kgID)
      mm8.scBlastTab.query (via keggPathway.kgID)
      hgFixed.refLink.locusLinkId (via keggPathway.locusID)
      knownGeneV39.knownToLocusLink.value (via keggPathway.locusID)
      mm8.knownToLocusLink.value (via keggPathway.locusID)
      mm8.keggMapDesc.mapID (via keggPathway.mapID)
      mm8.knownToKeggEntrez.value (via keggPathway.mapID)

Sample Rows
 
kgIDlocusIDmapID
NM_145554100017mmu04144
BC066808100017mmu04144
NM_001004141100066mmu00590
NM_001004141100066mmu00591
NM_001004141100066mmu01100
NM_133880100163mmu00565
NM_133880100163mmu01100
BC042677100198mmu00030
NM_173371100198mmu00030
BC042677100198mmu01100

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