Mercurial > repos > galaxyp > abrf2017_workshop

comparison Galaxy-Workflow-ABRF_2017_Taxonomy_Comparison_Workflow.ga @ 0:eb71034189fb draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/workflows/abrf2017_workshop commit bfcee2067ac57cc7136bb6a4281b1748a36776d5
author galaxyp
date Thu, 02 Mar 2017 15:42:24 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:eb71034189fb
1 {
2 "a_galaxy_workflow": "true",
3 "annotation": "",
4 "format-version": "0.1",
5 "name": "ABRF 2017:Taxonomy Comparison Workflow",
6 "steps": {
7 "0": {
8 "annotation": "",
9 "content_id": null,
10 "id": 0,
11 "input_connections": {},
12 "inputs": [
13 {
14 "description": "",
15 "name": "PSM Report (Bering Strait)"
16 }
17 ],
18 "label": null,
19 "name": "Input dataset",
20 "outputs": [],
21 "position": {
22 "left": 296,
23 "top": 186
24 },
25 "tool_errors": null,
26 "tool_id": null,
27 "tool_state": "{\"name\": \"PSM Report (Bering Strait)\"}",
28 "tool_version": null,
29 "type": "data_input",
30 "uuid": "c404eaed-7c90-4b48-82c4-9083bdb6db29",
31 "workflow_outputs": [
32 {
33 "label": null,
34 "output_name": "output",
35 "uuid": "0bfee776-11e1-4553-a7ee-25fd0c628891"
36 }
37 ]
38 },
39 "1": {
40 "annotation": "",
41 "content_id": null,
42 "id": 1,
43 "input_connections": {},
44 "inputs": [
45 {
46 "description": "",
47 "name": "PSM Report (Chukchi Sea)"
48 }
49 ],
50 "label": null,
51 "name": "Input dataset",
52 "outputs": [],
53 "position": {
54 "left": 352,
55 "top": 596.5
56 },
57 "tool_errors": null,
58 "tool_id": null,
59 "tool_state": "{\"name\": \"PSM Report (Chukchi Sea)\"}",
60 "tool_version": null,
61 "type": "data_input",
62 "uuid": "c6e42b4c-4116-48eb-92a2-bebdbceaba1d",
63 "workflow_outputs": [
64 {
65 "label": null,
66 "output_name": "output",
67 "uuid": "0d4f355a-1f05-49a9-a5a3-2f58fc25ca32"
68 }
69 ]
70 },
71 "2": {
72 "annotation": "",
73 "content_id": "toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/2.0.0",
74 "id": 2,
75 "input_connections": {
76 "tables_0|table": {
77 "id": 0,
78 "output_name": "output"
79 }
80 },
81 "inputs": [
82 {
83 "description": "runtime parameter for tool Query Tabular",
84 "name": "add_to_database"
85 }
86 ],
87 "label": null,
88 "name": "Query Tabular",
89 "outputs": [
90 {
91 "name": "sqlitedb",
92 "type": "sqlite"
93 },
94 {
95 "name": "output",
96 "type": "tabular"
97 }
98 ],
99 "position": {
100 "left": 453,
101 "top": 335
102 },
103 "post_job_actions": {
104 "HideDatasetActionsqlitedb": {
105 "action_arguments": {},
106 "action_type": "HideDatasetAction",
107 "output_name": "sqlitedb"
108 }
109 },
110 "tool_errors": null,
111 "tool_id": "toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/2.0.0",
112 "tool_shed_repository": {
113 "changeset_revision": "e84d1c3bf4fe",
114 "name": "query_tabular",
115 "owner": "jjohnson",
116 "tool_shed": "toolshed.g2.bx.psu.edu"
117 },
118 "tool_state": "{\"tables\": \"[{\\\"tbl_opts\\\": {\\\"load_named_columns\\\": \\\"true\\\", \\\"pkey_autoincr\\\": \\\"\\\", \\\"table_name\\\": \\\"psm\\\", \\\"col_names\\\": \\\"id,,sequence,,,,,,,,,,,,,,,,,,,,confidence,validation\\\", \\\"indexes\\\": []}, \\\"__index__\\\": 0, \\\"input_opts\\\": {\\\"linefilters\\\": [{\\\"filter\\\": {\\\"regex_action\\\": \\\"include_match\\\", \\\"regex_pattern\\\": \\\"^\\\\\\\\d\\\", \\\"__current_case__\\\": 2, \\\"filter_type\\\": \\\"regex\\\"}, \\\"__index__\\\": 0}]}, \\\"table\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}]\", \"save_db\": \"\\\"true\\\"\", \"__page__\": 0, \"__rerun_remap_job_id__\": null, \"no_header\": \"\\\"true\\\"\", \"sqlquery\": \"\\\"SELECT distinct sequence \\\\nFROM psm \\\\nWHERE validation IS NOT 'Confident' AND confidence >= 95 \\\\nORDER BY sequence\\\"\", \"add_to_database\": \"{\\\"withdb\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}\", \"workdb\": \"\\\"workdb.sqlite\\\"\"}",
119 "tool_version": "2.0.0",
120 "type": "tool",
121 "uuid": "90d1308d-cd0a-4dc7-8da8-eb1a311e3825",
122 "workflow_outputs": [
123 {
124 "label": null,
125 "output_name": "output",
126 "uuid": "cb6d774d-7930-4c42-b3dd-7e523acc58a2"
127 }
128 ]
129 },
130 "3": {
131 "annotation": "",
132 "content_id": "toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/2.0.0",
133 "id": 3,
134 "input_connections": {
135 "tables_0|table": {
136 "id": 1,
137 "output_name": "output"
138 }
139 },
140 "inputs": [
141 {
142 "description": "runtime parameter for tool Query Tabular",
143 "name": "add_to_database"
144 }
145 ],
146 "label": null,
147 "name": "Query Tabular",
148 "outputs": [
149 {
150 "name": "sqlitedb",
151 "type": "sqlite"
152 },
153 {
154 "name": "output",
155 "type": "tabular"
156 }
157 ],
158 "position": {
159 "left": 562,
160 "top": 646.5
161 },
162 "post_job_actions": {
163 "HideDatasetActionsqlitedb": {
164 "action_arguments": {},
165 "action_type": "HideDatasetAction",
166 "output_name": "sqlitedb"
167 }
168 },
169 "tool_errors": null,
170 "tool_id": "toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/2.0.0",
171 "tool_shed_repository": {
172 "changeset_revision": "e84d1c3bf4fe",
173 "name": "query_tabular",
174 "owner": "jjohnson",
175 "tool_shed": "toolshed.g2.bx.psu.edu"
176 },
177 "tool_state": "{\"tables\": \"[{\\\"tbl_opts\\\": {\\\"load_named_columns\\\": \\\"true\\\", \\\"pkey_autoincr\\\": \\\"\\\", \\\"table_name\\\": \\\"psm\\\", \\\"col_names\\\": \\\"id,,sequence,,,,,,,,,,,,,,,,,,,,confidence,validation\\\", \\\"indexes\\\": []}, \\\"__index__\\\": 0, \\\"input_opts\\\": {\\\"linefilters\\\": [{\\\"filter\\\": {\\\"regex_action\\\": \\\"include_match\\\", \\\"regex_pattern\\\": \\\"^\\\\\\\\d\\\", \\\"__current_case__\\\": 2, \\\"filter_type\\\": \\\"regex\\\"}, \\\"__index__\\\": 0}]}, \\\"table\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}]\", \"save_db\": \"\\\"true\\\"\", \"__page__\": 0, \"__rerun_remap_job_id__\": null, \"no_header\": \"\\\"false\\\"\", \"sqlquery\": \"\\\"SELECT distinct sequence \\\\nFROM psm \\\\nWHERE validation IS NOT 'Confident' AND confidence >= 95 \\\\nORDER BY sequence\\\"\", \"add_to_database\": \"{\\\"withdb\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}\", \"workdb\": \"\\\"workdb.sqlite\\\"\"}",
178 "tool_version": "2.0.0",
179 "type": "tool",
180 "uuid": "f512a71f-f718-4eca-9879-95c876274d57",
181 "workflow_outputs": [
182 {
183 "label": null,
184 "output_name": "output",
185 "uuid": "b2c1c6ac-672f-471f-8f81-1e9d7aaf1b18"
186 }
187 ]
188 },
189 "4": {
190 "annotation": "",
191 "content_id": "toolshed.g2.bx.psu.edu/repos/galaxyp/unipept/unipept/2.0.1",
192 "id": 4,
193 "input_connections": {
194 "peptide_src|input_tsv": {
195 "id": 2,
196 "output_name": "output"
197 }
198 },
199 "inputs": [
200 {
201 "description": "runtime parameter for tool Unipept",
202 "name": "peptide_src"
203 }
204 ],
205 "label": null,
206 "name": "Unipept",
207 "outputs": [
208 {
209 "name": "output_json",
210 "type": "d3_hierarchy"
211 },
212 {
213 "name": "output_tsv",
214 "type": "tabular"
215 },
216 {
217 "name": "output_csv",
218 "type": "csv"
219 },
220 {
221 "name": "output_unmatched",
222 "type": "tabular"
223 }
224 ],
225 "position": {
226 "left": 754.5,
227 "top": 327.5
228 },
229 "post_job_actions": {
230 "HideDatasetActionoutput_csv": {
231 "action_arguments": {},
232 "action_type": "HideDatasetAction",
233 "output_name": "output_csv"
234 },
235 "HideDatasetActionoutput_unmatched": {
236 "action_arguments": {},
237 "action_type": "HideDatasetAction",
238 "output_name": "output_unmatched"
239 },
240 "RenameDatasetActionoutput_json": {
241 "action_arguments": {
242 "newname": "Unipept: TAXONOMY Phylogenetic Tree (Bering Strait)"
243 },
244 "action_type": "RenameDatasetAction",
245 "output_name": "output_json"
246 }
247 },
248 "tool_errors": null,
249 "tool_id": "toolshed.g2.bx.psu.edu/repos/galaxyp/unipept/unipept/2.0.1",
250 "tool_shed_repository": {
251 "changeset_revision": "34758ab8aaa4",
252 "name": "unipept",
253 "owner": "galaxyp",
254 "tool_shed": "toolshed.g2.bx.psu.edu"
255 },
256 "tool_state": "{\"__page__\": 0, \"outputs\": \"[\\\"tsv\\\", \\\"json\\\"]\", \"__rerun_remap_job_id__\": null, \"peptide_src\": \"{\\\"column\\\": \\\"1\\\", \\\"fmt\\\": \\\"tabular\\\", \\\"input_tsv\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}, \\\"__current_case__\\\": 1}\", \"strict\": \"\\\"false\\\"\", \"unipept\": \"{\\\"allfields\\\": \\\"false\\\", \\\"extra\\\": \\\"false\\\", \\\"api\\\": \\\"pept2lca\\\", \\\"names\\\": \\\"true\\\", \\\"__current_case__\\\": 0, \\\"equate_il\\\": \\\"true\\\"}\"}",
257 "tool_version": "2.0.1",
258 "type": "tool",
259 "uuid": "829dee5e-7a29-4dce-857a-2c73f5967fc6",
260 "workflow_outputs": [
261 {
262 "label": null,
263 "output_name": "output_tsv",
264 "uuid": "3b30dfdc-5778-4862-8d14-819c4a1c81a5"
265 },
266 {
267 "label": null,
268 "output_name": "output_json",
269 "uuid": "d1d13d17-c7b2-4ebc-a4e6-822b05a99eea"
270 }
271 ]
272 },
273 "5": {
274 "annotation": "",
275 "content_id": "toolshed.g2.bx.psu.edu/repos/galaxyp/unipept/unipept/2.0.1",
276 "id": 5,
277 "input_connections": {
278 "peptide_src|input_tsv": {
279 "id": 3,
280 "output_name": "output"
281 }
282 },
283 "inputs": [
284 {
285 "description": "runtime parameter for tool Unipept",
286 "name": "peptide_src"
287 }
288 ],
289 "label": null,
290 "name": "Unipept",
291 "outputs": [
292 {
293 "name": "output_json",
294 "type": "d3_hierarchy"
295 },
296 {
297 "name": "output_tsv",
298 "type": "tabular"
299 },
300 {
301 "name": "output_csv",
302 "type": "csv"
303 },
304 {
305 "name": "output_unmatched",
306 "type": "tabular"
307 }
308 ],
309 "position": {
310 "left": 869,
311 "top": 628.5
312 },
313 "post_job_actions": {
314 "HideDatasetActionoutput_csv": {
315 "action_arguments": {},
316 "action_type": "HideDatasetAction",
317 "output_name": "output_csv"
318 },
319 "HideDatasetActionoutput_unmatched": {
320 "action_arguments": {},
321 "action_type": "HideDatasetAction",
322 "output_name": "output_unmatched"
323 },
324 "RenameDatasetActionoutput_json": {
325 "action_arguments": {
326 "newname": "Unipept: TAXONOMY Phylogenetic Tree (Chukchi Sea)"
327 },
328 "action_type": "RenameDatasetAction",
329 "output_name": "output_json"
330 }
331 },
332 "tool_errors": null,
333 "tool_id": "toolshed.g2.bx.psu.edu/repos/galaxyp/unipept/unipept/2.0.1",
334 "tool_shed_repository": {
335 "changeset_revision": "34758ab8aaa4",
336 "name": "unipept",
337 "owner": "galaxyp",
338 "tool_shed": "toolshed.g2.bx.psu.edu"
339 },
340 "tool_state": "{\"__page__\": 0, \"outputs\": \"[\\\"tsv\\\", \\\"json\\\"]\", \"__rerun_remap_job_id__\": null, \"peptide_src\": \"{\\\"column\\\": \\\"1\\\", \\\"fmt\\\": \\\"tabular\\\", \\\"input_tsv\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}, \\\"__current_case__\\\": 1}\", \"strict\": \"\\\"false\\\"\", \"unipept\": \"{\\\"allfields\\\": \\\"false\\\", \\\"extra\\\": \\\"false\\\", \\\"api\\\": \\\"pept2lca\\\", \\\"names\\\": \\\"true\\\", \\\"__current_case__\\\": 0, \\\"equate_il\\\": \\\"true\\\"}\"}",
341 "tool_version": "2.0.1",
342 "type": "tool",
343 "uuid": "a9912f29-258c-4327-9b45-67cccb557cf3",
344 "workflow_outputs": [
345 {
346 "label": null,
347 "output_name": "output_tsv",
348 "uuid": "cc2030a9-5328-445a-bc90-5ce555b57275"
349 },
350 {
351 "label": null,
352 "output_name": "output_json",
353 "uuid": "d1495e86-d619-4bf5-b573-b0afcb5aebbc"
354 }
355 ]
356 },
357 "6": {
358 "annotation": "",
359 "content_id": "toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/2.0.0",
360 "id": 6,
361 "input_connections": {
362 "tables_0|table": {
363 "id": 0,
364 "output_name": "output"
365 },
366 "tables_1|table": {
367 "id": 4,
368 "output_name": "output_tsv"
369 },
370 "tables_2|table": {
371 "id": 1,
372 "output_name": "output"
373 },
374 "tables_3|table": {
375 "id": 5,
376 "output_name": "output_tsv"
377 }
378 },
379 "inputs": [
380 {
381 "description": "runtime parameter for tool Query Tabular",
382 "name": "add_to_database"
383 }
384 ],
385 "label": null,
386 "name": "Query Tabular",
387 "outputs": [
388 {
389 "name": "sqlitedb",
390 "type": "sqlite"
391 },
392 {
393 "name": "output",
394 "type": "tabular"
395 }
396 ],
397 "position": {
398 "left": 1342,
399 "top": 298.5
400 },
401 "post_job_actions": {
402 "HideDatasetActionsqlitedb": {
403 "action_arguments": {},
404 "action_type": "HideDatasetAction",
405 "output_name": "sqlitedb"
406 },
407 "RenameDatasetActionoutput": {
408 "action_arguments": {
409 "newname": "Unipept: TAXONOMY GENUS PSMs Peptides (Bering Strait and Chukchi Sea)"
410 },
411 "action_type": "RenameDatasetAction",
412 "output_name": "output"
413 }
414 },
415 "tool_errors": null,
416 "tool_id": "toolshed.g2.bx.psu.edu/repos/jjohnson/query_tabular/query_tabular/2.0.0",
417 "tool_shed_repository": {
418 "changeset_revision": "e84d1c3bf4fe",
419 "name": "query_tabular",
420 "owner": "jjohnson",
421 "tool_shed": "toolshed.g2.bx.psu.edu"
422 },
423 "tool_state": "{\"tables\": \"[{\\\"tbl_opts\\\": {\\\"load_named_columns\\\": \\\"true\\\", \\\"pkey_autoincr\\\": \\\"\\\", \\\"table_name\\\": \\\"bering_psm\\\", \\\"col_names\\\": \\\"id,,sequence,,,,,,,,,,,,,,,,,,,,confidence,validation\\\", \\\"indexes\\\": []}, \\\"__index__\\\": 0, \\\"input_opts\\\": {\\\"linefilters\\\": [{\\\"filter\\\": {\\\"regex_action\\\": \\\"include_match\\\", \\\"regex_pattern\\\": \\\"^\\\\\\\\d\\\", \\\"__current_case__\\\": 2, \\\"filter_type\\\": \\\"regex\\\"}, \\\"__index__\\\": 0}]}, \\\"table\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}, {\\\"tbl_opts\\\": {\\\"load_named_columns\\\": \\\"true\\\", \\\"pkey_autoincr\\\": \\\"\\\", \\\"table_name\\\": \\\"bering_lca\\\", \\\"col_names\\\": \\\"peptide,,,,,,,,,,,,,,,,,,,,,genus\\\", \\\"indexes\\\": []}, \\\"__index__\\\": 1, \\\"input_opts\\\": {\\\"linefilters\\\": [{\\\"filter\\\": {\\\"comment_char\\\": \\\"#\\\", \\\"__current_case__\\\": 1, \\\"filter_type\\\": \\\"comment\\\"}, \\\"__index__\\\": 0}]}, \\\"table\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}, {\\\"tbl_opts\\\": {\\\"load_named_columns\\\": \\\"true\\\", \\\"pkey_autoincr\\\": \\\"\\\", \\\"table_name\\\": \\\"chukchi_psm\\\", \\\"col_names\\\": \\\"id,,sequence,,,,,,,,,,,,,,,,,,,,confidence,validation\\\", \\\"indexes\\\": []}, \\\"__index__\\\": 2, \\\"input_opts\\\": {\\\"linefilters\\\": [{\\\"filter\\\": {\\\"regex_action\\\": \\\"include_match\\\", \\\"regex_pattern\\\": \\\"^\\\\\\\\d\\\", \\\"__current_case__\\\": 2, \\\"filter_type\\\": \\\"regex\\\"}, \\\"__index__\\\": 0}]}, \\\"table\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}, {\\\"tbl_opts\\\": {\\\"load_named_columns\\\": \\\"true\\\", \\\"pkey_autoincr\\\": \\\"\\\", \\\"table_name\\\": \\\"chukchi_lca\\\", \\\"col_names\\\": \\\"peptide,,,,,,,,,,,,,,,,,,,,,genus\\\", \\\"indexes\\\": []}, \\\"__index__\\\": 3, \\\"input_opts\\\": {\\\"linefilters\\\": [{\\\"filter\\\": {\\\"comment_char\\\": \\\"#\\\", \\\"__current_case__\\\": 1, \\\"filter_type\\\": \\\"comment\\\"}, \\\"__index__\\\": 0}]}, \\\"table\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}]\", \"save_db\": \"\\\"true\\\"\", \"__page__\": 0, \"__rerun_remap_job_id__\": null, \"no_header\": \"\\\"false\\\"\", \"sqlquery\": \"\\\"SELECT taxon.genus, bering.psms as \\\\\\\"BeringStrait_PSMs\\\\\\\", chukchi.psms as \\\\\\\"ChukchiSea_PSMs\\\\\\\",\\\\nbering.peptides as \\\\\\\"BeringStrait_Peptides\\\\\\\", chukchi.peptides as \\\\\\\"ChukchiSea_Peptides\\\\\\\"\\\\nFROM\\\\n (SELECT distinct genus FROM bering_lca WHERE genus IS NOT NULL\\\\n UNION\\\\n SELECT distinct genus FROM chukchi_lca WHERE genus IS NOT NULL) as taxon\\\\n LEFT OUTER JOIN\\\\n (SELECT bering_lca.genus,count(bering_psm.sequence) as \\\\\\\"psms\\\\\\\",count(distinct bering_psm.sequence) as \\\\\\\"peptides\\\\\\\"\\\\n FROM bering_psm LEFT JOIN bering_lca ON bering_psm.sequence = bering_lca.peptide\\\\n WHERE validation IS NOT 'Confident'\\\\n AND confidence >= 95\\\\n GROUP BY bering_lca.genus ) as bering\\\\n ON taxon.genus = bering.genus\\\\n LEFT OUTER JOIN\\\\n (SELECT chukchi_lca.genus,count(chukchi_psm.sequence) as \\\\\\\"psms\\\\\\\",count(distinct chukchi_psm.sequence) as \\\\\\\"peptides\\\\\\\"\\\\n FROM chukchi_psm LEFT JOIN chukchi_lca ON chukchi_psm.sequence = chukchi_lca.peptide\\\\n WHERE validation IS NOT 'Confident'\\\\n AND confidence >= 95\\\\n GROUP BY chukchi_lca.genus) as chukchi\\\\n ON taxon.genus = chukchi.genus\\\\nWHERE bering.psms IS NOT NULL OR chukchi.psms IS NOT NULL\\\\nORDER BY taxon.genus\\\\n\\\"\", \"add_to_database\": \"{\\\"withdb\\\": {\\\"__class__\\\": \\\"RuntimeValue\\\"}}\", \"workdb\": \"\\\"workdb.sqlite\\\"\"}",
424 "tool_version": "2.0.0",
425 "type": "tool",
426 "uuid": "c8b14d06-f3a3-46db-b3c6-01f5c50bc16e",
427 "workflow_outputs": [
428 {
429 "label": null,
430 "output_name": "output",
431 "uuid": "ea8853c6-d1e2-4c04-a795-4b1af5e50ff4"
432 }
433 ]
434 }
435 },
436 "uuid": "8fac309b-4ea6-4c20-9e40-651b2346b3e8"
437 }