Schema for rgdGene2ToSymbol
  Database: rn4    Primary Table: rgdGene2ToSymbol    Row Count: 18,240   Data last updated: 2010-11-05
Format description: Cross-reference of rgdGene2 gene ID to RGD ID number and Gene Symbol
On download server: MariaDB table dump directory
fieldexampleSQL type info description
rgdId RGD:1565877varchar(40) values Same as name field in rgdGene2 gene
rgdIdNum 1565877varchar(40) values RGD ID without the 'RGD:' prefix
geneSymbol Zdhhc14varchar(40) values Gene Symbol

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

Sample Rows
 
rgdIdrgdIdNumgeneSymbol
RGD:15658771565877Zdhhc14
RGD:15969441596944Vom2r1
RGD:15617571561757Vom2r2
RGD:15658921565892Vom2r3
RGD:15641101564110Vom2r4
RGD:15858981585898Vom2r5
RGD:15626971562697Vom2r6
RGD:23218652321865LOC100360592
RGD:15847601584760LOC679782
RGD:15836631583663LOC679825

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