Schema for flyP2P
  Database: dm3    Primary Table: flyP2P    Row Count: 2,107,656   Data last updated: 2008-10-21
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query CG11121-RAvarchar(255) Query gene. Indexed
target CG11121-RAvarchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

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

Sample Rows
 
querytargetdistance
CG11121-RACG11121-RA0
CG11121-RACG3365-RE2
CG11121-RACG3365-RD2
CG11121-RACG3365-RC2
CG11121-RACG3365-RA2
CG11121-RACG3365-RB2
CG11121-RACG7809-RA2
CG11121-RACG2189-RA2
CG11121-RACG7001-RA2
CG11121-RACG5460-RC2

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