search

proteomicsunitcrg / qcloud2-pipeline

QCloud2 pipeline
5 stars 1 forks source link

Annotations mapping QCloud1->QCloud2 #41

Closed rolivella closed 4 years ago

rolivella commented 4 years ago 
SELECT 
distinct(annotation_code.annotation) as Op_annotation#The annotation made by our operator
FROM file
INNER JOIN feature
ON feature.idfile=file.idfile
LEFT JOIN bar
ON bar.creationdate=file.creationdate
LEFT JOIN annotation_code
ON annotation_code.code=bar.annotation
WHERE file.creationdate BETWEEN '2017-01-01 00:00:00' AND '2017-12-31 23:59:59'#Time window
AND file.instrument = "v"#Orbitrap Fusion Lumos
AND openms <> "ERR"#Discard RAW files that were not able to be processed by our pipeline
AND file.type="hela"#only Hela
AND annotation_code.annotation IS NOT NULL;

Shared annotations for Velos and Lumos 2017 and 2018 in QCloud1:

Op_annotation LC and/or MS service Calibration Column and/or precolumn change LC and/or MS Troubleshooting Cleaning New QC aliquote

rolivella commented 4 years ago

Mapping:

-LC and/or MS service->Service Visit -Calibration->MS calibration -Column and/or precolumn change->Splitted in "Column changed" & "Pre-column changed" -LC and/or MS Troubleshooting->Splitted in "LC maintenance" & "MS maintenance" -Cleaning->Splitted in "Ion source cleaning" & "MS full cleaning" -New QC aliquote -> QC aliquote changed

rolivella commented 4 years ago

Pending to map (asked to cristina):

'SR', 'System ready' 'SERV', 'LC and/or MS service' 'US', 'Unstable spray' 'NC', 'Non conformity'

rolivella commented 4 years ago

All mapping:

QCloud1 QCloud2
LC and/or MS service Service Visit
Calibration MS calibration
Column and/or precolumn change Splitted in "Column changed" & "Pre-column changed"
LC and/or MS Troubleshooting Splitted in "LC maintenance" & "MS maintenance"
Cleaning Splitted in "Ion source cleaning" & "MS full cleaning"
New QC aliquote QC aliquote changed
System ready Problem Solved
LC and/or MS service Service Visit
Unstable spray Spray issues
Non conformity' N/A