home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 123190

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
45129 45129 123190 123190 PubChem (compound) 1 11091 11091 1
360107 360107 123190 123190 PubChem (substance) 2 11091 11091 1
405268 405268 123190 123190 PubChem (substance) 2 173801 173801 9
460213 460213 123190 123190 PubChem (substance) 2 219140 219140 22
643835 643835 123190 123190 PubChem (substance) 2 186649 186649 13
719857 719857 123190 123190 PubChem (substance) 2 216557 216557 2
719859 719859 123190 123190 PubChem (substance) 2 137053 137053 3
719864 719864 123190 123190 PubChem (substance) 2 238966 238966 4
719867 719867 123190 123190 PubChem (substance) 2 148284 148284 5
719870 719870 123190 123190 PubChem (substance) 2 243217 243217 17
719871 719871 123190 123190 PubChem (substance) 2 239240 239240 15
719874 719874 123190 123190 PubChem (substance) 2 239190 239190 8
719878 719878 123190 123190 PubChem (substance) 2 240732 240732 16
719880 719880 123190 123190 PubChem (substance) 2 267621 267621 7
719884 719884 123190 123190 PubChem (substance) 2 274014 274014 11
719886 719886 123190 123190 PubChem (substance) 2 320533 320533 14
719888 719888 123190 123190 PubChem (substance) 2 294528 294528 19
719890 719890 123190 123190 PubChem (substance) 2 200126 200126 20
719893 719893 123190 123190 PubChem (substance) 2 217171 217171 23
787521 787521 123190 123190 PubChem (substance) 2 195651 195651 6
787522 787522 123190 123190 PubChem (substance) 2 188270 188270 10
787523 787523 123190 123190 PubChem (substance) 2 183932 183932 12
787524 787524 123190 123190 PubChem (substance) 2 240920 240920 18
787525 787525 123190 123190 PubChem (substance) 2 310244 310244 21
970893 970893 123190 123190 CAS Common Chemistry 3 11091 11091 1
1173416 1173416 123190 123190 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 465.021ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website