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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99735 99735 59974 59974 PubChem (compound) 1 4475 4475 1
436846 436846 59974 59974 PubChem (substance) 2 4475 4475 1
489174 489174 59974 59974 PubChem (substance) 2 67612 67612 22
510010 510010 59974 59974 PubChem (substance) 2 39072 39072 5
510014 510014 59974 59974 PubChem (substance) 2 211085 211085 12
510016 510016 59974 59974 PubChem (substance) 2 272682 272682 14
749874 749874 59974 59974 PubChem (substance) 2 136970 136970 2
749880 749880 59974 59974 PubChem (substance) 2 320450 320450 8
749882 749882 59974 59974 PubChem (substance) 2 340494 340494 18
749885 749885 59974 59974 PubChem (substance) 2 259410 259410 10
749888 749888 59974 59974 PubChem (substance) 2 195730 195730 6
749890 749890 59974 59974 PubChem (substance) 2 256418 256418 15
749891 749891 59974 59974 PubChem (substance) 2 297698 297698 16
749893 749893 59974 59974 PubChem (substance) 2 309787 309787 17
749897 749897 59974 59974 PubChem (substance) 2 216432 216432 7
749898 749898 59974 59974 PubChem (substance) 2 198573 198573 3
749900 749900 59974 59974 PubChem (substance) 2 137753 137753 4
749903 749903 59974 59974 PubChem (substance) 2 232047 232047 9
749905 749905 59974 59974 PubChem (substance) 2 146475 146475 11
749906 749906 59974 59974 PubChem (substance) 2 243355 243355 13
749909 749909 59974 59974 PubChem (substance) 2 291626 291626 19
749910 749910 59974 59974 PubChem (substance) 2 321737 321737 20
749911 749911 59974 59974 PubChem (substance) 2 323080 323080 21
1011734 1011734 59974 59974 CAS Common Chemistry 3 4475 4475 1
1213846 1213846 59974 59974 Computational Toxicology and Exposure Data 4 4475 4475 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 444.322ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website