Schema for affyGnfU74ADistance
  Database: mm8    Primary Table: affyGnfU74ADistance    Row Count: 12,062,000   Data last updated: 2006-03-09
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query NM_011441varchar(255) Query gene. Indexed
target NM_011441varchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

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.