home / zeropm-v0-0-4

api_results

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

18 rows where inchi_id = 39821

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
8045 8045 104178 104178 PubChem (compound) 1 39821 39821 1
8046 8046 338235 338235 PubChem (compound) 1 39821 39821 1
8047 8047 4267 4267 PubChem (compound) 1 39821 39821 1
8048 8048 380481 380481 PubChem (compound) 1 39821 39821 1
8049 8049 82225 82225 PubChem (compound) 1 39821 39821 1
8050 8050 302543 302543 PubChem (compound) 1 39821 39821 1
306596 306596 4267 4267 PubChem (substance) 2 39821 39821 1
306597 306597 338235 338235 PubChem (substance) 2 39821 39821 1
306598 306598 175635 175635 PubChem (substance) 2 39821 39821 2
306599 306599 380481 380481 PubChem (substance) 2 39821 39821 1
306600 306600 104178 104178 PubChem (substance) 2 39821 39821 1
306601 306601 302543 302543 PubChem (substance) 2 39821 39821 1
306602 306602 82225 82225 PubChem (substance) 2 39821 39821 1
944097 944097 338235 338235 CAS Common Chemistry 3 39821 39821 1
944098 944098 4267 4267 CAS Common Chemistry 3 39821 39821 1
944099 944099 302543 302543 CAS Common Chemistry 3 39821 39821 1
944100 944100 380481 380481 CAS Common Chemistry 3 39821 39821 1
944101 944101 82225 82225 CAS Common Chemistry 3 39821 39821 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 1269.908ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website