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 details page, where the key in the Synapse datasets table is "datasetName" (call it datasets:datasetName for clarity) and the value <datasetName> is pulled from the "datasetName" column of this same datasets table, e.g. datasets:datasetName=<datasetName> ” | 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 Title | publicationTitle | N | NA | Secondary_Label_1 | URL in markdown | Y | 4 | e.g. immune escape |
Overall Design | overallDesign | N | NA | Secondary_Label_2 | Y | 3 | ||
Theme | Theme | Y | NA1 | N | NA | e.g. tumor-immune | ||
Tumor Type | tumorType | Y | 23 | Secondary_Label_3 | Y | 7 | e.g. Skin Cutaneous Melanoma | |
Assay | assay | Y | 12 | Secondary_Label_4 | Y | 6 | e.g. RNA-seq | |
Species | species | Y | 34 | 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 | 45 | Secondary_Label_7 | Link to grant details page, where the key in the Synapse grant table is "grantName" (call it grant:grantName for clarity) and the value <grantName> is pulled from the "grantName" column of this dataset table, e.g. grant:grantName=<grantName> ” | Y | 5 | e.g. immunology |
Consortium | consortium | Y | 56 | Secondary_Label_8 | N | NA | e.g. PS-ON | |
Grant Type | grantType | Y | 67 | Secondary_Label_9 | 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.,.
...