#!/usr/bin/env python
from __future__ import print_function
from intermine.webservice import Service
service = Service("https://mines.legumeinfo.org/glycinemine/service")
query = service.new_query("Gene")
query.add_view(
            "primaryIdentifier", "name", "assemblyVersion", "annotationVersion",
                "description", "organism.name", "strain.identifier"
                )
query.add_constraint("description", "CONTAINS", "transposable", code="A")

for row in query.rows():
        print(row["primaryIdentifier"], row["name"], row["assemblyVersion"], row["annotationVersion"], \
                        row["description"], row["organism.name"], row["strain.identifier"])