Difference between revisions of "WormBase-Caltech Weekly Calls"

From WormBaseWiki
Jump to navigationJump to search
m
Line 1: Line 1:
 +
= Previous Years =
 +
 
[[WormBase-Caltech_Weekly_Calls_2009|2009 Meetings]]
 
[[WormBase-Caltech_Weekly_Calls_2009|2009 Meetings]]
  
 +
[[WormBase-Caltech_Weekly_Calls_2011|2011 Meetings]]
  
==2011 Meetings==
+
[[WormBase-Caltech_Weekly_Calls_2012|2012 Meetings]]
 
 
[[WormBase-Caltech_Weekly_Calls_February_2011|February]]
 
 
 
 
 
== March 3, 2011 ==
 
 
 
SUMMARY:
 
 
 
Every other month patch:
 
*We will try to generate an ACEDB patch every other month, starting with the Paper class data
 
*Need to coordinate with Juancarlos and Todd
 
 
 
Need to check .ACE patch files before upload:
 
*Will need to be vigilant about checking for errors and inconsistencies before sending to Todd to put up on website
 
*Curators need to check their own data for problems
 
*Wen will check for consistency between the different data types
 
 
 
Think about connecting website to Postgres:
 
*Think about showing Postgres data "immediately" on site
 
 
 
 
 
DETAILS:
 
 
 
Delayed release cycle:
 
*Will require more work to prepare for more frequent release of certain data types
 
*Aside from Kimberly's data, most data types are not urgent (e.g. Expression pattern)
 
*What are the users feeling?
 
**Having data faster will help users; they don't ask, because they don't see it
 
*On-the-fly updating of website? Like Postgres?
 
*Since we use ACEDB, we have to patch WS with .ACE file, or rebuild whole thing
 
*Flat file Postgres database, replaced every night?
 
*Website calls Postgres directly for certain data types?
 
*Performing build without sequence is easy? Do everything without sequence?
 
*How to integrate sequence data with other data once they're decoupled through the patching process?
 
*We need .ACE patch files
 
*Concise description separate from most else (but connected to papers)
 
*Do papers first?
 
*Website can show anything
 
*If we have a lot of patches, will not have check for data inconsistency/confliction
 
*Trial patch .ace files for papers first
 
*Juancarlos: Scripts that check differences between data dumps; scripts are data type specific
 
**Curators need to talk to Juancarlos about the importance of different data tags
 
*Paper .ACE file: Would include bibliographic info, journals, authors, genes associated from abstract or added manually
 
*One reason for more frequent releases: because we have first pass author forms; show them we add it quickly
 
**what will be added through the forms: expression patterns? RNAi (difficult?)?
 
*We should check patch before we send to Todd!!! Don't want to crash database
 
*How frequently to patch? Weekly? Daily? Check with Todd, how often he can load them?
 
*Chron job to create patch ACE files, send to curators to check for problems, then send to Todd
 
*Interdependency of data types; curators rely on other curators?
 
*Postgres directly to website? Todd would have to work it out
 
*New information flag on website? Toggle visibility?
 
*How do we know that the data do not conflict with each other?
 
*What are common problems? Dumper script goes bad, makes broken lines, empty fields
 
*Error catching mechanisms? More checks on postgres? Dump files?
 
*Data merging problems? What are the cases that are conflicts? Prevent them? Know beforehand?
 
*If we don't know, as long as it doesn't crash the database or fail to load, then OK
 
*Don't do -D stuff, maybe? No deletions? Skip typos?
 
*Always have to check ACE files anyway, but have to do every week (2 weeks?)
 
*We can try a patch every other month
 
*What can we do without the patch?
 
*Did SAB talk about changing to relational databases?
 
**Get website going as is first, and see if it matters?
 
**If people don't want to change data models, we can switch over to relational
 
**Separate panel on website directly from Postgres?
 
*Wen can check the data integration every other month for patch
 
 
 
 
 
 
 
== March 10th, 2011 ==
 
 
 
Release schedule and patches
 
*What is the appropriate frequency?
 
*Scheme: do what we're already doing, Wen merges into citace
 
*Excluding sequence related data
 
*Need to include Mary Ann's data (strains etc.)
 
*Daily update too frequent; maybe once per month/week
 
*Submit .ACE file to Todd with simple syntax; easily parsable; old description removed and new information added
 
*Make updates only in contrast to last WS, not previous patch/temporary upload
 
*ACEDB diff step only relative to WS
 
*Wen: Postgres can dump diff ace file; already have diff ace files for every data type at Caltech; integrate into citace;
 
*Raymond: integration is important; we need to talk about how much work needs to be done by each approach
 
*Wen: consistency checks, backups, store each version?
 
*Rayomnd: citace 224 to 225 (for example), display done on class level
 
