sort -ck3 file1.db
sort -ck2 file2.query
####
join -a 2 -1 3 -2 2 -e - -o 2.1,2.2,2.3,2.4,2.5,2.6,2.7,2.8,1.1 file1.db file2.query | tee result
##
##
1190 31277 A > T 1 0 0 -
1190 31607 C > A 0 3 1 -
1190 31629 C > T 0 2 0 -
1190 31789 A > G 1 2 5 zm1829427
1190 31882 A > C 0 4 0 -
1190 31883 T > A 0 4 0 zm445312
1190 31883 T > C 2 2 5 zm445312
1190 32199 C > T 0 1 1 -
1190 32487 T > C 0 1 1 -
1190 32496 A > G 0 3 0 -
##
##
(sed 's/^\([^ ]*\) \([^ ]*\) \([^ ]* [^ ]* [^ ]*\) \([^ ]*\) \([^ ]*\) \([^ ]*\)\(.*\)/\1 \2 \3 \4 \5 \6 \7/' result; echo; echo -n "Total number of HITS: "; grep -cv ' -$' result) |tee result.fmt
##
##
1190 31277 A > T 1 0 0 -
1190 31607 C > A 0 3 1 -
1190 31629 C > T 0 2 0 -
1190 31789 A > G 1 2 5 zm1829427
1190 31882 A > C 0 4 0 -
1190 31883 T > A 0 4 0 zm445312
1190 31883 T > C 2 2 5 zm445312
1190 32199 C > T 0 1 1 -
1190 32487 T > C 0 1 1 -
1190 32496 A > G 0 3 0 -
Total number of HITS: 3