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
pth2r_human 11 N-term W => Ter stop gained 1.834e-05 2 109046 0 None None
pth2r_human 82 N-term S => Ter stop gained 0.01262 1525 120832 17 None None
pth2r_human 101 N-term R => Ter stop gained 7.431e-05 9 121112 0 None None
pth2r_human 103 N-term C => LeufsTer2 frameshift 8.255e-06 1 121144 0 None None
pth2r_human 130 1.25x25 TM1 Q => Ter stop gained 8.255e-06 1 121144 0 None None LB (polar (hydrogen bond), polar (charge-assisted hydrogen bond))
pth2r_human 145 1.40x40 TM1 Y => LeufsTer2 frameshift 1.647e-05 2 121400 0 None None
pth2r_human 171 12.49x49 ICL1 R => Ter stop gained 2.63e-05 3 114080 0 None None
pth2r_human 209 ECL1 E => AspfsTer5 frameshift 1.651e-05 2 121106 0 None None
pth2r_human 216 ECL1 Q => Ter stop gained 8.281e-06 1 120764 0 None None
pth2r_human 232 ECL1 Q => Ter stop gained 8.55e-06 1 116956 0 None None
pth2r_human 233 3.26x26 TM3 Y => Ter stop gained 8.583e-06 1 116516 0 None None
pth2r_human 284 4.50x50 TM4 W => Ter stop gained 0.0003564 43 120636 0 None None
pth2r_human 294 4.60x60 TM4 W => Ter stop gained 8.237e-06 1 121402 0 None None
pth2r_human 298 4.64x64 TM4 R => Ter stop gained 8.237e-06 1 121402 0 None None
pth2r_human 316 5.37x38 TM5 W => Ter stop gained 2.472e-05 3 121342 0 None None
pth2r_human 316 5.37x38 TM5 W => Ter stop gained 2.472e-05 3 121340 0 None None
pth2r_human 337 5.58x58 TM5 V => LeufsTer4 frameshift 8.317e-06 1 120240 0 None None
pth2r_human 345 5.66x66 TM5 W => Ter stop gained 8.271e-06 1 120902 0 None None
pth2r_human 384 ECL3 H => ThrfsTer41 frameshift 4.122e-05 5 121306 0 None None
pth2r_human 453 C-term T => ProfsTer3 frameshift 8.838e-06 1 113154 0 None None
pth2r_human 477 C-term K => Ter stop gained 5.122e-05 6 117140 0 None None
pth2r_human 5 N-term G => R missense 9.202e-06 1 108668 0 nan 0.002
pth2r_human 6 N-term A => T missense 9.196e-06 1 108746 0 nan 0.001
pth2r_human 10 N-term V => I missense 0.0005965 65 108976 0 nan 0.001
pth2r_human 11 N-term W => G missense 9.175e-06 1 108996 0 nan 0.051
pth2r_human 15 N-term M => K missense 9.166e-06 1 109100 0 0.01 0.01
pth2r_human 15 N-term M => T missense 9.166e-06 1 109100 0 0.05 0.006
pth2r_human 17 N-term G => R missense 8.247e-05 9 109124 0 0.35 0.001
pth2r_human 17 N-term G => C missense 9.164e-06 1 109124 0 0.2 0.346
pth2r_human 18 N-term S => R missense 9.165e-06 1 109114 0 0.42 0.001 PTM (Phosphorylation)
pth2r_human 18 N-term S => R missense 3.665e-05 4 109126 0 0.42 0.001 PTM (Phosphorylation)
pth2r_human 29 N-term D => G missense 3.437e-05 4 116394 0 0.02 0.123
pth2r_human 30 N-term G => S missense 8.576e-06 1 116606 0 0.09 0.248
pth2r_human 31 N-term T => N missense 2.564e-05 3 116984 0 0.02 0.355
pth2r_human 33 N-term T => P missense 8.532e-06 1 117210 0 0.0 0.936
pth2r_human 34 N-term I => V missense 4.261e-05 5 117334 0 1.0 0.051
pth2r_human 36 N-term E => G missense 8.515e-06 1 117438 0 0.0 0.947
pth2r_human 38 N-term I => T missense 5.966e-05 7 117332 0 0.0 0.366
pth2r_human 40 N-term L => I missense 8.541e-06 1 117082 0 0.08 0.205
pth2r_human 44 N-term A => E missense 8.656e-06 1 115524 0 0.02 0.994
pth2r_human 44 N-term A => V missense 2.597e-05 3 115524 0 0.09 0.271
pth2r_human 45 N-term K => E missense 8.683e-06 1 115174 0 0.0 0.619
pth2r_human 48 N-term C => R missense 8.845e-06 1 113056 0 0.0 1.0
pth2r_human 49 N-term E => G missense 3.566e-05 4 112166 0 0.0 0.368
pth2r_human 51 N-term N => I missense 9.065e-06 1 110320 0 0.05 0.885
pth2r_human 51 N-term N => S missense 9.065e-06 1 110320 0 0.17 0.099
pth2r_human 56 N-term L => I missense 0.0002474 26 105080 0 0.13 0.007
pth2r_human 65 N-term P => S missense 8.301e-06 1 120470 0 0.01 1.0
pth2r_human 68 N-term D => V missense 8.285e-06 1 120700 0 0.0 1.0
pth2r_human 72 N-term C => F missense 4.138e-05 5 120818 0 0.0 1.0
pth2r_human 73 N-term W => R missense 2.483e-05 3 120834 0 0.0 0.997
pth2r_human 75 N-term R => G missense 2.482e-05 3 120890 0 0.09 0.886
pth2r_human 78 N-term V => A missense 8.27e-06 1 120926 0 0.25 0.023
pth2r_human 79 N-term G => E missense 3.308e-05 4 120920 0 0.0 0.999
pth2r_human 82 N-term S => L missense 8.276e-06 1 120832 0 0.19 0.004
pth2r_human 87 N-term P => R missense 6.628e-05 8 120698 0 0.0 1.0
pth2r_human 90 N-term I => V missense 8.29e-06 1 120634 0 0.09 0.037
pth2r_human 91 N-term Y => C missense 0.0003068 37 120604 0 0.0 0.994
pth2r_human 95 N-term H => R missense 8.304e-06 1 120430 0 0.0 0.976
pth2r_human 95 N-term H => P missense 5.813e-05 7 120430 0 0.0 0.997
pth2r_human 96 N-term K => I missense 8.308e-06 1 120368 0 0.0 0.739
pth2r_human 97 N-term G => R missense 8.312e-06 1 120308 0 0.0 1.0
pth2r_human 98 N-term V => I missense 0.0002477 30 121090 0 0.38 0.213
pth2r_human 99 N-term A => T missense 1.652e-05 2 121094 0 0.0 1.0
pth2r_human 101 N-term R => Q missense 2.477e-05 3 121118 0 0.0 1.0
pth2r_human 102 N-term H => Y missense 8.255e-06 1 121140 0 0.29 0.794
pth2r_human 102 N-term H => Q missense 8.255e-06 1 121144 0 0.24 0.063
pth2r_human 103 N-term C => R missense 8.255e-06 1 121146 0 0.0 1.0
pth2r_human 106 N-term N => D missense 3.302e-05 4 121156 0 0.09 0.999
pth2r_human 106 N-term N => S missense 4.127e-05 5 121162 0 0.18 0.994
pth2r_human 109 N-term W => C missense 0.0008418 102 121166 0 0.0 0.999
pth2r_human 119 N-term W => R missense 8.252e-06 1 121180 0 0.01 0.173
pth2r_human 120 N-term A => T missense 4.126e-05 5 121174 0 0.09 0.032
pth2r_human 120 N-term A => D missense 8.252e-06 1 121184 0 0.0 0.519
pth2r_human 120 N-term A => V missense 8.252e-06 1 121184 0 0.06 0.008
pth2r_human 125 N-term C => G missense 5.776e-05 7 121184 0 0.02 0.999
pth2r_human 127 N-term R => C missense 0.0001568 19 121172 0 0.02 0.912
pth2r_human 127 N-term R => H missense 0.0001651 20 121156 0 0.24 0.016
pth2r_human 132 1.27x27 TM1 D => N missense 0.0001156 14 121124 0 0.31 0.011
pth2r_human 133 1.28x28 TM1 I => T missense 1.651e-05 2 121120 0 0.49 0.002
pth2r_human 135 1.30x30 TM1 I => L missense 8.258e-06 1 121100 0 0.3 0.002
pth2r_human 139 1.34x34 TM1 E => K missense 8.239e-06 1 121378 0 0.09 0.275
pth2r_human 141 1.36x36 TM1 F => L missense 8.238e-06 1 121384 0 0.01 0.491 LB (hydrophobic)
pth2r_human 143 1.38x38 TM1 R => C missense 0.01151 1397 121394 13 0.0 0.967
pth2r_human 143 1.38x38 TM1 R => H missense 8.238e-06 1 121394 0 0.03 0.934
pth2r_human 145 1.40x40 TM1 Y => C missense 3.295e-05 4 121394 0 0.11 0.951
pth2r_human 148 1.43x43 TM1 Y => H missense 8.237e-06 1 121406 0 0.0 0.992
pth2r_human 150 1.45x45 TM1 V => I missense 1.647e-05 2 121406 0 0.36 0.02
pth2r_human 153 1.48x48 TM1 S => Y missense 8.237e-06 1 121406 0 0.0 0.995
pth2r_human 154 1.49x49 TM1 I => T missense 8.237e-06 1 121404 0 0.07 0.297
pth2r_human 155 1.50x50 TM1 S => F missense 6.59e-05 8 121404 0 0.02 0.992
pth2r_human 157 1.52x52 TM1 G => A missense 8.237e-06 1 121404 0 1.0 0.019
pth2r_human 162 1.57x57 TM1 A => S missense 0.000313 38 121402 0 0.01 0.961
pth2r_human 163 1.58x58 TM1 I => V missense 8.237e-06 1 121400 0 1.0 0.042
pth2r_human 165 1.60x60 TM1 I => F missense 1.648e-05 2 121396 0 0.01 0.905
pth2r_human 165 1.60x60 TM1 I => V missense 1.648e-05 2 121396 0 0.03 0.12
pth2r_human 166 1.61x61 TM1 I => L missense 1.647e-05 2 121400 0 1.0 0.06
pth2r_human 166 1.61x61 TM1 I => T missense 1.648e-05 2 121396 0 0.01 0.219
pth2r_human 167 1.62x62 TM1 G => R missense 8.238e-06 1 121390 0 0.02 0.983
pth2r_human 167 1.62x62 TM1 G => S missense 8.238e-06 1 121390 0 0.45 0.609
pth2r_human 167 1.62x62 TM1 G => V missense 8.238e-06 1 121394 0 0.09 0.58
pth2r_human 169 1.64x64 TM1 F => L missense 1.648e-05 2 121392 0 0.03 0.852
pth2r_human 174 2.44x44 TM2 C => Y missense 8.62e-06 1 116008 0 0.0 0.997
pth2r_human 177 2.47x47 TM2 N => D missense 8.524e-06 1 117316 0 0.01 1.0
pth2r_human 180 2.50x50 TM2 H => D missense 8.441e-06 1 118464 0 0.0 1.0
pth2r_human 180 2.50x50 TM2 H => L missense 1.686e-05 2 118626 0 0.02 1.0
pth2r_human 181 2.51x51 TM2 M => I missense 2.519e-05 3 119108 0 0.28 0.02
pth2r_human 185 2.55x55 TM2 V => M missense 0.0005162 62 120108 0 0.03 0.517
pth2r_human 185 2.55x55 TM2 V => A missense 8.322e-06 1 120160 0 0.37 0.075
pth2r_human 191 2.61x61 TM2 A => T missense 1.654e-05 2 120908 0 0.0 0.997
pth2r_human 194 2.64x64 TM2 I => V missense 1.652e-05 2 121054 0 0.09 0.934
pth2r_human 194 2.64x64 TM2 I => M missense 1.652e-05 2 121062 0 0.0 0.995
pth2r_human 202 2.72x72 TM2 H => P missense 8.254e-06 1 121154 0 0.05 0.932
pth2r_human 204 2.74x74 TM2 H => R missense 1.651e-05 2 121146 0 0.54 0.008
pth2r_human 223 ECL1 I => T missense 0.000209 25 119624 0 0.59 0.034
pth2r_human 225 ECL1 A => S missense 0.002758 329 119302 2 0.45 0.024
pth2r_human 225 ECL1 A => V missense 8.393e-06 1 119154 0 0.21 0.008
pth2r_human 229 ECL1 D => H missense 1.696e-05 2 117930 0 0.06 0.971
pth2r_human 229 ECL1 D => G missense 8.491e-06 1 117772 0 0.04 0.167
pth2r_human 233 3.26x26 TM3 Y => H missense 8.573e-06 1 116642 0 0.03 0.998
pth2r_human 242 3.35x35 TM3 M => L missense 8.256e-06 1 121120 0 1.0 0.009
pth2r_human 242 3.35x35 TM3 M => I missense 4.952e-05 6 121160 0 0.06 0.213
pth2r_human 248 3.41x41 TM3 A => S missense 8.242e-06 1 121330 0 0.03 0.964
pth2r_human 252 3.45x45 TM3 Y => H missense 2.472e-05 3 121366 0 0.03 0.948
pth2r_human 252 3.45x45 TM3 Y => F missense 1.648e-05 2 121368 0 0.08 0.068
pth2r_human 258 3.51x51 TM3 G => D missense 8.238e-06 1 121392 0 0.0 1.0
pth2r_human 264 3.57x57 TM3 L => V missense 3.295e-05 4 121390 0 0.0 0.903 GP (contact)
pth2r_human 264 3.57x57 TM3 L => F missense 8.238e-06 1 121390 0 0.0 0.991 GP (contact)
pth2r_human 265 3.58x58 TM3 I => M missense 3.295e-05 4 121388 0 0.0 0.99 GP (contact)
pth2r_human 267 3.60x60 TM3 V => M missense 8.238e-06 1 121386 0 1.0 0.124 GP (contact)
pth2r_human 268 ICL2 A => T missense 8.239e-06 1 121378 0 0.12 0.794
pth2r_human 270 ICL2 F => V missense 8.239e-06 1 121374 0 0.01 0.672
pth2r_human 271 ICL2 S => P missense 8.239e-06 1 121372 0 0.0 0.985
pth2r_human 271 ICL2 S => L missense 2.472e-05 3 121370 0 0.02 0.961
pth2r_human 272 ICL2 D => V missense 8.24e-06 1 121356 0 0.04 0.905
pth2r_human 274 ICL2 K => E missense 1.648e-05 2 121342 0 0.04 0.72
pth2r_human 278 4.44x45 TM4 G => D missense 4.125e-05 5 121198 0 0.01 0.999
pth2r_human 278 4.44x45 TM4 G => V missense 8.251e-06 1 121198 0 0.19 0.999
pth2r_human 280 4.46x47 TM4 I => F missense 8.256e-06 1 121118 0 0.01 0.723
pth2r_human 285 4.51x51 TM4 G => V missense 8.241e-06 1 121350 0 0.02 0.982
pth2r_human 289 4.55x55 TM4 A => T missense 2.471e-05 3 121398 0 0.12 0.011
pth2r_human 294 4.60x60 TM4 W => R missense 1.647e-05 2 121400 0 0.03 0.968
pth2r_human 296 4.62x62 TM4 V => L missense 8.237e-06 1 121402 0 0.52 0.014
pth2r_human 299 4.65x65 TM4 A => E missense 8.237e-06 1 121400 0 0.0 0.991
pth2r_human 300 4.66x66 TM4 T => A missense 1.647e-05 2 121398 0 0.07 0.044
pth2r_human 303 ECL2 D => H missense 0.0001153 14 121396 0 0.01 0.95
pth2r_human 304 ECL2 A => V missense 8.238e-06 1 121396 0 0.01 0.173
pth2r_human 306 45.50x50 ECL2 C => F missense 8.241e-06 1 121340 0 0.0 0.99
pth2r_human 310 ECL2 S => T missense 8.241e-06 1 121350 0 0.05 0.153
pth2r_human 311 5.32x33 TM5 A => T missense 8.241e-06 1 121340 0 0.0 0.914
pth2r_human 311 5.32x33 TM5 A => V missense 2.472e-05 3 121346 0 0.08 0.358
pth2r_human 315 5.36x37 TM5 K => R missense 1.648e-05 2 121344 0 0.05 0.143
pth2r_human 320 5.41x41 TM5 A => V missense 4.121e-05 5 121332 0 1.0 0.054
pth2r_human 320 5.41x41 TM5 A => G missense 8.242e-06 1 121332 0 0.16 0.806
pth2r_human 321 5.42x42 TM5 P => S missense 8.242e-06 1 121326 0 0.0 0.986
pth2r_human 321 5.42x42 TM5 P => L missense 4.121e-05 5 121328 0 0.02 0.476
pth2r_human 322 5.43x43 TM5 I => T missense 8.242e-06 1 121326 0 0.0 0.925 SodiumPocket MicroSwitch LB (hydrophobic)
pth2r_human 326 5.47x47 TM5 I => V missense 8.246e-06 1 121270 0 0.15 0.026
pth2r_human 326 5.47x47 TM5 I => M missense 8.247e-06 1 121250 0 0.0 0.89
pth2r_human 330 5.51x51 TM5 F => Y missense 7.625e-05 9 118032 0 0.01 1.0
pth2r_human 335 5.56x56 TM5 N => K missense 7.492e-05 9 120126 0 0.01 1.0
pth2r_human 336 5.57x57 TM5 T => M missense 0.0001331 16 120240 0 0.0 0.995 GP (contact)
pth2r_human 340 5.61x61 TM5 L => Q missense 8.286e-06 1 120682 0 0.0 1.0 GP (contact)
pth2r_human 342 5.63x63 TM5 T => A missense 1.656e-05 2 120768 0 0.0 0.999 GP (contact)
pth2r_human 345 5.66x66 TM5 W => L missense 9.926e-05 12 120894 0 0.19 0.9
pth2r_human 348 ICL3 N => Y missense 1.654e-05 2 120928 0 0.0 1.0
pth2r_human 348 ICL3 N => S missense 2.481e-05 3 120926 0 0.0 0.999
pth2r_human 350 ICL3 V => I missense 8.269e-06 1 120930 0 0.98 0.053
pth2r_human 350 ICL3 V => F missense 8.269e-06 1 120930 0 0.08 0.795
pth2r_human 350 ICL3 V => A missense 0.0009179 111 120932 4 0.19 0.423
pth2r_human 351 ICL3 G => R missense 1.654e-05 2 120912 0 1.0 0.766
pth2r_human 362 6.39x39 TM6 A => S missense 1.651e-05 2 121170 0 0.14 0.687 SodiumPocket MicroSwitch
pth2r_human 364 6.41x41 TM6 S => L missense 5.776e-05 7 121196 0 0.0 1.0 GP (contact)
pth2r_human 365 6.42x42 TM6 T => I missense 1.65e-05 2 121222 0 0.0 1.0 GP (contact)
pth2r_human 366 6.43x43 TM6 L => Q missense 8.248e-06 1 121242 0 0.0 0.777
pth2r_human 369 6.46x46 TM6 V => I missense 8.247e-06 1 121260 0 0.38 0.152
pth2r_human 372 6.49x49 TM6 F => L missense 8.247e-06 1 121260 0 0.0 0.999 SodiumPocket MicroSwitch
pth2r_human 373 6.50x50 TM6 G => A missense 8.247e-06 1 121252 0 0.0 1.0
pth2r_human 374 6.51x51 TM6 V => M missense 1.649e-05 2 121296 0 0.03 0.633
pth2r_human 375 6.52x52 TM6 H => Q missense 8.244e-06 1 121296 0 0.0 1.0
pth2r_human 380 6.57x57 TM6 V => I missense 1.649e-05 2 121288 0 0.27 0.05
pth2r_human 387 ECL3 T => A missense 8.243e-06 1 121314 0 nan 0.012
pth2r_human 390 7.34x33 TM7 G => R missense 2.473e-05 3 121308 0 nan 0.952
pth2r_human 390 7.34x33 TM7 G => R missense 8.243e-06 1 121308 0 nan 0.952
pth2r_human 390 7.34x33 TM7 G => V missense 8.242e-06 1 121326 0 nan 0.864
pth2r_human 393 7.37x36 TM7 I => F missense 0.0001484 18 121326 0 nan 0.857
pth2r_human 394 7.38x37 TM7 R => C missense 4.121e-05 5 121318 0 nan 1.0
pth2r_human 394 7.38x37 TM7 R => P missense 8.243e-06 1 121314 0 nan 1.0
pth2r_human 394 7.38x37 TM7 R => H missense 1.649e-05 2 121314 0 nan 1.0
pth2r_human 399 7.43x42 TM7 L => F missense 8.242e-06 1 121326 0 nan 1.0 LB (hydrophobic)
pth2r_human 402 7.46x45 TM7 N => Y missense 8.243e-06 1 121310 0 nan 1.0
pth2r_human 403 7.47x46 TM7 S => P missense 8.244e-06 1 121306 0 nan 1.0
pth2r_human 404 7.48x47 TM7 F => S missense 8.244e-06 1 121300 0 0.27 1.0 SodiumPocket MicroSwitch
pth2r_human 411 7.55x55 TM7 I => V missense 8.243e-06 1 121312 0 0.09 0.05
pth2r_human 412 7.56x56 TM7 I => T missense 1.649e-05 2 121312 0 nan 0.721
pth2r_human 424 8.54x54 H8 V => M missense 1.809e-05 2 110570 0 0.08 0.035
pth2r_human 427 8.57x57 H8 M => I missense 2.713e-05 3 110590 0 0.11 0.001
pth2r_human 430 8.60x60 H8 R => W missense 7.23e-05 8 110648 0 0.0 0.992
pth2r_human 430 8.60x60 H8 R => Q missense 1.807e-05 2 110666 0 0.0 0.734
pth2r_human 432 8.62x62 H8 N => K missense 8.99e-06 1 111234 0 0.14 0.394
pth2r_human 435 C-term V => M missense 0.004678 520 111166 6 0.04 0.018
pth2r_human 438 C-term K => E missense 8.995e-05 10 111172 0 0.05 0.012
pth2r_human 440 C-term T => S missense 0.0002786 31 111270 0 0.19 0.11
pth2r_human 442 C-term P => T missense 8.972e-06 1 111460 0 0.47 0.287
pth2r_human 446 C-term R => C missense 8.954e-06 1 111688 0 0.2 0.326
pth2r_human 446 C-term R => H missense 1.79e-05 2 111752 0 0.56 0.0
pth2r_human 449 C-term G => S missense 0.0001868 21 112430 1 0.06 0.68
pth2r_human 449 C-term G => D missense 8.891e-06 1 112476 0 0.0 0.972
pth2r_human 455 C-term V => M missense 5.273e-05 6 113790 0 0.48 0.008
pth2r_human 456 C-term T => A missense 1.754e-05 2 114038 1 0.09 0.891
pth2r_human 456 C-term T => M missense 0.0001315 15 114058 0 0.07 0.983
pth2r_human 457 C-term H => Q missense 8.755e-06 1 114224 0 0.18 0.017
pth2r_human 459 C-term T => I missense 8.725e-06 1 114614 0 0.03 0.418
pth2r_human 459 C-term T => S missense 8.725e-06 1 114614 0 0.37 0.043
pth2r_human 462 C-term Q => K missense 1.733e-05 2 115430 0 0.36 0.543
pth2r_human 464 C-term Q => H missense 8.641e-06 1 115734 0 0.3 0.015
pth2r_human 466 C-term A => V missense 2.594e-05 3 115644 0 0.34 0.009
pth2r_human 470 C-term R => C missense 6.022e-05 7 116236 0 0.0 0.8
pth2r_human 470 C-term R => L missense 8.606e-06 1 116204 0 0.03 0.428
pth2r_human 471 C-term M => K missense 8.587e-06 1 116450 0 0.45 0.051
pth2r_human 472 C-term V => M missense 6.01e-05 7 116474 0 0.09 0.599
pth2r_human 474 C-term I => V missense 8.567e-06 1 116730 0 0.2 0.002
pth2r_human 474 C-term I => S missense 6.85e-05 8 116792 0 0.09 0.075
pth2r_human 474 C-term I => T missense 8.562e-06 1 116792 0 0.15 0.075
pth2r_human 475 C-term S => P missense 8.56e-06 1 116818 0 0.22 0.682
pth2r_human 477 C-term K => R missense 8.534e-06 1 117174 0 0.59 0.015
pth2r_human 479 C-term A => T missense 2.556e-05 3 117376 0 0.79 0.001
pth2r_human 482 C-term A => S missense 5.093e-05 6 117814 0 0.25 0.012
pth2r_human 482 C-term A => T missense 8.488e-06 1 117814 0 0.23 0.012
pth2r_human 483 C-term S => G missense 1.693e-05 2 118100 0 0.52 0.0
pth2r_human 483 C-term S => R missense 8.472e-06 1 118036 0 0.25 0.003
pth2r_human 490 C-term I => V missense 1.68e-05 2 119052 0 1.0 0.0
pth2r_human 494 C-term G => D missense 1.673e-05 2 119556 0 0.0 0.998
pth2r_human 495 C-term Y => C missense 8.352e-06 1 119732 0 0.01 0.086
pth2r_human 506 C-term P => L missense 1.662e-05 2 120362 0 0.06 0.548
pth2r_human 507 C-term H => Q missense 8.307e-06 1 120382 0 0.32 0.001
pth2r_human 511 C-term E => K missense 0.001123 135 120244 1 0.06 0.04
pth2r_human 514 C-term K => E missense 0.0008413 101 120056 0 0.53 0.0
pth2r_human 514 C-term K => R missense 8.333e-06 1 120008 0 0.21 0.001
pth2r_human 516 C-term D => H missense 2.505e-05 3 119756 0 0.17 0.002
pth2r_human 520 C-term Q => R missense 8.417e-06 1 118808 0 0.4 0.002
pth2r_human 521 C-term G => E missense 8.436e-06 1 118536 0 0.37 0.002
pth2r_human 522 C-term D => Y missense 1.69e-05 2 118364 0 0.01 0.599
pth2r_human 528 C-term K => M missense 1.718e-05 2 116384 0 0.01 0.129
pth2r_human 529 C-term P => A missense 8.626e-06 1 115924 0 0.56 0.0
pth2r_human 529 C-term P => T missense 2.588e-05 3 115924 0 0.47 0.002
pth2r_human 529 C-term P => L missense 1.725e-05 2 115928 0 0.19 0.021
pth2r_human 532 C-term P => S missense 8.694e-06 1 115018 0 0.16 0.007
pth2r_human 533 C-term M => L missense 3.485e-05 4 114766 0 0.92 0.0
pth2r_human 533 C-term M => V missense 1.743e-05 2 114766 0 1.0 0.0
pth2r_human 534 C-term E => D missense 8.738e-06 1 114438 0 0.26 0.001
pth2r_human 537 C-term P => Q missense 8.804e-06 1 113586 0 0.55 0.032
pth2r_human 543 C-term Q => R missense 1.79e-05 2 111724 0 0.54 0.0
pth2r_human 548 C-term D => A missense 9.045e-06 1 110554 0 0.05 0.05


