api_results

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

11 rows where query_id = 30563

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
64143 64143 30563 30563 PubChem (compound) 1 121807 121807 1
387120 387120 30563 30563 PubChem (substance) 2 121807 121807 1
672594 672594 30563 30563 PubChem (substance) 2 107325 107325 6
730560 730560 30563 30563 PubChem (substance) 2 9272 9272 2
730739 730739 30563 30563 PubChem (substance) 2 234744 234744 3
730743 730743 30563 30563 PubChem (substance) 2 223131 223131 4
730744 730744 30563 30563 PubChem (substance) 2 296395 296395 5
730745 730745 30563 30563 PubChem (substance) 2 183405 183405 7
730746 730746 30563 30563 PubChem (substance) 2 329439 329439 8
985348 985348 30563 30563 CAS Common Chemistry 3 9272 9272 1
1188277 1188277 30563 30563 Computational Toxicology and Exposure Data 4 121807 121807 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)
);