Home    Target List    Selection    Community Requests    Clones    Screenings    XML files    Diffraction Images    Progress    Homolog Search    Clustering    Statistics    News    Help    Log In
CSGID: 3 matches were found.

IDP02263 Relative Identity: 100%E-value: 1.5e-78
IDP04035 Relative Identity: 32.3%E-value: 2.5e-17
IDP04320 Relative Identity: 26.8%E-value: 1.4e-12

PDB: 28 matches were found.

3U7I_B Relative Identity: 100%E-value: 1e-82
3U7I_D Relative Identity: 100%E-value: 1e-82
3U7I_C Relative Identity: 100%E-value: 1e-82
3U7I_A Relative Identity: 100%E-value: 1e-82
3P0R_A Relative Identity: 32.3%E-value: 3.2e-17
2HPV_B Relative Identity: 29.5%E-value: 6.6e-17
2HPV_A Relative Identity: 29.5%E-value: 6.6e-17
2HPV_D Relative Identity: 29.5%E-value: 6.6e-17
2HPV_C Relative Identity: 29.5%E-value: 6.6e-17
4ESE_A Relative Identity: 26.8%E-value: 3.8e-12
1T5B_A Relative Identity: 30%E-value: 4.4e-12
1T5B_B Relative Identity: 30%E-value: 4.4e-12
1TIK_A Relative Identity: 26.4%E-value: 7.4e-11
2Z9C_A Relative Identity: 25.4%E-value: 9.4e-11
2Z9D_B Relative Identity: 25.4%E-value: 9.4e-11
2Z9D_A Relative Identity: 25.4%E-value: 9.4e-11
2D5I_A Relative Identity: 25.4%E-value: 9.4e-11
2Z98_A Relative Identity: 25.4%E-value: 9.4e-11
1V4B_A Relative Identity: 25.4%E-value: 9.4e-11
2Z9B_A Relative Identity: 25.4%E-value: 9.4e-11
3KEG_A Relative Identity: 18.7%E-value: 0.0002
3KEG_B Relative Identity: 18.7%E-value: 0.0002
3R6W_A Relative Identity: 19.5%E-value: 0.00026
3R6W_B Relative Identity: 19.5%E-value: 0.00026
3LT5_A Relative Identity: 19.5%E-value: 0.00026
3LT5_B Relative Identity: 19.5%E-value: 0.00026
2V9C_B Relative Identity: 19.5%E-value: 0.00027
2V9C_A Relative Identity: 19.5%E-value: 0.00027



IDP02263 Relative Identity: 100%E-value: 1.5e-78

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
IDP022 MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
               10        20        30        40        50        60

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
IDP022 AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
               70        80        90       100       110       120

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
IDP022 RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
              130       140       150       160       170       180

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ::::::::::::::::::::::::::::::::::::::::
IDP022 IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
              190       200       210       220



IDP04035 Relative Identity: 32.3%E-value: 2.5e-17

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
       :.:.:...:. .  . ..::.:... :: ::::    :.:. ...:: . .:..   ...
IDP040 MTKVLFVKANNRPAE-QAVSVKLYEAFLASYKE-AHPNDTVVELDLYKEELPYVGVDMIN
               10         20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       .  : :.: .::.:: :..   .. :.::  :.  :. .:: :..::. :. :.: .  :
IDP040 GTFKAGKGFDLTEEEAKAVAVADKYLNQFLEADKVVFGFPLWNLTIPAVLHTYIDYLNRA
       60        70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
        .:::::  : :::. : ... ...: ::.:..    ..::.. ::. .:..:.:  ...
IDP040 GKTFKYTPEGPVGLIGD-KKIALLNARGGVYSEGP-AAEVEMAVKYVASMMGFFGATNME
      120       130        140       150        160       170

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
        :  .:   . : .. .     .:::: ..:::.
IDP040 TVVIEGHNQF-PDKAEEIITAGLEEAA-KVANKF
        180        190       200



IDP04320 Relative Identity: 26.8%E-value: 1.4e-12

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
       :.:.:....  ..  ::: : ..   :.:...   .... :   .:  . .:..:  ...
IDP043 MSKVLVLKS--SILATSSQSNQLADFFVEQWQAAHAGDQ-ITVRDLAAQPIPVLDGELVG
                 10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       : . .:..  :: ..:..    .:.. .... .. ::. :..:::::..::.:.: :  :
IDP043 ALRPSGTA--LTPRQQEALALSDELIAELQANDVIVIAAPMYNFNIPTQLKNYFDMIARA
        60          70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.::: :  ::.  :.: ... . :::.   :  ::.     ::. ...:.:: : .
IDP043 GVTFRYTEKGPEGLVT-GKRAIILTSRGGIHK--DTPTDLVV--PYLRLFLGFIGITDVE
         120       130        140         150         160       170

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :
IDP043 FVFAEGIAYGPEVATKAQADAKTLLAQVVAA
              180       190       200





3U7I_B Relative Identity: 100%E-value: 1e-82

                  10        20        30        40        50
QUERY     MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
          :::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_B SNAMNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
               10        20        30        40        50        60

        60        70        80        90       100       110
QUERY  VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_B VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
               70        80        90       100       110       120

       120       130       140       150       160       170
QUERY  MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_B MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
              130       140       150       160       170       180

       180       190       200       210       220
QUERY  DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       :::::::::::::::::::::::::::::::::::::::::::
3U7I_B DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
              190       200       210       220



3U7I_D Relative Identity: 100%E-value: 1e-82

                  10        20        30        40        50
QUERY     MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
          :::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_D SNAMNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
               10        20        30        40        50        60

        60        70        80        90       100       110
QUERY  VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_D VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
               70        80        90       100       110       120

       120       130       140       150       160       170
QUERY  MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_D MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
              130       140       150       160       170       180

       180       190       200       210       220
QUERY  DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       :::::::::::::::::::::::::::::::::::::::::::
3U7I_D DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
              190       200       210       220



3U7I_C Relative Identity: 100%E-value: 1e-82

                  10        20        30        40        50
QUERY     MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
          :::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_C SNAMNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
               10        20        30        40        50        60

        60        70        80        90       100       110
QUERY  VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_C VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
               70        80        90       100       110       120

       120       130       140       150       160       170
QUERY  MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_C MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
              130       140       150       160       170       180

       180       190       200       210       220
QUERY  DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       :::::::::::::::::::::::::::::::::::::::::::
3U7I_C DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
              190       200       210       220



3U7I_A Relative Identity: 100%E-value: 1e-82

                  10        20        30        40        50
QUERY     MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
          :::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_A SNAMNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
               10        20        30        40        50        60

        60        70        80        90       100       110
QUERY  VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_A VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
               70        80        90       100       110       120

       120       130       140       150       160       170
QUERY  MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
       ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3U7I_A MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
              130       140       150       160       170       180

       180       190       200       210       220
QUERY  DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       :::::::::::::::::::::::::::::::::::::::::::
3U7I_A DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
              190       200       210       220



3P0R_A Relative Identity: 32.3%E-value: 3.2e-17

                  10        20        30        40        50
QUERY     MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
          :.:.:...:. .  . ..::.:... :: ::::    :.:. ...:: . .:..
3P0R_A SNAMTKVLFVKANNRPAE-QAVSVKLYEAFLASYKE-AHPNDTVVELDLYKEELPYVGVD
               10         20        30         40        50

        60        70        80        90       100       110
QUERY  VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
       ....  : :.: .::.:: :..   .. :.::  :.  :. .:: :..::. :. :.: .
3P0R_A MINGTFKAGKGFDLTEEEAKAVAVADKYLNQFLEADKVVFGFPLWNLTIPAVLHTYIDYL
       60        70        80        90       100       110

       120       130       140       150       160       170
QUERY  MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
         : .:::::  : :::. : ... ...: ::.:..    ..::.. ::. .:..:.:
3P0R_A NRAGKTFKYTPEGPVGLIGD-KKIALLNARGGVYSEGP-AAEVEMAVKYVASMMGFFGAT
      120       130        140       150        160       170

       180       190       200       210       220
QUERY  DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ... :  .:   . : .. .     .:::: ..:::.
3P0R_A NMETVVIEGHNQF-PDKAEEIITAGLEEAA-KVANKF
        180        190       200        210



2HPV_B Relative Identity: 29.5%E-value: 6.6e-17

               10        20        30        40          50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLY--DDVVPMIDKTV
       :.: :...::: . . :  :..... :: ::.:   ..: :: ...:  .  .: ::. .
2HPV_B MSKLLVVKAHPLTKEESR-SVRALETFLASYRETNPSDE-IEILDVYAPETNMPEIDEEL
               10         20        30         40        50

       60           70        80        90       100       110
QUERY  LSAWEKQGNG---QELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMD
       ::::     :   . :....:. . :..:. .:: ::.  ::. :. :.:.:..:: ..:
2HPV_B LSAWGALRAGAAFETLSENQQQKVARFNELTDQFLSADKVVIANPMWNLNVPTRLKAWVD
       60        70        80        90       100       110

         120       130       140       150       160       170
QUERY  NIMIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLG
       .: .: .::.::  :   : . :.. : ::..::.: . :      .. .:.::..::.:
2HPV_B TINVAGKTFQYTAEGPKPLTS-GKKALHIQSNGGFYEGKD------FASQYIKAILNFIG
      120       130        140       150             160       170

         180       190       200       210       220
QUERY  IEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ... . .  .:
2HPV_B VDQVDGLFIEGIDHFPDRAEELLNTAMTKATEYGKTF
             180       190       200



2HPV_A Relative Identity: 29.5%E-value: 6.6e-17

               10        20        30        40          50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLY--DDVVPMIDKTV
       :.: :...::: . . :  :..... :: ::.:   ..: :: ...:  .  .: ::. .
2HPV_A MSKLLVVKAHPLTKEESR-SVRALETFLASYRETNPSDE-IEILDVYAPETNMPEIDEEL
               10         20        30         40        50

       60           70        80        90       100       110
QUERY  LSAWEKQGNG---QELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMD
       ::::     :   . :....:. . :..:. .:: ::.  ::. :. :.:.:..:: ..:
2HPV_A LSAWGALRAGAAFETLSENQQQKVARFNELTDQFLSADKVVIANPMWNLNVPTRLKAWVD
       60        70        80        90       100       110

         120       130       140       150       160       170
QUERY  NIMIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLG
       .: .: .::.::  :   : . :.. : ::..::.: . :      .. .:.::..::.:
