Schema for affyGnfU74ADistance
  Database: mm8    Primary Table: affyGnfU74ADistance    Row Count: 12,062,000   Data last updated: 2006-03-09
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory
fieldexampleSQL type description
query NM_011441varchar(255) Name of one gene
target NM_011441varchar(255) Name of other gene
distance 0float Distance in expression space, always >= 0

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via affyGnfU74ADistance.query)
      knownGeneV39.ceBlastTab.query (via affyGnfU74ADistance.query)
      knownGeneV39.dmBlastTab.query (via affyGnfU74ADistance.query)
      knownGeneV39.drBlastTab.query (via affyGnfU74ADistance.query)
      knownGeneV39.foldUtr3.name (via affyGnfU74ADistance.query)
      knownGeneV39.foldUtr5.name (via affyGnfU74ADistance.query)
      knownGeneV39.gnfAtlas2Distance.query (via affyGnfU74ADistance.query)
      knownGeneV39.gnfAtlas2Distance.target (via affyGnfU74ADistance.query)
      knownGeneV39.kgAlias.kgID (via affyGnfU74ADistance.query)
      knownGeneV39.kgColor.kgID (via affyGnfU74ADistance.query)
      knownGeneV39.kgProtAlias.kgID (via affyGnfU74ADistance.query)
      knownGeneV39.kgSpAlias.kgID (via affyGnfU74ADistance.query)
      knownGeneV39.kgTargetAli.qName (via affyGnfU74ADistance.query)
      knownGeneV39.kgXref.kgID (via affyGnfU74ADistance.query)
      knownGeneV39.knownAttrs.kgID (via affyGnfU74ADistance.query)
      knownGeneV39.knownBlastTab.query (via affyGnfU74ADistance.query)
      knownGeneV39.knownBlastTab.target (via affyGnfU74ADistance.query)
      knownGeneV39.knownCanonical.protein (via affyGnfU74ADistance.query)
      knownGeneV39.knownCanonical.transcript (via affyGnfU74ADistance.query)
      knownGeneV39.knownCds.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownGene.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownGeneMrna.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownGenePep.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownIsoforms.transcript (via affyGnfU74ADistance.query)
      knownGeneV39.knownToEnsembl.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToGnfAtlas2.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToHprd.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToLocusLink.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToMrna.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToMrnaSingle.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToMupit.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToPfam.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToRefSeq.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToSuper.gene (via affyGnfU74ADistance.query)
      knownGeneV39.knownToTag.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToU133.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToU95.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToVisiGene.name (via affyGnfU74ADistance.query)
      knownGeneV39.knownToWikipedia.name (via affyGnfU74ADistance.query)
      knownGeneV39.mmBlastTab.query (via affyGnfU74ADistance.query)
      knownGeneV39.rnBlastTab.query (via affyGnfU74ADistance.query)
      knownGeneV39.scBlastTab.query (via affyGnfU74ADistance.query)
      knownGeneV39.ucscScop.ucscId (via affyGnfU74ADistance.query)
      mm8.affyGnfU74BDistance.query (via affyGnfU74ADistance.query)
      mm8.affyGnfU74BDistance.target (via affyGnfU74ADistance.query)
      mm8.affyGnfU74CDistance.query (via affyGnfU74ADistance.query)
      mm8.affyGnfU74CDistance.target (via affyGnfU74ADistance.query)
      mm8.ccdsKgMap.geneId (via affyGnfU74ADistance.query)
      mm8.ceBlastTab.query (via affyGnfU74ADistance.query)
      mm8.dmBlastTab.query (via affyGnfU74ADistance.query)
      mm8.drBlastTab.query (via affyGnfU74ADistance.query)
      mm8.dupSpMrna.mrnaID (via affyGnfU74ADistance.query)
      mm8.foldUtr3.name (via affyGnfU74ADistance.query)
      mm8.foldUtr5.name (via affyGnfU74ADistance.query)
      mm8.gnfAtlas2Distance.query (via affyGnfU74ADistance.query)
      mm8.gnfAtlas2Distance.target (via affyGnfU74ADistance.query)
      mm8.hgBlastTab.query (via affyGnfU74ADistance.query)
      mm8.keggPathway.kgID (via affyGnfU74ADistance.query)
      mm8.kgAlias.kgID (via affyGnfU74ADistance.query)
      mm8.kgProtAlias.kgID (via affyGnfU74ADistance.query)
      mm8.kgSpAlias.kgID (via affyGnfU74ADistance.query)
      mm8.kgTargetAli.qName (via affyGnfU74ADistance.query)
      mm8.kgXref.kgID (via affyGnfU74ADistance.query)
      mm8.knownBlastTab.query (via affyGnfU74ADistance.query)
      mm8.knownBlastTab.target (via affyGnfU74ADistance.query)
      mm8.knownCanonical.transcript (via affyGnfU74ADistance.query)
      mm8.knownGene.name (via affyGnfU74ADistance.query)
      mm8.knownGeneMrna.name (via affyGnfU74ADistance.query)
      mm8.knownGenePep.name (via affyGnfU74ADistance.query)
      mm8.knownIsoforms.transcript (via affyGnfU74ADistance.query)
      mm8.knownToAllenBrain.name (via affyGnfU74ADistance.query)
      mm8.knownToEnsembl.name (via affyGnfU74ADistance.query)
      mm8.knownToGnfAtlas2.name (via affyGnfU74ADistance.query)
      mm8.knownToKeggEntrez.name (via affyGnfU74ADistance.query)
      mm8.knownToLocusLink.name (via affyGnfU74ADistance.query)
      mm8.knownToPfam.name (via affyGnfU74ADistance.query)
      mm8.knownToRefSeq.name (via affyGnfU74ADistance.query)
      mm8.knownToSuper.gene (via affyGnfU74ADistance.query)
      mm8.knownToVisiGene.name (via affyGnfU74ADistance.query)
      mm8.rnBlastTab.query (via affyGnfU74ADistance.query)
      mm8.scBlastTab.query (via affyGnfU74ADistance.query)

Sample Rows
 
querytargetdistance
NM_011441NM_0114410
NM_011441AK0047810
NM_011441BC1071720.558285
NM_011441NM_0082650.558285
NM_011441NM_0090220.581621
NM_011441BC0757040.581621
NM_011441NM_1754770.593086
NM_011441NM_0285440.601653
NM_011441AK1566020.601653
NM_011441AK1292820.603093

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