home / zeropm-v0-0-4

api_results

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

24 rows where inchi_id = 138345

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
5556 5556 20053 20053 PubChem (compound) 1 138345 138345 1
5557 5557 2947 2947 PubChem (compound) 1 138345 138345 1
5558 5558 122836 122836 PubChem (compound) 1 138345 138345 1
5559 5559 99965 99965 PubChem (compound) 1 138345 138345 1
5560 5560 99963 99963 PubChem (compound) 1 138345 138345 1
5561 5561 99964 99964 PubChem (compound) 1 138345 138345 1
303266 303266 20053 20053 PubChem (substance) 2 138345 138345 1
303267 303267 330695 330695 PubChem (substance) 2 138345 138345 1
303268 303268 2946 2946 PubChem (substance) 2 138345 138345 2
303269 303269 20344 20344 PubChem (substance) 2 138345 138345 3
303270 303270 2947 2947 PubChem (substance) 2 138345 138345 1
303271 303271 99964 99964 PubChem (substance) 2 138345 138345 1
303272 303272 2948 2948 PubChem (substance) 2 138345 138345 1
303273 303273 99963 99963 PubChem (substance) 2 138345 138345 1
303274 303274 99965 99965 PubChem (substance) 2 138345 138345 1
303275 303275 99962 99962 PubChem (substance) 2 138345 138345 1
303276 303276 351270 351270 PubChem (substance) 2 138345 138345 1
303277 303277 122836 122836 PubChem (substance) 2 138345 138345 1
303278 303278 351269 351269 PubChem (substance) 2 138345 138345 1
303279 303279 135877 135877 PubChem (substance) 2 138345 138345 2
303280 303280 351266 351266 PubChem (substance) 2 138345 138345 3
696583 696583 2946 2946 PubChem (substance) 2 138345 138345 3
696584 696584 351270 351270 PubChem (substance) 2 138345 138345 3
696585 696585 99962 99962 PubChem (substance) 2 138345 138345 3
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 430.741ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website