# List files in a package
rpm -ql PACKAGE

# What package does a file belong to?
rpm -qf FILE        # in currently installed packages
yum provides FILE   # in all packages

# Print a list of manually installed packages
# credits: http://forums.fedoraforum.org/showpost.php?p=1606568&postcount=12
yumdb search command_line "*install*" | grep command_line | sed 's/.*install//' | tr ' ' '\n' | sort -u