Difference between revisions of "WormBase-Caltech Weekly Calls"

From WormBaseWiki
Jump to navigationJump to search
(7 intermediate revisions by the same user not shown)
Line 43: Line 43:
 
***Include regardless of whether there is an associated gene (this seems to be the current practice?).
 
***Include regardless of whether there is an associated gene (this seems to be the current practice?).
 
***Currently, some variations with a given Method, e.g. Million_mutation, are NOT included.  We would continue this filtering.
 
***Currently, some variations with a given Method, e.g. Million_mutation, are NOT included.  We would continue this filtering.
 +
****SNP
 
****WGS_Hawaiian_Waterston
 
****WGS_Hawaiian_Waterston
 
****WGS_Pasadena_Quinlan
 
****WGS_Pasadena_Quinlan
Line 58: Line 59:
 
***The effect on the autocomplete, if we include all, probably won't be a problem 1,018,332 vs 306116)
 
***The effect on the autocomplete, if we include all, probably won't be a problem 1,018,332 vs 306116)
 
***Some of the gene ids from other species don't have 'WBGene' prefixes, e.g. Sp34_10109610.  Should we keep this in a separate table from genes with 'WBGene' prefixes?
 
***Some of the gene ids from other species don't have 'WBGene' prefixes, e.g. Sp34_10109610.  Should we keep this in a separate table from genes with 'WBGene' prefixes?
 +
 +
= January 20th, 2022 =
 +
 +
== Proposal for updating gene and variation information from WS releases ==
 +
=== Genes ===
 +
*Have two tables:
 +
**One continues as is - contains only ids for the [https://wormbase.org/species/all core nematode species] (all have WBGene ids)
 +
**Second, new table - contains non-WGene ids for [https://wormbase.org/species/al comparator nematode genomes]
 +
***Include other elegans and remanei strains?
 +
**Would not include ids for non-WB (and WBParaSite) genomes, e.g. Drosophila or budding yeast
 +
=== Variations ===
 +
*Include all variations that have a value for:
 +
**Method - current filters applied (filter SNP, Million_mutation, WGS's)
 +
**Species - all
 +
**Status - include all three status values (Live, Dead, Suppressed)
 +
*Whether a variation has a gene association doesn't matter (not a filter criteria for postgres)
 +
*From Paul D. - a number of variations in geneace were not making their way as individual objects to WS during the build and so were only created in WS via xref (hence the lack of other information). He's updated geneace with Species and other information wherever possible for the next build.
 +
*Variation merges are infrequent; previous ones may have been due to nameserver issues
 +
*New Methods arise infrequently, but we could check our parsing script against the list of Methods in each release to make sure we're up-to-date.  Would need an inclusion and exclusion list.

Revision as of 15:24, 20 January 2022

Previous Years

2009 Meetings

2011 Meetings

2012 Meetings

2013 Meetings

2014 Meetings

2015 Meetings

2016 Meetings

2017 Meetings

2018 Meetings

2019 Meetings

2020 Meetings

2021 Meetings

2022 Meetings

January

January 13th, 2022

tm variation - gene associations

  • Update on progress and some questions for the Caltech curators
  • Background: not all variations were being associated with genes in the OA table because some of those associations are in WS but not in geneace, so weren't coming through in the nightly geneace dump. Some variation-gene associations are made as part of the VEP pipeline during the build.
  • Wen now downloads several full ACeDB classes from the latest WS release in the form of .ace files so we can also have whatever information is in WS. Raymond wrote a script to sync those files to tazendra for further processing/use.
  • A few questions that we want to confirm before going forward:
    • In the WS variations file, there are 2,130,801 total variations (1,911,339 total Live) while in postgres there are currently 106,080.
      • Only include Status = Live variations?
      • Include regardless of whether there is an associated gene (this seems to be the current practice?).
      • Currently, some variations with a given Method, e.g. Million_mutation, are NOT included. We would continue this filtering.
        • SNP
        • WGS_Hawaiian_Waterston
        • WGS_Pasadena_Quinlan
        • WGS_Hobert
        • Million_mutation
        • WGS_Yanai
        • WGS_De_Bono
        • WGS_Andersen
        • WGS_Flibotte
        • WGS_Rose
      • Do we want other filters?
    • For genes, the ace file contains ALL the gene objects in WB regardless of species.
      • We've recently had an author request, via the Acknowledge pipeline, to associate genes of other, less well studied Caenorhabditis species, e.g. C. inopinata, to their paper.
      • Do we want all Caenorhabditis (and other nematode) species genes in our various gene tables, e.g. obo, paper? Any other species?
      • The effect on the autocomplete, if we include all, probably won't be a problem 1,018,332 vs 306116)
      • Some of the gene ids from other species don't have 'WBGene' prefixes, e.g. Sp34_10109610. Should we keep this in a separate table from genes with 'WBGene' prefixes?

January 20th, 2022

Proposal for updating gene and variation information from WS releases

Genes

  • Have two tables:
    • One continues as is - contains only ids for the core nematode species (all have WBGene ids)
    • Second, new table - contains non-WGene ids for comparator nematode genomes
      • Include other elegans and remanei strains?
    • Would not include ids for non-WB (and WBParaSite) genomes, e.g. Drosophila or budding yeast

Variations

  • Include all variations that have a value for:
    • Method - current filters applied (filter SNP, Million_mutation, WGS's)
    • Species - all
    • Status - include all three status values (Live, Dead, Suppressed)
  • Whether a variation has a gene association doesn't matter (not a filter criteria for postgres)
  • From Paul D. - a number of variations in geneace were not making their way as individual objects to WS during the build and so were only created in WS via xref (hence the lack of other information). He's updated geneace with Species and other information wherever possible for the next build.
  • Variation merges are infrequent; previous ones may have been due to nameserver issues
  • New Methods arise infrequently, but we could check our parsing script against the list of Methods in each release to make sure we're up-to-date. Would need an inclusion and exclusion list.