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 accession)

3. Call database endpoint from webpage and render results.

Feature 2: List Accessions by Family

The point here is to list what accessions were included in the original search, grouped by their families. Each "GenBank" identifier in this page should link out to the "Accession" query above.

• /explore?family=Coronaviridae

GenBank Accession	Sequence Name
EU82727.1	Trinidad Bat Alphacoronavirus
MT31337.1	Basement Rat Betacoronavirus
NC_00184.2	SARS-CoV-2