Table: bacterial_genomes
Columns: species
strain
type
base_pairs
genes
reference

Question: what is the reference when the strain is msb8?
SQL: SELECT "reference" FROM bacterial_genomes WHERE "strain" = 'msb8'

Question: what is the average genes when the reference is 2009 and the strain is rku-1?
SQL: SELECT AVG("genes") FROM bacterial_genomes WHERE "reference" = '2009' AND "strain" = 'rku-1'