Hello, I am wondering why the output format is different for the two queries below that only differ by the 'chr' where clause? Fastbit v1.3.5 is installed.
Query1 ====== ibis -d /opt/apache/CoGe/data//experiments/0/0/0/378 -q "select chr,start,stop,strand,value1,value2 where chr like 'NC_006090%' and start > 0 and stop < 99999" "NC_006090.3", 32386, 32412, 1, 0.0332527, 0.0012 "NC_006090.3", 32857, 32913, 1, 0.00270446, 5.4e-12 "NC_006090.3", 68859, 68900, 1, 0.000538718, 0.00096 "NC_006090.3", 69668, 69685, -1, 0.0133321, 0.0059 doQuery:: evaluate(SELECT chr,start,stop,strand,value1,value2 FROM 4 WHERE chr like 'NC_006090%' and start > 0 and stop < 99999) produced 5 hits Query2 ====== ibis -d /opt/apache/CoGe/data//experiments/0/0/0/378 -q "select chr,start,stop,strand,value1,value2 where chr='NC_006090.3' and start > 0 and stop < 99999" doQuaere -- "SELECT chr,start,stop,strand,value1,value2 WHERE chr='NC_006090.3' and start > 0 and stop < 99999" produced a table with 5 rows and 6 columns doQuaere -- the first row (of 5) from the result table for "SELECT chr,start,stop,strand,value1,value2 WHERE chr='NC_006090.3' and start > 0 and stop < 99999" "NC_006090.3", 32386, 32412, 1, 0.0332527017466677, 0.0012 The db was created with ardea -m \"chr:key, start:unsigned long, stop:unsigned long, strand:byte, value1:double, value2:double\" Thanks! Matt _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
