Schema for drBlastTab
  Database: dm3    Primary Table: drBlastTab    Row Count: 5,930   Data last updated: 2013-10-11
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query CG10354-RAvarchar(255) values Name of sequence in this assembly (query)
target ENSDART00000100246varchar(255) values Name of sequence in other assembly (target)
identity 55.73float range Percent identity
aliLength 829int(10) unsigned range Length of alignment
mismatch 326int(10) unsigned range Number of mismatches
gapOpen 9int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 791int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 826int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 890double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
CG10354-RAENSDART0000010024655.738293269079108260890
CG9773-RAENSDART0000005921255.0825610432927422588e-71264
CG13761-RBENSDART0000010523627.51429265833454234146e-47186
CG8344-RAENSDART0000009146668.671117340624113716112701514
CG5826-RAENSDART0000010194066.4919463138232562488e-74273
CG14750-RAENSDART0000015243342.44172981317421743e-42168
CG14749-RAENSDART0000012822732.2931920753656773987152e-43175
CG3408-RAENSDART0000010558444.38169902517111693e-35146
CG32555-RAENSDART0000008669633.14103264323310091110228e-159559
CG9333-RBENSDART0000013394336.4877346110077107454e-141499

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