2HPV_A TINVAGKTFQYTAEGPKPLTS-GKKALHIQSNGGFYEGKD------FASQYIKAILNFIG
      120       130        140       150             160       170

         180       190       200       210       220
QUERY  IEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ... . .  .:
2HPV_A VDQVDGLFIEGIDHFPDRAEELLNTAMTKATEYGKTF
             180       190       200



2HPV_D Relative Identity: 29.5%E-value: 6.6e-17

               10        20        30        40          50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLY--DDVVPMIDKTV
       :.: :...::: . . :  :..... :: ::.:   ..: :: ...:  .  .: ::. .
2HPV_D MSKLLVVKAHPLTKEESR-SVRALETFLASYRETNPSDE-IEILDVYAPETNMPEIDEEL
               10         20        30         40        50

       60           70        80        90       100       110
QUERY  LSAWEKQGNG---QELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMD
       ::::     :   . :....:. . :..:. .:: ::.  ::. :. :.:.:..:: ..:
2HPV_D LSAWGALRAGAAFETLSENQQQKVARFNELTDQFLSADKVVIANPMWNLNVPTRLKAWVD
       60        70        80        90       100       110

         120       130       140       150       160       170
QUERY  NIMIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLG
       .: .: .::.::  :   : . :.. : ::..::.: . :      .. .:.::..::.:
2HPV_D TINVAGKTFQYTAEGPKPLTS-GKKALHIQSNGGFYEGKD------FASQYIKAILNFIG
      120       130        140       150             160       170

         180       190       200       210       220
QUERY  IEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ... . .  .:
2HPV_D VDQVDGLFIEGIDHFPDRAEELLNTAMTKATEYGKTF
             180       190       200



2HPV_C Relative Identity: 29.5%E-value: 6.6e-17

               10        20        30        40          50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLY--DDVVPMIDKTV
       :.: :...::: . . :  :..... :: ::.:   ..: :: ...:  .  .: ::. .
2HPV_C MSKLLVVKAHPLTKEESR-SVRALETFLASYRETNPSDE-IEILDVYAPETNMPEIDEEL
               10         20        30         40        50

       60           70        80        90       100       110
QUERY  LSAWEKQGNG---QELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMD
       ::::     :   . :....:. . :..:. .:: ::.  ::. :. :.:.:..:: ..:
2HPV_C LSAWGALRAGAAFETLSENQQQKVARFNELTDQFLSADKVVIANPMWNLNVPTRLKAWVD
       60        70        80        90       100       110

         120       130       140       150       160       170
QUERY  NIMIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLG
       .: .: .::.::  :   : . :.. : ::..::.: . :      .. .:.::..::.:
2HPV_C TINVAGKTFQYTAEGPKPLTS-GKKALHIQSNGGFYEGKD------FASQYIKAILNFIG
      120       130        140       150             160       170

         180       190       200       210       220
QUERY  IEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ... . .  .:
2HPV_C VDQVDGLFIEGIDHFPDRAEELLNTAMTKATEYGKTF
             180       190       200



4ESE_A Relative Identity: 26.8%E-value: 3.8e-12

                  10        20        30        40        50
QUERY     MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
          :.:.:....  ..  ::: : ..   :.:...   .... :   .:  . .:..:
4ESE_A SNAMSKVLVLKS--SILATSSQSNQLADFFVEQWQAAHAGDQ-ITVRDLAAQPIPVLDGE
               10          20        30        40         50

        60        70        80        90       100       110
QUERY  VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNI
       ...: . .:..  :: ..:..    .:.. .... .. ::. :..:::::..::.:.: :
4ESE_A LVGALRPSGTA--LTPRQQEALALSDELIAELQANDVIVIAAPMYNFNIPTQLKNYFDMI
        60          70        80        90       100       110

       120       130       140       150       160       170
QUERY  MIARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIE
         :  ::.::: :  ::.  :.: ... . :::.   :  ::.     ::. ...:.::
4ESE_A ARAGVTFRYTEKGPEGLVT-GKRAIILTSRGGIHK--DTPTDLVV--PYLRLFLGFIGIT
         120       130        140         150         160       170

       180       190       200       210       220
QUERY  DYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       : ..: :.: :
4ESE_A DVEFVFAEGIAYGPEVATKAQADAKTLLAQVVAA
              180       190       200



1T5B_A Relative Identity: 30%E-value: 4.4e-12

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
       :.:.:....  ..    : : ..  .:.:...:    .: :   .:  . ::..:  ...
1T5B_A MSKVLVLKS--SILAGYSQSGQLTDYFIEQWREKHVADE-ITVRDLAANPVPVLDGELVG
                 10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       :  . :..  :: ..: .    .:.. ..:. .. ::. :..:::::..::.:.: :  :
1T5B_A AM-RPGDAP-LTPRQQDALALSDELIAELKAHDVIVIAAPMYNFNIPTQLKNYFDLIARA
         60         70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.::: :  ::.  :.: .:... :::. .    : ..    :::....:.:: : .
1T5B_A GITFRYTEKGPEGLVT-GKRAVVLSSRGGIHKD----TPTDLIAPYLKVFLGFIGITDVN
         120       130        140           150       160       170

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :   : ::  .:  ... :
1T5B_A FVFAEGIAY-GP-EVAAKAQADAKAAIDSVVAA
               180        190       200



1T5B_B Relative Identity: 30%E-value: 4.4e-12

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
       :.:.:....  ..    : : ..  .:.:...:    .: :   .:  . ::..:  ...
1T5B_B MSKVLVLKS--SILAGYSQSGQLTDYFIEQWREKHVADE-ITVRDLAANPVPVLDGELVG
                 10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       :  . :..  :: ..: .    .:.. ..:. .. ::. :..:::::..::.:.: :  :
1T5B_B AM-RPGDAP-LTPRQQDALALSDELIAELKAHDVIVIAAPMYNFNIPTQLKNYFDLIARA
         60         70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.::: :  ::.  :.: .:... :::. .    : ..    :::....:.:: : .
1T5B_B GITFRYTEKGPEGLVT-GKRAVVLSSRGGIHKD----TPTDLIAPYLKVFLGFIGITDVN
         120       130        140           150       160       170

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :   : ::  .:  ... :
1T5B_B FVFAEGIAY-GP-EVAAKAQADAKAAIDSVVAA
               180        190       200



1TIK_A Relative Identity: 26.4%E-value: 7.4e-11

                 10        20        30        40        50
QUERY    MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTV
         ..:.:....  ..    : : ..  .:.:...:  : .: :   .:  . .:..:  .
1TIK_A MSLSKVLVLKS--SILAGYSQSNQLSDYFVEQWREKHSADE-ITVRDLAANPIPVLDGEL
               10          20        30         40        50

       60        70        80        90       100       110
QUERY  LSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIM
       ..: .   .   :: ..:..    .:.. ..:. .. ::. :..:::: ..::.:.: .
1TIK_A VGALRP--SDAPLTPRQQEALALSDELIAELKAHDVIVIAAPMYNFNISTQLKNYFDLVA
        60          70        80        90       100       110

      120       130       140       150       160       170
QUERY  IARETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIED
        :  ::.:::.:  ::.  :.. .:: . :::.   :  ::.     ::.....:.:: :
1TIK_A RAGVTFRYTENGPEGLVT-GKKAIVITSRGGIHK--DGPTDL--VTPYLSTFLGFIGITD
         120       130        140         150         160       170

      180       190       200       210       220
QUERY  YQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
        ..: :.: :
1TIK_A VKFVFAEGIAYGPEMAAKAQSDAKAAIDSIVSAEGGSHHHHHH
              180       190       200       210



2Z9C_A Relative Identity: 25.4%E-value: 9.4e-11

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
                        : : ..  .:.:...:  : .: :   .:  . .:..:  ...
2Z9C_A    SKVLVLKSSILAGYSQSNQLSDYFVEQWREKHSADE-ITVRDLAANPIPVLDGELVG
                  10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       : .   .   :: ..:..    .:.. ..:. .. ::. :..:::: ..::.:.: .  :
2Z9C_A ALRP--SDAPLTPRQQEALALSDELIAELKAHDVIVIAAPMYNFNISTQLKNYFDLVARA
         60          70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.:::.:  ::.  :.. .:: . :::.   :  ::.     ::.....:.:: : .
2Z9C_A GVTFRYTENGPEGLVT-GKKAIVITSRGGIHK--DGPTDL--VTPYLSTFLGFIGITDVK
          120       130        140         150         160

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :
2Z9C_A FVFAEGIAYGPEMAAKAQSDAKAAIDSIVSA
     170       180       190       200



2Z9D_B Relative Identity: 25.4%E-value: 9.4e-11

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
                        : : ..  .:.:...:  : .: :   .:  . .:..:  ...
2Z9D_B    SKVLVLKSSILAGYSQSNQLSDYFVEQWREKHSADE-ITVRDLAANPIPVLDGELVG
                  10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       : .   .   :: ..:..    .:.. ..:. .. ::. :..:::: ..::.:.: .  :
2Z9D_B ALRP--SDAPLTPRQQEALALSDELIAELKAHDVIVIAAPMYNFNISTQLKNYFDLVARA
         60          70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.:::.:  ::.  :.. .:: . :::.   :  ::.     ::.....:.:: : .
2Z9D_B GVTFRYTENGPEGLVT-GKKAIVITSRGGIHK--DGPTDL--VTPYLSTFLGFIGITDVK
          120       130        140         150         160

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :
2Z9D_B FVFAEGIAYGPEMAAKAQSDAKAAIDSIVSA
     170       180       190       200



2Z9D_A Relative Identity: 25.4%E-value: 9.4e-11

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
                        : : ..  .:.:...:  : .: :   .:  . .:..:  ...
2Z9D_A    SKVLVLKSSILAGYSQSNQLSDYFVEQWREKHSADE-ITVRDLAANPIPVLDGELVG
                  10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       : .   .   :: ..:..    .:.. ..:. .. ::. :..:::: ..::.:.: .  :
2Z9D_A ALRP--SDAPLTPRQQEALALSDELIAELKAHDVIVIAAPMYNFNISTQLKNYFDLVARA
         60          70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.:::.:  ::.  :.. .:: . :::.   :  ::.     ::.....:.:: : .
2Z9D_A GVTFRYTENGPEGLVT-GKKAIVITSRGGIHK--DGPTDL--VTPYLSTFLGFIGITDVK
          120       130        140         150         160

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :
2Z9D_A FVFAEGIAYGPEMAAKAQSDAKAAIDSIVSA
     170       180       190       200



