api_results

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

21 rows where query_id = 111876

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99717 99717 111876 111876 PubChem (compound) 1 4327 4327 3
130932 130932 111876 111876 PubChem (compound) 1 106246 106246 1
130936 130936 111876 111876 PubChem (compound) 1 215557 215557 2
130938 130938 111876 111876 PubChem (compound) 1 195027 195027 4
130942 130942 111876 111876 PubChem (compound) 1 271716 271716 5
436806 436806 111876 111876 PubChem (substance) 2 4327 4327 3
480053 480053 111876 111876 PubChem (substance) 2 106246 106246 1
480063 480063 111876 111876 PubChem (substance) 2 215557 215557 2
480065 480065 111876 111876 PubChem (substance) 2 195027 195027 4
480068 480068 111876 111876 PubChem (substance) 2 271716 271716 11
775229 775229 111876 111876 PubChem (substance) 2 206181 206181 5
778330 778330 111876 111876 PubChem (substance) 2 186681 186681 6
778333 778333 111876 111876 PubChem (substance) 2 243309 243309 9
778336 778336 111876 111876 PubChem (substance) 2 255552 255552 10
778340 778340 111876 111876 PubChem (substance) 2 38655 38655 7
778342 778342 111876 111876 PubChem (substance) 2 309981 309981 13
778346 778346 111876 111876 PubChem (substance) 2 263104 263104 14
778348 778348 111876 111876 PubChem (substance) 2 231887 231887 8
778351 778351 111876 111876 PubChem (substance) 2 238749 238749 12
1033197 1033197 111876 111876 CAS Common Chemistry 3 38655 38655 1
1236138 1236138 111876 111876 Computational Toxicology and Exposure Data 4 106246 106246 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)
);