api_results

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

6 rows where query_id = 390266

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
278227 278227 390266 390266 PubChem (compound) 1 70068 70068 1
466252 466252 390266 390266 PubChem (substance) 2 70093 70093 3
670033 670033 390266 390266 PubChem (substance) 2 70068 70068 1
927377 927377 390266 390266 PubChem (substance) 2 144372 144372 2
1122287 1122287 390266 390266 CAS Common Chemistry 3 70068 70068 1
1336088 1336088 390266 390266 Computational Toxicology and Exposure Data 4 70068 70068 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)
);