search

tgbugs / pyontutils

python utilities for working with ontologies
MIT License
19 stars 123 forks source link

sparc queries to spreadsheets #64

Open tgbugs opened 5 years ago

tgbugs commented 5 years ago

For each organ in https://scicrunch.org/api/1/sparc-scigraph/dynamic/prod/sparc/organList get the list of all terms from https://scicrunch.org/api/1/sparc-scigraph/dynamic/prod/sparc/organParts/FMA:7203 and organize into 3 lists for parts, nerves, and blood vessels use the update functionality of the Sheet object https://github.com/tgbugs/pyontutils/blob/eaadd9a91d00aee6326953f04ddde3250968fa55/pyontutils/sheets.py#L157-L166 to populate a sheet per organ in a new google sheets workbook. Columns should be

  1. curie
  2. label
  3. synonyms
  4. definition (if available)
  5. mapping to uberon if uberon has an xref, and fill in the definition from uberon

We will probably need update functionality that can keep track of where things in the grid are anchored so we can move comments, but that is for the future.

@tmsincomb

tgbugs commented 4 years ago

Done now.

tgbugs commented 3 years ago

This was originally done manually. This should now be done systematically, following the original spec, and should probably live in the sparcur reports/sheets file https://github.com/SciCrunch/sparc-curation/blob/master/sparcur/sheets.py.

tgbugs commented 3 years ago

The additional requirement is that this needs to be able to be updated and kept in sync automatically.