home / zeropm-v0-0-4

api_results

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

23 rows where inchi_id = 42677

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
155133 155133 338618 338618 PubChem (compound) 1 42677 42677 1
155134 155134 135013 135013 PubChem (compound) 1 42677 42677 1
155135 155135 310832 310832 PubChem (compound) 1 42677 42677 1
155136 155136 361220 361220 PubChem (compound) 1 42677 42677 1
155137 155137 135012 135012 PubChem (compound) 1 42677 42677 1
511944 511944 135013 135013 PubChem (substance) 2 42677 42677 1
511945 511945 21168 21168 PubChem (substance) 2 42677 42677 4
511946 511946 354663 354663 PubChem (substance) 2 42677 42677 4
511947 511947 135012 135012 PubChem (substance) 2 42677 42677 1
511948 511948 338618 338618 PubChem (substance) 2 42677 42677 1
511949 511949 310832 310832 PubChem (substance) 2 42677 42677 1
511950 511950 355774 355774 PubChem (substance) 2 42677 42677 2
511951 511951 361220 361220 PubChem (substance) 2 42677 42677 1
1051609 1051609 135012 135012 CAS Common Chemistry 3 42677 42677 1
1051610 1051610 338618 338618 CAS Common Chemistry 3 42677 42677 1
1051611 1051611 361220 361220 CAS Common Chemistry 3 42677 42677 1
1051612 1051612 135013 135013 CAS Common Chemistry 3 42677 42677 1
1051613 1051613 310832 310832 CAS Common Chemistry 3 42677 42677 1
1254328 1254328 135012 135012 Computational Toxicology and Exposure Data 4 42677 42677 1
1254329 1254329 338618 338618 Computational Toxicology and Exposure Data 4 42677 42677 1
1254330 1254330 361220 361220 Computational Toxicology and Exposure Data 4 42677 42677 1
1254331 1254331 135013 135013 Computational Toxicology and Exposure Data 4 42677 42677 1
1254332 1254332 310832 310832 Computational Toxicology and Exposure Data 4 42677 42677 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 1361.293ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website