api_results

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

12 rows where query_id = 11402

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21790 21790 11402 11402 PubChem (compound) 1 53067 53067 1
326834 326834 11402 11402 PubChem (substance) 2 53067 53067 1
431885 431885 11402 11402 PubChem (substance) 2 169642 169642 8
432394 432394 11402 11402 PubChem (substance) 2 90404 90404 9
707573 707573 11402 11402 PubChem (substance) 2 136273 136273 2
707581 707581 11402 11402 PubChem (substance) 2 249057 249057 3
707583 707583 11402 11402 PubChem (substance) 2 243369 243369 4
707587 707587 11402 11402 PubChem (substance) 2 173740 173740 5
707589 707589 11402 11402 PubChem (substance) 2 258700 258700 6
707592 707592 11402 11402 PubChem (substance) 2 209174 209174 7
954282 954282 11402 11402 CAS Common Chemistry 3 53067 53067 1
1153849 1153849 11402 11402 Computational Toxicology and Exposure Data 4 53067 53067 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)
);