home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 117614

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99740 99740 117614 117614 PubChem (compound) 1 60783 60783 1
326645 326645 117614 117614 PubChem (substance) 2 52187 52187 9
436851 436851 117614 117614 PubChem (substance) 2 4475 4475 3
436864 436864 117614 117614 PubChem (substance) 2 60783 60783 1
749877 749877 117614 117614 PubChem (substance) 2 136970 136970 6
749922 749922 117614 117614 PubChem (substance) 2 216879 216879 2
749925 749925 117614 117614 PubChem (substance) 2 210077 210077 5
749928 749928 117614 117614 PubChem (substance) 2 60783 60783 4
749931 749931 117614 117614 PubChem (substance) 2 175717 175717 8
749932 749932 117614 117614 PubChem (substance) 2 243360 243360 12
749936 749936 117614 117614 PubChem (substance) 2 260175 260175 7
749939 749939 117614 117614 PubChem (substance) 2 263741 263741 10
749940 749940 117614 117614 PubChem (substance) 2 270875 270875 14
749942 749942 117614 117614 PubChem (substance) 2 308065 308065 15
749945 749945 117614 117614 PubChem (substance) 2 291385 291385 16
749947 749947 117614 117614 PubChem (substance) 2 326569 326569 17
749949 749949 117614 117614 PubChem (substance) 2 343769 343769 18
783132 783132 117614 117614 PubChem (substance) 2 279938 279938 11
783133 783133 117614 117614 PubChem (substance) 2 215551 215551 13
1011740 1011740 117614 117614 CAS Common Chemistry 3 60783 60783 1
1213851 1213851 117614 117614 Computational Toxicology and Exposure Data 4 60783 60783 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)
);
Powered by Datasette · Queries took 442.312ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website