Schema for rgdGene2ToPfam
  Database: rn4    Primary Table: rgdGene2ToPfam    Row Count: 14,400   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:1302933varchar(255) values primary ID
value PF00089varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
RGD:1302933PF00089
RGD:1302934PF00777
RGD:1302935PF00293
RGD:1302936PF00431
RGD:1302936PF00089
RGD:1302937PF00038
RGD:1302938PF00089
RGD:1302939PF00647
RGD:1302939PF00043
RGD:1302939PF02798

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