home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 377959

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
338120 338120 377959 377959 PubChem (substance) 2 2611 2611 18
827977 827977 377959 377959 PubChem (substance) 2 178671 178671 12
913412 913412 377959 377959 PubChem (substance) 2 241761 241761 7
913414 913414 377959 377959 PubChem (substance) 2 238588 238588 14
913420 913420 377959 377959 PubChem (substance) 2 249066 249066 15
921299 921299 377959 377959 PubChem (substance) 2 261279 261279 1
921300 921300 377959 377959 PubChem (substance) 2 216310 216310 2
921301 921301 377959 377959 PubChem (substance) 2 90344 90344 3
921302 921302 377959 377959 PubChem (substance) 2 267346 267346 4
921303 921303 377959 377959 PubChem (substance) 2 265836 265836 5
921304 921304 377959 377959 PubChem (substance) 2 90344 90344 6
921305 921305 377959 377959 PubChem (substance) 2 261279 261279 8
921306 921306 377959 377959 PubChem (substance) 2 274439 274439 9
921307 921307 377959 377959 PubChem (substance) 2 90344 90344 10
921308 921308 377959 377959 PubChem (substance) 2 246708 246708 11
921309 921309 377959 377959 PubChem (substance) 2 182324 182324 13
921310 921310 377959 377959 PubChem (substance) 2 216310 216310 16
921311 921311 377959 377959 PubChem (substance) 2 241453 241453 17
921312 921312 377959 377959 PubChem (substance) 2 333209 333209 19
1118532 1118532 377959 377959 CAS Common Chemistry 3 90344 90344 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 612.833ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website