I is 400000000 K is 500000000
400000000 400499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 400500000 K is 500000000
400500000 400999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 401000000 K is 500000000
401000000 401499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 401500000 K is 500000000
401500000 401999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 402000000 K is 500000000
402000000 402499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 402500000 K is 500000000
402500000 402999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 403000000 K is 500000000
403000000 403499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 403500000 K is 500000000
403500000 403999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 404000000 K is 500000000
404000000 404499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 404500000 K is 500000000
404500000 404999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 405000000 K is 500000000
405000000 405499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 405500000 K is 500000000
405500000 405999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 406000000 K is 500000000
406000000 406499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 406500000 K is 500000000
406500000 406999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 407000000 K is 500000000
407000000 407499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 407500000 K is 500000000
407500000 407999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 408000000 K is 500000000
408000000 408499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 408500000 K is 500000000
408500000 408999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 409000000 K is 500000000
409000000 409499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 409500000 K is 500000000
409500000 409999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 410000000 K is 500000000
410000000 410499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 410500000 K is 500000000
410500000 410999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 411000000 K is 500000000
411000000 411499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 411500000 K is 500000000
411500000 411999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 412000000 K is 500000000
412000000 412499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 412500000 K is 500000000
412500000 412999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 413000000 K is 500000000
413000000 413499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 413500000 K is 500000000
413500000 413999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 414000000 K is 500000000
414000000 414499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 414500000 K is 500000000
414500000 414999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 415000000 K is 500000000
415000000 415499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 415500000 K is 500000000
415500000 415999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
Traceback (most recent call last):
  File "/nfs/home/xyz/bin/fetch-hassea.py", line 36, in <module>
    for line in formatter(q):
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 359, in __call__
    yield self.format(item, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 323, in format
    return self._formatter(obj, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 277, in __call__
    return self.write(data, force_flush=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 273, in write
    self.buffered_write(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 507, in buffered_write
    fields = self._get_requested_data(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 528, in _get_requested_data
    data = super(TxtFormatter, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 502, in _get_requested_data
    data = super(CsvOutputBuffer, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 421, in _get_requested_data
    return self.extractor(obj, self.fields)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 157, in extract_fields
    value = getter(obj, field)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 222, in getattr_rs
    return getattr_r(obj, path.split(delimiter), get=get)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 217, in getattr_r
    branch = get(branch, step)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
    return self.impl.get(instance_state(instance), dict_)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 578, in get
    value = self.callable_(state, passive)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 529, in _load_for_state
    return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 573, in _emit_lazyload
    return loading.load_on_ident(q, ident_key)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
    return q.one()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 149, in one
    return self._ontimeout('one', *args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 143, in _ontimeout
    return bound()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 136, in <lambda>
    bound = lambda: func(*args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2473, in one
    ret = list(self)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 179, in __iter__
    return super(DeferredTransformationsQueryMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 376, in __iter__
    base_iter = super(AnnotateMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2516, in __iter__
    return self._execute_and_instances(context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (psycopg2.DatabaseError) server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
 [SQL: 'SELECT mol_to_smiles(substance.smiles) AS substance_smiles, substance.last_seen AS substance_last_seen, substance.free AS substance_free, substance.sub_id AS substance_sub_id, substance.inchikey AS substance_inchikey, substance.features AS substance_features, substance.purchasable AS substance_purchasable, substance.reactive AS substance_reactive, substance.bb AS substance_bb, substance.added_on AS substance_added_on, substance.purchasable_since AS substance_purchasable_since, substance.tranche_prefix AS substance_tranche_prefix, lower(CAST(subname_1.name AS TEXT)) AS lower_1, length(subname_1.name) AS length_1, subname_1.subname_id AS subname_1_subname_id, subname_1.sub_id_fk AS subname_1_sub_id_fk, subname_1.name AS subname_1_name, subname_1.preferred AS subname_1_preferred \nFROM substance LEFT OUTER JOIN subname AS subname_1 ON subname_1.sub_id_fk = substance.sub_id AND subname_1.preferred = true \nWHERE substance.sub_id = %(param_1)s'] [parameters: {'param_1': 415740946}]
I is 416000000 K is 500000000
416000000 416499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 416500000 K is 500000000
416500000 416999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 417000000 K is 500000000
417000000 417499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 417500000 K is 500000000
417500000 417999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 418000000 K is 500000000
418000000 418499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 418500000 K is 500000000
418500000 418999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 419000000 K is 500000000
419000000 419499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 419500000 K is 500000000
419500000 419999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 420000000 K is 500000000
420000000 420499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 420500000 K is 500000000
420500000 420999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 421000000 K is 500000000
421000000 421499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 421500000 K is 500000000
421500000 421999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 422000000 K is 500000000
422000000 422499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 422500000 K is 500000000
422500000 422999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 423000000 K is 500000000
423000000 423499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 423500000 K is 500000000
423500000 423999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 424000000 K is 500000000
424000000 424499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 424500000 K is 500000000
424500000 424999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 425000000 K is 500000000
425000000 425499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 425500000 K is 500000000
425500000 425999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 426000000 K is 500000000
426000000 426499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 426500000 K is 500000000
426500000 426999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 427000000 K is 500000000
427000000 427499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 427500000 K is 500000000
427500000 427999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 428000000 K is 500000000
428000000 428499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 428500000 K is 500000000
428500000 428999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 429000000 K is 500000000
429000000 429499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 429500000 K is 500000000
429500000 429999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 430000000 K is 500000000
430000000 430499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 430500000 K is 500000000
430500000 430999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 431000000 K is 500000000
431000000 431499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 431500000 K is 500000000
431500000 431999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 432000000 K is 500000000
432000000 432499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 432500000 K is 500000000
432500000 432999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 433000000 K is 500000000
433000000 433499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 433500000 K is 500000000
433500000 433999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 434000000 K is 500000000
434000000 434499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 434500000 K is 500000000
434500000 434999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 435000000 K is 500000000
435000000 435499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 435500000 K is 500000000
435500000 435999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 436000000 K is 500000000
436000000 436499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 436500000 K is 500000000
436500000 436999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 437000000 K is 500000000
437000000 437499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 437500000 K is 500000000
437500000 437999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 438000000 K is 500000000
438000000 438499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 438500000 K is 500000000
438500000 438999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 439000000 K is 500000000
439000000 439499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 439500000 K is 500000000
439500000 439999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 440000000 K is 500000000
440000000 440499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 440500000 K is 500000000
440500000 440999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 441000000 K is 500000000
441000000 441499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 441500000 K is 500000000
441500000 441999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 442000000 K is 500000000
442000000 442499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 442500000 K is 500000000
442500000 442999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 443000000 K is 500000000
443000000 443499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 443500000 K is 500000000
443500000 443999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 444000000 K is 500000000
444000000 444499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 444500000 K is 500000000
444500000 444999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 445000000 K is 500000000
445000000 445499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 445500000 K is 500000000
445500000 445999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 446000000 K is 500000000
446000000 446499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 446500000 K is 500000000
446500000 446999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 447000000 K is 500000000
447000000 447499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 447500000 K is 500000000
447500000 447999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 448000000 K is 500000000
448000000 448499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 448500000 K is 500000000
448500000 448999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 449000000 K is 500000000
449000000 449499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
Traceback (most recent call last):
  File "/nfs/home/xyz/bin/fetch-hassea.py", line 36, in <module>
    for line in formatter(q):
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 359, in __call__
    yield self.format(item, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 323, in format
    return self._formatter(obj, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 277, in __call__
    return self.write(data, force_flush=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 273, in write
    self.buffered_write(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 507, in buffered_write
    fields = self._get_requested_data(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 528, in _get_requested_data
    data = super(TxtFormatter, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 502, in _get_requested_data
    data = super(CsvOutputBuffer, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 421, in _get_requested_data
    return self.extractor(obj, self.fields)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 157, in extract_fields
    value = getter(obj, field)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 222, in getattr_rs
    return getattr_r(obj, path.split(delimiter), get=get)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 217, in getattr_r
    branch = get(branch, step)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/ext/associationproxy.py", line 246, in __get__
    target = getattr(obj, self.target_collection)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
    return self.impl.get(instance_state(instance), dict_)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 578, in get
    value = self.callable_(state, passive)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 529, in _load_for_state
    return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 573, in _emit_lazyload
    return loading.load_on_ident(q, ident_key)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
    return q.one()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 149, in one
    return self._ontimeout('one', *args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 143, in _ontimeout
    return bound()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 136, in <lambda>
    bound = lambda: func(*args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2473, in one
    ret = list(self)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 179, in __iter__
    return super(DeferredTransformationsQueryMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 376, in __iter__
    base_iter = super(AnnotateMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2516, in __iter__
    return self._execute_and_instances(context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (psycopg2.DatabaseError) server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
 [SQL: 'SELECT chembl21a.gene.num_targets AS chembl21a_gene_num_targets, chembl21a.gene.num_purch_substances AS chembl21a_gene_num_purch_substances, chembl21a.gene.gene_id AS chembl21a_gene_gene_id, chembl21a.gene.name AS chembl21a_gene_name, chembl21a.gene.description AS chembl21a_gene_description, chembl21a.gene.organism_fk AS chembl21a_gene_organism_fk, chembl21a.gene.target_class_fk AS chembl21a_gene_target_class_fk, chembl21a.gene.num_substances AS chembl21a_gene_num_substances, chembl21a.gene.num_observations AS chembl21a_gene_num_observations, chembl21a.gene.num_predictions AS chembl21a_gene_num_predictions, target_class_1.major_class AS target_class_1_major_class, target_class_1.num_targets AS target_class_1_num_targets, target_class_1.num_purch_substances AS target_class_1_num_purch_substances, target_class_1.target_class_id AS target_class_1_target_class_id, target_class_1.name AS target_class_1_name, target_class_1.chembl_description AS target_class_1_chembl_description, target_class_1.num_genes AS target_class_1_num_genes, target_class_1.num_substances AS target_class_1_num_substances, target_class_1.num_observations AS target_class_1_num_observations, target_class_1.num_predictions AS target_class_1_num_predictions, major_class_1.num_targets AS major_class_1_num_targets, major_class_1.num_purch_substances AS major_class_1_num_purch_substances, major_class_1.major_class_id AS major_class_1_major_class_id, major_class_1.name AS major_class_1_name, major_class_1.num_genes AS major_class_1_num_genes, major_class_1.num_substances AS major_class_1_num_substances, major_class_1.num_observations AS major_class_1_num_observations, major_class_1.num_predictions AS major_class_1_num_predictions \nFROM chembl21a.gene LEFT OUTER JOIN chembl21a.target_class AS target_class_1 ON target_class_1.target_class_id = chembl21a.gene.target_class_fk LEFT OUTER JOIN (chembl21a.target_class AS target_class_2 JOIN chembl21a.major_class AS major_class_1 ON target_class_2.major_class = major_class_1.major_class_id) ON target_class_2.target_class_id = chembl21a.gene.target_class_fk \nWHERE chembl21a.gene.gene_id = %(param_1)s'] [parameters: {'param_1': 90075}]
I is 449500000 K is 500000000
449500000 449999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
Traceback (most recent call last):
  File "/nfs/home/xyz/bin/fetch-hassea.py", line 36, in <module>
    for line in formatter(q):
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 359, in __call__
    yield self.format(item, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 323, in format
    return self._formatter(obj, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 277, in __call__
    return self.write(data, force_flush=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 273, in write
    self.buffered_write(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 507, in buffered_write
    fields = self._get_requested_data(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 528, in _get_requested_data
    data = super(TxtFormatter, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 502, in _get_requested_data
    data = super(CsvOutputBuffer, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 421, in _get_requested_data
    return self.extractor(obj, self.fields)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 157, in extract_fields
    value = getter(obj, field)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 222, in getattr_rs
    return getattr_r(obj, path.split(delimiter), get=get)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 217, in getattr_r
    branch = get(branch, step)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
    return self.impl.get(instance_state(instance), dict_)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 578, in get
    value = self.callable_(state, passive)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 529, in _load_for_state
    return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 573, in _emit_lazyload
    return loading.load_on_ident(q, ident_key)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
    return q.one()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 149, in one
    return self._ontimeout('one', *args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 143, in _ontimeout
    return bound()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 136, in <lambda>
    bound = lambda: func(*args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2473, in one
    ret = list(self)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 179, in __iter__
    return super(DeferredTransformationsQueryMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 376, in __iter__
    base_iter = super(AnnotateMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2516, in __iter__
    return self._execute_and_instances(context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.extensions.TransactionRollbackError) canceling statement due to conflict with recovery
DETAIL:  User query might have needed to see row versions that must be removed.
 [SQL: 'SELECT mol_to_smiles(substance.smiles) AS substance_smiles, substance.last_seen AS substance_last_seen, substance.free AS substance_free, substance.sub_id AS substance_sub_id, substance.inchikey AS substance_inchikey, substance.features AS substance_features, substance.purchasable AS substance_purchasable, substance.reactive AS substance_reactive, substance.bb AS substance_bb, substance.added_on AS substance_added_on, substance.purchasable_since AS substance_purchasable_since, substance.tranche_prefix AS substance_tranche_prefix, lower(CAST(subname_1.name AS TEXT)) AS lower_1, length(subname_1.name) AS length_1, subname_1.subname_id AS subname_1_subname_id, subname_1.sub_id_fk AS subname_1_sub_id_fk, subname_1.name AS subname_1_name, subname_1.preferred AS subname_1_preferred \nFROM substance LEFT OUTER JOIN subname AS subname_1 ON subname_1.sub_id_fk = substance.sub_id AND subname_1.preferred = true \nWHERE substance.sub_id = %(param_1)s'] [parameters: {'param_1': 449569961}]
I is 450000000 K is 500000000
450000000 450499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
Traceback (most recent call last):
  File "/nfs/home/xyz/bin/fetch-hassea.py", line 36, in <module>
    for line in formatter(q):
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 359, in __call__
    yield self.format(item, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 323, in format
    return self._formatter(obj, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 277, in __call__
    return self.write(data, force_flush=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 273, in write
    self.buffered_write(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 507, in buffered_write
    fields = self._get_requested_data(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 528, in _get_requested_data
    data = super(TxtFormatter, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 502, in _get_requested_data
    data = super(CsvOutputBuffer, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 421, in _get_requested_data
    return self.extractor(obj, self.fields)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 157, in extract_fields
    value = getter(obj, field)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 222, in getattr_rs
    return getattr_r(obj, path.split(delimiter), get=get)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 217, in getattr_r
    branch = get(branch, step)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/ext/associationproxy.py", line 246, in __get__
    target = getattr(obj, self.target_collection)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
    return self.impl.get(instance_state(instance), dict_)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 578, in get
    value = self.callable_(state, passive)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 529, in _load_for_state
    return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 573, in _emit_lazyload
    return loading.load_on_ident(q, ident_key)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
    return q.one()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 149, in one
    return self._ontimeout('one', *args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 143, in _ontimeout
    return bound()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 136, in <lambda>
    bound = lambda: func(*args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2473, in one
    ret = list(self)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 179, in __iter__
    return super(DeferredTransformationsQueryMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 376, in __iter__
    base_iter = super(AnnotateMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2516, in __iter__
    return self._execute_and_instances(context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (psycopg2.DatabaseError) server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
 [SQL: 'SELECT chembl21a.gene.num_targets AS chembl21a_gene_num_targets, chembl21a.gene.num_purch_substances AS chembl21a_gene_num_purch_substances, chembl21a.gene.gene_id AS chembl21a_gene_gene_id, chembl21a.gene.name AS chembl21a_gene_name, chembl21a.gene.description AS chembl21a_gene_description, chembl21a.gene.organism_fk AS chembl21a_gene_organism_fk, chembl21a.gene.target_class_fk AS chembl21a_gene_target_class_fk, chembl21a.gene.num_substances AS chembl21a_gene_num_substances, chembl21a.gene.num_observations AS chembl21a_gene_num_observations, chembl21a.gene.num_predictions AS chembl21a_gene_num_predictions, target_class_1.major_class AS target_class_1_major_class, target_class_1.num_targets AS target_class_1_num_targets, target_class_1.num_purch_substances AS target_class_1_num_purch_substances, target_class_1.target_class_id AS target_class_1_target_class_id, target_class_1.name AS target_class_1_name, target_class_1.chembl_description AS target_class_1_chembl_description, target_class_1.num_genes AS target_class_1_num_genes, target_class_1.num_substances AS target_class_1_num_substances, target_class_1.num_observations AS target_class_1_num_observations, target_class_1.num_predictions AS target_class_1_num_predictions, major_class_1.num_targets AS major_class_1_num_targets, major_class_1.num_purch_substances AS major_class_1_num_purch_substances, major_class_1.major_class_id AS major_class_1_major_class_id, major_class_1.name AS major_class_1_name, major_class_1.num_genes AS major_class_1_num_genes, major_class_1.num_substances AS major_class_1_num_substances, major_class_1.num_observations AS major_class_1_num_observations, major_class_1.num_predictions AS major_class_1_num_predictions \nFROM chembl21a.gene LEFT OUTER JOIN chembl21a.target_class AS target_class_1 ON target_class_1.target_class_id = chembl21a.gene.target_class_fk LEFT OUTER JOIN (chembl21a.target_class AS target_class_2 JOIN chembl21a.major_class AS major_class_1 ON target_class_2.major_class = major_class_1.major_class_id) ON target_class_2.target_class_id = chembl21a.gene.target_class_fk \nWHERE chembl21a.gene.gene_id = %(param_1)s'] [parameters: {'param_1': 91271}]
I is 450500000 K is 500000000
450500000 450999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 451000000 K is 500000000
451000000 451499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 451500000 K is 500000000
451500000 451999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 452000000 K is 500000000
452000000 452499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 452500000 K is 500000000
452500000 452999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 453000000 K is 500000000
453000000 453499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 453500000 K is 500000000
453500000 453999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 454000000 K is 500000000
454000000 454499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 454500000 K is 500000000
454500000 454999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 455000000 K is 500000000
455000000 455499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 455500000 K is 500000000
455500000 455999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 456000000 K is 500000000
456000000 456499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 456500000 K is 500000000
456500000 456999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 457000000 K is 500000000
457000000 457499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 457500000 K is 500000000
457500000 457999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 458000000 K is 500000000
458000000 458499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 458500000 K is 500000000
458500000 458999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 459000000 K is 500000000
459000000 459499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 459500000 K is 500000000
459500000 459999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 460000000 K is 500000000
460000000 460499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 460500000 K is 500000000
460500000 460999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 461000000 K is 500000000
461000000 461499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 461500000 K is 500000000
461500000 461999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 462000000 K is 500000000
462000000 462499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 462500000 K is 500000000
462500000 462999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 463000000 K is 500000000
463000000 463499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 463500000 K is 500000000
463500000 463999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 464000000 K is 500000000
464000000 464499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
Traceback (most recent call last):
  File "/nfs/home/xyz/bin/fetch-hassea.py", line 36, in <module>
    for line in formatter(q):
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 359, in __call__
    yield self.format(item, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 323, in format
    return self._formatter(obj, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 277, in __call__
    return self.write(data, force_flush=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 273, in write
    self.buffered_write(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 507, in buffered_write
    fields = self._get_requested_data(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 528, in _get_requested_data
    data = super(TxtFormatter, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 502, in _get_requested_data
    data = super(CsvOutputBuffer, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 421, in _get_requested_data
    return self.extractor(obj, self.fields)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 157, in extract_fields
    value = getter(obj, field)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 222, in getattr_rs
    return getattr_r(obj, path.split(delimiter), get=get)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 217, in getattr_r
    branch = get(branch, step)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
    return self.impl.get(instance_state(instance), dict_)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 578, in get
    value = self.callable_(state, passive)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 529, in _load_for_state
    return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 573, in _emit_lazyload
    return loading.load_on_ident(q, ident_key)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
    return q.one()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 149, in one
    return self._ontimeout('one', *args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 143, in _ontimeout
    return bound()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 136, in <lambda>
    bound = lambda: func(*args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2473, in one
    ret = list(self)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 179, in __iter__
    return super(DeferredTransformationsQueryMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 376, in __iter__
    base_iter = super(AnnotateMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2516, in __iter__
    return self._execute_and_instances(context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.extensions.TransactionRollbackError) canceling statement due to conflict with recovery
DETAIL:  User was holding a relation lock for too long.
 [SQL: 'SELECT mol_to_smiles(substance.smiles) AS substance_smiles, substance.last_seen AS substance_last_seen, substance.free AS substance_free, substance.sub_id AS substance_sub_id, substance.inchikey AS substance_inchikey, substance.features AS substance_features, substance.purchasable AS substance_purchasable, substance.reactive AS substance_reactive, substance.bb AS substance_bb, substance.added_on AS substance_added_on, substance.purchasable_since AS substance_purchasable_since, substance.tranche_prefix AS substance_tranche_prefix, lower(CAST(subname_1.name AS TEXT)) AS lower_1, length(subname_1.name) AS length_1, subname_1.subname_id AS subname_1_subname_id, subname_1.sub_id_fk AS subname_1_sub_id_fk, subname_1.name AS subname_1_name, subname_1.preferred AS subname_1_preferred \nFROM substance LEFT OUTER JOIN subname AS subname_1 ON subname_1.sub_id_fk = substance.sub_id AND subname_1.preferred = true \nWHERE substance.sub_id = %(param_1)s'] [parameters: {'param_1': 464422456}]
I is 464500000 K is 500000000
464500000 464999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 465000000 K is 500000000
465000000 465499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 465500000 K is 500000000
465500000 465999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 466000000 K is 500000000
466000000 466499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 466500000 K is 500000000
466500000 466999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 467000000 K is 500000000
467000000 467499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 467500000 K is 500000000
467500000 467999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 468000000 K is 500000000
468000000 468499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 468500000 K is 500000000
468500000 468999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 469000000 K is 500000000
469000000 469499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 469500000 K is 500000000
469500000 469999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 470000000 K is 500000000
470000000 470499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 470500000 K is 500000000
470500000 470999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 471000000 K is 500000000
471000000 471499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 471500000 K is 500000000
471500000 471999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 472000000 K is 500000000
472000000 472499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 472500000 K is 500000000
472500000 472999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 473000000 K is 500000000
473000000 473499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 473500000 K is 500000000
473500000 473999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
Traceback (most recent call last):
  File "/nfs/home/xyz/bin/fetch-hassea.py", line 36, in <module>
    for line in formatter(q):
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 359, in __call__
    yield self.format(item, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 323, in format
    return self._formatter(obj, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 277, in __call__
    return self.write(data, force_flush=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 273, in write
    self.buffered_write(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 507, in buffered_write
    fields = self._get_requested_data(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 528, in _get_requested_data
    data = super(TxtFormatter, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 502, in _get_requested_data
    data = super(CsvOutputBuffer, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 421, in _get_requested_data
    return self.extractor(obj, self.fields)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 157, in extract_fields
    value = getter(obj, field)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 222, in getattr_rs
    return getattr_r(obj, path.split(delimiter), get=get)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 217, in getattr_r
    branch = get(branch, step)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/ext/associationproxy.py", line 246, in __get__
    target = getattr(obj, self.target_collection)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
    return self.impl.get(instance_state(instance), dict_)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 578, in get
    value = self.callable_(state, passive)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 529, in _load_for_state
    return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 573, in _emit_lazyload
    return loading.load_on_ident(q, ident_key)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
    return q.one()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 149, in one
    return self._ontimeout('one', *args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 143, in _ontimeout
    return bound()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 136, in <lambda>
    bound = lambda: func(*args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2473, in one
    ret = list(self)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 179, in __iter__
    return super(DeferredTransformationsQueryMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 376, in __iter__
    base_iter = super(AnnotateMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2516, in __iter__
    return self._execute_and_instances(context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (psycopg2.DatabaseError) server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
 [SQL: 'SELECT chembl21a.gene.num_targets AS chembl21a_gene_num_targets, chembl21a.gene.num_purch_substances AS chembl21a_gene_num_purch_substances, chembl21a.gene.gene_id AS chembl21a_gene_gene_id, chembl21a.gene.name AS chembl21a_gene_name, chembl21a.gene.description AS chembl21a_gene_description, chembl21a.gene.organism_fk AS chembl21a_gene_organism_fk, chembl21a.gene.target_class_fk AS chembl21a_gene_target_class_fk, chembl21a.gene.num_substances AS chembl21a_gene_num_substances, chembl21a.gene.num_observations AS chembl21a_gene_num_observations, chembl21a.gene.num_predictions AS chembl21a_gene_num_predictions, target_class_1.major_class AS target_class_1_major_class, target_class_1.num_targets AS target_class_1_num_targets, target_class_1.num_purch_substances AS target_class_1_num_purch_substances, target_class_1.target_class_id AS target_class_1_target_class_id, target_class_1.name AS target_class_1_name, target_class_1.chembl_description AS target_class_1_chembl_description, target_class_1.num_genes AS target_class_1_num_genes, target_class_1.num_substances AS target_class_1_num_substances, target_class_1.num_observations AS target_class_1_num_observations, target_class_1.num_predictions AS target_class_1_num_predictions, major_class_1.num_targets AS major_class_1_num_targets, major_class_1.num_purch_substances AS major_class_1_num_purch_substances, major_class_1.major_class_id AS major_class_1_major_class_id, major_class_1.name AS major_class_1_name, major_class_1.num_genes AS major_class_1_num_genes, major_class_1.num_substances AS major_class_1_num_substances, major_class_1.num_observations AS major_class_1_num_observations, major_class_1.num_predictions AS major_class_1_num_predictions \nFROM chembl21a.gene LEFT OUTER JOIN chembl21a.target_class AS target_class_1 ON target_class_1.target_class_id = chembl21a.gene.target_class_fk LEFT OUTER JOIN (chembl21a.target_class AS target_class_2 JOIN chembl21a.major_class AS major_class_1 ON target_class_2.major_class = major_class_1.major_class_id) ON target_class_2.target_class_id = chembl21a.gene.target_class_fk \nWHERE chembl21a.gene.gene_id = %(param_1)s'] [parameters: {'param_1': 88782}]
I is 474000000 K is 500000000
474000000 474499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 474500000 K is 500000000
474500000 474999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 475000000 K is 500000000
475000000 475499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 475500000 K is 500000000
475500000 475999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 476000000 K is 500000000
476000000 476499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 476500000 K is 500000000
476500000 476999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 477000000 K is 500000000
477000000 477499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 477500000 K is 500000000
477500000 477999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 478000000 K is 500000000
478000000 478499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 478500000 K is 500000000
478500000 478999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 479000000 K is 500000000
479000000 479499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 479500000 K is 500000000
479500000 479999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 480000000 K is 500000000
480000000 480499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 480500000 K is 500000000
480500000 480999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 481000000 K is 500000000
481000000 481499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
Traceback (most recent call last):
  File "/nfs/home/xyz/bin/fetch-hassea.py", line 36, in <module>
    for line in formatter(q):
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 359, in __call__
    yield self.format(item, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 323, in format
    return self._formatter(obj, single=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 277, in __call__
    return self.write(data, force_flush=single)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 273, in write
    self.buffered_write(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 507, in buffered_write
    fields = self._get_requested_data(data)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 528, in _get_requested_data
    data = super(TxtFormatter, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 502, in _get_requested_data
    data = super(CsvOutputBuffer, self)._get_requested_data(obj)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 421, in _get_requested_data
    return self.extractor(obj, self.fields)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/data/representations.py", line 157, in extract_fields
    value = getter(obj, field)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 222, in getattr_rs
    return getattr_r(obj, path.split(delimiter), get=get)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/utils.py", line 217, in getattr_r
    branch = get(branch, step)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/ext/associationproxy.py", line 246, in __get__
    target = getattr(obj, self.target_collection)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
    return self.impl.get(instance_state(instance), dict_)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 578, in get
    value = self.callable_(state, passive)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 529, in _load_for_state
    return self._emit_lazyload(session, state, ident_key, passive)
  File "<string>", line 1, in <lambda>
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 573, in _emit_lazyload
    return loading.load_on_ident(q, ident_key)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/loading.py", line 219, in load_on_ident
    return q.one()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 149, in one
    return self._ontimeout('one', *args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 143, in _ontimeout
    return bound()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 136, in <lambda>
    bound = lambda: func(*args, **kwargs)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2473, in one
    ret = list(self)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 179, in __iter__
    return super(DeferredTransformationsQueryMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/zinc/extensions/sqlalchemy/query.py", line 376, in __iter__
    base_iter = super(AnnotateMixin, self).__iter__()
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2516, in __iter__
    return self._execute_and_instances(context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/nfs/soft/www/apps/zinc15/envs/production/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (psycopg2.DatabaseError) server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
 [SQL: 'SELECT chembl21a.gene.num_targets AS chembl21a_gene_num_targets, chembl21a.gene.num_purch_substances AS chembl21a_gene_num_purch_substances, chembl21a.gene.gene_id AS chembl21a_gene_gene_id, chembl21a.gene.name AS chembl21a_gene_name, chembl21a.gene.description AS chembl21a_gene_description, chembl21a.gene.organism_fk AS chembl21a_gene_organism_fk, chembl21a.gene.target_class_fk AS chembl21a_gene_target_class_fk, chembl21a.gene.num_substances AS chembl21a_gene_num_substances, chembl21a.gene.num_observations AS chembl21a_gene_num_observations, chembl21a.gene.num_predictions AS chembl21a_gene_num_predictions, target_class_1.major_class AS target_class_1_major_class, target_class_1.num_targets AS target_class_1_num_targets, target_class_1.num_purch_substances AS target_class_1_num_purch_substances, target_class_1.target_class_id AS target_class_1_target_class_id, target_class_1.name AS target_class_1_name, target_class_1.chembl_description AS target_class_1_chembl_description, target_class_1.num_genes AS target_class_1_num_genes, target_class_1.num_substances AS target_class_1_num_substances, target_class_1.num_observations AS target_class_1_num_observations, target_class_1.num_predictions AS target_class_1_num_predictions, major_class_1.num_targets AS major_class_1_num_targets, major_class_1.num_purch_substances AS major_class_1_num_purch_substances, major_class_1.major_class_id AS major_class_1_major_class_id, major_class_1.name AS major_class_1_name, major_class_1.num_genes AS major_class_1_num_genes, major_class_1.num_substances AS major_class_1_num_substances, major_class_1.num_observations AS major_class_1_num_observations, major_class_1.num_predictions AS major_class_1_num_predictions \nFROM chembl21a.gene LEFT OUTER JOIN chembl21a.target_class AS target_class_1 ON target_class_1.target_class_id = chembl21a.gene.target_class_fk LEFT OUTER JOIN (chembl21a.target_class AS target_class_2 JOIN chembl21a.major_class AS major_class_1 ON target_class_2.major_class = major_class_1.major_class_id) ON target_class_2.target_class_id = chembl21a.gene.target_class_fk \nWHERE chembl21a.gene.gene_id = %(param_1)s'] [parameters: {'param_1': 89941}]
I is 481500000 K is 500000000
481500000 481999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 482000000 K is 500000000
482000000 482499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 482500000 K is 500000000
482500000 482999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 483000000 K is 500000000
483000000 483499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 483500000 K is 500000000
483500000 483999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 484000000 K is 500000000
484000000 484499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 484500000 K is 500000000
484500000 484999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 485000000 K is 500000000
485000000 485499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 485500000 K is 500000000
485500000 485999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 486000000 K is 500000000
486000000 486499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 486500000 K is 500000000
486500000 486999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 487000000 K is 500000000
487000000 487499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 487500000 K is 500000000
487500000 487999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 488000000 K is 500000000
488000000 488499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 488500000 K is 500000000
488500000 488999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 489000000 K is 500000000
489000000 489499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 489500000 K is 500000000
489500000 489999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 490000000 K is 500000000
490000000 490499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 490500000 K is 500000000
490500000 490999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 491000000 K is 500000000
491000000 491499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 491500000 K is 500000000
491500000 491999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 492000000 K is 500000000
492000000 492499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 492500000 K is 500000000
492500000 492999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 493000000 K is 500000000
493000000 493499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 493500000 K is 500000000
493500000 493999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 494000000 K is 500000000
494000000 494499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 494500000 K is 500000000
494500000 494999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 495000000 K is 500000000
495000000 495499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 495500000 K is 500000000
495500000 495999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 496000000 K is 500000000
496000000 496499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 496500000 K is 500000000
496500000 496999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 497000000 K is 500000000
497000000 497499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 497500000 K is 500000000
497500000 497999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 498000000 K is 500000000
498000000 498499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 498500000 K is 500000000
498500000 498999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 499000000 K is 500000000
499000000 499499999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1
I is 499500000 K is 500000000
499500000 499999999
INFO:root:Using green thread (gevent)-enabled ZINC API (Forced: True)
INFO:root:Creating production ZINC application
INFO:root:ZINC production application loaded
INFO:root:SELECT chembl21a.sea.sea_id AS chembl21a_sea_sea_id, chembl21a.sea.sub_id_fk AS chembl21a_sea_sub_id_fk, chembl21a.sea.gene_fk AS chembl21a_sea_gene_fk, chembl21a.sea.predtype AS chembl21a_sea_predtype, chembl21a.sea.predvalue AS chembl21a_sea_predvalue, chembl21a.sea.pvalue AS chembl21a_sea_pvalue, chembl21a.sea.maxtc AS chembl21a_sea_maxtc 
FROM chembl21a.sea JOIN substance ON substance.sub_id = chembl21a.sea.sub_id_fk 
WHERE substance.sub_id BETWEEN :sub_id_1 AND :sub_id_2 AND substance.purchasable > :purchasable_1 AND (EXISTS (SELECT 1 
FROM chembl21a.sea 
WHERE substance.sub_id = chembl21a.sea.sub_id_fk))
 LIMIT :param_1