* Literally: If you're talking about honey production, the opposite could be sterile, barren, or unproductive.
* Figuratively: If you're talking about something that is sweet or pleasant, the opposite could be bitter, harsh, unpleasant, acrimonious, or unpalatable.
The best opposite will depend on the specific meaning of "melliferous" in the context you are using it.