Schema for dmBlastTab
  Database: ce2    Primary Table: dmBlastTab    Row Count: 4,587   Data last updated: 2007-07-18
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query T21H3.3varchar(255) values Name of sequence in this assembly (query)
target CG8472-RBvarchar(255) values Name of sequence in other assembly (target)
identity 99.33float range Percent identity
aliLength 149int(10) unsigned range Length of alignment
mismatch 1int(10) unsigned range Number of mismatches
gapOpen 0int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 149int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 149int(10) unsigned range End in target (non-inclusive)
eValue 7.000000000000001e-81double range Expectation value
bitScore 295double range Bit score

Connected Tables and Joining Fields
        ce2.hgBlastTab.query (via dmBlastTab.query)
      ce2.kimExpDistance.query (via dmBlastTab.query)
      ce2.kimExpDistance.target (via dmBlastTab.query)
      ce2.orfToGene.name (via dmBlastTab.query)
      ce2.sangerBlastTab.query (via dmBlastTab.query)
      ce2.sangerBlastTab.target (via dmBlastTab.query)
      ce2.sangerCanonical.transcript (via dmBlastTab.query)
      ce2.sangerGene.name (via dmBlastTab.query)
      ce2.sangerIsoforms.transcript (via dmBlastTab.query)
      ce2.sangerLinks.orfName (via dmBlastTab.query)
      ce2.sangerPep.name (via dmBlastTab.query)
      ce2.sangerToKim.name (via dmBlastTab.query)
      ce2.sangerToPfam.name (via dmBlastTab.query)
      ce2.sangerToRefSeq.name (via dmBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
T21H3.3CG8472-RB99.3314910014901497.000000000000001e-81295
F38A6.2CG13466-RA26.96649396192718882118142e-52204
F38A6.1CG10002-RA43.852449431333561253474.0000000000000005e-49192
F28C1.3bCG31635-RA31.913041876383411804654.999999999999999e-32136
F23H12.2CG7654-RA37.24145821414901363e-2094.7
F23H11.9CG4774-RC38.572101242312411063112e-38155
C02H7.3bCG5627-RA45.3150122381415962247204e-116416
F38A1.8CG2522-RA35.8446624210044604291e-69260
T26C5.3bCG9706-RB50.11467218469536725246e-110394
C46H3.2bCG12424-RB44.271317211993302573871e-27121

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