sparc queries to spreadsheets

[tgbugs]

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

pyontutils/pyontutils/sheets.py

Lines 157 to 166 in eaadd9a

	def update(self, values):
	if self.readonly:
	raise PermissionError('sheet was loaded readonly, '
	'if you want to write '
	'reinit with readonly=False')
	update_sheet_values(self.name,
	self.sheet_name,
	values,
	spreadsheet_service=self.spreadsheet_service)

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]

Done now.

[tgbugs]

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]

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