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

Publications

    2013
  1. Target: IDP91191
    Stogios PJ, Spanogiannopoulos P, Evdokimova E, Egorova O, Shakya T, Todorovic N, Capretta A, Wright GD, Savchenko A. (2013)
    Structure-guided optimization of protein kinase inhibitors reverses aminoglycoside antibiotic resistance
    Biochemical Journal,: (Details) (Abstract)
  2. Target: IDP92622
    Gorla SK, Kavitha M, Zhang M, Chin JE, Liu X, Striepen B, Makowska-Grzyska M, Kim Y, Joachimiak A, Hedstrom L, Cuny GD (2013)
    Optimization of Benzoxazole-Based Inhibitors of Cryptosporidium parvum Inosine 5'-Monophosphate Dehydrogenase.
    Journal of Medicinal Chemistry,56:4028-43 (Details) (Abstract)
  3. Jiao LY, Ouyang SY, Liang MF, Niu FF, Shaw N, Wu W, Ding W, Jin C, Peng Y, Zhu YP, Zhang FS, Wang T, Li C, Zuo XB, Luan CH, Li DX, Liu ZJ (2013)
    Structure of Severe Fever with Thrombocytopenia Syndrome Virus Nucleocapsid Protein in Complex with Suramin Reveals Therapeutic Potentials
    Journal of Virology,87(12):6829-39 (Details) (Abstract)
    Times cited: 0
  4. Target: IDP91202
    Light SH, Krishna SN, Bergan RC, Lavie A, Anderson WF (2013)
    Crystal structure of a type II dehydroquinate dehydratase-like protein from Bifidobacterium longum.
    Journal of Structural and Functional Genomics,: (Details) (Abstract)
    Times cited: 0
  5. Target: IDP90195
    McCoy WH, Wang X, Yokoyama WM, Hansen TH, Fremont DH (2013)
    Cowpox virus employs a two-pronged strategy to outflank MHCI antigen presentation.
    Molecular immunology,: (Details) (Abstract)
    Times cited: 0
  6. Target: IDP00252
    Luca VC, Nelson CA, Fremont DH (2013)
    Structure of the St. Louis encephalitis virus postfusion envelope trimer.
    Journal of Virology,87:818-28 (Details) (Abstract)
    Times cited: 0
  7. Lewis TE, Sillitoe I, Andreeva A, Blundell TL, Buchan DW, Chothia C, Cuff A, Dana JM, Filippis I, Gough J, Hunter S, Jones DT, Kelley LA, Kleywegt GJ, Minneci F, Mitchell A, Murzin AG, Ochoa-Montaño B, Rackham OJ, Smith J, Sternberg MJ, Velankar S, Yeats C, Orengo C (2013)
    Genome3D: a UK collaborative project to annotate genomic sequences with predicted 3D structures based on SCOP and CATH domains.
    Nucleic Acids Research,41:D499-507 (Details) (Abstract)
    Times cited: 1
  8. Sillitoe I, Cuff AL, Dessailly BH, Dawson NL, Furnham N, Lee D, Lees JG, Lewis TE, Studer RA, Rentzsch R, Yeats C, Thornton JM, Orengo CA (2013)
    New functional families (FunFams) in CATH to improve the mapping of conserved functional sites to 3D structures.
    Nucleic Acids Research,41:D490-8 (Details) (Abstract)
    Times cited: 0
  9. Target: IDP01809
    Filippova EV, Weston LA, Kuhn ML, Geissler B, Gehring AM, Armoush N, Adkins CT, Minasov G, Dubrovska I, Shuvalova L, Winsor JR, Lavis LD, Satchell KJ, Becker DP, Anderson WF, Johnson RJ (2013)
    Large scale structural rearrangement of a serine hydrolase from Francisella tularensis facilitates catalysis.
    Journal of Biological Chemistry,288:10522-35 (Details) (Abstract)
  10. Target: IDP00348
    Light SH, Anderson WF (2013)
    The diversity of allosteric controls at the gateway to aromatic amino acid biosynthesis.
    Protein Science,22:395-404 (Details) (Abstract)
    Times cited: 0
change view

Page 1 of 5, showing 10 records out of 48 total, starting on record 1, ending on 10

