UPDATE "equiseq_horse_genes" eg
SET "FLNC1" = CASE
                WHEN eg1."P3" = 'N/N' OR eg1."P3" = 'n/n' THEN 'n/n'
                WHEN eg1."P3" = 'N/P3' OR eg1."P3" = 'n/P3' THEN 'n/P3a'
                WHEN eg1."P3" = 'P3/P3' THEN 'P3a/P3a'
                ELSE eg."FLNC1"
             END,
    "FLNC2" = CASE
                WHEN eg1."P3" = 'N/N' OR eg1."P3" = 'n/n' THEN 'n/n'
                WHEN eg1."P3" = 'N/P3' OR eg1."P3" = 'n/P3' THEN 'n/P3b'
                WHEN eg1."P3" = 'P3/P3' THEN 'P3b/P3b'
                ELSE eg."FLNC2"
             END
FROM "equiseq_horse_genes1" eg1
WHERE eg."horse_id" = eg1."horse_id";
