Mercurial > repos > tomnl > anticipated_purity_lcms

annotate backup_sqlite.R @ 22:c8b34df46dae draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
author tomnl
date Fri, 01 Jun 2018 13:41:15 -0400
parents e8291b9d129b
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
21
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
1 library(msPurity)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
2 library(optparse)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
3 library(xcms)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
4 library(CAMERA)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
5 print(sessionInfo())
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
6 print('CREATING DATABASE')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
7
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
8
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
9 xset_pa_filename_fix <- function(opt, pa, xset){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
10
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
11
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
12 if (!is.null(opt$mzML_files) && !is.null(opt$galaxy_names)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
13 # NOTE: Relies on the pa@fileList having the names of files given as 'names' of the variables
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
14 # needs to be done due to Galaxy moving the files around and screwing up any links to files
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
15
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
16 filepaths <- trimws(strsplit(opt$mzML_files, ',')[[1]])
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
17 filepaths <- filepaths[filepaths != ""]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
18 new_names <- basename(filepaths)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
19
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
20 galaxy_names <- trimws(strsplit(opt$galaxy_names, ',')[[1]])
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
21 galaxy_names <- galaxy_names[galaxy_names != ""]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
22
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
23 nsave <- names(pa@fileList)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
24 old_filenames <- basename(pa@fileList)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
25 pa@fileList <- filepaths[match(names(pa@fileList), galaxy_names)]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
26 names(pa@fileList) <- nsave
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
27
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
28 pa@puritydf$filename <- basename(pa@fileList[match(pa@puritydf$filename, old_filenames)])
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
29 pa@grped_df$filename <- basename(pa@fileList[match(pa@grped_df$filename, old_filenames)])
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
30 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
31
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
32
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
33 if(!all(basename(pa@fileList)==basename(xset@filepaths))){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
34 if(!all(names(pa@fileList)==basename(xset@filepaths))){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
35 print('FILELISTS DO NOT MATCH')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
36 message('FILELISTS DO NOT MATCH')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
37 quit(status = 1)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
38 }else{
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
39 xset@filepaths <- unname(pa@fileList)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
40 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
41 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
42
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
43
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
44 return(list(pa, xset))
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
45 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
46
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
47
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
48
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
49
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
50 option_list <- list(
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
51 make_option(c("-o", "--out_dir"), type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
52 make_option("--pa", type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
53 make_option("--xset_xa", type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
54 make_option("--xcms_camera_option", type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
55 make_option("--eic", action="store_true"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
56 make_option("--cores", default=4),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
57 make_option("--mzML_files", type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
58 make_option("--galaxy_names", type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
59 make_option("--grp_peaklist", type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
60 make_option("--db_name", type="character", default='lcms_data.sqlite'),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
61 make_option("--raw_rt_columns", action="store_true"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
62 make_option("--metfrag_result", type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
63 make_option("--sirius_csifingerid_result", type="character"),
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
64 make_option("--probmetab_result", type="character")
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
65 )
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
66
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
67
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
68 # store options
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
69 opt<- parse_args(OptionParser(option_list=option_list))
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
70
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
71 loadRData <- function(rdata_path, name){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
72 #loads an RData file, and returns the named xset object if it is there
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
73 load(rdata_path)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
74 return(get(ls()[ls() == name]))
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
75 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
76
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
77 print(paste('pa', opt$pa))
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
78 print(opt$xset)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
79 print(opt$xcms_camera_option)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
80 # Requires
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
81 pa <- loadRData(opt$pa, 'pa')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
82
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
83
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
84 print(pa@fileList)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
85
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
86
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
87 if (opt$xcms_camera_option=='xcms'){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
88 xset <- loadRData(opt$xset, 'xset')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
89 fix <- xset_pa_filename_fix(opt, pa, xset)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
90 pa <- fix[[1]]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
91 xset <- fix[[2]]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
92 xa <- NULL
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
93 }else{
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
94
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
95 xa <- loadRData(opt$xset, 'xa')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
96 fix <- xset_pa_filename_fix(opt, pa, xa@xcmsSet)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
97 pa <- fix[[1]]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
98 xa@xcmsSet <- fix[[2]]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
99 xset <- NULL
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
100 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
101
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
102
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
103
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
104
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
105
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
106 if(is.null(opt$grp_peaklist)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
107 grp_peaklist = NA
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
108 }else{
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
109 grp_peaklist = opt$grp_peaklist
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
110 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
111
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
112
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
113
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
114
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
115
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
116 db_pth <- msPurity::create_database(pa, xset=xset, xsa=xa, out_dir=opt$out_dir,
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
117 grp_peaklist=grp_peaklist, db_name=opt$db_name)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
118
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
119 print(db_pth)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
120
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
121 if (!is.null(opt$eic)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
122 if (is.null(opt$raw_rt_columns)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
123 rtrawColumns <- FALSE
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
124 }else{
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
125 rtrawColumns <- TRUE
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
126 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
127 if (is.null(xset)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
128 xset <- xa@xcmsSet
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
129 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
130 # previous check should have matched filelists together
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
131 xset@filepaths <- unname(pa@fileList)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
132
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
133 # Saves the EICS into the previously created database
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
134 px <- msPurity::purityX(xset, saveEIC = TRUE,
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
135 cores=1, sqlitePth=db_pth,
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
136 rtrawColumns = rtrawColumns)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
137 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
138
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
139 con <- DBI::dbConnect(RSQLite::SQLite(), db_pth)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
140
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
141 add_extra_table_elucidation <- function(name, pth, db_con, filter_Score=NA, filter_Rank=NA){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
142 if (is.null(pth)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
143 return(0)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
144 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
145 chunk=50
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
146 c = 1
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
147 header_s = FALSE
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
148 con = file(pth, "r")
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
149 while ( TRUE ) {
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
150 line = readLines(con, n = 1)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
151 print(line)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
152 if ( length(line) == 0 ) {
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
153 break
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
154 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
155 line_v <- unlist(strsplit(line, split="\t"))
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
156 if (!header_s){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
157 header = line_v
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
158 header_s = TRUE
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
159 df <- data.frame(ncol=length(header), nrow=0)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
160 print(header)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
161 colnames(df) <- header
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
162 df_blank <- df
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
163 print('CHECK')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
164 write_to_table(df, db_con, name, FALSE, NA, NA)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
165 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
166 print(line_v)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
167
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
168 if (!is.na(filter_Score)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
169 if (line_v[header=='Score']<filter_Score){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
170 next
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
171 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
172 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
173 if (!is.na(filter_Rank)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
174
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
175 if (line_v[header=='Rank']>filter_Rank){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
176 next
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
177 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
178 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
179
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
180 df <- rbind(df, line_v)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
181
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
182
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
183
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
184 if (c>chunk){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
185 write_to_table(df, db_con, name, TRUE, filter_Score, filter_Rank)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
186 c=0
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
187 df <- df_blanks
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
188
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
189 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
190 c = c+1
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
191
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
192 print(line)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
193 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
194
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
195
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
196
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
197 close(con)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
198
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
199
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
200 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
201
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
202 write_to_table <- function(df, db_con, name, append){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
203
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
204 df <- df[!df$UID=='UID',]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
205 print(filter_Score)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
206 print(filter_Rank)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
207 print('filter rank and score')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
208
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
209
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
210 # get peakid, an scan id
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
211 df_ids <- stringr::str_split_fixed(df$UID, '-', 3)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
212 colnames(df_ids) <- c('grp_id', 'file_id', 'pid')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
213 df <- cbind(df_ids, df)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
214 DBI::dbWriteTable(db_con, name=name, value=df, row.names=FALSE, append=append)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
215 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
216
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
217 add_probmetab <- function(pth, con){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
218 if (!is.null(pth)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
219
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
220 df <- read.table(pth, header = TRUE, sep='\t', stringsAsFactors = FALSE, comment.char = "")
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
221 df$grp_id <- 1:nrow(df)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
222 start <- T
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
223 for (i in 1:nrow(df)){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
224
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
225 x <- df[i,]
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
226
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
227
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
228 if(is.na(x$proba) | x$proba =='NA'){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
229
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
230 next
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
231 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
232
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
233 mpc <- stringr::str_split(x$mpc, ';')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
234 proba <- stringr::str_split(x$proba, ';')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
235
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
236 for (j in 1:length(mpc[[1]])){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
237
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
238 row <- c(x$grp_id, x$propmz, mpc[[1]][j], proba[[1]][j])
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
239
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
240 if (start){
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
241 df_out <- data.frame(t(row), stringsAsFactors=F)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
242 start <- F
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
243 }else{
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
244 df_out <- data.frame(rbind(df_out, row), stringsAsFactors=F)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
245 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
246 print(df_out)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
247
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
248 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
249
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
250 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
251
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
252 colnames(df_out) <- c('grp_id', 'propmz', 'mpc', 'proba')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
253 DBI::dbWriteTable(con, name='probmetab_results', value=df_out, row.names=FALSE)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
254
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
255 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
256
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
257
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
258 }
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
259
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
260 add_extra_table_elucidation('metfrag_results', opt$metfrag_result, con, filter_Score=0.6, filter_Rank=NA)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
261 add_extra_table_elucidation('sirius_csifingerid_results', opt$sirius_csifingerid_result, con, filter_Score=NA, filter_Rank=5)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
262 add_probmetab(opt$probmetab_result, con)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
263
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
264
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
265
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
266
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
267 cmd <- paste('SELECT cpg.grpid, cpg.mz, cpg.mzmin, cpg.mzmax, cpg.rt, cpg.rtmin, cpg.rtmax, c_peaks.cid, ',
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
268 'c_peaks.mzmin AS c_peak_mzmin, c_peaks.mzmax AS c_peak_mzmax, ',
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
269 'c_peaks.rtmin AS c_peak_rtmin, c_peaks.rtmax AS c_peak_rtmax, s_peak_meta.*, fileinfo.filename, fileinfo.nm_save ',
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
270 'FROM c_peak_groups AS cpg ',
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
271 'LEFT JOIN c_peak_X_c_peak_group AS cXg ON cXg.grpid=cpg.grpid ',
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
272 'LEFT JOIN c_peaks on c_peaks.cid=cXg.cid ',
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
273 'LEFT JOIN c_peak_X_s_peak_meta AS cXs ON cXs.cid=c_peaks.cid ',
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
274 'LEFT JOIN s_peak_meta ON cXs.pid=s_peak_meta.pid ',
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
275 'LEFT JOIN fileinfo ON s_peak_meta.fileid=fileinfo.fileid')
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
276
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
277 print(cmd)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
278 cpeakgroup_msms <- DBI::dbGetQuery(con, cmd)
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
279
e8291b9d129b planemo upload for repository https://github.com/computational-metabolomics/mspurity-galaxy commit 04023134d8f28e85927ca293373c506484149ead-dirty
tomnl
parents:
diff changeset
280 write.table(cpeakgroup_msms, file.path(opt$out_dir, 'cpeakgroup_msms.tsv'), row.names=FALSE, sep='\t')