home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 172150

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
125119 125119 172150 172150 PubChem (compound) 1 58689 58689 2
190817 190817 172150 172150 PubChem (compound) 1 228652 228652 1
190819 190819 172150 172150 PubChem (compound) 1 35492 35492 3
190820 190820 172150 172150 PubChem (compound) 1 332362 332362 4
190821 190821 172150 172150 PubChem (compound) 1 228652 228652 5
472294 472294 172150 172150 PubChem (substance) 2 58689 58689 3
559021 559021 172150 172150 PubChem (substance) 2 228652 228652 1
559023 559023 172150 172150 PubChem (substance) 2 35492 35492 4
559025 559025 172150 172150 PubChem (substance) 2 332362 332362 5
559027 559027 172150 172150 PubChem (substance) 2 228652 228652 9
772562 772562 172150 172150 PubChem (substance) 2 136301 136301 16
818959 818959 172150 172150 PubChem (substance) 2 228596 228596 2
818961 818961 172150 172150 PubChem (substance) 2 289233 289233 6
818963 818963 172150 172150 PubChem (substance) 2 274645 274645 7
818964 818964 172150 172150 PubChem (substance) 2 259997 259997 8
818967 818967 172150 172150 PubChem (substance) 2 285349 285349 10
818968 818968 172150 172150 PubChem (substance) 2 289246 289246 11
818969 818969 172150 172150 PubChem (substance) 2 291019 291019 12
818970 818970 172150 172150 PubChem (substance) 2 211052 211052 13
818971 818971 172150 172150 PubChem (substance) 2 264526 264526 14
818972 818972 172150 172150 PubChem (substance) 2 309673 309673 15
1077585 1077585 172150 172150 CAS Common Chemistry 3 35492 35492 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 457.881ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website