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 23 Next »

Type / name of card: "Datasets"

Synapse Table: https://www.synapse.org/#!Synapse:syn21517423/tables/

Previously used 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.

Display NameColumn NameFacet Y/NFacet OrderUI MappingDestinationSearchable Y/NSearch OrderSearch hint text




Icondefault = disk


Dataset NamedatasetNameNNACard_Titlelink 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.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
ThemeThemeNNA

NNAe.g. tumor-immune
Tumor TypetumorTypeY2Secondary_Label_3
Y7e.g. Skin Cutaneous Melanoma
AssayassayY1Secondary_Label_4
Y6e.g. RNA-seq
SpeciesspeciesY3Secondary_Label_5
NNAe.g. Human
External LinkexternalLinkNNASecondary_Label_6URL embedded in HTMLNNAe.g. GSE93776
Grant NamegrantNameY4Card_SubTitle
Y5e.g. immunology
ConsortiumconsortiumY5Secondary_Label_7
NNAe.g. PS-ON
Grant TypegrantTypeY6Secondary_Label_8
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