# HG changeset patch # User brinkmanlab # Date 1607112461 0 # Node ID b08b09342b92dcad9569b10b5ac4815aefff692e # Parent 7c2f036e13a7ac2c9cff9e289d354b5c4a15529c "planemo upload for repository https://github.com/brinkmanlab/galaxy-tools/tree/master/microbedb commit 8cc0daf7f7ce6a49483c9152bccd53d66a00f707" diff -r 7c2f036e13a7 -r b08b09342b92 all_fasta.xml --- a/all_fasta.xml Tue Nov 10 00:15:03 2020 +0000 +++ b/all_fasta.xml Fri Dec 04 20:07:41 2020 +0000 @@ -1,4 +1,4 @@ - + Load all fasta files from MicrobeDB into the all_fasta data table topic_3301 @@ -28,10 +28,8 @@ (r.rep_accnum || '_' || r.rep_version) AS dbkey, (REPLACE(r.definition, ', complete genome.', '') || ' [' || r.rep_accnum || '.' || r.rep_version || ']') AS label, ('${os.path.dirname(str($db))}/' || genomeproject.gpv_directory || '/' || genomeproject.filename || '_genomic.fna') AS file_path - FROM genomeproject - JOIN replicon r ON genomeproject.gpv_id = r.gpv_id AND r.rep_type = 'chromosome' - WHERE genomeproject.version_id = (SELECT version_id FROM version WHERE is_current == 1) - AND genomeproject.file_types IS NOT NULL + FROM genomeproject JOIN replicon r ON genomeproject.gpv_id = r.gpv_id AND r.rep_type = 'chromosome' + WHERE genomeproject.file_types IS NOT NULL AND genomeproject.file_types LIKE '%.fna%' AND r.rep_type = 'chromosome' )