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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
135448 135448 115969 115969 PubChem (compound) 1 131927 131927 1
135450 135450 115969 115969 PubChem (compound) 1 270823 270823 2
135451 135451 115969 115969 PubChem (compound) 1 55662 55662 3
135452 135452 115969 115969 PubChem (compound) 1 271315 271315 4
135453 135453 115969 115969 PubChem (compound) 1 131927 131927 5
135454 135454 115969 115969 PubChem (compound) 1 261033 261033 6
472051 472051 115969 115969 PubChem (substance) 2 53070 53070 3
486169 486169 115969 115969 PubChem (substance) 2 131927 131927 1
486170 486170 115969 115969 PubChem (substance) 2 270823 270823 4
486173 486173 115969 115969 PubChem (substance) 2 55662 55662 6
486174 486174 115969 115969 PubChem (substance) 2 271315 271315 7
486175 486175 115969 115969 PubChem (substance) 2 131927 131927 11
486177 486177 115969 115969 PubChem (substance) 2 261033 261033 13
671125 671125 115969 115969 PubChem (substance) 2 209558 209558 2
772271 772271 115969 115969 PubChem (substance) 2 326548 326548 15
782148 782148 115969 115969 PubChem (substance) 2 181117 181117 5
782150 782150 115969 115969 PubChem (substance) 2 235050 235050 8
782151 782151 115969 115969 PubChem (substance) 2 216972 216972 9
782152 782152 115969 115969 PubChem (substance) 2 250495 250495 10
782154 782154 115969 115969 PubChem (substance) 2 140811 140811 12
782155 782155 115969 115969 PubChem (substance) 2 309831 309831 14
782156 782156 115969 115969 PubChem (substance) 2 333174 333174 16
782157 782157 115969 115969 PubChem (substance) 2 333579 333579 17
782158 782158 115969 115969 PubChem (substance) 2 334435 334435 18
1036583 1036583 115969 115969 CAS Common Chemistry 3 55662 55662 1
1239551 1239551 115969 115969 Computational Toxicology and Exposure Data 4 131927 131927 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 1886.723ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website