--#####DELETE COMMANDS##############################################
delete from results where STUDY_ID = 'ST000410';
delete from mwtab where STUDY_ID = 'ST000410';
delete from untarg_headings where STUDY_ID = 'ST000410';
delete from untarg_data where STUDY_ID = 'ST000410';
delete from study_status where STUDY_ID = 'ST000410';
delete from study_status_prod where STUDY_ID = 'ST000410';
delete from study_group where STUDY_ID = 'ST000410';
delete from study_version where STUDY_ID = 'ST000410';
delete from project where PROJECT_ID='PR000321';
delete from study where STUDY_ID='ST000410';
delete from subject where SUBJECT_ID='SU000431';
delete from collection where COLLECTION_ID='CO000425';
delete from treatment where TREATMENT_ID='TR000445';
delete from sampleprep where SAMPLEPREP_ID='SP000438';
delete from analysis where ANALYSIS_ID='AN000650';
delete from nmr where NMR_ID='NM000072';
delete from FACTOR where FACTOR_ID ='FA000739';
delete from FACTOR where FACTOR_ID ='FA000740';
delete from sample where MB_SAMPLE_ID between 'SA020072' and 'SA020174';
delete from allfactors where MB_SAMPLE_ID between 'SA020072' and 'SA020174';
delete from sampledata where MB_SAMPLE_ID between 'SA020072' and 'SA020174';
delete from factor_level where factor_level_id between 'FL004776' and 'FL004786';
delete from metabolite where METABOLITE_ID between 'ME136503' and 'ME136516';
delete from measurements where METADATA_ID between 'MD028214' and 'MD028316';
delete from metadata where METADATA_ID between 'MD028214' and 'MD028316';
delete from bindata where METADATA_ID between 'MD028214' and 'MD028316';
delete from bindata_md where METADATA_ID between 'MD028214' and 'MD028316';
