home / zeropm-v0-0-4

api_results

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

20 rows where inchi_id = 152808

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
1357 1357 667 667 PubChem (compound) 1 152808 152808 1
1358 1358 4949 4949 PubChem (compound) 1 152808 152808 2
1359 1359 107591 107591 PubChem (compound) 1 152808 152808 2
1360 1360 104623 104623 PubChem (compound) 1 152808 152808 1
1361 1361 340534 340534 PubChem (compound) 1 152808 152808 3
1362 1362 668 668 PubChem (compound) 1 152808 152808 1
297456 297456 340534 340534 PubChem (substance) 2 152808 152808 6
297457 297457 667 667 PubChem (substance) 2 152808 152808 1
297458 297458 107591 107591 PubChem (substance) 2 152808 152808 2
297459 297459 4948 4948 PubChem (substance) 2 152808 152808 4
297460 297460 436400 436400 PubChem (substance) 2 152808 152808 4
297461 297461 4949 4949 PubChem (substance) 2 152808 152808 2
297462 297462 339936 339936 PubChem (substance) 2 152808 152808 4
297463 297463 339236 339236 PubChem (substance) 2 152808 152808 3
297464 297464 327701 327701 PubChem (substance) 2 152808 152808 4
297465 297465 668 668 PubChem (substance) 2 152808 152808 1
297466 297466 363367 363367 PubChem (substance) 2 152808 152808 4
297467 297467 340535 340535 PubChem (substance) 2 152808 152808 5
297468 297468 435536 435536 PubChem (substance) 2 152808 152808 3
297469 297469 104623 104623 PubChem (substance) 2 152808 152808 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 631.034ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website