virusseq / portal-ui

Canadian VirusSeq Data Portal
https://virusseq-dataportal.ca/
GNU Affero General Public License v3.0
8 stars 8 forks source link

SK Update to Purpose of Sequencing Values #446

Open KirstenPalmier opened 1 month ago

KirstenPalmier commented 1 month ago

Hi @edsu7,

Can you please update the following to include a space after the semi-colon? Sepcimen Collector ID Old value New Value
SK_339227 Screening for Variants of Concern (VoC);International travel surveillance Screening for Variants of Concern (VoC); International travel surveillance
SK_339228 Screening for Variants of Concern (VoC);International travel surveillance Screening for Variants of Concern (VoC); International travel surveillance
SK_339225 Screening for Variants of Concern (VoC);International travel surveillance Screening for Variants of Concern (VoC); International travel surveillance
SK_339226 Screening for Variants of Concern (VoC);International travel surveillance Screening for Variants of Concern (VoC); International travel surveillance
SK_339224 Screening for Variants of Concern (VoC);International travel surveillance Screening for Variants of Concern (VoC); International travel surveillance
SK_339223 Screening for Variants of Concern (VoC);International travel surveillance Screening for Variants of Concern (VoC); International travel surveillance
SK_339222 Screening for Variants of Concern (VoC);International travel surveillance Screening for Variants of Concern (VoC); International travel surveillance

Thank you!

Kirsten Palmier

edsu7 commented 3 weeks ago

Hi @KirstenPalmier ,

Where did those values come from?

For some added context, for purpose_of_sequencing the database allows for multiple values and joins them when outputting to CSV and on UI.

For example on the UI: image

and downloaded file: https://docs.google.com/spreadsheets/d/1vvvbmW4E21pZGDF9fIfwFR_7WJLtuioMmb1KvKxbl4k/edit?gid=0#gid=0 study_id specimen collector sample ID purpose of sequencing
RRPL-SK SK_339225 Screening for Variants of Concern (VoC), International travel surveillance
RRPL-SK SK_339228 Screening for Variants of Concern (VoC), International travel surveillance
NSHA-NS NS_202590 Domestic travel surveillance, Vaccine escape surveillance
EH-NL NL_157415 Travel-associated surveillance, Domestic travel surveillance, International travel surveillance
PHO-ON ON_85211 Targeted surveillance (non-random sampling), Surveillance of international border crossing by air travel or ground transport
RRPL-SK SK_339227 Screening for Variants of Concern (VoC), International travel surveillance

Both of which have the space after the delimiter.

Cheers, Edmund