2D5I_A Relative Identity: 25.4%E-value: 9.4e-11

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
                        : : ..  .:.:...:  : .: :   .:  . .:..:  ...
2D5I_A    SKVLVLKSSILAGYSQSNQLSDYFVEQWREKHSADE-ITVRDLAANPIPVLDGELVG
                  10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       : .   .   :: ..:..    .:.. ..:. .. ::. :..:::: ..::.:.: .  :
2D5I_A ALRP--SDAPLTPRQQEALALSDELIAELKAHDVIVIAAPMYNFNISTQLKNYFDLVARA
         60          70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.:::.:  ::.  :.. .:: . :::.   :  ::.     ::.....:.:: : .
2D5I_A GVTFRYTENGPEGLVT-GKKAIVITSRGGIHK--DGPTDL--VTPYLSTFLGFIGITDVK
          120       130        140         150         160

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :
2D5I_A FVFAEGIAYGPEMAAKAQSDAKAAIDSIVSA
     170       180       190       200



2Z98_A Relative Identity: 25.4%E-value: 9.4e-11

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
                        : : ..  .:.:...:  : .: :   .:  . .:..:  ...
2Z98_A    SKVLVLKSSILAGYSQSNQLSDYFVEQWREKHSADE-ITVRDLAANPIPVLDGELVG
                  10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       : .   .   :: ..:..    .:.. ..:. .. ::. :..:::: ..::.:.: .  :
2Z98_A ALRP--SDAPLTPRQQEALALSDELIAELKAHDVIVIAAPMYNFNISTQLKNYFDLVARA
         60          70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.:::.:  ::.  :.. .:: . :::.   :  ::.     ::.....:.:: : .
2Z98_A GVTFRYTENGPEGLVT-GKKAIVITSRGGIHK--DGPTDL--VTPYLSTFLGFIGITDVK
          120       130        140         150         160

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :
2Z98_A FVFAEGIAYGPEMAAKAQSDAKAAIDSIVSA
     170       180       190       200



1V4B_A Relative Identity: 25.4%E-value: 9.4e-11

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
                        : : ..  .:.:...:  : .: :   .:  . .:..:  ...
1V4B_A    SKVLVLKSSILAGYSQSNQLSDYFVEQWREKHSADE-ITVRDLAANPIPVLDGELVG
                  10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       : .   .   :: ..:..    .:.. ..:. .. ::. :..:::: ..::.:.: .  :
1V4B_A ALRP--SDAPLTPRQQEALALSDELIAELKAHDVIVIAAPMYNFNISTQLKNYFDLVARA
         60          70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.:::.:  ::.  :.. .:: . :::.   :  ::.     ::.....:.:: : .
1V4B_A GVTFRYTENGPEGLVT-GKKAIVITSRGGIHK--DGPTDL--VTPYLSTFLGFIGITDVK
          120       130        140         150         160

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :
1V4B_A FVFAEGIAYGPEMAAKAQSDAKAAIDSIVSA
     170       180       190       200



2Z9B_A Relative Identity: 25.4%E-value: 9.4e-11

               10        20        30        40        50        60
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKTVLS
                        : : ..  .:.:...:  : .: :   .:  . .:..:  ...
2Z9B_A    SKVLVLKSSILAGYSQSNQLSDYFVEQWREKHSADE-ITVRDLAANPIPVLDGELVG
                  10        20        30         40        50

               70        80        90       100       110       120
QUERY  AWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMIA
       : .   .   :: ..:..    .:.. ..:. .. ::. :..:::: ..::.:.: .  :
2Z9B_A ALRP--SDAPLTPRQQEALALSDELIAELKAHDVIVIAAPMYNFNISTQLKNYFDLVARA
         60          70        80        90       100       110

              130       140       150       160       170       180
QUERY  RETFKYTETGSVGLLKDGRRMLVIQASGGIYTNDDWYTDVEYSHKYLKAMFNFLGIEDYQ
         ::.:::.:  ::.  :.. .:: . :::.   :  ::.     ::.....:.:: : .
2Z9B_A GVTFRYTENGPEGLVT-GKKAIVITSRGGIHK--DGPTDL--VTPYLSTFLGFIGITDVK
          120       130        140         150         160

              190       200       210       220
QUERY  IVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .: :.: :
2Z9B_A FVFAEGIAYGPEMAAKAQSDAKAAIDSIVSA
     170       180       190       200



3KEG_A Relative Identity: 18.7%E-value: 0.0002

               10        20        30        40        50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT-VL
       :.. : ..: :. .   : : .. . :: .:.:    .  . . ..    .: . .. :
3KEG_A MSRILAVHASPRGE--RSQSRRLAEVFLAAYRE-AHPQARVARREVGRVPLPAVTEAFVA
               10          20        30         40        50

      60        70        80        90       100       110
QUERY  SAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMI
       .:.. : . . :. . . .    .... .. ...  ::  :..::..:: :: ..:.:.
3KEG_A AAFHPQPEQRSLAMQADLALS--DQLVGELFDSDLLVISTPMYNFSVPSGLKAWIDQIVR
        60        70          80        90       100       110

     120       130          140       150        160       170
QUERY  ARETFKYTETGSVGLLKD---GRRMLVIQASGGI-YTNDDWYTDVEYSHKYLKAMFNFLG
          :: ..  ..:. ..    :.: :.. . ::  .        ....  .:.. ..:.:
3KEG_A LGVTFDFVLDNGVAQFRPLLRGKRALIVTSRGGHGFGPGGENQAMNHADPWLRTALGFIG
         120       130       140       150       160       170

         180       190       200       210       220
QUERY  IEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       :..  .: :.:
3KEG_A IDEVTVVAAEGEESGGRSFEDSCDEAEQRLLALARSA
         180       190       200       210



3KEG_B Relative Identity: 18.7%E-value: 0.0002

               10        20        30        40        50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT-VL
       :.. : ..: :. .   : : .. . :: .:.:    .  . . ..    .: . .. :
3KEG_B MSRILAVHASPRGE--RSQSRRLAEVFLAAYRE-AHPQARVARREVGRVPLPAVTEAFVA
               10          20        30         40        50

      60        70        80        90       100       110
QUERY  SAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMI
       .:.. : . . :. . . .    .... .. ...  ::  :..::..:: :: ..:.:.
3KEG_B AAFHPQPEQRSLAMQADLALS--DQLVGELFDSDLLVISTPMYNFSVPSGLKAWIDQIVR
        60        70          80        90       100       110

     120       130          140       150        160       170
QUERY  ARETFKYTETGSVGLLKD---GRRMLVIQASGGI-YTNDDWYTDVEYSHKYLKAMFNFLG
          :: ..  ..:. ..    :.: :.. . ::  .        ....  .:.. ..:.:
3KEG_B LGVTFDFVLDNGVAQFRPLLRGKRALIVTSRGGHGFGPGGENQAMNHADPWLRTALGFIG
         120       130       140       150       160       170

         180       190       200       210       220
QUERY  IEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       :..  .: :.:
3KEG_B IDEVTVVAAEGEESGGRSFEDSCDEAEQRLLALARSA
         180       190       200       210



3R6W_A Relative Identity: 19.5%E-value: 0.00026

               10        20        30        40        50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT-VL
       :.. : ..: :. .   : : .. . :: .:.:    .  . . ..    .: . .. :
3R6W_A MSRILAVHASPRGE--RSQSRRLAEVFLAAYRE-AHPQARVARREVGRVPLPAVTEAFVA
               10          20        30         40        50

      60        70        80        90       100       110
QUERY  SAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMI
       .:.. : . . :. . . .    .... .. ...  ::  :..::..:: :: ..:.:.
3R6W_A AAFHPQPEQRSLAMQADLALS--DQLVGELFDSDLLVISTPMYNFSVPSGLKAWIDQIVR
        60        70          80        90       100       110

     120       130           140       150        160       170
QUERY  ARETFKYTETGSVG----LLKDGRRMLVIQASGGI-YTNDDWYTDVEYSHKYLKAMFNFL
          :: ..  ..:.    ::. :.: :.. . ::  .        ....  .:.. ..:.
3R6W_A LGVTFDFVLDNGVAQYRPLLR-GKRALIVTSRGGHGFGPGGENQAMNHADPWLRTALGFI
         120       130        140       150       160       170

          180       190       200       210       220
QUERY  GIEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ::..  .: :.:
3R6W_A GIDEVTVVAAEGEESGGRSFEDSCDEAEQRLLALARSA
          180       190       200       210



3R6W_B Relative Identity: 19.5%E-value: 0.00026

               10        20        30        40        50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT-VL
       :.. : ..: :. .   : : .. . :: .:.:    .  . . ..    .: . .. :
3R6W_B MSRILAVHASPRGE--RSQSRRLAEVFLAAYRE-AHPQARVARREVGRVPLPAVTEAFVA
               10          20        30         40        50

      60        70        80        90       100       110
QUERY  SAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMI
       .:.. : . . :. . . .    .... .. ...  ::  :..::..:: :: ..:.:.
3R6W_B AAFHPQPEQRSLAMQADLALS--DQLVGELFDSDLLVISTPMYNFSVPSGLKAWIDQIVR
        60        70          80        90       100       110

     120       130           140       150        160       170
QUERY  ARETFKYTETGSVG----LLKDGRRMLVIQASGGI-YTNDDWYTDVEYSHKYLKAMFNFL
          :: ..  ..:.    ::. :.: :.. . ::  .        ....  .:.. ..:.
3R6W_B LGVTFDFVLDNGVAQYRPLLR-GKRALIVTSRGGHGFGPGGENQAMNHADPWLRTALGFI
         120       130        140       150       160       170

          180       190       200       210       220
QUERY  GIEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ::..  .: :.:
3R6W_B GIDEVTVVAAEGEESGGRSFEDSCDEAEQRLLALARSA
          180       190       200       210



3LT5_A Relative Identity: 19.5%E-value: 0.00026

               10        20        30        40        50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT-VL
       :.. : ..: :. .   : : .. . :: .:.:    .  . . ..    .: . .. :
3LT5_A MSRILAVHASPRGE--RSQSRRLAEVFLAAYRE-AHPQARVARREVGRVPLPAVTEAFVA
               10          20        30         40        50

      60        70        80        90       100       110
QUERY  SAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMI
       .:.. : . . :. . . .    .... .. ...  ::  :..::..:: :: ..:.:.
3LT5_A AAFHPQPEQRSLAMQADLALS--DQLVGELFDSDLLVISTPMYNFSVPSGLKAWIDQIVR
        60        70          80        90       100       110

     120       130           140       150        160       170
