Decide on default schema for metadata table #1
Description
At the moment all metadata provided in CSV or XLS is feed into the metadata table. By design StrainID is required. Unfortunately the metadata available for projects varies and it's difficult to write useful default queries. It also can vary significantly in cntext between a pathogen project and and microbial genomics project.
There are a two obvious options:
- Enforce a set of defaults and set to null if does not exist. Query can simply check all strains contain null for that field.
- Once metadata is in, inspect and have code generate queries given the metadata
I probably prefer the 1st, but it means as a group we need to decided on the the defaults.