notebook.community



In [1]:

    
from biothings_explorer.user_query_dispatcher import FindConnection
from biothings_explorer.hint import Hint
ht = Hint()



In [2]:

    
tmprss2 = ht.query("TMPRSS2")['Gene'][0]



In [3]:

    
fc = FindConnection(input_obj=tmprss2, output_obj='ChemicalSubstance', intermediate_nodes=['BiologicalEntity'])
fc.connect(verbose=True)









    



==========
========== QUERY PARAMETER SUMMARY ==========
==========

BTE will find paths that join 'TMPRSS2' and 'ChemicalSubstance'.                   Paths will have 1 intermediate node.

Intermediate node #1 will have these type constraints: BiologicalEntity



========== QUERY #1 -- fetch all Biological Entities linked to TMPRSS2 ==========
==========

==== Step #1: Query path planning ====

Because TMPRSS2 is of type 'Gene', BTE will query our meta-KG for APIs that can take 'Gene' as input and                   'None' as output

BTE found 18 apis:

API 1. DISEASES(1 API call)
API 2. biolink_gene2phenotype(1 API call)
API 3. robokop_gene2chemical(1 API call)
API 4. semmedgene(11 API calls)
API 5. myvariant.info(1 API call)
API 6. semmeddisease(7 API calls)
API 7. robokop_gene2genefamily(1 API call)
API 8. mydisease.info(1 API call)
API 9. biolink_gene2disease(1 API call)
API 10. dgidb_gene2chemical(1 API call)
API 11. biolink_geneinteraction(1 API call)
API 12. mychem.info(3 API calls)
API 13. ctd_gene2disease(1 API call)
API 14. ebigene2phenotype(1 API call)
API 15. mygene.info(4 API calls)
API 16. pfocr(1 API call)
API 17. opentarget(1 API call)
API 18. biolink_gene2anatomy(1 API call)


==== Step #2: Query path execution ====
NOTE: API requests are dispatched in parallel, so the list of APIs below is ordered by query time.

API 15.2: http://mygene.info/v3/query (POST "q=7113&scopes=entrezgene&fields=pantherdb.ortholog.MGI,pantherdb.ortholog.PomBase,pantherdb.ortholog.TAIR,go.CC.id,pantherdb.ortholog.Ensembl,pantherdb.ortholog.FlyBase,pantherdb.ortholog.RGD,go.BP.id,pathway.reactome.id,pantherdb.ortholog.ZFIN,pantherdb.ortholog.SGD,pantherdb.ortholog.HGNC,pathway.wikipathways.id,go.MF.id,pantherdb.ortholog.dictyBase&species=human&size=100")
API 12.3: http://mychem.info/v1/query (POST "q=TMPRSS2&scopes=drugcentral.bioactivity.uniprot.gene_symbol&fields=chembl.molecule_chembl_id&species=human&size=100")
API 15.1: http://mygene.info/v3/query (POST "q=ENSG00000184012&scopes=ensembl.gene&fields=uniprot.Swiss-Prot,ensembl.protein,ensembl.transcript&species=human&size=100")
API 12.2: http://mychem.info/v1/query (POST "q=TMPRSS2&scopes=drugbank.targets.gene_name&fields=drugbank.id&species=human&size=100")
API 12.1: http://mychem.info/v1/query (POST "q=TMPRSS2&scopes=drugbank.enzymes.gene_name&fields=drugbank.id&species=human&size=100")
API 6.5: http://pending.biothings.io/semmed/query (POST "q=C1336641&scopes=ASSOCIATED_WITH.gene.umls&fields=umls&species=human&size=100")
API 8.1: http://mydisease.info/v1/query (POST "q=7113&scopes=disgenet.genes_related_to_disease.gene_id&fields=mondo.xrefs.umls,disgenet.xrefs.umls&species=human&size=100")
API 6.2: http://pending.biothings.io/semmed/query (POST "q=C1336641&scopes=AFFECTS.protein.umls&fields=umls&species=human&size=100")
API 15.4: http://mygene.info/v3/query (POST "q=11876&scopes=pantherdb.ortholog.HGNC&fields=entrezgene&species=human&size=100")
API 15.3: http://mygene.info/v3/query (POST "q=ENSG00000184012&scopes=pantherdb.ortholog.Ensembl&fields=entrezgene&species=human&size=100")
API 5.1: http://myvariant.info/v1/query (POST "q=7113&scopes=dbsnp.gene.geneid&fields=dbsnp.rsid&species=human&size=100")
API 10.1: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS2
API 6.7: http://pending.biothings.io/semmed/query (POST "q=C1336641&scopes=CAUSES_reverse.gene.umls&fields=umls&species=human&size=100")
API 6.4: http://pending.biothings.io/semmed/query (POST "q=C1336641&scopes=AFFECTS_reverse.protein.umls&fields=umls&species=human&size=100")
API 6.3: http://pending.biothings.io/semmed/query (POST "q=C1336641&scopes=AFFECTS_reverse.gene.umls&fields=umls&species=human&size=100")
API 2.1: https://api.monarchinitiative.org/api/bioentity/gene/NCBIGene:7113/phenotypes?rows=100
API 9.1: https://api.monarchinitiative.org/api/bioentity/gene/NCBIGene:7113/diseases?rows=100
API 6.6: http://pending.biothings.io/semmed/query (POST "q=C1336641&scopes=ASSOCIATED_WITH_reverse.gene.umls&fields=umls&species=human&size=100")
API 6.1: http://pending.biothings.io/semmed/query (POST "q=C1336641&scopes=AFFECTS.gene.umls&fields=umls&species=human&size=100")
API 4.10: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=stimulates.protein.umls&fields=umls&species=human&size=100")
API 4.4: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=disrupts.gene.umls&fields=umls&species=human&size=100")
API 4.9: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=interacts_with.protein.umls&fields=umls&species=human&size=100")
API 4.6: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=inhibits.gene.umls&fields=umls&species=human&size=100")
API 4.2: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=affects.protein.umls&fields=umls&species=human&size=100")
API 4.5: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=disrupts.protein.umls&fields=umls&species=human&size=100")
API 4.1: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=affects.gene.umls&fields=umls&species=human&size=100")
API 4.3: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=associated_with.gene.umls&fields=umls&species=human&size=100")
API 18.1: https://api.monarchinitiative.org/api/bioentity/gene/NCBIGene:7113/anatomy?rows=100
API 4.8: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=interacts_with.gene.umls&fields=umls&species=human&size=100")
API 4.7: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=inhibits.protein.umls&fields=umls&species=human&size=100")
API 4.11: https://pending.biothings.io/semmedgene/query (POST "q=C1336641&scopes=umls&fields=stimulates.phenotypic_feature.umls,associated_with.biological_process_or_activity.umls,inhibits.cell_component.umls,associated_with.chemical_substance.umls,interacts_with.biological_process_or_activity.umls,disrupts.protein.umls,affects_reverse.biological_process_or_activity.umls,affects.cell.umls,affects_reverse.chemical_substance.umls,associated_with.gene.umls,associated_with.phenotypic_feature.umls,associated_with_reverse.anatomical_entity.umls,inhibits.biological_process_or_activity.umls,inhibits.protein.umls,affects.chemical_substance.umls,disrupts.cell.umls,stimulates.cell.umls,interacts_with_reverse.cell_component.umls,interacts_with_reverse.cell.umls,associated_with_reverse.biological_process_or_activity.umls,disrupts.cell_component.umls,interacts_with_reverse.chemical_substance.umls,disrupts.phenotypic_feature.umls,affects_reverse.cell_component.umls,stimulates.biological_process_or_activity.umls,affects.biological_process_or_activity.umls,associated_with_reverse.chemical_substance.umls,inhibits.phenotypic_feature.umls,affects_reverse.cell.umls,disrupts.gene.umls,interacts_with.protein.umls,interacts_with.cell_component.umls,affects.gene.umls,interacts_with_reverse.biological_process_or_activity.umls,associated_with.cell.umls,stimulates.anatomical_entity.umls,interacts_with.chemical_substance.umls,stimulates.cell_component.umls,affects.cell_component.umls,affects.protein.umls,affects.phenotypic_feature.umls,associated_with.anatomical_entity.umls,interacts_with.cell.umls,stimulates.protein.umls,disrupts.biological_process_or_activity.umls,interacts_with.gene.umls,affects.anatomical_entity.umls,inhibits.gene.umls&species=human&size=100")
API 11.1: https://api.monarchinitiative.org/api/bioentity/gene/NCBIGene:7113/interactions?rows=100
API 14.1: https://pending.biothings.io/ebigene2phenotype/query (POST "q=11876&scopes=_id&fields=gene2phenotype.phenotypes&species=human&size=100")
API 1.1: https://pending.biothings.io/DISEASES/query (POST "q=TMPRSS2&scopes=DISEASES.associatedWith.symbol&fields=_id&species=human&size=100")
API 16.1: https://pending.biothings.io/pfocr/query (POST "q=7113&scopes=associatedWith.genes&fields=_id&species=human&size=100")
API 17.1: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000184012&datasource=chembl&size=15&fields=drug
API 13.1: http://ctdbase.org/tools/batchQuery.go?inputType=gene&inputTerms=7113&report=diseases_curated&format=json
0, message='Attempt to decode JSON with unexpected mimetype: text/plain;charset=utf-8'
API 7.1: https://robokop.renci.org/api/simple/expand/gene/HGNC:11876/gene_family/
API 3.1: https://robokop.renci.org/api/simple/expand/gene/HGNC:11876/chemical_substance/


