api_results

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

17 rows where query_id = 358783

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21122 21122 358783 358783 PubChem (compound) 1 74066 74066 1
325664 325664 358783 358783 PubChem (substance) 2 74066 74066 1
506483 506483 358783 358783 PubChem (substance) 2 32512 32512 4
520683 520683 358783 358783 PubChem (substance) 2 60274 60274 11
564082 564082 358783 358783 PubChem (substance) 2 40555 40555 6
612634 612634 358783 358783 PubChem (substance) 2 88757 88757 12
612640 612640 358783 358783 PubChem (substance) 2 88759 88759 13
634714 634714 358783 358783 PubChem (substance) 2 172125 172125 10
653112 653112 358783 358783 PubChem (substance) 2 122753 122753 2
673025 673025 358783 358783 PubChem (substance) 2 27053 27053 14
706677 706677 358783 358783 PubChem (substance) 2 181289 181289 3
706682 706682 358783 358783 PubChem (substance) 2 179536 179536 5
706685 706685 358783 358783 PubChem (substance) 2 149920 149920 7
706688 706688 358783 358783 PubChem (substance) 2 171819 171819 8
706691 706691 358783 358783 PubChem (substance) 2 151337 151337 9
953758 953758 358783 358783 CAS Common Chemistry 3 74066 74066 1
1153175 1153175 358783 358783 Computational Toxicology and Exposure Data 4 74066 74066 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)
);