Pmid Authors Title Journal Issn Year Vol Pages Center Target Pdb Type Times Cited
23758273 Stogios PJ, Spanogiannopoulos P, Evdokimova E, Egorova O, Shakya T, Todorovic N, Capretta A, Wright GD, Savchenko A. Structure-guided optimization of protein kinase inhibitors reverses aminoglycoside antibiotic resistance Biochemical Journal 2013 CSGID IDP91191 4EJ7, 4FEU, 4FEV, 4FEW, 4FEX, 4GKH, 4GKI structure
23668331 Gorla SK, Kavitha M, Zhang M, Chin JE, Liu X, Striepen B, Makowska-Grzyska M, Kim Y, Joachimiak A, Hedstrom L, Cuny GD Optimization of Benzoxazole-Based Inhibitors of Cryptosporidium parvum Inosine 5'-Monophosphate Dehydrogenase. Journal of Medicinal Chemistry 2013 56 4028-43 CSGID IDP92622 4IXH function
23576501 Jiao LY, Ouyang SY, Liang MF, Niu FF, Shaw N, Wu W, Ding W, Jin C, Peng Y, Zhu YP, Zhang FS, Wang T, Li C, Zuo XB, Luan CH, Li DX, Liu ZJ Structure of Severe Fever with Thrombocytopenia Syndrome Virus Nucleocapsid Protein in Complex with Suramin Reveals Therapeutic Potentials Journal of Virology 2013 87(12) 6829-39 CSGID 4J4R, 4J4S, 4J4U, 4J4V, 4J4W, 4J4X, 4J4Y structure
23539270 Light SH, Krishna SN, Bergan RC, Lavie A, Anderson WF Crystal structure of a type II dehydroquinate dehydratase-like protein from Bifidobacterium longum. Journal of Structural and Functional Genomics 2013 CSGID IDP91202 3U80 note
23312338 McCoy WH, Wang X, Yokoyama WM, Hansen TH, Fremont DH Cowpox virus employs a two-pronged strategy to outflank MHCI antigen presentation. Molecular immunology 2013 CSGID IDP90195 4HKJ structure
23115296 Luca VC, Nelson CA, Fremont DH Structure of the St. Louis encephalitis virus postfusion envelope trimer. Journal of Virology 2013 87 818-28 CSGID IDP00252 4FG0 structure
23203986 Lewis TE, Sillitoe I, Andreeva A, Blundell TL, Buchan DW, Chothia C, Cuff A, Dana JM, Filippis I, Gough J, Hunter S, Jones DT, Kelley LA, Kleywegt GJ, Minneci F, Mitchell A, Murzin AG, Ochoa-Montaño B, Rackham OJ, Smith J, Sternberg MJ, Velankar S, Yeats C, Orengo C Genome3D: a UK collaborative project to annotate genomic sequences with predicted 3D structures based on SCOP and CATH domains. Nucleic Acids Research 2013 41 D499-507 CSGID other 1
23203873 Sillitoe I, Cuff AL, Dessailly BH, Dawson NL, Furnham N, Lee D, Lees JG, Lewis TE, Studer RA, Rentzsch R, Yeats C, Thornton JM, Orengo CA New functional families (FunFams) in CATH to improve the mapping of conserved functional sites to 3D structures. Nucleic Acids Research 2013 41 D490-8 CSGID other
23430251 Filippova EV, Weston LA, Kuhn ML, Geissler B, Gehring AM, Armoush N, Adkins CT, Minasov G, Dubrovska I, Shuvalova L, Winsor JR, Lavis LD, Satchell KJ, Becker DP, Anderson WF, Johnson RJ Large scale structural rearrangement of a serine hydrolase from Francisella tularensis facilitates catalysis. Journal of Biological Chemistry 2013 288 10522-35 CSGID IDP01809 function
23400945 Light SH, Anderson WF The diversity of allosteric controls at the gateway to aromatic amino acid biosynthesis. Protein Science 2013 22 395-404 CSGID IDP00348 other
change view


