introns
Data license: ODbL · Data source: Larue & Roy, 2023 · About: Minor Intron Database (WtMTA)
- id
- INTEGER (primary key), globally unique identifier for each intron
- dinucleotide_pair
- TEXT, terminal dinucleotide sequences of the intron
- is_minor
- INTEGER, indicates if the intron is a minor intron (1) or not (0)
- score
- REAL, score representing the probability (0-100%) of the intron being minor
- length
- INTEGER, length of the intron in base pairs
- transcript_id
- INTEGER (foreign key referencing transcripts(id)), parent transcript
- ordinal_index
- INTEGER, ordinal position of the intron within the transcript (e.g., 3 for the third intron)
- start
- INTEGER, start position of the intron in the genome
- end
- INTEGER, end position of the intron in the genome
- taxonomy_id
- INTEGER (foreign key referencing genomes(taxonomy_id)), NCBI taxonomy identifier for species
- scored_motifs
- TEXT, motifs scored for the intron
- phase
- INTEGER, phase of the intron in coding sequence (0, 1, or 2 or null for introns outside of coding sequence)
- in_cds
- INTEGER, indicates if the intron is within the coding sequence (1) or not (0; e.g., UTR introns)
- relative_position
- REAL, relative position of the intron within the transcript (as a percentage of coding length)
18 rows where transcript_id = 17285652
This data as json, CSV (advanced)
Suggested facets: dinucleotide_pair, score, length, phase, in_cds
id ▼ | dinucleotide_pair | is_minor | score | length | transcript_id | ordinal_index | start | end | taxonomy_id | scored_motifs | phase | in_cds | relative_position |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92353915 | GT-AG | 0 | 0.000105600094027 | 59 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 2 | 811994 | 812052 | Hesseltinella vesiculosa 101127 | CGA|GTAAGCTGTT...CCATCCAAAATG/TCGATGCTAACT...CTTAG|CTA | 0 | 1 | 2.217 |
92353916 | GT-CA | 0 | 1.000000099473604e-05 | 177 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 3 | 811755 | 811931 | Hesseltinella vesiculosa 101127 | AAC|GTAAGGCCCT...CTAACCTTATTT/ACTAACCTTATT...CTTCA|AGT | 2 | 1 | 2.989 |
92353917 | GT-AG | 0 | 5.410635472821034e-05 | 88 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 4 | 811582 | 811669 | Hesseltinella vesiculosa 101127 | AAG|GTATTTAAAA...CAAACCTAACCA/TCAAACCTAACC...CATAG|ACT | 0 | 1 | 4.048 |
92353918 | GT-AG | 0 | 1.000000099473604e-05 | 56 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 5 | 810943 | 810998 | Hesseltinella vesiculosa 101127 | TCG|GTAAAGTAGA...AAATTCTCACCT/AAAATTCTCACC...CATAG|AAT | 1 | 1 | 11.309 |
92353919 | GT-AG | 0 | 1.000000099473604e-05 | 67 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 6 | 810577 | 810643 | Hesseltinella vesiculosa 101127 | AAG|GTAGGAAGAC...GTCTTTTTACAA/CGTCTTTTTACA...GTTAG|ACG | 0 | 1 | 15.033 |
92353920 | GT-AG | 0 | 1.000000099473604e-05 | 69 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 7 | 809524 | 809592 | Hesseltinella vesiculosa 101127 | CAA|GTAAAAGCGA...GTTACCTGACCT/TGTTACCTGACC...CATAG|GAT | 0 | 1 | 27.289 |
92353921 | GT-AG | 0 | 1.000000099473604e-05 | 106 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 8 | 808266 | 808371 | Hesseltinella vesiculosa 101127 | TTG|GTAAAGCTAC...TATCTTTTAATT/TATCTTTTAATT...TCTAG|AAT | 0 | 1 | 41.637 |
92353922 | GT-AG | 0 | 1.000000099473604e-05 | 72 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 9 | 807972 | 808043 | Hesseltinella vesiculosa 101127 | GAG|GTAAGGAGCG...GTCTCATTGATT/AAGGGTCTCATT...ATTAG|ACC | 0 | 1 | 44.402 |
92353923 | GT-AG | 0 | 0.0001938254229352 | 68 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 10 | 807850 | 807917 | Hesseltinella vesiculosa 101127 | AAG|GTACGCATCT...CTCATCGTAACA/TTTTATCTCATC...TTCAG|AGC | 0 | 1 | 45.074 |
92353924 | GT-AG | 0 | 1.0669791001193142e-05 | 60 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 11 | 807550 | 807609 | Hesseltinella vesiculosa 101127 | GAT|GTAAGTCAGA...CACTTTTTATTT/ACACTTTTTATT...TGTAG|ATG | 0 | 1 | 48.063 |
92353925 | GT-AG | 0 | 1.000000099473604e-05 | 62 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 12 | 807057 | 807118 | Hesseltinella vesiculosa 101127 | AAG|GTAAGAAAGG...TTCTCTTTACTT/CCTTTTTTTATC...TGCAG|ATC | 2 | 1 | 53.431 |
92353926 | GT-AG | 0 | 1.000000099473604e-05 | 67 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 13 | 806203 | 806269 | Hesseltinella vesiculosa 101127 | CAG|GTAAAAAAAA...CTATCCTTTTCA/CAGTATCTCACC...CTTAG|ACC | 0 | 1 | 63.233 |
92353927 | GT-AG | 0 | 1.000000099473604e-05 | 59 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 14 | 805840 | 805898 | Hesseltinella vesiculosa 101127 | CAA|GTAAGCGGCT...ATTTTCTTCTTT/ACCATTCTCATT...CGTAG|CTG | 1 | 1 | 67.02 |
92353928 | GT-AG | 0 | 2.26133455471464e-05 | 61 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 15 | 805477 | 805537 | Hesseltinella vesiculosa 101127 | AGC|GTAAGTTGAC...TTTTTTTTTTTA/CCCCCTCTGACC...CACAG|GCC | 0 | 1 | 70.781 |
92353929 | GT-AG | 0 | 1.000000099473604e-05 | 81 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 16 | 805176 | 805256 | Hesseltinella vesiculosa 101127 | GAG|GTAAAAGAAA...TTTTTCTTGTAC/CCGATGCTCAAG...TTTAG|ATC | 1 | 1 | 73.521 |
92353930 | GT-AG | 0 | 1.192479617365649e-05 | 79 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 17 | 804816 | 804894 | Hesseltinella vesiculosa 101127 | GAT|GTAAAATAGA...TTTTTCTTTGTG/CCTCAGCTCACT...GCTAG|ATG | 0 | 1 | 77.021 |
92353931 | GT-AG | 0 | 1.000000099473604e-05 | 64 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 18 | 804091 | 804154 | Hesseltinella vesiculosa 101127 | CTG|GTAAGAATGG...CTCACCTTTTTT/GAATTACTCATC...TTTAG|ATG | 1 | 1 | 85.253 |
92356610 | GT-AG | 0 | 1.000000099473604e-05 | 124 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1403269 17285652 | 1 | 812207 | 812330 | Hesseltinella vesiculosa 101127 | AAG|GTAAAAAGAA...TCTCCTTTATCT/CTTTATCTTACT...TGTAG|ATT | 0 | 1.544 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "introns" ( "id" INTEGER, "dinucleotide_pair" TEXT, "is_minor" INTEGER, "score" REAL, "length" INTEGER, "transcript_id" INTEGER, "ordinal_index" INTEGER, "start" INTEGER, "end" INTEGER, "taxonomy_id" INTEGER, "scored_motifs" TEXT, "phase" INTEGER, "in_cds" INTEGER, "relative_position" REAL ,PRIMARY KEY ([id]), FOREIGN KEY([transcript_id]) REFERENCES [transcripts]([id]), FOREIGN KEY([taxonomy_id]) REFERENCES [genomes]([taxonomy_id]) ); CREATE INDEX [idx_introns_transcript_id] ON [introns] ([transcript_id]); CREATE INDEX [idx_introns_taxonomy_id] ON [introns] ([taxonomy_id]); CREATE INDEX [idx_introns_phase] ON [introns] ([phase]); CREATE INDEX [idx_introns_is_minor] ON [introns] ([is_minor]); CREATE INDEX [idx_introns_dinucleotide_pair] ON [introns] ([dinucleotide_pair]); CREATE INDEX [idx_introns_score] ON [introns] ([score]); CREATE INDEX [idx_introns_in_cds] ON [introns] ([in_cds]);