api_results

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

13 rows where query_id = 317187

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
441045 441045 317187 317187 PubChem (substance) 2 314709 314709 1
441061 441061 317187 317187 PubChem (substance) 2 315696 315696 6
441079 441079 317187 317187 PubChem (substance) 2 315581 315581 5
441086 441086 317187 317187 PubChem (substance) 2 315701 315701 9
454537 454537 317187 317187 PubChem (substance) 2 8701 8701 2
531185 531185 317187 317187 PubChem (substance) 2 315716 315716 7
752883 752883 317187 317187 PubChem (substance) 2 315090 315090 3
752892 752892 317187 317187 PubChem (substance) 2 315098 315098 4
752905 752905 317187 317187 PubChem (substance) 2 317895 317895 8
752911 752911 317187 317187 PubChem (substance) 2 317838 317838 10
752924 752924 317187 317187 PubChem (substance) 2 317948 317948 11
1013770 1013770 317187 317187 CAS Common Chemistry 3 8701 8701 1
1215920 1215920 317187 317187 Computational Toxicology and Exposure Data 4 119329 119329 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)
);