column name: name in data portal
synapse table name: corresponding name (e.g., for SQL query) in Synapse table view
facet: true if column_name should be faceted in data portal.
desired for CSBC/PS-ON: should this column be included in the CSBC data portal
Synapse table view source for this card: https://www.synapse.org/#!Synapse:syn10142562/tables/
There are extra rows in the above Synapse file view, which should be subsetted to those rows with grantType == U54 or U01
Several columns are missing from the above Synapse file view and are being added: centerSite, abstract, and keyInvestigators
| column name | synapse table name | facet | desired for CSBC/PS-ON | concept | example | required | column type | size | restricted values | comments | in AMP-AD tabledesired for CSBC/PS-ON | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Grant /Project Name | Modeling the role of lymph node metastases in tumor-mediated immune suppression | yes | largeText | name | no | yes | The name of the grant/project. | Stanford University Center for Cancer Systems Biology | yes | string | CSBC/PS-ON will want this called "Grant Name" | yes | yes | Center Name | Stanford University Center for Cancer Systems Biology||
| Grant Number | grantNumber | no | no | Grant NumberCA209971 | yes | string | yes | |||||||||
| Program | consortium | yes | Programyes | CSBC | yes | string | CSBC, PS-ON, AMP-AD, M2OVE-AD, MODEL-AD, Resilience-AD | yesyes | ||||||||
| Key Investigators | keyInvestigators | no | yes | Sylvia Plevritis, Garry Nolan, Ed Engleman, John Sunwoo | yes | yesstring vector | yes | |||||||||
| Institutions | institution | no | yes | Stanford | yesyes | string vector | There may be multiple institutions associated with a grant. | yes | ||||||||
| Link to Center Site | centerSite | no | yes | Link to an external URL representing the project/grant. | http://ccsb.stanford.edu | no | yeslink | yes | ||||||||
| Link to Synapse Sitehttps://www.synapse.org/#!Synapse:syn7315808/wiki/406891 | id | no | yes | Link to a Synapse URL (i.e., a Synapse project or more generally a Synapse Wiki) representing the project/grant. | syn7080714 | no | entity? | |||||||||
| Abstract | yesabstract | Abstract | Our Research Center aims to identify the mechanisms in which tumor cells instruct the immune system to tolerant them by focusing on the understudied role of lymph node invasion in tumor-mediated immunosuppression ...no | yes | yes | largeTextyes?This should be searchable. | yes | |||||||||
| Key Data Contributors | no | no | no | string vector | I don't think this is relevant for CSBC. | yes | no | |||||||||
| Grant Type | grantType | yes | yes | U54 | no? | string | U01, U54, U24, R01 | For CSBC, it will be interesting and relevant to summarize/visualize data based on center type (i.e., in a facet). But it's probably not necessary to display it on the project card. no | no? | |||||||
| Funding Agency | fundingAgency | NCIno | no | NCI | no | string | NCI | no | ||||||||
| Synapse Team ID | teamProfileId | no | no | CSBC has a Synapse team for each grant/center. | https://www.synapse.org/#!Team:3346413 | no | string (url) or synapse entity | nono |
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.