home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 71719

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
107748 107748 71719 71719 PubChem (compound) 1 77102 77102 1
447967 447967 71719 71719 PubChem (substance) 2 77102 77102 1
553828 553828 71719 71719 PubChem (substance) 2 30334 30334 22
757450 757450 71719 71719 PubChem (substance) 2 184702 184702 2
757451 757451 71719 71719 PubChem (substance) 2 192025 192025 3
757453 757453 71719 71719 PubChem (substance) 2 211247 211247 4
757455 757455 71719 71719 PubChem (substance) 2 140410 140410 5
757457 757457 71719 71719 PubChem (substance) 2 206756 206756 6
757458 757458 71719 71719 PubChem (substance) 2 199655 199655 7
757459 757459 71719 71719 PubChem (substance) 2 168134 168134 8
757460 757460 71719 71719 PubChem (substance) 2 176501 176501 9
757461 757461 71719 71719 PubChem (substance) 2 206757 206757 10
757462 757462 71719 71719 PubChem (substance) 2 206758 206758 11
757463 757463 71719 71719 PubChem (substance) 2 206759 206759 12
757464 757464 71719 71719 PubChem (substance) 2 195173 195173 13
757465 757465 71719 71719 PubChem (substance) 2 204582 204582 14
757466 757466 71719 71719 PubChem (substance) 2 195471 195471 15
757467 757467 71719 71719 PubChem (substance) 2 176205 176205 16
757468 757468 71719 71719 PubChem (substance) 2 320449 320449 17
757470 757470 71719 71719 PubChem (substance) 2 278077 278077 18
757471 757471 71719 71719 PubChem (substance) 2 196690 196690 19
757473 757473 71719 71719 PubChem (substance) 2 309963 309963 20
757475 757475 71719 71719 PubChem (substance) 2 291628 291628 21
1017177 1017177 71719 71719 CAS Common Chemistry 3 77102 77102 1
1219450 1219450 71719 71719 Computational Toxicology and Exposure Data 4 77102 77102 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 1494.309ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website