MaayanLab / DRC-Portals

0 stars 0 forks source link

To think about adding assay_type filter in C2M2 main search results page #329

Closed mano-at-sdsc closed 2 weeks ago

mano-at-sdsc commented 1 month ago

Not to be done immediately.

Add assay_type filter in C2M2 main search results page; suggested during the demo during August12 DRC/KC meeting.

This will require adding assay_type (and related information) into ffl_biosample and ffl_collection (which are then combined into ffl_biosample_collection), resulting in about 15% more rows (and make the search a bit slower correspondingly) as per the counts below.

drc=> select count(*) from (select distinct project_local_id, data_type, assay_type from c2m2.file); count

4934 (1 row)

drc=> select count(*) from (select distinct project_local_id, data_type from c2m2.file); count

4276 (1 row)

susrinivasan commented 3 weeks ago

Assay_type is now a new filter in the main page. The main search table and record info display assay type and linked to its ontology description appropriately.

mano-at-sdsc commented 3 weeks ago

The some other Component.tsx files as well in record_info likely need to be updated to include assay_type context. Likely, in FileComponent.tsx, unique_info needs to include assay_type related columns and file_table_keycol needs to be based on also join on assay_type information.

susrinivasan commented 2 weeks ago

The Files components in record_info were updated to include assay_type_name.

susrinivasan commented 2 weeks ago

Closed.