Get the chain IDs (auth_asym_ids and lable_asym_ids), entity IDs, entity names and type of chain (polymer or not) for PDB entiry 4uv7
This search can be run from here.
WITH t1 AS (SELECT DISTINCT e1.pdbid, e1.id entity_id, e1.pdbx_description chain_name, e1.type FROM entity e1 WHERE e1.pdbid='4uv7') SELECT t1.pdbid, t1.entity_id, trim(both ',' from array_to_string(array_cat(array_agg(DISTINCT e2.pdb_strand_id),array_agg(DISTINCT e3.pdb_strand_id)),',')) auth_asym_ids, trim(both ',' from array_to_string(array_cat(array_agg(DISTINCT e2.asym_id),array_agg(DISTINCT e3.asym_id)),',')) label_asym_ids, t1.chain_name, t1.type FROM t1 LEFT JOIN pdbx_poly_seq_scheme e2 ON t1.pdbid=e2.pdbid AND t1.entity_id=e2.entity_id LEFT JOIN pdbx_nonpoly_scheme e3 ON t1.pdbid=e3.pdbid AND t1.entity_id=e3.entity_id GROUP BY t1.pdbid, t1.entity_id, t1.chain_name, t1.type
Created: 2019-06-12 (last edited: more than 1 year ago)