Skip to content

Instantly share code, notes, and snippets.

@briandrawert
Created March 28, 2014 19:21
Show Gist options
  • Save briandrawert/9840900 to your computer and use it in GitHub Desktop.
Save briandrawert/9840900 to your computer and use it in GitHub Desktop.
Fungal frogs: select all the data points in the baseline groups, create new groups for the antibody model
SELECT a.ID as 'old_ID', b.ID, b.data_s_star_value, b.`param_Ac`, b.run_tag, g.name, g.model, g.group_name,
CONCAT('groupA__S_star=',CAST(b.data_s_star_value as char),'__Ac=',b.`param_Ac`) as 'new group'
FROM `stochastic_parameter_search` a
JOIN `stochastic_parameter_search` b ON (
a.`param_Nfrogs` = b.`param_Nfrogs` AND
a.`param_gamma` = b.`param_gamma` AND
a.`param_eta` = b.`param_eta` AND
a.`param_nu` = b.`param_nu` AND
a.`param_f` = b.`param_f` AND
a.`param_sigma` = b.`param_sigma` AND
a.`param_mu` = b.`param_mu`
)
JOIN `stochastic_parameter_groups` g ON (
a.ID = g.ID
)
WHERE g.model = 'baseline'
AND g.name = 'groupA'
AND b.run_tag = 'antibody_model'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment