Schema for keggPathway
  Database: hg16    Primary Table: keggPathway    Row Count: 4,897   Data last updated: 2004-03-27
Format description: KEGG pathway cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000616varchar(40) values Known Gene ID
locusID 11320varchar(40) values LocusLink ID
mapID hsa00510varchar(40) values KEGG pathway map ID

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via keggPathway.kgID)
      hg16.dmBlastTab.query (via keggPathway.kgID)
      hg16.drBlastTab.query (via keggPathway.kgID)
      hg16.dupSpMrna.mrnaID (via keggPathway.kgID)
      hg16.foldUtr3.name (via keggPathway.kgID)
      hg16.foldUtr5.name (via keggPathway.kgID)
      hg16.gnfAtlas2Distance.query (via keggPathway.kgID)
      hg16.gnfAtlas2Distance.target (via keggPathway.kgID)
      hg16.gnfU95Distance.query (via keggPathway.kgID)
      hg16.gnfU95Distance.target (via keggPathway.kgID)
      hg16.hg17Kg.name (via keggPathway.kgID)
      hg16.kgAlias.kgID (via keggPathway.kgID)
      hg16.kgProtAlias.kgID (via keggPathway.kgID)
      hg16.kgXref.kgID (via keggPathway.kgID)
      hg16.knownBlastTab.query (via keggPathway.kgID)
      hg16.knownBlastTab.target (via keggPathway.kgID)
      hg16.knownCanonical.transcript (via keggPathway.kgID)
      hg16.knownGene.name (via keggPathway.kgID)
      hg16.knownGeneLink.name (via keggPathway.kgID)
      hg16.knownGeneMrna.name (via keggPathway.kgID)
      hg16.knownGenePep.name (via keggPathway.kgID)
      hg16.knownIsoforms.transcript (via keggPathway.kgID)
      hg16.knownToEnsembl.name (via keggPathway.kgID)
      hg16.knownToGnfAtlas2.name (via keggPathway.kgID)
      hg16.knownToHInv.name (via keggPathway.kgID)
      hg16.knownToLocusLink.name (via keggPathway.kgID)
      hg16.knownToPfam.name (via keggPathway.kgID)
      hg16.knownToRefSeq.name (via keggPathway.kgID)
      hg16.knownToSuper.gene (via keggPathway.kgID)
      hg16.knownToU133.name (via keggPathway.kgID)
      hg16.knownToU95.name (via keggPathway.kgID)
      hg16.scBlastTab.query (via keggPathway.kgID)
      hg16.knownToLocusLink.value (via keggPathway.locusID)
      hgFixed.refLink.locusLinkId (via keggPathway.locusID)
      hg16.keggMapDesc.mapID (via keggPathway.mapID)

Sample Rows
 
kgIDlocusIDmapID
AB00061611320hsa00510
AB00082411181hsa00500
AB0018729175hsa04010
AB0020972255hsa04010
AB0023329575hsa04710
AB0023458864hsa04710
AB0023468871hsa04070
AB0023595198hsa00230
AB0023679201hsa00500
AB0023679201hsa00600

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