==== Step #3: Output normalization ====

API 1.1 DISEASES: 18 hits
API 18.1 biolink_gene2anatomy: 20 hits
API 9.1 biolink_gene2disease: 1 hits
API 2.1 biolink_gene2phenotype: 2 hits
API 11.1 biolink_geneinteraction: 11 hits
API 13.1 ctd_gene2disease: 2 hits
API 10.1 dgidb_gene2chemical: No hits
API 14.1 ebigene2phenotype: No hits
API 12.1 mychem.info: No hits
API 12.2 mychem.info: No hits
API 12.3 mychem.info: No hits
API 8.1 mydisease.info: 6 hits
API 15.1 mygene.info: 2 hits
API 15.2 mygene.info: 20 hits
API 15.3 mygene.info: No hits
API 15.4 mygene.info: 23 hits
API 5.1 myvariant.info: 100 hits
API 17.1 opentarget: No hits
API 16.1 pfocr: 5 hits
API 3.1 robokop_gene2chemical: No hits
API 7.1 robokop_gene2genefamily: 3 hits
API 6.1 semmeddisease: No hits
API 6.2 semmeddisease: No hits
API 6.3 semmeddisease: 4 hits
API 6.4 semmeddisease: No hits
API 6.5 semmeddisease: No hits
API 6.6 semmeddisease: 22 hits
API 6.7 semmeddisease: 3 hits
API 4.1 semmedgene: No hits
API 4.2 semmedgene: No hits
API 4.3 semmedgene: No hits
API 4.4 semmedgene: No hits
API 4.5 semmedgene: No hits
API 4.6 semmedgene: No hits
API 4.7 semmedgene: No hits
API 4.8 semmedgene: 7 hits
API 4.9 semmedgene: No hits
API 4.10 semmedgene: No hits
API 4.11 semmedgene: 24 hits

After id-to-object translation, BTE retrieved 261 unique objects.


========== QUERY #2.1 -- fetch all ChemicalSubstance entities linked to DiseaseOrPhenotypicFeature entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'DiseaseOrPhenotypicFeature', BTE will query our meta-KG for APIs that can take 'DiseaseOrPhenotypicFeature' as input and                   'ChemicalSubstance' as output

BTE found 4 apis:

API 1. semmeddisease(1 API call)
API 2. cohd_disease2chemical(6 API calls)
API 3. mydisease.info(1 API call)
API 4. mychem.info(2 API calls)


==== Step #2: Query path execution ====
NOTE: API requests are dispatched in parallel, so the list of APIs below is ordered by query time.

API 3.5: http://cohd.io/api/frequencies/associatedConceptDomainFreq?dataset_id=1&concept_id=4163261&domain=Drug
API 3.1: http://cohd.io/api/frequencies/associatedConceptDomainFreq?dataset_id=1&concept_id=4181351&domain=Drug
API 3.6: http://cohd.io/api/frequencies/associatedConceptDomainFreq?dataset_id=1&concept_id=432571&domain=Drug
API 3.3: http://cohd.io/api/frequencies/associatedConceptDomainFreq?dataset_id=1&concept_id=443392&domain=Drug
API 2.1: http://pending.biothings.io/semmed/query (POST "q=C1261473,C0277565,C0376358,C0242656,C0699748,C0023418,C0040715,C0920779,C0024299,C0029925,C1458155,C0153658,C0005695,C0600139,C0178874,C0006826,C0028778,C0346647,C1140680,C1368683,C0242379,C0012634,C0033578,C2931456,C0033581,C0936223,C0596263,C0005001,C0025202,C0005684,C0007131,C0677886,C0152013,C0677930,C1442161,C0553580,C0006142,C1838601,C0919267,C0020507,C0684249,C0027651,C0334001,C0030297,C0007112,C0007120,C0235974,C1175175,C0012860,C0007097,C0684337,C0021400,C0021831&scopes=umls&fields=ASSOCIATED_WITH_reverse.chemical_substance.umls,TREATS_reverse.chemical_substance.umls,AFFECTS_reverse.chemical_substance.umls,ASSOCIATED_WITH.chemical_substance.umls,AFFECTS.chemical_substance.umls&species=human&size=100")
API 3.4: http://cohd.io/api/frequencies/associatedConceptDomainFreq?dataset_id=1&concept_id=320752&domain=Drug
API 3.2: http://cohd.io/api/frequencies/associatedConceptDomainFreq?dataset_id=1&concept_id=194997&domain=Drug
API 4.1: http://mydisease.info/v1/query (POST "q=D009375,C537243,C538090,C562463,D008175,D012512,D008223,C563991,D009371,D002289,D007410,D007938,D011472,D006965,D007251,D001943,D008545,D010190,D002282,D045169,D018241,D004194,D010051,C000657245,D012509,C538231,D001749,D011471&scopes=mondo.xrefs.mesh,disgenet.xrefs.mesh&fields=ctd.chemical_related_to_disease.mesh_chemical_id&species=human&size=100")
API 1.2: http://mychem.info/v1/query (POST "q=C1261473,C0277565,C0376358,C0242656,C0699748,C0023418,C0040715,C0920779,C0024299,C0029925,C1458155,C0153658,C0005695,C0600139,C0178874,C0006826,C0028778,C0346647,C1140680,C1368683,C0242379,C0012634,C0033578,C2931456,C0033581,C0936223,C0596263,C0005001,C0025202,C0005684,C0007131,C0677886,C0152013,C0677930,C1442161,C0553580,C0006142,C1838601,C0919267,C0020507,C0684249,C0027651,C0334001,C0030297,C0007112,C0007120,C0235974,C1175175,C0012860,C0007097,C0684337,C0021400,C0021831&scopes=drugcentral.drug_use.indication.umls_cui&fields=chembl.molecule_chembl_id&species=human&size=100")
API 1.1: http://mychem.info/v1/query (POST "q=C1261473,C0277565,C0376358,C0242656,C0699748,C0023418,C0040715,C0920779,C0024299,C0029925,C1458155,C0153658,C0005695,C0600139,C0178874,C0006826,C0028778,C0346647,C1140680,C1368683,C0242379,C0012634,C0033578,C2931456,C0033581,C0936223,C0596263,C0005001,C0025202,C0005684,C0007131,C0677886,C0152013,C0677930,C1442161,C0553580,C0006142,C1838601,C0919267,C0020507,C0684249,C0027651,C0334001,C0030297,C0007112,C0007120,C0235974,C1175175,C0012860,C0007097,C0684337,C0021400,C0021831&scopes=drugcentral.drug_use.contraindication.umls_cui&fields=chembl.molecule_chembl_id&species=human&size=100")


