home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 113749

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
133097 133097 113749 113749 PubChem (compound) 1 47125 47125 1
440313 440313 113749 113749 PubChem (substance) 2 69417 69417 3
482985 482985 113749 113749 PubChem (substance) 2 47125 47125 1
659834 659834 113749 113749 PubChem (substance) 2 123189 123189 13
780280 780280 113749 113749 PubChem (substance) 2 171737 171737 2
780283 780283 113749 113749 PubChem (substance) 2 258844 258844 14
780284 780284 113749 113749 PubChem (substance) 2 155163 155163 4
780285 780285 113749 113749 PubChem (substance) 2 177276 177276 5
780286 780286 113749 113749 PubChem (substance) 2 177277 177277 6
780287 780287 113749 113749 PubChem (substance) 2 177278 177278 7
780288 780288 113749 113749 PubChem (substance) 2 173917 173917 8
780289 780289 113749 113749 PubChem (substance) 2 198044 198044 9
780290 780290 113749 113749 PubChem (substance) 2 198045 198045 10
780291 780291 113749 113749 PubChem (substance) 2 206934 206934 11
780292 780292 113749 113749 PubChem (substance) 2 284816 284816 12
780296 780296 113749 113749 PubChem (substance) 2 24141 24141 15
1034817 1034817 113749 113749 CAS Common Chemistry 3 47125 47125 1
1237790 1237790 113749 113749 Computational Toxicology and Exposure Data 4 47125 47125 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 713.462ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website