api_results

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

14 rows where query_id = 90720

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
15192 15192 90720 90720 PubChem (compound) 1 74728 74728 1
295843 295843 90720 90720 PubChem (substance) 2 60357 60357 9
316465 316465 90720 90720 PubChem (substance) 2 75571 75571 8
316997 316997 90720 90720 PubChem (substance) 2 74728 74728 1
328440 328440 90720 90720 PubChem (substance) 2 74122 74122 6
328449 328449 90720 90720 PubChem (substance) 2 74123 74123 2
465888 465888 90720 90720 PubChem (substance) 2 75532 75532 10
505631 505631 90720 90720 PubChem (substance) 2 95715 95715 5
538986 538986 90720 90720 PubChem (substance) 2 15970 15970 7
678407 678407 90720 90720 PubChem (substance) 2 30999 30999 4
703067 703067 90720 90720 PubChem (substance) 2 142188 142188 3
949508 949508 90720 90720 CAS Common Chemistry 3 74728 74728 1
1148235 1148235 90720 90720 Computational Toxicology and Exposure Data 4 74728 74728 1
1226279 1226279 90720 90720 Computational Toxicology and Exposure Data 4 54965 54965 2 
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)
);