Schema for rgdGene2ToGnfAtlas2
  Database: rn4    Primary Table: rgdGene2ToGnfAtlas2    Row Count: 3,818   Data last updated: 2010-10-18
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:2990varchar(255) values primary ID
value M32016_atvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
RGD:2990M32016_at
RGD:3593rc_AI171085_at
RGD:3797M27812_at
RGD:1563698rc_AA893690_g_at
RGD:2323267rc_AA866248_at
RGD:3041M23601_at
RGD:62004U47110_at
RGD:70950D78359_at
RGD:620957rc_H33491_at
RGD:2663D13518_at

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