home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 5612

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
10466 10466 5612 5612 PubChem (compound) 1 76691 76691 1
310442 310442 5612 5612 PubChem (substance) 2 76691 76691 1
366022 366022 5612 5612 PubChem (substance) 2 28000 28000 5
409812 409812 5612 5612 PubChem (substance) 2 62069 62069 13
505565 505565 5612 5612 PubChem (substance) 2 30917 30917 6
651133 651133 5612 5612 PubChem (substance) 2 133202 133202 8
699997 699997 5612 5612 PubChem (substance) 2 208795 208795 2
699999 699999 5612 5612 PubChem (substance) 2 174812 174812 3
700001 700001 5612 5612 PubChem (substance) 2 176667 176667 4
700003 700003 5612 5612 PubChem (substance) 2 176715 176715 7
700005 700005 5612 5612 PubChem (substance) 2 247122 247122 9
700007 700007 5612 5612 PubChem (substance) 2 176765 176765 10
700008 700008 5612 5612 PubChem (substance) 2 198105 198105 11
700011 700011 5612 5612 PubChem (substance) 2 186062 186062 12
700013 700013 5612 5612 PubChem (substance) 2 220398 220398 14
700014 700014 5612 5612 PubChem (substance) 2 249392 249392 15
700017 700017 5612 5612 PubChem (substance) 2 245315 245315 16
700019 700019 5612 5612 PubChem (substance) 2 202524 202524 17
700021 700021 5612 5612 PubChem (substance) 2 198098 198098 18
945905 945905 5612 5612 CAS Common Chemistry 3 76691 76691 1
1143921 1143921 5612 5612 Computational Toxicology and Exposure Data 4 76691 76691 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 671.78ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website