sdf-compound-structure-parsing
License: restricted — no clear open-source license detected for the underlying tool; verify licensing before commercial use or redistribution.
Summary
Parse and extract molecular structure and metadata from SDF-format compound databases to enable cross-referencing with fragment records and validation of compound identifiers. This skill is essential when working with DNA adduct reference databases where fragment entries must be matched to their parent compound records.
When to use
When you have fragment records (experimental or predicted) with compound identifiers or cross-reference fields that need to be validated against a reference compound database in SDF format. Specifically, use this skill when you need to confirm that every fragment in your fragment databases has a corresponding parent compound entry in the reference compound collection.
When NOT to use
- When fragment records do not contain compound identifiers or cross-reference fields to match against
- When the compound database is not in SDF format (e.g., already in Excel or Word format without structure data needed for this validation)
- When your goal is to perform molecular structure similarity or structural analysis rather than identifier validation
Inputs
- SDF-format compound database file containing DNA adduct reference compounds
- Experimental fragment database records (with compound identifiers or cross-reference fields)
- Predicted fragment database records (with compound identifiers or cross-reference fields)
Outputs
- Indexed lookup table of compound identifiers from SDF file
- Validation report documenting total fragments retrieved, successfully matched compounds, orphaned fragments, and matching success rate
- List of orphaned fragments lacking parent compound entries
How to apply
Load the SDF-format compound database using a molecular structure library or SDF parser. Extract the compound identifier field from each record in the SDF file and build an indexed lookup table. For each fragment record in your experimental or predicted fragment database, retrieve its compound identifier and query the lookup table to verify a match exists. Track successful matches, orphaned fragments (those lacking a parent compound), and calculate the overall matching success rate. Generate a validation report documenting total fragments retrieved, number successfully matched to compounds, any unmatched fragments, and the success percentage to assess data integrity.
Related tools
- SDF file parser / molecular structure library (Parse SDF format compound records, extract identifiers and metadata for lookup and cross-referencing)
Evaluation signals
- All compound identifiers extracted from SDF file are unique and indexed correctly without duplicates
- Every fragment record in both experimental and predicted databases receives a matching attempt against the SDF lookup table
- The validation report accounts for 100% of input fragments (successfully matched + orphaned = total retrieved)
- Matching success rate is documented with explicit counts: total fragments, successful matches, and unmatched count
- Orphaned fragments (if any) are explicitly listed with their identifiers for manual inspection and database correction
Limitations
- Compound identifier format must match exactly between fragment records and SDF file entries; format inconsistencies (leading zeros, case sensitivity, whitespace) will cause false non-matches
- SDF parser performance may degrade with very large compound databases; indexing strategy and memory management become critical
- Cross-reference fields in fragment databases may be missing, malformed, or inconsistent, requiring data cleaning prior to validation
- No changelog is available to track whether the reference compound database has been updated, potentially causing stale matches
Evidence
- [other] Load the SDF-format compound database containing the DNA adduct reference compounds: "Load the SDF-format compound database containing the DNA adduct reference compounds."
- [other] Extract compound identifier and validate against reference database: "For each fragment record in both experimental and predicted databases, extract the compound identifier or cross-reference field. Validate that each compound identifier present in the fragment"
- [other] Generate validation report with matching metrics: "Generate a validation report documenting the total number of fragments retrieved, the number successfully matched to compounds, any orphaned fragments lacking a parent compound entry, and the overall"
- [intro] Multiple formats available for DNA adductomics database: "The DNA adduct database in Excel format, Word format, online, compound database in SDF format"
- [other] Tool for SDF parsing and molecular structures: "tools: SDF file parser / molecular structure library"
1---2name: sdf-compound-structure-parsing3description: Use when when you have fragment records (experimental or predicted) with compound identifiers or cross-reference fields that need to be validated against a reference compound database in SDF format.4license: CC-BY-4.05---67# sdf-compound-structure-parsing89> **License: restricted** — no clear open-source license detected for the underlying tool; verify licensing before commercial use or redistribution. <!-- asb-license-banner -->10## Summary1112Parse and extract molecular structure and metadata from SDF-format compound databases to enable cross-referencing with fragment records and validation of compound identifiers. This skill is essential when working with DNA adduct reference databases where fragment entries must be matched to their parent compound records.1314## When to use1516When you have fragment records (experimental or predicted) with compound identifiers or cross-reference fields that need to be validated against a reference compound database in SDF format. Specifically, use this skill when you need to confirm that every fragment in your fragment databases has a corresponding parent compound entry in the reference compound collection.1718## When NOT to use1920- When fragment records do not contain compound identifiers or cross-reference fields to match against21- When the compound database is not in SDF format (e.g., already in Excel or Word format without structure data needed for this validation)22- When your goal is to perform molecular structure similarity or structural analysis rather than identifier validation2324## Inputs2526- SDF-format compound database file containing DNA adduct reference compounds27- Experimental fragment database records (with compound identifiers or cross-reference fields)28- Predicted fragment database records (with compound identifiers or cross-reference fields)2930## Outputs3132- Indexed lookup table of compound identifiers from SDF file33- Validation report documenting total fragments retrieved, successfully matched compounds, orphaned fragments, and matching success rate34- List of orphaned fragments lacking parent compound entries3536## How to apply3738Load the SDF-format compound database using a molecular structure library or SDF parser. Extract the compound identifier field from each record in the SDF file and build an indexed lookup table. For each fragment record in your experimental or predicted fragment database, retrieve its compound identifier and query the lookup table to verify a match exists. Track successful matches, orphaned fragments (those lacking a parent compound), and calculate the overall matching success rate. Generate a validation report documenting total fragments retrieved, number successfully matched to compounds, any unmatched fragments, and the success percentage to assess data integrity.3940## Related tools4142- **SDF file parser / molecular structure library** (Parse SDF format compound records, extract identifiers and metadata for lookup and cross-referencing)4344## Evaluation signals4546- All compound identifiers extracted from SDF file are unique and indexed correctly without duplicates47- Every fragment record in both experimental and predicted databases receives a matching attempt against the SDF lookup table48- The validation report accounts for 100% of input fragments (successfully matched + orphaned = total retrieved)49- Matching success rate is documented with explicit counts: total fragments, successful matches, and unmatched count50- Orphaned fragments (if any) are explicitly listed with their identifiers for manual inspection and database correction5152## Limitations5354- Compound identifier format must match exactly between fragment records and SDF file entries; format inconsistencies (leading zeros, case sensitivity, whitespace) will cause false non-matches55- SDF parser performance may degrade with very large compound databases; indexing strategy and memory management become critical56- Cross-reference fields in fragment databases may be missing, malformed, or inconsistent, requiring data cleaning prior to validation57- No changelog is available to track whether the reference compound database has been updated, potentially causing stale matches5859## Evidence6061- [other] Load the SDF-format compound database containing the DNA adduct reference compounds: "Load the SDF-format compound database containing the DNA adduct reference compounds."62- [other] Extract compound identifier and validate against reference database: "For each fragment record in both experimental and predicted databases, extract the compound identifier or cross-reference field. Validate that each compound identifier present in the fragment"63- [other] Generate validation report with matching metrics: "Generate a validation report documenting the total number of fragments retrieved, the number successfully matched to compounds, any orphaned fragments lacking a parent compound entry, and the overall"64- [intro] Multiple formats available for DNA adductomics database: "The DNA adduct database in Excel format, Word format, online, compound database in SDF format"65- [other] Tool for SDF parsing and molecular structures: "tools: SDF file parser / molecular structure library"
HolobiomicsLab