api_results

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

10 rows where query_id = 119516

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
491185 491185 119516 119516 PubChem (substance) 2 151346 151346 1
619051 619051 119516 119516 PubChem (substance) 2 77991 77991 4
676388 676388 119516 119516 PubChem (substance) 2 250618 250618 3
784392 784392 119516 119516 PubChem (substance) 2 250618 250618 2
784394 784394 119516 119516 PubChem (substance) 2 260639 260639 5
784395 784395 119516 119516 PubChem (substance) 2 266912 266912 6
784397 784397 119516 119516 PubChem (substance) 2 83420 83420 7
784398 784398 119516 119516 PubChem (substance) 2 310113 310113 8
1039606 1039606 119516 119516 CAS Common Chemistry 3 83420 83420 1
1242595 1242595 119516 119516 Computational Toxicology and Exposure Data 4 126351 126351 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)
);