Document toolboxDocument toolbox

CSBC / PSON Data File Schema

This describes the 'Explore Data' table.

This is not a card, but an explore table.

File view driving this: https://www.synapse.org/#!Synapse:syn9630847/tables/

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.

Columns should be ordered in the order they appear in this table (i.e., leftmost column in portal is topmost row 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 Name

Column Name

Facet Y/N

Facet Order

Destination

Searchable Y/N

Search hint text

Display Name

Column Name

Facet Y/N

Facet Order

Destination

Searchable Y/N

Search hint text


File Name

fileName

N

NA

 

N

 

Title

title

N

NA

 

N

 

Tumor Type

tumorType

Y

2



N

e.g. Skin Cutaneous Melanoma

Tissue

tissue

Y

4

 

N

e.g. colon

Assay

assay

Y

1



N

e.g. RNA-seq

Platform

platform

Y

5

 

N

 

Data Format

dataFormat

Y

6

 

N

e.g. bam

Species

species

Y

3



N

e.g. Human

Gender

gender

Y

7

 

N

e.g. female

Grant Name

grantName

Y

8

 

N

e.g. immunology

Consortium

consortium

Y

9



N

e.g. PS-ON

Grant Type

grantType

Y

10



N

e.g. U01

Detail pages