Synapse table for this card: https://www.synapse.org/#!Synapse:syn10923842/tables/
The following is a brief description of the relevant columns in the table below (by column header):
column name: name in data portal
synapse table name: corresponding name (e.g., for SQL query) in Synapse table view
required: is this a column that the portal WG has deemed required?
facet: true if column_name should be faceted in data portal.
card location: primary (i.e., top) or secondary (i.e., bottom) key/annotation
desired for CSBC/PS-ON: should this column be included in the CSBC data portal
The following have been added to the synapse table, but are blank. They need to be filled in: datasets, studies, tissue_or_organ, diseaseType, experimentalStrategy, featured, Abstract
| column name | synapse table name | standardized schema name | required | facet | card location | desired for CSBC/PS-ON | concept | example | required | column type | size | restricted values | comments | in AMP-AD portal | in NF portal | GDC equivalent |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Keywords | Keywords | no | yes | Keywords associated with this publication, some of which may come from a controlled vocabulary | tumor heterogeneity | yes | string vector | unrestricted | no | |||||||
| Abstract | Abstract | no | no | largeText | ||||||||||||
| Disease Type | diseaseType | yes | yes | The type of cells that carcinoma arises from. | Adenocarcinoma, Anaplastic Astrocytoma | yes | string vector | many | yes | related to Disease Type | ||||||
| Experimental Strategy | experimentalStrategy | yes | yes | RNA-seq | no | string vector | many | no | related to Experimental Strategy | |||||||
| Site | tissue_or_organ | yes | yes | yes | many | no | related to Primary Site | |||||||||
| doi | doi | doi | no | no | NA | yes | doi without wwww.doi.org/ prefix: eg: 10.1093/neuonc/noy046 | yes | yes | |||||||
| projectName | no | display name of project | don't know what this is | yes | ||||||||||||
| studyId | no | synapse id of Study -Synapse project or folder | no | entity vector | yes, as "id" | |||||||||||
| datasetId | no | synapse id of datasets | no | entity vector | ||||||||||||
| Title | Title | Title | yes | no | top | yes | publication title | yes | string | no | ||||||
| Authors | Authors | Author | yes | no | top | yes | publication authors | yes | string vector | no | ||||||
| Journal | Journal | Journal | yes | no | top | yes | publication journal | yes | string | no | ||||||
| Year | Publication Year | Year | no | yes | top | yes | publication year | yes | number | no | ||||||
| featured | no | yes | whether the card should be on the homepage (max 3 in table) | yes | ||||||||||||
| Link to Synapse site | CSBC PSON Center | no | no | Link to a Synapse URL (i.e., a Synapse project or more generally a Synapse Wiki) representing the project/grant. | ||||||||||||
| Program | Consortium | yes | yes | yes | string | CSBC, PSON | ||||||||||
| Grant Type | grantType | yes | yes | yes | U54, U01 | |||||||||||
| Datasets | datasets | no | yes | Links to datasets in portal. How should this be represented? | ||||||||||||
| Studies | studies | no | yes | Links to study in portal. How should this be represented? | ||||||||||||
| Grant | grant | no | yes | U54 or U01 center |
Until Synapse has a solution for multiple values in a single table cell (i.e., vectors), use pipe " | " to separate multiple values. Eg: fundingAgency: CTF | NTAP.
GDC docs: https://docs.gdc.cancer.gov/
GDC data dictionary browser: https://docs.gdc.cancer.gov/Data_Dictionary/gdcmvs/
Add Comment