home / zeropm-v0-0-4

api_results

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

23 rows where inchi_id = 25543

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
93378 93378 313598 313598 PubChem (compound) 1 25543 25543 1
93379 93379 54804 54804 PubChem (compound) 1 25543 25543 1
93380 93380 196560 196560 PubChem (compound) 1 25543 25543 1
427579 427579 6133 6133 PubChem (substance) 2 25543 25543 8
427580 427580 163994 163994 PubChem (substance) 2 25543 25543 1
427581 427581 201311 201311 PubChem (substance) 2 25543 25543 2
427582 427582 54804 54804 PubChem (substance) 2 25543 25543 1
427583 427583 313597 313597 PubChem (substance) 2 25543 25543 1
427584 427584 201313 201313 PubChem (substance) 2 25543 25543 2
427585 427585 201314 201314 PubChem (substance) 2 25543 25543 1
427586 427586 54805 54805 PubChem (substance) 2 25543 25543 1
427587 427587 313598 313598 PubChem (substance) 2 25543 25543 1
427588 427588 201312 201312 PubChem (substance) 2 25543 25543 1
427589 427589 370948 370948 PubChem (substance) 2 25543 25543 8
427590 427590 196560 196560 PubChem (substance) 2 25543 25543 1
427591 427591 167083 167083 PubChem (substance) 2 25543 25543 4
427592 427592 167082 167082 PubChem (substance) 2 25543 25543 2
427593 427593 196561 196561 PubChem (substance) 2 25543 25543 1
427594 427594 326282 326282 PubChem (substance) 2 25543 25543 8
1007355 1007355 54804 54804 CAS Common Chemistry 3 25543 25543 1
1007356 1007356 196560 196560 CAS Common Chemistry 3 25543 25543 1
1007357 1007357 313598 313598 CAS Common Chemistry 3 25543 25543 1
1007358 1007358 54805 54805 CAS Common Chemistry 3 25543 25543 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 711.448ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website