home / WtMTA

Search species

Search for species by partial name. The species name links to that species' detail page.

Custom SQL query (hide)

select
  '[' || species || '](/WtMTA-4fd108c/genomes/' || taxonomy_id || ')' as species,
  taxonomy_id
from genomes
where :search IS NOT NULL AND :search <> ''
  AND species LIKE '%' || :search || '%'
order by species

Query parameters

Edit SQL

0 results

Powered by Datasette · Queries took 1.969ms