Which columns to display in the Search view table?

[eboileau]

Aims/objectives.

We need to redesign the way we organize filters to query the DB. Check Intuitive database searching. Then we can decide how to display the table.

Adding DetectionMethod, DetectionTechnology, and/or Organism to the DataTable may seem redundant, especially with filters option, but otherwise the information is not available "per record".

Do we include annotations (gene name, id, biotype, genomic features) and filters in the DataTable? Or do we display annotation per site (using e.g. a modification id), with a modal or new page? In the latter case, how can we filter the data?

We don't want row aggregation or expansion, nor duplication where a given modification (chrom, start, end, name, strand) occurs more than once, i.e. we want distinct records to be shown in the table, but "distinct" depends on the columns, not just columns shown in the table, but those selected in the query (BE).

See also #59

A clear and concise description of todo items.

• Determine which columns (and how) to display in the Search view table, w/ or w/o filter/sort.

[eboileau]

The top filters are: modification grouped by RNA type (grouped dropdown, 1), organism (Cascade select, simplified, 1), cell/tissue/organ (multi select, 1+), technology (tree select, simplified, 1+). This restricts the query to these data. Annotations are added. Remaining filters are implemented in the table: sort for chrom, start, score, frequency, coverage; filter for gene name and id, dropdown for biotype and feature.