home / zeropm-v0-0-4

api_results

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

30 rows where query_id = 78663

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
111192 111192 78663 78663 PubChem (compound) 1 44085 44085 1
452656 452656 78663 78663 PubChem (substance) 2 44085 44085 1
715655 715655 78663 78663 PubChem (substance) 2 136707 136707 2
760124 760124 78663 78663 PubChem (substance) 2 184453 184453 17
760125 760125 78663 78663 PubChem (substance) 2 180081 180081 3
760129 760129 78663 78663 PubChem (substance) 2 208877 208877 4
760130 760130 78663 78663 PubChem (substance) 2 264395 264395 7
760133 760133 78663 78663 PubChem (substance) 2 320451 320451 19
760137 760137 78663 78663 PubChem (substance) 2 222100 222100 22
760139 760139 78663 78663 PubChem (substance) 2 291837 291837 24
760142 760142 78663 78663 PubChem (substance) 2 217790 217790 25
760145 760145 78663 78663 PubChem (substance) 2 240118 240118 5
760146 760146 78663 78663 PubChem (substance) 2 195594 195594 6
760147 760147 78663 78663 PubChem (substance) 2 170225 170225 8
760148 760148 78663 78663 PubChem (substance) 2 170226 170226 9
760149 760149 78663 78663 PubChem (substance) 2 204674 204674 10
760150 760150 78663 78663 PubChem (substance) 2 202937 202937 11
760151 760151 78663 78663 PubChem (substance) 2 170575 170575 12
760152 760152 78663 78663 PubChem (substance) 2 195396 195396 13
760153 760153 78663 78663 PubChem (substance) 2 195564 195564 14
760154 760154 78663 78663 PubChem (substance) 2 195691 195691 15
760155 760155 78663 78663 PubChem (substance) 2 207015 207015 16
760156 760156 78663 78663 PubChem (substance) 2 140504 140504 18
760157 760157 78663 78663 PubChem (substance) 2 261516 261516 20
760158 760158 78663 78663 PubChem (substance) 2 234179 234179 21
760159 760159 78663 78663 PubChem (substance) 2 291835 291835 23
760160 760160 78663 78663 PubChem (substance) 2 320181 320181 26
760161 760161 78663 78663 PubChem (substance) 2 291998 291998 27
1019545 1019545 78663 78663 CAS Common Chemistry 3 44085 44085 1
1221930 1221930 78663 78663 Computational Toxicology and Exposure Data 4 129979 129979 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 446.963ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website