home / zeropm-v0-0-4

api_results

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

28 rows where inchi_id = 28891

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21586 21586 340128 340128 PubChem (compound) 1 28891 28891 1
21587 21587 111680 111680 PubChem (compound) 1 28891 28891 1
21588 21588 11347 11347 PubChem (compound) 1 28891 28891 1
21589 21589 111679 111679 PubChem (compound) 1 28891 28891 1
21590 21590 104852 104852 PubChem (compound) 1 28891 28891 1
326424 326424 11348 11348 PubChem (substance) 2 28891 28891 1
326425 326425 11347 11347 PubChem (substance) 2 28891 28891 1
326426 326426 7937 7937 PubChem (substance) 2 28891 28891 9
326427 326427 112407 112407 PubChem (substance) 2 28891 28891 2
326428 326428 107240 107240 PubChem (substance) 2 28891 28891 2
326429 326429 113201 113201 PubChem (substance) 2 28891 28891 2
326430 326430 363727 363727 PubChem (substance) 2 28891 28891 4
326431 326431 340128 340128 PubChem (substance) 2 28891 28891 1
326432 326432 77961 77961 PubChem (substance) 2 28891 28891 4
326433 326433 111680 111680 PubChem (substance) 2 28891 28891 1
326434 326434 112408 112408 PubChem (substance) 2 28891 28891 2
326435 326435 111679 111679 PubChem (substance) 2 28891 28891 1
326436 326436 139404 139404 PubChem (substance) 2 28891 28891 2
326437 326437 113202 113202 PubChem (substance) 2 28891 28891 2
326438 326438 348179 348179 PubChem (substance) 2 28891 28891 9
326439 326439 103989 103989 PubChem (substance) 2 28891 28891 9
326440 326440 104852 104852 PubChem (substance) 2 28891 28891 1
954136 954136 340128 340128 CAS Common Chemistry 3 28891 28891 1
954137 954137 111680 111680 CAS Common Chemistry 3 28891 28891 1
954138 954138 11347 11347 CAS Common Chemistry 3 28891 28891 1
954139 954139 104852 104852 CAS Common Chemistry 3 28891 28891 1
954140 954140 111679 111679 CAS Common Chemistry 3 28891 28891 1
1119368 1119368 380691 380691 CAS Common Chemistry 3 28891 28891 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 1174.109ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website