home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 175611

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
75839 75839 175611 175611 PubChem (compound) 1 42165 42165 1
337235 337235 175611 175611 PubChem (substance) 2 1539 1539 4
403334 403334 175611 175611 PubChem (substance) 2 42165 42165 1
403336 403336 175611 175611 PubChem (substance) 2 231393 231393 3
403339 403339 175611 175611 PubChem (substance) 2 182808 182808 2
403341 403341 175611 175611 PubChem (substance) 2 249981 249981 17
403343 403343 175611 175611 PubChem (substance) 2 237681 237681 10
403344 403344 175611 175611 PubChem (substance) 2 191710 191710 5
403348 403348 175611 175611 PubChem (substance) 2 308187 308187 16
736588 736588 175611 175611 PubChem (substance) 2 239233 239233 6
736589 736589 175611 175611 PubChem (substance) 2 291091 291091 12
736592 736592 175611 175611 PubChem (substance) 2 216065 216065 7
736594 736594 175611 175611 PubChem (substance) 2 259972 259972 11
736598 736598 175611 175611 PubChem (substance) 2 264725 264725 13
736600 736600 175611 175611 PubChem (substance) 2 201947 201947 14
820953 820953 175611 175611 PubChem (substance) 2 207293 207293 8
820954 820954 175611 175611 PubChem (substance) 2 200266 200266 9
820955 820955 175611 175611 PubChem (substance) 2 333249 333249 15
959676 959676 175611 175611 CAS Common Chemistry 3 1539 1539 1
993610 993610 175611 175611 CAS Common Chemistry 3 42165 42165 3
1196668 1196668 175611 175611 Computational Toxicology and Exposure Data 4 42165 42165 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 459.765ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website