search

mattb112885 / clusterDbAnalysis

ITEP - Integrated Toolkit for Exploration of microbial Pan-genomes
26 stars 15 forks source link

Bad column names in blastres_selfbit #12

Closed mattb112885 closed 12 years ago

mattb112885 commented 12 years ago

Probably missing an AS in the join command somewhere...

PRAGMA TABLE_INFO(blastres_selfbit);

returns

0|querygene|TEXT|0||0 1|targetgene|TEXT|0||0 2|pctid|REAL|0||0 3|alnlen|INT|0||0 4|mismatches|INT|0||0 5|gapopens|INT|0||0 6|querystart|INT|0||0 7|queryend|INT|0||0 8|substart|INT|0||0 9|subend|INT|0||0 10|evalue|REAL|0||0 11|bitscore|REAL|0||0 12|bitscore:1|REAL|0||0 13|blast_self.bitscore|REAL|0||0

One of columns 12 and 13 should be query self-bit and the other is target self-bit score.

mattb112885 commented 12 years ago

I fixed this problem - testing to make sure it doesn't break anything else before committing. Expect a commit soon.