==== Step #3: Output normalization ====

API 3.1 cohd_disease2chemical: 430 hits
API 3.2 cohd_disease2chemical: 714 hits
API 3.3 cohd_disease2chemical: 1007 hits
API 3.4 cohd_disease2chemical: 432 hits
API 3.5 cohd_disease2chemical: 2298 hits
API 3.6 cohd_disease2chemical: 1859 hits
API 1.1 mychem.info: 79 hits
API 1.2 mychem.info: 75 hits
API 4.1 mydisease.info: 17194 hits
API 2.1 semmeddisease: 39092 hits

After id-to-object translation, BTE retrieved 11777 unique objects.


========== QUERY #2.2 -- fetch all ChemicalSubstance entities linked to AnatomicalEntity entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'AnatomicalEntity', BTE will query our meta-KG for APIs that can take 'AnatomicalEntity' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!


========== QUERY #2.3 -- fetch all ChemicalSubstance entities linked to PhenotypicFeature entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'PhenotypicFeature', BTE will query our meta-KG for APIs that can take 'PhenotypicFeature' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!


========== QUERY #2.4 -- fetch all ChemicalSubstance entities linked to Pathway entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'Pathway', BTE will query our meta-KG for APIs that can take 'Pathway' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!


========== QUERY #2.5 -- fetch all ChemicalSubstance entities linked to Gene entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'Gene', BTE will query our meta-KG for APIs that can take 'Gene' as input and                   'ChemicalSubstance' as output

BTE found 5 apis:

API 1. semmedgene(1 API call)
API 2. robokop_gene2chemical(43 API calls)
API 3. dgidb_gene2chemical(43 API calls)
API 4. mychem.info(3 API calls)
API 5. opentarget(47 API calls)


==== Step #2: Query path execution ====
NOTE: API requests are dispatched in parallel, so the list of APIs below is ordered by query time.

