Query to extract the secondary screen data from the eegi db.

eegi-secondary-screen.sql

select 
experiment.well,
experiment.worm_strain_id,
experimentplate.temperature,
experimentplate.date,
experiment.library_stock_id,
wormstrain.*,
librarystock.*,
experiment.*,
experimentplate.*,
clone.*,
-- clonetarget.*
devstarscore.*,
manualscore.*,
manualscorecode.*
-- gene.*
from 
experiment 
join experimentplate on experimentplate.id = experiment.plate_id 
join wormstrain on wormstrain.id = experiment.`worm_strain_id`
join librarystock on librarystock.`id` = experiment.`library_stock_id`
join clone on clone.`id` = librarystock.`intended_clone_id`
-- join clonetarget on clonetarget.`clone_id` = clone.id
join manualscore on manualscore.id = experiment.id
join manualscorecode on manualscorecode.`id` = manualscore.`score_code_id`
join devstarscore on devstarscore.`experiment_id` = experiment.id
-- join gene on gene.`id` = clonetarget.`gene_id`
where experimentplate.screen_stage = 2
-- and librarystock.intended_clone_id = "L4440"
order by 
experiment.well,
experiment.worm_strain_id,
experimentplate.temperature,
experimentplate.date,
experiment.library_stock_id