api_results

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

8 rows where query_id = 108530

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
24263 24263 108530 108530 PubChem (compound) 1 4080 4080 1
330422 330422 108530 108530 PubChem (substance) 2 4080 4080 1
647486 647486 108530 108530 PubChem (substance) 2 140583 140583 2
709748 709748 108530 108530 PubChem (substance) 2 189263 189263 3
709753 709753 108530 108530 PubChem (substance) 2 266846 266846 4
775214 775214 108530 108530 PubChem (substance) 2 184648 184648 5
956028 956028 108530 108530 CAS Common Chemistry 3 4080 4080 1
1156056 1156056 108530 108530 Computational Toxicology and Exposure Data 4 4080 4080 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)
);