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)