Residue

Diagrams

ICL1 R R L H ICL1ECL1 G V K E L E S L I M Q D D P Q N S I E A T S V D K S Q ECL1ICL2 A F F S D T K ICL2ECL2 D A R C W E L S ECL2ICL3 N A V G H ICL3ECL3 P H S F T ECL3N-term M A G L G A S L H V W G W L M L G S C L L A R A Q L D S D G T I T I E E Q I V L V L K A K V Q C E L N I T A Q L Q E G E G N C F P E W D G L I C W P R G T V G K I S A V P C P P Y I Y D F N H K G V A F R H C N P N G T W D F M H S L N K T W A N Y S D C L R F N-termC-term V D W K R T P P C G S R R C G S V L T T V T H S T S S Q S Q V A A S T R M V L I S G K A A K I A S R Q P D S H I T L P G Y V W S N S E Q D C L P H S F H E E T K E D S G R Q G D D I L M E K P S R P M E S N P D T E G C Q G E T E D V L C-term L Q P D I S I G K Q E F F E R L Y V M Y T V G Y S I S F G S L A V A I L I I G Y F C T R N Y I H M H L F V S F M L R A T S I F V K D R V V H A H I Y I G C K I A V V M F I Y F L A T N Y Y W I L V E G L Y L H N L I F V Y L W G F I L I G W G F P A A F V A A W A V A R A T L A A G D I K W I Y Q A P I L A A I G L N F I L F L N T V R V L A T K I W E T D T R K Q Y R K L A K S T L V L V L V F G V H Y I V F V C L G L G W E I R M H C E L F F N S F Q G F F V S I I Y C Y C N G E V K K W N L V Q A E M W S R S
SnakePlot Download: PNG | SVG A L S G F S I S Y G V T Y M V Y L R E F 1 M H L F V S F M L R A T S I F V K D R V 2 V L I W Y Y N T A L F Y I F M V V A I K 3 Y L W G F I L G I W G F P A A F V A A W A 4 F L I F N L G I A A L I P A Q Y I W K I D 5 L V L V L V F G V H Y I V F V C L 6 I S V F F G Q F S N F F L E C H M R I 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 3142.927 msec
System CPU time 63.402 msec
Total CPU time 3206.329 msec
Elapsed time 3509.097 msec
Context switches 141 voluntary, 37 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 668855
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/PTH2R_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': 'PTH2R_human'} render

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 309.18 ms (103 queries including 94 similar and 32 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" = 'pth2r_human'
0.8680571620692101%
 2.68

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.18052072633952393%
 0.56

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.5479625294184781%
 1.69

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" = 301) ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
1.8119931770722484%
 5.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(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.10826616821046203%
 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(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.340992162269703%
 1.05

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" = 301) ORDER BY "residue"."sequence_number" ASC
  2 similar queries.   Duplicated 2 times.
0.42635587182025964%
 1.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(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 (301)
0.19201051199718694%
 0.59

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 (117905, 118433, 118332, 118241) ORDER BY "residue"."sequence_number" ASC
1.756549177824868%
 5.43

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.09338342571429453%
 0.29

Connection: default

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

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" = 391
0.18969713233457022%
 0.59

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" = '002_001_004_002' AND U2."slug" = 'wt')) AND NOT ("interaction_type_residue_fragment"."type" = 'hidden' AND "interaction_type_residue_fragment"."type" IS NOT NULL))
66.45638045533481%
 205.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" = 41785
  25 similar queries.
1.5221267053463745%
 4.71

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" = 23598635
  25 similar queries.
0.7032674174354798%
 2.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(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" = 41788
  25 similar queries.
0.11574609578625607%
 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 ••• "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" = 23598639
  25 similar queries.
0.11929327793560168%
 0.37

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" = 41795
  25 similar queries.
0.09693060786364015%
 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" = 23598694
  25 similar queries.
0.45642980743427686%
 1.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 ••• "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" = 41806
  25 similar queries.
0.1255394030246668%
 0.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" = 23598742
  25 similar queries.
0.5132618344792274%
 1.59

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" = 27
  15 similar queries.
0.12685031816681627%
 0.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 ••• "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
  15 similar queries.   Duplicated 6 times.
0.11158201239354598%
 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" = 41821
  25 similar queries.
0.11859926403681666%
 0.37

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" = 23598825
  25 similar queries.
0.11944750324644281%
 0.37

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
  15 similar queries.
0.13086017624868523%
 0.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 ••• "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
  15 similar queries.   Duplicated 6 times.
0.11543764516457383%
 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(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" = 41824
  25 similar queries.
0.12908658517401242%
 0.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 ••• "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" = 23598829
  25 similar queries.
0.10340807091896694%
 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" = 31970
  15 similar queries.
0.11651722234046163%
 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
  15 similar queries.   Duplicated 6 times.
0.09785595972868684%
 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" = 41836
  25 similar queries.
0.1151291945428916%
 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 ••• "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" = 23598891
  25 similar queries.
0.1328651052896197%
 0.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 ••• "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" = 41850
  25 similar queries.
0.12098975635485394%
 0.37

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" = 23598904
  25 similar queries.
0.12685031816681627%
 0.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_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" = 59032
  15 similar queries.
0.12268623477410619%
 0.38

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
  15 similar queries.   Duplicated 6 times.
0.12314891070662953%
 0.38

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" = 41860
  25 similar queries.
0.09531124209980844%
 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" = 23598964
  25 similar queries.
9.251359496115064%
 28.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(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" = 83467
  15 similar queries.
0.13093728890410578%
 0.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 ••• "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
  15 similar queries.   Duplicated 6 times.
0.09639081927569625%
 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" = 41867
  25 similar queries.
0.11744257420550831%
 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 ••• "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" = 23598972
  25 similar queries.
0.1282383459643863%
 0.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 ••• "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" = 86259
  15 similar queries.
0.1124302516031721%
 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 ••• "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
  15 similar queries.   Duplicated 6 times.
0.08921934232158445%
 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(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" = 41871
  25 similar queries.
0.14103904676419876%
 0.44

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/mutational_landscape/views.py in render_variants(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" = 23598753
  25 similar queries.
0.12453693850419956%
 0.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_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
  15 similar queries.
0.12152954494279783%
 0.38

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
  15 similar queries.   Duplicated 2 times.
0.11805947544887277%
 0.37

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" = 41873
  25 similar queries.
0.11505208188747104%
 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 ••• "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" = 23598731
  25 similar queries.   Duplicated 2 times.
0.13386756981008696%
 0.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" = 97794
  15 similar queries.   Duplicated 2 times.
0.11767391217176998%
 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" = 14
  15 similar queries.   Duplicated 2 times.
0.1124302516031721%
 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(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" = 41875
  25 similar queries.
0.11697989827298497%
 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 ••• "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" = 23598731
  25 similar queries.   Duplicated 2 times.
0.11967884121270446%
 0.37

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" = 97794
  15 similar queries.   Duplicated 2 times.
0.11489785657662992%
 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" = 6
  15 similar queries.   Duplicated 3 times.
0.1128158148802749%
 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(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" = 41877
  25 similar queries.
0.11343271612363935%
 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"."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" = 23598713
  25 similar queries.
0.129163697829433%
 0.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" = 41879
  25 similar queries.
0.11289292753569545%
 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"."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" = 23598889
  25 similar queries.
0.11921616528018113%
 0.37

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" = 53500
  15 similar queries.
0.12083553104401282%
 0.37

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
  15 similar queries.   Duplicated 2 times.
0.1124302516031721%
 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(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" = 41880
  25 similar queries.
0.10140314187803245%
 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" = 23598901
  25 similar queries.
0.10001511408046243%
 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" = 57400
  15 similar queries.
0.11458940595494771%
 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 ••• "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" = 6
  15 similar queries.   Duplicated 3 times.
0.11158201239354598%
 0.34