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 19 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/NUI MappingDestinationSearchable Y/NSearch hint text



Icondefault = disk


datasetNameNCard_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.Ye.g. migration

idN

N

datasetsN



DescriptionsummaryNCard_Description
Ye.g. spatiotemporal
PublicationTitleNSecondary_Label_1PubMedYe.g. immune escape

PubMedN

N
Overall DesignoverallDesignNSecondary_Label_2


ThemeThemeN

Ne.g. tumor-immune
Tumor TypetumorTypeYSecondary_Label_3
Ye.g. Skin Cutaneous Melanoma
AssayassayYSecondary_Label_4
Ye.g. RNA-seq
StudiesstudiesN

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.

Ne.g. syn13857585
SpeciesspeciesYSecondary_Label_5
Ye.g. Human
External LinkexternalLinkNSecondary_Label_6URL embedded in HTMLNe.g. GSE93776
Grant NamegrantNameYCard_SubTitle
Ye.g. immunology
ConsortiumconsortiumYSecondary_Label_7
Ye.g. PS-ON
Grant TypegrantTypeYSecondary_Label_8
Ye.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