api_results

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

10 rows where query_id = 23112

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
51408 51408 23112 23112 PubChem (compound) 1 117380 117380 1
368596 368596 23112 23112 PubChem (substance) 2 117380 117380 1
368600 368600 23112 23112 PubChem (substance) 2 117380 117380 5
368605 368605 23112 23112 PubChem (substance) 2 37308 37308 7
368607 368607 23112 23112 PubChem (substance) 2 216269 216269 4
722575 722575 23112 23112 PubChem (substance) 2 185126 185126 3
722577 722577 23112 23112 PubChem (substance) 2 261460 261460 6
722583 722583 23112 23112 PubChem (substance) 2 138645 138645 2
975618 975618 23112 23112 CAS Common Chemistry 3 37308 37308 1
1178379 1178379 23112 23112 Computational Toxicology and Exposure Data 4 117380 117380 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)
);