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).
Upload Workflow
- File Selection: Select a
.csvor.xlsxfile from your local machine. - Identifier Matching: The system automatically detects the antibody identifier column by looking for headers such as
Name,Entry,Antibody,ID, orSequence Name(or defaults to the first column). Metadata rows are matched against existing antibody entries in the project. - Automatic Schema Inference: Data types (
Integer,Float, orText) are automatically inferred for each column. - Column Persistence: New custom columns are created and registered in the project's metadata schema. Existing column values for matched antibodies are updated.
- Notes Integration: If a
Notescolumn is present in the uploaded file, its text will update or append to the corresponding antibody notes.
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.
<,>,≤,≥,=) 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.