Created
June 29, 2017 10:33
-
-
Save joshmoore/97120daee8abb2080ab8d80a38e86825 to your computer and use it in GitHub Desktop.
Compound query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import omero | |
| compounds = unwrap(q.projection(("select distinct mv1.value, mv2.value from Image i " | |
| "join i.annotationLinks l1 join l1.child as a1 join a1.mapValue as mv1 " | |
| "join i.annotationLinks l2 join l2.child as a2 join a2.mapValue as mv2 " | |
| "join i.wellSamples ws join ws.well w join w.plate p " | |
| "where p.id = 4403 and mv1.name = 'Product Use Annotation' and mv2.name = 'Compound Name'"), None)) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Nalidixic acid sodium salt hydrate | UseClass:8104 (anti-bacterial) | |
|---|---|---|
| WY-14643 | UseClass:8089 (cardiovascular agent) | |
| N-LINOLEOYLGLYCINE | UseClass:8071 (anti-inflammatory) | |
| Amitryptiline hydrochloride | UseClass:8119 (anti-depressant) | |
| Tolazoline hydrochloride | UseClass:8092 (vasodilator) | |
| Mycophenolic acid | UseClass:8071 (anti-inflammatory);UseClass:8066 (anti-neoplastic);UseClass:8108 (anti-protozoal);UseClass:8076 (anti-psoriatic);UseClass:8070 (immunosuppressive agent) | |
| Nalbuphine hydrochloride | UseClass:8081 (analgesic) | |
| Astemizole | UseClass:8072 (anti-histamine) | |
| Berberine chloride | UseClass:8090 (anti-arrhythmic) | |
| Amoxapine | UseClass:8119 (anti-depressant);UseClass:8072 (anti-histamine) | |
| Tamoxifen citrate | UseClass:8144 (hormone antagonist) | |
| Ciprofloxacin hydrochloride | UseClass:8104 (anti-bacterial);UseClass:8111 (antiseptic) | |
| DL-PDMP | UseClass:8066 (anti-neoplastic);UseClass:8065 (anti-proliferative) | |
| FLUNARIZINE | UseClass:8114 (neuroprotective agent);UseClass:8092 (vasodilator) | |
| MEAD ACID (20:3 n-9) | UseClass:8071 (anti-inflammatory);UseClass:8073 (immunomodulator) | |
| Eburnamonine (-) | UseClass:8092 (vasodilator) | |
| Carbamazepine | UseClass:8121 (anti-convulsant) | |
| Pirenzepine dihydrochloride | UseClass:8125 (gastrointestinal agent) | |
| Mefloquine hydrochloride | UseClass:8110 (anti-malarial) | |
| Khellin | UseClass:8100 (cardiac stimulant);UseClass:8132 (muscle relaxant (spasmolytic)) | |
| Hesperetin | UseClass:8066 (anti-neoplastic);UseClass:8132 (muscle relaxant (spasmolytic)) | |
| LIDOCAINE | UseClass:8082 (anesthetic);UseClass:8090 (anti-arrhythmic) | |
| Papaverine hydrochloride | UseClass:8095 (anti-anginal);UseClass:8078 (anti-asthmatic);UseClass:8106 (anti-viral);UseClass:8133 (smooth muscle relaxant);UseClass:8092 (vasodilator) | |
| Terfenadine | UseClass:8072 (anti-histamine);UseClass:8088 (bronchodilator) | |
| GAMMA-LINOLENIC ACID (18:3 n-6) | UseClass:8066 (anti-neoplastic) | |
| BAY K-8644 | UseClass:8094 (vasoconstrictor) | |
| Cotinine (-) | UseClass:8119 (anti-depressant) | |
| Galanthamine hydrobromide | UseClass:8081 (analgesic) | |
| Harmalol hydrochloride dihydrate | UseClass:8113 (cns agent) | |
| CYCLOTHIAZIDE | UseClass:8091 (anti-hypertensive);UseClass:8153 (diuretic) | |
| Chlorpheniramine maleate | UseClass:8072 (anti-histamine) | |
| bumetanide | UseClass:8153 (diuretic) | |
| Phenacetin | UseClass:8075 (anti-pyretic) | |
| Azathioprine | UseClass:8070 (immunosuppressive agent) | |
| Todralazine hydrochloride | UseClass:8091 (anti-hypertensive) | |
| Trimethobenzamide hydrochloride | UseClass:8127 (anti-emetic) | |
| PROSTAGLANDIN A2 | UseClass:8066 (anti-neoplastic) | |
| Ticlopidine hydrochloride | UseClass:8089 (cardiovascular agent) | |
| Minaprine dihydrochloride | UseClass:8114 (neuroprotective agent);UseClass:8120 (psychotropic agent) | |
| 6-Furfurylaminopurine | UseClass:8147 (auxin) | |
| Riluzole hydrochloride | UseClass:8082 (anesthetic);UseClass:8123 (anti-anxiety);UseClass:8121 (anti-convulsant);UseClass:8099 (anti-ischemic);UseClass:8115 (hypnotic);UseClass:8120 (psychotropic agent) | |
| OXYMETAZOLINE | UseClass:8084 (decongestant);UseClass:8094 (vasoconstrictor) | |
| Naloxone hydrochloride | UseClass:8155 (antidote) | |
| Nomifensine maleate | UseClass:8119 (anti-depressant) | |
| FLECAINIDE | UseClass:8090 (anti-arrhythmic) | |
| GLYBURIDE | UseClass:8094 (vasoconstrictor) | |
| Paclitaxel | UseClass:8066 (anti-neoplastic) | |
| Pargyline hydrochloride | UseClass:8119 (anti-depressant) | |
| Mefenamic acid | UseClass:8071 (anti-inflammatory) | |
| clonidine | UseClass:8091 (anti-hypertensive) | |
| Verapamyl hydrochloride | UseClass:8090 (anti-arrhythmic);UseClass:8091 (anti-hypertensive);UseClass:8092 (vasodilator) | |
| BAY 11-7082 | UseClass:8071 (anti-inflammatory) | |
| FLUFENAMIC ACID | UseClass:8081 (analgesic);UseClass:8071 (anti-inflammatory);UseClass:8065 (anti-proliferative) | |
| Tolnaftate | UseClass:8105 (anti-fungal) | |
| Cyclizine hydrochloride | UseClass:8081 (analgesic);UseClass:8072 (anti-histamine) | |
| Mepenzolate bromide | UseClass:8113 (cns agent) | |
| Mianserine hydrochloride | UseClass:8119 (anti-depressant);UseClass:8072 (anti-histamine) | |
| Chlorzoxazone | UseClass:8132 (muscle relaxant (spasmolytic)) | |
| Flutamide | UseClass:8144 (hormone antagonist) | |
| Tiabendazole | UseClass:8105 (anti-fungal);UseClass:8109 (anti-helminthic);UseClass:8065 (anti-proliferative);UseClass:8108 (anti-protozoal) | |
| Diclofenac sodium | UseClass:8071 (anti-inflammatory) | |
| Cloxacillin sodium salt | UseClass:8104 (anti-bacterial) | |
| Methocarbamol | UseClass:8132 (muscle relaxant (spasmolytic)) | |
| Diphenhydramine hydrochloride | UseClass:8072 (anti-histamine) | |
| Monocrotaline | UseClass:8066 (anti-neoplastic) | |
| IBMX | UseClass:8092 (vasodilator) | |
| Ethosuximide | UseClass:8121 (anti-convulsant) | |
| Alverine citrate salt | UseClass:8132 (muscle relaxant (spasmolytic)) | |
| Betahistine mesylate | UseClass:8092 (vasodilator) | |
| Iproniazide phosphate | UseClass:8119 (anti-depressant) | |
| Sulfamethoxazole | UseClass:8104 (anti-bacterial) | |
| Tenoxicam | UseClass:8081 (analgesic);UseClass:8071 (anti-inflammatory) | |
| NICARDIPINE | UseClass:8092 (vasodilator) | |
| Tetracaine hydrochloride | UseClass:8082 (anesthetic) | |
| TROPISETRON | UseClass:8125 (gastrointestinal agent) | |
| Sulindac | UseClass:8081 (analgesic);UseClass:8071 (anti-inflammatory);UseClass:8075 (anti-pyretic) | |
| Suxibuzone | UseClass:8081 (analgesic);UseClass:8071 (anti-inflammatory);UseClass:8075 (anti-pyretic) | |
| PROSTAGLANDIN A1 | UseClass:8066 (anti-neoplastic) | |
| zaprinast | UseClass:8077 (anti-allergy);UseClass:8078 (anti-asthmatic) | |
| Pheniramine maleate | UseClass:8072 (anti-histamine) | |
| NIFLUMIC ACID | UseClass:8081 (analgesic);UseClass:8071 (anti-inflammatory) | |
| Ebselen | UseClass:8071 (anti-inflammatory);UseClass:8137 (anti-oxidant) | |
| Metolazone | UseClass:8153 (diuretic) | |
| Xylazine | UseClass:8081 (analgesic);UseClass:8132 (muscle relaxant (spasmolytic));UseClass:8116 (sedative) | |
| DIAZOXIDE | UseClass:8092 (vasodilator) | |
| LY-83583 | UseClass:8073 (immunomodulator) | |
| BUSPIRONE | UseClass:8123 (anti-anxiety);UseClass:8118 (anti-psychotic (neuroleptic));UseClass:8117 (tranquilizer) | |
| Lidocaine hydrochloride | UseClass:8082 (anesthetic);UseClass:8090 (anti-arrhythmic) | |
| Etofylline | UseClass:8155 (antidote) | |
| Quercetine dihydrate | UseClass:8071 (anti-inflammatory);UseClass:8066 (anti-neoplastic);UseClass:8138 (flavonoid);UseClass:8136 (vitamin) | |
| Oxethazaine | UseClass:8082 (anesthetic) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment