home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 111615

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
107133 107133 111615 111615 PubChem (compound) 1 122307 122307 2
107145 107145 111615 111615 PubChem (compound) 1 37202 37202 1
447178 447178 111615 111615 PubChem (substance) 2 122307 122307 2
447189 447189 111615 111615 PubChem (substance) 2 16902 16902 11
447203 447203 111615 111615 PubChem (substance) 2 37202 37202 1
447218 447218 111615 111615 PubChem (substance) 2 122307 122307 12
479720 479720 111615 111615 PubChem (substance) 2 136723 136723 4
479722 479722 111615 111615 PubChem (substance) 2 189188 189188 3
479724 479724 111615 111615 PubChem (substance) 2 327236 327236 5
757078 757078 111615 111615 PubChem (substance) 2 217811 217811 15
757086 757086 111615 111615 PubChem (substance) 2 229300 229300 6
757096 757096 111615 111615 PubChem (substance) 2 289326 289326 13
757099 757099 111615 111615 PubChem (substance) 2 182550 182550 7
757105 757105 111615 111615 PubChem (substance) 2 195525 195525 10
757111 757111 111615 111615 PubChem (substance) 2 292545 292545 8
757116 757116 111615 111615 PubChem (substance) 2 309903 309903 14
757125 757125 111615 111615 PubChem (substance) 2 122276 122276 9
778139 778139 111615 111615 PubChem (substance) 2 259483 259483 17
778142 778142 111615 111615 PubChem (substance) 2 326451 326451 16
1032972 1032972 111615 111615 CAS Common Chemistry 3 37202 37202 1
1235902 1235902 111615 111615 Computational Toxicology and Exposure Data 4 37202 37202 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 824.305ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website