Skip to content

Explore Query Page

Victor Lin edited this page Jul 15, 2020 · 5 revisions

End goal: query for a set of accessions and show summary visualization, with links to individual summary report pages.

Feature iteration 1

Example website endpoints:

  • /explore?family=Coronaviridae
  • /explore?accession=EU82727.1

Web page will show a simple table of SRA accession IDs with links to summary report pages. Example:


Results for query family=Coronaviridae:

SRA accession Study Name Score
SRR7287110 Felis catus Raw sequence reads 100
ERR2756788 Metagenomics of viral communities of vampire bats in Peru 84
... ... ...

We can start with top 10 results, then add pagination.

Tasks

  1. Craft SQL queries that reflect actual queries. Example:
    select *
    where family=Coronaviridae
    order by score
    limit 10
  2. Add database endpoints for above queries with same parameter. Example:
    Task<ActionResult<Run>> GetRuns(string family)
  3. Call database endpoint from webpage and render results.

Feature iteration 2

TBD

Clone this wiki locally