Variation Browser

Download
Receptor Position GPCRdb Segment Variant Mutation type Allele Frequency Allele Count Allele Number Homozygotes SIFT score PolyPhen score Functional annotation
Receptor Position GPCRdb Segment Variant Mutation Type Allele Frequency Allele Count Allele Number Homozygotes SIFT score PolyPhen score Functional annotation
gabr2_human 856 C-term N => LysfsTer99 frameshift 8.238e-06 1 121392 0 None None
gabr2_human 830 C-term H => ThrfsTer25 frameshift 8.236e-06 1 121412 0 None None
gabr2_human 641 ECL2 I => LeufsTer10 frameshift 8.245e-06 1 121292 0 None None
gabr2_human 340 N-term R => SerfsTer63 frameshift 8.237e-06 1 121410 0 None None
gabr2_human 108 N-term C => Ter stop gained 8.245e-06 1 121286 0 None None
gabr2_human 935 C-term R => Q missense 3.94e-05 2 50756 0 nan 0.003
gabr2_human 929 C-term H => R missense 3.613e-05 2 55350 0 nan 0.777
gabr2_human 926 C-term R => S missense 3.874e-05 2 51632 0 nan 0.866
gabr2_human 926 C-term R => C missense 5.81e-05 3 51632 0 nan 0.925
gabr2_human 923 C-term A => T missense 6.009e-05 3 49924 0 nan 0.002
gabr2_human 919 C-term V => I missense 0.0001971 10 50736 0 nan 0.104
gabr2_human 912 C-term A => V missense 1.888e-05 1 52968 0 nan 0.867
gabr2_human 912 C-term A => T missense 7.648e-05 4 52304 0 nan 0.773
gabr2_human 908 C-term G => R missense 1.84e-05 1 54338 0 nan 0.999
gabr2_human 906 C-term S => T missense 1.794e-05 1 55744 0 nan 0.535
gabr2_human 905 C-term P => Q missense 1.786e-05 1 56004 0 nan 0.999
gabr2_human 902 C-term A => T missense 1.775e-05 1 56344 0 nan 0.783
gabr2_human 879 C-term I => V missense 3.295e-05 4 121388 0 nan 0.01
gabr2_human 876 C-term K => E missense 1.648e-05 2 121394 0 nan 0.038
gabr2_human 873 C-term R => Q missense 6.59e-05 8 121396 0 nan 0.042
gabr2_human 872 C-term S => C missense 8.238e-06 1 121396 0 nan 0.97
gabr2_human 869 C-term T => A missense 0.1938 23531 121396 2533 nan 0.0
gabr2_human 859 C-term D => N missense 0.0001483 18 121396 0 nan 0.039
gabr2_human 857 C-term H => R missense 8.238e-06 1 121392 0 nan 0.084
gabr2_human 854 C-term L => F missense 5.767e-05 7 121386 0 nan 0.942
gabr2_human 849 C-term G => E missense 8.24e-06 1 121360 0 nan 0.36
gabr2_human 836 C-term D => Y missense 2.471e-05 3 121412 0 0.0 0.184
gabr2_human 835 C-term N => H missense 8.236e-06 1 121412 0 0.01 0.859
gabr2_human 830 C-term H => D missense 8.237e-06 1 121410 0 0.06 0.271
gabr2_human 829 C-term N => S missense 8.236e-06 1 121412 0 0.03 0.066
gabr2_human 823 C-term T => I missense 2.471e-05 3 121412 0 0.08 0.941
gabr2_human 815 C-term Q => K missense 5.766e-05 7 121410 0 0.43 0.644
gabr2_human 814 C-term M => V missense 8.237e-06 1 121410 0 0.36 0.437
gabr2_human 797 C-term R => H missense 8.251e-06 1 121198 0 0.15 0.107
gabr2_human 787 C-term R => H missense 1.648e-05 2 121364 0 0.12 0.469
gabr2_human 776 C-term S => L missense 8.237e-06 1 121402 0 0.06 0.129
gabr2_human 773 C-term T => M missense 0.0001318 16 121404 0 0.12 0.719
gabr2_human 770 C-term D => N missense 8.237e-06 1 121404 0 0.3 0.989
gabr2_human 753 8.48x48 H8 A => S missense 8.255e-06 1 121138 0 0.03 0.212 GP (contact)
gabr2_human 748 7.56x56 TM7 R => S missense 1.656e-05 2 120766 0 0.01 0.138
gabr2_human 748 7.56x56 TM7 R => K missense 1.657e-05 2 120728 0 0.43 0.104
gabr2_human 746 7.54x54 TM7 T => A missense 8.311e-06 1 120322 0 0.2 0.252
gabr2_human 741 7.49x49 TM7 V => M missense 3.512e-05 4 113900 0 0.03 0.782
gabr2_human 727 7.35x36 TM7 V => I missense 8.339e-06 1 119914 0 0.1 0.038
gabr2_human 724 7.32x33 TM7 V => M missense 8.322e-06 1 120164 0 0.02 0.616 LB (hydrophobic)
gabr2_human 719 7.27x28 TM7 V => M missense 8.308e-06 1 120362 0 0.04 0.771
gabr2_human 716 7.24x25 TM7 Q => E missense 8.306e-06 1 120400 0 0.17 0.072
gabr2_human 704 6.51x51 TM6 I => V missense 8.283e-06 1 120730 0 1.0 0.078 LB (hydrophobic)
gabr2_human 702 6.49x49 TM6 M => L missense 8.282e-06 1 120748 0 0.09 0.02
gabr2_human 692 6.39x39 TM6 I => V missense 3.318e-05 4 120564 0 0.31 0.181 GP (contact)
gabr2_human 669 5.52x52 TM5 L => S missense 8.939e-06 1 111870 0 0.0 0.286
gabr2_human 662 5.45x45 TM5 A => T missense 8.246e-06 1 121264 0 0.03 0.815
gabr2_human 660 5.43x43 TM5 V => A missense 8.244e-06 1 121302 0 0.0 0.539
gabr2_human 660 5.43x43 TM5 V => I missense 8.244e-06 1 121304 0 1.0 0.854
gabr2_human 642 ECL2 R => L missense 3.297e-05 4 121314 0 0.59 0.018
gabr2_human 642 ECL2 R => H missense 1.649e-05 2 121314 0 0.02 0.833
gabr2_human 642 ECL2 R => C missense 5.77e-05 7 121310 0 0.07 0.87
gabr2_human 641 ECL2 I => V missense 1.649e-05 2 121304 0 0.18 0.286
gabr2_human 637 ECL2 R => Q missense 8.26e-06 1 121060 0 0.32 0.076
gabr2_human 637 ECL2 R => W missense 8.275e-06 1 120844 0 0.01 0.979
gabr2_human 633 ECL2 D => N missense 8.321e-06 1 120176 0 0.21 0.928
gabr2_human 632 ECL2 P => L missense 8.336e-06 1 119960 0 0.05 0.054
gabr2_human 631 ECL2 E => G missense 8.922e-06 1 112086 0 0.08 0.978
gabr2_human 630 ECL2 M => V missense 8.881e-06 1 112604 0 0.54 0.022
gabr2_human 629 ECL2 S => G missense 8.845e-06 1 113052 0 0.25 0.006
gabr2_human 628 ECL2 Y => H missense 8.818e-06 1 113408 0 0.25 0.327
gabr2_human 622 ECL2 R => Q missense 1.721e-05 2 116210 0 0.48 0.249
gabr2_human 612 4.47x47 TM4 L => P missense 8.43e-06 1 118626 0 0.0 1.0
gabr2_human 604 4.39x39 TM4 M => V missense 8.456e-06 1 118256 0 0.01 0.046
gabr2_human 603 4.38x38 TM4 G => S missense 8.478e-06 1 117946 0 0.02 0.908
gabr2_human 601 4.36x36 TM4 V => M missense 8.503e-06 1 117612 0 0.0 0.987
gabr2_human 570 3.46x46 TM3 A => T missense 4.132e-05 5 121006 0 0.08 0.993
gabr2_human 548 3.24x24 TM3 T => N missense 8.238e-06 1 121392 0 0.31 0.856
gabr2_human 546 3.22x22 TM3 E => A missense 8.237e-06 1 121398 0 0.59 0.01
gabr2_human 518 2.37x37 TM2 Y => C missense 8.238e-06 1 121386 0 0.05 0.953
gabr2_human 513 12.51x51 ICL1 K => N missense 8.242e-06 1 121332 0 0.01 0.83
gabr2_human 512 12.50x50 ICL1 I => V missense 1.648e-05 2 121326 0 0.1 0.773
gabr2_human 507 ICL1 R => Q missense 4.165e-05 5 120060 1 0.03 0.984
gabr2_human 493 1.51x51 TM1 M => V missense 8.241e-06 1 121340 0 0.24 0.072
gabr2_human 490 1.48x48 TM1 I => V missense 8.24e-06 1 121366 0 0.64 0.002
gabr2_human 475 N-term R => Q missense 2.472e-05 3 121338 0 0.42 0.066
gabr2_human 475 N-term R => W missense 8.242e-06 1 121332 0 0.01 0.947
gabr2_human 462 N-term E => K missense 0.0002497 30 120140 1 0.58 0.04
gabr2_human 455 N-term T => N missense 7.421e-05 9 121276 0 0.16 0.006
gabr2_human 453 N-term N => S missense 8.245e-06 1 121290 0 0.56 0.716
gabr2_human 448 N-term T => A missense 8.244e-06 1 121306 0 0.73 0.022
gabr2_human 447 N-term D => N missense 4.122e-05 5 121302 0 0.12 0.884
gabr2_human 444 N-term A => T missense 8.244e-06 1 121296 0 0.01 0.044
gabr2_human 435 N-term R => M missense 8.256e-06 1 121122 0 0.03 0.246
gabr2_human 435 N-term R => K missense 2.477e-05 3 121122 0 0.89 0.0
gabr2_human 423 N-term M => T missense 8.329e-06 1 120058 0 0.16 0.928
gabr2_human 418 N-term R => W missense 8.387e-06 1 119230 0 0.13 0.995
gabr2_human 408 N-term F => I missense 8.238e-06 1 121384 0 0.0 1.0
gabr2_human 405 N-term E => K missense 8.238e-06 1 121396 0 0.26 0.022
gabr2_human 403 N-term M => K missense 8.237e-06 1 121408 0 0.0 0.906
gabr2_human 394 N-term T => M missense 4.118e-05 5 121408 0 0.12 0.575
gabr2_human 393 N-term H => D missense 1.647e-05 2 121408 0 0.53 0.05
gabr2_human 391 N-term T => M missense 7.413e-05 9 121404 0 0.1 0.867
gabr2_human 384 N-term R => W missense 8.237e-06 1 121406 0 0.03 0.663
gabr2_human 381 N-term R => W missense 8.237e-06 1 121400 0 0.0 0.87
gabr2_human 378 N-term A => T missense 8.237e-06 1 121404 0 0.73 0.004
gabr2_human 370 N-term Q => K missense 1.647e-05 2 121408 0 0.33 0.006
gabr2_human 358 N-term A => T missense 8.237e-06 1 121410 0 0.42 1.0
gabr2_human 355 N-term H => D missense 8.237e-06 1 121410 0 0.0 0.989
gabr2_human 351 N-term P => R missense 8.236e-06 1 121412 0 0.34 0.165
gabr2_human 349 N-term V => M missense 1.647e-05 2 121412 0 0.13 0.771
gabr2_human 344 N-term N => K missense 1.647e-05 2 121412 0 0.91 0.01
gabr2_human 341 N-term E => Q missense 8.237e-06 1 121398 0 0.16 0.954
gabr2_human 335 N-term P => A missense 1.648e-05 2 121356 0 0.66 0.998
gabr2_human 333 N-term K => T missense 8.705e-06 1 114878 0 0.42 0.254
gabr2_human 327 N-term I => F missense 8.521e-06 1 117358 0 0.05 0.239
gabr2_human 317 N-term V => A missense 8.36e-06 1 119616 0 0.21 0.031
gabr2_human 315 N-term I => V missense 8.332e-06 1 120018 0 0.12 0.254
gabr2_human 314 N-term Y => H missense 8.324e-06 1 120140 0 0.45 0.756
gabr2_human 306 N-term N => Y missense 1.654e-05 2 120940 0 0.01 0.824
gabr2_human 304 N-term R => Q missense 3.306e-05 4 120998 0 0.6 0.01
gabr2_human 304 N-term R => W missense 8.262e-06 1 121030 0 0.03 0.733
gabr2_human 301 N-term R => H missense 1.651e-05 2 121142 0 0.13 0.004
gabr2_human 301 N-term R => P missense 8.255e-06 1 121142 0 0.38 0.313
gabr2_human 295 N-term T => M missense 0.0001485 18 121240 0 0.16 0.001
gabr2_human 294 N-term H => R missense 2.474e-05 3 121256 0 0.6 0.011
gabr2_human 293 N-term V => M missense 8.247e-06 1 121254 0 0.18 0.164
gabr2_human 286 N-term E => K missense 8.249e-06 1 121232 0 0.68 0.004
gabr2_human 272 N-term M => T missense 8.342e-06 1 119870 0 0.0 0.816
gabr2_human 270 N-term E => K missense 1.688e-05 2 118498 0 0.91 0.051
gabr2_human 261 N-term A => T missense 1.648e-05 2 121396 0 0.26 0.052
gabr2_human 258 N-term N => S missense 8.237e-06 1 121402 0 0.87 0.013
gabr2_human 248 N-term V => M missense 4.942e-05 6 121400 0 0.0 0.734
gabr2_human 239 N-term S => N missense 1.649e-05 2 121266 0 0.53 0.015
gabr2_human 224 N-term I => V missense 4.951e-05 6 121186 0 0.36 0.607
gabr2_human 222 N-term E => K missense 8.255e-06 1 121142 0 0.3 0.007
gabr2_human 205 N-term V => I missense 2.475e-05 3 121214 0 0.28 0.007
gabr2_human 200 N-term T => M missense 9.894e-05 12 121284 0 0.0 0.982 PTM (Phosphorylation)
gabr2_human 198 N-term V => M missense 8.243e-06 1 121310 0 0.0 0.999
gabr2_human 189 N-term L => W missense 8.24e-06 1 121352 0 0.0 0.943
gabr2_human 170 N-term P => R missense 8.25e-06 1 121214 0 0.0 0.327
gabr2_human 147 N-term Q => H missense 4.12e-05 5 121366 0 0.12 0.382
gabr2_human 138 N-term V => I missense 8.238e-06 1 121396 0 0.03 0.992
gabr2_human 134 N-term V => I missense 2.471e-05 3 121400 0 0.31 0.93
gabr2_human 127 N-term H => Q missense 8.237e-06 1 121406 0 0.19 0.657
gabr2_human 125 N-term P => S missense 8.237e-06 1 121406 0 0.0 1.0
gabr2_human 102 N-term R => W missense 1.916e-05 1 52184 0 0.23 0.044
gabr2_human 90 N-term N => S missense 2.133e-05 2 93780 0 0.18 0.067
gabr2_human 68 N-term V => A missense 9.757e-06 1 102490 0 0.9 0.011
gabr2_human 68 N-term V => M missense 9.755e-06 1 102510 0 0.17 0.157
gabr2_human 64 N-term L => F missense 1.006e-05 1 99452 0 0.48 0.04
gabr2_human 59 N-term M => I missense 1.059e-05 1 94460 0 0.4 0.0
gabr2_human 59 N-term M => L missense 1.077e-05 1 92880 0 1.0 0.0
gabr2_human 55 N-term P => R missense 1.251e-05 1 79946 0 0.3 0.0
gabr2_human 55 N-term P => L missense 2.502e-05 2 79946 0 0.2 0.0
gabr2_human 46 N-term A => T missense 6.898e-05 1 14496 0 0.13 0.0
gabr2_human 44 N-term R => Q missense 9.781e-05 1 10224 0 nan 0.0


