...
Synapse Table: https://www.synapse.org/#!Synapse:syn21868591/tables/
DEPRECATED Synapse File View: https://www.synapse.org/#!Synapse:syn18488466/tables/
NOTE: Studies are selected in this view with is.dataset == TRUE
DEPRECATED Synapse Table: https://www.synapse.org/#!Synapse:syn21517423/tables/
...
Explore page config
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.
Any column that should be faceted in the portal (i.e., faceted on an explore page or have a column facet on a table) must be faceted on the corresponding Synapse table/view. There is a performance penalty incurred with each additional facet – hence, facet only those columns needed by the portal and limit to those likely to be useful.
Display Name | Column Name | Column Type | Link Format | Facet Y/N | Facet Order | Card UI Mapping | Destination | Link Query Key | Link Value Column | Searchable Y/N | Search Order | Search Hint Text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default = disk | |||||||||||
Dataset Name |
|
| N | NA |
| Datasets/DetailsPage | datasetId |
| Y | 1 | e.g. migration | |
|
| N | NA | N | NA | |||||||
|
| N | NA | N | NA | |||||||
Description |
|
| N | NA |
| Y | 2 | e.g. spatiotemporal | ||||
Publication |
|
| markdown: | N | NA |
| PubMed record | Y | 4 | e.g. immune escape | ||
Overall Design |
|
| N | NA |
| Y | 3 | |||||
Theme |
|
| Y | 1 | N | NA | e.g. tumor-immune | |||||
Tumor Type |
|
| Y | 3 |
| Y | 7 | e.g. Skin Cutaneous Melanoma | ||||
Assay |
|
| Y | 2 |
| Y | 6 | e.g. RNA-seq | ||||
Species |
|
| Y | 4 |
| N | NA | e.g. Human | ||||
External Link |
|
| N | NA |
| URL embedded in HTML | N | NA | e.g. GSE93776 | |||
Grant Name |
|
| portal query (each) | Y | 5 |
| Grants/DetailsPage | grantName |
| Y | 5 | e.g. immunology |
Consortium |
|
| Y | 6 |
| N | NA | e.g. PS-ON |
*<TYPE>_LIST columns for multi-value annotations not yet implemented
...
SELECT * FROM syn18488466 where "datasets" = 'syn7248581'
Additionally, we should display files associated with this dataset by querying the files table using datasets, i.e.,.
...