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
pe2r2_human 53 ICL1 D => ThrfsTer19 frameshift 9.631e-06 1 103836 0 None None
pe2r2_human 93 2.65x64 TM2 Y => Ter stop gained 8.566e-06 1 116740 0 None None LB (polar (charge-assisted hydrogen bond))
pe2r2_human 153 4.42x42 TM4 G => AlafsTer117 frameshift 8.448e-06 1 118374 0 None None
pe2r2_human 232 5.73x73 TM5 S => ArgfsTer40 frameshift 8.396e-06 1 119100 0 None None
pe2r2_human 273 6.44x44 TM6 F => SerfsTer16 frameshift 8.367e-06 1 119512 0 None None SodiumPocket MicroSwitch
pe2r2_human 292 ECL3 R => Ter stop gained 6.645e-05 8 120388 0 None None
pe2r2_human 349 C-term Q => Ter stop gained 1.65e-05 2 121226 0 None None
pe2r2_human 3 N-term N => S missense 1.897e-05 2 105416 0 nan 0.008
pe2r2_human 11 N-term E => G missense 9.484e-06 1 105440 0 0.12 0.002
pe2r2_human 12 N-term D => N missense 1.897e-05 2 105420 0 0.65 0.002
pe2r2_human 17 N-term Q => H missense 9.493e-06 1 105340 0 0.26 0.003
pe2r2_human 18 N-term W => R missense 9.496e-06 1 105312 0 0.39 0.096
pe2r2_human 22 N-term G => S missense 9.531e-06 1 104926 0 0.15 0.064
pe2r2_human 23 N-term E => D missense 9.535e-06 1 104882 0 0.2 0.006
pe2r2_human 26 1.37x37 TM1 A => G missense 9.529e-06 1 104942 0 0.22 0.608
pe2r2_human 33 1.44x44 TM1 S => L missense 1.904e-05 2 105062 0 0.2 0.202 PTM (Phosphorylation)
pe2r2_human 40 1.51x51 TM1 L => F missense 1.899e-05 2 105304 0 0.03 0.983
pe2r2_human 42 1.53x53 TM1 A => V missense 1.899e-05 2 105326 0 0.0 1.0
pe2r2_human 43 1.54x54 TM1 L => V missense 9.535e-06 1 104878 0 0.0 0.999
pe2r2_human 44 1.55x55 TM1 A => E missense 1.905e-05 2 104998 0 0.02 0.763
pe2r2_human 47 1.58x58 TM1 A => T missense 9.549e-06 1 104718 0 0.6 0.075
pe2r2_human 48 1.59x59 TM1 R => H missense 9.572e-06 1 104472 0 0.54 0.005
pe2r2_human 51 ICL1 R => L missense 3.852e-05 4 103838 0 0.03 0.009
pe2r2_human 51 ICL1 R => Q missense 2.889e-05 3 103838 0 0.06 0.066
pe2r2_human 53 ICL1 D => N missense 9.584e-06 1 104340 0 0.15 0.22
pe2r2_human 59 ICL1 G => R missense 9.391e-06 1 106482 0 0.57 0.029
pe2r2_human 60 ICL1 R => H missense 3.733e-05 4 107158 0 0.15 0.027
pe2r2_human 61 ICL1 R => S missense 9.255e-06 1 108044 0 0.05 0.043
pe2r2_human 62 ICL1 S => R missense 9.217e-06 1 108490 0 0.65 0.001 PTM (Phosphorylation)
pe2r2_human 71 2.43x43 TM2 V => L missense 8.853e-06 1 112962 0 0.01 0.649
pe2r2_human 71 2.43x43 TM2 V => M missense 8.853e-06 1 112962 0 0.0 0.995
pe2r2_human 73 2.45x45 TM2 E => K missense 2.633e-05 3 113934 0 0.84 0.617
pe2r2_human 73 2.45x45 TM2 E => Q missense 8.777e-06 1 113934 0 0.53 0.925
pe2r2_human 78 2.50x50 TM2 D => N missense 8.658e-06 1 115498 0 0.0 1.0
pe2r2_human 81 2.53x53 TM2 G => R missense 8.616e-06 1 116062 0 0.0 1.0
pe2r2_human 83 2.55x55 TM2 C => G missense 0.005392 628 116464 6 0.0 0.999
pe2r2_human 88 2.60x59 TM2 V => L missense 8.567e-06 1 116726 0 0.63 0.268
pe2r2_human 89 2.61x60 TM2 V => I missense 8.568e-06 1 116718 0 0.0 1.0 LB (hydrophobic)
pe2r2_human 104 ECL1 P => L missense 1.712e-05 2 116824 0 0.15 0.875
pe2r2_human 105 ECL1 E => K missense 8.558e-06 1 116846 0 0.69 0.003
pe2r2_human 109 3.25x25 TM3 C => R missense 8.556e-06 1 116874 0 0.0 1.0
pe2r2_human 116 3.32x32 TM3 M => V missense 8.55e-06 1 116958 0 0.0 0.999 LB (hydrophobic)
pe2r2_human 116 3.32x32 TM3 M => T missense 8.55e-06 1 116958 0 0.0 1.0 LB (hydrophobic)
pe2r2_human 123 3.39x39 TM3 T => A missense 8.543e-06 1 117052 0 0.06 0.986
pe2r2_human 126 3.42x42 TM3 M => V missense 8.538e-06 1 117130 0 0.33 0.027
pe2r2_human 128 3.44x44 TM3 F => L missense 8.538e-06 1 117118 0 0.24 0.116
pe2r2_human 129 3.45x45 TM3 A => S missense 8.538e-06 1 117126 0 0.09 0.773
pe2r2_human 130 3.46x46 TM3 M => I missense 8.531e-06 1 117216 0 0.0 0.992
pe2r2_human 136 3.52x52 TM3 L => V missense 0.0001192 14 117430 0 0.02 0.11
pe2r2_human 143 34.52x52 ICL2 F => S missense 8.481e-06 1 117908 0 0.0 0.846 GP (contact)
pe2r2_human 146 34.55x55 ICL2 R => H missense 8.468e-06 1 118088 0 0.0 0.957 GP (contact)
pe2r2_human 147 34.56x56 ICL2 R => C missense 8.466e-06 1 118126 0 0.08 0.013 GP (contact)
pe2r2_human 150 4.39x39 TM4 R => C missense 8.453e-06 1 118302 0 0.13 0.015
pe2r2_human 161 4.50x50 TM4 Y => F missense 5.858e-05 7 119496 0 0.18 0.717
pe2r2_human 164 4.53x53 TM4 S => P missense 8.36e-06 1 119624 0 0.06 0.972
pe2r2_human 165 4.54x54 TM4 L => M missense 2.507e-05 3 119676 0 0.1 0.944
pe2r2_human 172 4.61x61 TM4 L => Q missense 2.503e-05 3 119844 0 0.05 0.996
pe2r2_human 178 ECL2 Y => C missense 8.341e-06 1 119894 0 0.0 0.999
pe2r2_human 180 ECL2 Q => R missense 8.335e-06 1 119970 0 0.0 0.984
pe2r2_human 180 ECL2 Q => H missense 5.837e-05 7 119918 0 0.0 0.994
pe2r2_human 187 45.50x50 ECL2 C => W missense 8.291e-06 1 120616 0 0.0 1.0
pe2r2_human 190 ECL2 R => W missense 8.285e-06 1 120694 0 0.03 0.013
pe2r2_human 190 ECL2 R => Q missense 8.284e-06 1 120710 0 0.78 0.004
pe2r2_human 192 ECL2 G => A missense 8.28e-06 1 120778 0 0.22 0.063
pe2r2_human 195 5.36x36 TM5 A => S missense 2.483e-05 3 120838 0 0.21 0.055
pe2r2_human 197 5.38x38 TM5 L => P missense 8.273e-06 1 120870 0 0.32 0.962
pe2r2_human 204 5.45x45 TM5 L => P missense 1.654e-05 2 120894 0 0.0 0.998
pe2r2_human 210 5.51x51 TM5 S => P missense 3.311e-05 4 120792 0 0.01 0.529
pe2r2_human 216 5.57x57 TM5 F => C missense 4.145e-05 5 120620 0 0.05 0.014
pe2r2_human 221 5.62x62 TM5 N => Y missense 8.306e-06 1 120400 0 0.0 0.493
pe2r2_human 221 5.62x62 TM5 N => S missense 8.311e-06 1 120326 0 0.51 0.038
pe2r2_human 223 5.64x64 TM5 I => L missense 3.327e-05 4 120238 0 0.31 0.002 GP (contact)
pe2r2_human 230 5.71x71 TM5 R => Q missense 8.396e-06 1 119100 0 0.62 0.023 GP (contact)
pe2r2_human 233 5.74x74 TM5 R => H missense 8.384e-06 1 119274 0 0.0 0.982 GP (contact)
pe2r2_human 235 5.76x76 TM5 G => R missense 8.389e-06 1 119198 0 0.05 0.777
pe2r2_human 242 ICL3 R => W missense 1.686e-05 2 118626 0 0.0 0.806
pe2r2_human 242 ICL3 R => G missense 8.43e-06 1 118626 0 0.05 0.011
pe2r2_human 242 ICL3 R => Q missense 7.589e-05 9 118596 0 0.09 0.019
pe2r2_human 242 ICL3 R => P missense 8.432e-06 1 118596 0 0.07 0.019
pe2r2_human 247 ICL3 A => V missense 8.425e-06 1 118696 0 0.39 0.021
pe2r2_human 247 ICL3 A => D missense 8.425e-06 1 118696 0 0.6 0.094
pe2r2_human 248 ICL3 R => H missense 8.42e-06 1 118758 0 0.06 0.015
pe2r2_human 249 ICL3 R => K missense 1.681e-05 2 118980 0 0.29 0.012
pe2r2_human 249 ICL3 R => S missense 8.401e-06 1 119030 0 0.1 0.063
pe2r2_human 252 ICL3 E => Q missense 0.0001006 12 119230 0 0.28 0.533
pe2r2_human 252 ICL3 E => K missense 2.516e-05 3 119230 0 0.14 0.038
pe2r2_human 262 6.33x33 TM6 H => Q missense 8.354e-06 1 119708 0 0.0 0.972 GP (contact)
pe2r2_human 263 6.34x34 TM6 L => F missense 8.353e-06 1 119716 0 0.0 0.998 SodiumPocket MicroSwitch
pe2r2_human 264 6.35x35 TM6 I => T missense 5.012e-05 6 119720 0 0.0 0.629
pe2r2_human 265 6.36x36 TM6 L => P missense 8.352e-06 1 119736 0 0.0 0.942 GP (contact)
pe2r2_human 268 6.39x39 TM6 I => V missense 8.358e-06 1 119648 0 0.2 0.026
pe2r2_human 271 6.42x42 TM6 I => V missense 8.368e-06 1 119502 0 0.26 0.37
pe2r2_human 271 6.42x42 TM6 I => T missense 8.371e-06 1 119466 0 0.02 0.961
pe2r2_human 274 6.45x45 TM6 A => D missense 8.389e-06 1 119206 0 0.0 0.925
pe2r2_human 277 6.48x48 TM6 S => C missense 8.399e-06 1 119060 0 0.0 0.995 SodiumPocket MicroSwitch
pe2r2_human 281 6.52x52 TM6 T => M missense 4.217e-05 5 118568 0 0.0 0.896
pe2r2_human 285 6.56x56 TM6 Y => C missense 0.001669 199 119248 3 0.0 0.566
pe2r2_human 287 ECL3 N => S missense 2.505e-05 3 119768 0 0.06 0.191
pe2r2_human 292 ECL3 R => Q missense 1.661e-05 2 120438 0 0.45 0.009
pe2r2_human 293 ECL3 K => E missense 2.489e-05 3 120522 0 0.86 0.004
pe2r2_human 299 7.37x36 TM7 Q => H missense 1.655e-05 2 120818 0 0.12 0.617
pe2r2_human 300 7.38x37 TM7 A => V missense 8.275e-06 1 120840 0 0.04 0.458
pe2r2_human 306 7.44x43 TM7 I => V missense 0.0001157 14 121034 0 0.5 0.008 SodiumPocket MicroSwitch
pe2r2_human 312 7.50x50 TM7 P => L missense 8.249e-06 1 121228 0 0.0 0.997 SodiumPocket MicroSwitch
pe2r2_human 313 7.51x51 TM7 W => L missense 8.248e-06 1 121242 0 0.02 0.651
pe2r2_human 327 8.55x55 H8 R => C missense 8.24e-06 1 121364 0 0.01 0.891
pe2r2_human 327 8.55x55 H8 R => H missense 8.24e-06 1 121366 0 0.04 0.891
pe2r2_human 331 8.59x59 H8 C => S missense 1.648e-05 2 121372 0 0.05 0.965
pe2r2_human 333 C-term R => W missense 8.239e-06 1 121368 0 0.0 0.724
pe2r2_human 338 C-term T => S missense 1.648e-05 2 121352 0 0.52 0.003
pe2r2_human 342 C-term T => I missense 8.242e-06 1 121326 0 0.28 0.001
pe2r2_human 345 C-term S => F missense 8.245e-06 1 121292 0 0.05 0.59
pe2r2_human 346 C-term C => Y missense 0.0001319 16 121280 0 0.23 0.248
pe2r2_human 357 C-term D => E missense 3.318e-05 4 120542 0 0.19 0.004


