home / zeropm-v0-0-4

api_results

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

24 rows where inchi_id = 20317

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
8684 8684 4660 4660 PubChem (compound) 1 20317 20317 1
8685 8685 32915 32915 PubChem (compound) 1 20317 20317 1
8686 8686 159855 159855 PubChem (compound) 1 20317 20317 1
8687 8687 85245 85245 PubChem (compound) 1 20317 20317 1
8688 8688 4661 4661 PubChem (compound) 1 20317 20317 1
307526 307526 4663 4663 PubChem (substance) 2 20317 20317 2
307527 307527 32915 32915 PubChem (substance) 2 20317 20317 1
307528 307528 4660 4660 PubChem (substance) 2 20317 20317 1
307529 307529 54403 54403 PubChem (substance) 2 20317 20317 2
307530 307530 54405 54405 PubChem (substance) 2 20317 20317 1
307531 307531 7701 7701 PubChem (substance) 2 20317 20317 2
307532 307532 159855 159855 PubChem (substance) 2 20317 20317 1
307533 307533 85245 85245 PubChem (substance) 2 20317 20317 1
307534 307534 139563 139563 PubChem (substance) 2 20317 20317 2
307535 307535 81545 81545 PubChem (substance) 2 20317 20317 2
307536 307536 85246 85246 PubChem (substance) 2 20317 20317 1
307537 307537 159856 159856 PubChem (substance) 2 20317 20317 2
307538 307538 357035 357035 PubChem (substance) 2 20317 20317 1
307539 307539 4661 4661 PubChem (substance) 2 20317 20317 1
944594 944594 4660 4660 CAS Common Chemistry 3 20317 20317 1
944595 944595 32915 32915 CAS Common Chemistry 3 20317 20317 1
944596 944596 159855 159855 CAS Common Chemistry 3 20317 20317 1
944597 944597 314459 314459 CAS Common Chemistry 3 20317 20317 1
944598 944598 4661 4661 CAS Common Chemistry 3 20317 20317 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 812.17ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website