Skip to end of banner
Go to start of banner

CSBC/PSON Dataset Schema

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 30 Next »

Type / name of card: "Datasets"

DEPRECATED: briefly used this Synapse Table: https://www.synapse.org/#!Synapse:syn21517423/tables/

Synapse fileview: https://www.synapse.org/#!Synapse:syn18488466/tables/   

NOTE: Studies are selected in this view with is.dataset == TRUE 

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 NameColumn NameFacet Y/NFacet OrderUI MappingDestinationSearchable Y/NSearch OrderSearch hint text




Icondefault = disk


Dataset NamedatasetNameNNACard_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> ”

Y1e.g. migration

idNNA

NNA

datasetsNNA

NNA
DescriptiondescriptionNNACard_Description
Y2e.g. spatiotemporal
Publication TitlepublicationTitleNNASecondary_Label_1URL in markdownY4e.g. immune escape
Overall DesignoverallDesignNNASecondary_Label_2
Y3
ThemeThemeY1

NNAe.g. tumor-immune
Tumor TypetumorTypeY3Secondary_Label_3
Y7e.g. Skin Cutaneous Melanoma
AssayassayY2Secondary_Label_4
Y6e.g. RNA-seq
SpeciesspeciesY4Secondary_Label_5
NNAe.g. Human
External LinkexternalLinkNNASecondary_Label_6URL embedded in HTMLNNAe.g. GSE93776
Grant NamegrantNameY5Secondary_Label_7Link 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> ”Y5e.g. immunology
ConsortiumconsortiumY6Secondary_Label_8
NNAe.g. PS-ON
Grant TypegrantTypeY7Secondary_Label_9
NNAe.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'

  • No labels