Home    Target List    Selection    Community Requests    Clones    Screenings    XML files    Diffraction Images    Progress    Homolog Search    Clustering    Statistics    News    Help    Log In
To see full content of that page you need the activeISee plugin.
Get the latest version from here.

Structure of IDP90163

Crystal Structure of Type I 3-Dehydroquinate Dehydratase (aroD) from Clostridium difficile with Covalent Reaction Intermediate.

CSGID target
IDP90163 
PDB Id
3JS3 (NCBI MMDB
Authors
G.Minasov,S.H.Light,L.Shuvalova,I.Dubrovska,J.Winsor,S.N.Peterson,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid) 
Responsible person
George Minasov 
Responsible lab
Northwestern University 
Deposition Date
Sep 09, 2009 
Release Date
Sep 22, 2009 

Annotation

Description
The shikimate pathway links metabolism of carbohydrates to biosynthesis of aromatic compounds. In a sequence of seven metabolic steps, phosphoenolpyruvate and erythrose 4-phosphate are converted to chorismate, the precursor of the aromatic amino acids and many secondary aromatic metabolites. The shikimate pathway is essential for most bacteria and plants but absent in animals.The dehydration of dehydroquinate to dehydroshikimate is an essential step in the shikimate pathway and is thus an attractive target for the development of novel antibiotics. In the pharmaceutical industry, shikimic acid from the Chinese star anise is used as a base material for production of Tamiflu (oseltamivir). Two distinct types of dehydroquinate dehydratases have been shown to catalyze the dehydration of dehydroquinate through disparate mechanisms. The protein we studied is representative of the type I enzyme, which is known to form Schiff base with the reaction intermediate. It has a typical TIM barrel fold with eight parallel beta strands, and active site located at the C-terminal ends of strands. The protein was co-crystallized with the 3-dehydroshikimate, which was found covalently bound to the highly conserved lysine in the active site. The reported structure represents the intermediate step in the dehydration of dehydroquinate to dehydroshikimate.  
Functional assignment
3-dehydroquinate dehydratase 
Presentation Controlls:
rotate
with the [Left]-mouse
drag
with the [Middle]-mouse (or with [Ctrl]-key pressed)
zoom
with the [Left]-mouse in the left zone of the window: zoom-up, unzoom-down
clipping
with the [Left]-mouse in the right zone of the window

Presentation Options:
background color:
black, white
ribbon style:
normal, smooth
ribbon color:
secondary structure, N to C, molecule

Ligands

Ligand code Name Ligand type
DHS 3-amino-4,5-dihydroxy-cyclohex-1-enecarboxylate biological

Structure information

Unit cell parameters

Space Group
P 1 21 1  
Unit Cell

a=60.47Å, b=139.62Å, c=66.77Å
α=90.00, β=90.63, γ=90.00  
Solvent content
49.05  
Matthews coefficient
2.41  

Refinement

Data for the highest resolution shell is in parentheses.
Resolution range
29.55-2.20Å (2.26-2.20Å)  
Rall(%)
19.2  
Rwork(%)
18.9 (28.0)  
Rfree(%)
24.1 (33.0)  
Num. observed reflections
55907 (4028)  
Num. Rfree reflections
2851 (214)  
Completeness(%)
99.8 (98.0)  

Model parameters

Num Atoms
8116  
Num Waters
318  
Num Hetatoms
366  
Model mean isotropic B factor (Å2)
21.950  
RMSD bond length (Å)
0.012  
RMSD bond angle
1.537°  
Filename uploaded
rcsb055088.pdb (uploaded on Sep 11, 2009 7:25 PM)  
Inserted
Sep 11, 2009  

