X-ray Structures

Filter Targets:

Show Filters

Page 1 of 14, showing 20 records  out of 273 total, starting on record 1 structures.
Click on the title of a structure below to see more information about that structure.

Target 012132

Title: Crystal structure of NADP-dependent 2-hydroxyacid dehydrogenase from Sinorhizobium meliloti in complex with 2''-phospho-ADP-ribose
Authors: I.G.Shabalin,O.A.Gasiorowska,K.B.Handing,J.Bonanno,J.Kutner,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5J23 (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: [(2r,3r,4r,5r)-5-(6-amino-9h-purin-9-yl)-3-hydroxy-4-(p hosphonooxy)tetrahydrofuran-2-yl]methyl [(2r,3s,4r,5r)-3,4,5-trihydroxytetrahydrofuran-2-yl]methyl dihydrogen diphosphate
Other ligands: , acetate ion
R: 14.6%
Rfree: 16.9%
Resolution: 2.3Å
Deposited: 2016-03-29
Released:

Target 491003

Title: Crystal structure of Equine Serum Albumin in the presence of 30 mM zinc at pH 7.4.
Authors: K.B.Handing,I.G.Shabalin,D.R.Cooper,K.Szlachta,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5IJE (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: zinc ion
Other ligands: sulfate ion
R: 19.5%
Rfree: 25.5%
Resolution: 2.4Å
Deposited: 2016-03-01
Released:

Target 030805

Title: Crystal structure of SAM-dependent methyltransferase from Thiobacillus denitrificans in complex with S-Adenosyl-L-homocysteine
Authors: C.Larowe,I.G.Shabalin,J.Kutner,K.B.Handing,M.Stead,B.S.Hillerich,M.Ahmed,R.Seidel,J.Bonanno,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5EPE (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: s-adenosyl-l-homocysteine
Other ligands:
R: 1670%
Rfree: 16.7%
Resolution: 1.9Å
Deposited: 2015-11-11
Released:

Target 491003

Title: Horse Serum Albumin (ESA) in complex with Cetirizine
Authors: K.B.Handing,I.G.Shabalin,K.A.Majorek,M.Chruszcz,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5DQF (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 18.1%
Rfree: 24.1%
Resolution: 2.15Å
Deposited: 2015-09-14
Released:

Target 028317

Title: Crystal Structure of a Putative enoyl-CoA hydratase/isomerase family protein from Hyphomonas neptunium
Authors: K.Szlachta,D.R.Cooper,H.C.Chapman,M.T.Cymbrowski,M.Stead,B.S.Hillerich,M.Ahmed,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,J.Hammonds,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5C9G (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 19.8%
Rfree: 23.2%
Resolution: 2.1Å
Deposited: 2015-06-26
Released:

Target 014667

Title: Crystal structure of NADP-dependent dehydrogenase from Rhodobacter sphaeroides
Authors: M.Kowiel,O.A.Gasiorowska,I.G.Shabalin,K.B.Handing,P.J.Porebski,M.Cymborowski,N.F.Al Obaidi,J.Bonanno,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5C5I (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 19.7%
Rfree: 25.2%
Resolution: 2.2Å
Deposited: 2015-06-19
Released: 2015-07-01

Target 030807

Title: Crystal structure of RNA methyltransferase from Salinibacter ruber in complex with S-Adenosyl-L-homocysteine
Authors: K.B.Handing,C.Larowe,I.G.Shabalin,M.Stead,B.S.Hillerich,M.Ahmed,J.Bonanno,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5BXY (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: s-adenosyl-l-homocysteine
Other ligands: , magnesium ion
R: 15%
Rfree: 18.8%
Resolution: 1.75Å
Deposited: 2015-06-09
Released:

Target 014307

Title: Probable 2-hydroxyacid dehydrogenase from Rhizobium etli CFN 42 in complex with NADP, HEPES and L(+)-tartaric acid
Authors: K.M.Langner,I.G.Shabalin,K.B.Handing,O.A.Gasiorowska,M.Stead,B.S.Hillerich,S.Chowdhury,J.Hammonds,M.D.Zimmerman,N.Al Obaidi,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5BQF (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 13.91%
Rfree: 16.5%
Resolution: 1.45Å
Deposited: 2015-05-29
Released:

Target 030801

Title: Crystal structure of SAM-dependent methyltransferase from Bacteroides fragilis in complex with S-Adenosyl-L-homocysteine
Authors: O.A.Gasiorowska,I.G.Shabalin,K.B.Handing,M.T.Cymborowski,D.V.Mason,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5BP9 (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: s-adenosyl-l-homocysteine
Other ligands: 1-(2-methoxy-ethoxy)-2-{2-[2-(2-methoxy-ethoxy]-ethoxy}-ethane, pentaethylene glycol
R: 13.4%
Rfree: 17.9%
Resolution: 1.5Å
Deposited: 2015-05-27
Released: 2015-06-10

Target 030788

Title: Crystal structure of SAM-dependent methyltransferase from Geobacter sulfurreducens in complex with S-Adenosyl-L-homocysteine
Authors: J.Kutner,I.G.Shabalin,D.V.Mason,K.B.Handing,O.A.Gasiorowska,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 5BP7 (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: s-adenosyl-l-homocysteine
Other ligands:
R: 18.6%
Rfree: 22.3%
Resolution: 2.1Å
Deposited: 2015-05-27
Released:

Target 011884

Title: Crystal structure of NADP-dependent dehydrogenase from Sinorhizobium meliloti in complex with NADPH and oxalate
Authors: P.Sroka,O.A.Gasiorowska,K.B.Handing,I.G.Shabalin,P.J.Porebski,B.S.Hillerich,J.Bonanno,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4Z0P (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 1340%
Rfree: 15%
Resolution: 1.7Å
Deposited: 2015-03-26
Released:

Target 022189

Title: Crystal structure of trimethylamine methyltransferase from Sinorhizobium meliloti in complex with unknown ligand
Authors: I.G.Shabalin,P.J.Porebski,O.A.Gasiorowska,K.B.Handing,E.Niedzialkowska,M.T.Cymborowski,D.R.Cooper,M.Stead,J.Hammonds,M.Ahmed,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4YYC (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 13.9%
Rfree: 16.5%
Resolution: 1.56Å
Deposited: 2015-03-23
Released:

Target 014260

Title: Crystal structure of aldo-keto reductase from Polaromonas sp. JS666
Authors: O.A.Gasiorowska,K.B.Handing,I.G.Shabalin,P.Sroka,B.S.Hillerich,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4XK2 (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: ,
R: 16.1%
Rfree: 18.5%
Resolution: 1.9Å
Deposited: 2015-01-09
Released:

Target 014307

Title: Probable 2-hydroxyacid dehydrogenase from Rhizobium etli CFN 42 in complex with NADPH
Authors: K.M.Langner,I.G.Shabalin,K.B.Handing,O.A.Gasiorowska,M.Stead,B.S.Hillerich,S.Chowdhury,J.Hammonds,M.D.Zimmerman,N.Al Obadi,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4XCV (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 15.1%
Rfree: 17.8%
Resolution: 1.4Å
Deposited: 2014-12-18
Released: 2014-12-31

Target 012048

Title: Crystal structure of aldo-keto reductase from Sinorhizobium meliloti 1021
Authors: O.A.Gasiorowska,K.B.Handing,I.G.Shabalin,J.Bonanno,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4XAP (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 16%
Rfree: 22.5%
Resolution: 2.21Å
Deposited: 2014-12-15
Released: 2014-12-31

Target 015257

Title: Crystal structure of D-isomer specific 2-hydroxyacid dehydrogenase from Xanthobacter autotrophicus Py2
Authors: K.B.Handing,O.A.Gasiorowska,I.G.Shabalin,M.T.Cymborowski,J.Bonanno,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4XA8 (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 16.3%
Rfree: 20.9%
Resolution: 1.9Å
Deposited: 2014-12-12
Released: 2015-01-14

Target 022550

Title: Crystal structure of cyclohexadienyl dehydrogenase from Sinorhizobium meliloti in complex with NADP and tyrosine at 1.4 A resolution
Authors: I.G.Shabalin,D.R.Cooper,J.Hou,M.D.Zimmerman,M.Stead,B.S.Hillerich,M.Ahmed,J.Hammonds,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4WJI (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: NADP nicotinamide-adenine-dinucleotide phosphate
Other ligands: , magnesium ion
R: 11.5%
Rfree: 15.9%
Resolution: 1.4Å
Deposited: 2014-09-30
Released:

Target 013574

Title: Crystal structure of aldo/keto reductase from Klebsiella pneumoniae in complex with NADP and acetate at 1.8 A resolution
Authors: P.Bacal,I.G.Shabalin,D.R.Cooper,B.S.Hillerich,M.D.Zimmerman,S.Chowdhury,J.Hammonds,N.Al Obaidi,A.Gizzi,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4WGH (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: NADP nicotinamide-adenine-dinucleotide phosphate
Other ligands: acetate ion
R: 1450%
Rfree: 18.5%
Resolution: 1.8Å
Deposited: 2014-09-18
Released:

Target 011884

Title: Crystal structure of NADP-dependent dehydrogenase from Sinorhizobium meliloti in complex with NADP and sulfate
Authors: P.Sroka,O.A.Gasiorowska,K.B.Handing,I.G.Shabalin,T.Osinski,B.S.Hillerich,J.Bonanno,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4WEQ (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: NADP nicotinamide-adenine-dinucleotide phosphate
Other ligands: , di(hydroxyethyl)ether, glycerol, sulfate ion
R: 1540%
Rfree: 19.6%
Resolution: 2Å
Deposited: 2014-09-10
Released:

Target 021011

Title: Crystal structure of ABC transporter substrate-binding protein from Sinorhizobium meliloti
Authors: I.G.Shabalin,Z.Otwinowski,P.Bacal,M.T.Cymborowski,K.B.Handing,M.Stead,J.Hammonds,M.Ahmed,J.Bonanno,R.Seidel,S.C.Almo,W.Minor,New York Structural Genomics Research Consortium (Nysgrc)
PDB 4WED (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: , formic acid, glycerol
R: 1650%
Rfree: 22.8%
Resolution: 2.35Å
Deposited: 2014-09-09
Released:
previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |
(default) 10 queries took 3557 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "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", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1006
2SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "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", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1001
3SELECT d.id as deposit_id, d.pdb_id, l.code as ligand_code, l.name, dl.ligand_type FROM deposit AS d JOIN deposit_ligand AS dl ON d.id = dl.deposit_id JOIN ligand AS l ON dl.ligand_code = l.code WHERE dl.ligand_type = 'biological' ORDER BY l.name75755
4SELECT d.id as deposit_id, d.pdb_id, l.code as ligand_code, l.name, dl.ligand_type FROM deposit AS d JOIN deposit_ligand AS dl ON d.id = dl.deposit_id JOIN ligands.ligand AS l ON dl.ligand_code = l.code WHERE dl.ligand_type IS NULL OR (dl.ligand_type != 'biological' AND dl.ligand_type != 'modified residue') ORDER BY l.name26526520
5SELECT DISTINCT "Deposit"."authors" AS "Deposit__authors" FROM "deposit" AS "Deposit" WHERE 1 = 1 ORDER BY "authors" asc 1321322
6SELECT DISTINCT "Target"."project" AS "Target__project" FROM "protein_target" AS "Target" WHERE 1 = 1 ORDER BY "project" asc 7979715
7SELECT DISTINCT TaxonomyName.name_text AS TaxonomyName__species, TaxonomyName.tax_id AS TaxonomyName__tax_id FROM names AS TaxonomyName RIGHT JOIN protein_target AS Target ON (TaxonomyName.tax_id = Target.species_taxon_id AND TaxonomyName.name_class = 'scientific name') RIGHT JOIN deposit AS Deposit ON (Target.target_id=Deposit.target_id)61611303
8SELECT COUNT(*) AS "count" 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 obsolete IS FALSE 11782
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", "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", "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", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id", "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."local_target_id" AS "Target__local_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"."study_id" AS "Target__study_id", "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"."ec" AS "Target__ec", "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"."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"."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"."type" AS "Target__type", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."oligomeric_protein" AS "Target__oligomeric_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", "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 obsolete IS FALSE ORDER BY case when "Target"."project"='Community Requests' then 1 when "Target"."project"='Community Request' then 2 else 3 end ASC, "Deposit"."deposition_date" desc LIMIT 202020721
10SELECT "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" IN ('288', '289', '286', '287', '282', '285', '283', '281', '284', '280', '279', '278', '277', '274', '275', '276', '273', '272', '271', '270') AND "DepositLigand"."ligand_code" = "Ligand"."code") 37372
(labdb) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)