Schema for bioCycPathway
  Database: hg17    Primary Table: bioCycPathway    Row Count: 947   Data last updated: 2005-06-05
Format description: BioCyc Pathway to Known Gene cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB020635varchar(40) values Known Gene ID
geneID ENSG00000158467varchar(40) values Gene (RefSeq) ID
mapID ADENOSYLHOMOCYSCAT-PWYvarchar(40) values BioCyc pathway map ID

Connected Tables and Joining Fields
        hg17.ccdsKgMap.geneId (via bioCycPathway.kgID)
      hg17.ceBlastTab.query (via bioCycPathway.kgID)
      hg17.dmBlastTab.query (via bioCycPathway.kgID)
      hg17.drBlastTab.query (via bioCycPathway.kgID)
      hg17.dupSpMrna.mrnaID (via bioCycPathway.kgID)
      hg17.foldUtr3.name (via bioCycPathway.kgID)
      hg17.foldUtr5.name (via bioCycPathway.kgID)
      hg17.gladHumESDistance.query (via bioCycPathway.kgID)
      hg17.gladHumESDistance.target (via bioCycPathway.kgID)
      hg17.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      hg17.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      hg17.gnfU95Distance.query (via bioCycPathway.kgID)
      hg17.gnfU95Distance.target (via bioCycPathway.kgID)
      hg17.humanHprdP2P.query (via bioCycPathway.kgID)
      hg17.humanHprdP2P.target (via bioCycPathway.kgID)
      hg17.humanVidalP2P.query (via bioCycPathway.kgID)
      hg17.humanVidalP2P.target (via bioCycPathway.kgID)
      hg17.humanWankerP2P.query (via bioCycPathway.kgID)
      hg17.humanWankerP2P.target (via bioCycPathway.kgID)
      hg17.keggPathway.kgID (via bioCycPathway.kgID)
      hg17.kgAlias.kgID (via bioCycPathway.kgID)
      hg17.kgProtAlias.kgID (via bioCycPathway.kgID)
      hg17.kgSpAlias.kgID (via bioCycPathway.kgID)
      hg17.kgTargetAli.qName (via bioCycPathway.kgID)
      hg17.kgXref.kgID (via bioCycPathway.kgID)
      hg17.knownBlastTab.query (via bioCycPathway.kgID)
      hg17.knownBlastTab.target (via bioCycPathway.kgID)
      hg17.knownCanonical.transcript (via bioCycPathway.kgID)
      hg17.knownExpDistance.query (via bioCycPathway.kgID)
      hg17.knownExpDistance.target (via bioCycPathway.kgID)
      hg17.knownGene.name (via bioCycPathway.kgID)
      hg17.knownGeneLink.name (via bioCycPathway.kgID)
      hg17.knownGeneMrna.name (via bioCycPathway.kgID)
      hg17.knownGenePep.name (via bioCycPathway.kgID)
      hg17.knownIsoforms.transcript (via bioCycPathway.kgID)
      hg17.knownToAllenBrain.name (via bioCycPathway.kgID)
      hg17.knownToEnsembl.name (via bioCycPathway.kgID)
      hg17.knownToGnf1h.name (via bioCycPathway.kgID)
      hg17.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      hg17.knownToHInv.name (via bioCycPathway.kgID)
      hg17.knownToHprd.name (via bioCycPathway.kgID)
      hg17.knownToKeggEntrez.name (via bioCycPathway.kgID)
      hg17.knownToLocusLink.name (via bioCycPathway.kgID)
      hg17.knownToPfam.name (via bioCycPathway.kgID)
      hg17.knownToRefSeq.name (via bioCycPathway.kgID)
      hg17.knownToSuper.gene (via bioCycPathway.kgID)
      hg17.knownToU133.name (via bioCycPathway.kgID)
      hg17.knownToU133Plus2.name (via bioCycPathway.kgID)
      hg17.knownToU95.name (via bioCycPathway.kgID)
      hg17.knownToVisiGene.name (via bioCycPathway.kgID)
      hg17.mmBlastTab.query (via bioCycPathway.kgID)
      hg17.rankProp.query (via bioCycPathway.kgID)
      hg17.rankProp.target (via bioCycPathway.kgID)
      hg17.rnBlastTab.query (via bioCycPathway.kgID)
      hg17.scBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.bioCycPathway.kgID (via bioCycPathway.kgID)
      knownGeneV39.ceBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.dmBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.drBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.foldUtr3.name (via bioCycPathway.kgID)
      knownGeneV39.foldUtr5.name (via bioCycPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      knownGeneV39.kgAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgColor.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgProtAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgSpAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgTargetAli.qName (via bioCycPathway.kgID)
      knownGeneV39.kgXref.kgID (via bioCycPathway.kgID)
      knownGeneV39.knownAttrs.kgID (via bioCycPathway.kgID)
      knownGeneV39.knownBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.knownBlastTab.target (via bioCycPathway.kgID)
      knownGeneV39.knownCanonical.protein (via bioCycPathway.kgID)
      knownGeneV39.knownCanonical.transcript (via bioCycPathway.kgID)
      knownGeneV39.knownCds.name (via bioCycPathway.kgID)
      knownGeneV39.knownGene.name (via bioCycPathway.kgID)
      knownGeneV39.knownGeneMrna.name (via bioCycPathway.kgID)
      knownGeneV39.knownGenePep.name (via bioCycPathway.kgID)
      knownGeneV39.knownIsoforms.transcript (via bioCycPathway.kgID)
      knownGeneV39.knownToEnsembl.name (via bioCycPathway.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      knownGeneV39.knownToHprd.name (via bioCycPathway.kgID)
      knownGeneV39.knownToLocusLink.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMrna.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMrnaSingle.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMupit.name (via bioCycPathway.kgID)
      knownGeneV39.knownToPfam.name (via bioCycPathway.kgID)
      knownGeneV39.knownToRefSeq.name (via bioCycPathway.kgID)
      knownGeneV39.knownToSuper.gene (via bioCycPathway.kgID)
      knownGeneV39.knownToTag.name (via bioCycPathway.kgID)
      knownGeneV39.knownToU133.name (via bioCycPathway.kgID)
      knownGeneV39.knownToU95.name (via bioCycPathway.kgID)
      knownGeneV39.knownToVisiGene.name (via bioCycPathway.kgID)
      knownGeneV39.knownToWikipedia.name (via bioCycPathway.kgID)
      knownGeneV39.mmBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.rnBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.scBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.ucscScop.ucscId (via bioCycPathway.kgID)
      hg17.bioCycMapDesc.mapID (via bioCycPathway.mapID)

Sample Rows
 
kgIDgeneIDmapID
AB020635ENSG00000158467ADENOSYLHOMOCYSCAT-PWY
AB020635ENSG00000158467METHIONINE-DEG1-PWY
AB02064423305FAO-PWY
AB040949ENSG00000138193LIPASYN-PWY
AB044561ENSG00000139631CYSDEGRV-PWY
AF001903ENSG00000138796FAO-PWY
AF040260ENSG00000112699COLANSYN-PWY
AF040260ENSG00000112699GDPRHAMSYN-PWY
AF051852ENSG00000159921GLCMANNANAUT-PWY
AF051852ENSG00000159921P441-PWY

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