(default) 20 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager" FROM "center_user" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1001
2SELECT "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id", "Structure"."id" AS "Structure__id", "Structure"."target_id" AS "Structure__target_id", "Structure"."structure_solution_id" AS "Structure__structure_solution_id", "Structure"."ref_filename" AS "Structure__ref_filename", "Structure"."ref_uploaded" AS "Structure__ref_uploaded", "Structure"."ref_r" AS "Structure__ref_r", "Structure"."ref_rfree" AS "Structure__ref_rfree", "Structure"."ref_resolution" AS "Structure__ref_resolution", "Structure"."num_atoms" AS "Structure__num_atoms", "Structure"."num_waters" AS "Structure__num_waters", "Structure"."num_hetatoms" AS "Structure__num_hetatoms", "Structure"."ref_res_high" AS "Structure__ref_res_high", "Structure"."ref_res_low" AS "Structure__ref_res_low", "Structure"."ref_sigma_f" AS "Structure__ref_sigma_f", "Structure"."ref_sigma_i" AS "Structure__ref_sigma_i", "Structure"."ref_number_reflns_obs" AS "Structure__ref_number_reflns_obs", "Structure"."ref_percent_reflns_obs" AS "Structure__ref_percent_reflns_obs", "Structure"."ref_percent_reflns_r_free" AS "Structure__ref_percent_reflns_r_free", "Structure"."ref_b_iso_mean" AS "Structure__ref_b_iso_mean", "Structure"."rval_work" AS "Structure__rval_work", "Structure"."ref_bond_refined_d" AS "Structure__ref_bond_refined_d", "Structure"."ref_angle_refined_deg" AS "Structure__ref_angle_refined_deg", "Structure"."ref_shell_res_high" AS "Structure__ref_shell_res_high", "Structure"."ref_shell_res_low" AS "Structure__ref_shell_res_low", "Structure"."ref_shell_number_reflns_all" AS "Structure__ref_shell_number_reflns_all", "Structure"."ref_shell_number_reflns_r_free" AS "Structure__ref_shell_number_reflns_r_free", "Structure"."ref_shell_r_work" AS "Structure__ref_shell_r_work", "Structure"."ref_shell_r_free" AS "Structure__ref_shell_r_free", "Structure"."ref_shell_percent_reflns_obs" AS "Structure__ref_shell_percent_reflns_obs", "Structure"."ref_dihedral_angle" AS "Structure__ref_dihedral_angle", "Structure"."ref_improper_torsion_angle" AS "Structure__ref_improper_torsion_angle", "Structure"."a" AS "Structure__a", "Structure"."b" AS "Structure__b", "Structure"."c" AS "Structure__c", "Structure"."alpha" AS "Structure__alpha", "Structure"."beta" AS "Structure__beta", "Structure"."gamma" AS "Structure__gamma", "Structure"."z" AS "Structure__z", "Structure"."matthew_coeff" AS "Structure__matthew_coeff", "Structure"."spacegroup" AS "Structure__spacegroup", "Structure"."inserted" AS "Structure__inserted", "Structure"."ins_user_id" AS "Structure__ins_user_id", "Structure"."update" AS "Structure__update", "Structure"."upd_user_id" AS "Structure__upd_user_id", "Structure"."staff_id" AS "Structure__staff_id", "Structure"."lab_id" AS "Structure__lab_id", "Lab"."id" AS "Lab__id", "Lab"."short" AS "Lab__short", "Lab"."full_name" AS "Lab__full_name", "Lab"."display_name" AS "Lab__display_name", "Lab"."main" AS "Lab__main", "Lab"."active" AS "Lab__active", "Lab"."prefix" AS "Lab__prefix", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."cell_wall" AS "Target__cell_wall", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."ins_user_id" AS "Target__ins_user_id", "Target"."upd_user_id" AS "Target__upd_user_id", "Target"."stage" AS "Target__stage", "Target"."hidden" AS "Target__hidden", "Target"."submitter_id" AS "Target__submitter_id", "Target"."selection_db_id" AS "Target__selection_db_id", "Target"."dna_source_taxon_id" AS "Target__dna_source_taxon_id", "Target"."batch" AS "Target__batch", "Target"."genus_taxon_id" AS "Target__genus_taxon_id", "Target"."seguid" AS "Target__seguid", "Target"."uniprot_id" AS "Target__uniprot_id", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."ec" AS "Target__ec", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."type" AS "Target__type", (EXISTS(SELECT 1 FROM vs_assay WHERE "Target"."target_id" = "vs_assay"."target_id")) AS "Target__has_screening", "Pdbstructures"."pdb_id" AS "Pdbstructures__pdb_id", "Pdbstructures"."file_modify_date" AS "Pdbstructures__file_modify_date", "Pdbstructures"."header" AS "Pdbstructures__header", "Pdbstructures"."deposition_date" AS "Pdbstructures__deposition_date", "Pdbstructures"."release_date" AS "Pdbstructures__release_date", "Pdbstructures"."collection_date" AS "Pdbstructures__collection_date", "Pdbstructures"."title" AS "Pdbstructures__title", "Pdbstructures"."exp_method" AS "Pdbstructures__exp_method", "Pdbstructures"."resolution" AS "Pdbstructures__resolution", "Pdbstructures"."current_flag" AS "Pdbstructures__current_flag", "Pdbstructures"."time_updated" AS "Pdbstructures__time_updated", "Pdbstructures"."nr_matches_50" AS "Pdbstructures__nr_matches_50", "Pdbstructures"."with_sf" AS "Pdbstructures__with_sf", "Pdbstructures"."exp_detail" AS "Pdbstructures__exp_detail", "Pdbstructures"."nr_matches_30" AS "Pdbstructures__nr_matches_30", "Pdbstructures"."r_value" AS "Pdbstructures__r_value", "Pdbstructures"."rfree_value" AS "Pdbstructures__rfree_value", "Pdbstructures"."b_iso_mean" AS "Pdbstructures__b_iso_mean", "Pdbstructures"."supersede_id" AS "Pdbstructures__supersede_id", "Pdbstructures"."waters" AS "Pdbstructures__waters", "Pdbstructures"."original_deposition_date" AS "Pdbstructures__original_deposition_date", "Pdbstructures"."residue_no" AS "Pdbstructures__residue_no" FROM "deposit" AS "Deposit" LEFT JOIN "structure" AS "Structure" ON ("Deposit"."structure_id" = "Structure"."id") LEFT JOIN "lab" AS "Lab" ON ("Deposit"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("Deposit"."staff_id" = "Staff"."id") LEFT JOIN "protein_target" AS "Target" ON ("Deposit"."target_id" = "Target"."target_id") LEFT JOIN "pdbstructures" AS "Pdbstructures" ON ("Deposit"."pdb_id" = "Pdbstructures"."pdb_id") WHERE "Deposit"."id" = '1135' LIMIT 1014
3SELECT "Pdbchains"."pdb_id" AS "Pdbchains__pdb_id", "Pdbchains"."chain_id" AS "Pdbchains__chain_id", "Pdbchains"."length" AS "Pdbchains__length", "Pdbchains"."sequence_3" AS "Pdbchains__sequence_3", "Pdbchains"."type" AS "Pdbchains__type", "Pdbchains"."time_updated" AS "Pdbchains__time_updated", "Pdbchains"."sequence" AS "Pdbchains__sequence", "Pdbchains"."corrected" AS "Pdbchains__corrected", "Pdbchains"."type2" AS "Pdbchains__type2", "Pdbchains"."calpha_percent" AS "Pdbchains__calpha_percent", "Pdbchains"."datasource" AS "Pdbchains__datasource", "Pdbchains"."numofresidues" AS "Pdbchains__numofresidues", "Pdbchains"."numofatoms" AS "Pdbchains__numofatoms", "Pdbchains"."calpha_residues" AS "Pdbchains__calpha_residues", "Pdbchains"."polymer_residues" AS "Pdbchains__polymer_residues", "Pdbchains"."sequence_coord" AS "Pdbchains__sequence_coord", "Pdbchains"."pi" AS "Pdbchains__pi", "Pdbchains"."null_occupancy" AS "Pdbchains__null_occupancy", "Pdbchains"."low_bfactors" AS "Pdbchains__low_bfactors", "Pdbchains"."high_bfactors" AS "Pdbchains__high_bfactors", "Pdbchains"."mass_seq" AS "Pdbchains__mass_seq", "Pdbchains"."mass_coord" AS "Pdbchains__mass_coord" FROM "pdbchains" AS "Pdbchains" WHERE "Pdbchains"."pdb_id" = ('1135') 000
4SELECT "Ligand"."id" AS "Ligand__id", "Ligand"."code" AS "Ligand__code", "Ligand"."name" AS "Ligand__name", "Ligand"."formula" AS "Ligand__formula", "Ligand"."type" AS "Ligand__type", "Ligand"."inchi" AS "Ligand__inchi", "Ligand"."inchi_key" AS "Ligand__inchi_key", "Ligand"."isomeric_smiles" AS "Ligand__isomeric_smiles", "Ligand"."mw" AS "Ligand__mw", "DepositLigand"."id" AS "DepositLigand__id", "DepositLigand"."deposit_id" AS "DepositLigand__deposit_id", "DepositLigand"."ligand_code" AS "DepositLigand__ligand_code", "DepositLigand"."ligand_type" AS "DepositLigand__ligand_type", "DepositLigand"."inserted" AS "DepositLigand__inserted" FROM "ligand" AS "Ligand" JOIN "deposit_ligand" AS "DepositLigand" ON ("DepositLigand"."deposit_id" = '1135' AND "DepositLigand"."ligand_code" = "Ligand"."code") 011
5SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'deposit_annotation' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position086
6SELECT "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id", "Structure"."id" AS "Structure__id", "Structure"."target_id" AS "Structure__target_id", "Structure"."structure_solution_id" AS "Structure__structure_solution_id", "Structure"."ref_filename" AS "Structure__ref_filename", "Structure"."ref_uploaded" AS "Structure__ref_uploaded", "Structure"."ref_r" AS "Structure__ref_r", "Structure"."ref_rfree" AS "Structure__ref_rfree", "Structure"."ref_resolution" AS "Structure__ref_resolution", "Structure"."num_atoms" AS "Structure__num_atoms", "Structure"."num_waters" AS "Structure__num_waters", "Structure"."num_hetatoms" AS "Structure__num_hetatoms", "Structure"."ref_res_high" AS "Structure__ref_res_high", "Structure"."ref_res_low" AS "Structure__ref_res_low", "Structure"."ref_sigma_f" AS "Structure__ref_sigma_f", "Structure"."ref_sigma_i" AS "Structure__ref_sigma_i", "Structure"."ref_number_reflns_obs" AS "Structure__ref_number_reflns_obs", "Structure"."ref_percent_reflns_obs" AS "Structure__ref_percent_reflns_obs", "Structure"."ref_percent_reflns_r_free" AS "Structure__ref_percent_reflns_r_free", "Structure"."ref_b_iso_mean" AS "Structure__ref_b_iso_mean", "Structure"."rval_work" AS "Structure__rval_work", "Structure"."ref_bond_refined_d" AS "Structure__ref_bond_refined_d", "Structure"."ref_angle_refined_deg" AS "Structure__ref_angle_refined_deg", "Structure"."ref_shell_res_high" AS "Structure__ref_shell_res_high", "Structure"."ref_shell_res_low" AS "Structure__ref_shell_res_low", "Structure"."ref_shell_number_reflns_all" AS "Structure__ref_shell_number_reflns_all", "Structure"."ref_shell_number_reflns_r_free" AS "Structure__ref_shell_number_reflns_r_free", "Structure"."ref_shell_r_work" AS "Structure__ref_shell_r_work", "Structure"."ref_shell_r_free" AS "Structure__ref_shell_r_free", "Structure"."ref_shell_percent_reflns_obs" AS "Structure__ref_shell_percent_reflns_obs", "Structure"."ref_dihedral_angle" AS "Structure__ref_dihedral_angle", "Structure"."ref_improper_torsion_angle" AS "Structure__ref_improper_torsion_angle", "Structure"."a" AS "Structure__a", "Structure"."b" AS "Structure__b", "Structure"."c" AS "Structure__c", "Structure"."alpha" AS "Structure__alpha", "Structure"."beta" AS "Structure__beta", "Structure"."gamma" AS "Structure__gamma", "Structure"."z" AS "Structure__z", "Structure"."matthew_coeff" AS "Structure__matthew_coeff", "Structure"."spacegroup" AS "Structure__spacegroup", "Structure"."inserted" AS "Structure__inserted", "Structure"."ins_user_id" AS "Structure__ins_user_id", "Structure"."update" AS "Structure__update", "Structure"."upd_user_id" AS "Structure__upd_user_id", "Structure"."staff_id" AS "Structure__staff_id", "Structure"."lab_id" AS "Structure__lab_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Pdbstructures"."pdb_id" AS "Pdbstructures__pdb_id", "Pdbstructures"."file_modify_date" AS "Pdbstructures__file_modify_date", "Pdbstructures"."header" AS "Pdbstructures__header", "Pdbstructures"."deposition_date" AS "Pdbstructures__deposition_date", "Pdbstructures"."release_date" AS "Pdbstructures__release_date", "Pdbstructures"."collection_date" AS "Pdbstructures__collection_date", "Pdbstructures"."title" AS "Pdbstructures__title", "Pdbstructures"."exp_method" AS "Pdbstructures__exp_method", "Pdbstructures"."resolution" AS "Pdbstructures__resolution", "Pdbstructures"."current_flag" AS "Pdbstructures__current_flag", "Pdbstructures"."time_updated" AS "Pdbstructures__time_updated", "Pdbstructures"."nr_matches_50" AS "Pdbstructures__nr_matches_50", "Pdbstructures"."with_sf" AS "Pdbstructures__with_sf", "Pdbstructures"."exp_detail" AS "Pdbstructures__exp_detail", "Pdbstructures"."nr_matches_30" AS "Pdbstructures__nr_matches_30", "Pdbstructures"."r_value" AS "Pdbstructures__r_value", "Pdbstructures"."rfree_value" AS "Pdbstructures__rfree_value", "Pdbstructures"."b_iso_mean" AS "Pdbstructures__b_iso_mean", "Pdbstructures"."supersede_id" AS "Pdbstructures__supersede_id", "Pdbstructures"."waters" AS "Pdbstructures__waters", "Pdbstructures"."original_deposition_date" AS "Pdbstructures__original_deposition_date", "Pdbstructures"."residue_no" AS "Pdbstructures__residue_no", "DepositAnnotation"."id" AS "DepositAnnotation__id", "DepositAnnotation"."deposit_id" AS "DepositAnnotation__deposit_id", "DepositAnnotation"."description" AS "DepositAnnotation__description", "DepositAnnotation"."functional_assignment" AS "DepositAnnotation__functional_assignment", "DepositAnnotation"."function_determined_experimentally" AS "DepositAnnotation__function_determined_experimentally", "DepositAnnotation"."new_fold" AS "DepositAnnotation__new_fold", "DepositAnnotation"."nih_raport_complicated_structure" AS "DepositAnnotation__nih_raport_complicated_structure", "DepositAnnotation"."nih_other_information" AS "DepositAnnotation__nih_other_information" FROM "deposit" AS "Deposit" LEFT JOIN "structure" AS "Structure" ON ("Deposit"."structure_id" = "Structure"."id") LEFT JOIN "staff" AS "Staff" ON ("Deposit"."staff_id" = "Staff"."id") LEFT JOIN "pdbstructures" AS "Pdbstructures" ON ("Deposit"."pdb_id" = "Pdbstructures"."pdb_id") LEFT JOIN "deposit_annotation" AS "DepositAnnotation" ON ("DepositAnnotation"."deposit_id" = "Deposit"."id") WHERE "Deposit"."id" = '1135' LIMIT 1012
7SELECT "Structure"."id" AS "Structure__id", "Structure"."target_id" AS "Structure__target_id", "Structure"."structure_solution_id" AS "Structure__structure_solution_id", "Structure"."ref_filename" AS "Structure__ref_filename", "Structure"."ref_uploaded" AS "Structure__ref_uploaded", "Structure"."ref_r" AS "Structure__ref_r", "Structure"."ref_rfree" AS "Structure__ref_rfree", "Structure"."ref_resolution" AS "Structure__ref_resolution", "Structure"."num_atoms" AS "Structure__num_atoms", "Structure"."num_waters" AS "Structure__num_waters", "Structure"."num_hetatoms" AS "Structure__num_hetatoms", "Structure"."ref_res_high" AS "Structure__ref_res_high", "Structure"."ref_res_low" AS "Structure__ref_res_low", "Structure"."ref_sigma_f" AS "Structure__ref_sigma_f", "Structure"."ref_sigma_i" AS "Structure__ref_sigma_i", "Structure"."ref_number_reflns_obs" AS "Structure__ref_number_reflns_obs", "Structure"."ref_percent_reflns_obs" AS "Structure__ref_percent_reflns_obs", "Structure"."ref_percent_reflns_r_free" AS "Structure__ref_percent_reflns_r_free", "Structure"."ref_b_iso_mean" AS "Structure__ref_b_iso_mean", "Structure"."rval_work" AS "Structure__rval_work", "Structure"."ref_bond_refined_d" AS "Structure__ref_bond_refined_d", "Structure"."ref_angle_refined_deg" AS "Structure__ref_angle_refined_deg", "Structure"."ref_shell_res_high" AS "Structure__ref_shell_res_high", "Structure"."ref_shell_res_low" AS "Structure__ref_shell_res_low", "Structure"."ref_shell_number_reflns_all" AS "Structure__ref_shell_number_reflns_all", "Structure"."ref_shell_number_reflns_r_free" AS "Structure__ref_shell_number_reflns_r_free", "Structure"."ref_shell_r_work" AS "Structure__ref_shell_r_work", "Structure"."ref_shell_r_free" AS "Structure__ref_shell_r_free", "Structure"."ref_shell_percent_reflns_obs" AS "Structure__ref_shell_percent_reflns_obs", "Structure"."ref_dihedral_angle" AS "Structure__ref_dihedral_angle", "Structure"."ref_improper_torsion_angle" AS "Structure__ref_improper_torsion_angle", "Structure"."a" AS "Structure__a", "Structure"."b" AS "Structure__b", "Structure"."c" AS "Structure__c", "Structure"."alpha" AS "Structure__alpha", "Structure"."beta" AS "Structure__beta", "Structure"."gamma" AS "Structure__gamma", "Structure"."z" AS "Structure__z", "Structure"."matthew_coeff" AS "Structure__matthew_coeff", "Structure"."spacegroup" AS "Structure__spacegroup", "Structure"."inserted" AS "Structure__inserted", "Structure"."ins_user_id" AS "Structure__ins_user_id", "Structure"."update" AS "Structure__update", "Structure"."upd_user_id" AS "Structure__upd_user_id", "Structure"."staff_id" AS "Structure__staff_id", "Structure"."lab_id" AS "Structure__lab_id" FROM "structure" AS "Structure" WHERE "Structure"."id" = '165' 010
8SELECT "StructureSolution"."id" AS "StructureSolution__id", "StructureSolution"."target_id" AS "StructureSolution__target_id", "StructureSolution"."solution_date" AS "StructureSolution__solution_date", "StructureSolution"."staff_id" AS "StructureSolution__staff_id", "StructureSolution"."other_people" AS "StructureSolution__other_people", "StructureSolution"."lab_id" AS "StructureSolution__lab_id", "StructureSolution"."status" AS "StructureSolution__status", "StructureSolution"."method" AS "StructureSolution__method", "StructureSolution"."phasing_resolution" AS "StructureSolution__phasing_resolution", "StructureSolution"."model_pdb_id" AS "StructureSolution__model_pdb_id", "StructureSolution"."model_description" AS "StructureSolution__model_description", "StructureSolution"."phasing_atom_type" AS "StructureSolution__phasing_atom_type", "StructureSolution"."phasing_atom_sites" AS "StructureSolution__phasing_atom_sites", "StructureSolution"."mean_fom" AS "StructureSolution__mean_fom", "StructureSolution"."phasing_program_id" AS "StructureSolution__phasing_program_id", "StructureSolution"."phasing_programs_other" AS "StructureSolution__phasing_programs_other", "StructureSolution"."sites_location_program_id" AS "StructureSolution__sites_location_program_id", "StructureSolution"."sites_location_programs_other" AS "StructureSolution__sites_location_programs_other", "StructureSolution"."model_building_program_id" AS "StructureSolution__model_building_program_id", "StructureSolution"."model_building_programs_other" AS "StructureSolution__model_building_programs_other", "StructureSolution"."inserted" AS "StructureSolution__inserted", "StructureSolution"."ins_user_id" AS "StructureSolution__ins_user_id", "StructureSolution"."update" AS "StructureSolution__update", "StructureSolution"."upd_user_id" AS "StructureSolution__upd_user_id" FROM "structure_solution" AS "StructureSolution" WHERE "StructureSolution"."id" = '28' 010
9SELECT "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id" FROM "deposit" AS "Deposit" WHERE "Deposit"."structure_id" = '165' 010
10SELECT "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager" FROM "staff" AS "Staff" WHERE "Staff"."id" = '58' 010
11SELECT "Lab"."id" AS "Lab__id", "Lab"."short" AS "Lab__short", "Lab"."full_name" AS "Lab__full_name", "Lab"."display_name" AS "Lab__display_name", "Lab"."main" AS "Lab__main", "Lab"."active" AS "Lab__active", "Lab"."prefix" AS "Lab__prefix" FROM "lab" AS "Lab" WHERE "Lab"."short" = 'NU' 010
12SELECT "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id" FROM "deposit" AS "Deposit" WHERE "Deposit"."staff_id" = ('58') 0911
13SELECT "Pdbstructures"."pdb_id" AS "Pdbstructures__pdb_id", "Pdbstructures"."file_modify_date" AS "Pdbstructures__file_modify_date", "Pdbstructures"."header" AS "Pdbstructures__header", "Pdbstructures"."deposition_date" AS "Pdbstructures__deposition_date", "Pdbstructures"."release_date" AS "Pdbstructures__release_date", "Pdbstructures"."collection_date" AS "Pdbstructures__collection_date", "Pdbstructures"."title" AS "Pdbstructures__title", "Pdbstructures"."exp_method" AS "Pdbstructures__exp_method", "Pdbstructures"."resolution" AS "Pdbstructures__resolution", "Pdbstructures"."current_flag" AS "Pdbstructures__current_flag", "Pdbstructures"."time_updated" AS "Pdbstructures__time_updated", "Pdbstructures"."nr_matches_50" AS "Pdbstructures__nr_matches_50", "Pdbstructures"."with_sf" AS "Pdbstructures__with_sf", "Pdbstructures"."exp_detail" AS "Pdbstructures__exp_detail", "Pdbstructures"."nr_matches_30" AS "Pdbstructures__nr_matches_30", "Pdbstructures"."r_value" AS "Pdbstructures__r_value", "Pdbstructures"."rfree_value" AS "Pdbstructures__rfree_value", "Pdbstructures"."b_iso_mean" AS "Pdbstructures__b_iso_mean", "Pdbstructures"."supersede_id" AS "Pdbstructures__supersede_id", "Pdbstructures"."waters" AS "Pdbstructures__waters", "Pdbstructures"."original_deposition_date" AS "Pdbstructures__original_deposition_date", "Pdbstructures"."residue_no" AS "Pdbstructures__residue_no" FROM "pdbstructures" AS "Pdbstructures" WHERE "Pdbstructures"."pdb_id" = '3JS3' 010
14SELECT "DepositAnnotation"."id" AS "DepositAnnotation__id", "DepositAnnotation"."deposit_id" AS "DepositAnnotation__deposit_id", "DepositAnnotation"."description" AS "DepositAnnotation__description", "DepositAnnotation"."functional_assignment" AS "DepositAnnotation__functional_assignment", "DepositAnnotation"."function_determined_experimentally" AS "DepositAnnotation__function_determined_experimentally", "DepositAnnotation"."new_fold" AS "DepositAnnotation__new_fold", "DepositAnnotation"."nih_raport_complicated_structure" AS "DepositAnnotation__nih_raport_complicated_structure", "DepositAnnotation"."nih_other_information" AS "DepositAnnotation__nih_other_information" FROM "deposit_annotation" AS "DepositAnnotation" WHERE "DepositAnnotation"."deposit_id" = '1135' 010
15SELECT "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id" FROM "deposit" AS "Deposit" WHERE "Deposit"."id" = '1135' 010
16SELECT "Pdbchains"."pdb_id" AS "Pdbchains__pdb_id", "Pdbchains"."chain_id" AS "Pdbchains__chain_id", "Pdbchains"."length" AS "Pdbchains__length", "Pdbchains"."sequence_3" AS "Pdbchains__sequence_3", "Pdbchains"."type" AS "Pdbchains__type", "Pdbchains"."time_updated" AS "Pdbchains__time_updated", "Pdbchains"."sequence" AS "Pdbchains__sequence", "Pdbchains"."corrected" AS "Pdbchains__corrected", "Pdbchains"."type2" AS "Pdbchains__type2", "Pdbchains"."calpha_percent" AS "Pdbchains__calpha_percent", "Pdbchains"."datasource" AS "Pdbchains__datasource", "Pdbchains"."numofresidues" AS "Pdbchains__numofresidues", "Pdbchains"."numofatoms" AS "Pdbchains__numofatoms", "Pdbchains"."calpha_residues" AS "Pdbchains__calpha_residues", "Pdbchains"."polymer_residues" AS "Pdbchains__polymer_residues", "Pdbchains"."sequence_coord" AS "Pdbchains__sequence_coord", "Pdbchains"."pi" AS "Pdbchains__pi", "Pdbchains"."null_occupancy" AS "Pdbchains__null_occupancy", "Pdbchains"."low_bfactors" AS "Pdbchains__low_bfactors", "Pdbchains"."high_bfactors" AS "Pdbchains__high_bfactors", "Pdbchains"."mass_seq" AS "Pdbchains__mass_seq", "Pdbchains"."mass_coord" AS "Pdbchains__mass_coord" FROM "pdbchains" AS "Pdbchains" WHERE "Pdbchains"."pdb_id" = ('1135') 000
17SELECT "Ligand"."id" AS "Ligand__id", "Ligand"."code" AS "Ligand__code", "Ligand"."name" AS "Ligand__name", "Ligand"."formula" AS "Ligand__formula", "Ligand"."type" AS "Ligand__type", "Ligand"."inchi" AS "Ligand__inchi", "Ligand"."inchi_key" AS "Ligand__inchi_key", "Ligand"."isomeric_smiles" AS "Ligand__isomeric_smiles", "Ligand"."mw" AS "Ligand__mw", "DepositLigand"."id" AS "DepositLigand__id", "DepositLigand"."deposit_id" AS "DepositLigand__deposit_id", "DepositLigand"."ligand_code" AS "DepositLigand__ligand_code", "DepositLigand"."ligand_type" AS "DepositLigand__ligand_type", "DepositLigand"."inserted" AS "DepositLigand__inserted" FROM "ligand" AS "Ligand" JOIN "deposit_ligand" AS "DepositLigand" ON ("DepositLigand"."deposit_id" = '1135' AND "DepositLigand"."ligand_code" = "Ligand"."code") 011
18SELECT "DepositLigand"."id" AS "DepositLigand__id", "DepositLigand"."deposit_id" AS "DepositLigand__deposit_id", "DepositLigand"."ligand_code" AS "DepositLigand__ligand_code", "DepositLigand"."ligand_type" AS "DepositLigand__ligand_type", "DepositLigand"."inserted" AS "DepositLigand__inserted", "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id", "Ligand"."id" AS "Ligand__id", "Ligand"."code" AS "Ligand__code", "Ligand"."name" AS "Ligand__name", "Ligand"."formula" AS "Ligand__formula", "Ligand"."type" AS "Ligand__type", "Ligand"."inchi" AS "Ligand__inchi", "Ligand"."inchi_key" AS "Ligand__inchi_key", "Ligand"."isomeric_smiles" AS "Ligand__isomeric_smiles", "Ligand"."mw" AS "Ligand__mw" FROM "deposit_ligand" AS "DepositLigand" LEFT JOIN "deposit" AS "Deposit" ON ("DepositLigand"."deposit_id" = "Deposit"."id") LEFT JOIN "ligand" AS "Ligand" ON ("DepositLigand"."ligand_code" = "Ligand"."code") WHERE "DepositLigand"."deposit_id" = '1135' 011
19SELECT "Ligand"."id" AS "Ligand__id", "Ligand"."code" AS "Ligand__code", "Ligand"."name" AS "Ligand__name", "Ligand"."formula" AS "Ligand__formula", "Ligand"."type" AS "Ligand__type", "Ligand"."inchi" AS "Ligand__inchi", "Ligand"."inchi_key" AS "Ligand__inchi_key", "Ligand"."isomeric_smiles" AS "Ligand__isomeric_smiles", "Ligand"."mw" AS "Ligand__mw" FROM "ligand" AS "Ligand" WHERE "Ligand"."code" = ('DHS') 010
20SELECT "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id", "DepositLigand"."id" AS "DepositLigand__id", "DepositLigand"."deposit_id" AS "DepositLigand__deposit_id", "DepositLigand"."ligand_code" AS "DepositLigand__ligand_code", "DepositLigand"."ligand_type" AS "DepositLigand__ligand_type", "DepositLigand"."inserted" AS "DepositLigand__inserted" FROM "deposit" AS "Deposit" JOIN "deposit_ligand" AS "DepositLigand" ON ("DepositLigand"."ligand_code" = 'DHS' AND "DepositLigand"."deposit_id" = "Deposit"."id") 010