home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 56679

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
95941 95941 56679 56679 PubChem (compound) 1 56470 56470 1
95944 95944 56679 56679 PubChem (compound) 1 228983 228983 2
95947 95947 56679 56679 PubChem (compound) 1 28878 28878 3
431173 431173 56679 56679 PubChem (substance) 2 56470 56470 1
431180 431180 56679 56679 PubChem (substance) 2 228983 228983 5
431182 431182 56679 56679 PubChem (substance) 2 28878 28878 7
747087 747087 56679 56679 PubChem (substance) 2 225386 225386 2
747092 747092 56679 56679 PubChem (substance) 2 227385 227385 3
747096 747096 56679 56679 PubChem (substance) 2 148891 148891 4
747101 747101 56679 56679 PubChem (substance) 2 243341 243341 6
747104 747104 56679 56679 PubChem (substance) 2 136652 136652 8
747109 747109 56679 56679 PubChem (substance) 2 332989 332989 9
747110 747110 56679 56679 PubChem (substance) 2 219176 219176 10
747113 747113 56679 56679 PubChem (substance) 2 284282 284282 11
747114 747114 56679 56679 PubChem (substance) 2 290053 290053 12
747116 747116 56679 56679 PubChem (substance) 2 214903 214903 13
1009236 1009236 56679 56679 CAS Common Chemistry 3 56470 56470 1
1211274 1211274 56679 56679 Computational Toxicology and Exposure Data 4 56470 56470 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 499.577ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website