**Example: Gene page; only update information relevant to gene class to be displayed
 
*Do once per month: faster than currently because it doesn't have to go through the dev site
 
*If we update Citace to Citace, missing a lot of cross-references?
 
*Mock citace with Mary Ann's data? Becomes diff base; Mary Ann submits (non-sequence related) data directly to WBCIT
 
*Build low-connectivity ace at WBCIT? Add Mary Ann's data, remove RNAi
 
*Todd: important consideration: things added won't be available for search until formal release; weird things about diff; new reference associations with genes; a lot of duplications?
 
**Raymond: will look at it
 
*Todd: WBGene00000846, example, see how fast it loads, go from there; would like a single ACE file (concatenation of all individual ace files); would not happen on development; would have to happen on production releases; would take production database off line, clone it, and upload it to all production nodes
 
*Individual curators need to check their individual ace files for errors
 
*Frequency: monthly
 
*Todd: we should just run some tests first, to check feasibility
 
*Raymond: WBGene1, example, concise description has typo, WS225 has typo fixed from WS224, diff file shows:
 
**-D old_description
 
**new_description
 
*Load diff ace into original database?
 
*parallel display; unrelated to resident WS?
 
*Todd: producing two web pages for each object?
 
*Raymond: No, only changing relevant tags, etc.
 
*Todd: Two databases running at same time inefficient; include timestamps?
 
*Raymond: No, cannot include timestamps
 
*Wen: Send patch ace files to Todd
 
*Raymond: In conflict with versioning; how to show new data
 
*Wen: Call it "WS225.1"
 
 
 
 
 
Human Disease Relevance tag in Concise Description
 
*Ranjana: Sent out e-mail; human disease tag "Human Disease Relevance"; to clean up concise description form (old tags in form outdated); could be putting more information into concise description; OMIM human disease
 
*Raymond: make not just text field, but make entity field pointing to object; meant to be human readable, this may break up the concise description into OMIM-related and OMIM-non-related info; why parse the data into a tag?
 
*Paul S: OMIM descriptions as a separate tag
 
*Raymond: Rewrite concise description?
 
*Ranjana: No
 
*Paul S: Would you mention human disease relevance in concise description? yes, but if it's just a link out to OMIM, then separate out; OMIM may have changed since Erich wrote original script; check OMIM for new information and tags that may be able to get pulled out
 
*Ranjana: Michael Paulini can consolidate orthology information?
 
 
 
 
 
Karen: Transgene model
 
*A lot of changes to propose
 
*Deletions of tags; more coming
 
*Other things in database connected to transgenes
 
*Many things in transgene objects that may be able to be parsed into different tags (new job for someone?)
 
*Strict nomenclature for transgene descriptor
 
*Clones present need to be parsed into clone class?
 
*Todd made Clone page;
 
*Start with vectors/backbones and then work on specific plasmids
 
 
 
 
 
Gene class-phenotype connections and descriptions?
 
 
 
 
 
GSA markup at Flybase
 
*Flybase is not willing to fully QC all papers
 
*Do we push Flybase and/or provide a better tool to QC?
 
*Are we worried about the GSA markup for flies not looking professional?
 
*People need to be willing to pay for the QC/curation; depends on database priorities
 
*CIT will spend more time on in-house development to make Fly GSA markup easier/more efficient
 
 
 
 
 
Putting SPELL on Amazon cloud?
 
 
 
 
 
 
 
== March 17th, 2011 ==
 
 
 
Transgene Information was the only topic discussed.
 
 
 
Karen noticed that CGC strain information contains more detailed information about transgenes then what is found in the papers that describe the transgenes.  She would like to integrate the CGC strain information into the transgene curation pipeline.  This could potentially lead to some redundancy, but the consensus was that this was a good idea.  Going forward  - Initially Karen will go through all the CGC strains that have transgene info and add it to the transgene objects in WB.  Once that is accomplished we will institute some system (like the NBP allele info) to update as new strains w/transgene info are entered into the CGC.
 
 
 
 
 
 
 
== March 24, 2011 ==
 
 
 
Ranjana- Upload this week?
 
Wen: No, next month
 
  
 +
[[WormBase-Caltech_Weekly_Calls_2013|2013 Meetings]]
  
IWM registration
+
[[WormBase-Caltech_Weekly_Calls_2014|2014 Meetings]]
*Send info to Mary Alvarez
 
*register for housing after April 1st
 
  
 +
[[WormBase-Caltech_Weekly_Calls_2015|2015 Meetings]]
  
Raymond: update on patch file
+
[[WormBase-Caltech_Weekly_Calls_2016|2016 Meetings]]
*Generate patch file at regular interval between 2 month formal releases
 
*Use patch file to update the web page
 
