Mercurial > repos > brinkmanlab > microbedb
comparison all_fasta.sql @ 6:b7884a377566 draft
"planemo upload for repository https://github.com/brinkmanlab/galaxy-tools/tree/master/microbedb commit 7ea4cbe9a0f7347379e245223cc2c40021c586f9"
author | brinkmanlab |
---|---|
date | Mon, 09 Nov 2020 18:37:30 +0000 |
parents | 40d14d5c8125 |
children |
comparison
equal
deleted
inserted
replaced
5:67447b96c3ff | 6:b7884a377566 |
---|---|
1 SELECT json_group_array(json_object('value', unique_build_id, 'dbkey', dbkey, 'name', label, 'path', file_path)) | 1 SELECT json_object('data_tables', json_object('all_fasta', json_group_array(json_object('value', unique_build_id, 'dbkey', dbkey, 'name', label, 'path', file_path)))) |
2 FROM ( | 2 FROM ( |
3 SELECT (r.rep_accnum || '.' || r.rep_version) AS unique_build_id, | 3 SELECT (r.rep_accnum || '.' || r.rep_version) AS unique_build_id, |
4 (r.rep_accnum || '_' || r.rep_version) AS dbkey, | 4 (r.rep_accnum || '_' || r.rep_version) AS dbkey, |
5 (REPLACE(r.definition, ', complete genome.', '') || ' [' || r.rep_accnum || '.' || r.rep_version || | 5 (REPLACE(r.definition, ', complete genome.', '') || ' [' || r.rep_accnum || '.' || r.rep_version || |
6 ']') AS label, | 6 ']') AS label, |