home / zeropm-v0-0-4

api_results

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

19 rows where inchi_id = 38991

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
147172 147172 174856 174856 PubChem (compound) 1 38991 38991 1
147173 147173 256390 256390 PubChem (compound) 1 38991 38991 1
147174 147174 338097 338097 PubChem (compound) 1 38991 38991 1
147175 147175 127037 127037 PubChem (compound) 1 38991 38991 1
147176 147176 127038 127038 PubChem (compound) 1 38991 38991 1
501526 501526 338097 338097 PubChem (substance) 2 38991 38991 1
501527 501527 174856 174856 PubChem (substance) 2 38991 38991 1
501528 501528 127037 127037 PubChem (substance) 2 38991 38991 1
501529 501529 158213 158213 PubChem (substance) 2 38991 38991 3
501530 501530 127038 127038 PubChem (substance) 2 38991 38991 1
501531 501531 174857 174857 PubChem (substance) 2 38991 38991 1
501532 501532 256390 256390 PubChem (substance) 2 38991 38991 1
501533 501533 251732 251732 PubChem (substance) 2 38991 38991 2
501534 501534 399926 399926 PubChem (substance) 2 38991 38991 4
501535 501535 251730 251730 PubChem (substance) 2 38991 38991 4
1045534 1045534 127037 127037 CAS Common Chemistry 3 38991 38991 1
1045535 1045535 338097 338097 CAS Common Chemistry 3 38991 38991 1
1045536 1045536 174856 174856 CAS Common Chemistry 3 38991 38991 1
1045537 1045537 127038 127038 CAS Common Chemistry 3 38991 38991 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 607.651ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website