home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 67239

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
105238 105238 67239 67239 PubChem (compound) 1 56443 56443 1
444626 444626 67239 67239 PubChem (substance) 2 56443 56443 1
466332 466332 67239 67239 PubChem (substance) 2 59793 59793 7
483652 483652 67239 67239 PubChem (substance) 2 48803 48803 8
486968 486968 67239 67239 PubChem (substance) 2 57098 57098 6
492277 492277 67239 67239 PubChem (substance) 2 85428 85428 5
499670 499670 67239 67239 PubChem (substance) 2 19812 19812 3
507462 507462 67239 67239 PubChem (substance) 2 34232 34232 12
509046 509046 67239 67239 PubChem (substance) 2 37188 37188 11
515500 515500 67239 67239 PubChem (substance) 2 48720 48720 2
515503 515503 67239 67239 PubChem (substance) 2 48721 48721 4
518204 518204 67239 67239 PubChem (substance) 2 54430 54430 10
522576 522576 67239 67239 PubChem (substance) 2 67906 67906 9
524559 524559 67239 67239 PubChem (substance) 2 73859 73859 16
755106 755106 67239 67239 PubChem (substance) 2 167639 167639 13
755107 755107 67239 67239 PubChem (substance) 2 143988 143988 14
755109 755109 67239 67239 PubChem (substance) 2 167527 167527 15
1015457 1015457 67239 67239 CAS Common Chemistry 3 56443 56443 1
1217595 1217595 67239 67239 Computational Toxicology and Exposure Data 4 56443 56443 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 412.863ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website