home / zeropm-v0-0-4

api_results

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

43 rows where inchi_id = 31914

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
35855 35855 312401 312401 PubChem (compound) 1 31914 31914 1
35856 35856 437526 437526 PubChem (compound) 1 31914 31914 1
35857 35857 67642 67642 PubChem (compound) 1 31914 31914 1
35858 35858 110924 110924 PubChem (compound) 1 31914 31914 1
35859 35859 16515 16515 PubChem (compound) 1 31914 31914 1
35860 35860 16516 16516 PubChem (compound) 1 31914 31914 1
35861 35861 358760 358760 PubChem (compound) 1 31914 31914 1
346932 346932 16515 16515 PubChem (substance) 2 31914 31914 1
346933 346933 11339 11339 PubChem (substance) 2 31914 31914 7
346934 346934 38968 38968 PubChem (substance) 2 31914 31914 4
346935 346935 67915 67915 PubChem (substance) 2 31914 31914 3
346936 346936 16516 16516 PubChem (substance) 2 31914 31914 1
346937 346937 110924 110924 PubChem (substance) 2 31914 31914 1
346938 346938 62143 62143 PubChem (substance) 2 31914 31914 2
346939 346939 437526 437526 PubChem (substance) 2 31914 31914 1
346940 346940 11337 11337 PubChem (substance) 2 31914 31914 2
346941 346941 104833 104833 PubChem (substance) 2 31914 31914 2
346942 346942 94704 94704 PubChem (substance) 2 31914 31914 6
346943 346943 11338 11338 PubChem (substance) 2 31914 31914 2
346944 346944 363648 363648 PubChem (substance) 2 31914 31914 13
346945 346945 336972 336972 PubChem (substance) 2 31914 31914 2
346946 346946 350726 350726 PubChem (substance) 2 31914 31914 3
346947 346947 359580 359580 PubChem (substance) 2 31914 31914 4
346948 346948 16585 16585 PubChem (substance) 2 31914 31914 2
346949 346949 67642 67642 PubChem (substance) 2 31914 31914 1
346950 346950 62144 62144 PubChem (substance) 2 31914 31914 2
346951 346951 16584 16584 PubChem (substance) 2 31914 31914 2
346952 346952 389579 389579 PubChem (substance) 2 31914 31914 2
346953 346953 358760 358760 PubChem (substance) 2 31914 31914 1
346954 346954 391898 391898 PubChem (substance) 2 31914 31914 6
346955 346955 111294 111294 PubChem (substance) 2 31914 31914 2
346956 346956 309382 309382 PubChem (substance) 2 31914 31914 2
346957 346957 312401 312401 PubChem (substance) 2 31914 31914 1
346958 346958 435585 435585 PubChem (substance) 2 31914 31914 2
346959 346959 363647 363647 PubChem (substance) 2 31914 31914 2
964295 964295 16515 16515 CAS Common Chemistry 3 31914 31914 1
964296 964296 312401 312401 CAS Common Chemistry 3 31914 31914 1
964297 964297 16516 16516 CAS Common Chemistry 3 31914 31914 1
964298 964298 336972 336972 CAS Common Chemistry 3 31914 31914 1
964299 964299 363647 363647 CAS Common Chemistry 3 31914 31914 1
964300 964300 358760 358760 CAS Common Chemistry 3 31914 31914 1
964301 964301 110924 110924 CAS Common Chemistry 3 31914 31914 1
964302 964302 437526 437526 CAS Common Chemistry 3 31914 31914 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 1011.874ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website