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

X-ray Structures

Important note for CSGID staff! Before depositing your structure, make sure it follows the guidelines here " PDB deposit guidelines" and here "Crystal structure quality metrics for PDB deposition."

Filter Targets:

Show Filters

Page 10 of 30, showing 20 records  out of 584 total, starting on record 181 structures.
Click on the title of a structure below to see more information about that structure.

Target IDP90785          community request

Title: 2.1 Angstrom resolution crystal structure of an orotate phosphoribosyltransferase (pyrE) from Vibrio cholerae O1 biovar eltor str. N16961
Authors: A.S.Halavaty,G.Minasov,L.Shuvalova,I.Dubrovska,J.Winsor,K.Kwon,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3N2L (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: chloride ion
R: 22.4%
Rfree: 26.9%
Resolution: 2.1Å
Deposited: 2010-05-18
Released: 2010-06-02

Target IDP90611          community request

Title: 2.25 Angstrom resolution crystal structure of a thymidylate kinase (tmk) from Vibrio cholerae O1 biovar eltor str. N16961 in complex with thymidine
Authors: A.S.Halavaty,G.Minasov,L.Shuvalova,J.Winsor,I.Dubrovska,S.Peterson,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3N2I (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: thymidine
Other ligands: chloride ion
R: 20.8%
Rfree: 26.1%
Resolution: 2.25Å
Deposited: 2010-05-18
Released: 2010-06-02

Target IDP90886          community request

Title: 1.8 Angstrom Resolution Crystal Structure of Diaminopimelate Decarboxylase (lysA) from Vibrio cholerae.
Authors: G.Minasov,A.Halavaty,L.Shuvalova,I.Dubrovska,J.Winsor,L.Papazisi,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3N2B (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: chloride ion
R: 18.4%
Rfree: 21.9%
Resolution: 1.8Å
Deposited: 2010-05-17
Released: 2010-06-09

Target IDP90784          community request

Title: CRYSTAL STRUCTURE OF BIFUNCTIONAL FOLYLPOLYGLUTAMATE SYNTHASE/DIHYDROFOLATE SYNTHASE COMPLEXED WITH ADP FROM YERSINIA PESTIS C092
Authors: B Nocek,N.Maltseva,L.Papazisi,W.Anderson,A.Joachimiak,Niaid
PDB 3N2A (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: adenosine-5'-diphosphate, magnesium ion
Other ligands: 1,2-ethanediol, glycerol
R: 19%
Rfree: 20.2%
Resolution: 1.9Å
Deposited: 2010-05-17
Released: 2010-06-30

Target IDP90682          community request

Title: Crystal structure of serine hydroxymethyltransferase from Campylobacter jejuni
Authors: S.M.Anderson,Z.Wawrzak,O.Onopriyenko,J.Hasseman,W.F.Anderson,A.Savchenko,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3N0L (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: sulfate ion
R: 16.2%
Rfree: 19.8%
Resolution: 1.8Å
Deposited: 2010-05-14
Released: 2010-05-26

Target IDP90355          community request

Title: 1.25 ANGSTROM CRYSTAL STRUCTURE OF A PUTATIVE PHOSPHATIDYLETHANOLAMINE-BINDING PROTEIN (PEBP) HOMOLOG CT736 FROM CHLAMYDIA TRACHOMATIS D/UW-3/CX
Authors: J.S.Brunzelle,Z.Wawrzak,O.Onopriyenko,A.Savchenko,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3N08 (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: calcium ion, chloride ion
R: 15.3%
Rfree: 17.3%
Resolution: 1.25Å
Deposited: 2010-05-13
Released: 2010-07-14

Target IDP90800          community request

Title: Crystal Structure of Pantoate-Beta-alanine Ligase fromCampylobacter jejuni
Authors: Y.Kim,M.Zhou,L.Papazisi,W.F.Anderson,A.Joachimiak
PDB 3MXT (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: chloride ion, formic acid, glycerol, magnesium ion, sulfate ion
R: 16%
Rfree: 19.9%
Resolution: 1.85Å
Deposited: 2010-05-07
Released: 2010-06-16

Target IDP90797          community request

Title: Crystal Structure of Pantoate-beta-Alanine Ligase from Salmonella typhimurium
Authors: Y.Kim,M.Makowska-Grzyska,N.Maltseva,K.Kwon,W.F.Anderson,A.Joachimiak
PDB 3MUE (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: acetic acid, ethanol, glycerol, sulfate ion
R: 18.1%
Rfree: 22.9%
Resolution: 2.7Å
Deposited: 2010-05-03
Released: 2010-05-26

Target IDP90271          community request

Title: Crystal Structure of Swine Flu Virus NS1 N-Terminal RNA Binding Domain from H1N1 Influenza A/California/07/2009
Authors: J.S.Brunzelle,Z.Wawrzak,T.Skarina,A.Savchenko,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3M8A (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: acetate ion, malonate ion, sodium ion
R: 17.2%
Rfree: 20.4%
Resolution: 2.1Å
Deposited: 2010-03-17
Released: 2010-04-28

Target IDP90922          community request

Title: Crystal Structure of Type I 3-Dehydroquinate Dehydratase (aroD) from Salmonella typhimurium LT2 in CovalentComplex with Dehydroquinate.
Authors: G.Minasov,S.H.Light,L.Shuvalova,L.Papazisi,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3M7W (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: 1,3,4-trihydroxy-5-oxo-cyclohexanecarboxylic acid, glycerol
R: 15.7%
Rfree: 20.6%
Resolution: 1.95Å
Deposited: 2010-03-17
Released: 2010-04-07

Target IDP90564          community request

Title: Crystal structure of transketolase in complex with thiamine diphosphate, ribose-5-phosphate (pyranose form) and magnesium ion
Authors: B.Nocek,M.Makowska-Grzyska,N.Maltseva,W.Anderson,A.Joachimiak,(Csgid) Center For Structural Genomics Of Infectious Diseases
PDB 3M7I (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: ribose-5-phosphate, pyranose form, thiamine diphosphate
Other ligands: 1,2-ethanediol, magnesium ion
R: 17.1%
Rfree: 21.1%
Resolution: 1.75Å
Deposited: 2010-03-16
Released: 2010-04-07
Title: Crystal structure of transketolase in complex with thiamine diphosphate, ribose-5-phosphate and calcium ion
Authors: B.Nocek,M.Makowska-Grzyska,N.Maltseva,A.Joachimiak,W.Anderson,Csgid
PDB 3M6L (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: ribose-5-phosphate
Other ligands: 1,2-ethanediol, calcium ion, glycerol, phosphate ion, thiamine diphosphate
R: 16.2%
Rfree: 20.1%
Resolution: 1.59Å
Deposited: 2010-03-15
Released: 2010-04-28

Target IDP90555          community request

Title: Crystal Structure of Tryptophanyl-tRNA Synthetase from Campylobacter jejuni
Authors: Y.Kim,M.Zhou,J.Hasseman,W.F.Anderson,A.Joachimiak,Csgid
PDB 3M5W (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: glycerol, sulfate ion
R: 18.7%
Rfree: 24.3%
Resolution: 2.32Å
Deposited: 2010-03-14
Released: 2010-03-31

Target IDP90711          community request

Title: Crystal Structure of Dihydrodipicolinate Synthase from Campylobacter jejuni
Authors: Y.Kim,M.Zhou,K.Kwon,W.F.Anderson,A.Joachimiak,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3M5V (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: chloride ion, di(hydroxyethyl)ether, formic acid, sulfate ion
R: 14.7%
Rfree: 18.1%
Resolution: 1.8Å
Deposited: 2010-03-13
Released: 2010-04-28

Target IDP90849          community request

Title: Crystal Structure of Phosphoserine Aminotransferase from Campylobacter jejuni
Authors: Y.Kim,M.Gu,L.Papazisi,W.F.Anderson,A.Joachimiak
PDB 3M5U (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: 2-(n-morpholino)-ethanesulfonic acid, glycerol
R: 17.2%
Rfree: 22%
Resolution: 2.15Å
Deposited: 2010-03-13
Released: 2010-04-07

Target IDP90271          community request

Title: Crystal Structure of Swine Flu Virus NS1 Effector Domain fromH1N1 Influenza A/California/07/2009.
Authors: D.H.Fremont,Y.Y.L.Yu,C.A.Nelson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3M5R (PDBSUM) (Profunc) (GPSS) (MMDB)
R: 20.85%
Rfree: 24.4%
Resolution: 2Å
Deposited: 2010-03-13
Released: 2010-04-07

Target IDP90564          community request

Title: Crystal structure of transketolase in complex with thiamin diphosphate and calcium ion
Authors: B.Nocek,M.Makowska-Grzyska,N.Maltseva,S.Grimshaw,A.Joachimiak,W.Anderson
PDB 3M34 (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: 1,2-ethanediol, calcium ion, glycerol, thiamine diphosphate
R: 15.3%
Rfree: 18.2%
Resolution: 1.65Å
Deposited: 2010-03-08
Released: 2010-04-28

Target IDP90915          community request

Title: Crystal structure of 4-hydroxythreonine-4-phosphate dehydrogenase from Yersinia pestis CO92
Authors: B.Nocek,N.Maltseva,K.Kwon,W.Anderson,A.Joachimiak,Center For Structural Genomics Of Infectious Diseases
PDB 3LXY (PDBSUM) (Profunc) (GPSS) (MMDB)
Complexed with: unknown
Other ligands: sucrose, sulfate ion
R: 19.4%
Rfree: 24.8%
Resolution: 1.7Å
Deposited: 2010-02-25
Released: 2010-03-09

Target IDP90587          community request

Title: 2.00 Angstrom resolution crystal structure of a catalytic subunit of an aspartate carbamoyltransferase (pyrB) from Yersinia pestis CO92
Authors: A.S.Halavaty,G.Minasov,I.Dubrovska,J.Winsor,L.Shuvalova,S.Peterson,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3LXM (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: tetraethylene glycol
R: 18.1%
Rfree: 21.7%
Resolution: 2Å
Deposited: 2010-02-25
Released: 2010-03-16

Target IDP90771          community request

Title: 1.65 Angstrom Resolution Crystal Structure of Type II 3-Dehydroquinate Dehydratase (aroQ) from Yersinia pestis.
Authors: G.Minasov,S.H.Light,L.Shuvalova,I.Dubrovska,J.Winsor,L.Papazisi,W.F.Anderson,Center For Structural Genomics Of Infectious Diseases (Csgid)
PDB 3LWZ (PDBSUM) (Profunc) (GPSS) (MMDB)
Other ligands: 1,2-ethanediol, beta-mercaptoethanol, glycerol
R: 15.1%
Rfree: 18.2%
Resolution: 1.65Å
Deposited: 2010-02-24
Released: 2010-03-09
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
(default) 53 queries took 462 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE 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';0925
2SELECT 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_ligand' 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 position058
3SELECT 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' 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 position0196
4SELECT 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 = 'structure' 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 position0467
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 = 'structure_solution' 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 position0247
6SELECT 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 = 'staff' 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 position0196
7SELECT 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 = 'lab' 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 position076
8SELECT 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 = 'expression' 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 position0327
9SELECT 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 = 'protein_target' 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 position09410
10SELECT 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 = 'protein_pdb_homolog_table' 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 position056
11SELECT 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 = 'tigr_main_roles' 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 position025
12SELECT 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 = 'tigr_sub_roles' 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 position025
13SELECT 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 = 'names' 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 position045
14SELECT 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 = 'stage' 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 position025
15SELECT 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 = 'request_target' 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 position0207
16SELECT 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 = 'request_person' 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 position076
17SELECT 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 = 'target_planning' 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 position0166
18SELECT 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 = 'protein_subtarget' 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 position0156
19SELECT 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 = 'protein_subtarget_assignment' 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 position066
20SELECT 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 = 'clone' 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 position0397
21SELECT 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 = 'center_user' 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
22SELECT 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 = 'mr_clone' 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 position0106
23SELECT 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 = 'purification' 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 position0317
24SELECT 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 = 'protocol' 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 position0106
25SELECT 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 = 'crystallization_drop' 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 position0347
26SELECT 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 = 'crystal_harvest' 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 position0277
27SELECT 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 = 'dataset' 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 position0568
28SELECT 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 = 'detector' 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 position076
29SELECT 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 = 'beamline' 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 position046
30SELECT 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 = 'synchrotron' 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 position066
31SELECT 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 = 'software' 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 position0126
32SELECT 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 = 'hsqc' 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 position0166
33SELECT 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 = 'nmr_structure' 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 position0146
34SELECT 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 = 'nmr_deposit' 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 position0176
35SELECT 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 = 'pdbstructures' 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 position0226
36SELECT 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 = 'pdbchains' 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 position0226
37SELECT 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 = 'vs_assay' 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 position0156
38SELECT 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 = 'library' 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 position055
39SELECT 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 = 'vs_assay_data' 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 position096
40SELECT 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 = 'substance' 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 position0136
41SELECT 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 = 'justification_code' 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 position046
42SELECT 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 = 'justification_code_map' 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 position035
43SELECT 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 = 'ligand' 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 position096
44SELECT "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 1000
45SELECT 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.name025416
46SELECT 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.name0113519
47SELECT DISTINCT "Deposit"."authors" AS "Deposit__authors" FROM "deposit" AS "Deposit" WHERE 1 = 1 ORDER BY "authors" asc 04487
48SELECT DISTINCT "Target"."project" AS "Target__project" FROM "protein_target" AS "Target" WHERE 1 = 1 ORDER BY "project" asc 0942
49SELECT 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)03515
50SELECT 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 0118
51SELECT "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 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"."pdb_id" desc LIMIT 20 OFFSET 18002075
52SELECT "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" IN ('1201', '1202', '1219', '1208', '1205', '1216', '1200', '1199', '1193', '1191', '1189', '1188', '1182', '1186', '1183', '1187', '1184', '1175', '1174', '1177') 001
53SELECT "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 ('1201', '1202', '1219', '1208', '1205', '1216', '1200', '1199', '1193', '1191', '1189', '1188', '1182', '1186', '1183', '1187', '1184', '1175', '1174', '1177') AND "DepositLigand"."ligand_code" = "Ligand"."code") 0622