DPL-470-1: malformed root_sample_ids that were picked, but are not duplicated in MLWH

[Jonnie-Bevan]

User Story
Part of the wider DPL-470 issue which spawned in turn from DPL-048. Related are DPL-0483-2, DPL-0483-3 and DPL-0483-5

This story concerns the 1,128 malformed root_sample_ids in the MLWH lighthouse_sample table which were picked at some point and are therefore in SS, the MLWH sample table and Event Warehouse as well as lighthouse_sample (+ MongoDB). These came from the MK lighthouse lab in 2021 and have an extra substring (something like '_RNA123456789') concatenated on the end of the correct ID.

Fix
These IDs are not duplicated in MLWH or elsewhere (as far as I know currently), so the fixed ID can simply update the ID in each of the 5 places it needs updating. The fix simply involves removing any string from after the underscore.

Who are the primary contacts for this story
Jonnie B
Alan K

Acceptance criteria

• data are fixed in MLWH lighthouse_sample table
• data are fixed in MongoDB sample table
• data are fixed in SequenceScape samples table (root_sample_id is called description here). This should proliferate to the MLWH sample table, but this needs to be checked to be sure
• data are fixed in Event Warehouse