api_results

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

7 rows where query_id = 385412

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
275082 275082 385412 385412 PubChem (compound) 1 148713 148713 1
666080 666080 385412 385412 PubChem (substance) 2 148713 148713 1
850691 850691 385412 385412 PubChem (substance) 2 264987 264987 5
924457 924457 385412 385412 PubChem (substance) 2 148713 148713 2
924458 924458 385412 385412 PubChem (substance) 2 148713 148713 3
924459 924459 385412 385412 PubChem (substance) 2 282948 282948 4
1333583 1333583 385412 385412 Computational Toxicology and Exposure Data 4 122366 122366 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)
);