# HG changeset patch
# User brinkmanlab
# Date 1610766314 0
# Node ID 2f6ef3a184dfb575788cc7e84181a591cdeacca3
# Parent  b08b09342b92dcad9569b10b5ac4815aefff692e
"planemo upload for repository https://github.com/brinkmanlab/galaxy-tools/tree/master/microbedb commit 12aaf041d3d5a052c6a3f3aa7f3177591e3b19bf"

diff -r b08b09342b92 -r 2f6ef3a184df all_fasta.xml
--- a/all_fasta.xml	Fri Dec 04 20:07:41 2020 +0000
+++ b/all_fasta.xml	Sat Jan 16 03:05:14 2021 +0000
@@ -26,11 +26,11 @@
             )) FROM (
              SELECT (r.rep_accnum || '.' || r.rep_version) AS unique_build_id,
                     (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
+                    (REPLACE(REPLACE(r.definition, ', complete sequence.', ''), ', complete genome.', '') || ' [' || r.rep_accnum || '.' || r.rep_version || ']') AS label,
+                    ('${os.path.dirname(str($db))}/' || genomeproject.gpv_directory || '/' || r.file_name || '.fna') AS file_path
              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%'
+             WHERE r.file_types IS NOT NULL
+               AND r.file_types LIKE '%.fna%'
                AND r.rep_type = 'chromosome'
             )
         ]]></configfile>