Difference between revisions of "WormBase-Caltech Weekly Calls"
From WormBaseWiki
Jump to navigationJump to searchm |
|||
Line 58: | Line 58: | ||
=== Species in Postgres and ACEDB/Datomic === | === Species in Postgres and ACEDB/Datomic === | ||
+ | * Want to dump "Affected By Pathogen" fields in Phenotype OA and RNAi OA | ||
+ | * Want to be sure that what gets dumped aligns with species loaded into ACEDB | ||
+ | * Currently one species annotated not in WS277: Streptococcus gallolyticus subsp. gallolyticus | ||
* We currently have many Postgres tables for storing species lists: | * We currently have many Postgres tables for storing species lists: | ||
− | ** pap_species_index | + | ** pap_species_index (used by "Affected By Pathogen" fields) |
** obo_name_ncbitaxonid | ** obo_name_ncbitaxonid | ||
** obo_name_taxon | ** obo_name_taxon | ||
+ | * How do species get loaded into ACEDB? Dumps from Postgres? Which table(s)? |
Revision as of 15:41, 13 August 2020
Contents
Previous Years
2020 Meetings
August 6th, 2020
Experimental conditions data flow into Alliance
- Experimental conditions in disease annotations: WB has inducers (used to recapitulate the disease condition) and modifiers (a modifier can ameliorate, exacerbate, or have no effect, on the disease condition)
- We use the WB Molecule CV for Inducers and Modifiers in disease annotation
- Experimental conditions in phenotype annotations: are free text (captured in remarks); will probably need to formalize later on
- So for data flow into Alliance:
- In the short term we will load the Molecule CV into the Alliance (Ranjana and Michael P. will work on this)
- Groups will switch to using common data model that works for all and common ontology/ontologies in the near future.
- How do we handle genetic sex? Part of condition?
- Condition has been intended for external/environmental conditions, whereas genetic sex is inherent to the organism of study
- Expression pattern curation needs genetic sex; needs a model at the Alliance for capturing sex
August 13, 2020
Species in Postgres and ACEDB/Datomic
- Want to dump "Affected By Pathogen" fields in Phenotype OA and RNAi OA
- Want to be sure that what gets dumped aligns with species loaded into ACEDB
- Currently one species annotated not in WS277: Streptococcus gallolyticus subsp. gallolyticus
- We currently have many Postgres tables for storing species lists:
- pap_species_index (used by "Affected By Pathogen" fields)
- obo_name_ncbitaxonid
- obo_name_taxon
- How do species get loaded into ACEDB? Dumps from Postgres? Which table(s)?