*Proposal for citace, use ACE diff utility -> citace intermediate
 
*Start with one upload between formal releases
 
*Submit patch file to OICR
 
*Testing patch file; submit to Todd for testing
 
*How to generate a good patch file?
 
**tried on one class; some issues
 
**patch file looks OK, sent to Kimberly
 
**test by reading into ACeDB
 
**-D bug; problem for hashed tags
 
***solution: separate -D lines from those without -D; read in to ACEDB as different blocks
 
*maybe 2 weeks to get working
 
*Gary: data linked to ontology terms?
 
*patching OBO files?
 
*Raymond: we assume that not all info is going to be updated mid-build
 
*have to accept some dead links
 
*Juancarlos: How does ACE diff handle ordered vs non-ordered tags?
 
*Raymond: Not sure; we'll have to test
 
*is this only an Author tag issue?
 
*Juancarlos: think there may be others; not sure
 
*Raymond: Alternative solution to ACE diff, acedb patch file from postgres directly
 
*Juancarlos: Possible to dump two consecutive ace files from postgres, write a script to compare them
 
*Raymond: what about data not in postgres? Anatomy? May be possible
 
*Raymond & Juancarlos: ACE diff approach is preferred
 
*Will ACE diff handle model changes? No
 
*Juancarlos: have to change parser everytime there's a model change
 
*Kimberly: will go through the diff file carefully
 
  
 +
[[WormBase-Caltech_Weekly_Calls_2017|2017 Meetings]]
  
Citace uploads
+
[[WormBase-Caltech_Weekly_Calls_2018|2018 Meetings]]
*Raymond: What Wen says counts; ignore robotic e-mails
 
  
 +
[[WormBase-Caltech_Weekly_Calls_2019|2019 Meetings]]
  
Ranjana: Question about OA
 
*Dead genes in postgres show up in OA
 
*Gene table vs dead table; gene table contains everything
 
*Term info should indicate that a gene is obsolete
 
*In future, if something is wrong, it will not show
 
  
  
  
== March 31, 2011 ==
+
= 2020 Meetings =
  
 +
[[WormBase-Caltech_Weekly_Calls_January_2020|January]]
  
Next acedb upload - May 26th
+
[[WormBase-Caltech_Weekly_Calls_February_2020|February]]
  
 +
[[WormBase-Caltech_Weekly_Calls_March_2020|March]]
  
Transgene model change proposals (Karen)
+
[[WormBase-Caltech_Weekly_Calls_April_2020|April]]
*Handouts (old vs new model)
 
*Changes:
 
**new model much shorter
 
**"Reporter_product" and "Integrated_by" now ?Text (rather than list of options)
 
***Change "Integrated_by" to "Integration_method"
 
***OA will provide drop down menu for controlled vocabulary of terms (e.g. "GFP")
 
***switch "Reporter" with "Reporter_product"
 
**"Isolation" now called "Construction"
 
**"Coinjection_marker" change from ?Transgene to ?Text
 
***Remove "Coinjected_with" and just keep "Coinjection_marker"
 
***Remove "Fragment Text" tag?
 
**"Location" now sub-tag of Construction, populated by Juancarlos' script
 
***Change "Location" to "Laboratory"? Todd: This would be helpful for web team
 
**Look at "Author" tag; obsolete? Use Laboratory (under location) instead?
 
**New tag "Genetic_information"
 
**Change "Transgene_type" to "Reporter_type"
 
**"Multi_point" should be indented
 
**Rescue ?Variation only; remove Rescue ?Gene
 
**Remove Coinjection... stuff from Used_for tag
 
**Add Associated_with tag
 
**Supporting data removed
 
*Where is "Is" vs "Ex" info stored? Currently in "Isolated_by" subtag "Not_integrated"
 
**Remove "Not_integrated"
 
**Should have more explicit display/capturing of extra-chromosomal vs integrated transgene
 
**Where do we store integration location information?
 
**Add to Genetic_information as "Extrachromosomal" and "Integrated" sub-tags
 
*"Driven_by" questions?
 
**"Driven_by_gene": should this be just primary driving sequence? Much more informative
 
***Yes, but very rarely is sequence available from authors
 
***Some of this info held in "Remarks" field
 
***Good if we could get primers, at least
 
***We will keep curating this data in the "Remark" field; maybe hire a summer student/work-study to perform mapping/sequence extraction
 
***Out-sourcing/crowd-sourcing curation?
 
*Hopefully in database by WS226
 
*Clean Remark box for WS226 (not clean for WS225)
 
  
 +
[[WormBase-Caltech_Weekly_Calls_May_2020|May]]
  
Citace Patch (Raymond)
+
[[WormBase-Caltech_Weekly_Calls_June_2020|June]]
*Patch file e-mailed out
 
