SELECT p.code, sp.name AS specimen, os.id AS os_id, os.name AS os, os.stimulus_name , oe.id AS oe_id, oe.workflow_state AS oe_state
FROM specimens sp JOIN ophys_sessions os ON os.specimen_id=sp.id AND os.workflow_state = 'uploaded' JOIN projects p ON p.id=os.project_id
JOIN ophys_experiments oe ON oe.ophys_session_id=os.id AND oe.workflow_state NOT IN ('failed','processing')
WHERE p.code LIKE 'VisCodingTargeted%'
ORDER BY 1,2,5;
Create NWB files and SDK access methods for Visual Coding Targeted Experiments data sets
VisCodingTargetedTFxSF VisCodingTargetedContrast VisCodingTargetedMovies VisCodingTargetedScenes VisCodingTargetedRunningDecoding VisCodingTargetedSignalNoise
LIMS db query to get the data sets