api_results

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

13 rows where query_id = 112232

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
131332 131332 112232 112232 PubChem (compound) 1 42695 42695 1
480564 480564 112232 112232 PubChem (substance) 2 42695 42695 1
778660 778660 112232 112232 PubChem (substance) 2 136984 136984 2
778661 778661 112232 112232 PubChem (substance) 2 178424 178424 3
778663 778663 112232 112232 PubChem (substance) 2 207784 207784 4
778665 778665 112232 112232 PubChem (substance) 2 198137 198137 5
778667 778667 112232 112232 PubChem (substance) 2 154426 154426 6
778670 778670 112232 112232 PubChem (substance) 2 206961 206961 7
778671 778671 112232 112232 PubChem (substance) 2 200041 200041 8
778673 778673 112232 112232 PubChem (substance) 2 197916 197916 9
778674 778674 112232 112232 PubChem (substance) 2 239125 239125 10
1033529 1033529 112232 112232 CAS Common Chemistry 3 42695 42695 1
1236468 1236468 112232 112232 Computational Toxicology and Exposure Data 4 42695 42695 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)
);