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 = 18656

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124198 124198 103667 103667 PubChem (compound) 1 18656 18656 1
124199 124199 167073 167073 PubChem (compound) 1 18656 18656 1
124200 124200 125327 125327 PubChem (compound) 1 18656 18656 1
124201 124201 418148 418148 PubChem (compound) 1 18656 18656 1
124202 124202 234737 234737 PubChem (compound) 1 18656 18656 1
124203 124203 125328 125328 PubChem (compound) 1 18656 18656 1
124204 124204 251675 251675 PubChem (compound) 1 18656 18656 1
470883 470883 125328 125328 PubChem (substance) 2 18656 18656 1
470884 470884 251675 251675 PubChem (substance) 2 18656 18656 1
470885 470885 418148 418148 PubChem (substance) 2 18656 18656 1
470886 470886 167626 167626 PubChem (substance) 2 18656 18656 1
470887 470887 234737 234737 PubChem (substance) 2 18656 18656 1
470888 470888 103667 103667 PubChem (substance) 2 18656 18656 1
470889 470889 167625 167625 PubChem (substance) 2 18656 18656 2
470890 470890 125327 125327 PubChem (substance) 2 18656 18656 1
470891 470891 168363 168363 PubChem (substance) 2 18656 18656 2
470892 470892 167073 167073 PubChem (substance) 2 18656 18656 1
470893 470893 252066 252066 PubChem (substance) 2 18656 18656 1
1044128 1044128 125327 125327 CAS Common Chemistry 3 18656 18656 1
1044129 1044129 234737 234737 CAS Common Chemistry 3 18656 18656 1
1044130 1044130 125328 125328 CAS Common Chemistry 3 18656 18656 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 491.884ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website