api_results

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

11 rows where query_id = 397378

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
281300 281300 397378 397378 PubChem (compound) 1 10493 10493 1
339473 339473 397378 397378 PubChem (substance) 2 3519 3519 6
624476 624476 397378 397378 PubChem (substance) 2 456 456 5
648873 648873 397378 397378 PubChem (substance) 2 13079 13079 4
673948 673948 397378 397378 PubChem (substance) 2 10493 10493 1
802599 802599 397378 397378 PubChem (substance) 2 13079 13079 7
930943 930943 397378 397378 PubChem (substance) 2 10493 10493 2
930944 930944 397378 397378 PubChem (substance) 2 308799 308799 3
930945 930945 397378 397378 PubChem (substance) 2 226402 226402 8
1123985 1123985 397378 397378 CAS Common Chemistry 3 10493 10493 1
1337922 1337922 397378 397378 Computational Toxicology and Exposure Data 4 10493 10493 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)
);