Schema for dmBlastTab
  Database: sacCer3    Primary Table: dmBlastTab    Row Count: 3,675   Data last updated: 2011-09-02
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query Q0045varchar(255) values Name of sequence in this assembly (query)
target CG34067-RAvarchar(255) values Name of sequence in other assembly (target)
identity 58.63float range Percent identity
aliLength 527int(10) unsigned range Length of alignment
mismatch 193int(10) unsigned range Number of mismatches
gapOpen 5int(10) unsigned range Number of gap openings
qStart 2int(10) unsigned range Start in query (0 based)
qEnd 528int(10) unsigned range End in query (non-inclusive)
tStart 1int(10) unsigned range Start in target (0 based)
tEnd 504int(10) unsigned range End in target (non-inclusive)
eValue 3e-179double range Expectation value
bitScore 625double range Bit score

Connected Tables and Joining Fields
        sacCer3.ceBlastTab.query (via dmBlastTab.query)
      sacCer3.choExpDistance.query (via dmBlastTab.query)
      sacCer3.choExpDistance.target (via dmBlastTab.query)
      sacCer3.drBlastTab.query (via dmBlastTab.query)
      sacCer3.esRegGeneToModule.gene (via dmBlastTab.query)
      sacCer3.esRegGeneToMotif.gene (via dmBlastTab.query)
      sacCer3.esRegUpstreamRegion.name (via dmBlastTab.query)
      sacCer3.hgBlastTab.query (via dmBlastTab.query)
      sacCer3.mmBlastTab.query (via dmBlastTab.query)
      sacCer3.rnBlastTab.query (via dmBlastTab.query)
      sacCer3.sgdBlastTab.query (via dmBlastTab.query)
      sacCer3.sgdBlastTab.target (via dmBlastTab.query)
      sacCer3.sgdCanonical.transcript (via dmBlastTab.query)
      sacCer3.sgdDescription.name (via dmBlastTab.query)
      sacCer3.sgdGene.name (via dmBlastTab.query)
      sacCer3.sgdIsoforms.transcript (via dmBlastTab.query)
      sacCer3.sgdPep.name (via dmBlastTab.query)
      sacCer3.sgdToName.name (via dmBlastTab.query)
      sacCer3.sgdToSwissProt.name (via dmBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
Q0045CG34067-RA58.635271935252815043e-179625
Q0050CG34067-RA40.54744122751730.0000000158.9
Q0055CG34067-RA50663112681650.000000000000773.2
Q0060CG34067-RA54.43793412811784e-2095.9
Q0065CG34067-RA61.94247921224912464e-84309
Q0070CG34067-RA66.253231062232413227e-124441
Q0085CG34073-RA32.1723013952325142199e-22100
Q0105CG34090-RA52.143741771337753775.9999999999999994e-111397
Q0110CG34090-RA53.96139621314251426.999999999999999e-42168
Q0115CG34090-RA55.29170741317351733e-54209

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