各PDBエントリーのPDBIDと高分子鎖の合計化学式量を得る(合計化学式量の多い順)
検索はこちら
SELECT pdbid, SUM(pdbx_number_of_molecules*formula_weight) AS weight FROM entity WHERE type = 'polymer' GROUP BY pdbid ORDER BY weight DESC
作成日: 2021-02-01 (最終更新日: more than 1 year ago)

検索はこちら
SELECT pdbid, SUM(pdbx_number_of_molecules*formula_weight) AS weight FROM entity WHERE type = 'polymer' GROUP BY pdbid ORDER BY weight DESC