API 3.1: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS6
API 5.2: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000140443&datasource=chembl&size=15&fields=drug
API 5.29: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSGALG00000016144&datasource=chembl&size=15&fields=drug
API 3.20: http://www.dgidb.org/api/v2/interactions.json?genes=MMP9
API 5.47: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000166682&datasource=chembl&size=15&fields=drug
API 5.18: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000187045&datasource=chembl&size=15&fields=drug
API 5.23: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000285141&datasource=chembl&size=15&fields=drug
API 5.32: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000185873&datasource=chembl&size=15&fields=drug
API 5.30: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000283706&datasource=chembl&size=15&fields=drug
API 5.12: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000186452&datasource=chembl&size=15&fields=drug
API 5.40: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000160183&datasource=chembl&size=15&fields=drug
API 3.31: http://www.dgidb.org/api/v2/interactions.json?genes=SLC45A3
API 5.36: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000183844&datasource=chembl&size=15&fields=drug
API 5.31: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000169083&datasource=chembl&size=15&fields=drug
API 5.43: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000175832&datasource=chembl&size=15&fields=drug
API 5.45: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000052344&datasource=chembl&size=15&fields=drug
API 5.9: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000205403&datasource=chembl&size=15&fields=drug
API 5.42: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000141510&datasource=chembl&size=15&fields=drug
API 3.18: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS13
API 5.4: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000215148&datasource=chembl&size=15&fields=drug
API 5.21: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000154646&datasource=chembl&size=15&fields=drug
API 5.11: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000013441&datasource=chembl&size=15&fields=drug
API 5.17: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000137747&datasource=chembl&size=15&fields=drug
API 5.19: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000100985&datasource=chembl&size=15&fields=drug
API 3.13: http://www.dgidb.org/api/v2/interactions.json?genes=PRSS8
API 3.3: http://www.dgidb.org/api/v2/interactions.json?genes=PLXNA2
API 3.14: http://www.dgidb.org/api/v2/interactions.json?genes=PRSS51
API 3.16: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS15
API 3.12: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS5
API 3.7: http://www.dgidb.org/api/v2/interactions.json?genes=ERG
API 3.34: http://www.dgidb.org/api/v2/interactions.json?genes=FKBP5
API 3.21: http://www.dgidb.org/api/v2/interactions.json?genes=IGF1R
API 3.17: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS4
API 3.5: http://www.dgidb.org/api/v2/interactions.json?genes=PRSS27
API 3.8: http://www.dgidb.org/api/v2/interactions.json?genes=ETV1
API 3.9: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS12
API 3.39: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS7
API 3.41: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS11D
API 3.40: http://www.dgidb.org/api/v2/interactions.json?genes=PRSS22
API 3.43: http://www.dgidb.org/api/v2/interactions.json?genes=FAM3B
API 3.26: http://www.dgidb.org/api/v2/interactions.json?genes=NKX3-1
API 3.25: http://www.dgidb.org/api/v2/interactions.json?genes=ETS1
API 3.19: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS3
API 3.22: http://www.dgidb.org/api/v2/interactions.json?genes=KLKB1
API 3.10: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS11F
API 5.1: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000087128&datasource=chembl&size=15&fields=drug
API 5.33: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000006468&datasource=chembl&size=15&fields=drug
API 5.6: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000153802&datasource=chembl&size=15&fields=drug
API 5.20: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000187054&datasource=chembl&size=15&fields=drug
API 3.15: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS11E
API 5.25: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000172382&datasource=chembl&size=15&fields=drug
API 5.7: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000157554&datasource=chembl&size=15&fields=drug
API 5.13: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000149418&datasource=chembl&size=15&fields=drug
API 3.29: http://www.dgidb.org/api/v2/interactions.json?genes=ST14
API 1.1: https://pending.biothings.io/semmedgene/query (POST "q=C1708832,C1416681,C1418661,C1442484,C1428929,C2828579,C1429009,C1424347,C1412940,C1705029,C1705526,C2828570,C1334523,C1705691,C1710301,C1415646,C0812201,C0599295,C1366520,C1822765,C0079419,C1334882,C3541023,C1423515,C1540030,C1420784,C1705964,C1333361,C1540025,C2828575,C1540027,C1540028,C0694888,C1540029,C1420785,C1415700,C1333362,C1334088,C1418974,C1414498,C0017337,C1367578,C0079427,C1540024,C1422596,C1705350,C1418973,C1423044,C1842761,C1540026,C1414627,C1413489&scopes=umls&fields=affects.chemical_substance.umls,associated_with.chemical_substance.umls,interacts_with.chemical_substance.umls,associated_with_reverse.chemical_substance.umls,affects_reverse.chemical_substance.umls,interacts_with_reverse.chemical_substance.umls&species=human&size=100")
API 5.35: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000105707&datasource=chembl&size=15&fields=drug
API 4.1: http://mychem.info/v1/query (POST "q=TMPRSS6,HPN,PLXNA2,PRSS46P,PRSS27,ETV4,ERG,ETV1,TMPRSS12,TMPRSS11F,CLK1,TMPRSS5,PRSS8,PRSS51,TMPRSS11E,TMPRSS15,TMPRSS4,TMPRSS13,TMPRSS3,MMP9,IGF1R,KLKB1,AR,PTEN,ETS1,NKX3-1,PRSS55,TP53,ST14,F11,SLC45A3,TMPRSS9,PRSS41,FKBP5,HNRNPL,CFI,TMPRSS11B,PRSS50,TMPRSS7,PRSS22,TMPRSS11D,TMPRSS11A,FAM3B&scopes=drugbank.enzymes.gene_name&fields=drugbank.id&species=human&size=100")
API 5.3: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000282947&datasource=chembl&size=15&fields=drug
API 5.5: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000134954&datasource=chembl&size=15&fields=drug
API 5.38: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000184647&datasource=chembl&size=15&fields=drug
API 5.10: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000274058&datasource=chembl&size=15&fields=drug
API 5.24: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000176040&datasource=chembl&size=15&fields=drug
API 3.6: http://www.dgidb.org/api/v2/interactions.json?genes=ETV4
API 5.28: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000164344&datasource=chembl&size=15&fields=drug
API 5.41: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000198092&datasource=chembl&size=15&fields=drug
API 5.44: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000104824&datasource=chembl&size=15&fields=drug
API 5.39: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000005001&datasource=chembl&size=15&fields=drug
API 5.15: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000282937&datasource=chembl&size=15&fields=drug
API 5.16: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000088926&datasource=chembl&size=15&fields=drug
API 5.27: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000284792&datasource=chembl&size=15&fields=drug
API 5.37: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000076356&datasource=chembl&size=15&fields=drug
API 5.8: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000167034&datasource=chembl&size=15&fields=drug
API 5.34: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000158715&datasource=chembl&size=15&fields=drug
API 5.46: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000178297&datasource=chembl&size=15&fields=drug
API 5.14: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000171862&datasource=chembl&size=15&fields=drug
API 5.22: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000137648&datasource=chembl&size=15&fields=drug
API 5.26: https://platform-api.opentargets.io/v3/platform/public/evidence/filter?target=ENSG00000096060&datasource=chembl&size=15&fields=drug
API 3.33: http://www.dgidb.org/api/v2/interactions.json?genes=PRSS41
API 3.2: http://www.dgidb.org/api/v2/interactions.json?genes=HPN
API 3.42: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS11A
API 3.32: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS9
API 3.11: http://www.dgidb.org/api/v2/interactions.json?genes=CLK1
API 3.35: http://www.dgidb.org/api/v2/interactions.json?genes=HNRNPL
API 3.36: http://www.dgidb.org/api/v2/interactions.json?genes=CFI
API 3.4: http://www.dgidb.org/api/v2/interactions.json?genes=PRSS46P
API 3.24: http://www.dgidb.org/api/v2/interactions.json?genes=PTEN
API 3.27: http://www.dgidb.org/api/v2/interactions.json?genes=PRSS55
API 3.38: http://www.dgidb.org/api/v2/interactions.json?genes=PRSS50
API 3.37: http://www.dgidb.org/api/v2/interactions.json?genes=TMPRSS11B
API 3.28: http://www.dgidb.org/api/v2/interactions.json?genes=TP53
API 3.23: http://www.dgidb.org/api/v2/interactions.json?genes=AR
API 3.30: http://www.dgidb.org/api/v2/interactions.json?genes=F11
API 4.2: http://mychem.info/v1/query (POST "q=TMPRSS6,HPN,PLXNA2,PRSS46P,PRSS27,ETV4,ERG,ETV1,TMPRSS12,TMPRSS11F,CLK1,TMPRSS5,PRSS8,PRSS51,TMPRSS11E,TMPRSS15,TMPRSS4,TMPRSS13,TMPRSS3,MMP9,IGF1R,KLKB1,AR,PTEN,ETS1,NKX3-1,PRSS55,TP53,ST14,F11,SLC45A3,TMPRSS9,PRSS41,FKBP5,HNRNPL,CFI,TMPRSS11B,PRSS50,TMPRSS7,PRSS22,TMPRSS11D,TMPRSS11A,FAM3B&scopes=drugbank.targets.gene_name&fields=drugbank.id&species=human&size=100")
API 4.3: http://mychem.info/v1/query (POST "q=TMPRSS6,HPN,PLXNA2,PRSS46P,PRSS27,ETV4,ERG,ETV1,TMPRSS12,TMPRSS11F,CLK1,TMPRSS5,PRSS8,PRSS51,TMPRSS11E,TMPRSS15,TMPRSS4,TMPRSS13,TMPRSS3,MMP9,IGF1R,KLKB1,AR,PTEN,ETS1,NKX3-1,PRSS55,TP53,ST14,F11,SLC45A3,TMPRSS9,PRSS41,FKBP5,HNRNPL,CFI,TMPRSS11B,PRSS50,TMPRSS7,PRSS22,TMPRSS11D,TMPRSS11A,FAM3B&scopes=drugcentral.bioactivity.uniprot.gene_symbol&fields=chembl.molecule_chembl_id&species=human&size=100")
API 2.1: https://robokop.renci.org/api/simple/expand/gene/HGNC:9100/chemical_substance/
API 2.4: https://robokop.renci.org/api/simple/expand/gene/HGNC:24059/chemical_substance/
API 2.3: https://robokop.renci.org/api/simple/expand/gene/HGNC:16517/chemical_substance/
API 2.2: https://robokop.renci.org/api/simple/expand/gene/HGNC:30824/chemical_substance/
API 2.5: https://robokop.renci.org/api/simple/expand/gene/HGNC:3493/chemical_substance/
API 2.6: https://robokop.renci.org/api/simple/expand/gene/HGNC:6371/chemical_substance/
API 2.7: https://robokop.renci.org/api/simple/expand/gene/HGNC:5155/chemical_substance/
API 2.9: https://robokop.renci.org/api/simple/expand/gene/HGNC:9490/chemical_substance/
API 2.8: https://robokop.renci.org/api/simple/expand/gene/HGNC:11877/chemical_substance/
API 2.10: https://robokop.renci.org/api/simple/expand/gene/HGNC:8642/chemical_substance/
API 2.12: https://robokop.renci.org/api/simple/expand/gene/HGNC:24465/chemical_substance/
API 2.11: https://robokop.renci.org/api/simple/expand/gene/HGNC:27954/chemical_substance/
API 2.13: https://robokop.renci.org/api/simple/expand/gene/HGNC:11344/chemical_substance/
API 2.19: https://robokop.renci.org/api/simple/expand/gene/HGNC:3721/chemical_substance/
API 2.15: https://robokop.renci.org/api/simple/expand/gene/HGNC:3529/chemical_substance/
API 2.21: https://robokop.renci.org/api/simple/expand/gene/HGNC:2068/chemical_substance/
API 2.25: https://robokop.renci.org/api/simple/expand/gene/HGNC:1253/chemical_substance/
API 2.18: https://robokop.renci.org/api/simple/expand/gene/HGNC:28779/chemical_substance/
API 2.22: https://robokop.renci.org/api/simple/expand/gene/HGNC:7838/chemical_substance/
API 2.28: https://robokop.renci.org/api/simple/expand/gene/HGNC:3446/chemical_substance/
API 2.20: https://robokop.renci.org/api/simple/expand/gene/HGNC:37321/chemical_substance/
API 2.17: https://robokop.renci.org/api/simple/expand/gene/HGNC:30079/chemical_substance/
API 2.26: https://robokop.renci.org/api/simple/expand/gene/HGNC:30846/chemical_substance/
API 2.32: https://robokop.renci.org/api/simple/expand/gene/HGNC:3490/chemical_substance/
API 2.31: https://robokop.renci.org/api/simple/expand/gene/HGNC:25398/chemical_substance/
API 2.16: https://robokop.renci.org/api/simple/expand/gene/HGNC:37325/chemical_substance/
API 2.24: https://robokop.renci.org/api/simple/expand/gene/HGNC:5045/chemical_substance/
API 2.23: https://robokop.renci.org/api/simple/expand/gene/HGNC:11878/chemical_substance/
API 2.29: https://robokop.renci.org/api/simple/expand/gene/HGNC:29808/chemical_substance/
API 2.27: https://robokop.renci.org/api/simple/expand/gene/HGNC:3488/chemical_substance/
API 2.35: https://robokop.renci.org/api/simple/expand/gene/HGNC:29994/chemical_substance/
API 2.33: https://robokop.renci.org/api/simple/expand/gene/HGNC:9491/chemical_substance/
API 2.34: https://robokop.renci.org/api/simple/expand/gene/HGNC:14368/chemical_substance/
API 2.14: https://robokop.renci.org/api/simple/expand/gene/HGNC:7176/chemical_substance/
API 2.42: https://robokop.renci.org/api/simple/expand/gene/HGNC:30715/chemical_substance/
API 2.43: https://robokop.renci.org/api/simple/expand/gene/HGNC:17910/chemical_substance/
API 2.30: https://robokop.renci.org/api/simple/expand/gene/HGNC:644/chemical_substance/
API 2.38: https://robokop.renci.org/api/simple/expand/gene/HGNC:14908/chemical_substance/
API 2.39: https://robokop.renci.org/api/simple/expand/gene/HGNC:5394/chemical_substance/
API 2.36: https://robokop.renci.org/api/simple/expand/gene/HGNC:5465/chemical_substance/
API 2.37: https://robokop.renci.org/api/simple/expand/gene/HGNC:15475/chemical_substance/
API 2.41: https://robokop.renci.org/api/simple/expand/gene/HGNC:11998/chemical_substance/
API 2.40: https://robokop.renci.org/api/simple/expand/gene/HGNC:9588/chemical_substance/


