Published base-pair frequency tables (latest version) (view)

7 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: html_version, pdf_version, xlsx_version

CREATE VIEW basepair_table_downloads as
select molecule,
       max(case when format = 'html' then version end) as html_version,
       max(case when format = 'html' then url end)     as html_url,
       max(case when format = 'pdf'  then version end) as pdf_version,
       max(case when format = 'pdf'  then url end)     as pdf_url,
       max(case when format = 'xlsx' then version end) as xlsx_version,
       max(case when format = 'xlsx' then url end)     as xlsx_url
from nucleotide_frequency_tables
where category = 'MODEL' and subtype = 'BP' and is_supporting = 'no'
  and is_latest_in_format = 'yes'
group by molecule
order by case molecule when '5S' then 1 when '16S' then 2 when '23S' then 3 else 4 end;