Schema for rgdGene2Xref
  Database: rn4    Primary Table: rgdGene2Xref    Row Count: 108,885   Data last updated: 2010-10-28
Format description: Cross-reference of rgdGene2 gene to various type of info
On download server: MariaDB table dump directory
fieldexampleSQL type info description
rgdGeneId RGD:1302933varchar(40) values Same as name field in rgdGene2 gene
infoType GeneIDvarchar(40) values Type of info, e.g. ID, GeneID, MGC, etc.
info 408209text values Text of info

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

Sample Rows
 
rgdGeneIdinfoTypeinfo
RGD:1302933GeneID408209
RGD:1302933IDMcpt1l3
RGD:1302933IDRGD1302933
RGD:1302933NameMcpt1l3
RGD:1302933Notemember of the serine protease family
RGD:1302933geneMcpt1l3
RGD:1302935GeneID308518
RGD:1302935IDNudt19
RGD:1302935IDRGD1302935
RGD:1302935IMAGE7123358

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