==== Step #3: Output normalization ====

API 3.1 dgidb_gene2chemical: No hits
API 3.2 dgidb_gene2chemical: 2 hits
API 3.3 dgidb_gene2chemical: No hits
API 3.4 dgidb_gene2chemical: No hits
API 3.5 dgidb_gene2chemical: No hits
API 3.6 dgidb_gene2chemical: 1 hits
API 3.7 dgidb_gene2chemical: 10 hits
API 3.8 dgidb_gene2chemical: 1 hits
API 3.9 dgidb_gene2chemical: No hits
API 3.10 dgidb_gene2chemical: No hits
API 3.11 dgidb_gene2chemical: 1 hits
API 3.12 dgidb_gene2chemical: No hits
API 3.13 dgidb_gene2chemical: No hits
API 3.14 dgidb_gene2chemical: No hits
API 3.15 dgidb_gene2chemical: No hits
API 3.16 dgidb_gene2chemical: No hits
API 3.17 dgidb_gene2chemical: No hits
API 3.18 dgidb_gene2chemical: No hits
API 3.19 dgidb_gene2chemical: No hits
API 3.20 dgidb_gene2chemical: 13 hits
API 3.21 dgidb_gene2chemical: 37 hits
API 3.22 dgidb_gene2chemical: 2 hits
API 3.23 dgidb_gene2chemical: 80 hits
API 3.24 dgidb_gene2chemical: 104 hits
API 3.25 dgidb_gene2chemical: No hits
API 3.26 dgidb_gene2chemical: No hits
API 3.27 dgidb_gene2chemical: No hits
API 3.28 dgidb_gene2chemical: 108 hits
API 3.29 dgidb_gene2chemical: 3 hits
API 3.30 dgidb_gene2chemical: 5 hits
API 3.31 dgidb_gene2chemical: No hits
API 3.32 dgidb_gene2chemical: No hits
API 3.33 dgidb_gene2chemical: No hits
API 3.34 dgidb_gene2chemical: 3 hits
API 3.35 dgidb_gene2chemical: No hits
API 3.36 dgidb_gene2chemical: No hits
API 3.37 dgidb_gene2chemical: No hits
API 3.38 dgidb_gene2chemical: No hits
API 3.39 dgidb_gene2chemical: No hits
API 3.40 dgidb_gene2chemical: No hits
API 3.41 dgidb_gene2chemical: No hits
API 3.42 dgidb_gene2chemical: No hits
API 3.43 dgidb_gene2chemical: No hits
API 4.1 mychem.info: No hits
API 4.2 mychem.info: 165 hits
API 4.3 mychem.info: 127 hits
API 5.1 opentarget: No hits
API 5.2 opentarget: 15 hits
API 5.3 opentarget: No hits
API 5.4 opentarget: No hits
API 5.5 opentarget: No hits
API 5.6 opentarget: No hits
API 5.7 opentarget: No hits
API 5.8 opentarget: No hits
API 5.9 opentarget: No hits
API 5.10 opentarget: No hits
API 5.11 opentarget: No hits
API 5.12 opentarget: No hits
API 5.13 opentarget: No hits
API 5.14 opentarget: No hits
API 5.15 opentarget: No hits
API 5.16 opentarget: No hits
API 5.17 opentarget: No hits
API 5.18 opentarget: No hits
API 5.19 opentarget: 12 hits
API 5.20 opentarget: No hits
API 5.21 opentarget: No hits
API 5.22 opentarget: No hits
API 5.23 opentarget: No hits
API 5.24 opentarget: No hits
API 5.25 opentarget: No hits
API 5.26 opentarget: No hits
API 5.27 opentarget: No hits
API 5.28 opentarget: 15 hits
API 5.29 opentarget: No hits
API 5.30 opentarget: No hits
API 5.31 opentarget: 15 hits
API 5.32 opentarget: No hits
API 5.33 opentarget: No hits
API 5.34 opentarget: No hits
API 5.35 opentarget: No hits
API 5.36 opentarget: No hits
API 5.37 opentarget: No hits
API 5.38 opentarget: No hits
API 5.39 opentarget: No hits
API 5.40 opentarget: No hits
API 5.41 opentarget: No hits
API 5.42 opentarget: No hits
API 5.43 opentarget: No hits
API 5.44 opentarget: No hits
API 5.45 opentarget: No hits
API 5.46 opentarget: No hits
API 5.47 opentarget: No hits
API 2.1 robokop_gene2chemical: No hits
API 2.2 robokop_gene2chemical: No hits
API 2.3 robokop_gene2chemical: No hits
API 2.4 robokop_gene2chemical: No hits
API 2.5 robokop_gene2chemical: No hits
API 2.6 robokop_gene2chemical: No hits
API 2.7 robokop_gene2chemical: No hits
API 2.8 robokop_gene2chemical: No hits
API 2.9 robokop_gene2chemical: No hits
API 2.10 robokop_gene2chemical: No hits
API 2.11 robokop_gene2chemical: No hits
API 2.12 robokop_gene2chemical: No hits
API 2.13 robokop_gene2chemical: No hits
API 2.14 robokop_gene2chemical: 7 hits
API 2.15 robokop_gene2chemical: No hits
API 2.16 robokop_gene2chemical: No hits
API 2.17 robokop_gene2chemical: No hits
API 2.18 robokop_gene2chemical: No hits
API 2.19 robokop_gene2chemical: No hits
API 2.20 robokop_gene2chemical: No hits
API 2.21 robokop_gene2chemical: No hits
API 2.22 robokop_gene2chemical: No hits
API 2.23 robokop_gene2chemical: No hits
API 2.24 robokop_gene2chemical: No hits
API 2.25 robokop_gene2chemical: No hits
API 2.26 robokop_gene2chemical: No hits
API 2.27 robokop_gene2chemical: No hits
API 2.28 robokop_gene2chemical: No hits
API 2.29 robokop_gene2chemical: No hits
API 2.30 robokop_gene2chemical: 13 hits
API 2.31 robokop_gene2chemical: No hits
API 2.32 robokop_gene2chemical: 1 hits
API 2.33 robokop_gene2chemical: No hits
API 2.34 robokop_gene2chemical: No hits
API 2.35 robokop_gene2chemical: No hits
API 2.36 robokop_gene2chemical: 6 hits
API 2.37 robokop_gene2chemical: No hits
API 2.38 robokop_gene2chemical: No hits
API 2.39 robokop_gene2chemical: 1 hits
API 2.40 robokop_gene2chemical: 19 hits
API 2.41 robokop_gene2chemical: 60 hits
API 2.42 robokop_gene2chemical: No hits
API 2.43 robokop_gene2chemical: No hits
API 1.1 semmedgene: 6890 hits

After id-to-object translation, BTE retrieved 3385 unique objects.


========== QUERY #2.6 -- fetch all ChemicalSubstance entities linked to SequenceVariant entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'SequenceVariant', BTE will query our meta-KG for APIs that can take 'SequenceVariant' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!


========== QUERY #2.7 -- fetch all ChemicalSubstance entities linked to GeneFamily entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'GeneFamily', BTE will query our meta-KG for APIs that can take 'GeneFamily' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!


========== QUERY #2.8 -- fetch all ChemicalSubstance entities linked to Transcript entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'Transcript', BTE will query our meta-KG for APIs that can take 'Transcript' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!


========== QUERY #2.9 -- fetch all ChemicalSubstance entities linked to Protein entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'Protein', BTE will query our meta-KG for APIs that can take 'Protein' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!


========== QUERY #2.10 -- fetch all ChemicalSubstance entities linked to ChemicalSubstance entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'ChemicalSubstance', BTE will query our meta-KG for APIs that can take 'ChemicalSubstance' as input and                   'ChemicalSubstance' as output

