Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and m_test_result.test_id=m_test.test_id
and m_morphology_defect.result_id=m_' at line 19 select
p53_dose,
day_scored,
m_zfin_anatomy.anatomy_id,
anatomy_name,
quality_value,
pato_id,
pato_attribute,
pato_value,
sum(number_fish_positive)/sum(number_fish_screened) as p,
dose_in_nanogram as x
from m_test,
m_test_result,
m_morphology_defect,
m_defect,
m_zfin_anatomy
where
morpholino_id=
and m_test_result.test_id=m_test.test_id
and m_morphology_defect.result_id=m_test_result.result_id
and m_morphology_defect.defect_id=m_defect.defect_id
and name not like '% normal%'
and name not like '%cell death%'
and dose_in_nanogram>0 and number_fish_screened>0 and number_fish_screened is not null and quality_value!=''
and m_zfin_anatomy.anatomy_id=m_defect.anatomy_id
group by dose_in_nanogram,anatomy_id,quality_value,p53_dose,day_scored
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and t.test_id=r.test_id
and r.result_id=md.result_id
and md.defect_id=d.defe' at line 11 select
d.name as name,
sum(number_fish_positive)/sum(number_fish_screened) as p
from
m_test as t,
m_test_result as r,
m_morphology_defect as md,
m_defect as d
where
t.morpholino_id=
and t.test_id=r.test_id
and r.result_id=md.result_id
and md.defect_id=d.defect_id
and r.number_fish_screened>0
and ((d.name not like '% normal%') or (d.name like '% normal%' and number_fish_positive/number_fish_screened<0.3))
and ((d.name not like '%plieotropic%') or (d.name like '%plieotropic%' and number_fish_positive/number_fish_screened<0.5))
and ((d.name not like '%cell death%') or (d.name like '%cell death%' and number_fish_positive/number_fish_screened<0.9))
and d.name not like '%LD50%'
group by d.name Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and m_test_result.test_id=m_test.test_id
and m_test.screen_id=m_screen.screen' at line 10 select
p53_dose as p53,m_screen.screen_name as name,100*sum(number_fish_positive)/sum(number_fish_screened) as y,
dose_in_nanogram as x
from m_test,
m_test_result,
m_morphology_defect,
m_defect,
m_screen where
morpholino_id=
and m_test_result.test_id=m_test.test_id
and m_test.screen_id=m_screen.screen_id
and m_morphology_defect.result_id=m_test_result.result_id
and m_morphology_defect.defect_id=m_defect.defect_id
and m_defect.name like '% normal%'
and dose_in_nanogram>0 and number_fish_screened is not null and number_fish_screened>0
group by p53_dose,m_test.screen_id,dose_in_nanogram Morpholino DatabaseMorpholino Database
Note: When more than one data point existed per dose an average was used. p53 morpholino co-injections were used to minimize non-specific toxicity effects (Robu et al. PLoS Genetics 2007)
