Schema for bioCycPathway
  Database: hg16    Primary Table: bioCycPathway    Row Count: 996   Data last updated: 2004-04-07
Format description: BioCyc Pathway to Known Gene cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000824varchar(40) values Known Gene ID
geneID NM_007180varchar(40) values Gene (RefSeq) ID
mapID TREDEGLOW-PWYvarchar(40) values BioCyc pathway map ID

Connected Tables and Joining Fields
        hg16.dmBlastTab.query (via bioCycPathway.kgID)
      hg16.drBlastTab.query (via bioCycPathway.kgID)
      hg16.dupSpMrna.mrnaID (via bioCycPathway.kgID)
      hg16.foldUtr3.name (via bioCycPathway.kgID)
      hg16.foldUtr5.name (via bioCycPathway.kgID)
      hg16.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      hg16.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      hg16.gnfU95Distance.query (via bioCycPathway.kgID)
      hg16.gnfU95Distance.target (via bioCycPathway.kgID)
      hg16.hg17Kg.name (via bioCycPathway.kgID)
      hg16.keggPathway.kgID (via bioCycPathway.kgID)
      hg16.kgAlias.kgID (via bioCycPathway.kgID)
      hg16.kgProtAlias.kgID (via bioCycPathway.kgID)
      hg16.kgXref.kgID (via bioCycPathway.kgID)
      hg16.knownBlastTab.query (via bioCycPathway.kgID)
      hg16.knownBlastTab.target (via bioCycPathway.kgID)
      hg16.knownCanonical.transcript (via bioCycPathway.kgID)
      hg16.knownGene.name (via bioCycPathway.kgID)
      hg16.knownGeneLink.name (via bioCycPathway.kgID)
      hg16.knownGeneMrna.name (via bioCycPathway.kgID)
      hg16.knownGenePep.name (via bioCycPathway.kgID)
      hg16.knownIsoforms.transcript (via bioCycPathway.kgID)
      hg16.knownToEnsembl.name (via bioCycPathway.kgID)
      hg16.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      hg16.knownToHInv.name (via bioCycPathway.kgID)
      hg16.knownToLocusLink.name (via bioCycPathway.kgID)
      hg16.knownToPfam.name (via bioCycPathway.kgID)
      hg16.knownToRefSeq.name (via bioCycPathway.kgID)
      hg16.knownToSuper.gene (via bioCycPathway.kgID)
      hg16.knownToU133.name (via bioCycPathway.kgID)
      hg16.knownToU95.name (via bioCycPathway.kgID)
      hg16.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)
      hg16.bioCycMapDesc.mapID (via bioCycPathway.mapID)

Sample Rows
 
kgIDgeneIDmapID
AB000824NM_007180TREDEGLOW-PWY
AB007851NM_002767P1-PWY
AB007851NM_002767PRPP-PWY
AB011153NM_015192LIPASYN-PWY
AB015226NM_003888NPGLUCAT-PWY
AB020644NM_015256FAO-PWY
AB026722NM_006903P61-PWY
AB029015NM_015184LIPASYN-PWY
AB029948NM_017827TRNA-CHARGING-PWY
AB033116NM_018245GLUCAT-PWY

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