Schema for affyGnfU74ADistance
  Database: mm9    Primary Table: affyGnfU74ADistance    Row Count: 18,090,000   Data last updated: 2011-03-03
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query uc009cfv.1varchar(255) Query gene. Indexed
target uc009cfv.1varchar(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)
      mm9.affyGnfU74BDistance.query (via affyGnfU74ADistance.query)
      mm9.affyGnfU74BDistance.target (via affyGnfU74ADistance.query)
      mm9.affyGnfU74CDistance.query (via affyGnfU74ADistance.query)
      mm9.affyGnfU74CDistance.target (via affyGnfU74ADistance.query)
      mm9.bioCycPathway.kgID (via affyGnfU74ADistance.query)
      mm9.ccdsKgMap.geneId (via affyGnfU74ADistance.query)
      mm9.ceBlastTab.query (via affyGnfU74ADistance.query)
      mm9.dmBlastTab.query (via affyGnfU74ADistance.query)
      mm9.drBlastTab.query (via affyGnfU74ADistance.query)
      mm9.foldUtr3.name (via affyGnfU74ADistance.query)
      mm9.foldUtr5.name (via affyGnfU74ADistance.query)
      mm9.gnfAtlas2Distance.query (via affyGnfU74ADistance.query)
      mm9.gnfAtlas2Distance.target (via affyGnfU74ADistance.query)
      mm9.hgBlastTab.query (via affyGnfU74ADistance.query)
      mm9.keggPathway.kgID (via affyGnfU74ADistance.query)
      mm9.kgAlias.kgID (via affyGnfU74ADistance.query)
      mm9.kgColor.kgID (via affyGnfU74ADistance.query)
      mm9.kgProtAlias.kgID (via affyGnfU74ADistance.query)
      mm9.kgProtMap2.qName (via affyGnfU74ADistance.query)
      mm9.kgSpAlias.kgID (via affyGnfU74ADistance.query)
      mm9.kgTargetAli.qName (via affyGnfU74ADistance.query)
      mm9.kgTxInfo.name (via affyGnfU74ADistance.query)
      mm9.kgXref.kgID (via affyGnfU74ADistance.query)
      mm9.knownBlastTab.query (via affyGnfU74ADistance.query)
      mm9.knownBlastTab.target (via affyGnfU74ADistance.query)
      mm9.knownCanonical.protein (via affyGnfU74ADistance.query)
      mm9.knownCanonical.transcript (via affyGnfU74ADistance.query)
      mm9.knownGene.name (via affyGnfU74ADistance.query)
      mm9.knownGeneMrna.name (via affyGnfU74ADistance.query)
      mm9.knownGenePep.name (via affyGnfU74ADistance.query)
      mm9.knownIsoforms.transcript (via affyGnfU74ADistance.query)
      mm9.knownToAllenBrain.name (via affyGnfU74ADistance.query)
      mm9.knownToEnsembl.name (via affyGnfU74ADistance.query)
      mm9.knownToGnfAtlas2.name (via affyGnfU74ADistance.query)
      mm9.knownToKeggEntrez.name (via affyGnfU74ADistance.query)
      mm9.knownToLocusLink.name (via affyGnfU74ADistance.query)
      mm9.knownToPfam.name (via affyGnfU74ADistance.query)
      mm9.knownToRefSeq.name (via affyGnfU74ADistance.query)
      mm9.knownToSuper.gene (via affyGnfU74ADistance.query)
      mm9.knownToVisiGene.name (via affyGnfU74ADistance.query)
      mm9.rnBlastTab.query (via affyGnfU74ADistance.query)
      mm9.scBlastTab.query (via affyGnfU74ADistance.query)
      mm9.ucscScop.ucscId (via affyGnfU74ADistance.query)

Sample Rows
 
querytargetdistance
uc009cfv.1uc009cfv.10
uc009cfv.1uc012enc.10.751126
uc009cfv.1uc012end.10.790967
uc009cfv.1uc008grx.10.798083
uc009cfv.1uc008grw.10.798083
uc009cfv.1uc007hnh.10.811893
uc009cfv.1uc007hng.10.811893
uc009cfv.1uc008cbs.10.826945
uc009cfv.1uc007kpi.20.855592
uc009cfv.1uc008sps.20.884606

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