home / zeropm-v0-0-4

api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

42 rows where query_id = 161699

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
95507 95507 161699 161699 PubChem (compound) 1 22667 22667 1
180983 180983 161699 161699 PubChem (compound) 1 192014 192014 2
180985 180985 161699 161699 PubChem (compound) 1 224753 224753 3
180987 180987 161699 161699 PubChem (compound) 1 169158 169158 4
180989 180989 161699 161699 PubChem (compound) 1 189089 189089 5
180992 180992 161699 161699 PubChem (compound) 1 216837 216837 6
180993 180993 161699 161699 PubChem (compound) 1 237605 237605 7
180995 180995 161699 161699 PubChem (compound) 1 240426 240426 8
180997 180997 161699 161699 PubChem (compound) 1 265815 265815 9
180999 180999 161699 161699 PubChem (compound) 1 270109 270109 10
181001 181001 161699 161699 PubChem (compound) 1 309835 309835 11
181004 181004 161699 161699 PubChem (compound) 1 334355 334355 12
181006 181006 161699 161699 PubChem (compound) 1 334567 334567 13
430575 430575 161699 161699 PubChem (substance) 2 22667 22667 1
438308 438308 161699 161699 PubChem (substance) 2 18897 18897 4
546015 546015 161699 161699 PubChem (substance) 2 192014 192014 2
546019 546019 161699 161699 PubChem (substance) 2 224753 224753 3
546027 546027 161699 161699 PubChem (substance) 2 169158 169158 7
546032 546032 161699 161699 PubChem (substance) 2 189089 189089 5
546034 546034 161699 161699 PubChem (substance) 2 216837 216837 18
546036 546036 161699 161699 PubChem (substance) 2 237605 237605 12
546041 546041 161699 161699 PubChem (substance) 2 240426 240426 21
546044 546044 161699 161699 PubChem (substance) 2 265815 265815 19
546047 546047 161699 161699 PubChem (substance) 2 270109 270109 22
546050 546050 161699 161699 PubChem (substance) 2 309835 309835 20
546053 546053 161699 161699 PubChem (substance) 2 334355 334355 25
546055 546055 161699 161699 PubChem (substance) 2 334567 334567 26
720723 720723 161699 161699 PubChem (substance) 2 142097 142097 11
746682 746682 161699 161699 PubChem (substance) 2 169158 169158 9
746687 746687 161699 161699 PubChem (substance) 2 242999 242999 13
746688 746688 161699 161699 PubChem (substance) 2 240555 240555 8
746693 746693 161699 161699 PubChem (substance) 2 320456 320456 14
746696 746696 161699 161699 PubChem (substance) 2 262587 262587 15
746699 746699 161699 161699 PubChem (substance) 2 22667 22667 27
751020 751020 161699 161699 PubChem (substance) 2 139287 139287 6
811122 811122 161699 161699 PubChem (substance) 2 195253 195253 16
812943 812943 161699 161699 PubChem (substance) 2 231931 231931 10
812945 812945 161699 161699 PubChem (substance) 2 284059 284059 17
812947 812947 161699 161699 PubChem (substance) 2 321733 321733 23
812949 812949 161699 161699 PubChem (substance) 2 168535 168535 24
1008893 1008893 161699 161699 CAS Common Chemistry 3 22667 22667 1
1210914 1210914 161699 161699 Computational Toxicology and Exposure Data 4 22667 22667 1
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 818.958ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website