I am trying to isolate some import errors due to a mis-matched species during an import. I am aware of a instance where a lichen was inadvertently matched against a butterfly - thus leading to lots of records of the lichen rather than the butterfly.

I have fixed these records as there were relatively few and they were easy to find. But this led me to wonder whether there were other bad matches in the database, and I have uncovered some more.

The IW_Matched_Species table includes a field 'Match_Checklist_Key' - which I assumed to be the TAXON_LIST key or the TAXON_LIST_VERSION key, but this does not appear to be the case since the example below would imply that Cuckoo had been matched to a Fungus, when in fact the Matched_Key is indeed the TLIK for Cuckoo:

Matched_Value    Matched_Key    Match_Checklist_Key    Temp_User_ID    IW_Matched_Species_Id
Cuculus canorus    NHMSYS0000529061    BMSSYS0000000001        7148

I had hoped I could use this match_checklist_key to quickly determine whether a name had been matched to something in the wrong taxonomic group, but I guess this is not the case?