home / zeropm-v0-0-4

api_results

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

21 rows where inchi_id = 46514

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
111490 111490 362165 362165 PubChem (compound) 1 46514 46514 1
111491 111491 79244 79244 PubChem (compound) 1 46514 46514 1
111492 111492 79243 79243 PubChem (compound) 1 46514 46514 1
111493 111493 310235 310235 PubChem (compound) 1 46514 46514 1
111494 111494 238136 238136 PubChem (compound) 1 46514 46514 1
111495 111495 411776 411776 PubChem (compound) 1 46514 46514 1
111496 111496 137141 137141 PubChem (compound) 1 46514 46514 1
453098 453098 79244 79244 PubChem (substance) 2 46514 46514 1
453099 453099 79243 79243 PubChem (substance) 2 46514 46514 1
453100 453100 137141 137141 PubChem (substance) 2 46514 46514 1
453101 453101 310235 310235 PubChem (substance) 2 46514 46514 1
453102 453102 336715 336715 PubChem (substance) 2 46514 46514 2
453103 453103 362165 362165 PubChem (substance) 2 46514 46514 1
453104 453104 411776 411776 PubChem (substance) 2 46514 46514 1
453105 453105 238136 238136 PubChem (substance) 2 46514 46514 1
1019752 1019752 79243 79243 CAS Common Chemistry 3 46514 46514 1
1019753 1019753 310235 310235 CAS Common Chemistry 3 46514 46514 1
1019754 1019754 79244 79244 CAS Common Chemistry 3 46514 46514 1
1019755 1019755 411776 411776 CAS Common Chemistry 3 46514 46514 1
1019756 1019756 362165 362165 CAS Common Chemistry 3 46514 46514 1
1019757 1019757 238136 238136 CAS Common Chemistry 3 46514 46514 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 1133.584ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website