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 = 87747

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
320117 320117 87747 87747 PubChem (substance) 2 49563 49563 4
433514 433514 87747 87747 PubChem (substance) 2 26506 26506 7
450399 450399 87747 87747 PubChem (substance) 2 30503 30503 24
477601 477601 87747 87747 PubChem (substance) 2 10748 10748 6
478737 478737 87747 87747 PubChem (substance) 2 31988 31988 16
544506 544506 87747 87747 PubChem (substance) 2 21100 21100 11
659515 659515 87747 87747 PubChem (substance) 2 67580 67580 18
735163 735163 87747 87747 PubChem (substance) 2 150306 150306 15
764078 764078 87747 87747 PubChem (substance) 2 119334 119334 1
764079 764079 87747 87747 PubChem (substance) 2 140034 140034 2
764080 764080 87747 87747 PubChem (substance) 2 262273 262273 3
764081 764081 87747 87747 PubChem (substance) 2 218377 218377 5
764082 764082 87747 87747 PubChem (substance) 2 155029 155029 8
764084 764084 87747 87747 PubChem (substance) 2 284644 284644 9
764085 764085 87747 87747 PubChem (substance) 2 155044 155044 10
764089 764089 87747 87747 PubChem (substance) 2 207095 207095 12
764090 764090 87747 87747 PubChem (substance) 2 230830 230830 13
764092 764092 87747 87747 PubChem (substance) 2 216598 216598 14
764094 764094 87747 87747 PubChem (substance) 2 317855 317855 17
764096 764096 87747 87747 PubChem (substance) 2 240122 240122 19
764097 764097 87747 87747 PubChem (substance) 2 276471 276471 20
764098 764098 87747 87747 PubChem (substance) 2 215617 215617 21
764099 764099 87747 87747 PubChem (substance) 2 239560 239560 22
764100 764100 87747 87747 PubChem (substance) 2 239559 239559 23
764101 764101 87747 87747 PubChem (substance) 2 241566 241566 25
1225154 1225154 87747 87747 Computational Toxicology and Exposure Data 4 119334 119334 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 451.407ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website