BMRB ID |
---|
4635 |
4841 |
4874 |
5457 |
5808 |
6749 |
6899 |
15569 |
15570 |
17485 |
17653 |
18988 |
27227 |
50098 |
50099 |
50100 |
50101 |
50102 |
50103 |
50105 |
50370 |
Found 21 row(s)
SQL query was:
select count(*) from (select distinct e."ID" as "BMRB ID",cast(e."ID" as integer) as num from macromolecules."Entry" e join (select distinct "Entry_ID","Name" as "Molecule" from macromolecules."Assembly" union select "Entry_ID","Name" as "Molecule" from macromolecules."Entity" union select "Entry_ID","Name" as "Molecule" from macromolecules."Chem_comp") m on m."Entry_ID"=e."ID" where m."Molecule" ~* 'PAH') as foo
(If the results don't include an entry that should be there, please check the list of NMR-STAR 2.1 entries that have not been updated to NMR-STAR 3.1 yet)