*step forward for figuring out protocol for patch
 
*If supplemented with geneace, should cover everything outside of the sequence/genome browser domain
 
*How long will it take to load?
 
**Doesn't take long to load into citace
 
**Will test loading into full ACEDB
 
**File only a few MBs
 
**Todd: lots of XREFs slow things down
 
*Complete test will require Geneace patch from Mary Ann
 
  
 +
[[WormBase-Caltech_Weekly_Calls_July_2020|July]]
  
Virtual Worm Site and You Tube tutorials (Chris)
 
  
 +
==August 6th, 2020==
  
SVMs for Genetics papers
+
===Experimental conditions data flow into Alliance===
*Genetics papers were missed for some reason
+
*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)
*Need to rerun Genetics papers through SVM
+
*We use the WB Molecule CV for Inducers and Modifiers in disease annotation
*Need to get through Textpresso as well (before SVM?)
+
*Experimental conditions in phenotype annotations: are free text (captured in remarks); will probably need to formalize later on
*Need to clarify if those papers are on Textpresso-Dev
+
*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
  
  
KOGs
+
== August 13, 2020 ==
*Who is handling/should handle KOG data in WormBase?
 
*Anyone at Caltech have thoughts?
 
*Should get Erich's opinion
 
**Can we maintain it ourselves? Is that out of the question?
 
  
 +
=== 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 multiple Postgres tables for storing species lists:
 +
** pap_species_index (used by "Affected By Pathogen" fields, AFP); Kimberly uses to assign species to papers and occasionally adds new ones
 +
** obo_name_ncbitaxonid
 +
** obo_name_taxon (original, smaller list)
 +
** h_pap_species_index (history for pap_species_index)
 +
* How do species get loaded into ACEDB? Dumps from Postgres? Which table(s)?
 +
* WS277 has 7,906 species (1,936 have no NCBI Taxon ID)
 +
* Kimberly has occasionally uploaded a species.ace file in the context of GO curation; but Hinxton otherwise handles it; should ask them
 +
* New species are associated with paper objects, but otherwise no additional data for those species come from Caltech
 +
* It might be useful to have species pages in WB that at least list papers for which we have species associations, maybe include other information?
  
Updated changes for OA (Juancarlos)
+
=== WS279 Citace upload ===
 +
* When is it happening? Not sure; not on release schedule right now
  
 +
=== SOLR server security (IMSS) ===
 +
* IMSS network security blocked network on our server due to its open SOLR web access.
 +
* Part of AMIGO stack, very old version, drives our ontology browser directly, SObA, Enrichment tools indirectly.
 +
* Added some firewall/URL filter and IMSS opens up the network (for now). IMSS still gripes about its service is open to the world.
  
Daniela and Juancarlos have updated old picture data
+
=== Alzheimer's disease portal ===
*Will send a couple of links around for people to review
+
* Supplement grant awarded to Alliance for an Alzheimer's disease portal
 +
* Could involve automated/concise descriptions, interactions, etc.
 +
* Could establish useful pipelines that could be reused in other contexts

Revision as of 21:01, 13 August 2020

Previous Years

2009 Meetings

2011 Meetings

2012 Meetings

2013 Meetings

2014 Meetings

2015 Meetings

2016 Meetings

2017 Meetings

2018 Meetings

2019 Meetings



2020 Meetings

January

February

March

April

May

June

July


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 multiple Postgres tables for storing species lists:
    • pap_species_index (used by "Affected By Pathogen" fields, AFP); Kimberly uses to assign species to papers and occasionally adds new ones
    • obo_name_ncbitaxonid
    • obo_name_taxon (original, smaller list)
    • h_pap_species_index (history for pap_species_index)
  • How do species get loaded into ACEDB? Dumps from Postgres? Which table(s)?
  • WS277 has 7,906 species (1,936 have no NCBI Taxon ID)
  • Kimberly has occasionally uploaded a species.ace file in the context of GO curation; but Hinxton otherwise handles it; should ask them
  • New species are associated with paper objects, but otherwise no additional data for those species come from Caltech
  • It might be useful to have species pages in WB that at least list papers for which we have species associations, maybe include other information?

WS279 Citace upload

  • When is it happening? Not sure; not on release schedule right now

SOLR server security (IMSS)

  • IMSS network security blocked network on our server due to its open SOLR web access.
  • Part of AMIGO stack, very old version, drives our ontology browser directly, SObA, Enrichment tools indirectly.
  • Added some firewall/URL filter and IMSS opens up the network (for now). IMSS still gripes about its service is open to the world.

Alzheimer's disease portal

  • Supplement grant awarded to Alliance for an Alzheimer's disease portal
  • Could involve automated/concise descriptions, interactions, etc.
  • Could establish useful pipelines that could be reused in other contexts