home / zeropm-v0-0-4

api_results

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

15 rows where inchi_id = 39846

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
153929 153929 133845 133845 PubChem (compound) 1 39846 39846 1
153930 153930 133846 133846 PubChem (compound) 1 39846 39846 1
153931 153931 411122 411122 PubChem (compound) 1 39846 39846 1
510384 510384 23517 23517 PubChem (substance) 2 39846 39846 5
510385 510385 411122 411122 PubChem (substance) 2 39846 39846 1
510386 510386 123099 123099 PubChem (substance) 2 39846 39846 2
510387 510387 133845 133845 PubChem (substance) 2 39846 39846 1
510388 510388 123100 123100 PubChem (substance) 2 39846 39846 2
510389 510389 133846 133846 PubChem (substance) 2 39846 39846 1
1050657 1050657 411122 411122 CAS Common Chemistry 3 39846 39846 1
1050658 1050658 133846 133846 CAS Common Chemistry 3 39846 39846 1
1050659 1050659 133845 133845 CAS Common Chemistry 3 39846 39846 1
1253416 1253416 133845 133845 Computational Toxicology and Exposure Data 4 39846 39846 1
1253417 1253417 411122 411122 Computational Toxicology and Exposure Data 4 39846 39846 1
1253418 1253418 133846 133846 Computational Toxicology and Exposure Data 4 39846 39846 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 434.545ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website