| 1 | SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr'; | | 0 | 83 | 16 |
| 2 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 5 | 7 |
| 3 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 19 | 7 |
| 4 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 46 | 9 |
| 5 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 24 | 9 |
| 6 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 20 | 8 |
| 7 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 6 | 7 |
| 8 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 32 | 9 |
| 9 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 95 | 13 |
| 10 | SELECT 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' AND (table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 5 | 7 |
| 11 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 2 | 7 |
| 12 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 2 | 7 |
| 13 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 4 | 7 |
| 14 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 2 | 7 |
| 15 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 20 | 8 |
| 16 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 7 | 7 |
| 17 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 16 | 8 |
| 18 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 12 | 8 |
| 19 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 6 | 7 |
| 20 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 41 | 10 |
| 21 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 8 | 7 |
| 22 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 31 | 9 |
| 23 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 10 | 8 |
| 24 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 34 | 10 |
| 25 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 27 | 9 |
| 26 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 56 | 11 |
| 27 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 7 | 7 |
| 28 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 12 | 8 |
| 29 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 16 | 8 |
| 30 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 13 | 8 |
| 31 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 17 | 8 |
| 32 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 22 | 8 |
| 33 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 22 | 8 |
| 34 | SELECT 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 = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb' OR table_schema = 'mr') ORDER BY position | | 0 | 9 | 7 |
| 35 | SELECT "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", "Staff"."function" AS "Staff__function" FROM "center_user" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1 | | 0 | 0 | 2 |
| 36 | SELECT 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.name | | 0 | 7 | 3 |
| 37 | SELECT 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.name | | 0 | 28 | 2 |
| 38 | SELECT DISTINCT "Deposit"."authors" AS "Deposit__authors" FROM "deposit" AS "Deposit" WHERE 1 = 1 ORDER BY "authors" asc | | 0 | 181 | 3 |
| 39 | SELECT DISTINCT "Target"."project" AS "Target__project" FROM "protein_target" AS "Target" WHERE 1 = 1 ORDER BY "project" asc | | 0 | 39 | 130 |
| 40 | SELECT 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) | | 0 | 50 | 122 |
| 41 | SELECT 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 | | 0 | 1 | 120 |
| 42 | SELECT "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id", "Structure"."id" AS "Structure__id", "Structure"."target_id" AS "Structure__target_id", "Structure"."structure_solution_id" AS "Structure__structure_solution_id", "Structure"."ref_filename" AS "Structure__ref_filename", "Structure"."ref_uploaded" AS "Structure__ref_uploaded", "Structure"."ref_r" AS "Structure__ref_r", "Structure"."ref_rfree" AS "Structure__ref_rfree", "Structure"."ref_resolution" AS "Structure__ref_resolution", "Structure"."num_atoms" AS "Structure__num_atoms", "Structure"."num_waters" AS "Structure__num_waters", "Structure"."num_hetatoms" AS "Structure__num_hetatoms", "Structure"."ref_res_high" AS "Structure__ref_res_high", "Structure"."ref_res_low" AS "Structure__ref_res_low", "Structure"."ref_sigma_f" AS "Structure__ref_sigma_f", "Structure"."ref_sigma_i" AS "Structure__ref_sigma_i", "Structure"."ref_number_reflns_obs" AS "Structure__ref_number_reflns_obs", "Structure"."ref_percent_reflns_obs" AS "Structure__ref_percent_reflns_obs", "Structure"."ref_percent_reflns_r_free" AS "Structure__ref_percent_reflns_r_free", "Structure"."ref_b_iso_mean" AS "Structure__ref_b_iso_mean", "Structure"."rval_work" AS "Structure__rval_work", "Structure"."ref_bond_refined_d" AS "Structure__ref_bond_refined_d", "Structure"."ref_angle_refined_deg" AS "Structure__ref_angle_refined_deg", "Structure"."ref_shell_res_high" AS "Structure__ref_shell_res_high", "Structure"."ref_shell_res_low" AS "Structure__ref_shell_res_low", "Structure"."ref_shell_number_reflns_all" AS "Structure__ref_shell_number_reflns_all", "Structure"."ref_shell_number_reflns_r_free" AS "Structure__ref_shell_number_reflns_r_free", "Structure"."ref_shell_r_work" AS "Structure__ref_shell_r_work", "Structure"."ref_shell_r_free" AS "Structure__ref_shell_r_free", "Structure"."ref_shell_percent_reflns_obs" AS "Structure__ref_shell_percent_reflns_obs", "Structure"."ref_dihedral_angle" AS "Structure__ref_dihedral_angle", "Structure"."ref_improper_torsion_angle" AS "Structure__ref_improper_torsion_angle", "Structure"."a" AS "Structure__a", "Structure"."b" AS "Structure__b", "Structure"."c" AS "Structure__c", "Structure"."alpha" AS "Structure__alpha", "Structure"."beta" AS "Structure__beta", "Structure"."gamma" AS "Structure__gamma", "Structure"."z" AS "Structure__z", "Structure"."matthew_coeff" AS "Structure__matthew_coeff", "Structure"."spacegroup" AS "Structure__spacegroup", "Structure"."inserted" AS "Structure__inserted", "Structure"."ins_user_id" AS "Structure__ins_user_id", "Structure"."update" AS "Structure__update", "Structure"."upd_user_id" AS "Structure__upd_user_id", "Structure"."staff_id" AS "Structure__staff_id", "Structure"."lab_id" AS "Structure__lab_id", "Lab"."id" AS "Lab__id", "Lab"."short" AS "Lab__short", "Lab"."full_name" AS "Lab__full_name", "Lab"."display_name" AS "Lab__display_name", "Lab"."main" AS "Lab__main", "Lab"."active" AS "Lab__active", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."local_target_id" AS "Target__local_target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."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"."ec" AS "Target__ec", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."type" AS "Target__type", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification", "Pdbstructures"."pdb_id" AS "Pdbstructures__pdb_id", "Pdbstructures"."file_modify_date" AS "Pdbstructures__file_modify_date", "Pdbstructures"."header" AS "Pdbstructures__header", "Pdbstructures"."deposition_date" AS "Pdbstructures__deposition_date", "Pdbstructures"."release_date" AS "Pdbstructures__release_date", "Pdbstructures"."collection_date" AS "Pdbstructures__collection_date", "Pdbstructures"."title" AS "Pdbstructures__title", "Pdbstructures"."exp_method" AS "Pdbstructures__exp_method", "Pdbstructures"."resolution" AS "Pdbstructures__resolution", "Pdbstructures"."current_flag" AS "Pdbstructures__current_flag", "Pdbstructures"."time_updated" AS "Pdbstructures__time_updated", "Pdbstructures"."nr_matches_50" AS "Pdbstructures__nr_matches_50", "Pdbstructures"."with_sf" AS "Pdbstructures__with_sf", "Pdbstructures"."exp_detail" AS "Pdbstructures__exp_detail", "Pdbstructures"."nr_matches_30" AS "Pdbstructures__nr_matches_30", "Pdbstructures"."r_value" AS "Pdbstructures__r_value", "Pdbstructures"."rfree_value" AS "Pdbstructures__rfree_value", "Pdbstructures"."b_iso_mean" AS "Pdbstructures__b_iso_mean", "Pdbstructures"."supersede_id" AS "Pdbstructures__supersede_id", "Pdbstructures"."waters" AS "Pdbstructures__waters", "Pdbstructures"."original_deposition_date" AS "Pdbstructures__original_deposition_date", "Pdbstructures"."residue_no" AS "Pdbstructures__residue_no" FROM "deposit" AS "Deposit" LEFT JOIN "structure" AS "Structure" ON ("Deposit"."structure_id" = "Structure"."id") LEFT JOIN "lab" AS "Lab" ON ("Deposit"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("Deposit"."staff_id" = "Staff"."id") LEFT JOIN "protein_target" AS "Target" ON ("Deposit"."target_id" = "Target"."target_id") LEFT JOIN "pdbstructures" AS "Pdbstructures" ON ("Deposit"."pdb_id" = "Pdbstructures"."pdb_id") WHERE obsolete IS FALSE ORDER BY case when "Target"."project"='Community Requests' then 1
when "Target"."project"='Community Request' then 2
else 3 end ASC, "Deposit"."pdb_id" desc LIMIT 20 OFFSET 100 | | 0 | 20 | 150 |
| 43 | SELECT "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 ('153', '151', '165', '152', '162', '163', '189', '149', '148', '147', '146', '145', '143', '144', '142', '141', '140', '139', '138', '137') | | 0 | 0 | 2 |
| 44 | SELECT "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 ('153', '151', '165', '152', '162', '163', '189', '149', '148', '147', '146', '145', '143', '144', '142', '141', '140', '139', '138', '137') AND "DepositLigand"."ligand_code" = "Ligand"."code") | | 0 | 0 | 1 |
Title:
Crystal structure of solute binding protein of ABC transporter from Rhodopseudomonas palustris HaA2 in complex with caffeic acid/3-(4-HYDROXY-PHENYL)PYRUVIC ACID 
Title:
Crystal structure of solute binding protein of ABC transporter from Rhodopseudomonas palustris BisB5 in complex with 3,4-dihydroxy benzoic acid
Title:
Crystal structure of ABC transporter from R. palustris - solute binding protein (RPA0668) in complex with benzoate
previous
