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 = 2279585
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239589 | GT-AG | 0 | 1.000000099473604e-05 | 449 | rna-XM_027997946.1 2279585 | 2 | 1882864 | 1883312 | Aphis gossypii 80765 | CCG|GTGAGTTAAA...AAACTTTTAGTT/TTTTAGTTAAAA...TTTAG|TCG | 2 | 1 | 13.26 |
12239590 | GT-AG | 0 | 0.0001249613090995 | 127 | rna-XM_027997946.1 2279585 | 3 | 1883520 | 1883646 | Aphis gossypii 80765 | CAG|GTAAACATCC...GTTATTTTAATT/GTTATTTTAATT...TATAG|AAA | 2 | 1 | 18.458 |
12239591 | GT-AG | 0 | 0.0052649536479394 | 541 | rna-XM_027997946.1 2279585 | 4 | 1883858 | 1884398 | Aphis gossypii 80765 | CAT|GTAATTTTTT...TTTTTTTTAATT/TTTTTTTTAATT...TTCAG|GAG | 0 | 1 | 23.757 |
12239592 | GT-AG | 0 | 0.0022269671248728 | 110 | rna-XM_027997946.1 2279585 | 5 | 1884515 | 1884624 | Aphis gossypii 80765 | TAC|GTACGTACTA...ATGTCTTTATTT/AATGTCTTTATT...TATAG|CTG | 2 | 1 | 26.67 |
12239593 | GT-AG | 0 | 0.0060793637721931 | 69 | rna-XM_027997946.1 2279585 | 6 | 1884868 | 1884936 | Aphis gossypii 80765 | TAG|GTATGTTTTC...AATATATTATTT/ATTATTGTTATA...TTCAG|ACA | 2 | 1 | 32.772 |
12239594 | GT-AG | 0 | 1.000000099473604e-05 | 70 | rna-XM_027997946.1 2279585 | 7 | 1885116 | 1885185 | Aphis gossypii 80765 | TTG|GTTAGTTTTT...GAGATTTTAGTA/TGAGATTTTAGT...TACAG|CCC | 1 | 1 | 37.268 |
12239595 | GT-AG | 0 | 2.426521299829372e-05 | 77 | rna-XM_027997946.1 2279585 | 8 | 1885749 | 1885825 | Aphis gossypii 80765 | TTA|GTAAGTATGA...TATGACTTGATG/TTAATTTTTACT...TTCAG|GCA | 0 | 1 | 51.406 |
12239596 | GT-AG | 0 | 1.000000099473604e-05 | 1484 | rna-XM_027997946.1 2279585 | 9 | 1886002 | 1887485 | Aphis gossypii 80765 | AGA|GTGAGTATCA...TATTTTTTATTT/TTATTTTTTATT...TTTAG|TGA | 2 | 1 | 55.826 |
12239597 | GT-AG | 0 | 0.000129141173195 | 70 | rna-XM_027997946.1 2279585 | 10 | 1888151 | 1888220 | Aphis gossypii 80765 | ATG|GTAGGTTTAT...TTTTTCTTATAA/TTTTTTCTTATA...AACAG|GAA | 1 | 1 | 72.526 |
12239598 | GT-AG | 0 | 1.000000099473604e-05 | 69 | rna-XM_027997946.1 2279585 | 11 | 1888346 | 1888414 | Aphis gossypii 80765 | GTA|GTGAGTATAA...TTACTATTGATT/AATTAATTTACT...TATAG|AAT | 0 | 1 | 75.665 |
12239599 | GT-AG | 0 | 1.000000099473604e-05 | 7060 | rna-XM_027997946.1 2279585 | 12 | 1888591 | 1895650 | Aphis gossypii 80765 | GAG|GTAATAAAAA...ATATTTTTAATA/ATATTTTTAATA...TACAG|AAA | 2 | 1 | 80.085 |
12239600 | GT-AG | 0 | 5.497023349532565e-05 | 6235 | rna-XM_027997946.1 2279585 | 13 | 1895768 | 1902002 | Aphis gossypii 80765 | TCC|GTAAGTAATA...TAATTTTTACTA/GTAATTTTTACT...TTCAG|AAT | 2 | 1 | 83.024 |
12239601 | GT-AG | 0 | 3.870733659713927e-05 | 3047 | rna-XM_027997946.1 2279585 | 14 | 1902116 | 1905162 | Aphis gossypii 80765 | CAG|GTAATTTATT...ATAACCTTACTC/AATAACCTTACT...TATAG|AAA | 1 | 1 | 85.861 |
12239602 | GT-AG | 0 | 1.000000099473604e-05 | 4441 | rna-XM_027997946.1 2279585 | 15 | 1905300 | 1909740 | Aphis gossypii 80765 | AAG|GTAAAAATAA...TGATATTTAAAA/TTTTATGTCACT...TGCAG|GAT | 0 | 1 | 89.302 |
12239603 | GT-AG | 0 | 4.0507298270484405e-05 | 4873 | rna-XM_027997946.1 2279585 | 16 | 1909957 | 1914829 | Aphis gossypii 80765 | AAG|GTAAGCTGGT...TAAATTTTGATG/ATTTTATTTACG...CACAG|ATC | 0 | 1 | 94.726 |
12239604 | GT-AG | 0 | 1.000000099473604e-05 | 5034 | rna-XM_027997946.1 2279585 | 17 | 1914959 | 1919992 | Aphis gossypii 80765 | AAG|GTGAGCAGAA...TTGTATTTAACA/TTGTATTTAACA...TACAG|TTT | 0 | 1 | 97.966 |
12239605 | GT-AG | 0 | 1.000000099473604e-05 | 3265 | rna-XM_027997946.1 2279585 | 18 | 1920054 | 1923318 | Aphis gossypii 80765 | AAG|GTTAGTTGTT...CCTTCATTAGTT/ATATAGTTAATT...TTCAG|GTA | 1 | 1 | 99.498 |
12240575 | GT-AG | 0 | 4.382552756240638e-05 | 84 | rna-XM_027997946.1 2279585 | 1 | 1882595 | 1882678 | Aphis gossypii 80765 | TTG|GTACGGTTTG...TTATACTTACCG/ATTATACTTACC...TTTAG|GCC | 0 | 9.819 |
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]);