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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
73534 73534 36100 36100 PubChem (compound) 1 67690 67690 1
73535 73535 36098 36098 PubChem (compound) 1 67690 67690 1
73536 73536 197519 197519 PubChem (compound) 1 67690 67690 1
73537 73537 197520 197520 PubChem (compound) 1 67690 67690 1
73538 73538 171072 171072 PubChem (compound) 1 67690 67690 1
73539 73539 428455 428455 PubChem (compound) 1 67690 67690 1
400233 400233 197519 197519 PubChem (substance) 2 67690 67690 1
400234 400234 171073 171073 PubChem (substance) 2 67690 67690 1
400235 400235 428455 428455 PubChem (substance) 2 67690 67690 1
400236 400236 36100 36100 PubChem (substance) 2 67690 67690 1
400237 400237 36098 36098 PubChem (substance) 2 67690 67690 1
400238 400238 171072 171072 PubChem (substance) 2 67690 67690 1
400239 400239 36099 36099 PubChem (substance) 2 67690 67690 1
400240 400240 36101 36101 PubChem (substance) 2 67690 67690 1
400241 400241 197520 197520 PubChem (substance) 2 67690 67690 1
1093878 1093878 197519 197519 CAS Common Chemistry 3 67690 67690 1
1093879 1093879 197520 197520 CAS Common Chemistry 3 67690 67690 1
1093880 1093880 428455 428455 CAS Common Chemistry 3 67690 67690 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 839.787ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website