Schema for D. mel Proteins - Spaln Alignment of D. melanogaster Proteins (FlyBase Release 5.53)
  Database: DanaWGS    Primary Table: spalnDm3Proteins    Row Count: 26,366
fieldexampleSQL type info
bin 585smallint(5) unsigned range
chrom scaffold_10103varchar(255) values
chromStart 521int(10) unsigned range
chromEnd 3648int(10) unsigned range
name CG16952-PCvarchar(255) values
score 3543int(10) unsigned range
strand -char(1) values
thickStart 521int(10) unsigned range
thickEnd 3648int(10) unsigned range
reserved 0int(10) unsigned range
blockCount 3int(10) unsigned range
blockSizes 138,2476,402,longblob  
chromStarts 0,191,2725longblob  

Sample Rows
 
binchromchromStartchromEndnamescorestrandthickStartthickEndreservedblockCountblockSizeschromStarts
585scaffold_101035213648CG16952-PC3543-521364803138,2476,402,0,191,2725
585scaffold_101035213648CG16952-PB3543-521364803138,2476,402,0,191,2725
585scaffold_101035213648CG16952-PD3543-521364803138,2476,402,0,191,2725
585scaffold_101035213648CG16952-PE3170-5213648022667,402,0,2725
585scaffold_101035213648CG16952-PA3543-521364803138,2476,402,0,191,2725
585scaffold_104920515CG5004-PD108+0515034,120,174,0,71,341
585scaffold_104920515CG5004-PE108+0515034,120,174,0,71,341
586scaffold_10513142336147674Rad23-PB999-14233614767404108,297,95,502,0,199,552,4836
586scaffold_10513142336167315Rad23-PA1295-14233616731505108,297,95,649,66,0,199,552,4836,24913
586scaffold_10513142336167315Rad23-PC1295-14233616731505108,297,95,649,66,0,199,552,4836,24913

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

D. mel Proteins (spalnDm3Proteins) Track Description
 

Description

D. melanogaster proteins from FlyBase were aligned against the D. ananassae gneome assembly using Spaln2 with cross-species parameters.

Methods

The list of genes that aligned to each contig were determined by the best hit in the D. melanogaster blastx track at each genomic locus. mRNA transcripts from each of these genes were aligned against the contig using Spaln2 with cross-species parameters optimized for D. melanogaster: (-Tdromel -yX -yS).

References

Iwata H., and Gotoh, O. Benchmarking spliced alignment programs including Spaln2, an extended version of Spaln that incorporates additional species-specific features. Nucleic Acids Research. 2012, 109