BTE found 1 apis:

API 1. semmedchemical(4 API calls)


==== Step #2: Query path execution ====
NOTE: API requests are dispatched in parallel, so the list of APIs below is ordered by query time.

API 1.2: https://pending.biothings.io/semmedchemical/query (POST "q=C0600493,C0002844&scopes=associated_with.chemical_substance.umls&fields=umls&species=human&size=100")
API 1.4: https://pending.biothings.io/semmedchemical/query (POST "q=C0600493,C0002844&scopes=umls&fields=affects.chemical_substance.umls,interacts_with.chemical_substance.umls,associated_with.chemical_substance.umls&species=human&size=100")
API 1.1: https://pending.biothings.io/semmedchemical/query (POST "q=C0600493,C0002844&scopes=affects.chemical_substance.umls&fields=umls&species=human&size=100")
API 1.3: https://pending.biothings.io/semmedchemical/query (POST "q=C0600493,C0002844&scopes=interacts_with.chemical_substance.umls&fields=umls&species=human&size=100")


==== Step #3: Output normalization ====

API 1.1 semmedchemical: No hits
API 1.2 semmedchemical: No hits
API 1.3 semmedchemical: 127 hits
API 1.4 semmedchemical: 343 hits

After id-to-object translation, BTE retrieved 398 unique objects.


========== QUERY #2.11 -- fetch all ChemicalSubstance entities linked to MolecularActivity entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'MolecularActivity', BTE will query our meta-KG for APIs that can take 'MolecularActivity' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!


========== QUERY #2.12 -- fetch all ChemicalSubstance entities linked to BiologicalProcess entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'BiologicalProcess', BTE will query our meta-KG for APIs that can take 'BiologicalProcess' as input and                   'ChemicalSubstance' as output

BTE found 1 apis:

API 1. semmedchemical(5 API calls)


==== Step #2: Query path execution ====
NOTE: API requests are dispatched in parallel, so the list of APIs below is ordered by query time.

API 1.1: https://pending.biothings.io/semmedchemical/query (POST "q=C0040649,C0376452,C0012899&scopes=affects.biological_process_or_activity.umls&fields=umls&species=human&size=100")
API 1.4: https://pending.biothings.io/semmedchemical/query (POST "q=C0040649,C0376452,C0012899&scopes=associated_with_reverse.biological_process_or_activity.umls&fields=umls&species=human&size=100")
API 1.3: https://pending.biothings.io/semmedchemical/query (POST "q=C0040649,C0376452,C0012899&scopes=associated_with.biological_process_or_activity.umls&fields=umls&species=human&size=100")
API 1.5: https://pending.biothings.io/semmedchemical/query (POST "q=C0040649,C0376452,C0012899&scopes=causes.biological_process_or_activity.umls&fields=umls&species=human&size=100")
API 1.2: https://pending.biothings.io/semmedchemical/query (POST "q=C0040649,C0376452,C0012899&scopes=affects_reverse.biological_process_or_activity.umls&fields=umls&species=human&size=100")


==== Step #3: Output normalization ====

API 1.1 semmedchemical: 300 hits
API 1.2 semmedchemical: 8 hits
API 1.3 semmedchemical: No hits
API 1.4 semmedchemical: No hits
API 1.5 semmedchemical: 1 hits

After id-to-object translation, BTE retrieved 267 unique objects.


========== QUERY #2.13 -- fetch all ChemicalSubstance entities linked to CellularComponent entites ==========
==========

==== Step #1: Query path planning ====

Because None is of type 'CellularComponent', BTE will query our meta-KG for APIs that can take 'CellularComponent' as input and                   'ChemicalSubstance' as output
We are sorry! We couln't find any APIs which can do the type of query for you!

==========
========== Final assembly of results ==========
==========


In the #1 query, BTE found 44 unique DiseaseOrPhenotypicFeature nodes
In the #1 query, BTE found 20 unique AnatomicalEntity nodes
In the #1 query, BTE found 2 unique PhenotypicFeature nodes
In the #1 query, BTE found 5 unique Pathway nodes
In the #1 query, BTE found 56 unique Gene nodes
In the #1 query, BTE found 100 unique SequenceVariant nodes
In the #1 query, BTE found 1 unique GeneFamily nodes
In the #1 query, BTE found 10 unique Transcript nodes
In the #1 query, BTE found 7 unique Protein nodes
In the #1 query, BTE found 2 unique ChemicalSubstance nodes
In the #1 query, BTE found 4 unique MolecularActivity nodes
In the #1 query, BTE found 7 unique BiologicalProcess nodes
In the #1 query, BTE found 3 unique CellularComponent nodes
In the #2 query, BTE found 12914 unique ChemicalSubstance nodes



In [9]:

    
df = fc.display_table_view()

No. 2 NELFINAVIR MESYLATE



In [12]:

    
df.loc[df['output_name'] == 'NELFINAVIR']









    Out[12]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      17813
      TMPRSS2
      Gene
      molecularlyInteractsWith
      biolink
      biolink_geneinteraction
      None
      Gene
      AR
      entrez:367
      targetedBy
      mychem.info
      mychem.info
      None
      ChemicalSubstance
      NELFINAVIR
      chembl:CHEMBL584
    
    
      17814
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmedgene
      semmedgene
      None
      Gene
      AR
      entrez:367
      targetedBy
      mychem.info
      mychem.info
      None
      ChemicalSubstance
      NELFINAVIR
      chembl:CHEMBL584
    
    
      17815
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      AR
      entrez:367
      targetedBy
      mychem.info
      mychem.info
      None
      ChemicalSubstance
      NELFINAVIR
      chembl:CHEMBL584
    
    
      17816
      TMPRSS2
      Gene
      molecularlyInteractsWith
      biolink
      biolink_geneinteraction
      None
      Gene
      AR
      entrez:367
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      NELFINAVIR
      chembl:CHEMBL584
    
    
      17817
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmedgene
      semmedgene
      None
      Gene
      AR
      entrez:367
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      NELFINAVIR
      chembl:CHEMBL584
    
    
      17818
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      AR
      entrez:367
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      NELFINAVIR
      chembl:CHEMBL584

No. 4 hanfangchin A



In [13]:

    
df.loc[df['output_name'] == 'C0076316']









    Out[13]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      7946
      TMPRSS2
      Gene
      associatedWith
      semmed
      semmedgene
      None
      BiologicalProcess
      DNA Repair
      umls:C0012899
      associatedWith
      semmedchemical
      semmedchemical
      None
      ChemicalSubstance
      C0076316
      umls:C0076316

No. 13 astemizole



In [14]:

    
df.loc[df['output_name'] == 'ASTEMIZOLE']









    Out[14]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      2155
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      C0017337
      umls:C0017337
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      ASTEMIZOLE
      chembl:CHEMBL296419

No. 14 amodiaquine



In [16]:

    
df.loc[df['output_name'] == 'AMODIAQUINE']









    Out[16]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      56719
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      disease
      mondo:MONDO:0000001
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      AMODIAQUINE
      chembl:CHEMBL682
    
    
      56720
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      cancer
      mondo:MONDO:0004992
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      AMODIAQUINE
      chembl:CHEMBL682

No. 22 mefloquine



In [19]:

    
df.loc[df['output_name'] == '(S,R)-MEFLOQUINE']









    Out[19]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      53830
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      C0017337
      umls:C0017337
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      (S,R)-MEFLOQUINE
      chembl:CHEMBL172

No. 27 CEPHARANTHINE



