1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
echo "----- pick READ and QUALITY from different tables -----"
TOOL="vdb-sql"
SRC="SRR341578"
DST="$SRC.db"
SRC_COLS_A="ALIGN_ID;SEQ_SPOT_ID;READ"
DST_COLS_A="ALIGN_ID INTEGER, SEQ_SPOT_ID INTEGER, READ"
rm -f $DST
TMPFILE=`mktemp -u`
#create a virtual table to read from
echo "create virtual table SRC_ALIG using vdb( $SRC, table = PRIMARY_ALIGNMENT, columns = $SRC_COLS_A );" >> $TMPFILE
#create a real table
echo "create table ALIG( $DST_COLS_A );" >> $TMPFILE
#copy the data from the virtual table into the real one
echo "insert into ALIG select * from SRC_ALIG;" >> $TMPFILE
#create an index on SEQ_SPOT_ID
echo "create index I_SEQ_SPOT_ID on ALIG( SEQ_SPOT_ID );" >> $TMPFILE
echo "performing copy"
$TOOL $DST < $TMPFILE
rm $TMPFILE
|
