Mercurial > repos > brinkmanlab > microbedb

comparison all_fasta.sql @ 6:b7884a377566 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"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,