home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 181274

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
199452 199452 181274 181274 PubChem (compound) 1 168956 168956 1
199453 199453 181274 181274 PubChem (compound) 1 192084 192084 2
199454 199454 181274 181274 PubChem (compound) 1 48296 48296 3
199455 199455 181274 181274 PubChem (compound) 1 231380 231380 4
199456 199456 181274 181274 PubChem (compound) 1 188164 188164 5
199457 199457 181274 181274 PubChem (compound) 1 189154 189154 6
199458 199458 181274 181274 PubChem (compound) 1 289376 289376 7
199459 199459 181274 181274 PubChem (compound) 1 210484 210484 8
199460 199460 181274 181274 PubChem (compound) 1 133557 133557 9
199461 199461 181274 181274 PubChem (compound) 1 326426 326426 10
570024 570024 181274 181274 PubChem (substance) 2 168956 168956 1
570027 570027 181274 181274 PubChem (substance) 2 192084 192084 2
570030 570030 181274 181274 PubChem (substance) 2 48296 48296 4
570033 570033 181274 181274 PubChem (substance) 2 231380 231380 3
570036 570036 181274 181274 PubChem (substance) 2 188164 188164 5
570040 570040 181274 181274 PubChem (substance) 2 189154 189154 6
570041 570041 181274 181274 PubChem (substance) 2 289376 289376 7
570042 570042 181274 181274 PubChem (substance) 2 210484 210484 12
570043 570043 181274 181274 PubChem (substance) 2 133557 133557 8
570046 570046 181274 181274 PubChem (substance) 2 326426 326426 13
817943 817943 181274 181274 PubChem (substance) 2 137457 137457 9
823635 823635 181274 181274 PubChem (substance) 2 296218 296218 10
823636 823636 181274 181274 PubChem (substance) 2 320986 320986 11
1083570 1083570 181274 181274 CAS Common Chemistry 3 48296 48296 1
1285181 1285181 181274 181274 Computational Toxicology and Exposure Data 4 133557 133557 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 483.619ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website