api_results

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

18 rows where query_id = 81634

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102684 102684 81634 81634 PubChem (compound) 1 119329 119329 1
441036 441036 81634 81634 PubChem (substance) 2 119329 119329 1
441051 441051 81634 81634 PubChem (substance) 2 314709 314709 4
441063 441063 81634 81634 PubChem (substance) 2 315696 315696 8
441070 441070 81634 81634 PubChem (substance) 2 315581 315581 2
441088 441088 81634 81634 PubChem (substance) 2 315701 315701 11
454534 454534 81634 81634 PubChem (substance) 2 8701 8701 5
531194 531194 81634 81634 PubChem (substance) 2 315716 315716 9
752869 752869 81634 81634 PubChem (substance) 2 317023 317023 3
752880 752880 81634 81634 PubChem (substance) 2 315090 315090 6
752897 752897 81634 81634 PubChem (substance) 2 315098 315098 7
752909 752909 81634 81634 PubChem (substance) 2 317895 317895 10
752916 752916 81634 81634 PubChem (substance) 2 317838 317838 12
752929 752929 81634 81634 PubChem (substance) 2 317948 317948 13
752943 752943 81634 81634 PubChem (substance) 2 317881 317881 15
761119 761119 81634 81634 PubChem (substance) 2 318163 318163 14
1013765 1013765 81634 81634 CAS Common Chemistry 3 8701 8701 1
1215921 1215921 81634 81634 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)
);