Select Code to Download

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 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; ech
+o; echo -n "Total number of HITS: "; grep -cv ' -$' result) |tee resu
+lt.fmt

1190    31277    A > T    1    0    0     -
1190    31607    C > A    0    3    1     -
...
1190    32496    A > G    0    3    0     -

Total number of HITS: 3