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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
237339 237339 228801 228801 PubChem (compound) 1 203375 203375 1
237340 237340 228801 228801 PubChem (compound) 1 172189 172189 2
237341 237341 228801 228801 PubChem (compound) 1 206201 206201 3
237342 237342 228801 228801 PubChem (compound) 1 178006 178006 4
237343 237343 228801 228801 PubChem (compound) 1 179614 179614 5
237344 237344 228801 228801 PubChem (compound) 1 191933 191933 6
237345 237345 228801 228801 PubChem (compound) 1 247588 247588 7
237346 237346 228801 228801 PubChem (compound) 1 255119 255119 8
296748 296748 228801 228801 PubChem (substance) 2 61265 61265 6
617429 617429 228801 228801 PubChem (substance) 2 203375 203375 1
617431 617431 228801 228801 PubChem (substance) 2 172189 172189 2
617432 617432 228801 228801 PubChem (substance) 2 206201 206201 3
617433 617433 228801 228801 PubChem (substance) 2 178006 178006 8
617434 617434 228801 228801 PubChem (substance) 2 179614 179614 4
617435 617435 228801 228801 PubChem (substance) 2 191933 191933 5
617436 617436 228801 228801 PubChem (substance) 2 247588 247588 10
617437 617437 228801 228801 PubChem (substance) 2 255119 255119 11
663403 663403 228801 228801 PubChem (substance) 2 226134 226134 7
839982 839982 228801 228801 PubChem (substance) 2 179359 179359 9
839983 839983 228801 228801 PubChem (substance) 2 172358 172358 12
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 1592.047ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website