home / zeropm-v0-0-4

api_results

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

19 rows where inchi_id = 39641

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
94930 94930 55922 55922 PubChem (compound) 1 39641 39641 1
94931 94931 55923 55923 PubChem (compound) 1 39641 39641 1
94932 94932 237071 237071 PubChem (compound) 1 39641 39641 1
94933 94933 73562 73562 PubChem (compound) 1 39641 39641 1
94934 94934 133770 133770 PubChem (compound) 1 39641 39641 1
94935 94935 311236 311236 PubChem (compound) 1 39641 39641 1
429731 429731 71809 71809 PubChem (substance) 2 39641 39641 1
429732 429732 55923 55923 PubChem (substance) 2 39641 39641 1
429733 429733 55922 55922 PubChem (substance) 2 39641 39641 1
429734 429734 133770 133770 PubChem (substance) 2 39641 39641 1
429735 429735 176713 176713 PubChem (substance) 2 39641 39641 2
429736 429736 311236 311236 PubChem (substance) 2 39641 39641 1
429737 429737 71810 71810 PubChem (substance) 2 39641 39641 1
429738 429738 237071 237071 PubChem (substance) 2 39641 39641 1
429739 429739 73562 73562 PubChem (substance) 2 39641 39641 1
1008475 1008475 55922 55922 CAS Common Chemistry 3 39641 39641 1
1008476 1008476 55923 55923 CAS Common Chemistry 3 39641 39641 1
1008477 1008477 311236 311236 CAS Common Chemistry 3 39641 39641 1
1008478 1008478 73562 73562 CAS Common Chemistry 3 39641 39641 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 743.016ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website