<< previous | 1 | 2 | 3 | 4 | 5 |
(psipubs) 29 queries took 59 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';0259
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 = 'publication' AND (table_schema = 'public') ORDER BY position03714
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 = 'journal_alias' AND (table_schema = 'public') ORDER BY position025
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 = 'journal' AND (table_schema = 'public') ORDER BY position066
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 = 'abstract' AND (table_schema = 'public') ORDER BY position037
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 = 'publication_pdb' AND (table_schema = 'public') ORDER BY position037
7SELECT COUNT(*) AS "count" FROM "publication" AS "Publication" LEFT JOIN "journal_alias" AS "JournalAlias" ON ("Publication"."journal_short" = "JournalAlias"."name") WHERE center like'%CSGID%' 015
8SELECT "Publication"."id" AS "Publication__id", "Publication"."pmid" AS "Publication__pmid", "Publication"."authors" AS "Publication__authors", "Publication"."title" AS "Publication__title", "Publication"."journal_short" AS "Publication__journal_short", "Publication"."issn" AS "Publication__issn", "Publication"."year" AS "Publication__year", "Publication"."vol" AS "Publication__vol", "Publication"."pages" AS "Publication__pages", "Publication"."center" AS "Publication__center", "Publication"."target_id" AS "Publication__target_id", "Publication"."pdb_id" AS "Publication__pdb_id", "Publication"."type" AS "Publication__type", "Publication"."status" AS "Publication__status", "Publication"."source" AS "Publication__source", "Publication"."remark" AS "Publication__remark", "Publication"."verified" AS "Publication__verified", "Publication"."frozen" AS "Publication__frozen", "Publication"."times_cited" AS "Publication__times_cited", "Publication"."times_cited_update" AS "Publication__times_cited_update", "Publication"."inserted" AS "Publication__inserted", "Publication"."updated" AS "Publication__updated", "Publication"."times_cited_status" AS "Publication__times_cited_status", "Publication"."pubmed_times_cited" AS "Publication__pubmed_times_cited", "Publication"."pubmed_times_cited_update" AS "Publication__pubmed_times_cited_update", "Publication"."pubmed_times_cited_status" AS "Publication__pubmed_times_cited_status", "Publication"."cover_image" AS "Publication__cover_image", "Publication"."initiative_id" AS "Publication__initiative_id", "Publication"."pmcid" AS "Publication__pmcid", "Publication"."doi" AS "Publication__doi", "Publication"."date_pubmed_created" AS "Publication__date_pubmed_created", "Publication"."date_pubmed_updated" AS "Publication__date_pubmed_updated", "Publication"."pub_month" AS "Publication__pub_month", "Publication"."pub_day" AS "Publication__pub_day", "Publication"."date_accepted" AS "Publication__date_accepted", "Publication"."date_pubmed_history" AS "Publication__date_pubmed_history", "Publication"."date_aheadofprint" AS "Publication__date_aheadofprint", "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "publication" AS "Publication" LEFT JOIN "journal_alias" AS "JournalAlias" ON ("Publication"."journal_short" = "JournalAlias"."name") WHERE center like'%CSGID%' ORDER BY "year" desc, "id" desc LIMIT 100104
9SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Biochem J' 010
10SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '34' 011
11SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Journal of medicinal chemistry' 010
12SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '124' 010
13SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'J Virol' 010
14SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '136' 010
15SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Journal of structural and functional genomics' 010
16SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '16' 010
17SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Molecular immunology' 010
18SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '1837' 010
19SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Journal of virology' 010
20SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '136' 010
21SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Nucleic acids research' 010
22SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '165' 010
23SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Nucleic acids research' 010
24SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '165' 010
25SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'The Journal of biological chemistry' 010
26SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '114' 010
27SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Protein science : a publication of the Protein Society' 010
28SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '179' 010
29SELECT "PublicationPdb"."id" AS "PublicationPdb__id", "PublicationPdb"."publication_id" AS "PublicationPdb__publication_id", "PublicationPdb"."pdb_id" AS "PublicationPdb__pdb_id" FROM "publication_pdb" AS "PublicationPdb" WHERE "PublicationPdb"."publication_id" IN ('2481', '2469', '2370', '2354', '2345', '2343', '2337', '2336', '2333', '2330') 0181
(default) 44 queries took 303 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';0922
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 = '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 position087
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 = '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 position0197
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 = '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 position077
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 = '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 position0328
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 = '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 position09412
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 = '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
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 = '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 position026
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 = '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 position026
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 = '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 position046
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 = '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 position026
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 = '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
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 = '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 position077
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 = '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 position0167
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 = '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 position0157
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 = '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 position067
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 = '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 position0398
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 = '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 position0107
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 = '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 position0318
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 = '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 position0107
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 = '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 position0348
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 = '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 position0278
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 = '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 position0569
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 = '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 position0248
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 = '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 position0127
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 = '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 position0469
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 = '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 position0197
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 = '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 position0227
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 = '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 position0227
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 = '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 position097
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 = '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 position057
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 = '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 position077
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 = '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
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 = '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 position067
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 = '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 position0167
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 = '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 position0147
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 = '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 position0177
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 = '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 position0157
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 = '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 position056
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 = '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 position097
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 = '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 position0137
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' 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
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 = '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 position036
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 1001