A plain-English explanation of the number, the green certificate and the residence card.
The NIE is the number. EU citizens get a green certificate; non-EU citizens get a TIE card. All three are commonly — and confusingly — called "the NIE".
If you are non-EU and living in Mallorca long-term, you will ultimately need a TIE card that displays your NIE number.