Table: ttss_components
Columns: function_genus
shigella
salmonella
yersinia
escherichia

Question:  how many ↓ function / genus → with escherichia being espd
SQL: SELECT COUNT("function_genus") FROM ttss_components WHERE "escherichia" = 'EspD'

Question: what's the salmonella with escherichia being espd
SQL: SELECT "salmonella" FROM ttss_components WHERE "escherichia" = 'EspD'

Question: what's the ↓ function / genus → with shigella being spa32
SQL: SELECT "function_genus" FROM ttss_components WHERE "shigella" = 'Spa32'

Question: what's the salmonella with shigella being ipgc
SQL: SELECT "salmonella" FROM ttss_components WHERE "shigella" = 'IpgC'

Question: what's the salmonella with escherichia being sepb (escn)
SQL: SELECT "salmonella" FROM ttss_components WHERE "escherichia" = 'SepB (EscN)'

Question: what's the shigella with yersinia being yscp
SQL: SELECT "shigella" FROM ttss_components WHERE "yersinia" = 'YscP'