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

• Search Services
• PDBj Mine
• SQL Search
• 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