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

Publication

ID 1886
PubMed ID 20213425
Authors Eschenfeldt WH, Maltseva N, Stols L, Donnelly MI, Gu M, Nocek B, Tan K, Kim Y, Joachimiak A
Title Cleavable C-terminal His-tag vectors for structure determination.
Journal Journal of Structural and Functional Genomics
ISSN
Year 2010
Volume 11
Pages 31-9
Center CSGID+MCSG
Target ID
PDB ID(s)
Type method
Remark
Times Cited 5
Citation Number Update 2013-06-15 11:26:23.719565-04
(psipubs) 12 queries took 60 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 position03715
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 position027
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 position067
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 "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", "PubAbstract"."id" AS "PubAbstract__id", "PubAbstract"."publication_id" AS "PubAbstract__publication_id", "PubAbstract"."abstract" AS "PubAbstract__abstract" FROM "publication" AS "Publication" LEFT JOIN "journal_alias" AS "JournalAlias" ON ("Publication"."journal_short" = "JournalAlias"."name") LEFT JOIN "abstract" AS "PubAbstract" ON ("PubAbstract"."publication_id" = "Publication"."id") WHERE "Publication"."id" = '1886' LIMIT 1015
8SELECT "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" = ('1886') 001
9SELECT "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 "id" = '1886' LIMIT 1011
10SELECT "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
11SELECT "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' 011
12SELECT "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" = ('1886') 000
(default) 44 queries took 314 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 position057
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 position027
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 position047
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 position0208
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 position0399
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 position0228
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 position0228
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 position047
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 position057
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 position047
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 position037
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