Schema for rgdGene2ToLocusLink
  Database: rn4    Primary Table: rgdGene2ToLocusLink    Row Count: 18,240   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 313296varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
RGD:1563873313296
RGD:1560768298159
RGD:1588662691030
RGD:1588647691047
RGD:1561678298168
RGD:1561623313308
RGD:1560720313311
RGD:1560124302497
RGD:1311230302499
RGD:1564494302502

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