api_results

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

10 rows where query_id = 132911

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
152966 152966 132911 132911 PubChem (compound) 1 37431 37431 1
399879 399879 132911 132911 PubChem (substance) 2 114196 114196 4
509158 509158 132911 132911 PubChem (substance) 2 37431 37431 1
793818 793818 132911 132911 PubChem (substance) 2 159916 159916 2
793823 793823 132911 132911 PubChem (substance) 2 37431 37431 3
793827 793827 132911 132911 PubChem (substance) 2 217772 217772 5
793828 793828 132911 132911 PubChem (substance) 2 205982 205982 6
793830 793830 132911 132911 PubChem (substance) 2 258903 258903 7
1049960 1049960 132911 132911 CAS Common Chemistry 3 37431 37431 1
1252727 1252727 132911 132911 Computational Toxicology and Exposure Data 4 37431 37431 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)
);