home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 181793

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
199939 199939 181793 181793 PubChem (compound) 1 48990 48990 1
199941 199941 181793 181793 PubChem (compound) 1 231433 231433 2
199942 199942 181793 181793 PubChem (compound) 1 219028 219028 3
199943 199943 181793 181793 PubChem (compound) 1 246722 246722 4
199944 199944 181793 181793 PubChem (compound) 1 192029 192029 5
199945 199945 181793 181793 PubChem (compound) 1 189212 189212 6
199946 199946 181793 181793 PubChem (compound) 1 129112 129112 7
570639 570639 181793 181793 PubChem (substance) 2 48990 48990 1
570642 570642 181793 181793 PubChem (substance) 2 231433 231433 2
570646 570646 181793 181793 PubChem (substance) 2 219028 219028 3
570650 570650 181793 181793 PubChem (substance) 2 246722 246722 4
570652 570652 181793 181793 PubChem (substance) 2 192029 192029 5
570653 570653 181793 181793 PubChem (substance) 2 189212 189212 8
570655 570655 181793 181793 PubChem (substance) 2 129112 129112 11
815157 815157 181793 181793 PubChem (substance) 2 137425 137425 10
815163 815163 181793 181793 PubChem (substance) 2 231434 231434 6
823945 823945 181793 181793 PubChem (substance) 2 150959 150959 7
823947 823947 181793 181793 PubChem (substance) 2 291134 291134 9
823948 823948 181793 181793 PubChem (substance) 2 320525 320525 12
823949 823949 181793 181793 PubChem (substance) 2 169006 169006 13
1083902 1083902 181793 181793 CAS Common Chemistry 3 48990 48990 1
1285506 1285506 181793 181793 Computational Toxicology and Exposure Data 4 129112 129112 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)
);
Powered by Datasette · Queries took 600.064ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website