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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
116523 116523 88941 88941 PubChem (compound) 1 48082 48082 1
460147 460147 88941 88941 PubChem (substance) 2 48082 48082 1
764591 764591 88941 88941 PubChem (substance) 2 136252 136252 2
764593 764593 88941 88941 PubChem (substance) 2 208865 208865 3
764594 764594 88941 88941 PubChem (substance) 2 217780 217780 4
764596 764596 88941 88941 PubChem (substance) 2 274918 274918 5
764597 764597 88941 88941 PubChem (substance) 2 199908 199908 6
764599 764599 88941 88941 PubChem (substance) 2 235165 235165 7
764600 764600 88941 88941 PubChem (substance) 2 195647 195647 8
764602 764602 88941 88941 PubChem (substance) 2 249851 249851 9
764603 764603 88941 88941 PubChem (substance) 2 291890 291890 10
764604 764604 88941 88941 PubChem (substance) 2 195294 195294 11
764607 764607 88941 88941 PubChem (substance) 2 192439 192439 12
764609 764609 88941 88941 PubChem (substance) 2 202168 202168 13
764610 764610 88941 88941 PubChem (substance) 2 195226 195226 14
764611 764611 88941 88941 PubChem (substance) 2 326521 326521 15
764612 764612 88941 88941 PubChem (substance) 2 217188 217188 16
764613 764613 88941 88941 PubChem (substance) 2 294846 294846 17
1023227 1023227 88941 88941 CAS Common Chemistry 3 48082 48082 1
1225603 1225603 88941 88941 Computational Toxicology and Exposure Data 4 48082 48082 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 478.68ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website