home / zeropm-v0-0-4

api_results

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

27 rows where inchi_id = 51414

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
201520 201520 183472 183472 PubChem (compound) 1 51414 51414 1
201521 201521 183471 183471 PubChem (compound) 1 51414 51414 1
201522 201522 421463 421463 PubChem (compound) 1 51414 51414 1
201523 201523 196850 196850 PubChem (compound) 1 51414 51414 2
201524 201524 183471 183471 PubChem (compound) 1 51414 51414 2
201525 201525 427949 427949 PubChem (compound) 1 51414 51414 2
214164 214164 427949 427949 PubChem (compound) 1 51414 51414 1
214165 214165 196850 196850 PubChem (compound) 1 51414 51414 1
214166 214166 196851 196851 PubChem (compound) 1 51414 51414 1
572659 572659 183472 183472 PubChem (substance) 2 51414 51414 1
572660 572660 183471 183471 PubChem (substance) 2 51414 51414 1
572661 572661 421463 421463 PubChem (substance) 2 51414 51414 1
572662 572662 183472 183472 PubChem (substance) 2 51414 51414 2
572663 572663 196851 196851 PubChem (substance) 2 51414 51414 2
572664 572664 421463 421463 PubChem (substance) 2 51414 51414 2
572665 572665 196850 196850 PubChem (substance) 2 51414 51414 2
572666 572666 183471 183471 PubChem (substance) 2 51414 51414 2
572667 572667 427949 427949 PubChem (substance) 2 51414 51414 2
589115 589115 196850 196850 PubChem (substance) 2 51414 51414 1
589116 589116 196851 196851 PubChem (substance) 2 51414 51414 1
589117 589117 427949 427949 PubChem (substance) 2 51414 51414 1
824774 824774 196850 196850 PubChem (substance) 2 51414 51414 4
824775 824775 183471 183471 PubChem (substance) 2 51414 51414 3
1084999 1084999 183471 183471 CAS Common Chemistry 3 51414 51414 1
1085000 1085000 421463 421463 CAS Common Chemistry 3 51414 51414 1
1093507 1093507 196850 196850 CAS Common Chemistry 3 51414 51414 1
1093508 1093508 427949 427949 CAS Common Chemistry 3 51414 51414 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 2210.132ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website