In [20]:

    
df.loc[df['output_name'] == 'C0055082']









    Out[20]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      2494
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0596263
      umls:C0596263
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2496
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0029925
      umls:C0029925
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2497
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0027651
      umls:C0027651
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2498
      TMPRSS2
      Gene
      causes
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0027651
      umls:C0027651
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2499
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0027651
      umls:C0027651
      associatedWith
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2500
      TMPRSS2
      Gene
      causes
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0027651
      umls:C0027651
      associatedWith
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2503
      TMPRSS2
      Gene
      associatedWith
      DISEASES
      DISEASES
      None
      DiseaseOrPhenotypicFeature
      breast cancer
      mondo:MONDO:0007254
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2504
      TMPRSS2
      Gene
      associatedWith
      DISEASES
      DISEASES
      None
      DiseaseOrPhenotypicFeature
      urinary bladder cancer
      mondo:MONDO:0001187
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2505
      TMPRSS2
      Gene
      associatedWith
      DISEASES
      DISEASES
      None
      DiseaseOrPhenotypicFeature
      lung cancer
      mondo:MONDO:0008903
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2506
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      disease
      mondo:MONDO:0000001
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082
    
    
      2507
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      cancer
      mondo:MONDO:0004992
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0055082
      umls:C0055082

No. 33 ANDROGRAPHOLIDE



In [21]:

    
df.loc[df['output_name'] == 'C0051821']









    Out[21]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      12301
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      C0017337
      umls:C0017337
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      C0051821
      umls:C0051821
    
    
      12302
      TMPRSS2
      Gene
      decreasesActivityOf
      semmed
      semmedgene
      None
      Gene
      C1705526
      umls:C1705526
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      C0051821
      umls:C0051821
    
    
      12303
      TMPRSS2
      Gene
      molecularlyInteractsWith
      biolink
      biolink_geneinteraction
      None
      Gene
      AR
      entrez:367
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      C0051821
      umls:C0051821
    
    
      12304
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmedgene
      semmedgene
      None
      Gene
      AR
      entrez:367
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      C0051821
      umls:C0051821
    
    
      12305
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      AR
      entrez:367
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      C0051821
      umls:C0051821

No. 39 NAFOXIDINE



In [22]:

    
df.loc[df['output_name'] == 'C0027328']









    Out[22]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      32643
      TMPRSS2
      Gene
      associatedWith
      DISEASES
      DISEASES
      None
      DiseaseOrPhenotypicFeature
      breast cancer
      mondo:MONDO:0007254
      associatedWith
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0027328
      umls:C0027328
    
    
      32644
      TMPRSS2
      Gene
      associatedWith
      DISEASES
      DISEASES
      None
      DiseaseOrPhenotypicFeature
      breast cancer
      mondo:MONDO:0007254
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0027328
      umls:C0027328

No. 46 CDRI 85287



In [23]:

    
df.loc[df['output_name'] == 'C0168602']









    Out[23]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      32883
      TMPRSS2
      Gene
      associatedWith
      DISEASES
      DISEASES
      None
      DiseaseOrPhenotypicFeature
      breast cancer
      mondo:MONDO:0007254
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0168602
      umls:C0168602

No. 48 RETINALDEHYDE



In [24]:

    
df.loc[df['output_name'] == 'C0035331']









    Out[24]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      885
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      C0002844
      umls:C0002844
      molecularlyInteractsWith
      semmed
      semmedchemical
      None
      ChemicalSubstance
      C0035331
      umls:C0035331

No. 59 CLOFAZIMINE



In [25]:

    
df.loc[df['output_name'] == 'CLOFAZIMINE']









    Out[25]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      56752
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      disease
      mondo:MONDO:0000001
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      CLOFAZIMINE
      chembl:CHEMBL1292
    
    
      56754
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      cancer
      mondo:MONDO:0004992
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      CLOFAZIMINE
      chembl:CHEMBL1292

No. 63 PERHEXILINE



In [26]:

    
df.loc[df['output_name'] == 'PERHEXILINE']









    Out[26]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id

No. 64 resiniferatoxin



In [28]:

    
df.loc[df['output_name'] == 'C0073081']









    Out[28]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      5866
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0242656
      umls:C0242656
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5867
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0699748
      umls:C0699748
      associatedWith
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5868
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0027651
      umls:C0027651
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5869
      TMPRSS2
      Gene
      causes
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0027651
      umls:C0027651
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5870
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0007097
      umls:C0007097
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5871
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0005001
      umls:C0005001
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5872
      TMPRSS2
      Gene
      causes
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      C0028778
      umls:C0028778
      associatedWith
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5873
      TMPRSS2
      Gene
      associatedWith
      DISEASES
      DISEASES
      None
      DiseaseOrPhenotypicFeature
      lung cancer
      mondo:MONDO:0008903
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5874
      TMPRSS2
      Gene
      associatedWith
      DISEASES
      DISEASES
      None
      DiseaseOrPhenotypicFeature
      lymphoma
      mondo:MONDO:0005062
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5875
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      disease
      mondo:MONDO:0000001
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081
    
    
      5876
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      cancer
      mondo:MONDO:0004992
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0073081
      umls:C0073081

No. 65 TEPOTINIB



In [29]:

    
df.loc[df['output_name'] == 'TEPOTINIB']









    Out[29]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      59374
      TMPRSS2
      Gene
      decreasesActivityOf
      semmed
      semmedgene
      None
      Gene
      TP53
      entrez:7157
      targetedBy
      dgidb
      dgidb_gene2chemical
      None
      ChemicalSubstance
      TEPOTINIB
      chembl:CHEMBL3402762

No. 69 EBASTINE



In [30]:

    
df.loc[df['output_name'] == 'EBASTINE']









    Out[30]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      56884
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      C0017337
      umls:C0017337
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      EBASTINE
      chembl:CHEMBL305660

No. 73 5-Azacytidine



In [31]:

    
df.loc[df['output_name'] == 'AZACITIDINE']









    Out[31]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      4928
      TMPRSS2
      Gene
      associatedWith
      semmed
      semmedgene
      None
      BiologicalProcess
      DNA Methylation
      umls:C0376452
      associatedWith
      semmedchemical
      semmedchemical
      None
      ChemicalSubstance
      AZACITIDINE
      chembl:CHEMBL1489

No. 76 AMIODARONE



In [32]:

    
df.loc[df['output_name'] == 'AMIODARONE']









    Out[32]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      9201
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      C0017337
      umls:C0017337
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      AMIODARONE
      chembl:CHEMBL633
    
    
      9203
      TMPRSS2
      Gene
      molecularlyInteractsWith
      biolink
      biolink_geneinteraction
      None
      Gene
      AR
      entrez:367
      targetedBy
      mychem.info
      mychem.info
      None
      ChemicalSubstance
      AMIODARONE
      chembl:CHEMBL633
    
    
      9204
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmedgene
      semmedgene
      None
      Gene
      AR
      entrez:367
      targetedBy
      mychem.info
      mychem.info
      None
      ChemicalSubstance
      AMIODARONE
      chembl:CHEMBL633
    
    
      9205
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      Gene
      AR
      entrez:367
      targetedBy
      mychem.info
      mychem.info
      None
      ChemicalSubstance
      AMIODARONE
      chembl:CHEMBL633

No. 79 NSP 805



In [34]:

    
df.loc[df['output_name'] == 'C0660146']









    Out[34]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id

No. 81 CLORICROMENE



In [35]:

    
df.loc[df['output_name'] == 'C0050066']









    Out[35]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      55206
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      disease
      mondo:MONDO:0000001
      treatedBy
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0050066
      umls:C0050066
    
    
      55207
      TMPRSS2
      Gene
      associatedWith
      semmeddisease
      semmeddisease
      None
      DiseaseOrPhenotypicFeature
      disease
      mondo:MONDO:0000001
      associatedWith
      semmed
      semmeddisease
      None
      ChemicalSubstance
      C0050066
      umls:C0050066

No. 82 TIFLUADOM



In [36]:

    
df.loc[df['output_name'] == 'C0076670']









    Out[36]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id

No. 85 SCH-28080



In [37]:

    
df.loc[df['output_name'] == 'C0074142']









    Out[37]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id

NO. 96 IMMUNOMYCIN



In [38]:

    
df.loc[df['output_name'] == 'C0123418']









    Out[38]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id

NO.97 ARGLABIN



In [39]:

    
df.loc[df['output_name'] == 'C0661380']









    Out[39]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id

NO.100 TRETINOIN



