Text this: Study on physicochemical status, bacterial analysis and its correlation