home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 138796

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
158967 158967 138796 138796 PubChem (compound) 1 51478 51478 1
303372 303372 138796 138796 PubChem (substance) 2 58549 58549 8
305575 305575 138796 138796 PubChem (substance) 2 2054 2054 14
309340 309340 138796 138796 PubChem (substance) 2 3690 3690 9
310171 310171 138796 138796 PubChem (substance) 2 2666 2666 19
310217 310217 138796 138796 PubChem (substance) 2 3721 3721 7
340162 340162 138796 138796 PubChem (substance) 2 4032 4032 10
340218 340218 138796 138796 PubChem (substance) 2 4040 4040 18
341426 341426 138796 138796 PubChem (substance) 2 4055 4055 13
341509 341509 138796 138796 PubChem (substance) 2 4065 4065 3
366061 366061 138796 138796 PubChem (substance) 2 28116 28116 4
370244 370244 138796 138796 PubChem (substance) 2 42742 42742 6
371342 371342 138796 138796 PubChem (substance) 2 44389 44389 12
395500 395500 138796 138796 PubChem (substance) 2 25158 25158 15
428944 428944 138796 138796 PubChem (substance) 2 25145 25145 11
516908 516908 138796 138796 PubChem (substance) 2 51478 51478 1
548517 548517 138796 138796 PubChem (substance) 2 24986 24986 16
699928 699928 138796 138796 PubChem (substance) 2 270351 270351 17
797714 797714 138796 138796 PubChem (substance) 2 171319 171319 2
797717 797717 138796 138796 PubChem (substance) 2 169807 169807 5
1054461 1054461 138796 138796 CAS Common Chemistry 3 51478 51478 1
1257205 1257205 138796 138796 Computational Toxicology and Exposure Data 4 51478 51478 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.961ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website