api_results

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

6 rows where query_id = 379991

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
237304 237304 379991 379991 PubChem (compound) 1 30970 30970 1
617384 617384 379991 379991 PubChem (substance) 2 30970 30970 1
770531 770531 379991 379991 PubChem (substance) 2 169375 169375 2
922143 922143 379991 379991 PubChem (substance) 2 162707 162707 3
1119164 1119164 379991 379991 CAS Common Chemistry 3 30970 30970 1
1331395 1331395 379991 379991 Computational Toxicology and Exposure Data 4 30970 30970 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)
);