home / zeropm-v0-0-4

api_results

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

23 rows where inchi_id = 47438

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
4809 4809 2531 2531 PubChem (compound) 1 47438 47438 1
4810 4810 78028 78028 PubChem (compound) 1 47438 47438 1
4811 4811 2535 2535 PubChem (compound) 1 47438 47438 1
4812 4812 302588 302588 PubChem (compound) 1 47438 47438 1
4813 4813 339368 339368 PubChem (compound) 1 47438 47438 1
4814 4814 89487 89487 PubChem (compound) 1 47438 47438 1
4815 4815 375532 375532 PubChem (compound) 1 47438 47438 3
4816 4816 362398 362398 PubChem (compound) 1 47438 47438 1
302253 302253 73399 73399 PubChem (substance) 2 47438 47438 3
302254 302254 2535 2535 PubChem (substance) 2 47438 47438 1
302255 302255 375532 375532 PubChem (substance) 2 47438 47438 3
302256 302256 78028 78028 PubChem (substance) 2 47438 47438 1
302257 302257 339368 339368 PubChem (substance) 2 47438 47438 1
302258 302258 78026 78026 PubChem (substance) 2 47438 47438 3
302259 302259 2531 2531 PubChem (substance) 2 47438 47438 1
302260 302260 366910 366910 PubChem (substance) 2 47438 47438 2
302261 302261 302588 302588 PubChem (substance) 2 47438 47438 1
302262 302262 89487 89487 PubChem (substance) 2 47438 47438 1
302263 302263 362398 362398 PubChem (substance) 2 47438 47438 1
941670 941670 2535 2535 CAS Common Chemistry 3 47438 47438 1
941671 941671 339368 339368 CAS Common Chemistry 3 47438 47438 1
941672 941672 89487 89487 CAS Common Chemistry 3 47438 47438 1
941673 941673 362398 362398 CAS Common Chemistry 3 47438 47438 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 1305.716ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website