Skip to content

Upload Metadata...

To enrich your project with experimental assay data, affinity measurements, expression titers, physical property characterization, or custom notes, open the Edit menu and select Upload Metadata....

Supported file formats include CSV (.csv) and Excel spreadsheets (.xlsx, .xls).

Matching Methods

When uploading a metadata file, you can choose between two matching modes:

  • By Entry Name (Default): Matches rows against existing antibody candidate names in the project. The system automatically detects identifier headers such as Name, Entry, Antibody, ID, or Sequence Name (or defaults to the first column).
  • By Sequence Identity: Matches uploaded rows against the amino acid sequences of project antibodies. This is ideal when experimental or assay data comes from an external source or partner with different sample names or clone IDs.

Sequence Scope Options

When matching by sequence identity, you can specify the comparison scope:

  • Full Length (Exact Match): Requires complete full-length sequence identity against the project antibody chains.
  • Variable Domain (Fv): Automatically trims constant regions and leader peptides via AntPack before matching, comparing the variable domains (VH and VL). This allows matching files containing only Fv domains against full-length IgG project entries (or vice versa).

Column Ingestion & Duplication Handling

  • Sequence Columns: Detected sequence columns (such as Heavy Chain / Light Chain, or a single Sequence column) are used purely for matching and are not added as metadata columns.
  • Custom Metadata: All non-sequence columns (e.g., Clone ID, KD, Expression, Tm, Purity) are automatically inferred and ingested as custom metadata columns. If the uploaded file contains a column named Name, it is cleanly imported as Imported Name to prevent collisions with the primary candidate name column.
  • Shared Sequences & Multi-Entry Duplication: If an uploaded sequence matches multiple existing antibody entries (such as a shared heavy chain paired with different light chains, or duplicated clones in the project), the metadata is added to every matching candidate. The imported clone name will appear across all matching rows, making the relationship clear in the project grid.
  • Multiple Metadata Rows for the Same Sequence: If the uploaded spreadsheet contains the same sequence across multiple rows with different names or assay values (e.g., replicate screening hits or different partner clone names), their values are automatically merged onto each matching candidate, separated by semicolons (e.g. meta1; meta2 in the name column and Yo1; Yo2 in data columns).

Custom Column Configuration

Once uploaded, custom columns appear in the Project View table. You can customize column display and conditional formatting under Project Settings:

  • Conditional Severity Colors: Assign operator rules (e.g. <, >, &le;, &ge;, =) and threshold values for Good (Green), Low (Yellow), Medium (Orange), and High (Red) severity highlights.
  • Continuous Color Scaling: Toggle color scaling across numerical min-max ranges to create smooth visual heatmaps across project candidates.
  • Export Compatibility: All custom metadata columns and assigned values are included in Excel (.xlsx) and CSV project exports.