# SV_by_gene.csv

List of genes affected by structural variants, per sample.

This table takes the structural_variants.csv table and extracts all the gene
names associated with any of the high-confidence structural variants, and
annotates which column the gene was found in (if the gene was found in the
Cancer census list, was in DisruptL, DisruptR, etc).

Note: if the same gene appeared in more than one fusion event, the row will
be duplicated, with the only difference being in what fusion events are
listed in the "fusion" column.

# Columns:
DNANum {varchar} = DNANumber identifying unique samples to tie with other
    data tables
gene {varchar} = gene name
Cancer_census/Contained/DisruptL/DisruptR/Intronic/ClosestL/ClosestR {bool} =
    True if at least one SV breakpoint affected this gene in this sample, as
    found in these columns of the structural_variants.csv table.
fusion {varchar} = list the fusion gene events from the "Fusion" column of the
    structural_variants.csv table, otherwise has an empty string "".
fused_genes {varchar} = a comma separated list of genes appearing in the fusion
    event.