home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 375590

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
268801 268801 375590 375590 PubChem (compound) 1 12823 12823 1
268802 268802 375590 375590 PubChem (compound) 1 264723 264723 2
268803 268803 375590 375590 PubChem (compound) 1 326138 326138 3
268804 268804 375590 375590 PubChem (compound) 1 246781 246781 4
268805 268805 375590 375590 PubChem (compound) 1 323928 323928 5
268806 268806 375590 375590 PubChem (compound) 1 335157 335157 6
268807 268807 375590 375590 PubChem (compound) 1 232531 232531 7
268808 268808 375590 375590 PubChem (compound) 1 309768 309768 8
268809 268809 375590 375590 PubChem (compound) 1 320784 320784 9
268810 268810 375590 375590 PubChem (compound) 1 333009 333009 10
268811 268811 375590 375590 PubChem (compound) 1 343672 343672 11
658198 658198 375590 375590 PubChem (substance) 2 4324 4324 7
658258 658258 375590 375590 PubChem (substance) 2 12823 12823 1
658260 658260 375590 375590 PubChem (substance) 2 264723 264723 2
658261 658261 375590 375590 PubChem (substance) 2 326138 326138 3
658262 658262 375590 375590 PubChem (substance) 2 246781 246781 4
658263 658263 375590 375590 PubChem (substance) 2 323928 323928 5
658264 658264 375590 375590 PubChem (substance) 2 335157 335157 6
658265 658265 375590 375590 PubChem (substance) 2 232531 232531 9
658266 658266 375590 375590 PubChem (substance) 2 309768 309768 10
658267 658267 375590 375590 PubChem (substance) 2 320784 320784 11
658268 658268 375590 375590 PubChem (substance) 2 333009 333009 13
658269 658269 375590 375590 PubChem (substance) 2 343672 343672 12
691682 691682 375590 375590 PubChem (substance) 2 198591 198591 8
1117727 1117727 375590 375590 CAS Common Chemistry 3 12823 12823 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 583.286ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website