Explore Query Page

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

Feature 1: List SRA by Accession + Scores

Example website endpoint:

• /explore?accession=EU82727.1

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

---

Results for query accession=EU82727.1:

SRA accession	Study Name	Score	Read	Identity
SRR7287110	Felis catus Raw sequence reads	100	1337	99.9%
ERR2756788	Metagenomics of viral communities of vampire bats in Peru	84	410	86%
...	...	...

---

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

Tasks

1. Craft SQL queries that reflect actual queries. Example:

SELECT 
  "AccessionSections"."Sra",
  "AccessionSections"."Score",
  "AccessionSections"."Aln",  
  "AccessionSections"."PctId", 
FROM 
  public."AccessionSections", 
WHERE 
  "AccessionSections"."Acc" = "EU82727.1"
ORDER BY
  "AccessionSections"."Score" DESC,
  "AccessionSections"."Aln" DESC
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 2: List Accessions by Family

• /explore?family=Coronaviridae

TBD