api_results

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

18 rows where query_id = 13304

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
27157 27157 13304 13304 PubChem (compound) 1 124775 124775 1
334428 334428 13304 13304 PubChem (substance) 2 124775 124775 1
710833 710833 13304 13304 PubChem (substance) 2 136363 136363 2
710846 710846 13304 13304 PubChem (substance) 2 188222 188222 3
710851 710851 13304 13304 PubChem (substance) 2 234906 234906 15
710853 710853 13304 13304 PubChem (substance) 2 167886 167886 4
710856 710856 13304 13304 PubChem (substance) 2 195854 195854 5
710858 710858 13304 13304 PubChem (substance) 2 195861 195861 6
710861 710861 13304 13304 PubChem (substance) 2 196810 196810 7
710863 710863 13304 13304 PubChem (substance) 2 197811 197811 8
710865 710865 13304 13304 PubChem (substance) 2 186015 186015 9
710869 710869 13304 13304 PubChem (substance) 2 184229 184229 10
710872 710872 13304 13304 PubChem (substance) 2 207732 207732 11
710873 710873 13304 13304 PubChem (substance) 2 207734 207734 12
710875 710875 13304 13304 PubChem (substance) 2 207735 207735 13
710879 710879 13304 13304 PubChem (substance) 2 195856 195856 14
958100 958100 13304 13304 CAS Common Chemistry 3 47699 47699 1
1158426 1158426 13304 13304 Computational Toxicology and Exposure Data 4 124775 124775 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)
);