This function searches through Micronix tube samples in the database to find matches
based on a given DataFrame. It identifies discrepancies in positions, missing samples,
or samples that are in an archived status.
Usage
search_micronix_tube(database, micronix_search_df)
Arguments
- database
A string specifying the path to the SQLite database.
- micronix_search_df
A DataFrame containing the micronix tube samples to be searched.
The DataFrame must contain at least a 'barcode' column.
Value
A list containing three DataFrames: missing_from_db, additional_in_db, and
archived_samples. Each DataFrame provides details on samples that are missing from the
database, additional in the database but not in the search DataFrame, and samples that are
in an archived status, respectively.
