Content_text is the text crawled by Ektron search providers such as Solr and Microsoft Search Server. Other columns are crawled as well, but only content_text is searched by the keyword search. Other properties such as metadata can be searched using expression trees. For more on querying, see the following document.
Search API