Residue

Diagrams

ICL1 Q R N K L I K M S ICL1ECL1 D G S F V ECL1ICL2 N V K M K K K I I ICL2ECL2 P L R R T V E K Y S M E P D P A G R D I S I R P L L E H C E N T ECL2ICL3 S I P A L N ICL3ECL3 R D ECL3N-term M A S P R S S G Q P G P P P P P P P P P A R L L L L L L L P L L L P L A P G A W G W A R G A P R P P P S S P P L S I M G L M P L T K E V A K G S I G R G V L P A V E L A I E Q I R N E S L L R P Y F L D L R L Y D T E C D N A K G L K A F Y D A I K Y G P N H L M V F G G V C P S V T S I I A E S L Q G W N L V Q L S F A A T T P V L A D K K K Y P Y F F R T V P S D N A V N P A I L K L L K H Y Q W K R V G T L T Q D V Q R F S E V R N D L T G V L Y G E D I E I S D T E S F S N D P C T S V K K L K G N D V R I I L G Q F D Q N M A A K V F C C A Y E E N M Y G S K Y Q W I I P G W Y E P S W W E Q V H T E A N S S R C L R K N L L A A M E G Y I G V D F E P L S S K Q I K T I S G K T P Q Q Y E R E Y N N K R S G V G P S K F H G Y A Y D G I W V I A K T L Q R A M E T L H A S S R H Q R I Q D F N Y T D H T L G R I I L N A M N E T N F F G V T G Q V V F R N G E R M G T I K F T Q F Q D S R E V K V G E Y N A V A D T L E I I N D T I R F Q G S E P P K D K T I I L E Q L R K I N-termC-term T Q N Q K K E D S K T S T S V T S V N Q A S T S R L E G L Q S E N H R L R M K I T E L D K D L E E V T M Q L Q D T P E K T T Y I K Q N H Y Q E L N D I L N L G N F T E S T D G G K A I L K N H L D Q N P Q L Q W N T T E P S R T C K D P I E D I N S P E H I Q R R L S L Q L P I L H H A Y L P S I G G V D A S C V S P C V S P T A S P R H R H V P P S F R V M V S G L C-term S L P L Y S I L S A L T I L G M I M A S A F L F F N I K N S P Y M N N L I I L G G M L S Y A S I F L F G L S E K T F E T L C T V R T W I L T V G Y T T A F G A M F A K T W R V H A I F K K D Q K L L V I V G G M L L I D L C I L I C W Q A V D H M T I W L G I V Y A Y K G L L M L F G C F L A W E T R N V D S K Y I G M S V Y N V G I M C I I G A A V S F L T Q P N V Q F C I V A L V I I F C S T I T L C L V F V P K L I T L R T N P D A R R F A T Q N Q F
SnakePlot Download: PNG | SVG S A M I M G L I T L A S L I S Y L P L S 1 N L I I L G G M L S Y A S I F L F G L 2 A F M A G F A T T Y G V T L I W T R V T 3 L L V I V G G M L L I D L C I L I C W Q 4 A L F C G F L M L L G K Y A Y V I G L W 5 G M S V Y N V G I M C I I G A A V S F L 6 C L T I T S C F I I V L A V I C F Q V N 7
HelixBox Download: PNG | SVG




