Schema for rgdGene2ToRefSeq
  Database: rn4    Primary Table: rgdGene2ToRefSeq    Row Count: 13,893   Data last updated: 2010-10-21
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:1563873varchar(255) values primary ID
value NM_001107941varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        rn4.affyExonTissuesGsMedianDistRgdGene2.query (via rgdGene2ToRefSeq.name)
      rn4.affyExonTissuesGsMedianDistRgdGene2.target (via rgdGene2ToRefSeq.name)
      rn4.affyExonTissuesGsMedianRgdGene2.name (via rgdGene2ToRefSeq.name)
      rn4.affyExonTissuesGsRgdGene2.name (via rgdGene2ToRefSeq.name)
      rn4.ceBlastTab.query (via rgdGene2ToRefSeq.name)
      rn4.dmBlastTab.query (via rgdGene2ToRefSeq.name)
      rn4.drBlastTab.query (via rgdGene2ToRefSeq.name)
      rn4.gnfAtlas2RgdGene2Distance.query (via rgdGene2ToRefSeq.name)
      rn4.gnfAtlas2RgdGene2Distance.target (via rgdGene2ToRefSeq.name)
      rn4.hgBlastTab.query (via rgdGene2ToRefSeq.name)
      rn4.mmBlastTab.query (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2BlastTab.query (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2BlastTab.target (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2Canonical.transcript (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2Isoforms.transcript (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2KeggPathway.rgdId (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2Pep.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToDescription.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToDisplayId.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToEnsembl.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToGenbank.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToGenbankAll.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToGnfAtlas2.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToKeggEntrez.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToLocusLink.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToPDB.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToPfam.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToRAE230.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToSymbol.rgdId (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToU34A.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2ToUniProt.name (via rgdGene2ToRefSeq.name)
      rn4.rgdGene2Xref.rgdGeneId (via rgdGene2ToRefSeq.name)
      rn4.rgdGenePathway.geneId (via rgdGene2ToRefSeq.name)
      rn4.scBlastTab.query (via rgdGene2ToRefSeq.name)
      hgFixed.gbCdnaInfo.acc (via rgdGene2ToRefSeq.value)
      hgFixed.gbSeq.acc (via rgdGene2ToRefSeq.value)
      hgFixed.imageClone.acc (via rgdGene2ToRefSeq.value)
      hgFixed.refLink.mrnaAcc (via rgdGene2ToRefSeq.value)
      hgFixed.refSeqStatus.mrnaAcc (via rgdGene2ToRefSeq.value)
      hgFixed.refSeqSummary.mrnaAcc (via rgdGene2ToRefSeq.value)
      knownGeneV39.kgXref.refseq (via rgdGene2ToRefSeq.value)
      knownGeneV39.knownToRefSeq.value (via rgdGene2ToRefSeq.value)
      rn4.mrnaOrientInfo.name (via rgdGene2ToRefSeq.value)
      rn4.mrnaRefseq.refseq (via rgdGene2ToRefSeq.value)
      rn4.refFlat.name (via rgdGene2ToRefSeq.value)
      rn4.refGene.name (via rgdGene2ToRefSeq.value)
      rn4.refSeqAli.qName (via rgdGene2ToRefSeq.value)

Sample Rows
 
namevalue
RGD:1563873NM_001107941
RGD:1561623NM_001191756
RGD:1311230NM_001030033
RGD:1564494NM_001106951
RGD:2990NM_017068
RGD:727788NM_182822
RGD:1563789NM_001024901
RGD:1563844NM_001024874
RGD:1563189NM_001025654
RGD:2301305NM_001135607

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