Schema for rgdGenePathway
  Database: rn4    Primary Table: rgdGenePathway    Row Count: 3,731   Data last updated: 2011-12-02
Format description: Cross-reference of rgdGene2 gene ID to RGD pathway ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId RGD:69329varchar(40) values Same as name field in rgdGene2 table
pathwayId PW:0000007varchar(40) values RGD pathway ID

Connected Tables and Joining Fields
        rn4.affyExonTissuesGsMedianDistRgdGene2.query (via rgdGenePathway.geneId)
      rn4.affyExonTissuesGsMedianDistRgdGene2.target (via rgdGenePathway.geneId)
      rn4.affyExonTissuesGsMedianRgdGene2.name (via rgdGenePathway.geneId)
      rn4.affyExonTissuesGsRgdGene2.name (via rgdGenePathway.geneId)
      rn4.ceBlastTab.query (via rgdGenePathway.geneId)
      rn4.dmBlastTab.query (via rgdGenePathway.geneId)
      rn4.drBlastTab.query (via rgdGenePathway.geneId)
      rn4.gnfAtlas2RgdGene2Distance.query (via rgdGenePathway.geneId)
      rn4.gnfAtlas2RgdGene2Distance.target (via rgdGenePathway.geneId)
      rn4.hgBlastTab.query (via rgdGenePathway.geneId)
      rn4.mmBlastTab.query (via rgdGenePathway.geneId)
      rn4.rgdGene2.name (via rgdGenePathway.geneId)
      rn4.rgdGene2BlastTab.query (via rgdGenePathway.geneId)
      rn4.rgdGene2BlastTab.target (via rgdGenePathway.geneId)
      rn4.rgdGene2Canonical.transcript (via rgdGenePathway.geneId)
      rn4.rgdGene2Isoforms.transcript (via rgdGenePathway.geneId)
      rn4.rgdGene2KeggPathway.rgdId (via rgdGenePathway.geneId)
      rn4.rgdGene2Pep.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToDescription.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToDisplayId.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToEnsembl.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToGenbank.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToGenbankAll.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToGnfAtlas2.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToKeggEntrez.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToLocusLink.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToPDB.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToPfam.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToRAE230.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToRefSeq.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToSymbol.rgdId (via rgdGenePathway.geneId)
      rn4.rgdGene2ToU34A.name (via rgdGenePathway.geneId)
      rn4.rgdGene2ToUniProt.name (via rgdGenePathway.geneId)
      rn4.rgdGene2Xref.rgdGeneId (via rgdGenePathway.geneId)
      rn4.scBlastTab.query (via rgdGenePathway.geneId)
      rn4.rgdPathway.pathwayId (via rgdGenePathway.pathwayId)

Sample Rows
 
geneIdpathwayId
RGD:69329PW:0000007
RGD:2274PW:0000007
RGD:2202PW:0000007
RGD:619758PW:0000007
RGD:3168PW:0000007
RGD:3537PW:0000007
RGD:620945PW:0000007
RGD:2890PW:0000007
RGD:2561PW:0000007
RGD:70967PW:0000007

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