CREATE TABLE table_name_41 (genbank_id VARCHAR2, variant_id VARCHAR2)

Which genbank id's variant is abd1a?
SELECT genbank_id FROM table_name_41 WHERE variant_id = "abd1a"
SELECT "genbank_id" FROM "table_name_41" WHERE "abd1a" = "variant_id"