WtMTA-db
Data license: ODbL · Data source: Larue & Roy, 2023
Queries
- BED-format introns (by taxid + adjusted_score band)
- Minor (U12-type) introns for one genome
- Most U12-like introns for one genome (ranked by raw motif score)
Tables
genomes
taxonomy_id, species, common_name, group, phylum, order, family, u12_status, n_minor_introns, percent_minor_introns, u12_density_percentile, n_u12_all, n_major_introns, motif_category, z_excess, hc_u12_cds, hc_u12_exon, snrna_status, minor_snrnas, n_minor_snrna, u11_E, u12_E, u4atac_E, u6atac_E, total_genes, total_introns_scored, genome_size_bp, gc_content, coding_gc_content, n_contigs, assembly_n50, assembly_l50, busco_score, accession, genome_version, source, assembly_url, ncbi_taxonomy_url, wikipedia_url, common_name_level, taxonomy, genome_path, annotation_path
2,634 rows
introns
id, taxonomy_id, transcript_id, chromosome, start, end, strand, length, ordinal_index, num_child_introns, relative_position, phase, in_cds, dinucleotide_pair, is_high_confidence_minor, type_id, adjusted_score, rel_score, p_motif, svm_score, motif_category, exon5_flank, five_ss_seq, bps_seq, three_ss_seq, exon3_flank, bp_offset, five_raw_score, bp_raw_score, three_raw_score, decision_distance, ensemble_sigma, p_adj, bp_scan_confidence, ppt_raw_score, ppt_ct, ppt_longest_run, ppt_t_weighted, core_three_raw_score, fit_u12, fit_u2, fit_u12_five, fit_u12_bp, fit_u12_three, min_fit_bp_three
346,921,077 rows
minor_introns
id, taxonomy_id, transcript_id, chromosome, start, end, strand, length, ordinal_index, num_child_introns, relative_position, phase, in_cds, dinucleotide_pair, is_high_confidence_minor, type_id, adjusted_score, rel_score, p_motif, svm_score, motif_category, exon5_flank, five_ss_seq, bps_seq, three_ss_seq, exon3_flank, bp_offset
1,005,866 rows
transcripts
id, taxonomy_id, transcript_id, gene_id, chromosome, strand, start, end, coding_length, introns_per_kbp_cds, n_introns, n_minor_introns, proportion_minor_introns
51,752,125 rows
... and 14 hidden tables
Download SQLite DB: WtMTA-db.db 149.8 GB