home / zeropm-v0-0-4

api_results

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

21 rows where inchi_id = 42635

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
6006 6006 71759 71759 PubChem (compound) 1 42635 42635 1
6007 6007 3197 3197 PubChem (compound) 1 42635 42635 1
6008 6008 3199 3199 PubChem (compound) 1 42635 42635 1
6009 6009 3200 3200 PubChem (compound) 1 42635 42635 1
6010 6010 3198 3198 PubChem (compound) 1 42635 42635 1
303868 303868 3198 3198 PubChem (substance) 2 42635 42635 1
303869 303869 84807 84807 PubChem (substance) 2 42635 42635 8
303870 303870 3197 3197 PubChem (substance) 2 42635 42635 1
303871 303871 3199 3199 PubChem (substance) 2 42635 42635 1
303872 303872 3200 3200 PubChem (substance) 2 42635 42635 1
303873 303873 371207 371207 PubChem (substance) 2 42635 42635 8
303874 303874 71757 71757 PubChem (substance) 2 42635 42635 2
303875 303875 71759 71759 PubChem (substance) 2 42635 42635 1
303876 303876 359975 359975 PubChem (substance) 2 42635 42635 8
942564 942564 3199 3199 CAS Common Chemistry 3 42635 42635 1
942565 942565 71756 71756 CAS Common Chemistry 3 42635 42635 1
942566 942566 3197 3197 CAS Common Chemistry 3 42635 42635 1
942567 942567 71759 71759 CAS Common Chemistry 3 42635 42635 1
1140074 1140074 71756 71756 Computational Toxicology and Exposure Data 4 42635 42635 1
1140075 1140075 3197 3197 Computational Toxicology and Exposure Data 4 42635 42635 1
1140076 1140076 3199 3199 Computational Toxicology and Exposure Data 4 42635 42635 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 1825.128ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website