home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 99

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
218 218 99 99 PubChem (compound) 1 74053 74053 1
295787 295787 99 99 PubChem (substance) 2 74053 74053 1
411894 411894 99 99 PubChem (substance) 2 65005 65005 16
422683 422683 99 99 PubChem (substance) 2 88275 88275 20
498036 498036 99 99 PubChem (substance) 2 15740 15740 6
517230 517230 99 99 PubChem (substance) 2 52262 52262 13
587556 587556 99 99 PubChem (substance) 2 66167 66167 17
589278 589278 99 99 PubChem (substance) 2 67204 67204 18
600669 600669 99 99 PubChem (substance) 2 80608 80608 19
692101 692101 99 99 PubChem (substance) 2 203379 203379 2
692106 692106 99 99 PubChem (substance) 2 208110 208110 3
692109 692109 99 99 PubChem (substance) 2 208033 208033 4
692113 692113 99 99 PubChem (substance) 2 149161 149161 5
692115 692115 99 99 PubChem (substance) 2 244357 244357 7
692118 692118 99 99 PubChem (substance) 2 187958 187958 8
692121 692121 99 99 PubChem (substance) 2 215453 215453 9
692124 692124 99 99 PubChem (substance) 2 210249 210249 10
692127 692127 99 99 PubChem (substance) 2 272877 272877 11
692130 692130 99 99 PubChem (substance) 2 187800 187800 12
692133 692133 99 99 PubChem (substance) 2 192227 192227 14
692136 692136 99 99 PubChem (substance) 2 211245 211245 15
938300 938300 99 99 CAS Common Chemistry 3 74053 74053 1
1134937 1134937 99 99 Computational Toxicology and Exposure Data 4 74053 74053 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 492.74ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website