In [40]:

    
df.loc[df['output_name'] == 'TRETINOIN']









    Out[40]:







  
    
      
      input
      input_type
      pred1
      pred1_source
      pred1_api
      pred1_pubmed
      node1_type
      node1_name
      node1_id
      pred2
      pred2_source
      pred2_api
      pred2_pubmed
      output_type
      output_name
      output_id
    
  
  
    
      2093
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      C0002844
      umls:C0002844
      molecularlyInteractsWith
      semmed
      semmedchemical
      None
      ChemicalSubstance
      TRETINOIN
      chembl:CHEMBL38
    
    
      2094
      TMPRSS2
      Gene
      molecularlyInteractsWith
      semmed
      semmedgene
      None
      ChemicalSubstance
      C0600493
      umls:C0600493
      molecularlyInteractsWith
      semmed
      semmedchemical
      None
      ChemicalSubstance
      TRETINOIN
      chembl:CHEMBL38

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
17813	TMPRSS2	Gene	molecularlyInteractsWith	biolink	biolink_geneinteraction	None	Gene	AR	entrez:367	targetedBy	mychem.info	mychem.info	None	ChemicalSubstance	NELFINAVIR	chembl:CHEMBL584
17814	TMPRSS2	Gene	molecularlyInteractsWith	semmedgene	semmedgene	None	Gene	AR	entrez:367	targetedBy	mychem.info	mychem.info	None	ChemicalSubstance	NELFINAVIR	chembl:CHEMBL584
17815	TMPRSS2	Gene	molecularlyInteractsWith	semmed	semmedgene	None	Gene	AR	entrez:367	targetedBy	mychem.info	mychem.info	None	ChemicalSubstance	NELFINAVIR	chembl:CHEMBL584
17816	TMPRSS2	Gene	molecularlyInteractsWith	biolink	biolink_geneinteraction	None	Gene	AR	entrez:367	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	NELFINAVIR	chembl:CHEMBL584
17817	TMPRSS2	Gene	molecularlyInteractsWith	semmedgene	semmedgene	None	Gene	AR	entrez:367	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	NELFINAVIR	chembl:CHEMBL584
17818	TMPRSS2	Gene	molecularlyInteractsWith	semmed	semmedgene	None	Gene	AR	entrez:367	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	NELFINAVIR	chembl:CHEMBL584

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
56719	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	disease	mondo:MONDO:0000001	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	AMODIAQUINE	chembl:CHEMBL682
56720	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	cancer	mondo:MONDO:0004992	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	AMODIAQUINE	chembl:CHEMBL682

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
2494	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0596263	umls:C0596263	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2496	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0029925	umls:C0029925	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2497	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0027651	umls:C0027651	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2498	TMPRSS2	Gene	causes	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0027651	umls:C0027651	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2499	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0027651	umls:C0027651	associatedWith	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2500	TMPRSS2	Gene	causes	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0027651	umls:C0027651	associatedWith	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2503	TMPRSS2	Gene	associatedWith	DISEASES	DISEASES	None	DiseaseOrPhenotypicFeature	breast cancer	mondo:MONDO:0007254	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2504	TMPRSS2	Gene	associatedWith	DISEASES	DISEASES	None	DiseaseOrPhenotypicFeature	urinary bladder cancer	mondo:MONDO:0001187	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2505	TMPRSS2	Gene	associatedWith	DISEASES	DISEASES	None	DiseaseOrPhenotypicFeature	lung cancer	mondo:MONDO:0008903	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2506	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	disease	mondo:MONDO:0000001	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082
2507	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	cancer	mondo:MONDO:0004992	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0055082	umls:C0055082

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
12301	TMPRSS2	Gene	molecularlyInteractsWith	semmed	semmedgene	None	Gene	C0017337	umls:C0017337	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	C0051821	umls:C0051821
12302	TMPRSS2	Gene	decreasesActivityOf	semmed	semmedgene	None	Gene	C1705526	umls:C1705526	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	C0051821	umls:C0051821
12303	TMPRSS2	Gene	molecularlyInteractsWith	biolink	biolink_geneinteraction	None	Gene	AR	entrez:367	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	C0051821	umls:C0051821
12304	TMPRSS2	Gene	molecularlyInteractsWith	semmedgene	semmedgene	None	Gene	AR	entrez:367	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	C0051821	umls:C0051821
12305	TMPRSS2	Gene	molecularlyInteractsWith	semmed	semmedgene	None	Gene	AR	entrez:367	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	C0051821	umls:C0051821

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
32643	TMPRSS2	Gene	associatedWith	DISEASES	DISEASES	None	DiseaseOrPhenotypicFeature	breast cancer	mondo:MONDO:0007254	associatedWith	semmed	semmeddisease	None	ChemicalSubstance	C0027328	umls:C0027328
32644	TMPRSS2	Gene	associatedWith	DISEASES	DISEASES	None	DiseaseOrPhenotypicFeature	breast cancer	mondo:MONDO:0007254	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0027328	umls:C0027328

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
56752	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	disease	mondo:MONDO:0000001	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	CLOFAZIMINE	chembl:CHEMBL1292
56754	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	cancer	mondo:MONDO:0004992	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	CLOFAZIMINE	chembl:CHEMBL1292

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
5866	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0242656	umls:C0242656	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5867	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0699748	umls:C0699748	associatedWith	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5868	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0027651	umls:C0027651	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5869	TMPRSS2	Gene	causes	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0027651	umls:C0027651	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5870	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0007097	umls:C0007097	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5871	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0005001	umls:C0005001	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5872	TMPRSS2	Gene	causes	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	C0028778	umls:C0028778	associatedWith	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5873	TMPRSS2	Gene	associatedWith	DISEASES	DISEASES	None	DiseaseOrPhenotypicFeature	lung cancer	mondo:MONDO:0008903	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5874	TMPRSS2	Gene	associatedWith	DISEASES	DISEASES	None	DiseaseOrPhenotypicFeature	lymphoma	mondo:MONDO:0005062	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5875	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	disease	mondo:MONDO:0000001	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081
5876	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	cancer	mondo:MONDO:0004992	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0073081	umls:C0073081

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
9201	TMPRSS2	Gene	molecularlyInteractsWith	semmed	semmedgene	None	Gene	C0017337	umls:C0017337	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	AMIODARONE	chembl:CHEMBL633
9203	TMPRSS2	Gene	molecularlyInteractsWith	biolink	biolink_geneinteraction	None	Gene	AR	entrez:367	targetedBy	mychem.info	mychem.info	None	ChemicalSubstance	AMIODARONE	chembl:CHEMBL633
9204	TMPRSS2	Gene	molecularlyInteractsWith	semmedgene	semmedgene	None	Gene	AR	entrez:367	targetedBy	mychem.info	mychem.info	None	ChemicalSubstance	AMIODARONE	chembl:CHEMBL633
9205	TMPRSS2	Gene	molecularlyInteractsWith	semmed	semmedgene	None	Gene	AR	entrez:367	targetedBy	mychem.info	mychem.info	None	ChemicalSubstance	AMIODARONE	chembl:CHEMBL633

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
55206	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	disease	mondo:MONDO:0000001	treatedBy	semmed	semmeddisease	None	ChemicalSubstance	C0050066	umls:C0050066
55207	TMPRSS2	Gene	associatedWith	semmeddisease	semmeddisease	None	DiseaseOrPhenotypicFeature	disease	mondo:MONDO:0000001	associatedWith	semmed	semmeddisease	None	ChemicalSubstance	C0050066	umls:C0050066

	input	input_type	pred1	pred1_source	pred1_api	pred1_pubmed	node1_type	node1_name	node1_id	pred2	pred2_source	pred2_api	pred2_pubmed	output_type	output_name	output_id
2093	TMPRSS2	Gene	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	C0002844	umls:C0002844	molecularlyInteractsWith	semmed	semmedchemical	None	ChemicalSubstance	TRETINOIN	chembl:CHEMBL38
2094	TMPRSS2	Gene	molecularlyInteractsWith	semmed	semmedgene	None	ChemicalSubstance	C0600493	umls:C0600493	molecularlyInteractsWith	semmed	semmedchemical	None	ChemicalSubstance	TRETINOIN	chembl:CHEMBL38