api_results

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

10 rows where query_id = 87461

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
115667 115667 87461 87461 PubChem (compound) 1 107349 107349 1
458888 458888 87461 87461 PubChem (substance) 2 107349 107349 1
678019 678019 87461 87461 PubChem (substance) 2 46862 46862 4
763932 763932 87461 87461 PubChem (substance) 2 231054 231054 2
763933 763933 87461 87461 PubChem (substance) 2 16165 16165 3
763934 763934 87461 87461 PubChem (substance) 2 240264 240264 5
763935 763935 87461 87461 PubChem (substance) 2 107349 107349 6
763936 763936 87461 87461 PubChem (substance) 2 163106 163106 7
1022688 1022688 87461 87461 CAS Common Chemistry 3 16165 16165 1
1225055 1225055 87461 87461 Computational Toxicology and Exposure Data 4 107349 107349 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)
);