Schema for affyExonTissuesGsMedianDistRgdGene2
  Database: rn4    Primary Table: affyExonTissuesGsMedianDistRgdGene2    Row Count: 18,155,000   Data last updated: 2010-10-26
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory
fieldexampleSQL type description
query RGD:1596944varchar(255) Name of one gene
target RGD:1596944varchar(255) Name of other gene
distance 0float Distance in expression space, always >= 0

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

Sample Rows
 
querytargetdistance
RGD:1596944RGD:15969440
RGD:1596944RGD:23215510.03
RGD:1596944RGD:13343790.034545
RGD:1596944RGD:23186940.034636
RGD:1596944RGD:15658920.037545
RGD:1596944RGD:13329210.037727
RGD:1596944RGD:15612230.037818
RGD:1596944RGD:13337030.039182
RGD:1596944RGD:15628780.039636
RGD:1596944RGD:13110390.040818

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