ImmunoResource
Tables (10)
IGV Viewer (IGV)
- IGV file (igv_id) — VARCHAR(20) — Primary key — NOT NULL
- Screenshot (igv_screenshot) — VARCHAR(100)
- RNA_Id (rna_id) — INT — Foreign key → RNA Contig.RNA Id — NOT NULL
MHC-Binding (MHCbinding)
- HLA Allele (allele) — VARCHAR(100) — Primary key — NOT NULL
- Peptide Sequence (peptide_sequence) — VARCHAR(20) — Foreign key → Peptide Information.Peptide Sequence — NOT NULL
- Sample Id (sample_id) — INT — Foreign key → Sample Information.Sample Id — NOT NULL
- IsBinder (is_binder) — Boolean
- netMHCpan EL-Rank (NetMHCpan) — FLOAT
- STMHCpan Score (STMHCpan) — INT
- TransPHLA Score (TransPHLA) — INT
Peptide Information (Peptide)
- Peptide Sequence (peptide_sequence) — VARCHAR(20) — Primary key — NOT NULL
- Length (peptide_length) — int(10) — NOT NULL
- Canonical/Non canonical (is_canonical) — VARCHAR(20)
- pXg Version (pxg_version) — VARCHAR(20)
Peptide RNA-contig Spectrum Match (PRSM)
- PSM Id (psm_id) — INT — Foreign key → peptide - spectrum.PSM Id — NOT NULL
- RNA Id (rna_id) — INT — Foreign key → RNA Contig.RNA Id — NOT NULL
- Peptide Sequence (peptide_sequence) — VARCHAR(20) — Foreign key → Peptide Information.Peptide Sequence — NOT NULL
- Events (events) — VARHCAR(100)
RNA Contig (RNA)
- RNA Id (rna_id) — INT — Primary key — NOT NULL
- Genomic Position (genomic_loci) — VARHCAR(100)
- MeanQScore (mean_q_score) — float
- Gene Names (gene_names) — VARCHAR(100)
- Mutation (gene_mutation) — VARCHAR(100)
- Mutation Status (mutation_status) — VARCHAR(100)
- Observed LeftFlankNtseq (observed_leftflank_nt) — VARHCAR(1000)
- Observed Nucleotide Sequence (observed_nt) — VARHCAR(1000)
- Observed RightFlankNtseq (observed_rightflank_nt) — VARHCAR(1000)
- Reference LeftFlankNtseq (reference_leftflank_nt) — VARHCAR(1000)
- Reference Nucleotide Sequence (reference_nt) — VARCHAR(1000)
- Reference RightFlankNtseq (reference_rightflank_nt) — VARCHAR(1000)
- RNA-seq Raw file id (rna_raw_id) — VARCHAR(20) — Foreign key → RNA-seq Raw file source.RNA-seq Raw file id — NOT NULL
- Read Count (read_count)
- GeneIDs (gene_id)
RNA-seq Raw file source (RNAseqsource)
- RNA-seq Raw file id (rna_raw_id) — VARCHAR(20) — Primary key — NOT NULL
- RNA-seq source accession code (rna_accession code) — VARCHAR(100)
- Sample Id (sample_id) — INT — Foreign key → Sample Information.Sample Id — NOT NULL
Sample Information (Sample)
- Sample Id (sample_id) — INT — Primary key — NOT NULL
- HLA Type (HLA_type) — INT
- Sample Type (sample_type) — VARCHAR(20)
- Disease (disease) — VARCHAR(100)
- Sample Name (sample_name) — VARCHAR(100)
- HLA alleles (hla_alleles) — VARCHAR(20)
- Species (sample_species) — VARCHAR(20)
Spectrum
- Spectrum Id (spectrum_id) — VARCHAR(20) — Primary key — NOT NULL
- Experiment Spectrum (exp_spectrum) — VARCHAR(1000)
- Scan number (spectrum_scan) — int(10)
- Mass (spectrum_mass) — float
- Charge (spectrum_charge) — int(10)
- Retention time (spectrum_rt) — float
- MS/MS Raw file id (msms_raw_id) — VARCHAR(20) — Foreign key → Spectrum Raw file.MS/MS Raw file id — NOT NULL
- Mode (mode) — VARCHAR(20)
- Precursor tolerance (precursor_tol) — VARCHAR(20)
- Fragment tolerance (fragment_tol) — VARCHAR(20)
Spectrum Raw file (MSMSsource)
- MS/MS Raw file id (msms_raw_id) — VARCHAR(20) — Primary key — NOT NULL
- MS/MS Raw file name (msms_file_name) — VARCHAR(100)
- MS/MS file accession code (msms_code) — VARCHAR(100)
- Sample Id (sample_id) — INT — Foreign key → Sample Information.Sample Id — NOT NULL
peptide - spectrum (PSM)
- PSM Id (psm_id) — INT — Primary key — NOT NULL
- Spectrum Id (spectrum_id) — INT — Foreign key → Spectrum.Spectrum Id — NOT NULL
- Peptide Sequence (peptide_sequence) — VARCHAR(20) — Foreign key → Peptide Information.Peptide Sequence — NOT NULL
- P-value (p_value) — float
- Search Score (search_score) — float
- FDR Stage (fdr_stage) — VARCHAR(20)
- q-value — float
- SA Score (SA) — float
- DeltaRT (dRT) — float
- Search tool (search_tool)