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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21370 21370 230069 230069 PubChem (compound) 1 45333 45333 1
326003 326003 230069 230069 PubChem (substance) 2 45333 45333 1
694666 694666 230069 230069 PubChem (substance) 2 232032 232032 4
694673 694673 230069 230069 PubChem (substance) 2 232033 232033 5
694680 694680 230069 230069 PubChem (substance) 2 232034 232034 6
694688 694688 230069 230069 PubChem (substance) 2 149542 149542 7
694690 694690 230069 230069 PubChem (substance) 2 232035 232035 8
706882 706882 230069 230069 PubChem (substance) 2 182692 182692 2
706886 706886 230069 230069 PubChem (substance) 2 208438 208438 3
771938 771938 230069 230069 PubChem (substance) 2 232037 232037 10
775816 775816 230069 230069 PubChem (substance) 2 232038 232038 11
775819 775819 230069 230069 PubChem (substance) 2 230850 230850 12
840313 840313 230069 230069 PubChem (substance) 2 232036 232036 9
840314 840314 230069 230069 PubChem (substance) 2 232039 232039 13
840318 840318 230069 230069 PubChem (substance) 2 232040 232040 14
840320 840320 230069 230069 PubChem (substance) 2 232041 232041 15
840322 840322 230069 230069 PubChem (substance) 2 232042 232042 16
840324 840324 230069 230069 PubChem (substance) 2 169903 169903 17
953962 953962 230069 230069 CAS Common Chemistry 3 45333 45333 1
1153422 1153422 230069 230069 Computational Toxicology and Exposure Data 4 45333 45333 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 515.739ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website