api_results

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

12 rows where query_id = 182005

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
200155 200155 182005 182005 PubChem (compound) 1 49304 49304 1
570921 570921 182005 182005 PubChem (substance) 2 49304 49304 1
651974 651974 182005 182005 PubChem (substance) 2 254863 254863 9
752053 752053 182005 182005 PubChem (substance) 2 176261 176261 7
824066 824066 182005 182005 PubChem (substance) 2 184678 184678 2
824067 824067 182005 182005 PubChem (substance) 2 270320 270320 3
824068 824068 182005 182005 PubChem (substance) 2 276077 276077 4
824070 824070 182005 182005 PubChem (substance) 2 212677 212677 5
824072 824072 182005 182005 PubChem (substance) 2 308040 308040 6
824074 824074 182005 182005 PubChem (substance) 2 320942 320942 8
1084036 1084036 182005 182005 CAS Common Chemistry 3 49304 49304 1
1285648 1285648 182005 182005 Computational Toxicology and Exposure Data 4 49304 49304 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)
);