drop table if exists clusters;

create table clusters
(
    factor      char(1) not null,
    sequence    varchar(10) not null,
    num         integer unsigned not null,
    index (sequence)
);

insert into clusters values
    ('C', 'seq1', 25),
    ('A', 'seq1', 20),
    ('E', 'seq2', 45),
    ('D', 'seq2', 30),
    ('B', 'seq2', 25),
    ('B', 'seq1', 40),
    ('B', 'seq2', 80)
;

select
    sequence,
    group_concat(factor order by factor) as factors,
    group_concat(num    order by factor) as nums
from
    clusters
group by
    sequence
having
    factors like '%A%B%C%'
    or
    factors like '%B%D%E%'