Yellow snot has tiny streaks of blood (for months). Clear snot has no blood streaks. Cancer? Symptoms include picking nose daily.

Sounds pretty normal. This is common to simple nasal irritation from dusts or allergens. Nose picking will often result in damage to the tiny capillaries in the nasal membranes. Your doc can confirm or exclude these suspicions.