home / zeropm-v0-0-4

api_results

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

15 rows where inchi_id = 199861

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
129937 129937 110958 110958 PubChem (compound) 1 199861 199861 1
129938 129938 358811 358811 PubChem (compound) 1 199861 199861 1
263943 263943 337007 337007 PubChem (compound) 1 199861 199861 2
478781 478781 110386 110386 PubChem (substance) 2 199861 199861 2
478782 478782 16527 16527 PubChem (substance) 2 199861 199861 2
478783 478783 26485 26485 PubChem (substance) 2 199861 199861 3
478784 478784 110958 110958 PubChem (substance) 2 199861 199861 1
478785 478785 358811 358811 PubChem (substance) 2 199861 199861 1
478786 478786 341532 341532 PubChem (substance) 2 199861 199861 2
478787 478787 26486 26486 PubChem (substance) 2 199861 199861 2
478788 478788 83353 83353 PubChem (substance) 2 199861 199861 4
478789 478789 110387 110387 PubChem (substance) 2 199861 199861 2
478790 478790 358812 358812 PubChem (substance) 2 199861 199861 4
650522 650522 16527 16527 PubChem (substance) 2 199861 199861 4
650523 650523 337007 337007 PubChem (substance) 2 199861 199861 2
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 758.819ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website