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


Source data 

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 NameColumn NameColumn TypeLink FormatFacet Y/NFacet OrderCard UI MappingDestinationLink Query KeyLink Value ColumnSearchable Y/NSearch OrderSearch Hint Text






icondefault = disk




Dataset NamedatasetNameSTRING
NNAtitle

Datasets/DetailsPage

datasetIddatasetIdY1e.g. migration

datasetIdENTITY
NNA



NNA

datasetAliasSTRING
NNA



NNA
DescriptiondescriptionLARGE_TEXT
NNAdescription


Y2e.g. spatiotemporal
PublicationpublicationSTRINGmarkdown: 
[publicationTitle](pubMedUrl)
NNAsecondaryLabels[0]PubMed record

Y4e.g. immune escape
Overall DesignoverallDesignSTRING
NNAsecondaryLabels[1]


Y3
ThemethemeSTRING_LIST*
Y1



NNAe.g. tumor-immune
Tumor TypetumorTypeSTRING_LIST*
Y3secondaryLabels[2]


Y7e.g. Skin Cutaneous Melanoma
AssayassaySTRING_LIST*
Y2secondaryLabels[3]


Y6e.g. RNA-seq
SpeciesspeciesSTRING_LIST*
Y4secondaryLabels[4]


NNAe.g. Human
External LinkexternalLinkSTRING
NNAsecondaryLabels[5]URL embedded in HTML

NNAe.g. GSE93776
Grant NamegrantNameSTRING_LIST*portal query (each)Y5secondaryLabels[6]Grants/DetailsPagegrantNamegrantNameY5e.g. immunology
ConsortiumconsortiumSTRING_LIST*
Y6Secondary_Label_8


NNAe.g. PS-ON

*<TYPE>_LIST columns for multi-value annotations not yet implemented



Details page config 

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