Mercurial > repos > brinkmanlab > microbedb
diff 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 |
line wrap: on
line diff
--- a/all_fasta.sql Mon Nov 09 01:09:50 2020 +0000 +++ b/all_fasta.sql Mon Nov 09 18:37:30 2020 +0000 @@ -1,4 +1,4 @@ -SELECT json_group_array(json_object('value', unique_build_id, 'dbkey', dbkey, 'name', label, 'path', file_path)) +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)))) FROM ( SELECT (r.rep_accnum || '.' || r.rep_version) AS unique_build_id, (r.rep_accnum || '_' || r.rep_version) AS dbkey,