QUERY  ARETFKYTETGSVG----LLKDGRRMLVIQASGGI-YTNDDWYTDVEYSHKYLKAMFNFL
          :: ..  ..:.    ::. :.: :.. . ::  .        ....  .:.. ..:.
3LT5_A LGVTFDFVLDNGVAQYRPLLR-GKRALIVTSRGGHGFGPGGENQAMNHADPWLRTALGFI
         120       130        140       150       160       170

          180       190       200       210       220
QUERY  GIEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ::..  .: :.:
3LT5_A GIDEVTVVAAEGEESGGRSFEDSCDEAEQRLLALARSA
          180       190       200       210



3LT5_B Relative Identity: 19.5%E-value: 0.00026

               10        20        30        40        50
QUERY  MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT-VL
       :.. : ..: :. .   : : .. . :: .:.:    .  . . ..    .: . .. :
3LT5_B MSRILAVHASPRGE--RSQSRRLAEVFLAAYRE-AHPQARVARREVGRVPLPAVTEAFVA
               10          20        30         40        50

      60        70        80        90       100       110
QUERY  SAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDNIMI
       .:.. : . . :. . . .    .... .. ...  ::  :..::..:: :: ..:.:.
3LT5_B AAFHPQPEQRSLAMQADLALS--DQLVGELFDSDLLVISTPMYNFSVPSGLKAWIDQIVR
        60        70          80        90       100       110

     120       130           140       150        160       170
QUERY  ARETFKYTETGSVG----LLKDGRRMLVIQASGGI-YTNDDWYTDVEYSHKYLKAMFNFL
          :: ..  ..:.    ::. :.: :.. . ::  .        ....  .:.. ..:.
3LT5_B LGVTFDFVLDNGVAQYRPLLR-GKRALIVTSRGGHGFGPGGENQAMNHADPWLRTALGFI
         120       130        140       150       160       170

          180       190       200       210       220
QUERY  GIEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       ::..  .: :.:
3LT5_B GIDEVTVVAAEGEESGGRSFEDSCDEAEQRLLALARSA
          180       190       200       210



2V9C_B Relative Identity: 19.5%E-value: 0.00027

                  10        20        30        40        50
QUERY     MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
          :.. : ..: :. .   : : .. . :: .:.:    .  . . ..    .: . ..
2V9C_B GSHMSRILAVHASPRGE--RSQSRRLAEVFLAAYRE-AHPQARVARREVGRVPLPAVTEA
               10          20        30         40        50

         60        70        80        90       100       110
QUERY  -VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDN
        : .:.. : . . :. . . .    .... .. ...  ::  :..::..:: :: ..:.
2V9C_B FVAAAFHPQPEQRSLAMQADLALS--DQLVGELFDSDLLVISTPMYNFSVPSGLKAWIDQ
        60        70        80          90       100       110

        120       130           140       150        160       170
QUERY  IMIARETFKYTETGSVG----LLKDGRRMLVIQASGGI-YTNDDWYTDVEYSHKYLKAMF
       :.    :: ..  ..:.    ::. :.: :.. . ::  .        ....  .:.. .
2V9C_B IVRLGVTFDFVLDNGVAQYRPLLR-GKRALIVTSRGGHGFGPGGENQAMNHADPWLRTAL
         120       130        140       150       160       170

             180       190       200       210       220
QUERY  NFLGIEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .:.::..  .: :.:
2V9C_B GFIGIDEVTVVAAEGEESGGRSFEDSCDEAEQRLLALARSA
          180       190       200       210



2V9C_A Relative Identity: 19.5%E-value: 0.00027

                  10        20        30        40        50
QUERY     MNKTLIINAHPKVDDTSSVSIKVFKHFLESYKELISNNETIEQINLYDDVVPMIDKT
          :.. : ..: :. .   : : .. . :: .:.:    .  . . ..    .: . ..
2V9C_A GSHMSRILAVHASPRGE--RSQSRRLAEVFLAAYRE-AHPQARVARREVGRVPLPAVTEA
               10          20        30         40        50

         60        70        80        90       100       110
QUERY  -VLSAWEKQGNGQELTREEQKVTERMSEILQQFKSANTYVIVLPLHNFNIPSKLKDYMDN
        : .:.. : . . :. . . .    .... .. ...  ::  :..::..:: :: ..:.
2V9C_A FVAAAFHPQPEQRSLAMQADLALS--DQLVGELFDSDLLVISTPMYNFSVPSGLKAWIDQ
        60        70        80          90       100       110

        120       130           140       150        160       170
QUERY  IMIARETFKYTETGSVG----LLKDGRRMLVIQASGGI-YTNDDWYTDVEYSHKYLKAMF
       :.    :: ..  ..:.    ::. :.: :.. . ::  .        ....  .:.. .
2V9C_A IVRLGVTFDFVLDNGVAQYRPLLR-GKRALIVTSRGGHGFGPGGENQAMNHADPWLRTAL
         120       130        140       150       160       170

             180       190       200       210       220
QUERY  NFLGIEDYQIVRAQGTAVLDPTEVLQNAYKEVEEAASRLANKYIFSLEE
       .:.::..  .: :.:
2V9C_A GFIGIDEVTVVAAEGEESGGRSFEDSCDEAEQRLLALARSA
          180       190       200       210




