api_results

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

28 rows where query_id = 175867

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
194394 194394 175867 175867 PubChem (compound) 1 118805 118805 1
194395 194395 175867 175867 PubChem (compound) 1 220021 220021 2
194396 194396 175867 175867 PubChem (compound) 1 264302 264302 3
194397 194397 175867 175867 PubChem (compound) 1 238981 238981 4
194398 194398 175867 175867 PubChem (compound) 1 256339 256339 5
194399 194399 175867 175867 PubChem (compound) 1 289355 289355 6
194400 194400 175867 175867 PubChem (compound) 1 308812 308812 7
194401 194401 175867 175867 PubChem (compound) 1 320695 320695 8
561743 561743 175867 175867 PubChem (substance) 2 38328 38328 5
563600 563600 175867 175867 PubChem (substance) 2 118805 118805 1
563603 563603 175867 175867 PubChem (substance) 2 220021 220021 2
563606 563606 175867 175867 PubChem (substance) 2 264302 264302 3
563607 563607 175867 175867 PubChem (substance) 2 238981 238981 4
563610 563610 175867 175867 PubChem (substance) 2 256339 256339 8
563611 563611 175867 175867 PubChem (substance) 2 289355 289355 9
563612 563612 175867 175867 PubChem (substance) 2 308812 308812 18
563613 563613 175867 175867 PubChem (substance) 2 320695 320695 17
670822 670822 175867 175867 PubChem (substance) 2 40083 40083 11
821063 821063 175867 175867 PubChem (substance) 2 239219 239219 6
821064 821064 175867 175867 PubChem (substance) 2 240422 240422 7
821066 821066 175867 175867 PubChem (substance) 2 118805 118805 10
821068 821068 175867 175867 PubChem (substance) 2 224765 224765 12
821069 821069 175867 175867 PubChem (substance) 2 255498 255498 13
821070 821070 175867 175867 PubChem (substance) 2 260058 260058 14
821071 821071 175867 175867 PubChem (substance) 2 320392 320392 15
821072 821072 175867 175867 PubChem (substance) 2 309669 309669 16
1079990 1079990 175867 175867 CAS Common Chemistry 3 40083 40083 1
1281506 1281506 175867 175867 Computational Toxicology and Exposure Data 4 118805 118805 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)
);