home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 29008

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
61984 61984 29008 29008 PubChem (compound) 1 314403 314403 1
61985 61985 29008 29008 PubChem (compound) 1 315064 315064 2
61986 61986 29008 29008 PubChem (compound) 1 216084 216084 3
61987 61987 29008 29008 PubChem (compound) 1 314227 314227 4
61988 61988 29008 29008 PubChem (compound) 1 315617 315617 5
61991 61991 29008 29008 PubChem (compound) 1 332931 332931 6
61992 61992 29008 29008 PubChem (compound) 1 340218 340218 7
61995 61995 29008 29008 PubChem (compound) 1 343676 343676 8
383753 383753 29008 29008 PubChem (substance) 2 314403 314403 1
383759 383759 29008 29008 PubChem (substance) 2 315064 315064 2
383767 383767 29008 29008 PubChem (substance) 2 216084 216084 7
383773 383773 29008 29008 PubChem (substance) 2 314227 314227 4
383774 383774 29008 29008 PubChem (substance) 2 315617 315617 3
383777 383777 29008 29008 PubChem (substance) 2 332931 332931 8
383778 383778 29008 29008 PubChem (substance) 2 340218 340218 9
383781 383781 29008 29008 PubChem (substance) 2 343676 343676 10
647000 647000 29008 29008 PubChem (substance) 2 141992 141992 6
729026 729026 29008 29008 PubChem (substance) 2 314394 314394 5
729027 729027 29008 29008 PubChem (substance) 2 314228 314228 11
983729 983729 29008 29008 CAS Common Chemistry 3 1680 1680 1
1186701 1186701 29008 29008 Computational Toxicology and Exposure Data 4 114182 114182 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 464.275ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website