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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
113079 113079 82463 82463 PubChem (compound) 1 36302 36302 1
113080 113080 82462 82462 PubChem (compound) 1 36302 36302 1
113081 113081 132432 132432 PubChem (compound) 1 36302 36302 1
113082 113082 82465 82465 PubChem (compound) 1 36302 36302 1
455186 455186 238890 238890 PubChem (substance) 2 36302 36302 2
455187 455187 82463 82463 PubChem (substance) 2 36302 36302 1
455188 455188 236757 236757 PubChem (substance) 2 36302 36302 1
455189 455189 82462 82462 PubChem (substance) 2 36302 36302 1
455190 455190 82465 82465 PubChem (substance) 2 36302 36302 1
455191 455191 140469 140469 PubChem (substance) 2 36302 36302 4
455192 455192 132432 132432 PubChem (substance) 2 36302 36302 1
1020849 1020849 82462 82462 CAS Common Chemistry 3 36302 36302 1
1020850 1020850 82463 82463 CAS Common Chemistry 3 36302 36302 1
1020851 1020851 238890 238890 CAS Common Chemistry 3 36302 36302 1
1020852 1020852 132432 132432 CAS Common Chemistry 3 36302 36302 1
1020853 1020853 82465 82465 CAS Common Chemistry 3 36302 36302 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 2529.318ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website