api_results

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

15 rows where query_id = 12080

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
23694 23694 12080 12080 PubChem (compound) 1 77510 77510 1
329656 329656 12080 12080 PubChem (substance) 2 77510 77510 1
477921 477921 12080 12080 PubChem (substance) 2 94639 94639 11
709314 709314 12080 12080 PubChem (substance) 2 136863 136863 2
709318 709318 12080 12080 PubChem (substance) 2 199615 199615 3
709321 709321 12080 12080 PubChem (substance) 2 230248 230248 4
709327 709327 12080 12080 PubChem (substance) 2 158872 158872 5
709331 709331 12080 12080 PubChem (substance) 2 206927 206927 6
709333 709333 12080 12080 PubChem (substance) 2 195650 195650 7
709336 709336 12080 12080 PubChem (substance) 2 230567 230567 8
709339 709339 12080 12080 PubChem (substance) 2 320940 320940 9
709342 709342 12080 12080 PubChem (substance) 2 321315 321315 10
709345 709345 12080 12080 PubChem (substance) 2 241751 241751 12
955598 955598 12080 12080 CAS Common Chemistry 3 77510 77510 1
1155555 1155555 12080 12080 Computational Toxicology and Exposure Data 4 77510 77510 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)
);