Purchasability


Ligand source activities (1 row/activity)

Select all ChEMBL ID Receptor Species Purchasable p-value
(-log)		 Activity
Type		 Activity
Relation		 Activity
Value		 Unit Assay Type Assay Description Mol
weight		 Rot
Bonds		 H don H acc LogP Smiles
CHEMBL102250 5ht1f_human Human No 8.0 EC50 = 11 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
324 3 2 4 1.9 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=COC=C4
CHEMBL105091 5ht1f_human Human No 8.0 EC50 = 11 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
324 3 2 4 2.2 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CO4
CHEMBL105958 5ht1f_human Human No 8.0 EC50 = 11 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
335 3 2 4 1.7 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=NC=C4
CHEMBL3617557 5ht1f_human Human No 7.0 EC50 = 110 Funct
Agonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assayAgonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assay
341 4 1 5 2.6 CN1CCC(CC1)C(=O)C2=NC(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL3617557 5ht1f_human Human No 7.0 EC50 = 110 Funct
Agonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assayAgonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assay
341 4 1 5 2.6 CN1CCC(CC1)C(=O)C2=NC(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL105955 5ht1f_human Human No 7.9 EC50 = 13 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
300 4 2 3 2.0 CCCC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL187308 5ht1f_human Human No 6.9 EC50 = 140 Funct
Stimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cellsStimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cells
388 3 1 5 3.9 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL187308 5ht1f_human Human No 6.9 EC50 = 140 Funct
Stimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cellsStimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cells
388 3 1 5 3.9 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL321080 5ht1f_human Human No 7.8 EC50 = 15 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
340 3 2 4 2.8 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CS4
CHEMBL420475 5ht1f_human Human No 7.7 EC50 = 21 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
312 3 2 3 2.2 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4CCC4
CHEMBL105722 5ht1f_human Human No 7.6 EC50 = 25 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
335 3 2 4 2.1 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CC=N4
CHEMBL177238 5ht1f_human Human No 6.6 EC50 = 277 Funct
Concentration required for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-1) cells expressing the human 5-hydroxytryptamine 1F receptorConcentration required for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-1) cells expressing the human 5-hydroxytryptamine 1F receptor
388 3 1 5 3.8 CN1CCC(CC1)C2=COC3=C2N=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL105261 5ht1f_human Human No 7.5 EC50 = 32 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
286 3 2 3 1.6 CCC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL104720 5ht1f_human Human No 7.5 EC50 = 34 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
298 3 2 3 1.6 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4CC4
CHEMBL128 5ht1f_human Human Yes 7.5 EC50 = 35 Funct
In vitro effective concentration for inhibition of skolin-stimulated adenylate cyclase in cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for inhibition of skolin-stimulated adenylate cyclase in cell line expressing human 5-hydroxytryptamine 1F receptor
295 6 2 4 0.9 CNS(=O)(=O)CC1=CC2=C(C=C1)NC=C2CCN(C)C
CHEMBL431041 5ht1f_human Human Yes 7.4 EC50 = 36 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-HT1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-HT1F receptor
272 2 2 3 1.2 CC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL186662 5ht1f_human Human No 6.3 EC50 = 470 Funct
Stimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cellsStimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cells
371 3 1 6 3.4 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)F
CHEMBL186662 5ht1f_human Human No 6.3 EC50 = 470 Funct
Stimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cellsStimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cells
371 3 1 6 3.4 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)F
CHEMBL187581 5ht1f_human Human No 7.3 EC50 = 50 Funct
Stimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cellsStimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cells
390 3 2 7 3.6 CN1CCC(CC1)N2CNC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4F)F)F
CHEMBL187581 5ht1f_human Human No 7.3 EC50 = 50 Funct
Stimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cellsStimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cells
390 3 2 7 3.6 CN1CCC(CC1)N2CNC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4F)F)F
CHEMBL3617550 5ht1f_human Human No 7.3 EC50 = 55 Funct
Agonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assayAgonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)F
CHEMBL3617550 5ht1f_human Human No 7.3 EC50 = 55 Funct
Agonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assayAgonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)F
CHEMBL339980 5ht1f_human Human No 8.2 EC50 = 6 Funct
In vitro effective concentration for inhibition of skolin-stimulated adenylate cyclase in cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for inhibition of skolin-stimulated adenylate cyclase in cell line expressing human 5-hydroxytryptamine 1F receptor
339 5 2 3 3.7 CC1=C(C2=C(N1)C=CC=C2NC(=O)C3=CC=C(C=C3)F)CCN(C)C
CHEMBL186951 5ht1f_human Human No 7.2 EC50 = 63 Funct
Stimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cellsStimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cells
389 3 2 5 4.1 CN1CCC(CC1)N2CNC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL186951 5ht1f_human Human No 7.2 EC50 = 63 Funct
Stimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cellsStimulation of [35S]GTP-gamma-S, binding to cloned human 5-hydroxytryptamine 1F receptor expressed in Mouse LM(tk-) cells
389 3 2 5 4.1 CN1CCC(CC1)N2CNC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL177258 5ht1f_human Human No 7.2 EC50 = 66 Funct
Concentration required for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-1) cells expressing the human 5-hydroxytryptamine 1F receptorConcentration required for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-1) cells expressing the human 5-hydroxytryptamine 1F receptor
353 3 1 5 3.2 CN1CCC(CC1)C2=COC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL369705 5ht1f_human Human No 7.2 EC50 = 68.7 Funct
Concentration required for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-1) cells expressing the human 5-hydroxytryptamine 1F receptorConcentration required for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-1) cells expressing the human 5-hydroxytryptamine 1F receptor
388 3 1 5 3.8 CN1CCC(CC1)C2=COC3=C2N=C(C=C3)NC(=O)C4=C(C=CC=C4Cl)F
CHEMBL3617549 5ht1f_human Human No 7.1 EC50 = 87 Funct
Agonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assayAgonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assay
340 4 1 4 3.0 CN1CCC(CC1)C(=O)C2=CC(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL3617549 5ht1f_human Human No 7.1 EC50 = 87 Funct
Agonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assayAgonist activity at human 5HT1F receptor expressed in LM(tk-) cells by [35S]GTPgammaS binding assay
340 4 1 4 3.0 CN1CCC(CC1)C(=O)C2=CC(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL104753 5ht1f_human Human No 8.0 EC50 = 9.4 Funct
In vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptorIn vitro effective concentration for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-)cells expressing the human 5-hydroxytryptamine 1F receptor
340 3 2 4 2.5 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CSC=C4
CHEMBL173949 5ht1f_human Human No 7.0 EC50 = 91.7 Funct
Concentration required for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-1) cells expressing the human 5-hydroxytryptamine 1F receptorConcentration required for stimulation of [35S]GTP-gamma-S, binding in mouse LM(tk-1) cells expressing the human 5-hydroxytryptamine 1F receptor
389 3 1 7 3.4 CN1CCC(CC1)C2=COC3=C2N=C(C=C3)NC(=O)C4=C(C=C(C=C4F)F)F
CHEMBL2110300 5ht1f_human Human No 6.4 IC50 = 363.1 Funct
Binding affinity towards human recombinant 5-hydroxytryptamine 1F receptorBinding affinity towards human recombinant 5-hydroxytryptamine 1F receptor
313 4 2 3 2.5 CN(C)C1CC(C1)C2=CNC3=C2C=C(C=C3)CC4COC(=O)N4
CHEMBL292779 5ht1f_human Human No 5.4 IC50 = 3800 Funct
Compound was evaluated for the affinity at 5-hydroxytryptamine 1F receptorCompound was evaluated for the affinity at 5-hydroxytryptamine 1F receptor
433 8 1 5 3.7 C1CN(CCN1CCCC2=CNC3=C2C=C(C=C3)N4C=NN=C4)CCC5=CC(=CC=C5)F
CHEMBL101690 5ht1f_human Human Yes 8.8 Ki = 1.6 Funct
Binding affinity at human 5HT1F receptorBinding affinity at human 5HT1F receptor
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL101690 5ht1f_human Human Yes 8.8 Ki = 1.6 Funct
Binding affinity at human 5HT1F receptorBinding affinity at human 5HT1F receptor
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL128636 5ht1f_human Human No 8.8 Ki = 1.6 Funct
Binding affinity towards human 5-hydroxytryptamine 1F receptorBinding affinity towards human 5-hydroxytryptamine 1F receptor
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C(=CC=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL101690 5ht1f_human Human Yes 8.8 Ki = 1.6 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL318105 5ht1f_human Human No 7.0 Ki = 100 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
230 1 2 3 1.3 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)N
CHEMBL318110 5ht1f_human Human No 7.0 Ki = 100 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
231 1 2 2 0.7 CN1CCC(CC1)C2=CNC3=C2NC(=O)C=C3
CHEMBL522708 5ht1f_human Human No 6.0 Ki = 1000 Funct
Displacement of radioligand from human cloned 5HT1F receptorDisplacement of radioligand from human cloned 5HT1F receptor
480 7 0 6 4.6 CC1=NC2=C(C=C1)C(=CC=C2)OCCN3CCC(CC3)CC4=CC(=CC=C4)N5CCCS5(=O)=O
CHEMBL522708 5ht1f_human Human No 6.0 Ki = 1000 Funct
Displacement of radioligand from human cloned 5HT1F receptorDisplacement of radioligand from human cloned 5HT1F receptor
480 7 0 6 4.6 CC1=NC2=C(C=C1)C(=CC=C2)OCCN3CCC(CC3)CC4=CC(=CC=C4)N5CCCS5(=O)=O
CHEMBL103550 5ht1f_human Human No 8.0 Ki = 11 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
352 3 2 4 2.9 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC(=CC=C4)F
CHEMBL105369 5ht1f_human Human No 8.0 Ki = 11 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
367 3 3 4 2.6 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)NC4=CC=C(C=C4)F
CHEMBL321967 5ht1f_human Human No 8.0 Ki = 11 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
326 3 2 3 2.7 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4CCCC4
CHEMBL419547 5ht1f_human Human No 8.0 Ki = 11 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
359 3 2 4 2.5 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CC(=C4)C#N
CHEMBL3617556 5ht1f_human Human No 6.0 Ki = 1100 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
356 4 2 5 3.2 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)O
CHEMBL3617556 5ht1f_human Human No 6.0 Ki = 1100 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
356 4 2 5 3.2 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)O
CHEMBL186662 5ht1f_human Human No 7.9 Ki = 12 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
371 3 1 6 3.4 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)F
CHEMBL186662 5ht1f_human Human No 7.9 Ki = 12 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
371 3 1 6 3.4 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)F
CHEMBL105025 5ht1f_human Human No 7.9 Ki = 12 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
348 3 2 3 3.2 CC1=CC=CC=C1C(=O)NC2=NC3=C(C=C2)NC=C3C4CCN(CC4)C
CHEMBL420101 5ht1f_human Human No 7.9 Ki = 12 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
348 3 2 3 3.2 CC1=CC=C(C=C1)C(=O)NC2=NC3=C(C=C2)NC=C3C4CCN(CC4)C
CHEMBL609742 5ht1f_human Human No 7.9 Ki = 12.3 Funct
Inhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cellsInhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cells
390 5 3 4 3.6 C1CC(NC1)CC2=CNC3=C2C=C(C=C3)NS(=O)(=O)C4=CC=CC=C4Cl
CHEMBL609742 5ht1f_human Human No 7.9 Ki = 12.3 Funct
Inhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cellsInhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cells
390 5 3 4 3.6 C1CC(NC1)CC2=CNC3=C2C=C(C=C3)NS(=O)(=O)C4=CC=CC=C4Cl
CHEMBL186951 5ht1f_human Human No 7.9 Ki = 13 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
389 3 2 5 4.1 CN1CCC(CC1)N2CNC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL186951 5ht1f_human Human No 7.9 Ki = 13 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
389 3 2 5 4.1 CN1CCC(CC1)N2CNC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL103503 5ht1f_human Human No 7.9 Ki = 13 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
352 3 2 4 2.8 CN1CCC(CC1)C2=CNC3=CN=C(C=C23)NC(=O)C4=CC=C(C=C4)F
CHEMBL102344 5ht1f_human Human No 7.9 Ki = 13 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
328 6 2 3 3.1 CCCCCC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL105091 5ht1f_human Human No 7.9 Ki = 13 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
324 3 2 4 2.2 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CO4
CHEMBL369391 5ht1f_human Human No 7.9 Ki = 13.5 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
341 5 1 5 3.3 CC1=C(C2=C(O1)C=CC(=N2)NC(=O)C3=CC=C(C=C3)F)CCN(C)C
CHEMBL3617551 5ht1f_human Human No 5.9 Ki = 1300 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=C(C=CC(=C2)NC(=O)C3=CC=C(C=C3)F)F
CHEMBL3617551 5ht1f_human Human No 5.9 Ki = 1300 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=C(C=CC(=C2)NC(=O)C3=CC=C(C=C3)F)F
CHEMBL105850 5ht1f_human Human No 7.9 Ki = 14 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
394 6 2 4 4.2 CCCCN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL319857 5ht1f_human Human No 7.9 Ki = 14 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
314 5 2 3 2.5 CCCCC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL606547 5ht1f_human Human No 7.8 Ki = 16 Funct
Inhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cellsInhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cells
404 5 2 4 4.1 CN1CCCC1CC2=CNC3=C2C=C(C=C3)NS(=O)(=O)C4=CC=CC=C4Cl
CHEMBL321133 5ht1f_human Human No 7.8 Ki = 16 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
364 4 2 4 2.8 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC(=CC=C4)OC
CHEMBL606547 5ht1f_human Human No 7.8 Ki = 16 Funct
Inhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cellsInhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cells
404 5 2 4 4.1 CN1CCCC1CC2=CNC3=C2C=C(C=C3)NS(=O)(=O)C4=CC=CC=C4Cl
CHEMBL187581 5ht1f_human Human No 7.8 Ki = 17 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
390 3 2 7 3.6 CN1CCC(CC1)N2CNC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4F)F)F
CHEMBL445651 5ht1f_human Human No 7.8 Ki = 17 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 1 5 3.3 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL187581 5ht1f_human Human No 7.8 Ki = 17 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
390 3 2 7 3.6 CN1CCC(CC1)N2CNC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4F)F)F
CHEMBL445651 5ht1f_human Human No 7.8 Ki = 17 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 1 5 3.3 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL2113386 5ht1f_human Human No 7.8 Ki = 17.8 Funct
Inhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cellsInhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cells
495 6 3 4 3.5 C1CC(NC1)CC2=CNC3=C2C=C(C=C3)NS(=O)(=O)CC4=CC=CC=C4I
CHEMBL2113386 5ht1f_human Human No 7.8 Ki = 17.8 Funct
Inhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cellsInhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cells
495 6 3 4 3.5 C1CC(NC1)CC2=CNC3=C2C=C(C=C3)NS(=O)(=O)CC4=CC=CC=C4I
CHEMBL104953 5ht1f_human Human No 6.8 Ki = 170 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
366 4 2 4 3.3 CCN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL3617554 5ht1f_human Human No 5.8 Ki = 1700 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
375 4 1 4 3.7 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)Cl
CHEMBL3617554 5ht1f_human Human No 5.8 Ki = 1700 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
375 4 1 4 3.7 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)Cl
CHEMBL105478 5ht1f_human Human No 7.8 Ki = 18 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
380 5 2 4 3.8 CCCN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL321343 5ht1f_human Human No 7.7 Ki = 19 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
379 3 2 5 2.6 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CC=C4[N+](=O)[O-]
CHEMBL105327 5ht1f_human Human No 7.7 Ki = 19 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
308 3 2 5 0.9 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NS(=O)(=O)C
CHEMBL104384 5ht1f_human Human No 7.7 Ki = 19 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
352 3 2 4 2.9 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CC=C4F
CHEMBL282971 5ht1f_human Human No 6.7 Ki = 199.5 Funct
The compound was tested for the binding affinity towards human cloned 5-hydroxytryptamine 1F receptor in CHO cells, using [3H]5-HT as radioligandThe compound was tested for the binding affinity towards human cloned 5-hydroxytryptamine 1F receptor in CHO cells, using [3H]5-HT as radioligand
492 5 1 7 5.2 CC1=C(SC2=C1C=C(C=C2)Cl)S(=O)(=O)NC3=CC(=C(C=C3)OC)N4CCN5CCCC5C4
CHEMBL425190 5ht1f_human Human Yes 5.7 Ki = 1995.3 Funct
Binding affinity for human 5-hydroxytryptamine 1F receptor Binding affinity for human 5-hydroxytryptamine 1F receptor
413 6 0 5 4.2 CC1=NC2=C(C=C1)C(=CC=C2)OCCN3CCN(CC3)CC4=CC=CC5=C4N=CC=C5
CHEMBL425190 5ht1f_human Human Yes 5.7 Ki = 1995.3 Funct
Binding affinity for human 5-hydroxytryptamine 1F receptor Binding affinity for human 5-hydroxytryptamine 1F receptor
413 6 0 5 4.2 CC1=NC2=C(C=C1)C(=CC=C2)OCCN3CCN(CC3)CC4=CC=CC5=C4N=CC=C5
CHEMBL101690 5ht1f_human Human Yes 8.7 Ki = 2.1 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL101690 5ht1f_human Human Yes 8.7 Ki = 2.1 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL101690 5ht1f_human Human Yes 8.7 Ki = 2.1 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL101690 5ht1f_human Human Yes 8.7 Ki = 2.1 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL101690 5ht1f_human Human Yes 8.7 Ki = 2.1 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
351 3 2 3 3.6 CN1CCC(CC1)C2=CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL361303 5ht1f_human Human Yes 8.7 Ki = 2.2 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
351 3 1 3 3.4 CN1CCC(CC1)N2C=CC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL361303 5ht1f_human Human Yes 8.7 Ki = 2.2 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
351 3 1 3 3.4 CN1CCC(CC1)N2C=CC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL173949 5ht1f_human Human No 8.6 Ki = 2.3 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
389 3 1 7 3.4 CN1CCC(CC1)C2=COC3=C2N=C(C=C3)NC(=O)C4=C(C=C(C=C4F)F)F
CHEMBL323264 5ht1f_human Human No 8.6 Ki = 2.5 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
287 2 3 3 1.0 CNC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL606556 5ht1f_human Human No 8.6 Ki = 2.7 Funct
Inhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cellsInhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cells
404 5 2 4 4.1 CN1CCCC1CC2=CNC3=C2C=C(C=C3)NS(=O)(=O)C4=CC(=CC=C4)Cl
CHEMBL606556 5ht1f_human Human No 8.6 Ki = 2.7 Funct
Inhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cellsInhibition of [3H]8-OH-DPAT binding to human 5-hydroxytryptamine 1F receptor expressed in CHO cells
404 5 2 4 4.1 CN1CCCC1CC2=CNC3=C2C=C(C=C3)NS(=O)(=O)C4=CC(=CC=C4)Cl
CHEMBL369705 5ht1f_human Human No 8.5 Ki = 2.9 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
388 3 1 5 3.8 CN1CCC(CC1)C2=COC3=C2N=C(C=C3)NC(=O)C4=C(C=CC=C4Cl)F
CHEMBL101686 5ht1f_human Human No 7.7 Ki = 20 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
357 8 2 3 4.1 CCCCCCCC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL418806 5ht1f_human Human No 7.7 Ki = 20 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
340 3 2 3 3.2 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4CCCCC4
CHEMBL321562 5ht1f_human Human No 7.7 Ki = 20 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
364 4 2 4 2.8 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CC=C4OC
CHEMBL317535 5ht1f_human Human No 5.7 Ki = 2000 Funct
Binding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligandBinding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligand
260 6 1 3 2.9 CCOC(=O)C1=C(C2=CC=CC=C2N1)CCN(C)C
CHEMBL103058 5ht1f_human Human No 7.7 Ki = 21 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
284 3 2 3 1.2 CCN1CCC(=CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C
CHEMBL104026 5ht1f_human Human No 6.7 Ki = 210 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
272 2 2 3 1.1 CC(=O)NC1=NC=C2C(=C1)C(=CN2)C3CCN(CC3)C
CHEMBL104158 5ht1f_human Human No 6.7 Ki = 220 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
273 2 2 4 0.5 CC(=O)NC1=NC=C2C(=N1)C(=CN2)C3CCN(CC3)C
CHEMBL104374 5ht1f_human Human No 7.6 Ki = 23 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
245 2 1 3 1.9 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)OC
CHEMBL3617560 5ht1f_human Human No 5.6 Ki = 2400 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
341 4 1 5 2.3 CN1CCC(CC1)C(=O)C2=CC(=NC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL3617560 5ht1f_human Human No 5.6 Ki = 2400 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
341 4 1 5 2.3 CN1CCC(CC1)C(=O)C2=CC(=NC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL316979 5ht1f_human Human No 7.6 Ki = 25 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
364 4 2 4 2.9 CCN1CCC(=CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL128 5ht1f_human Human Yes 7.6 Ki = 25.7 Funct
Binding affinity towards human 5-hydroxytryptamine 1F receptor was determinedBinding affinity towards human 5-hydroxytryptamine 1F receptor was determined
295 6 2 4 0.9 CNS(=O)(=O)CC1=CC2=C(C=C1)NC=C2CCN(C)C
CHEMBL76237 5ht1f_human Human Yes 5.6 Ki = 2500 Funct
Binding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligandBinding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligand
358 6 0 4 3.5 CN(C)CCC1=CN(C2=C1C=C(C=C2)OC)S(=O)(=O)C3=CC=CC=C3
CHEMBL104968 5ht1f_human Human No 7.6 Ki = 27 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
388 4 2 6 2.6 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NS(=O)(=O)C4=CC=C(C=C4)F
CHEMBL263700 5ht1f_human Human No 7.5 Ki = 29 Funct
Binding affinity against 5-hydroxytryptamine 1F receptor in CHO using [3H]5-HT radioligandBinding affinity against 5-hydroxytryptamine 1F receptor in CHO using [3H]5-HT radioligand
308 4 1 3 3.5 CN(C)CCC1=CN(C2=C1C=C(C=C2)O)C(=O)C3=CC=CC=C3
CHEMBL177238 5ht1f_human Human No 8.5 Ki = 3 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
388 3 1 5 3.8 CN1CCC(CC1)C2=COC3=C2N=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL177258 5ht1f_human Human No 8.5 Ki = 3.1 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 1 5 3.2 CN1CCC(CC1)C2=COC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL432713 5ht1f_human Human Yes 8.5 Ki = 3.2 Funct
Binding affinity for 5-hydroxytryptamine 1F receptor was determinedBinding affinity for 5-hydroxytryptamine 1F receptor was determined
500 9 3 3 6.0 C1CN(CCC1C2=CNC3=C2C=C(C=C3)O)CCCCCNC(=O)C=CC4=CC(=C(C=C4)Cl)Cl
CHEMBL187308 5ht1f_human Human No 8.4 Ki = 3.6 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
388 3 1 5 3.9 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL187308 5ht1f_human Human No 8.4 Ki = 3.6 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
388 3 1 5 3.9 CN1CCC(CC1)C2=NOC3=C2C=C(C=C3)NC(=O)C4=C(C=C(C=C4)F)Cl
CHEMBL421287 5ht1f_human Human No 8.4 Ki = 3.8 Funct
Binding affinity towards human 5-hydroxytryptamine 1F receptorBinding affinity towards human 5-hydroxytryptamine 1F receptor
325 5 2 3 3.3 CN(C)CCC1=CNC2=C1C(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL102292 5ht1f_human Human No 8.4 Ki = 3.8 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
301 3 3 3 1.4 CCNC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL184597 5ht1f_human Human No 8.4 Ki = 3.9 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
352 3 2 4 3.1 CN1CCC(CC1)C2=C3C=C(C=CC3=NN2)NC(=O)C4=CC=C(C=C4)F
CHEMBL92139 5ht1f_human Human No 8.4 Ki = 3.9 Funct
Binding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligandBinding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligand
328 5 0 3 3.5 CN(C)CCC1=C2C=CN(C2=CC=C1)S(=O)(=O)C3=CC=CC=C3
CHEMBL184597 5ht1f_human Human No 8.4 Ki = 3.9 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
352 3 2 4 3.1 CN1CCC(CC1)C2=C3C=C(C=CC3=NN2)NC(=O)C4=CC=C(C=C4)F
CHEMBL105240 5ht1f_human Human No 7.5 Ki = 30 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
380 4 2 4 3.7 CC(C)N1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL292759 5ht1f_human Human Yes 6.5 Ki = 316.2 Funct
Compound was tested for its binding affinity against 5-hydroxytryptamine 1F receptor in human cloned receptors in CHO cells using [3H]5-HTCompound was tested for its binding affinity against 5-hydroxytryptamine 1F receptor in human cloned receptors in CHO cells using [3H]5-HT
440 5 1 6 3.0 CN1CCN(CC1)C2=C(C=CC(=C2)NS(=O)(=O)C3=CC=C(C=C3)Br)OC
CHEMBL292759 5ht1f_human Human Yes 6.5 Ki = 316.2 Funct
Compound was tested for its binding affinity against 5-hydroxytryptamine 1F receptor in human cloned receptors in CHO cells using [3H]5-HTCompound was tested for its binding affinity against 5-hydroxytryptamine 1F receptor in human cloned receptors in CHO cells using [3H]5-HT
440 5 1 6 3.0 CN1CCN(CC1)C2=C(C=CC(=C2)NS(=O)(=O)C3=CC=C(C=C3)Br)OC
CHEMBL29433 5ht1f_human Human No 6.5 Ki = 316.2 Funct
The compound was tested for the binding affinity towards human cloned 5-hydroxytryptamine 1F receptor in CHO cells, using [3H]5-HT as radioligandThe compound was tested for the binding affinity towards human cloned 5-hydroxytryptamine 1F receptor in CHO cells, using [3H]5-HT as radioligand
492 5 1 7 5.2 CC1=C(SC2=C1C=C(C=C2)Cl)S(=O)(=O)NC3=CC(=C(C=C3)OC)N4CCN5CCCC5C4
CHEMBL3617559 5ht1f_human Human No 5.5 Ki = 3200 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
341 4 1 5 2.0 CN1CCC(CC1)C(=O)C2=CC(=CN=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL3617559 5ht1f_human Human No 5.5 Ki = 3200 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
341 4 1 5 2.0 CN1CCC(CC1)C(=O)C2=CC(=CN=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL40650 5ht1f_rat Rat Yes 5.5 Ki = 3380 Funct
Binding affinity against 5-hydroxytryptamine 1 receptor using [3H]5-HT as radioligandBinding affinity against 5-hydroxytryptamine 1 receptor using [3H]5-HT as radioligand
449 4 1 6 3.2 COC1=CC=CC2=C1CCC3C2CN(C3)CCN4C(=O)C5=C(C6=C(S5)C=CC=N6)NC4=O
CHEMBL104946 5ht1f_human Human No 7.5 Ki = 35 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
272 3 3 3 1.2 CCC(=O)NC1=NC2=C(C=C1)NC=C2C3CCNCC3
CHEMBL365405 5ht1f_human Human Yes 8.4 Ki = 4.1 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
352 3 1 4 3.0 CN1CCC(CC1)N2C3=C(C=CC(=C3)NC(=O)C4=CC=C(C=C4)F)C=N2
CHEMBL365405 5ht1f_human Human Yes 8.4 Ki = 4.1 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
352 3 1 4 3.0 CN1CCC(CC1)N2C3=C(C=CC(=C3)NC(=O)C4=CC=C(C=C4)F)C=N2
CHEMBL104496 5ht1f_human Human No 8.4 Ki = 4.1 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
403 3 2 3 4.1 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=C(C=C(C=C4)Cl)Cl
CHEMBL102250 5ht1f_human Human No 8.3 Ki = 4.6 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
324 3 2 4 1.9 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=COC=C4
CHEMBL105556 5ht1f_human Human No 8.3 Ki = 4.7 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
309 3 1 5 1.5 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)OS(=O)(=O)C
CHEMBL361061 5ht1f_human Human No 8.3 Ki = 4.8 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 1 4 3.6 CN1CCC(CC1)N2CCC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL361061 5ht1f_human Human No 8.3 Ki = 4.8 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 1 4 3.6 CN1CCC(CC1)N2CCC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL3617552 5ht1f_human Human No 7.4 Ki = 41 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=CC(=CC(=C2)F)NC(=O)C3=CC=C(C=C3)F
CHEMBL3617552 5ht1f_human Human No 7.4 Ki = 41 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=CC(=CC(=C2)F)NC(=O)C3=CC=C(C=C3)F
CHEMBL105118 5ht1f_human Human No 7.4 Ki = 42 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
379 3 2 5 2.6 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC(=CC=C4)[N+](=O)[O-]
CHEMBL322018 5ht1f_human Human No 7.4 Ki = 45 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
258 2 3 3 0.7 CC(=O)NC1=NC2=C(C=C1)NC=C2C3CCNCC3
CHEMBL125745 5ht1f_human Human No 7.3 Ki = 47 Funct
Binding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligandBinding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligand
300 4 1 3 2.5 C1=CC=C(C=C1)S(=O)(=O)N2C=CC3=C(C=CC=C32)CCN
CHEMBL431041 5ht1f_human Human Yes 8.3 Ki = 5 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
272 2 2 3 1.2 CC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL3617549 5ht1f_human Human No 8.3 Ki = 5.1 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
340 4 1 4 3.0 CN1CCC(CC1)C(=O)C2=CC(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL3617549 5ht1f_human Human No 8.3 Ki = 5.1 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
340 4 1 4 3.0 CN1CCC(CC1)C(=O)C2=CC(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL105261 5ht1f_human Human No 8.3 Ki = 5.5 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
286 3 2 3 1.6 CCC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL449406 5ht1f_human Human No 8.2 Ki = 5.8 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
348 3 2 3 3.2 CC1=CC=CC(=C1)C(=O)NC2=NC3=C(C=C2)NC=C3C4CCN(CC4)C
CHEMBL497963 5ht1f_human Human No 6.3 Ki = 501.2 Funct
Displacement of radioligand from human cloned 5HT1F receptorDisplacement of radioligand from human cloned 5HT1F receptor
454 8 1 6 4.3 CC1=NC2=C(C=C1)C(=CC=C2)OCCN3CCC(CC3)CC4=CC(=CC=C4)NS(=O)(=O)C
CHEMBL497963 5ht1f_human Human No 6.3 Ki = 501.2 Funct
Displacement of radioligand from human cloned 5HT1F receptorDisplacement of radioligand from human cloned 5HT1F receptor
454 8 1 6 4.3 CC1=NC2=C(C=C1)C(=CC=C2)OCCN3CCC(CC3)CC4=CC(=CC=C4)NS(=O)(=O)C
CHEMBL184994 5ht1f_human Human No 6.3 Ki = 520 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
369 3 1 5 3.3 CN1CCC(CC1)N2CCOC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL184994 5ht1f_human Human No 6.3 Ki = 520 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
369 3 1 5 3.3 CN1CCC(CC1)N2CCOC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL3617553 5ht1f_human Human No 6.3 Ki = 530 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=CC(=C(C=C2)F)NC(=O)C3=CC=C(C=C3)F
CHEMBL3617553 5ht1f_human Human No 6.3 Ki = 530 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=CC(=C(C=C2)F)NC(=O)C3=CC=C(C=C3)F
CHEMBL126340 5ht1f_human Human No 6.2 Ki = 570 Funct
Binding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligandBinding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligand
433 7 0 4 5.2 CN(C)CCC1=C2C=C(N(C2=CC=C1)S(=O)(=O)C3=CC=CC=C3)C(=O)C4=CC=CC=C4
CHEMBL105722 5ht1f_human Human No 8.2 Ki = 6.3 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
335 3 2 4 2.1 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CC=N4
CHEMBL105955 5ht1f_human Human No 8.2 Ki = 6.9 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
300 4 2 3 2.0 CCCC(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL3616488 5ht1f_human Human No 6.2 Ki = 610 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
370 5 1 5 3.0 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)OC
CHEMBL3616488 5ht1f_human Human No 6.2 Ki = 610 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
370 5 1 5 3.0 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)OC
CHEMBL321578 5ht1f_human Human No 7.2 Ki = 62 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
314 3 2 3 2.6 CC(C)(C)C(=O)NC1=NC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL320198 5ht1f_human Human No 7.2 Ki = 67 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
353 3 2 5 2.3 CN1CCC(CC1)C2=CNC3=CN=C(N=C23)NC(=O)C4=CC=C(C=C4)F
CHEMBL321080 5ht1f_human Human No 8.2 Ki = 7.1 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
340 3 2 4 2.8 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CS4
CHEMBL104484 5ht1f_human Human No 8.1 Ki = 7.2 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
359 3 2 4 2.5 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)C#N
CHEMBL105743 5ht1f_human Human No 8.1 Ki = 7.3 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
334 3 2 3 2.8 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=CC=C4
CHEMBL104753 5ht1f_human Human No 8.1 Ki = 7.4 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
340 3 2 4 2.5 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CSC=C4
CHEMBL319920 5ht1f_human Human No 8.1 Ki = 7.5 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
389 4 1 6 3.2 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)OS(=O)(=O)C4=CC=C(C=C4)F
CHEMBL103479 5ht1f_human Human No 8.1 Ki = 7.6 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
352 3 2 4 2.9 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL103479 5ht1f_human Human No 8.1 Ki = 7.6 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
352 3 2 4 2.9 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL104692 5ht1f_human Human No 8.1 Ki = 7.7 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
379 3 2 5 2.6 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)[N+](=O)[O-]
CHEMBL495075 5ht1f_human Human Yes 5.1 Ki = 7200 Funct
Binding affinity to 5HT1F receptorBinding affinity to 5HT1F receptor
527 6 2 4 5.0 C1CNCCC1OC2=C(C=C(C=C2)CN3CCC(C3)NC(=O)C4=CC(=C(C=C4)Cl)Cl)Br
CHEMBL495075 5ht1f_human Human Yes 5.1 Ki = 7200 Funct
Binding affinity to 5HT1F receptorBinding affinity to 5HT1F receptor
527 6 2 4 5.0 C1CNCCC1OC2=C(C=C(C=C2)CN3CCC(C3)NC(=O)C4=CC(=C(C=C4)Cl)Cl)Br
CHEMBL102182 5ht1f_human Human No 7.1 Ki = 75 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
443 6 2 4 4.9 C1CN(CCC1C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F)CCC5=CC=CC=C5
CHEMBL93868 5ht1f_human Human No 6.1 Ki = 770 Funct
Binding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligandBinding affinity against 5-hydroxytryptamine 1F receptor in CHO cells using [3H]5-HT radioligand
328 5 0 3 3.5 CN(C)CCC1=CN(C2=CC=CC=C21)S(=O)(=O)C3=CC=CC=C3
CHEMBL339980 5ht1f_human Human No 8.1 Ki = 8.2 Funct
Binding affinity towards human 5-hydroxytryptamine 1F receptor using [3H]-5-HT radioligandBinding affinity towards human 5-hydroxytryptamine 1F receptor using [3H]-5-HT radioligand
339 5 2 3 3.7 CC1=C(C2=C(N1)C=CC=C2NC(=O)C3=CC=C(C=C3)F)CCN(C)C
CHEMBL178066 5ht1f_human Human Yes 8.1 Ki = 8.2 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
339 5 2 3 3.7 CC1=C(C2=C(N1)C=CC(=C2)NC(=O)C3=CC=C(C=C3)F)CCN(C)C
CHEMBL3617550 5ht1f_human Human No 8.1 Ki = 8.3 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)F
CHEMBL3617550 5ht1f_human Human No 8.1 Ki = 8.3 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
358 4 1 5 3.1 CN1CCC(CC1)C(=O)C2=C(C(=CC=C2)NC(=O)C3=CC=C(C=C3)F)F
CHEMBL105958 5ht1f_human Human No 8.1 Ki = 8.4 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
335 3 2 4 1.7 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=NC=C4
CHEMBL187952 5ht1f_human Human No 8.1 Ki = 8.6 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 2 4 3.5 CN1CCC(CC1)C2CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL187952 5ht1f_human Human No 8.1 Ki = 8.6 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 2 4 3.5 CN1CCC(CC1)C2CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL420475 5ht1f_human Human No 8.1 Ki = 8.7 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
312 3 2 3 2.2 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4CCC4
CHEMBL3617555 5ht1f_human Human No 6.1 Ki = 870 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
354 4 1 4 3.4 CC1=C(C=CC=C1NC(=O)C2=CC=C(C=C2)F)C(=O)C3CCN(CC3)C
CHEMBL3617555 5ht1f_human Human No 6.1 Ki = 870 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
354 4 1 4 3.4 CC1=C(C=CC=C1NC(=O)C2=CC=C(C=C2)F)C(=O)C3CCN(CC3)C
CHEMBL187952 5ht1f_human Human No 8.1 Ki = 9 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 2 4 3.5 CN1CCC(CC1)C2CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL3617557 5ht1f_human Human No 8.0 Ki = 9.5 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
341 4 1 5 2.6 CN1CCC(CC1)C(=O)C2=NC(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL3617557 5ht1f_human Human No 8.0 Ki = 9.5 Funct
Binding affinity to human 5HT1F receptor by radioligand binding assayBinding affinity to human 5HT1F receptor by radioligand binding assay
341 4 1 5 2.6 CN1CCC(CC1)C(=O)C2=NC(=CC=C2)NC(=O)C3=CC=C(C=C3)F
CHEMBL102335 5ht1f_human Human No 8.0 Ki = 9.5 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
338 3 3 4 2.4 C1CNCCC1C2=CNC3=C2N=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL187952 5ht1f_human Human No 8.0 Ki = 9.6 Funct
In vitro binding affinity for human 5-hydroxytryptamine 1F receptorIn vitro binding affinity for human 5-hydroxytryptamine 1F receptor
353 3 2 4 3.5 CN1CCC(CC1)C2CNC3=C2C=C(C=C3)NC(=O)C4=CC=C(C=C4)F
CHEMBL103424 5ht1f_human Human Yes 8.0 Ki = 9.7 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
271 2 2 2 1.8 CC(=O)NC1=CC2=C(C=C1)NC=C2C3CCN(CC3)C
CHEMBL104720 5ht1f_human Human No 8.0 Ki = 9.8 Funct
In vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptorIn vitro binding affinity was determined by radioligand binding assay using cell line expressing human 5-hydroxytryptamine 1F receptor
298 3 2 3 1.6 CN1CCC(CC1)C2=CNC3=C2N=C(C=C3)NC(=O)C4CC4
«

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 825.788 msec
System CPU time 82.417 msec
Total CPU time 908.205 msec
Elapsed time 1185.290 msec
Context switches 211 voluntary, 14 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 35.168.110.128
X-Forwarded-Proto https
X-Real-Ip 35.168.110.128

Response headers

Key Value
Content-Length 283585
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 /ligand/target/all/001_001_001_005/
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
ligand.views.TargetDetails () {'slug': '001_001_001_005'} ligand_target_detail

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

  •   default 294.07 ms (188 queries including 186 similar and 124 duplicates )
  Query Timeline Time (ms) Action
  +
SELECT ••• "ligand_assayexperiment"."id", "ligand_assayexperiment"."ligand_id", "ligand_assayexperiment"."protein_id", "ligand_assayexperiment"."assay_id", "ligand_assayexperiment"."assay_type", "ligand_assayexperiment"."assay_description", "ligand_assayexperiment"."pchembl_value", "ligand_assayexperiment"."published_value", "ligand_assayexperiment"."published_relation", "ligand_assayexperiment"."published_type", "ligand_assayexperiment"."published_units", "ligand_assayexperiment"."standard_value", "ligand_assayexperiment"."standard_relation", "ligand_assayexperiment"."standard_type", "ligand_assayexperiment"."standard_units", "ligand_assayexperiment"."publication_id", "ligand_assayexperiment"."chembl", "ligand_assayexperiment"."smiles", "ligand_assayexperiment"."activity", "ligand_assayexperiment"."document_chembl_id", "ligand_assayexperiment"."cell_line" FROM "ligand_assayexperiment" INNER JOIN "ligand" ON ("ligand_assayexperiment"."ligand_id" = "ligand"."id") INNER JOIN "ligand_properities" ON ("ligand"."properities_id" = "ligand_properities"."id") INNER JOIN "ligand_properities_web_links" ON ("ligand_properities"."id" = "ligand_properities_web_links"."ligandproperities_id") INNER JOIN "web_link" ON ("ligand_properities_web_links"."weblink_id" = "web_link"."id") INNER JOIN "web_resource" ON ("web_link"."web_resource_id" = "web_resource"."id") INNER JOIN "protein" ON ("ligand_assayexperiment"."protein_id" = "protein"."id") INNER JOIN "protein_family" ON ("protein"."family_id" = "protein_family"."id") WHERE ("web_resource"."slug" = 'chembl_ligand' AND "protein_family"."slug" = '001_001_001_005')
40.7776089610855%
 119.92

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/ligand/views.py in TargetDetails(334)
  if not ps:
  +
SELECT ••• "ligand_assayexperiment"."standard_type", "ligand_assayexperiment"."standard_relation", "ligand_assayexperiment"."standard_value", "ligand_assayexperiment"."assay_description", "ligand_assayexperiment"."assay_type", "ligand_assayexperiment"."pchembl_value", "ligand_assayexperiment"."ligand_id", "ligand"."properities_id", "web_link"."index", "species"."common_name", "protein"."entry_name", "ligand_properities"."mw", "ligand_properities"."logp", "ligand_properities"."rotatable_bonds", "ligand_properities"."smiles", "ligand_properities"."hdon", "ligand_properities"."hacc", "ligand_assayexperiment"."protein_id", COUNT(DISTINCT "ligand_assayexperiment"."protein_id") AS "num_targets" FROM "ligand_assayexperiment" INNER JOIN "ligand" ON ("ligand_assayexperiment"."ligand_id" = "ligand"."id") INNER JOIN "ligand_properities" ON ("ligand"."properities_id" = "ligand_properities"."id") INNER JOIN "ligand_properities_web_links" ON ("ligand_properities"."id" = "ligand_properities_web_links"."ligandproperities_id") INNER JOIN "web_link" ON ("ligand_properities_web_links"."weblink_id" = "web_link"."id") INNER JOIN "web_resource" ON ("web_link"."web_resource_id" = "web_resource"."id") INNER JOIN "protein" ON ("ligand_assayexperiment"."protein_id" = "protein"."id") INNER JOIN "protein_family" ON ("protein"."family_id" = "protein_family"."id") INNER JOIN "species" ON ("protein"."species_id" = "species"."id") WHERE ("web_resource"."slug" = 'chembl_ligand' AND "protein_family"."slug" = '001_001_001_005') GROUP BY "ligand_assayexperiment"."standard_type", "ligand_assayexperiment"."standard_relation", "ligand_assayexperiment"."standard_value", "ligand_assayexperiment"."assay_description", "ligand_assayexperiment"."assay_type", "ligand_assayexperiment"."pchembl_value", "ligand_assayexperiment"."ligand_id", "ligand"."properities_id", "web_link"."index", "species"."common_name", "protein"."entry_name", "ligand_properities"."mw", "ligand_properities"."logp", "ligand_properities"."rotatable_bonds", "ligand_properities"."smiles", "ligand_properities"."hdon", "ligand_properities"."hacc", "ligand_assayexperiment"."protein_id"
2.81314910873975%
 8.27

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/ligand/views.py in TargetDetails(357)
  for record in ps:
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43927 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.34497519908028235%
 1.01

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 44924 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18833781138977576%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 45542 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
1.1236219233968585%
 3.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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 110511 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.4969102221299766%
 1.46

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 110511 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18371652200139124%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 45083 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.47347947417834285%
 1.39

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 21286 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.5053420483824677%
 1.49

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 21286 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18493265078780824%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 100033 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.50599065040189%
 1.49

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 128372 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18777028462278117%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 44792 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.19474275633157184%
 0.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 67423 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.1907700689626097%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 42750 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18460834977809704%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 45849 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
1.0754632234547463%
 3.16

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 3855 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.583985043237432%
 1.72

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 130025 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.17374426595277204%
 0.51

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 70831 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18947286492376494%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 70831 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.1820139417004075%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 71931 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.537366773091448%
 1.58

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 71931 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.16328555838958603%
 0.48

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 110395 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.16360985939929723%
 0.48

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 110395 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18331114573925225%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 106845 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18785135987520896%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 71752 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.1867973815936476%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 71752 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18939178967133716%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 68670 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.5248001089651393%
 1.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 117612 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.7857813465302224%
 2.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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 41268 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.6099291240143276%
 1.79

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 41268 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18468942503052482%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 44481 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.2081201729821586%
 0.61

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 25392 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.5553654791304193%
 1.63

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 78503 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.18817566088492016%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 95155 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.1655556654575644%
 0.49

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43830 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 8 times.
0.18793243512763677%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43830 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 8 times.
0.19385092855486605%
 0.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 52841 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.1923915740111657%
 0.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43830 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 8 times.
0.18704060735093098%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 99867 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.1871216826033588%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 100653 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.1869595320985032%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 135927 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.19190512249659888%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 135927 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18225716745769088%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 32312 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.18955394017619276%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 46312 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.18525695179751944%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 102109 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.5283674200719624%
 1.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 128369 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.1496649159817159%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 112059 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18906748866162595%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 112059 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18339222099168004%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 70831 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.1815274901858407%
 0.53

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 70831 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18258146846740206%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 44937 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.19863436844810614%
 0.58

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 128509 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.5619325745770709%
 1.65

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 29923 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.19482383158399966%
 0.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 29923 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.1918240472441711%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 71752 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.20017479824423434%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 71752 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18258146846740206%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43466 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.5730398841596793%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 44637 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.497964200411538%
 1.46

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 44924 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.17982490988485694%
 0.53

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 24925 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.4405629216926567%
 1.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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 39594 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.6497370729563767%
 1.91

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 39594 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.16255588111773586%
 0.48

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 15962 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.18647308058393638%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 100381 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.5797691301111866%
 1.70

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 143496 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.19458060582671624%
 0.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 100383 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.5274755922952565%
 1.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 143496 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.1855001775548028%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 71931 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18314899523439668%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 131068 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.507612155450446%
 1.49

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 71931 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 4 times.
0.18233824271011867%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 131068 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18785135987520896%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 15255 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.19360770279758266%
 0.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 15255 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18452727452566922%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 44952 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.18906748866162595%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 110933 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.5155575301883702%
 1.52

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 110933 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18266254371982987%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 45103 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.5222057008874497%
 1.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 25608 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.1972560891568336%
 0.58

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 37741 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.18801351038006456%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43670 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.3967822853816455%
 1.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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 94150 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.19044576795289853%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 127968 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.5586084892275313%
 1.64

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 127968 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.1915808214868877%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43830 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 8 times.
0.18460834977809704%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43830 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 8 times.
0.1706634063605157%
 0.50

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43830 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 8 times.
0.18736490836064218%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43830 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 8 times.
0.1856623280596584%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 43830 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 8 times.
0.37513519298342335%
 1.10

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 24345 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.19903974471024516%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 24345 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.166123192224559%
 0.49

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 25392 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18298684472954108%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 100086 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.1821760922052631%
 0.54

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 141543 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.1869595320985032%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 141543 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.1816896406906963%
 0.53

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 117612 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.19279695027330468%
 0.57

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 5331 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.5066392524213124%
 1.49

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 26028 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.525691936741845%
 1.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 100993 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.16377200990415283%
 0.48

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 100687 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.19085114421503752%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 42463 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.15874534425362935%
 0.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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 46483 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
1.012467752318347%
 2.98

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 42454 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.7978615591419644%
 2.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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 45233 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
1.8310035008293999%
 5.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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 108708 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.19903974471024516%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 108708 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.18866211239948694%
 0.55

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 100510 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.16433953667114742%
 0.48

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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 3855 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.   Duplicated 2 times.
0.20520146389475785%
 0.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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 22838 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.20033694874908992%
 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/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT ••• "ligand_ligandvendorlink"."id", "ligand_ligandvendorlink"."vendor_id", "ligand_ligandvendorlink"."lp_id", "ligand_ligandvendorlink"."url", "ligand_ligandvendorlink"."vendor_external_id", "ligand_ligandvendorlink"."sid" FROM "ligand_ligandvendorlink" INNER JOIN "ligand_ligandvendors" ON ("ligand_ligandvendorlink"."vendor_id" = "ligand_ligandvendors"."id") WHERE ("ligand_ligandvendorlink"."lp_id" = 45718 AND NOT ("ligand_ligandvendors"."name" IN ('ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem')))
  186 similar queries.
0.9234471251526242%
 2.72

Connection: default

/usr/lib/python3.6/concurrent/futures/thread.py in _worker(69)
  work_item.run()
/usr/lib/python3.6/concurrent/futures/thread.py in run(56)
  result = self.fn(*self.args, **self.kwargs)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle(279)
  keepalive = self.handle_request(req, conn)
/home/protwis/gpcrdb_env/lib/python3.6/site-packages/gunicorn/workers/gthread.py in handle_request(328)
  respiter = self.wsgi(environ, resp.start_response)
/home/protwis/gpcrdb_test/common/middleware/stats.py in __call__(34)
  response = self.get_response(request)
/home/protwis/gpcrdb_test/ligand/views.py in TargetDetails(359)
  vendor__name__in=['ZINC', 'ChEMBL', 'BindingDB', 'SureChEMBL', 'eMolecules', 'MolPort', 'PubChem'])) > 0 else 'No'
  +
SELECT •••