api_results

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

14 rows where query_id = 1394

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
2646 2646 1394 1394 PubChem (compound) 1 36775 36775 1
299203 299203 1394 1394 PubChem (substance) 2 36775 36775 1
479380 479380 1394 1394 PubChem (substance) 2 35702 35702 6
646709 646709 1394 1394 PubChem (substance) 2 135599 135599 5
656269 656269 1394 1394 PubChem (substance) 2 157515 157515 3
694214 694214 1394 1394 PubChem (substance) 2 137918 137918 2
694224 694224 1394 1394 PubChem (substance) 2 219149 219149 4
694228 694228 1394 1394 PubChem (substance) 2 258935 258935 7
694229 694229 1394 1394 PubChem (substance) 2 242180 242180 8
694233 694233 1394 1394 PubChem (substance) 2 196744 196744 9
694236 694236 1394 1394 PubChem (substance) 2 207013 207013 10
694238 694238 1394 1394 PubChem (substance) 2 320878 320878 11
940017 940017 1394 1394 CAS Common Chemistry 3 36775 36775 1
1137074 1137074 1394 1394 Computational Toxicology and Exposure Data 4 36775 36775 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)
);