Schema for keggPathway
  Database: rn3    Primary Table: keggPathway    Row Count: 1,131   Data last updated: 2004-03-23
Format description: KEGG pathway cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000491varchar(40) values Known Gene ID
locusID 81827varchar(40) values LocusLink ID
mapID rno03050varchar(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)
      rn3.dmBlastTab.query (via keggPathway.kgID)
      rn3.drBlastTab.query (via keggPathway.kgID)
      rn3.dupSpMrna.mrnaID (via keggPathway.kgID)
      rn3.gnfAtlas2Distance.query (via keggPathway.kgID)
      rn3.gnfAtlas2Distance.target (via keggPathway.kgID)
      rn3.hgBlastTab.query (via keggPathway.kgID)
      rn3.kgAlias.kgID (via keggPathway.kgID)
      rn3.kgProtAlias.kgID (via keggPathway.kgID)
      rn3.kgSpAlias.kgID (via keggPathway.kgID)
      rn3.kgXref.kgID (via keggPathway.kgID)
      rn3.knownBlastTab.query (via keggPathway.kgID)
      rn3.knownBlastTab.target (via keggPathway.kgID)
      rn3.knownCanonical.transcript (via keggPathway.kgID)
      rn3.knownGene.name (via keggPathway.kgID)
      rn3.knownGeneLink.name (via keggPathway.kgID)
      rn3.knownGeneMrna.name (via keggPathway.kgID)
      rn3.knownGenePep.name (via keggPathway.kgID)
      rn3.knownIsoforms.transcript (via keggPathway.kgID)
      rn3.knownToEnsembl.name (via keggPathway.kgID)
      rn3.knownToGnfAtlas2.name (via keggPathway.kgID)
      rn3.knownToLocusLink.name (via keggPathway.kgID)
      rn3.knownToPfam.name (via keggPathway.kgID)
      rn3.knownToRefSeq.name (via keggPathway.kgID)
      rn3.knownToSuper.gene (via keggPathway.kgID)
      rn3.scBlastTab.query (via keggPathway.kgID)
      hgFixed.refLink.locusLinkId (via keggPathway.locusID)
      knownGeneV39.knownToLocusLink.value (via keggPathway.locusID)
      rn3.knownToLocusLink.value (via keggPathway.locusID)
      rn3.keggMapDesc.mapID (via keggPathway.mapID)

Sample Rows
 
kgIDlocusIDmapID
AB00049181827rno03050
AB00239429301rno00340
AB00255860666rno00561
AB003400114027rno00260
AB003400114027rno00472
AB003478171079rno00604
AB004329116719rno00061
AB004329116719rno00640
AB00613781919rno00601
AB00613781919rno00603

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