Schema for rgdGene2KeggPathway
  Database: rn4    Primary Table: rgdGene2KeggPathway    Row Count: 8,083   Data last updated: 2010-10-25
Format description: KEGG pathway cross reference for RGD Genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
rgdId RGD:621341varchar(40) values  
locusID 112400varchar(40) values LocusLink ID
mapID rno04012varchar(40) values KEGG pathway map ID

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

Sample Rows
 
rgdIdlocusIDmapID
RGD:621341112400rno04012
RGD:621341112400rno04012
RGD:621341112400rno04012
RGD:621341112400rno04012
RGD:621341112400rno04012
RGD:621341112400rno04012
RGD:621341112400rno04012
RGD:71007113898rno04146
RGD:71035113936rno04610
RGD:71035113936rno04972

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