home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 20393

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
45128 45128 20393 20393 PubChem (compound) 1 11091 11091 1
360106 360106 20393 20393 PubChem (substance) 2 11091 11091 1
719856 719856 20393 20393 PubChem (substance) 2 216557 216557 2
719858 719858 20393 20393 PubChem (substance) 2 137053 137053 3
719862 719862 20393 20393 PubChem (substance) 2 238966 238966 4
719865 719865 20393 20393 PubChem (substance) 2 148284 148284 5
719869 719869 20393 20393 PubChem (substance) 2 243217 243217 6
719872 719872 20393 20393 PubChem (substance) 2 239240 239240 7
719875 719875 20393 20393 PubChem (substance) 2 239190 239190 8
719877 719877 20393 20393 PubChem (substance) 2 240732 240732 9
719881 719881 20393 20393 PubChem (substance) 2 267621 267621 10
719883 719883 20393 20393 PubChem (substance) 2 274014 274014 11
719885 719885 20393 20393 PubChem (substance) 2 320533 320533 12
719887 719887 20393 20393 PubChem (substance) 2 294528 294528 13
719889 719889 20393 20393 PubChem (substance) 2 200126 200126 14
719891 719891 20393 20393 PubChem (substance) 2 320762 320762 15
719892 719892 20393 20393 PubChem (substance) 2 217171 217171 16
719894 719894 20393 20393 PubChem (substance) 2 329602 329602 17
970892 970892 20393 20393 CAS Common Chemistry 3 11091 11091 1
1173414 1173414 20393 20393 Computational Toxicology and Exposure Data 4 11091 11091 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 414.765ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website