Residue

Diagrams

ICL1 W R G D V G C S A G R R S S L ICL1ECL1 Q T L V A L A P E ECL1ICL2 P Y F Y Q R R V ICL2ECL2 Y G Q Y V Q Y C P G T W C F I R H G R ECL2ICL3 P S L G S G R G G P G A R R R G E ICL3ECL3 N E T S S R K E K ECL3N-term M G N A S N D S Q S E D C E T R Q W L P P G E N-termC-term R I S L R T Q D A T Q T S C S T Q S D A S K Q A D L C-term S P A I S S V M F S A G V L G N L I A L A L L A R R S L F H V L V T E L V F T D L L G T C L I S P V V L A S Y A R N S R A C T Y F A F A M T F F S L A T M L M L F A M A L E R Y L S I G H S R S G G L A V L P V I Y A V S L L F C S L P L L D T A Y L Q L Y A T L L L L L I V S V L A C N F S V I L N L I R M H R R S R R S R C G R V S M A E E T D H L I L L A I M T I T F A V C S L P F T I F A Y M W D L Q A L R F L S I N S I I D P W V F A I L R P P M R S V L R L V L C C
SnakePlot Download: PNG | SVG L N G L V G A S F M V S S I A P S 1 T E L V F T D L L G T L C I S P V V L A S 2 A F L M L M T A L S F F T M A F A F Y T 3 G L A V L P V I Y A V S L L F C S L P L 4 S F N C A L V S V I L L L L L T A Y L Q 5 A I M T I T F A V C S L P F T I F A Y M 6 W P D I I S N I S L F R L A Q L D W 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 2125.626 msec
System CPU time 64.012 msec
Total CPU time 2189.638 msec
Elapsed time 2489.759 msec
Context switches 186 voluntary, 29 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 481982
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/PE2R2_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': 'PE2R2_human'} render

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 313.35 ms (163 queries including 154 similar and 69 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" = 'pe2r2_human'
0.8302632159612624%
 2.60

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.16335915731935763%
 0.51

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.5489689427383164%
 1.72

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" = 172) ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
0.8497415318782422%
 2.66

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.09069590848843703%
 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.31766394122418173%
 1.00

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" = 172) ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
0.3818054268414237%
 1.20

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 (172)
1.6736895126007967%
 5.24

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 (71328, 70283, 70398, 70261, 70358, 71034, 70462, 71039) ORDER BY "residue"."sequence_number" ASC
1.329623322848521%
 4.17

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.09518505160992846%
 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(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.33067484755935184%
 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" = 230
0.16762003892619698%
 0.53

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" = '001_004_008_004' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
65.88996881947709%
 206.47

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" = 11970
  37 similar queries.
0.5485885068805629%
 1.72

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" = 23573167
  37 similar queries.
0.5780342422706847%
 1.81

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" = 20446
  33 similar queries.   Duplicated 3 times.
0.11580467510016876%
 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
  33 similar queries.   Duplicated 13 times.
0.11002205006231539%
 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" = 11976
  37 similar queries.
0.0965546206978411%
 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" = 23573198
  37 similar queries.
0.38150107815522083%
 1.20

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" = 30306
  33 similar queries.   Duplicated 3 times.
0.09746766675644952%
 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 ••• "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
  33 similar queries.   Duplicated 13 times.
0.09366330817891443%
 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(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" = 12261
  37 similar queries.
0.10636986582788169%
 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" = 23573354
  37 similar queries.
0.3942837229757389%
 1.24

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" = 85164
  33 similar queries.   Duplicated 3 times.
0.10180463553483955%
 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
  33 similar queries.   Duplicated 13 times.
0.09411983120821864%
 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(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" = 12269
  37 similar queries.
0.09586983615388478%
 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" = 23573361
  37 similar queries.
0.10393507633825923%
 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_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" = 87493
  33 similar queries.
0.10256550725034658%
 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" = 7
  33 similar queries.   Duplicated 3 times.
0.10302203027965078%
 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(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" = 12270
  37 similar queries.
0.4424469025673334%
 1.39

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" = 23573164
  37 similar queries.
0.10256550725034658%
 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" = 19
  33 similar queries.   Duplicated 4 times.
0.09853288715815935%
 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 ••• "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" = 7
  33 similar queries.   Duplicated 3 times.
0.09411983120821864%
 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(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" = 12271
  37 similar queries.
0.09883723584436217%
 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" = 23573126
  37 similar queries.   Duplicated 2 times.
0.1073589990580408%
 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 ••• "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" = 1695
  33 similar queries.   Duplicated 4 times.
0.09746766675644952%
 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 ••• "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" = 4
  33 similar queries.   Duplicated 8 times.
0.09465244140907354%
 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(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" = 12272
  37 similar queries.
0.09472852858062425%
 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" = 23573126
  37 similar queries.   Duplicated 2 times.
0.0997502819029706%
 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_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" = 1695
  33 similar queries.   Duplicated 4 times.
0.09936984604521709%
 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 ••• "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" = 4
  33 similar queries.   Duplicated 8 times.
0.10477203522531693%
 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(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" = 12273
  37 similar queries.
0.10218507139259307%
 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" = 23573267
  37 similar queries.
0.1065220401709831%
 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" = 12274
  37 similar queries.
0.10081550230468042%
 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" = 23573358
  37 similar queries.
0.10591334279857748%
 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_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" = 86651
  33 similar queries.   Duplicated 3 times.
0.1002068049322748%
 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 ••• "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" = 15
  33 similar queries.   Duplicated 3 times.
0.09769592827110164%
 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" = 12275
  37 similar queries.
0.1002068049322748%
 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" = 23573175
  37 similar queries.   Duplicated 2 times.
0.1066742145140845%
 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_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" = 23742
  33 similar queries.   Duplicated 4 times.
0.10408725068136063%
 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 ••• "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" = 4
  33 similar queries.   Duplicated 8 times.
0.09838071281505795%
 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" = 12276
  37 similar queries.
0.20087013289385383%
 0.63

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" = 23573175
  37 similar queries.   Duplicated 2 times.
0.09815245130040584%
 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_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" = 23742
  33 similar queries.   Duplicated 4 times.
0.09434809272287073%
 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 ••• "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" = 4
  33 similar queries.   Duplicated 8 times.
0.09670679504094251%
 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(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" = 12277
  37 similar queries.
0.0930546108065088%
 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(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" = 23573168
  37 similar queries.
0.10385898916670852%
 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_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" = 20862
  33 similar queries.   Duplicated 3 times.
0.10614160431322958%
 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 ••• "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" = 8
  33 similar queries.   Duplicated 5 times.
0.09389156969356652%
 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(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" = 98228
  37 similar queries.
0.8415241173507664%
 2.64

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" = 23648569
  37 similar queries.
1.0872095942879838%
 3.41

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" = 3646
  33 similar queries.
0.10028289210382552%
 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 ••• "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
  33 similar queries.   Duplicated 13 times.
0.09701114372714531%
 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(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" = 98234
  37 similar queries.
0.09693505655559462%
 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" = 23648606
  37 similar queries.
0.10553290694082396%
 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_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" = 20446
  33 similar queries.   Duplicated 3 times.
0.1037829019951578%
 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 ••• "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
  33 similar queries.   Duplicated 13 times.
0.10256550725034658%
 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(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" = 98237
  37 similar queries.
0.10081550230468042%
 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" = 23648610
  37 similar queries.
0.1069024760287366%
 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_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" = 22078
  33 similar queries.
0.10553290694082396%
 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 ••• "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
  33 similar queries.   Duplicated 13 times.
0.09739157958489883%
 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" = 98241
  37 similar queries.
0.10302203027965078%
 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" = 23648637
  37 similar queries.
0.5834364314507845%
 1.83

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" = 30306
  33 similar queries.   Duplicated 3 times.
0.09632635918318899%
 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 ••• "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
  33 similar queries.   Duplicated 13 times.
0.09320678514961021%
 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(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" = 98243
  37 similar queries.
0.09579374898233409%
 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" = 23648640
  37 similar queries.
0.41946857675902127%
 1.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_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" = 31554
  33 similar queries.
0.09845679998660867%
 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 ••• "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
  33 similar queries.   Duplicated 13 times.
0.09366330817891443%
 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(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" = 96561
  37 similar queries.
0.6414909433439703%
 2.01

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" = 23648707
  37 similar queries.
0.44731648154657827%
 1.40

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" = 98249
  37 similar queries.
0.09495679009527636%
 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" = 23648792
  37 similar queries.
0.42859903734510557%
 1.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 ••• "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" = 85164
  33 similar queries.   Duplicated 3 times.
0.09419591837976933%
 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 ••• "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
  33 similar queries.   Duplicated 13 times.
0.0960220104969862%
 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(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" = 98255
  37 similar queries.
0.32527265837925196%
 1.02

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" = 23648603
  37 similar queries.   Duplicated 2 times.
0.0997502819029706%
 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_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" = 19
  33 similar queries.   Duplicated 4 times.
0.09860897432971007%
 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 ••• "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" = 8
  33 similar queries.   Duplicated 5 times.
0.09351113383581301%
 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(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" = 98256
  37 similar queries.
0.0964024463547397%
 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" = 23648603
  37 similar queries.   Duplicated 2 times.
0.11177205500798154%
 0.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_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" = 19
  33 similar queries.   Duplicated 4 times.
0.09404374403666793%
 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(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" = 5
  33 similar queries.
0.09145678020394406%
 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(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" = 98257
  37 similar queries.
0.09389156969356652%
 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(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" = 23648565
  37 similar queries.
0.09936984604521709%
 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_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" = 1695
  33 similar queries.   Duplicated 4 times.
0.09898941018746357%
 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 ••• "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" = 4
  33 similar queries.   Duplicated 8 times.
0.10172854836328885%
 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(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" = 98258
  37 similar queries.
0.1036307276520564%
 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" = 23648706
  37 similar queries.
0.10751117340114223%
 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" = 98259
  37 similar queries.
0.10127202533398465%
 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" = 23648796
  37 similar queries.
0.10941335268990976%
 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 ••• "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" = 86651
  33 similar queries.   Duplicated 3 times.
0.10134811250553533%
 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" = 15
  33 similar queries.   Duplicated 3 times.
0.09784810261420304%
 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" = 98260
  37 similar queries.
0.1000546305891734%
 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_n