(default) 23 queries took 36 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT "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
2SELECT "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."cell_wall" AS "Target__cell_wall", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."ins_user_id" AS "Target__ins_user_id", "Target"."upd_user_id" AS "Target__upd_user_id", "Target"."stage" AS "Target__stage", "Target"."hidden" AS "Target__hidden", "Target"."submitter_id" AS "Target__submitter_id", "Target"."selection_db_id" AS "Target__selection_db_id", "Target"."dna_source_taxon_id" AS "Target__dna_source_taxon_id", "Target"."batch" AS "Target__batch", "Target"."genus_taxon_id" AS "Target__genus_taxon_id", "Target"."seguid" AS "Target__seguid", "Target"."uniprot_id" AS "Target__uniprot_id", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."ec" AS "Target__ec", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."type" AS "Target__type", (EXISTS(SELECT 1 FROM vs_assay WHERE "Target"."target_id" = "vs_assay"."target_id")) AS "Target__has_screening", "Project"."protein_target_id" AS "Project__protein_target_id", "Project"."pdb_id" AS "Project__pdb_id", "Project"."chain_id" AS "Project__chain_id", "Project"."sequence_identity" AS "Project__sequence_identity", "Project"."organism" AS "Project__organism", "TigrMainRole"."id" AS "TigrMainRole__id", "TigrMainRole"."name" AS "TigrMainRole__name", "TigrSubRole"."id" AS "TigrSubRole__id", "TigrSubRole"."name" AS "TigrSubRole__name", "Organism"."tax_id" AS "Organism__tax_id", "Organism"."name_text" AS "Organism__name_text", "Organism"."unique_name" AS "Organism__unique_name", "Organism"."name_class" AS "Organism__name_class", "Species"."tax_id" AS "Species__tax_id", "Species"."name_text" AS "Species__name_text", "Species"."unique_name" AS "Species__unique_name", "Species"."name_class" AS "Species__name_class", "Stage"."sequence" AS "Stage__sequence", "Stage"."name" AS "Stage__name", "ProteinPdbHomolog"."protein_target_id" AS "ProteinPdbHomolog__protein_target_id", "ProteinPdbHomolog"."pdb_id" AS "ProteinPdbHomolog__pdb_id", "ProteinPdbHomolog"."chain_id" AS "ProteinPdbHomolog__chain_id", "ProteinPdbHomolog"."sequence_identity" AS "ProteinPdbHomolog__sequence_identity", "ProteinPdbHomolog"."organism" AS "ProteinPdbHomolog__organism", "RequestTarget"."id" AS "RequestTarget__id", "RequestTarget"."gi" AS "RequestTarget__gi", "RequestTarget"."ncbi_accver" AS "RequestTarget__ncbi_accver", "RequestTarget"."sequence" AS "RequestTarget__sequence", "RequestTarget"."ncbi_taxon_id" AS "RequestTarget__ncbi_taxon_id", "RequestTarget"."organism" AS "RequestTarget__organism", "RequestTarget"."comment" AS "RequestTarget__comment", "RequestTarget"."person_id" AS "RequestTarget__person_id", "RequestTarget"."justification" AS "RequestTarget__justification", "RequestTarget"."resources" AS "RequestTarget__resources", "RequestTarget"."agreement_clicked" AS "RequestTarget__agreement_clicked", "RequestTarget"."approved" AS "RequestTarget__approved", "RequestTarget"."target_id" AS "RequestTarget__target_id", "RequestTarget"."inserted" AS "RequestTarget__inserted", "RequestTarget"."updated" AS "RequestTarget__updated", "RequestTarget"."dna_sequence" AS "RequestTarget__dna_sequence", "RequestTarget"."dna_source" AS "RequestTarget__dna_source", "RequestTarget"."dna_source_taxon_id" AS "RequestTarget__dna_source_taxon_id", "RequestTarget"."center" AS "RequestTarget__center", "RequestTarget"."community_interest" AS "RequestTarget__community_interest", "TargetPlanning"."id" AS "TargetPlanning__id", "TargetPlanning"."target_id" AS "TargetPlanning__target_id", "TargetPlanning"."source_file" AS "TargetPlanning__source_file", "TargetPlanning"."target_type" AS "TargetPlanning__target_type", "TargetPlanning"."genomic_dna_source" AS "TargetPlanning__genomic_dna_source", "TargetPlanning"."genomic_dna_status" AS "TargetPlanning__genomic_dna_status", "TargetPlanning"."notes1" AS "TargetPlanning__notes1", "TargetPlanning"."id1" AS "TargetPlanning__id1", "TargetPlanning"."notes2" AS "TargetPlanning__notes2", "TargetPlanning"."id2" AS "TargetPlanning__id2", "TargetPlanning"."ortholog_rescue" AS "TargetPlanning__ortholog_rescue", "TargetPlanning"."codon_optimization" AS "TargetPlanning__codon_optimization", "TargetPlanning"."should_solve_structure" AS "TargetPlanning__should_solve_structure", "TargetPlanning"."inserted" AS "TargetPlanning__inserted", "TargetPlanning"."updated" AS "TargetPlanning__updated", "TargetPlanning"."operon_colocalization" AS "TargetPlanning__operon_colocalization" FROM "protein_target" AS "Target" LEFT JOIN "protein_pdb_homolog_table" AS "Project" ON ("Target"."target_id" = "Project"."protein_target_id") LEFT JOIN "tigr_main_roles" AS "TigrMainRole" ON ("Target"."tigr_main_role_id" = "TigrMainRole"."id") LEFT JOIN "tigr_sub_roles" AS "TigrSubRole" ON ("Target"."tigr_sub_role_id" = "TigrSubRole"."id") LEFT JOIN "names" AS "Organism" ON ("Target"."ncbi_taxon_id" = "Organism"."tax_id" AND "Organism"."name_class" = 'scientific name') LEFT JOIN "names" AS "Species" ON ("Target"."species_taxon_id" = "Species"."tax_id" AND "Species"."name_class" = 'scientific name') LEFT JOIN "stage" AS "Stage" ON ("Target"."stage" = "Stage"."name") LEFT JOIN "protein_pdb_homolog_table" AS "ProteinPdbHomolog" ON ("ProteinPdbHomolog"."protein_target_id" = "Target"."target_id") LEFT JOIN "request_target" AS "RequestTarget" ON ("RequestTarget"."target_id" = "Target"."target_id") LEFT JOIN "target_planning" AS "TargetPlanning" ON ("TargetPlanning"."target_id" = "Target"."target_id") WHERE "Target"."target_id" = 'IDP02263' LIMIT 10113
3SELECT "SubTarget"."id" AS "SubTarget__id", "SubTarget"."target_id" AS "SubTarget__target_id", "SubTarget"."sequence_start" AS "SubTarget__sequence_start", "SubTarget"."sequence_end" AS "SubTarget__sequence_end", "SubTarget"."mutation" AS "SubTarget__mutation", "SubTarget"."sequence" AS "SubTarget__sequence", "SubTarget"."dna_sequence" AS "SubTarget__dna_sequence", "SubTarget"."sequence_comments" AS "SubTarget__sequence_comments", "SubTarget"."date_selected" AS "SubTarget__date_selected", "SubTarget"."priority" AS "SubTarget__priority", "SubTarget"."inserted" AS "SubTarget__inserted", "SubTarget"."updated" AS "SubTarget__updated", "SubTarget"."type" AS "SubTarget__type", "SubTarget"."batch" AS "SubTarget__batch", "SubTarget"."predicted_cox_ligand" AS "SubTarget__predicted_cox_ligand" FROM "protein_subtarget" AS "SubTarget" WHERE "SubTarget"."target_id" = ('IDP02263') 010
4SELECT "ProteinClone"."id" AS "ProteinClone__id", "ProteinClone"."target_id" AS "ProteinClone__target_id", "ProteinClone"."clone_suffix" AS "ProteinClone__clone_suffix", "ProteinClone"."sequence_start" AS "ProteinClone__sequence_start", "ProteinClone"."sequence_end" AS "ProteinClone__sequence_end", "ProteinClone"."sequence" AS "ProteinClone__sequence", "ProteinClone"."sequence_comments" AS "ProteinClone__sequence_comments", "ProteinClone"."local_protein_target_id" AS "ProteinClone__local_protein_target_id", "ProteinClone"."local_clone_plate_id" AS "ProteinClone__local_clone_plate_id", "ProteinClone"."local_clone_id" AS "ProteinClone__local_clone_id", "ProteinClone"."experiment_date_start" AS "ProteinClone__experiment_date_start", "ProteinClone"."experiment_date_end" AS "ProteinClone__experiment_date_end", "ProteinClone"."staff_id" AS "ProteinClone__staff_id", "ProteinClone"."other_people" AS "ProteinClone__other_people", "ProteinClone"."lab_id" AS "ProteinClone__lab_id", "ProteinClone"."protocol_id" AS "ProteinClone__protocol_id", "ProteinClone"."status" AS "ProteinClone__status", "ProteinClone"."vector" AS "ProteinClone__vector", "ProteinClone"."pcr_primer_forward" AS "ProteinClone__pcr_primer_forward", "ProteinClone"."pcr_primer_backward" AS "ProteinClone__pcr_primer_backward", "ProteinClone"."shipped_to_lab_id" AS "ProteinClone__shipped_to_lab_id", "ProteinClone"."shipped_date" AS "ProteinClone__shipped_date", "ProteinClone"."inserted" AS "ProteinClone__inserted", "ProteinClone"."ins_user_id" AS "ProteinClone__ins_user_id", "ProteinClone"."update" AS "ProteinClone__update", "ProteinClone"."upd_user_id" AS "ProteinClone__upd_user_id", "ProteinClone"."secondary_shipped_to_lab_id" AS "ProteinClone__secondary_shipped_to_lab_id", "ProteinClone"."secondary_shipped_date" AS "ProteinClone__secondary_shipped_date", "ProteinClone"."external_source" AS "ProteinClone__external_source", "ProteinClone"."mutation" AS "ProteinClone__mutation", "ProteinClone"."bei_available" AS "ProteinClone__bei_available", "ProteinClone"."bei_number" AS "ProteinClone__bei_number", "ProteinClone"."reference_sequence_variance" AS "ProteinClone__reference_sequence_variance", "ProteinClone"."confirmed_dna_sequence" AS "ProteinClone__confirmed_dna_sequence", "ProteinClone"."confirmed_protein_sequence" AS "ProteinClone__confirmed_protein_sequence", "ProteinClone"."present_in_lims" AS "ProteinClone__present_in_lims", "ProteinClone"."template_dna_sequence" AS "ProteinClone__template_dna_sequence", "ProteinClone"."lims_date" AS "ProteinClone__lims_date", "ProteinClone"."dummy" AS "ProteinClone__dummy" FROM "clone" AS "ProteinClone" WHERE "ProteinClone"."target_id" = ('IDP02263') 010
5SELECT "Purification"."id" AS "Purification__id", "Purification"."target_id" AS "Purification__target_id", "Purification"."purification_suffix" AS "Purification__purification_suffix", "Purification"."expression_id" AS "Purification__expression_id", "Purification"."local_expression_id" AS "Purification__local_expression_id", "Purification"."local_protein_target_id" AS "Purification__local_protein_target_id", "Purification"."local_purification_id" AS "Purification__local_purification_id", "Purification"."experiment_date_start" AS "Purification__experiment_date_start", "Purification"."experiment_date_end" AS "Purification__experiment_date_end", "Purification"."staff_id" AS "Purification__staff_id", "Purification"."other_people" AS "Purification__other_people", "Purification"."lab_id" AS "Purification__lab_id", "Purification"."protocol_id" AS "Purification__protocol_id", "Purification"."status" AS "Purification__status", "Purification"."description" AS "Purification__description", "Purification"."affinity_tag_status" AS "Purification__affinity_tag_status", "Purification"."semet_status" AS "Purification__semet_status", "Purification"."covalent_modification" AS "Purification__covalent_modification", "Purification"."final_buffer" AS "Purification__final_buffer", "Purification"."final_concentration" AS "Purification__final_concentration", "Purification"."final_volume" AS "Purification__final_volume", "Purification"."shipped_to_lab_id" AS "Purification__shipped_to_lab_id", "Purification"."shipped_date" AS "Purification__shipped_date", "Purification"."inserted" AS "Purification__inserted", "Purification"."ins_user_id" AS "Purification__ins_user_id", "Purification"."update" AS "Purification__update", "Purification"."upd_user_id" AS "Purification__upd_user_id", "Purification"."present_in_lims" AS "Purification__present_in_lims", "Purification"."lims_date" AS "Purification__lims_date", "Purification"."dummy" AS "Purification__dummy", "Purification"."yield" AS "Purification__yield" FROM "purification" AS "Purification" WHERE "Purification"."target_id" = ('IDP02263') 030
6SELECT "Expression"."id" AS "Expression__id", "Expression"."target_id" AS "Expression__target_id", "Expression"."expression_suffix" AS "Expression__expression_suffix", "Expression"."clone_id" AS "Expression__clone_id", "Expression"."clone_suffix" AS "Expression__clone_suffix", "Expression"."local_clone_id" AS "Expression__local_clone_id", "Expression"."local_protein_target_id" AS "Expression__local_protein_target_id", "Expression"."local_expression_id" AS "Expression__local_expression_id", "Expression"."experiment_date_start" AS "Expression__experiment_date_start", "Expression"."experiment_date_end" AS "Expression__experiment_date_end", "Expression"."staff_id" AS "Expression__staff_id", "Expression"."other_people" AS "Expression__other_people", "Expression"."lab_id" AS "Expression__lab_id", "Expression"."protocol_id" AS "Expression__protocol_id", "Expression"."status" AS "Expression__status", "Expression"."expression_organism" AS "Expression__expression_organism", "Expression"."expression_strain" AS "Expression__expression_strain", "Expression"."media_type" AS "Expression__media_type", "Expression"."media_volume" AS "Expression__media_volume", "Expression"."growth_temperature" AS "Expression__growth_temperature", "Expression"."induction_temperature" AS "Expression__induction_temperature", "Expression"."induction_reagent" AS "Expression__induction_reagent", "Expression"."experiment_type" AS "Expression__experiment_type", "Expression"."expression_level" AS "Expression__expression_level", "Expression"."solubility_level" AS "Expression__solubility_level", "Expression"."inserted" AS "Expression__inserted", "Expression"."ins_user_id" AS "Expression__ins_user_id", "Expression"."update" AS "Expression__update", "Expression"."upd_user_id" AS "Expression__upd_user_id", "Expression"."present_in_lims" AS "Expression__present_in_lims", "Expression"."lims_date" AS "Expression__lims_date", "Expression"."dummy" AS "Expression__dummy" FROM "expression" AS "Expression" WHERE "Expression"."target_id" = ('IDP02263') 020
7SELECT "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" FROM "deposit" AS "Deposit" WHERE "Deposit"."target_id" = ('IDP02263') 011
8SELECT "Dataset"."id" AS "Dataset__id", "Dataset"."target_id" AS "Dataset__target_id", "Dataset"."crystal_harvest_id" AS "Dataset__crystal_harvest_id", "Dataset"."structure_solution_id" AS "Dataset__structure_solution_id", "Dataset"."experiment_date" AS "Dataset__experiment_date", "Dataset"."staff_id" AS "Dataset__staff_id", "Dataset"."other_people" AS "Dataset__other_people", "Dataset"."lab_id" AS "Dataset__lab_id", "Dataset"."detector_id" AS "Dataset__detector_id", "Dataset"."beamline_id" AS "Dataset__beamline_id", "Dataset"."sca_filename" AS "Dataset__sca_filename", "Dataset"."sca_uploaded" AS "Dataset__sca_uploaded", "Dataset"."wavelength" AS "Dataset__wavelength", "Dataset"."wavelength_type" AS "Dataset__wavelength_type", "Dataset"."diffraction_resolution" AS "Dataset__diffraction_resolution", "Dataset"."experiment_temperature" AS "Dataset__experiment_temperature", "Dataset"."a" AS "Dataset__a", "Dataset"."b" AS "Dataset__b", "Dataset"."c" AS "Dataset__c", "Dataset"."alpha" AS "Dataset__alpha", "Dataset"."beta" AS "Dataset__beta", "Dataset"."gamma" AS "Dataset__gamma", "Dataset"."z" AS "Dataset__z", "Dataset"."matthew_coeff" AS "Dataset__matthew_coeff", "Dataset"."spacegroup" AS "Dataset__spacegroup", "Dataset"."sca_number_reflns_obs" AS "Dataset__sca_number_reflns_obs", "Dataset"."sca_rmerge_i_obs" AS "Dataset__sca_rmerge_i_obs", "Dataset"."sca_chi_squared" AS "Dataset__sca_chi_squared", "Dataset"."sca_redundancy" AS "Dataset__sca_redundancy", "Dataset"."sca_shell_rmerge_i_obs" AS "Dataset__sca_shell_rmerge_i_obs", "Dataset"."sca_shell_chi_squared" AS "Dataset__sca_shell_chi_squared", "Dataset"."sca_shell_redundancy" AS "Dataset__sca_shell_redundancy", "Dataset"."sca_average_i" AS "Dataset__sca_average_i", "Dataset"."sca_average_i_sigma" AS "Dataset__sca_average_i_sigma", "Dataset"."sca_shell_i" AS "Dataset__sca_shell_i", "Dataset"."sca_shell_i_sigma" AS "Dataset__sca_shell_i_sigma", "Dataset"."data_collection_program_id" AS "Dataset__data_collection_program_id", "Dataset"."data_collection_programs_other" AS "Dataset__data_collection_programs_other", "Dataset"."data_scaling_program_id" AS "Dataset__data_scaling_program_id", "Dataset"."data_scaling_programs_other" AS "Dataset__data_scaling_programs_other", "Dataset"."intensity_integration_program_id" AS "Dataset__intensity_integration_program_id", "Dataset"."intensity_integration_programs_other" AS "Dataset__intensity_integration_programs_other", "Dataset"."shipped_to_lab_id" AS "Dataset__shipped_to_lab_id", "Dataset"."shipped_date" AS "Dataset__shipped_date", "Dataset"."inserted" AS "Dataset__inserted", "Dataset"."ins_user_id" AS "Dataset__ins_user_id", "Dataset"."update" AS "Dataset__update", "Dataset"."upd_user_id" AS "Dataset__upd_user_id", "Dataset"."sca_shell_res_low" AS "Dataset__sca_shell_res_low", "Dataset"."sca_shell_res_high" AS "Dataset__sca_shell_res_high", "Dataset"."sca_number_reflns_all" AS "Dataset__sca_number_reflns_all", "Dataset"."local_protein_target_id" AS "Dataset__local_protein_target_id", "Dataset"."local_dataset_id" AS "Dataset__local_dataset_id", "Dataset"."local_crystal_harvest_id" AS "Dataset__local_crystal_harvest_id", "Dataset"."dataset_suffix" AS "Dataset__dataset_suffix", "Dataset"."present_in_lims" AS "Dataset__present_in_lims" FROM "dataset" AS "Dataset" WHERE "Dataset"."target_id" = ('IDP02263') 011
9SELECT "Screening"."id" AS "Screening__id", "Screening"."target_id" AS "Screening__target_id", "Screening"."pdb_id" AS "Screening__pdb_id", "Screening"."chain_id" AS "Screening__chain_id", "Screening"."surface_id" AS "Screening__surface_id", "Screening"."method" AS "Screening__method", "Screening"."surface_pdb_file" AS "Screening__surface_pdb_file", "Screening"."docking_file" AS "Screening__docking_file", "Screening"."date_started" AS "Screening__date_started", "Screening"."date_ended" AS "Screening__date_ended", "Screening"."staff_id" AS "Screening__staff_id", "Screening"."inserted" AS "Screening__inserted", "Screening"."updated" AS "Screening__updated", "Screening"."run_id" AS "Screening__run_id", "Screening"."library_id" AS "Screening__library_id", (SELECT COUNT(*) FROM vs_assay_data WHERE "vs_assay_data"."vs_assay_id" = "Screening"."id") AS "Screening__compounds_count", (SELECT conc_comma("substance_name") FROM "hts"."vs_assay_data" WHERE rank < 5 AND vs_assay_id = "Screening"."id") AS "Screening__top_hits" FROM "vs_assay" AS "Screening" WHERE "Screening"."target_id" = ('IDP02263') 033
10SELECT "CrystalHarvest"."id" AS "CrystalHarvest__id", "CrystalHarvest"."target_id" AS "CrystalHarvest__target_id", "CrystalHarvest"."crystal_harvest_suffix" AS "CrystalHarvest__crystal_harvest_suffix", "CrystalHarvest"."crystallization_drop_id" AS "CrystalHarvest__crystallization_drop_id", "CrystalHarvest"."local_crystallization_drop_id" AS "CrystalHarvest__local_crystallization_drop_id", "CrystalHarvest"."local_protein_target_id" AS "CrystalHarvest__local_protein_target_id", "CrystalHarvest"."local_crystal_harvest_id" AS "CrystalHarvest__local_crystal_harvest_id", "CrystalHarvest"."experiment_date" AS "CrystalHarvest__experiment_date", "CrystalHarvest"."staff_id" AS "CrystalHarvest__staff_id", "CrystalHarvest"."other_people" AS "CrystalHarvest__other_people", "CrystalHarvest"."lab_id" AS "CrystalHarvest__lab_id", "CrystalHarvest"."protocol_id" AS "CrystalHarvest__protocol_id", "CrystalHarvest"."cryo_solution" AS "CrystalHarvest__cryo_solution", "CrystalHarvest"."soaking_solution" AS "CrystalHarvest__soaking_solution", "CrystalHarvest"."ligand" AS "CrystalHarvest__ligand", "CrystalHarvest"."diffraction_limit" AS "CrystalHarvest__diffraction_limit", "CrystalHarvest"."crystal_quality" AS "CrystalHarvest__crystal_quality", "CrystalHarvest"."shipped_to_lab_id" AS "CrystalHarvest__shipped_to_lab_id", "CrystalHarvest"."shipped_date" AS "CrystalHarvest__shipped_date", "CrystalHarvest"."inserted" AS "CrystalHarvest__inserted", "CrystalHarvest"."ins_user_id" AS "CrystalHarvest__ins_user_id", "CrystalHarvest"."update" AS "CrystalHarvest__update", "CrystalHarvest"."upd_user_id" AS "CrystalHarvest__upd_user_id", "CrystalHarvest"."final_pdb_id" AS "CrystalHarvest__final_pdb_id", "CrystalHarvest"."present_in_lims" AS "CrystalHarvest__present_in_lims", "CrystalHarvest"."lims_date" AS "CrystalHarvest__lims_date", "CrystalHarvest"."dummy" AS "CrystalHarvest__dummy" FROM "crystal_harvest" AS "CrystalHarvest" WHERE "CrystalHarvest"."target_id" = ('IDP02263') 020
11SELECT "Justification"."id" AS "Justification__id", "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "JustificationCodeProteinTarget"."id" AS "JustificationCodeProteinTarget__id", "JustificationCodeProteinTarget"."target_id" AS "JustificationCodeProteinTarget__target_id", "JustificationCodeProteinTarget"."justification_code_id" AS "JustificationCodeProteinTarget__justification_code_id" FROM "justification_code" AS "Justification" JOIN "justification_code_map" AS "JustificationCodeProteinTarget" ON ("JustificationCodeProteinTarget"."target_id" = 'IDP02263' AND "JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") 000
12SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP02263' 000
13SELECT "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."cell_wall" AS "Target__cell_wall", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."ins_user_id" AS "Target__ins_user_id", "Target"."upd_user_id" AS "Target__upd_user_id", "Target"."stage" AS "Target__stage", "Target"."hidden" AS "Target__hidden", "Target"."submitter_id" AS "Target__submitter_id", "Target"."selection_db_id" AS "Target__selection_db_id", "Target"."dna_source_taxon_id" AS "Target__dna_source_taxon_id", "Target"."batch" AS "Target__batch", "Target"."genus_taxon_id" AS "Target__genus_taxon_id", "Target"."seguid" AS "Target__seguid", "Target"."uniprot_id" AS "Target__uniprot_id", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."ec" AS "Target__ec", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."type" AS "Target__type", (EXISTS(SELECT 1 FROM vs_assay WHERE "Target"."target_id" = "vs_assay"."target_id")) AS "Target__has_screening", "Project"."protein_target_id" AS "Project__protein_target_id", "Project"."pdb_id" AS "Project__pdb_id", "Project"."chain_id" AS "Project__chain_id", "Project"."sequence_identity" AS "Project__sequence_identity", "Project"."organism" AS "Project__organism", "TigrMainRole"."id" AS "TigrMainRole__id", "TigrMainRole"."name" AS "TigrMainRole__name", "TigrSubRole"."id" AS "TigrSubRole__id", "TigrSubRole"."name" AS "TigrSubRole__name", "Organism"."tax_id" AS "Organism__tax_id", "Organism"."name_text" AS "Organism__name_text", "Organism"."unique_name" AS "Organism__unique_name", "Organism"."name_class" AS "Organism__name_class", "Species"."tax_id" AS "Species__tax_id", "Species"."name_text" AS "Species__name_text", "Species"."unique_name" AS "Species__unique_name", "Species"."name_class" AS "Species__name_class", "Stage"."sequence" AS "Stage__sequence", "Stage"."name" AS "Stage__name", "ProteinPdbHomolog"."protein_target_id" AS "ProteinPdbHomolog__protein_target_id", "ProteinPdbHomolog"."pdb_id" AS "ProteinPdbHomolog__pdb_id", "ProteinPdbHomolog"."chain_id" AS "ProteinPdbHomolog__chain_id", "ProteinPdbHomolog"."sequence_identity" AS "ProteinPdbHomolog__sequence_identity", "ProteinPdbHomolog"."organism" AS "ProteinPdbHomolog__organism", "RequestTarget"."id" AS "RequestTarget__id", "RequestTarget"."gi" AS "RequestTarget__gi", "RequestTarget"."ncbi_accver" AS "RequestTarget__ncbi_accver", "RequestTarget"."sequence" AS "RequestTarget__sequence", "RequestTarget"."ncbi_taxon_id" AS "RequestTarget__ncbi_taxon_id", "RequestTarget"."organism" AS "RequestTarget__organism", "RequestTarget"."comment" AS "RequestTarget__comment", "RequestTarget"."person_id" AS "RequestTarget__person_id", "RequestTarget"."justification" AS "RequestTarget__justification", "RequestTarget"."resources" AS "RequestTarget__resources", "RequestTarget"."agreement_clicked" AS "RequestTarget__agreement_clicked", "RequestTarget"."approved" AS "RequestTarget__approved", "RequestTarget"."target_id" AS "RequestTarget__target_id", "RequestTarget"."inserted" AS "RequestTarget__inserted", "RequestTarget"."updated" AS "RequestTarget__updated", "RequestTarget"."dna_sequence" AS "RequestTarget__dna_sequence", "RequestTarget"."dna_source" AS "RequestTarget__dna_source", "RequestTarget"."dna_source_taxon_id" AS "RequestTarget__dna_source_taxon_id", "RequestTarget"."center" AS "RequestTarget__center", "RequestTarget"."community_interest" AS "RequestTarget__community_interest", "TargetPlanning"."id" AS "TargetPlanning__id", "TargetPlanning"."target_id" AS "TargetPlanning__target_id", "TargetPlanning"."source_file" AS "TargetPlanning__source_file", "TargetPlanning"."target_type" AS "TargetPlanning__target_type", "TargetPlanning"."genomic_dna_source" AS "TargetPlanning__genomic_dna_source", "TargetPlanning"."genomic_dna_status" AS "TargetPlanning__genomic_dna_status", "TargetPlanning"."notes1" AS "TargetPlanning__notes1", "TargetPlanning"."id1" AS "TargetPlanning__id1", "TargetPlanning"."notes2" AS "TargetPlanning__notes2", "TargetPlanning"."id2" AS "TargetPlanning__id2", "TargetPlanning"."ortholog_rescue" AS "TargetPlanning__ortholog_rescue", "TargetPlanning"."codon_optimization" AS "TargetPlanning__codon_optimization", "TargetPlanning"."should_solve_structure" AS "TargetPlanning__should_solve_structure", "TargetPlanning"."inserted" AS "TargetPlanning__inserted", "TargetPlanning"."updated" AS "TargetPlanning__updated", "TargetPlanning"."operon_colocalization" AS "TargetPlanning__operon_colocalization" FROM "protein_target" AS "Target" LEFT JOIN "protein_pdb_homolog_table" AS "Project" ON ("Target"."target_id" = "Project"."protein_target_id") LEFT JOIN "tigr_main_roles" AS "TigrMainRole" ON ("Target"."tigr_main_role_id" = "TigrMainRole"."id") LEFT JOIN "tigr_sub_roles" AS "TigrSubRole" ON ("Target"."tigr_sub_role_id" = "TigrSubRole"."id") LEFT JOIN "names" AS "Organism" ON ("Target"."ncbi_taxon_id" = "Organism"."tax_id" AND "Organism"."name_class" = 'scientific name') LEFT JOIN "names" AS "Species" ON ("Target"."species_taxon_id" = "Species"."tax_id" AND "Species"."name_class" = 'scientific name') LEFT JOIN "stage" AS "Stage" ON ("Target"."stage" = "Stage"."name") LEFT JOIN "protein_pdb_homolog_table" AS "ProteinPdbHomolog" ON ("ProteinPdbHomolog"."protein_target_id" = "Target"."target_id") LEFT JOIN "request_target" AS "RequestTarget" ON ("RequestTarget"."target_id" = "Target"."target_id") LEFT JOIN "target_planning" AS "TargetPlanning" ON ("TargetPlanning"."target_id" = "Target"."target_id") WHERE "Target"."target_id" = 'IDP02263' LIMIT 10112
14SELECT "SubTarget"."id" AS "SubTarget__id", "SubTarget"."target_id" AS "SubTarget__target_id", "SubTarget"."sequence_start" AS "SubTarget__sequence_start", "SubTarget"."sequence_end" AS "SubTarget__sequence_end", "SubTarget"."mutation" AS "SubTarget__mutation", "SubTarget"."sequence" AS "SubTarget__sequence", "SubTarget"."dna_sequence" AS "SubTarget__dna_sequence", "SubTarget"."sequence_comments" AS "SubTarget__sequence_comments", "SubTarget"."date_selected" AS "SubTarget__date_selected", "SubTarget"."priority" AS "SubTarget__priority", "SubTarget"."inserted" AS "SubTarget__inserted", "SubTarget"."updated" AS "SubTarget__updated", "SubTarget"."type" AS "SubTarget__type", "SubTarget"."batch" AS "SubTarget__batch", "SubTarget"."predicted_cox_ligand" AS "SubTarget__predicted_cox_ligand" FROM "protein_subtarget" AS "SubTarget" WHERE "SubTarget"."target_id" = ('IDP02263') 010
15SELECT "ProteinClone"."id" AS "ProteinClone__id", "ProteinClone"."target_id" AS "ProteinClone__target_id", "ProteinClone"."clone_suffix" AS "ProteinClone__clone_suffix", "ProteinClone"."sequence_start" AS "ProteinClone__sequence_start", "ProteinClone"."sequence_end" AS "ProteinClone__sequence_end", "ProteinClone"."sequence" AS "ProteinClone__sequence", "ProteinClone"."sequence_comments" AS "ProteinClone__sequence_comments", "ProteinClone"."local_protein_target_id" AS "ProteinClone__local_protein_target_id", "ProteinClone"."local_clone_plate_id" AS "ProteinClone__local_clone_plate_id", "ProteinClone"."local_clone_id" AS "ProteinClone__local_clone_id", "ProteinClone"."experiment_date_start" AS "ProteinClone__experiment_date_start", "ProteinClone"."experiment_date_end" AS "ProteinClone__experiment_date_end", "ProteinClone"."staff_id" AS "ProteinClone__staff_id", "ProteinClone"."other_people" AS "ProteinClone__other_people", "ProteinClone"."lab_id" AS "ProteinClone__lab_id", "ProteinClone"."protocol_id" AS "ProteinClone__protocol_id", "ProteinClone"."status" AS "ProteinClone__status", "ProteinClone"."vector" AS "ProteinClone__vector", "ProteinClone"."pcr_primer_forward" AS "ProteinClone__pcr_primer_forward", "ProteinClone"."pcr_primer_backward" AS "ProteinClone__pcr_primer_backward", "ProteinClone"."shipped_to_lab_id" AS "ProteinClone__shipped_to_lab_id", "ProteinClone"."shipped_date" AS "ProteinClone__shipped_date", "ProteinClone"."inserted" AS "ProteinClone__inserted", "ProteinClone"."ins_user_id" AS "ProteinClone__ins_user_id", "ProteinClone"."update" AS "ProteinClone__update", "ProteinClone"."upd_user_id" AS "ProteinClone__upd_user_id", "ProteinClone"."secondary_shipped_to_lab_id" AS "ProteinClone__secondary_shipped_to_lab_id", "ProteinClone"."secondary_shipped_date" AS "ProteinClone__secondary_shipped_date", "ProteinClone"."external_source" AS "ProteinClone__external_source", "ProteinClone"."mutation" AS "ProteinClone__mutation", "ProteinClone"."bei_available" AS "ProteinClone__bei_available", "ProteinClone"."bei_number" AS "ProteinClone__bei_number", "ProteinClone"."reference_sequence_variance" AS "ProteinClone__reference_sequence_variance", "ProteinClone"."confirmed_dna_sequence" AS "ProteinClone__confirmed_dna_sequence", "ProteinClone"."confirmed_protein_sequence" AS "ProteinClone__confirmed_protein_sequence", "ProteinClone"."present_in_lims" AS "ProteinClone__present_in_lims", "ProteinClone"."template_dna_sequence" AS "ProteinClone__template_dna_sequence", "ProteinClone"."lims_date" AS "ProteinClone__lims_date", "ProteinClone"."dummy" AS "ProteinClone__dummy" FROM "clone" AS "ProteinClone" WHERE "ProteinClone"."target_id" = ('IDP02263') 010
16SELECT "Purification"."id" AS "Purification__id", "Purification"."target_id" AS "Purification__target_id", "Purification"."purification_suffix" AS "Purification__purification_suffix", "Purification"."expression_id" AS "Purification__expression_id", "Purification"."local_expression_id" AS "Purification__local_expression_id", "Purification"."local_protein_target_id" AS "Purification__local_protein_target_id", "Purification"."local_purification_id" AS "Purification__local_purification_id", "Purification"."experiment_date_start" AS "Purification__experiment_date_start", "Purification"."experiment_date_end" AS "Purification__experiment_date_end", "Purification"."staff_id" AS "Purification__staff_id", "Purification"."other_people" AS "Purification__other_people", "Purification"."lab_id" AS "Purification__lab_id", "Purification"."protocol_id" AS "Purification__protocol_id", "Purification"."status" AS "Purification__status", "Purification"."description" AS "Purification__description", "Purification"."affinity_tag_status" AS "Purification__affinity_tag_status", "Purification"."semet_status" AS "Purification__semet_status", "Purification"."covalent_modification" AS "Purification__covalent_modification", "Purification"."final_buffer" AS "Purification__final_buffer", "Purification"."final_concentration" AS "Purification__final_concentration", "Purification"."final_volume" AS "Purification__final_volume", "Purification"."shipped_to_lab_id" AS "Purification__shipped_to_lab_id", "Purification"."shipped_date" AS "Purification__shipped_date", "Purification"."inserted" AS "Purification__inserted", "Purification"."ins_user_id" AS "Purification__ins_user_id", "Purification"."update" AS "Purification__update", "Purification"."upd_user_id" AS "Purification__upd_user_id", "Purification"."present_in_lims" AS "Purification__present_in_lims", "Purification"."lims_date" AS "Purification__lims_date", "Purification"."dummy" AS "Purification__dummy", "Purification"."yield" AS "Purification__yield" FROM "purification" AS "Purification" WHERE "Purification"."target_id" = ('IDP02263') 030
17SELECT "Expression"."id" AS "Expression__id", "Expression"."target_id" AS "Expression__target_id", "Expression"."expression_suffix" AS "Expression__expression_suffix", "Expression"."clone_id" AS "Expression__clone_id", "Expression"."clone_suffix" AS "Expression__clone_suffix", "Expression"."local_clone_id" AS "Expression__local_clone_id", "Expression"."local_protein_target_id" AS "Expression__local_protein_target_id", "Expression"."local_expression_id" AS "Expression__local_expression_id", "Expression"."experiment_date_start" AS "Expression__experiment_date_start", "Expression"."experiment_date_end" AS "Expression__experiment_date_end", "Expression"."staff_id" AS "Expression__staff_id", "Expression"."other_people" AS "Expression__other_people", "Expression"."lab_id" AS "Expression__lab_id", "Expression"."protocol_id" AS "Expression__protocol_id", "Expression"."status" AS "Expression__status", "Expression"."expression_organism" AS "Expression__expression_organism", "Expression"."expression_strain" AS "Expression__expression_strain", "Expression"."media_type" AS "Expression__media_type", "Expression"."media_volume" AS "Expression__media_volume", "Expression"."growth_temperature" AS "Expression__growth_temperature", "Expression"."induction_temperature" AS "Expression__induction_temperature", "Expression"."induction_reagent" AS "Expression__induction_reagent", "Expression"."experiment_type" AS "Expression__experiment_type", "Expression"."expression_level" AS "Expression__expression_level", "Expression"."solubility_level" AS "Expression__solubility_level", "Expression"."inserted" AS "Expression__inserted", "Expression"."ins_user_id" AS "Expression__ins_user_id", "Expression"."update" AS "Expression__update", "Expression"."upd_user_id" AS "Expression__upd_user_id", "Expression"."present_in_lims" AS "Expression__present_in_lims", "Expression"."lims_date" AS "Expression__lims_date", "Expression"."dummy" AS "Expression__dummy" FROM "expression" AS "Expression" WHERE "Expression"."target_id" = ('IDP02263') 020
18SELECT "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" FROM "deposit" AS "Deposit" WHERE "Deposit"."target_id" = ('IDP02263') 011
19SELECT "Dataset"."id" AS "Dataset__id", "Dataset"."target_id" AS "Dataset__target_id", "Dataset"."crystal_harvest_id" AS "Dataset__crystal_harvest_id", "Dataset"."structure_solution_id" AS "Dataset__structure_solution_id", "Dataset"."experiment_date" AS "Dataset__experiment_date", "Dataset"."staff_id" AS "Dataset__staff_id", "Dataset"."other_people" AS "Dataset__other_people", "Dataset"."lab_id" AS "Dataset__lab_id", "Dataset"."detector_id" AS "Dataset__detector_id", "Dataset"."beamline_id" AS "Dataset__beamline_id", "Dataset"."sca_filename" AS "Dataset__sca_filename", "Dataset"."sca_uploaded" AS "Dataset__sca_uploaded", "Dataset"."wavelength" AS "Dataset__wavelength", "Dataset"."wavelength_type" AS "Dataset__wavelength_type", "Dataset"."diffraction_resolution" AS "Dataset__diffraction_resolution", "Dataset"."experiment_temperature" AS "Dataset__experiment_temperature", "Dataset"."a" AS "Dataset__a", "Dataset"."b" AS "Dataset__b", "Dataset"."c" AS "Dataset__c", "Dataset"."alpha" AS "Dataset__alpha", "Dataset"."beta" AS "Dataset__beta", "Dataset"."gamma" AS "Dataset__gamma", "Dataset"."z" AS "Dataset__z", "Dataset"."matthew_coeff" AS "Dataset__matthew_coeff", "Dataset"."spacegroup" AS "Dataset__spacegroup", "Dataset"."sca_number_reflns_obs" AS "Dataset__sca_number_reflns_obs", "Dataset"."sca_rmerge_i_obs" AS "Dataset__sca_rmerge_i_obs", "Dataset"."sca_chi_squared" AS "Dataset__sca_chi_squared", "Dataset"."sca_redundancy" AS "Dataset__sca_redundancy", "Dataset"."sca_shell_rmerge_i_obs" AS "Dataset__sca_shell_rmerge_i_obs", "Dataset"."sca_shell_chi_squared" AS "Dataset__sca_shell_chi_squared", "Dataset"."sca_shell_redundancy" AS "Dataset__sca_shell_redundancy", "Dataset"."sca_average_i" AS "Dataset__sca_average_i", "Dataset"."sca_average_i_sigma" AS "Dataset__sca_average_i_sigma", "Dataset"."sca_shell_i" AS "Dataset__sca_shell_i", "Dataset"."sca_shell_i_sigma" AS "Dataset__sca_shell_i_sigma", "Dataset"."data_collection_program_id" AS "Dataset__data_collection_program_id", "Dataset"."data_collection_programs_other" AS "Dataset__data_collection_programs_other", "Dataset"."data_scaling_program_id" AS "Dataset__data_scaling_program_id", "Dataset"."data_scaling_programs_other" AS "Dataset__data_scaling_programs_other", "Dataset"."intensity_integration_program_id" AS "Dataset__intensity_integration_program_id", "Dataset"."intensity_integration_programs_other" AS "Dataset__intensity_integration_programs_other", "Dataset"."shipped_to_lab_id" AS "Dataset__shipped_to_lab_id", "Dataset"."shipped_date" AS "Dataset__shipped_date", "Dataset"."inserted" AS "Dataset__inserted", "Dataset"."ins_user_id" AS "Dataset__ins_user_id", "Dataset"."update" AS "Dataset__update", "Dataset"."upd_user_id" AS "Dataset__upd_user_id", "Dataset"."sca_shell_res_low" AS "Dataset__sca_shell_res_low", "Dataset"."sca_shell_res_high" AS "Dataset__sca_shell_res_high", "Dataset"."sca_number_reflns_all" AS "Dataset__sca_number_reflns_all", "Dataset"."local_protein_target_id" AS "Dataset__local_protein_target_id", "Dataset"."local_dataset_id" AS "Dataset__local_dataset_id", "Dataset"."local_crystal_harvest_id" AS "Dataset__local_crystal_harvest_id", "Dataset"."dataset_suffix" AS "Dataset__dataset_suffix", "Dataset"."present_in_lims" AS "Dataset__present_in_lims" FROM "dataset" AS "Dataset" WHERE "Dataset"."target_id" = ('IDP02263') 011
20SELECT "Screening"."id" AS "Screening__id", "Screening"."target_id" AS "Screening__target_id", "Screening"."pdb_id" AS "Screening__pdb_id", "Screening"."chain_id" AS "Screening__chain_id", "Screening"."surface_id" AS "Screening__surface_id", "Screening"."method" AS "Screening__method", "Screening"."surface_pdb_file" AS "Screening__surface_pdb_file", "Screening"."docking_file" AS "Screening__docking_file", "Screening"."date_started" AS "Screening__date_started", "Screening"."date_ended" AS "Screening__date_ended", "Screening"."staff_id" AS "Screening__staff_id", "Screening"."inserted" AS "Screening__inserted", "Screening"."updated" AS "Screening__updated", "Screening"."run_id" AS "Screening__run_id", "Screening"."library_id" AS "Screening__library_id", (SELECT COUNT(*) FROM vs_assay_data WHERE "vs_assay_data"."vs_assay_id" = "Screening"."id") AS "Screening__compounds_count", (SELECT conc_comma("substance_name") FROM "hts"."vs_assay_data" WHERE rank < 5 AND vs_assay_id = "Screening"."id") AS "Screening__top_hits" FROM "vs_assay" AS "Screening" WHERE "Screening"."target_id" = ('IDP02263') 033
21SELECT "CrystalHarvest"."id" AS "CrystalHarvest__id", "CrystalHarvest"."target_id" AS "CrystalHarvest__target_id", "CrystalHarvest"."crystal_harvest_suffix" AS "CrystalHarvest__crystal_harvest_suffix", "CrystalHarvest"."crystallization_drop_id" AS "CrystalHarvest__crystallization_drop_id", "CrystalHarvest"."local_crystallization_drop_id" AS "CrystalHarvest__local_crystallization_drop_id", "CrystalHarvest"."local_protein_target_id" AS "CrystalHarvest__local_protein_target_id", "CrystalHarvest"."local_crystal_harvest_id" AS "CrystalHarvest__local_crystal_harvest_id", "CrystalHarvest"."experiment_date" AS "CrystalHarvest__experiment_date", "CrystalHarvest"."staff_id" AS "CrystalHarvest__staff_id", "CrystalHarvest"."other_people" AS "CrystalHarvest__other_people", "CrystalHarvest"."lab_id" AS "CrystalHarvest__lab_id", "CrystalHarvest"."protocol_id" AS "CrystalHarvest__protocol_id", "CrystalHarvest"."cryo_solution" AS "CrystalHarvest__cryo_solution", "CrystalHarvest"."soaking_solution" AS "CrystalHarvest__soaking_solution", "CrystalHarvest"."ligand" AS "CrystalHarvest__ligand", "CrystalHarvest"."diffraction_limit" AS "CrystalHarvest__diffraction_limit", "CrystalHarvest"."crystal_quality" AS "CrystalHarvest__crystal_quality", "CrystalHarvest"."shipped_to_lab_id" AS "CrystalHarvest__shipped_to_lab_id", "CrystalHarvest"."shipped_date" AS "CrystalHarvest__shipped_date", "CrystalHarvest"."inserted" AS "CrystalHarvest__inserted", "CrystalHarvest"."ins_user_id" AS "CrystalHarvest__ins_user_id", "CrystalHarvest"."update" AS "CrystalHarvest__update", "CrystalHarvest"."upd_user_id" AS "CrystalHarvest__upd_user_id", "CrystalHarvest"."final_pdb_id" AS "CrystalHarvest__final_pdb_id", "CrystalHarvest"."present_in_lims" AS "CrystalHarvest__present_in_lims", "CrystalHarvest"."lims_date" AS "CrystalHarvest__lims_date", "CrystalHarvest"."dummy" AS "CrystalHarvest__dummy" FROM "crystal_harvest" AS "CrystalHarvest" WHERE "CrystalHarvest"."target_id" = ('IDP02263') 020
22SELECT "Justification"."id" AS "Justification__id", "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "JustificationCodeProteinTarget"."id" AS "JustificationCodeProteinTarget__id", "JustificationCodeProteinTarget"."target_id" AS "JustificationCodeProteinTarget__target_id", "JustificationCodeProteinTarget"."justification_code_id" AS "JustificationCodeProteinTarget__justification_code_id" FROM "justification_code" AS "Justification" JOIN "justification_code_map" AS "JustificationCodeProteinTarget" ON ("JustificationCodeProteinTarget"."target_id" = 'IDP02263' AND "JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") 000
23SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP02263' 000