Schema for dmBlastTab
  Database: danRer3    Primary Table: dmBlastTab    Row Count: 5,253   Data last updated: 2007-04-06
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENSDART00000067854varchar(255) values Name of sequence in this assembly (query)
target CG4091-RAvarchar(255) values Name of sequence in other assembly (target)
identity 43.17float range Percent identity
aliLength 183int(10) unsigned range Length of alignment
mismatch 104int(10) unsigned range Number of mismatches
gapOpen 0int(10) unsigned range Number of gap openings
qStart 3int(10) unsigned range Start in query (0 based)
qEnd 186int(10) unsigned range End in query (non-inclusive)
tStart 5int(10) unsigned range Start in target (0 based)
tEnd 188int(10) unsigned range End in target (non-inclusive)
eValue 9.999999999999999e-33double range Expectation value
bitScore 135double range Bit score

Connected Tables and Joining Fields
        knownGeneV39.knownToEnsembl.value (via dmBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENSDART00000067854CG4091-RA43.171831040318651889.999999999999999e-33135
ENSDART00000067814CG5452-RA46.38207109210216222282e-52201
ENSDART00000067803CG6779-RA84.42231360423562371e-107385
ENSDART00000067792CG15224-RE88.37215250021502152e-107384
ENSDART00000067779CG9210-RA39.59533257768588435241e-96352
ENSDART00000067776CG17060-RA78.16206383020102047e-86312
ENSDART00000067765CG4746-RA75.77359870035963651e-166582
ENSDART00000067754CG17347-RA48.631467114150311734e-36146
ENSDART00000067751CG14145-RA43.629453017111431371e-1784.3
ENSDART00000067740CG3450-RA83.05591000590598.000000000000001e-24104

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