Home    Target List    Selection    Community Requests    Clones    Screenings    XML files    Diffraction Images    Progress    Homolog Search    Clustering    Statistics    News    Help    Log In

Dataset

Protein Target Csgid Id
IDP00044  
Experiment Date
Jul 08, 2010  
Staff
Przemek Porebski  
Lab
University of Virginia  
Beamline
19BM  
Sca Filename
IDP00044_Antib1_1.sca  
Sca Uploaded
 
Wavelength
0.979  
Wavelength Type
peak  
Diffraction Resolution
2.50  
a
77.257  
b
110.593  
c
137.062  
alpha
90.00  
beta
98.69  
gamma
90.00  
z
 
Matthew Coeff
 
Spacegroup
P21  
Sca Number Reflns Obs
95385  
Sca Rmerge I Obs
0.157  
Sca Chi Squared
 
Sca Redundancy
2.0  
Sca Shell Rmerge I Obs
0.000  
Sca Shell Chi Squared
 
Sca Shell Redundancy
1.9  
Sca Average I
1311.7  
Sca Average I Sigma
108.2  
Sca Shell I
86.0  
Sca Shell I Sigma
95.9  
Data Collection Program
HKL3000  
Data Scaling Program
HKL3000  
Intensity Integration Program
HKL3000  
Inserted
Jul 09, 2010  
(default) 9 queries took 14 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 "Dataset"."id" AS "Dataset__id", "Dataset"."target_id" AS "Dataset__target_id", "Dataset"."crystal_harvest_id" AS "Dataset__crystal_harvest_id", "Dataset"."structure_solution_id" AS "Dataset__structure_solution_id", "Dataset"."experiment_date" AS "Dataset__experiment_date", "Dataset"."staff_id" AS "Dataset__staff_id", "Dataset"."other_people" AS "Dataset__other_people", "Dataset"."lab_id" AS "Dataset__lab_id", "Dataset"."detector_id" AS "Dataset__detector_id", "Dataset"."beamline_id" AS "Dataset__beamline_id", "Dataset"."sca_filename" AS "Dataset__sca_filename", "Dataset"."sca_uploaded" AS "Dataset__sca_uploaded", "Dataset"."wavelength" AS "Dataset__wavelength", "Dataset"."wavelength_type" AS "Dataset__wavelength_type", "Dataset"."diffraction_resolution" AS "Dataset__diffraction_resolution", "Dataset"."experiment_temperature" AS "Dataset__experiment_temperature", "Dataset"."a" AS "Dataset__a", "Dataset"."b" AS "Dataset__b", "Dataset"."c" AS "Dataset__c", "Dataset"."alpha" AS "Dataset__alpha", "Dataset"."beta" AS "Dataset__beta", "Dataset"."gamma" AS "Dataset__gamma", "Dataset"."z" AS "Dataset__z", "Dataset"."matthew_coeff" AS "Dataset__matthew_coeff", "Dataset"."spacegroup" AS "Dataset__spacegroup", "Dataset"."sca_number_reflns_obs" AS "Dataset__sca_number_reflns_obs", "Dataset"."sca_rmerge_i_obs" AS "Dataset__sca_rmerge_i_obs", "Dataset"."sca_chi_squared" AS "Dataset__sca_chi_squared", "Dataset"."sca_redundancy" AS "Dataset__sca_redundancy", "Dataset"."sca_shell_rmerge_i_obs" AS "Dataset__sca_shell_rmerge_i_obs", "Dataset"."sca_shell_chi_squared" AS "Dataset__sca_shell_chi_squared", "Dataset"."sca_shell_redundancy" AS "Dataset__sca_shell_redundancy", "Dataset"."sca_average_i" AS "Dataset__sca_average_i", "Dataset"."sca_average_i_sigma" AS "Dataset__sca_average_i_sigma", "Dataset"."sca_shell_i" AS "Dataset__sca_shell_i", "Dataset"."sca_shell_i_sigma" AS "Dataset__sca_shell_i_sigma", "Dataset"."data_collection_program_id" AS "Dataset__data_collection_program_id", "Dataset"."data_collection_programs_other" AS "Dataset__data_collection_programs_other", "Dataset"."data_scaling_program_id" AS "Dataset__data_scaling_program_id", "Dataset"."data_scaling_programs_other" AS "Dataset__data_scaling_programs_other", "Dataset"."intensity_integration_program_id" AS "Dataset__intensity_integration_program_id", "Dataset"."intensity_integration_programs_other" AS "Dataset__intensity_integration_programs_other", "Dataset"."shipped_to_lab_id" AS "Dataset__shipped_to_lab_id", "Dataset"."shipped_date" AS "Dataset__shipped_date", "Dataset"."inserted" AS "Dataset__inserted", "Dataset"."ins_user_id" AS "Dataset__ins_user_id", "Dataset"."update" AS "Dataset__update", "Dataset"."upd_user_id" AS "Dataset__upd_user_id", "Dataset"."sca_shell_res_low" AS "Dataset__sca_shell_res_low", "Dataset"."sca_shell_res_high" AS "Dataset__sca_shell_res_high", "Dataset"."sca_number_reflns_all" AS "Dataset__sca_number_reflns_all", "Dataset"."local_protein_target_id" AS "Dataset__local_protein_target_id", "Dataset"."local_dataset_id" AS "Dataset__local_dataset_id", "Dataset"."local_crystal_harvest_id" AS "Dataset__local_crystal_harvest_id", "Dataset"."dataset_suffix" AS "Dataset__dataset_suffix", "Dataset"."present_in_lims" AS "Dataset__present_in_lims", "CrystalHarvest"."id" AS "CrystalHarvest__id", "CrystalHarvest"."target_id" AS "CrystalHarvest__target_id", "CrystalHarvest"."crystal_harvest_suffix" AS "CrystalHarvest__crystal_harvest_suffix", "CrystalHarvest"."crystallization_drop_id" AS "CrystalHarvest__crystallization_drop_id", "CrystalHarvest"."local_crystallization_drop_id" AS "CrystalHarvest__local_crystallization_drop_id", "CrystalHarvest"."local_protein_target_id" AS "CrystalHarvest__local_protein_target_id", "CrystalHarvest"."local_crystal_harvest_id" AS "CrystalHarvest__local_crystal_harvest_id", "CrystalHarvest"."experiment_date" AS "CrystalHarvest__experiment_date", "CrystalHarvest"."staff_id" AS "CrystalHarvest__staff_id", "CrystalHarvest"."other_people" AS "CrystalHarvest__other_people", "CrystalHarvest"."lab_id" AS "CrystalHarvest__lab_id", "CrystalHarvest"."protocol_id" AS "CrystalHarvest__protocol_id", "CrystalHarvest"."cryo_solution" AS "CrystalHarvest__cryo_solution", "CrystalHarvest"."soaking_solution" AS "CrystalHarvest__soaking_solution", "CrystalHarvest"."ligand" AS "CrystalHarvest__ligand", "CrystalHarvest"."diffraction_limit" AS "CrystalHarvest__diffraction_limit", "CrystalHarvest"."crystal_quality" AS "CrystalHarvest__crystal_quality", "CrystalHarvest"."shipped_to_lab_id" AS "CrystalHarvest__shipped_to_lab_id", "CrystalHarvest"."shipped_date" AS "CrystalHarvest__shipped_date", "CrystalHarvest"."inserted" AS "CrystalHarvest__inserted", "CrystalHarvest"."ins_user_id" AS "CrystalHarvest__ins_user_id", "CrystalHarvest"."update" AS "CrystalHarvest__update", "CrystalHarvest"."upd_user_id" AS "CrystalHarvest__upd_user_id", "CrystalHarvest"."final_pdb_id" AS "CrystalHarvest__final_pdb_id", "CrystalHarvest"."present_in_lims" AS "CrystalHarvest__present_in_lims", "CrystalHarvest"."lims_date" AS "CrystalHarvest__lims_date", "CrystalHarvest"."dummy" AS "CrystalHarvest__dummy", "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", "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", "Detector"."id" AS "Detector__id", "Detector"."detector_name" AS "Detector__detector_name", "Detector"."detector_type" AS "Detector__detector_type", "Detector"."beamline_id" AS "Detector__beamline_id", "Detector"."radiation_type" AS "Detector__radiation_type", "Detector"."start_date" AS "Detector__start_date", "Detector"."end_date" AS "Detector__end_date", "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", "DataCollectionProgram"."id" AS "DataCollectionProgram__id", "DataCollectionProgram"."short" AS "DataCollectionProgram__short", "DataCollectionProgram"."version" AS "DataCollectionProgram__version", "DataCollectionProgram"."data_collection" AS "DataCollectionProgram__data_collection", "DataCollectionProgram"."data_scaling" AS "DataCollectionProgram__data_scaling", "DataCollectionProgram"."intensity_integration" AS "DataCollectionProgram__intensity_integration", "DataCollectionProgram"."phasing" AS "DataCollectionProgram__phasing", "DataCollectionProgram"."sites_location" AS "DataCollectionProgram__sites_location", "DataCollectionProgram"."model_building" AS "DataCollectionProgram__model_building", "DataCollectionProgram"."refinement" AS "DataCollectionProgram__refinement", "DataCollectionProgram"."authors" AS "DataCollectionProgram__authors", "DataCollectionProgram"."current_use" AS "DataCollectionProgram__current_use", "DataScalingProgram"."id" AS "DataScalingProgram__id", "DataScalingProgram"."short" AS "DataScalingProgram__short", "DataScalingProgram"."version" AS "DataScalingProgram__version", "DataScalingProgram"."data_collection" AS "DataScalingProgram__data_collection", "DataScalingProgram"."data_scaling" AS "DataScalingProgram__data_scaling", "DataScalingProgram"."intensity_integration" AS "DataScalingProgram__intensity_integration", "DataScalingProgram"."phasing" AS "DataScalingProgram__phasing", "DataScalingProgram"."sites_location" AS "DataScalingProgram__sites_location", "DataScalingProgram"."model_building" AS "DataScalingProgram__model_building", "DataScalingProgram"."refinement" AS "DataScalingProgram__refinement", "DataScalingProgram"."authors" AS "DataScalingProgram__authors", "DataScalingProgram"."current_use" AS "DataScalingProgram__current_use", "IntensityIntegrationProgram"."id" AS "IntensityIntegrationProgram__id", "IntensityIntegrationProgram"."short" AS "IntensityIntegrationProgram__short", "IntensityIntegrationProgram"."version" AS "IntensityIntegrationProgram__version", "IntensityIntegrationProgram"."data_collection" AS "IntensityIntegrationProgram__data_collection", "IntensityIntegrationProgram"."data_scaling" AS "IntensityIntegrationProgram__data_scaling", "IntensityIntegrationProgram"."intensity_integration" AS "IntensityIntegrationProgram__intensity_integration", "IntensityIntegrationProgram"."phasing" AS "IntensityIntegrationProgram__phasing", "IntensityIntegrationProgram"."sites_location" AS "IntensityIntegrationProgram__sites_location", "IntensityIntegrationProgram"."model_building" AS "IntensityIntegrationProgram__model_building", "IntensityIntegrationProgram"."refinement" AS "IntensityIntegrationProgram__refinement", "IntensityIntegrationProgram"."authors" AS "IntensityIntegrationProgram__authors", "IntensityIntegrationProgram"."current_use" AS "IntensityIntegrationProgram__current_use" FROM "dataset" AS "Dataset" LEFT JOIN "crystal_harvest" AS "CrystalHarvest" ON ("Dataset"."crystal_harvest_id" = "CrystalHarvest"."id") LEFT JOIN "lab" AS "Lab" ON ("Dataset"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("Dataset"."staff_id" = "Staff"."id") LEFT JOIN "structure_solution" AS "StructureSolution" ON ("Dataset"."structure_solution_id" = "StructureSolution"."id") LEFT JOIN "detector" AS "Detector" ON ("Dataset"."detector_id" = "Detector"."id") LEFT JOIN "protein_target" AS "Target" ON ("Dataset"."target_id" = "Target"."target_id") LEFT JOIN "software" AS "DataCollectionProgram" ON ("Dataset"."data_collection_program_id" = "DataCollectionProgram"."id") LEFT JOIN "software" AS "DataScalingProgram" ON ("Dataset"."data_scaling_program_id" = "DataScalingProgram"."id") LEFT JOIN "software" AS "IntensityIntegrationProgram" ON ("Dataset"."intensity_integration_program_id" = "IntensityIntegrationProgram"."id") WHERE "Dataset"."id" = '618' LIMIT 10110
3SELECT "Dataset"."id" AS "Dataset__id", "Dataset"."target_id" AS "Dataset__target_id", "Dataset"."crystal_harvest_id" AS "Dataset__crystal_harvest_id", "Dataset"."structure_solution_id" AS "Dataset__structure_solution_id", "Dataset"."experiment_date" AS "Dataset__experiment_date", "Dataset"."staff_id" AS "Dataset__staff_id", "Dataset"."other_people" AS "Dataset__other_people", "Dataset"."lab_id" AS "Dataset__lab_id", "Dataset"."detector_id" AS "Dataset__detector_id", "Dataset"."beamline_id" AS "Dataset__beamline_id", "Dataset"."sca_filename" AS "Dataset__sca_filename", "Dataset"."sca_uploaded" AS "Dataset__sca_uploaded", "Dataset"."wavelength" AS "Dataset__wavelength", "Dataset"."wavelength_type" AS "Dataset__wavelength_type", "Dataset"."diffraction_resolution" AS "Dataset__diffraction_resolution", "Dataset"."experiment_temperature" AS "Dataset__experiment_temperature", "Dataset"."a" AS "Dataset__a", "Dataset"."b" AS "Dataset__b", "Dataset"."c" AS "Dataset__c", "Dataset"."alpha" AS "Dataset__alpha", "Dataset"."beta" AS "Dataset__beta", "Dataset"."gamma" AS "Dataset__gamma", "Dataset"."z" AS "Dataset__z", "Dataset"."matthew_coeff" AS "Dataset__matthew_coeff", "Dataset"."spacegroup" AS "Dataset__spacegroup", "Dataset"."sca_number_reflns_obs" AS "Dataset__sca_number_reflns_obs", "Dataset"."sca_rmerge_i_obs" AS "Dataset__sca_rmerge_i_obs", "Dataset"."sca_chi_squared" AS "Dataset__sca_chi_squared", "Dataset"."sca_redundancy" AS "Dataset__sca_redundancy", "Dataset"."sca_shell_rmerge_i_obs" AS "Dataset__sca_shell_rmerge_i_obs", "Dataset"."sca_shell_chi_squared" AS "Dataset__sca_shell_chi_squared", "Dataset"."sca_shell_redundancy" AS "Dataset__sca_shell_redundancy", "Dataset"."sca_average_i" AS "Dataset__sca_average_i", "Dataset"."sca_average_i_sigma" AS "Dataset__sca_average_i_sigma", "Dataset"."sca_shell_i" AS "Dataset__sca_shell_i", "Dataset"."sca_shell_i_sigma" AS "Dataset__sca_shell_i_sigma", "Dataset"."data_collection_program_id" AS "Dataset__data_collection_program_id", "Dataset"."data_collection_programs_other" AS "Dataset__data_collection_programs_other", "Dataset"."data_scaling_program_id" AS "Dataset__data_scaling_program_id", "Dataset"."data_scaling_programs_other" AS "Dataset__data_scaling_programs_other", "Dataset"."intensity_integration_program_id" AS "Dataset__intensity_integration_program_id", "Dataset"."intensity_integration_programs_other" AS "Dataset__intensity_integration_programs_other", "Dataset"."shipped_to_lab_id" AS "Dataset__shipped_to_lab_id", "Dataset"."shipped_date" AS "Dataset__shipped_date", "Dataset"."inserted" AS "Dataset__inserted", "Dataset"."ins_user_id" AS "Dataset__ins_user_id", "Dataset"."update" AS "Dataset__update", "Dataset"."upd_user_id" AS "Dataset__upd_user_id", "Dataset"."sca_shell_res_low" AS "Dataset__sca_shell_res_low", "Dataset"."sca_shell_res_high" AS "Dataset__sca_shell_res_high", "Dataset"."sca_number_reflns_all" AS "Dataset__sca_number_reflns_all", "Dataset"."local_protein_target_id" AS "Dataset__local_protein_target_id", "Dataset"."local_dataset_id" AS "Dataset__local_dataset_id", "Dataset"."local_crystal_harvest_id" AS "Dataset__local_crystal_harvest_id", "Dataset"."dataset_suffix" AS "Dataset__dataset_suffix", "Dataset"."present_in_lims" AS "Dataset__present_in_lims", "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", "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", "DataCollectionProgram"."id" AS "DataCollectionProgram__id", "DataCollectionProgram"."short" AS "DataCollectionProgram__short", "DataCollectionProgram"."version" AS "DataCollectionProgram__version", "DataCollectionProgram"."data_collection" AS "DataCollectionProgram__data_collection", "DataCollectionProgram"."data_scaling" AS "DataCollectionProgram__data_scaling", "DataCollectionProgram"."intensity_integration" AS "DataCollectionProgram__intensity_integration", "DataCollectionProgram"."phasing" AS "DataCollectionProgram__phasing", "DataCollectionProgram"."sites_location" AS "DataCollectionProgram__sites_location", "DataCollectionProgram"."model_building" AS "DataCollectionProgram__model_building", "DataCollectionProgram"."refinement" AS "DataCollectionProgram__refinement", "DataCollectionProgram"."authors" AS "DataCollectionProgram__authors", "DataCollectionProgram"."current_use" AS "DataCollectionProgram__current_use", "DataScalingProgram"."id" AS "DataScalingProgram__id", "DataScalingProgram"."short" AS "DataScalingProgram__short", "DataScalingProgram"."version" AS "DataScalingProgram__version", "DataScalingProgram"."data_collection" AS "DataScalingProgram__data_collection", "DataScalingProgram"."data_scaling" AS "DataScalingProgram__data_scaling", "DataScalingProgram"."intensity_integration" AS "DataScalingProgram__intensity_integration", "DataScalingProgram"."phasing" AS "DataScalingProgram__phasing", "DataScalingProgram"."sites_location" AS "DataScalingProgram__sites_location", "DataScalingProgram"."model_building" AS "DataScalingProgram__model_building", "DataScalingProgram"."refinement" AS "DataScalingProgram__refinement", "DataScalingProgram"."authors" AS "DataScalingProgram__authors", "DataScalingProgram"."current_use" AS "DataScalingProgram__current_use", "IntensityIntegrationProgram"."id" AS "IntensityIntegrationProgram__id", "IntensityIntegrationProgram"."short" AS "IntensityIntegrationProgram__short", "IntensityIntegrationProgram"."version" AS "IntensityIntegrationProgram__version", "IntensityIntegrationProgram"."data_collection" AS "IntensityIntegrationProgram__data_collection", "IntensityIntegrationProgram"."data_scaling" AS "IntensityIntegrationProgram__data_scaling", "IntensityIntegrationProgram"."intensity_integration" AS "IntensityIntegrationProgram__intensity_integration", "IntensityIntegrationProgram"."phasing" AS "IntensityIntegrationProgram__phasing", "IntensityIntegrationProgram"."sites_location" AS "IntensityIntegrationProgram__sites_location", "IntensityIntegrationProgram"."model_building" AS "IntensityIntegrationProgram__model_building", "IntensityIntegrationProgram"."refinement" AS "IntensityIntegrationProgram__refinement", "IntensityIntegrationProgram"."authors" AS "IntensityIntegrationProgram__authors", "IntensityIntegrationProgram"."current_use" AS "IntensityIntegrationProgram__current_use" FROM "dataset" AS "Dataset" LEFT JOIN "staff" AS "Staff" ON ("Dataset"."staff_id" = "Staff"."id") LEFT JOIN "structure_solution" AS "StructureSolution" ON ("Dataset"."structure_solution_id" = "StructureSolution"."id") LEFT JOIN "software" AS "DataCollectionProgram" ON ("Dataset"."data_collection_program_id" = "DataCollectionProgram"."id") LEFT JOIN "software" AS "DataScalingProgram" ON ("Dataset"."data_scaling_program_id" = "DataScalingProgram"."id") LEFT JOIN "software" AS "IntensityIntegrationProgram" ON ("Dataset"."intensity_integration_program_id" = "IntensityIntegrationProgram"."id") WHERE "Dataset"."id" = '618' LIMIT 1013
4SELECT "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" = '123' 010
5SELECT "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" = 'UVA' 010
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" FROM "deposit" AS "Deposit" WHERE "Deposit"."staff_id" = ('123') 000
7SELECT "DataCollectionProgram"."id" AS "DataCollectionProgram__id", "DataCollectionProgram"."short" AS "DataCollectionProgram__short", "DataCollectionProgram"."version" AS "DataCollectionProgram__version", "DataCollectionProgram"."data_collection" AS "DataCollectionProgram__data_collection", "DataCollectionProgram"."data_scaling" AS "DataCollectionProgram__data_scaling", "DataCollectionProgram"."intensity_integration" AS "DataCollectionProgram__intensity_integration", "DataCollectionProgram"."phasing" AS "DataCollectionProgram__phasing", "DataCollectionProgram"."sites_location" AS "DataCollectionProgram__sites_location", "DataCollectionProgram"."model_building" AS "DataCollectionProgram__model_building", "DataCollectionProgram"."refinement" AS "DataCollectionProgram__refinement", "DataCollectionProgram"."authors" AS "DataCollectionProgram__authors", "DataCollectionProgram"."current_use" AS "DataCollectionProgram__current_use" FROM "software" AS "DataCollectionProgram" WHERE "DataCollectionProgram"."id" = '50' 010
8SELECT "DataScalingProgram"."id" AS "DataScalingProgram__id", "DataScalingProgram"."short" AS "DataScalingProgram__short", "DataScalingProgram"."version" AS "DataScalingProgram__version", "DataScalingProgram"."data_collection" AS "DataScalingProgram__data_collection", "DataScalingProgram"."data_scaling" AS "DataScalingProgram__data_scaling", "DataScalingProgram"."intensity_integration" AS "DataScalingProgram__intensity_integration", "DataScalingProgram"."phasing" AS "DataScalingProgram__phasing", "DataScalingProgram"."sites_location" AS "DataScalingProgram__sites_location", "DataScalingProgram"."model_building" AS "DataScalingProgram__model_building", "DataScalingProgram"."refinement" AS "DataScalingProgram__refinement", "DataScalingProgram"."authors" AS "DataScalingProgram__authors", "DataScalingProgram"."current_use" AS "DataScalingProgram__current_use" FROM "software" AS "DataScalingProgram" WHERE "DataScalingProgram"."id" = '50' 010
9SELECT "IntensityIntegrationProgram"."id" AS "IntensityIntegrationProgram__id", "IntensityIntegrationProgram"."short" AS "IntensityIntegrationProgram__short", "IntensityIntegrationProgram"."version" AS "IntensityIntegrationProgram__version", "IntensityIntegrationProgram"."data_collection" AS "IntensityIntegrationProgram__data_collection", "IntensityIntegrationProgram"."data_scaling" AS "IntensityIntegrationProgram__data_scaling", "IntensityIntegrationProgram"."intensity_integration" AS "IntensityIntegrationProgram__intensity_integration", "IntensityIntegrationProgram"."phasing" AS "IntensityIntegrationProgram__phasing", "IntensityIntegrationProgram"."sites_location" AS "IntensityIntegrationProgram__sites_location", "IntensityIntegrationProgram"."model_building" AS "IntensityIntegrationProgram__model_building", "IntensityIntegrationProgram"."refinement" AS "IntensityIntegrationProgram__refinement", "IntensityIntegrationProgram"."authors" AS "IntensityIntegrationProgram__authors", "IntensityIntegrationProgram"."current_use" AS "IntensityIntegrationProgram__current_use" FROM "software" AS "IntensityIntegrationProgram" WHERE "IntensityIntegrationProgram"."id" = '50' 010