home / zeropm-v0-0-4

api_results

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

29 rows where query_id = 366000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21897 21897 366000 366000 PubChem (compound) 1 54021 54021 2
22090 22090 366000 366000 PubChem (compound) 1 58694 58694 1
36055 36055 366000 366000 PubChem (compound) 1 35894 35894 3
326340 326340 366000 366000 PubChem (substance) 2 51328 51328 18
327037 327037 366000 366000 PubChem (substance) 2 54021 54021 2
327335 327335 366000 366000 PubChem (substance) 2 58694 58694 1
347255 347255 366000 366000 PubChem (substance) 2 35894 35894 3
505463 505463 366000 366000 PubChem (substance) 2 30747 30747 20
707925 707925 366000 366000 PubChem (substance) 2 54021 54021 10
707940 707940 366000 366000 PubChem (substance) 2 58694 58694 5
749602 749602 366000 366000 PubChem (substance) 2 169733 169733 16
751058 751058 366000 366000 PubChem (substance) 2 169448 169448 19
846943 846943 366000 366000 PubChem (substance) 2 188331 188331 4
846946 846946 366000 366000 PubChem (substance) 2 169599 169599 6
846947 846947 366000 366000 PubChem (substance) 2 188328 188328 7
846950 846950 366000 366000 PubChem (substance) 2 188329 188329 8
846952 846952 366000 366000 PubChem (substance) 2 169602 169602 9
846954 846954 366000 366000 PubChem (substance) 2 188330 188330 11
846956 846956 366000 366000 PubChem (substance) 2 169723 169723 12
846957 846957 366000 366000 PubChem (substance) 2 149567 149567 13
846961 846961 366000 366000 PubChem (substance) 2 193582 193582 14
846963 846963 366000 366000 PubChem (substance) 2 281330 281330 15
846965 846965 366000 366000 PubChem (substance) 2 241507 241507 17
846966 846966 366000 366000 PubChem (substance) 2 329660 329660 21
846969 846969 366000 366000 PubChem (substance) 2 330490 330490 22
846970 846970 366000 366000 PubChem (substance) 2 188330 188330 23
954343 954343 366000 366000 CAS Common Chemistry 3 54021 54021 1
954504 954504 366000 366000 CAS Common Chemistry 3 58694 58694 2
1153926 1153926 366000 366000 Computational Toxicology and Exposure Data 4 132670 132670 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 456.819ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website