[Seqbuster-questions] miRNA analysis problem

[Bruce, C. J. <can...@ya...>]

Hello,

I am going through the test data set to familiarize myself with seqbuster. In the miRNA analysis step I got the following error message in the IsoseqDistribution.Rout file:

==============================
[1] "select `id`,`chr`,`freq`,`trimmed5`,`trimmed3`,`addition3`,`mut`,`trimmed3ref`,`trimmed5ref` from `testpro`.`testr`  `freq` >= 0.
01  AND `DB` LIKE 'miRNA' AND `chr` NOT LIKE 'amb' AND  `mut` NOT REGEXP '^0[ACTG]+' AND  `mut` NOT REGEXP '^-[0-9]+[ACTG]+' AND `mut`
NOT REGEXP '^[0-9]+[ACTG]+[0-9]+';"
Error in mysqlExecStatement(conn, statement, ...) :
(could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL serve
r version for the right syntax to use near '>= 0.01  AND `DB` LIKE 'miRNA' AND `chr` NOT LIKE 'amb' AND  `mut` NOT REGEXP '^' at line
1)
Calls: dbSendQuery ... .valueClassTest -> is -> is -> mysqlExecStatement -> .Call
Execution halted
========================

Am I doing something wrong? is there a "WHERE" missing in the SQL query above?


Can Bruce
Bioinformatics Resource
Keck Lab
Yale University