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 = 123202

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
143142 143142 123202 123202 PubChem (compound) 1 136700 136700 1
364583 364583 123202 123202 PubChem (substance) 2 24864 24864 13
431126 431126 123202 123202 PubChem (substance) 2 56057 56057 2
431140 431140 123202 123202 PubChem (substance) 2 124628 124628 6
431145 431145 123202 123202 PubChem (substance) 2 119998 119998 5
496334 496334 123202 123202 PubChem (substance) 2 242698 242698 1
496342 496342 123202 123202 PubChem (substance) 2 136700 136700 4
653728 653728 123202 123202 PubChem (substance) 2 73961 73961 15
747007 747007 123202 123202 PubChem (substance) 2 170797 170797 8
747024 747024 123202 123202 PubChem (substance) 2 239058 239058 11
747029 747029 123202 123202 PubChem (substance) 2 124628 124628 12
747042 747042 123202 123202 PubChem (substance) 2 173492 173492 10
747051 747051 123202 123202 PubChem (substance) 2 170780 170780 9
747058 747058 123202 123202 PubChem (substance) 2 248396 248396 7
787570 787570 123202 123202 PubChem (substance) 2 141033 141033 3
787571 787571 123202 123202 PubChem (substance) 2 164459 164459 14
1009218 1009218 123202 123202 CAS Common Chemistry 3 56057 56057 2
1211249 1211249 123202 123202 Computational Toxicology and Exposure Data 4 56057 56057 2
1211260 1211260 123202 123202 Computational Toxicology and Exposure Data 4 124628 124628 3
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 760.64ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website