Synapse Table: https://www.synapse.org/#!Synapse:syn21517423/tables/
...
Number of Secondary Fields to show: 4
Note that there is no explicit aliasing between Column Name and Display Name. Rather, camelCase Column Names are automatically rendered as Camel Case. The table below just makes that clear.
| Display Name | Column Name | Facet Y/N | UI Mapping | Destination | Searchable Y/N | Search hint text |
|---|---|---|---|---|---|---|
| Icon | default = disk | |||||
| datasetName | N | Card_Title | link to dataset detail pages, with information populated from datasets view (syn18488466) with row/entry having datasets column set to value in datasets column in this table. | Y | e.g. migration | |
| Grant Name | grantName | N | Card_SubTitle | Y | e.g. immunology | |
| id | N | N | ||||
| datasets | N | |||||
| Description | summary | N | Card_Description | Y | e.g. spatiotemporal | |
| Publication | Title | N | Secondary_Label_1 | PubMed | Y | e.g. immune escape |
| PubMed | N | N | ||||
| Overall Design | overallDesign | N | Secondary_Label_2 | |||
| Theme | Theme | Y | Secondary_Label_3 | Y | e.g. tumor-immune | |
| Tumor Type | tumorType | Y | Secondary_Label_4 | Y | e.g. Skin Cutaneous Melanoma | |
| Assay | assay | Y | Secondary_Label_5 | Y | e.g. RNA-seq | |
| Studies | studies | N | Secondary_Label_6 | comma-separated list of synIds, should link to study detail pages, with information populated from studies view (syn18483791) with row/entry having studies column set to this value. | Y | e.g. syn13857585 |
| Species | species | Y | Secondary_Label_7 | Y | e.g. Human | |
| External Link | externalLink | N | Secondary_Label_8 | URL embedded in HTML | N | e.g. GSE93776 |
| Consortium | consortium | Y | Secondary_Label_9 | Y | e.g. PS-ON | |
| Grant Type | grantType | Y | Secondary_Label_10 | Y | e.g. U01 |
Detail pages:
Detail pages should display the above information (i.e., from the card) in the header/banner of the page. The query to get that information should be on this table using datasets:
SELECT * FROM syn18488466 where "datasets" = 'syn7248581'
Additionally, we should display files associated with this dataset by querying the files table using datasets, i.e.,.
files:
SELECT * FROM syn9630847 where "datasets" = 'syn7248581'