api_results

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

9 rows where query_id = 14997

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
31560 31560 14997 14997 PubChem (compound) 1 77798 77798 1
337657 337657 14997 14997 PubChem (substance) 2 2267 2267 2
340471 340471 14997 14997 PubChem (substance) 2 77798 77798 1
480445 480445 14997 14997 PubChem (substance) 2 42048 42048 4
518325 518325 14997 14997 PubChem (substance) 2 54699 54699 5
557166 557166 14997 14997 PubChem (substance) 2 33692 33692 3
712686 712686 14997 14997 PubChem (substance) 2 165748 165748 6
961384 961384 14997 14997 CAS Common Chemistry 3 77798 77798 1
1162366 1162366 14997 14997 Computational Toxicology and Exposure Data 4 77798 77798 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)
);