«

Versions

Package Name Version
Django 2.2.1
Python 3.6.7
debug_toolbar Debug Toolbar 1.11
polymorphic Polymorphic 2.0.3
rest_framework Django REST framework 3.9.3
rest_framework_swagger Rest_Framework_Swagger 2.2.0

Time

Resource usage

Resource Value
User CPU time 3947.357 msec
System CPU time 180.240 msec
Total CPU time 4127.597 msec
Elapsed time 4503.104 msec
Context switches 651 voluntary, 16 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

Settings from protwis.settings

Setting Value
ABSOLUTE_URL_OVERRIDES {}
ADMINS []
ALLOWED_HOSTS ['*']
APPEND_SLASH True
AUTHENTICATION_BACKENDS ['django.contrib.auth.backends.ModelBackend']
AUTH_PASSWORD_VALIDATORS '********************'
AUTH_USER_MODEL 'auth.User'
BASE_DIR '/home/protwis/gpcrdb_test'
BUILD_CACHE_DIR '/home/protwis/gpcrdb_data/cache'
CACHES {'alignments': {'BACKEND': 'django.core.cache.backends.filebased.FileBasedCache', 'LOCATION': '/home/protwis/caches/test_alignment', 'OPTIONS': {'MAX_ENTRIES': 1000}}, 'default': {'BACKEND': 'django.core.cache.backends.filebased.FileBasedCache', 'LOCATION': '/home/protwis/caches/test/', 'OPTIONS': {'MAX_ENTRIES': 10000000}}}
CACHE_MIDDLEWARE_ALIAS 'default'
CACHE_MIDDLEWARE_KEY_PREFIX '********************'
CACHE_MIDDLEWARE_SECONDS 600
CSRF_COOKIE_AGE 31449600
CSRF_COOKIE_DOMAIN None
CSRF_COOKIE_HTTPONLY False
CSRF_COOKIE_NAME 'csrftoken'
CSRF_COOKIE_PATH '/'
CSRF_COOKIE_SAMESITE 'Lax'
CSRF_COOKIE_SECURE False
CSRF_FAILURE_VIEW 'django.views.csrf.csrf_failure'
CSRF_HEADER_NAME 'HTTP_X_CSRFTOKEN'
CSRF_TRUSTED_ORIGINS []
CSRF_USE_SESSIONS False
DATABASES {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'HOST': 'localhost', 'NAME': 'protwis_202107', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'protwis'}}
DATABASE_ROUTERS []
DATA_DIR '/home/protwis/gpcrdb_data'
DATA_UPLOAD_MAX_MEMORY_SIZE 2621440
DATA_UPLOAD_MAX_NUMBER_FIELDS 1000
DATETIME_FORMAT 'N j, Y, P'
DATETIME_INPUT_FORMATS ['%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y']
DATE_FORMAT 'N j, Y'
DATE_INPUT_FORMATS ['%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y']
DEBUG True
DEBUG_PROPAGATE_EXCEPTIONS False
DEBUG_TOOLBAR_PATCH_SETTINGS False
DECIMAL_SEPARATOR '.'
DEFAULT_CHARSET 'utf-8'
DEFAULT_CONTENT_TYPE 'text/html'
DEFAULT_EXCEPTION_REPORTER_FILTER 'django.views.debug.SafeExceptionReporterFilter'
DEFAULT_FILE_STORAGE 'django.core.files.storage.FileSystemStorage'
DEFAULT_FROM_EMAIL 'webmaster@localhost'
DEFAULT_INDEX_TABLESPACE ''
DEFAULT_NUMBERING_SCHEME 'gpcrdb'
DEFAULT_PROTEIN_STATE 'inactive'
DEFAULT_SITE 'gpcr'
DEFAULT_TABLESPACE ''
DISALLOWED_USER_AGENTS []
DOCUMENTATION_URL 'https://docs.gpcrdb.org/'
EMAIL_BACKEND 'django.core.mail.backends.smtp.EmailBackend'
EMAIL_HOST 'localhost'
EMAIL_HOST_PASSWORD '********************'
EMAIL_HOST_USER ''
EMAIL_PORT 25
EMAIL_SSL_CERTFILE None
EMAIL_SSL_KEYFILE '********************'
EMAIL_SUBJECT_PREFIX '[Django] '
EMAIL_TIMEOUT None
EMAIL_USE_LOCALTIME False
EMAIL_USE_SSL False
EMAIL_USE_TLS False
FILE_CHARSET 'utf-8'
FILE_UPLOAD_DIRECTORY_PERMISSIONS None
FILE_UPLOAD_HANDLERS ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
FILE_UPLOAD_MAX_MEMORY_SIZE 2621440
FILE_UPLOAD_PERMISSIONS None
FILE_UPLOAD_TEMP_DIR None
FIRST_DAY_OF_WEEK 0
FIXTURE_DIRS []
FORCE_SCRIPT_NAME None
FORMAT_MODULE_PATH None
FORM_RENDERER 'django.forms.renderers.DjangoTemplates'
GOOGLE_ANALYTICS_API '********************'
GOOGLE_ANALYTICS_KEY '********************'
IGNORABLE_404_URLS []
INSTALLED_APPS ('django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.humanize', 'debug_toolbar', 'rest_framework', 'rest_framework_swagger', 'polymorphic', 'common', 'api', 'news', 'pages', 'home', 'protein', 'family', 'residue', 'alignment', 'similaritysearch', 'similaritymatrix', 'structure', 'ligand', 'interaction', 'mutation', 'phylogenetic_trees', 'sitesearch', 'build_gpcr', 'construct', 'tools', 'drugs', 'signprot', 'signprot2', 'mutational_landscape', 'contactnetwork', 'seqsign', 'angles', 'hotspots')
INTERNAL_IPS '10.0.2.2'
LANGUAGES [('af', 'Afrikaans'), ('ar', 'Arabic'), ('ast', 'Asturian'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'), ('hy', 'Armenian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kab', 'Kabyle'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lb', 'Luxembourgish'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'), ('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')]
LANGUAGES_BIDI ['he', 'ar', 'fa', 'ur']
LANGUAGE_CODE 'en-us'
LANGUAGE_COOKIE_AGE None
LANGUAGE_COOKIE_DOMAIN None
LANGUAGE_COOKIE_NAME 'django_language'
LANGUAGE_COOKIE_PATH '/'
LOCALE_PATHS []
LOGGING {'disable_existing_loggers': False, 'formatters': {'verbose': {'datefmt': '%d/%b/%Y %H:%M:%S', 'format': '[%(asctime)s] %(levelname)s ' '[%(name)s:%(lineno)s] %(message)s'}, 'verbose_low': {'datefmt': '%d/%b/%Y %H:%M:%S', 'format': '[%(asctime)s] %(levelname)s ' '[%(name)s:%(lineno)s]'}}, 'handlers': {'build': {'class': 'logging.FileHandler', 'filename': 'logs/build.log', 'formatter': 'verbose', 'level': 'DEBUG'}, 'django': {'class': 'logging.FileHandler', 'filename': 'logs/django.log', 'formatter': 'verbose', 'level': 'WARNING'}, 'protwis': {'class': 'logging.FileHandler', 'filename': 'logs/protwis.log', 'formatter': 'verbose', 'level': 'DEBUG'}}, 'loggers': {'build': {'handlers': ['build'], 'level': 'DEBUG'}, 'django': {'handlers': ['django'], 'level': 'WARNING', 'propagate': True}, 'protwis': {'handlers': ['protwis'], 'level': 'DEBUG'}}, 'version': 1}
LOGGING_CONFIG 'logging.config.dictConfig'
LOGIN_REDIRECT_URL '/accounts/profile/'
LOGIN_URL '/accounts/login/'
LOGOUT_REDIRECT_URL None
MANAGERS []
MEDIA_ROOT '/protwis/media/protwis'
MEDIA_URL '/media/'
MESSAGE_STORAGE 'django.contrib.messages.storage.fallback.FallbackStorage'
MIDDLEWARE ('common.middleware.stats.StatsMiddleware', 'debug_toolbar.middleware.DebugToolbarMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware')
MIGRATION_MODULES {}
MONTH_DAY_FORMAT 'F j'
NUMBER_GROUPING 0
PASSWORD_HASHERS '********************'
PASSWORD_RESET_TIMEOUT_DAYS '********************'
PREPEND_WWW False
REFERENCE_POSITIONS {'D1S1': 'D1S1x50', 'D1S2': 'D1S2x50', 'D1T1': 'D1T1x50', 'D1e1': 'D1e1x50', 'ECL1': '23x50', 'ECL2': '45x50', 'H8': '8x50', 'ICL1': '12x50', 'ICL2': '34x50', 'TM1': '1x50', 'TM2': '2x50', 'TM3': '3x50', 'TM4': '4x50', 'TM5': '5x50', 'TM6': '6x50', 'TM7': '7x50'}
ROOT_URLCONF 'protwis.urls'
SECRET_KEY '********************'
SECURE_BROWSER_XSS_FILTER False
SECURE_CONTENT_TYPE_NOSNIFF False
SECURE_HSTS_INCLUDE_SUBDOMAINS False
SECURE_HSTS_PRELOAD False
SECURE_HSTS_SECONDS 0
SECURE_PROXY_SSL_HEADER None
SECURE_REDIRECT_EXEMPT []
SECURE_SSL_HOST None
SECURE_SSL_REDIRECT False
SERVER_EMAIL 'root@localhost'
SESSION_CACHE_ALIAS 'default'
SESSION_COOKIE_AGE 86400
SESSION_COOKIE_DOMAIN None
SESSION_COOKIE_HTTPONLY True
SESSION_COOKIE_NAME 'sessionid'
SESSION_COOKIE_PATH '/'
SESSION_COOKIE_SAMESITE 'Lax'
SESSION_COOKIE_SECURE False
SESSION_ENGINE 'django.contrib.sessions.backends.db'
SESSION_EXPIRE_AT_BROWSER_CLOSE False
SESSION_FILE_PATH None
SESSION_SAVE_EVERY_REQUEST False
SESSION_SERIALIZER 'django.contrib.sessions.serializers.PickleSerializer'
SETTINGS_MODULE 'protwis.settings'
SHORT_DATETIME_FORMAT 'm/d/Y P'
SHORT_DATE_FORMAT 'm/d/Y'
SIGNING_BACKEND 'django.core.signing.TimestampSigner'
SILENCED_SYSTEM_CHECKS []
SITE_NAME 'gpcr'
SITE_TITLE 'GPCRdb'
STATICFILES_DIRS ('/home/protwis/gpcrdb_test/static',)
STATICFILES_FINDERS ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
STATICFILES_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage'
STATIC_ROOT '/home/protwis/static_test/'
STATIC_URL '/static/'
SWAGGER_SETTINGS {'USE_SESSION_AUTH': False}
TEMPLATES [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'OPTIONS': {'context_processors': ['django.contrib.auth.context_processors.auth', 'django.template.context_processors.debug', 'django.template.context_processors.i18n', 'django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.tz', 'django.contrib.messages.context_processors.messages', 'protwis.context_processors.current_site', 'protwis.context_processors.canonical_tag', 'protwis.context_processors.documentation_url', 'protwis.context_processors.google_analytics', 'protwis.context_processors.site_title'], 'debug': True}}]
TEST_NON_SERIALIZED_APPS []
TEST_RUNNER 'django.test.runner.DiscoverRunner'
THOUSAND_SEPARATOR ','
TIME_FORMAT 'P'
TIME_INPUT_FORMATS ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
TIME_ZONE 'Europe/Copenhagen'
USE_I18N True
USE_L10N True
USE_THOUSAND_SEPARATOR False
USE_TZ True
USE_X_FORWARDED_HOST False
USE_X_FORWARDED_PORT False
WSGI_APPLICATION None
X_FRAME_OPTIONS 'SAMEORIGIN'
YEAR_MONTH_FORMAT 'F Y'

Headers

Request headers

Key Value
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Encoding br,gzip
Accept-Language en-US,en;q=0.5
Connection close
Host test.gpcrdb.org
User-Agent CCBot/2.0 (https://commoncrawl.org/faq/)
X-Forwarded-For 3.236.207.90
X-Forwarded-Proto https
X-Real-Ip 3.236.207.90

Response headers

Key Value
Content-Length 802645
Content-Type text/html; charset=utf-8
Vary Cookie
X-Frame-Options SAMEORIGIN

WSGI environ

Since the WSGI environ inherits the environment of the server, only a significant subset is shown below.

Key Value
PATH_INFO /mutational_landscape/protein/GABR2_human/
QUERY_STRING
REMOTE_ADDR
REQUEST_METHOD GET
SCRIPT_NAME
SERVER_NAME test.gpcrdb.org
SERVER_PORT 443
SERVER_PROTOCOL HTTP/1.0
SERVER_SOFTWARE gunicorn/19.9.0

Request

View information

View function Arguments Keyword arguments URL name
mutational_landscape.views.render_variants () {'protein': 'GABR2_human'} render

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 409.83 ms (321 queries including 310 similar and 102 duplicates )
  Query Timeline Time (ms) Action
  +
SELECT ••• "protein"."id", "protein"."parent_id", "protein"."family_id", "protein"."species_id", "protein"."source_id", "protein"."residue_numbering_scheme_id", "protein"."sequence_type_id", "protein"."entry_name", "protein"."accession", "protein"."name", "protein"."sequence" FROM "protein" WHERE "protein"."entry_name" = 'gabr2_human'
0.9265540009889759%
 3.80

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(89)
  proteins.append(Protein.objects.get(entry_name=protein.lower()))
  +
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'State (micro-)switches'
  3 similar queries.
0.12315657814363419%
 0.50

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(128)
  micro_switches_rset = ResiduePositionSet.objects.get(name="State (micro-)switches")
  +
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 2
  3 similar queries.
0.423223479449664%
 1.73

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(130)
  for residue in micro_switches_rset.residue_position.all():
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 340) ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
3.04971057913261%
 12.50

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(135)
  for ms in ms_object:
  +
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'Sodium ion pocket'
  3 similar queries.
0.06922830797870794%
 0.28

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(139)
  sodium_pocket_rset = ResiduePositionSet.objects.get(name="Sodium ion pocket")
  +
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 3
  3 similar queries.
0.2425317781203642%
 0.99

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(141)
  for residue in sodium_pocket_rset.residue_position.all():
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" INNER JOIN "residue_generic_number" ON ("residue"."generic_number_id" = "residue_generic_number"."id") INNER JOIN "protein_conformation" ON ("residue"."protein_conformation_id" = "protein_conformation"."id") WHERE ("residue_generic_number"."label" IN ('5x47', '5x50', '6x30', '6x44', '6x50', '6x48', '6x34', '5x58', '3x40', '3x49', '3x50', '7x53', '7x50', '7x49', '7x43') AND "protein_conformation"."protein_id" = 340) ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
0.35091189388871113%
 1.44

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(146)
  for sp in sp_object:
  +
SELECT ••• "residue_ptm"."id", "residue_ptm"."protein_id", "residue_ptm"."residue_id", "residue_ptm"."modification" FROM "residue_ptm" WHERE "residue_ptm"."protein_id" IN (340)
0.38244277029582013%
 1.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(149)
  for ptm in ptms:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" IN (184320, 183171, 183583, 183715, 184360, 184204, 184237, 184208, 184255, 184019, 182520, 184025, 184249, 183167) ORDER BY "residue"."sequence_number" ASC
1.0122458477558973%
 4.15

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(149)
  for ptm in ptms:
  +
SELECT ••• "residue_position_set"."id", "residue_position_set"."name", "residue_position_set"."set_type", "residue_position_set"."protein_group" FROM "residue_position_set" WHERE "residue_position_set"."name" = 'G-protein interface'
  3 similar queries.
0.06981005846592396%
 0.29

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(154)
  rset = ResiduePositionSet.objects.get(name='G-protein interface')
  +
SELECT ••• "residue_generic_number_equivalent"."id", "residue_generic_number_equivalent"."default_generic_number_id", "residue_generic_number_equivalent"."scheme_id", "residue_generic_number_equivalent"."label" FROM "residue_generic_number_equivalent" INNER JOIN "residue_position_set_residue_position" ON ("residue_generic_number_equivalent"."id" = "residue_position_set_residue_position"."residuegenericnumberequivalent_id") WHERE "residue_position_set_residue_position"."residuepositionset_id" = 1
  3 similar queries.
0.2535850373774688%
 1.04

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(156)
  for residue in rset.residue_position.all():
  +
SELECT ••• "protein_family"."id", "protein_family"."parent_id", "protein_family"."slug", "protein_family"."name" FROM "protein_family" WHERE "protein_family"."id" = 448
0.13304633642630675%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(163)
  orthologs = Protein.objects.filter(family__slug=proteins[0].family.slug, sequence_type__slug='wt')
  +
SELECT ••• "interaction_residue_fragment"."id", "interaction_residue_fragment"."structure_ligand_pair_id", "interaction_residue_fragment"."rotamer_id", "interaction_residue_fragment"."fragment_id", "interaction_residue_fragment"."interaction_type_id" FROM "interaction_residue_fragment" INNER JOIN "interaction_structure_ligand" ON ("interaction_residue_fragment"."structure_ligand_pair_id" = "interaction_structure_ligand"."id") INNER JOIN "structure" ON ("interaction_structure_ligand"."structure_id" = "structure"."id") INNER JOIN "protein_conformation" ON ("structure"."protein_conformation_id" = "protein_conformation"."id") INNER JOIN "protein" ON ("protein_conformation"."protein_id" = "protein"."id") INNER JOIN "interaction_type_residue_fragment" ON ("interaction_residue_fragment"."interaction_type_id" = "interaction_type_residue_fragment"."id") WHERE ("interaction_structure_ligand"."annotated" = true AND "protein"."parent_id" IN (SELECT ••• U0."id" FROM "protein" U0 INNER JOIN "protein_family" U1 ON (U0."family_id" = U1."id") INNER JOIN "protein_sequence_type" U2 ON (U0."sequence_type_id" = U2."id") WHERE (U1."slug" = '004_002_001_003' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
50.273480904040255%
 206.04

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(170)
  for interaction in interactions:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85051
  117 similar queries.
0.7195671776375112%
 2.95

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636135
  117 similar queries.
0.6516768957794002%
 2.67

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85060
  117 similar queries.
0.3295616510078827%
 1.35

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636348
  117 similar queries.
0.5047848977573518%
 2.07

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85064
  117 similar queries.
0.07626748887402193%
 0.31

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636240
  117 similar queries.
0.07673288926379476%
 0.31

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85065
  117 similar queries.
0.07620931382530033%
 0.31

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636223
  117 similar queries.   Duplicated 2 times.
0.0793507664562669%
 0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85066
  117 similar queries.
0.07679106431251637%
 0.31

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636223
  117 similar queries.   Duplicated 2 times.
0.0828994444282847%
 0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85067
  117 similar queries.
0.07708193955612437%
 0.32

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636221
  117 similar queries.
0.08086331772302859%
 0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85068
  117 similar queries.
0.07725646470228918%
 0.32

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636200
  117 similar queries.   Duplicated 3 times.
0.08121236801535821%
 0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85069
  117 similar queries.
0.07999069199220454%
 0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636200
  117 similar queries.   Duplicated 3 times.
0.08185229355129585%
 0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85070
  117 similar queries.
0.0775473399458972%
 0.32

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636200
  117 similar queries.   Duplicated 3 times.
0.08138689316152302%
 0.33

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85077
  117 similar queries.
0.0775473399458972%
 0.32

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636606
  117 similar queries.
0.29477297187236395%
 1.21

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" = 27394
  32 similar queries.   Duplicated 2 times.
0.08836789900811541%
 0.36

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 3
  32 similar queries.   Duplicated 23 times.
0.08260856918467668%
 0.34

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(176)
  interactiontype = interaction.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85080
  117 similar queries.
0.07347508653538497%
 0.30

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue"."id", "residue"."protein_conformation_id", "residue"."protein_segment_id", "residue"."generic_number_id", "residue"."display_generic_number_id", "residue"."sequence_number", "residue"."amino_acid" FROM "residue" WHERE "residue"."id" = 23636610
  117 similar queries.
0.07865266587160767%
 0.32

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "residue_generic_number"."id", "residue_generic_number"."scheme_id", "residue_generic_number"."protein_segment_id", "residue_generic_number"."label" FROM "residue_generic_number" WHERE "residue_generic_number"."id" = 29058
  32 similar queries.   Duplicated 3 times.
0.07778004014078362%
 0.32

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(171)
  if interaction.rotamer.residue.generic_number:
  +
SELECT ••• "interaction_type_residue_fragment"."id", "interaction_type_residue_fragment"."slug", "interaction_type_residue_fragment"."name", "interaction_type_residue_fragment"."type", "interaction_type_residue_fragment"."direction" FROM "interaction_type_residue_fragment" WHERE "interaction_type_residue_fragment"."id" = 3
  32 similar queries.   Duplicated 23 times.
0.07591843858169231%
 0.31

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(176)
  interactiontype = interaction.interaction_type.name
  +
SELECT ••• "structure_rotamer"."id", "structure_rotamer"."residue_id", "structure_rotamer"."structure_id", "structure_rotamer"."pdbdata_id", "structure_rotamer"."missing_atoms" FROM "structure_rotamer" WHERE "structure_rotamer"."id" = 85086
  117 similar queries.
0.07888536606649407%