api_results

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

12 rows where query_id = 147284

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
62108 62108 147284 147284 PubChem (compound) 1 178330 178330 1
62113 62113 147284 147284 PubChem (compound) 1 1823 1823 2
62120 62120 147284 147284 PubChem (compound) 1 1823 1823 4
62130 62130 147284 147284 PubChem (compound) 1 243007 243007 3
62133 62133 147284 147284 PubChem (compound) 1 248102 248102 5
383951 383951 147284 147284 PubChem (substance) 2 178330 178330 1
383960 383960 147284 147284 PubChem (substance) 2 1823 1823 2
383970 383970 147284 147284 PubChem (substance) 2 1823 1823 4
383982 383982 147284 147284 PubChem (substance) 2 243007 243007 3
383993 383993 147284 147284 PubChem (substance) 2 248102 248102 5
983835 983835 147284 147284 CAS Common Chemistry 3 1823 1823 1
1186803 1186803 147284 147284 Computational Toxicology and Exposure Data 4 1823 1823 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)
);