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 = 83218

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
94973 94973 83218 83218 PubChem (compound) 1 248640 248640 1
94979 94979 83218 83218 PubChem (compound) 1 248675 248675 2
94981 94981 83218 83218 PubChem (compound) 1 249004 249004 3
94986 94986 83218 83218 PubChem (compound) 1 248713 248713 4
94990 94990 83218 83218 PubChem (compound) 1 334589 334589 5
429804 429804 83218 83218 PubChem (substance) 2 248640 248640 1
429816 429816 83218 83218 PubChem (substance) 2 248675 248675 2
429828 429828 83218 83218 PubChem (substance) 2 249004 249004 3
429837 429837 83218 83218 PubChem (substance) 2 248713 248713 4
429843 429843 83218 83218 PubChem (substance) 2 334589 334589 14
471939 471939 83218 83218 PubChem (substance) 2 248548 248548 5
492833 492833 83218 83218 PubChem (substance) 2 248910 248910 9
496601 496601 83218 83218 PubChem (substance) 2 12272 12272 10
652360 652360 83218 83218 PubChem (substance) 2 248589 248589 11
746377 746377 83218 83218 PubChem (substance) 2 248640 248640 12
746380 746380 83218 83218 PubChem (substance) 2 322068 322068 13
746381 746381 83218 83218 PubChem (substance) 2 248640 248640 15
761671 761671 83218 83218 PubChem (substance) 2 274263 274263 6
761673 761673 83218 83218 PubChem (substance) 2 249004 249004 7
761674 761674 83218 83218 PubChem (substance) 2 149524 149524 8
1008502 1008502 83218 83218 CAS Common Chemistry 3 37647 37647 1
1210519 1210519 83218 83218 Computational Toxicology and Exposure Data 4 37647 37647 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 472.077ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website