api_results

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

11 rows where query_id = 27434

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
360077 360077 27434 27434 PubChem (substance) 2 138972 138972 3
380021 380021 27434 27434 PubChem (substance) 2 74183 74183 1
380028 380028 27434 27434 PubChem (substance) 2 167856 167856 5
381726 381726 27434 27434 PubChem (substance) 2 136433 136433 4
469517 469517 27434 27434 PubChem (substance) 2 369 369 6
469638 469638 27434 27434 PubChem (substance) 2 168935 168935 2
726991 726991 27434 27434 PubChem (substance) 2 261691 261691 7
726996 726996 27434 27434 PubChem (substance) 2 242173 242173 8
726997 726997 27434 27434 PubChem (substance) 2 259344 259344 9
981926 981926 27434 27434 CAS Common Chemistry 3 74183 74183 1
1184858 1184858 27434 27434 Computational Toxicology and Exposure Data 4 74183 74183 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)
);