PDBエントリー1a14に含まれる残基の数を得る

• 検索サービス
• PDBj Mine
• SQL検索
• PDBエントリー1a14に含まれる残基の数を得る

検索はこちら

WITH slen(pdbid, entity_id, len) AS
(select pdbid, entity_id, count(*) 
 FROM entity_poly_seq 
 WHERE pdbid='1a14'
 GROUP BY pdbid, entity_id)
SELECT entity.pdbid, SUM(entity.pdbx_number_of_molecules*s.len) AS NumberOfResidues
FROM entity
JOIN slen AS s ON s.pdbid = entity.pdbid and s.entity_id = entity.id
GROUP BY entity.pdbid