home / zeropm-v0-0-4

api_results

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

16 rows where inchi_id = 140370

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
192200 192200 399792 399792 PubChem (compound) 1 140370 140370 1
192201 192201 181604 181604 PubChem (compound) 1 140370 140370 1
192202 192202 173526 173526 PubChem (compound) 1 140370 140370 1
192203 192203 337840 337840 PubChem (compound) 1 140370 140370 1
560803 560803 173526 173526 PubChem (substance) 2 140370 140370 1
560804 560804 167062 167062 PubChem (substance) 2 140370 140370 4
560805 560805 181604 181604 PubChem (substance) 2 140370 140370 1
560806 560806 399792 399792 PubChem (substance) 2 140370 140370 1
560807 560807 337840 337840 PubChem (substance) 2 140370 140370 1
560808 560808 337839 337839 PubChem (substance) 2 140370 140370 1
560809 560809 173527 173527 PubChem (substance) 2 140370 140370 1
560810 560810 181605 181605 PubChem (substance) 2 140370 140370 1
560811 560811 343512 343512 PubChem (substance) 2 140370 140370 1
560812 560812 343513 343513 PubChem (substance) 2 140370 140370 2
560813 560813 343511 343511 PubChem (substance) 2 140370 140370 2
932057 932057 399792 399792 PubChem (substance) 2 140370 140370 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 1359.857ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website