Select Code to Download

drop table if exists clusters;

...
    factors like '%A%B%C%'
    or
    factors like '%B%D%E%'

+----------+---------+-------------+
| sequence | factors | nums        |
...
| seq1     | A,B,C   | 20,40,25    |
| seq2     | B,B,D,E | 80,25,30,45 |
+----------+---------+-------------+

use strict;
use warnings;
...
        );
    }
}

B = 80 D = 30   E = 45 
B = 80 D = 30   E = 0.5
...
B = 25 D = 1000 E = 45 
B = 25 D = 1000 E = 0.5
... (24_200_000 rows)