home / zeropm-v0-0-4

api_results

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

26 rows where inchi_id = 3893

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
141427 141427 328520 328520 PubChem (compound) 1 3893 3893 1
141428 141428 121513 121513 PubChem (compound) 1 3893 3893 1
141429 141429 328519 328519 PubChem (compound) 1 3893 3893 1
141430 141430 318990 318990 PubChem (compound) 1 3893 3893 1
141431 141431 121514 121514 PubChem (compound) 1 3893 3893 1
493913 493913 105202 105202 PubChem (substance) 2 3893 3893 2
493914 493914 121513 121513 PubChem (substance) 2 3893 3893 1
493915 493915 233718 233718 PubChem (substance) 2 3893 3893 2
493916 493916 328519 328519 PubChem (substance) 2 3893 3893 1
493917 493917 121514 121514 PubChem (substance) 2 3893 3893 1
493918 493918 341941 341941 PubChem (substance) 2 3893 3893 2
493919 493919 328520 328520 PubChem (substance) 2 3893 3893 1
493920 493920 123690 123690 PubChem (substance) 2 3893 3893 2
493921 493921 366001 366001 PubChem (substance) 2 3893 3893 3
493922 493922 230167 230167 PubChem (substance) 2 3893 3893 2
493923 493923 307678 307678 PubChem (substance) 2 3893 3893 2
493924 493924 364483 364483 PubChem (substance) 2 3893 3893 2
493925 493925 123689 123689 PubChem (substance) 2 3893 3893 2
493926 493926 318990 318990 PubChem (substance) 2 3893 3893 1
493927 493927 105203 105203 PubChem (substance) 2 3893 3893 2
1041294 1041294 121513 121513 CAS Common Chemistry 3 3893 3893 1
1041295 1041295 328519 328519 CAS Common Chemistry 3 3893 3893 1
1041296 1041296 121514 121514 CAS Common Chemistry 3 3893 3893 1
1041297 1041297 328520 328520 CAS Common Chemistry 3 3893 3893 1
1041298 1041298 233718 233718 CAS Common Chemistry 3 3893 3893 1
1041299 1041299 318990 318990 CAS Common Chemistry 3 3893 3893 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 1016.067ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website