Dear Yue, if you are interested on trade of intermediate goods and global production chains, you can take a look in OECD´s trade in value added database:
There is a database for trade in resources with a breakdown by type (agriculture, fertilizers, forestry products, fuels, metals & minerals, gemstones):
https://resourcetrade.earth
Also, you may also download the data on intermediate products directly from Comtrade (only be sure to choose BEC classifier):