Type / name of card: "Datasets"
...
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.
Facets should be ordered in the order they appear in this table.
| Display Name | Column Name | Facet Y/N | Facet Order | UI Mapping | Destination | Searchable Y/N | Search Order | Search hint text | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Icon | default = disk | ||||||||||||
| Dataset Name | datasetName | N | NA | 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 | 1 | e.g. migration | |||||
| id | N | NA | N | NA | |||||||||
| datasets | N | NA | N | NA | |||||||||
| Description | description | N | NA | Card_Description | Y | 2 | e.g. spatiotemporal | ||||||
| Publication TitleTitle | publicationTitle | N | NA | Secondary_Label_1 | PubMedURL in markdown | Y | 4 | e.g. immune escape | PubMed | N | NA | N | NA |
| Overall Design | overallDesign | N | NA | Secondary_Label_2 | Y | 3 | |||||||
| Theme | Theme | N | NA | N | NA | e.g. tumor-immune | |||||||
| Tumor Type | tumorType | Y | 2 | Secondary_Label_3 | Y | 7 | e.g. Skin Cutaneous Melanoma | ||||||
| Assay | assay | Y | 1 | Secondary_Label_4 | Y | 6 | e.g. RNA-seq | ||||||
| Studies | studies | N | NA | 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. | N | NA | e.g. syn13857585 | ||||||
| Species | species | Y | 3 | Secondary_Label_5 | N | NA | e.g. Human | ||||||
| External Link | externalLink | N | NA | Secondary_Label_6 | URL embedded in HTML | N | NA | e.g. GSE93776 | |||||
| Grant Name | grantName | Y | 4 | Card_SubTitle | Y | 5 | e.g. immunology | ||||||
| Consortium | consortium | Y | 5 | Secondary_Label_7 | N | NA | e.g. PS-ON | ||||||
| Grant Type | grantType | Y | 6 | Secondary_Label_8 | N | NA | e.g. U01 |
...
SELECT * FROM syn18488466 where "datasets" = 'syn7248581'
Additionally, we should display files associated with this dataset by querying the files table using datasets, i.e.,.
...