Skip to content

Parse VIDRL human sera pool measurements #158

@huddlej

Description

@huddlej

Description

Summary of the plan for parsing human sera pool measurements from VIDRL spreadsheets:

  1. Parse past VIDRL spreadsheets to find all distinct serum id values for human sera pools, so we know what values need to be mapped to vaccine strain names
  2. Create a TSV file per subtype in fauna that maps human sera pool ids from VIDRL to vaccine strains (e.g., “SH 2024 EGG” to “A/Thailand/8/2022-egg” for H3N2) using seasonal-flu vaccine.json files (e.g., H3N2) as a source of truth
  3. Add logic to tdb/vidrl_upload.py to convert serum_id (e.g., “SH 2024”) and serum_passage (e.g., “EGG”) values from the parsed titer blocks to a key that appears in the TSV file mapping above and use that key to set the serum strain to the vaccine strain name
  4. Run the upload script on past spreadsheets (as dryrun?) and confirm that human sera pool measurements get extract for H1, H3, and Vic
  5. Upload just the new human sera pool measurements to fauna

Metadata

Metadata

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions