Fix 'Tier' filter include results of deleted assets & minor lineage fixes

[karanh37]

Describe your changes:

Fixes #15979

Column level lineage search:

https://github.com/open-metadata/OpenMetadata/assets/33024356/e9056b0e-19e4-499d-9891-5fbd1349647e

Lineage layers

I worked on ... because ...

Type of change:

• [ ] Bug fix
• [ ] Improvement
• [ ] New feature
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [ ] Documentation

Checklist:

• [x] I have read the CONTRIBUTING document.
• [ ] My PR title is Fixes <issue-number>: <short explanation>
• [ ] I have commented on my code, particularly in hard-to-understand areas.
• [ ] For JSON Schema changes: I updated the migration scripts or explained why it is not needed.

[github-actions[bot]]

Jest test Coverage

UI tests summary

Lines	Statements	Branches	Functions
	64.74% (34578/53413)	41.67% (13599/32634)	43.46% (4243/9763)

[cypress[bot]]

31 failed tests on run #34094 ↗︎

31	283	8	0	0
⚠️ You've recorded test results over your free plan limit. Upgrade your plan to view test results.

Details:

Merge branch 'main' into feedbacks
Project: openmetadata	Commit: 024d94fc64
Status: Failed	Duration: 26:48 💡
Started: May 7, 2024 5:47 PM	Ended: May 7, 2024 7:13 PM

Review all test suite changes for PR #16120 ↗︎

[sonarqubecloud[bot]]

Quality Gate passed for 'open-metadata-ui'

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud