Schema for arbExpDistance
  Database: dm2    Primary Table: arbExpDistance    Row Count: 7,465,000   Data last updated: 2007-04-03
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query CG3152-RAvarchar(255) Query gene. Indexed
target CG3152-RAvarchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

Connected Tables and Joining Fields
        dm2.ceBlastTab.query (via arbExpDistance.query)
      dm2.drBlastTab.query (via arbExpDistance.query)
      dm2.flyBase2004Xref.name (via arbExpDistance.query)
      dm2.flyBaseBlastTab.query (via arbExpDistance.query)
      dm2.flyBaseBlastTab.target (via arbExpDistance.query)
      dm2.flyBaseCanonical.transcript (via arbExpDistance.query)
      dm2.flyBaseGene.name (via arbExpDistance.query)
      dm2.flyBaseIsoforms.transcript (via arbExpDistance.query)
      dm2.flyBaseNoncoding.name (via arbExpDistance.query)
      dm2.flyBasePep.name (via arbExpDistance.query)
      dm2.flyBaseToCG.name (via arbExpDistance.query)
      dm2.flyBaseToDescription.name (via arbExpDistance.query)
      dm2.flyBaseToPfam.name (via arbExpDistance.query)
      dm2.flyBaseToRefSeq.name (via arbExpDistance.query)
      dm2.flyBaseToUniProt.name (via arbExpDistance.query)
      dm2.flyP2P.query (via arbExpDistance.query)
      dm2.flyP2P.target (via arbExpDistance.query)
      dm2.hgBlastTab.query (via arbExpDistance.query)
      dm2.mmBlastTab.query (via arbExpDistance.query)
      dm2.rnBlastTab.query (via arbExpDistance.query)
      dm2.scBlastTab.query (via arbExpDistance.query)

Sample Rows
 
querytargetdistance
CG3152-RACG3152-RA0
CG3152-RACG1554-RA0.193933
CG3152-RACG3061-RA0.35488
CG3152-RACG14789-RA0.358711
CG3152-RACG7206-RB0.370829
CG3152-RACG7206-RA0.370829
CG3152-RACG3051-RB0.375105
CG3152-RACG3051-RA0.375105
CG3152-RACG3051-RC0.375105
CG3152-RACG4184-RA0.379079

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