Schema for affyGnfU74BDistance
  Database: mm7    Primary Table: affyGnfU74BDistance    Row Count: 7,173,000   Data last updated: 2005-11-17
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query NM_009826varchar(255) Query gene. Indexed
target NM_009826varchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

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

Sample Rows
 
querytargetdistance
NM_009826NM_0098260
NM_009826AK0777890.380645
NM_009826NM_0198160.380645
NM_009826AK1540310.397728
NM_009826NM_0265700.405539
NM_009826AK1579370.444277
NM_009826BC0367180.444277
NM_009826NM_1531360.444277
NM_009826BC0798920.449995
NM_009826NM_1737530.449995

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