home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 111039

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
635 635 111039 111039 PubChem (compound) 1 208689 208689 1
641 641 111039 111039 PubChem (compound) 1 136630 136630 2
645 645 111039 111039 PubChem (compound) 1 157922 157922 3
651 651 111039 111039 PubChem (compound) 1 140148 140148 4
653 653 111039 111039 PubChem (compound) 1 232227 232227 5
657 657 111039 111039 PubChem (compound) 1 281132 281132 6
130031 130031 111039 111039 PubChem (compound) 1 284638 284638 7
296452 296452 111039 111039 PubChem (substance) 2 208689 208689 1
296462 296462 111039 111039 PubChem (substance) 2 136630 136630 2
296469 296469 111039 111039 PubChem (substance) 2 157922 157922 3
296481 296481 111039 111039 PubChem (substance) 2 140148 140148 4
296486 296486 111039 111039 PubChem (substance) 2 232227 232227 5
296490 296490 111039 111039 PubChem (substance) 2 281132 281132 6
305314 305314 111039 111039 PubChem (substance) 2 7599 7599 7
308762 308762 111039 111039 PubChem (substance) 2 137995 137995 8
478905 478905 111039 111039 PubChem (substance) 2 284638 284638 11
777626 777626 111039 111039 PubChem (substance) 2 157923 157923 9
777630 777630 111039 111039 PubChem (substance) 2 334645 334645 10
938571 938571 111039 111039 CAS Common Chemistry 3 32583 32583 1
1135262 1135262 111039 111039 Computational Toxicology and Exposure Data 4 32583 32583 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 438.71ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website