home / zeropm-v0-0-4

api_results

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

28 rows where query_id = 83827

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
113727 113727 83827 83827 PubChem (compound) 1 315796 315796 1
295964 295964 83827 83827 PubChem (substance) 2 11222 11222 5
296974 296974 83827 83827 PubChem (substance) 2 90217 90217 11
305518 305518 83827 83827 PubChem (substance) 2 73277 73277 17
505061 505061 83827 83827 PubChem (substance) 2 29997 29997 6
512701 512701 83827 83827 PubChem (substance) 2 43279 43279 9
524947 524947 83827 83827 PubChem (substance) 2 74720 74720 8
561974 561974 83827 83827 PubChem (substance) 2 38575 38575 7
573923 573923 83827 83827 PubChem (substance) 2 52549 52549 10
697699 697699 83827 83827 PubChem (substance) 2 21241 21241 1
739172 739172 83827 83827 PubChem (substance) 2 140776 140776 12
762037 762037 83827 83827 PubChem (substance) 2 155428 155428 2
762038 762038 83827 83827 PubChem (substance) 2 177225 177225 3
762039 762039 83827 83827 PubChem (substance) 2 176306 176306 4
762040 762040 83827 83827 PubChem (substance) 2 257457 257457 13
762041 762041 83827 83827 PubChem (substance) 2 270424 270424 14
762043 762043 83827 83827 PubChem (substance) 2 258616 258616 15
762044 762044 83827 83827 PubChem (substance) 2 176772 176772 16
762046 762046 83827 83827 PubChem (substance) 2 322956 322956 18
762047 762047 83827 83827 PubChem (substance) 2 206268 206268 19
762049 762049 83827 83827 PubChem (substance) 2 178673 178673 20
762050 762050 83827 83827 PubChem (substance) 2 267648 267648 21
762051 762051 83827 83827 PubChem (substance) 2 234375 234375 22
762052 762052 83827 83827 PubChem (substance) 2 234610 234610 23
762053 762053 83827 83827 PubChem (substance) 2 288917 288917 24
762054 762054 83827 83827 PubChem (substance) 2 237374 237374 25
1021256 1021256 83827 83827 CAS Common Chemistry 3 21241 21241 1
1139085 1139085 83827 83827 Computational Toxicology and Exposure Data 4 10050 10050 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 632.24ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website