Schema for rgdGene2ToUniProt
  Database: rn4    Primary Table: rgdGene2ToUniProt    Row Count: 14,339   Data last updated: 2012-02-02
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name RGD:1302933varchar(40) values primary ID
value Q6IE11varchar(40) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        rn4.affyExonTissuesGsMedianDistRgdGene2.query (via rgdGene2ToUniProt.name)
      rn4.affyExonTissuesGsMedianDistRgdGene2.target (via rgdGene2ToUniProt.name)
      rn4.affyExonTissuesGsMedianRgdGene2.name (via rgdGene2ToUniProt.name)
      rn4.affyExonTissuesGsRgdGene2.name (via rgdGene2ToUniProt.name)
      rn4.ceBlastTab.query (via rgdGene2ToUniProt.name)
      rn4.dmBlastTab.query (via rgdGene2ToUniProt.name)
      rn4.drBlastTab.query (via rgdGene2ToUniProt.name)
      rn4.gnfAtlas2RgdGene2Distance.query (via rgdGene2ToUniProt.name)
      rn4.gnfAtlas2RgdGene2Distance.target (via rgdGene2ToUniProt.name)
      rn4.hgBlastTab.query (via rgdGene2ToUniProt.name)
      rn4.mmBlastTab.query (via rgdGene2ToUniProt.name)
      rn4.rgdGene2.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2BlastTab.query (via rgdGene2ToUniProt.name)
      rn4.rgdGene2BlastTab.target (via rgdGene2ToUniProt.name)
      rn4.rgdGene2Canonical.transcript (via rgdGene2ToUniProt.name)
      rn4.rgdGene2Isoforms.transcript (via rgdGene2ToUniProt.name)
      rn4.rgdGene2KeggPathway.rgdId (via rgdGene2ToUniProt.name)
      rn4.rgdGene2Pep.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToDescription.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToDisplayId.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToEnsembl.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToGenbank.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToGenbankAll.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToGnfAtlas2.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToKeggEntrez.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToLocusLink.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToPDB.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToPfam.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToRAE230.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToRefSeq.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToSymbol.rgdId (via rgdGene2ToUniProt.name)
      rn4.rgdGene2ToU34A.name (via rgdGene2ToUniProt.name)
      rn4.rgdGene2Xref.rgdGeneId (via rgdGene2ToUniProt.name)
      rn4.rgdGenePathway.geneId (via rgdGene2ToUniProt.name)
      rn4.scBlastTab.query (via rgdGene2ToUniProt.name)
      go.goaPart.dbObjectId (via rgdGene2ToUniProt.value)
      knownGeneV39.kgProtAlias.alias (via rgdGene2ToUniProt.value)
      knownGeneV39.kgSpAlias.spID (via rgdGene2ToUniProt.value)
      knownGeneV39.kgXref.spID (via rgdGene2ToUniProt.value)
      proteome.spOldNew.acc (via rgdGene2ToUniProt.value)
      proteome.spReactomeEvent.spID (via rgdGene2ToUniProt.value)
      proteome.spReactomeId.spID (via rgdGene2ToUniProt.value)
      uniProt.accToKeyword.acc (via rgdGene2ToUniProt.value)
      uniProt.accToTaxon.acc (via rgdGene2ToUniProt.value)
      uniProt.citation.acc (via rgdGene2ToUniProt.value)
      uniProt.comment.acc (via rgdGene2ToUniProt.value)
      uniProt.description.acc (via rgdGene2ToUniProt.value)
      uniProt.displayId.acc (via rgdGene2ToUniProt.value)
      uniProt.extDbRef.acc (via rgdGene2ToUniProt.value)
      uniProt.feature.acc (via rgdGene2ToUniProt.value)
      uniProt.gene.acc (via rgdGene2ToUniProt.value)
      uniProt.geneLogic.acc (via rgdGene2ToUniProt.value)
      uniProt.info.acc (via rgdGene2ToUniProt.value)
      uniProt.otherAcc.acc (via rgdGene2ToUniProt.value)
      uniProt.protein.acc (via rgdGene2ToUniProt.value)
      visiGene.gene.uniProt (via rgdGene2ToUniProt.value)

Sample Rows
 
namevalue
RGD:1302933Q6IE11
RGD:1302935Q6AYD9
RGD:1302936Q6IE64
RGD:1302937Q6IFV4
RGD:1302938Q6IE58
RGD:1302939Q68FR6
RGD:1302940Q6P3V7
RGD:1302941Q6GUG4
RGD:1302945Q6XQN1
RGD:1302946Q4V8Q1

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