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)
20 rows where transcript_id = 2279581
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239515 | GT-AG | 0 | 1.000000099473604e-05 | 631 | rna-XM_027998560.1 2279581 | 2 | 1854990 | 1855620 | Aphis gossypii 80765 | GGG|GTAAGTTGTT...AATGCATTATAT/ATATAGTTAAAT...TTTAG|AAT | 0 | 1 | 26.538 |
12239516 | GT-AG | 0 | 3.004913880282634e-05 | 54 | rna-XM_027998560.1 2279581 | 3 | 1855859 | 1855912 | Aphis gossypii 80765 | CTG|GTATGAATAA...AAGGTTTTAAAA/CTAAAGTTTACA...TTCAG|GTG | 1 | 1 | 30.82 |
12239517 | GT-AG | 0 | 0.0017953871793206 | 152 | rna-XM_027998560.1 2279581 | 4 | 1856145 | 1856296 | Aphis gossypii 80765 | CAG|GTATATATTG...ACAGTATTAATT/ACAGTATTAATT...TTCAG|AAA | 2 | 1 | 34.995 |
12239518 | GT-AG | 0 | 0.0003766284132933 | 65 | rna-XM_027998560.1 2279581 | 5 | 1856477 | 1856541 | Aphis gossypii 80765 | TCG|GTATGTATAA...ACTATTTTCATT/ACTATTTTCATT...ATTAG|GGA | 2 | 1 | 38.233 |
12239519 | GT-AG | 0 | 0.0001821205620717 | 77 | rna-XM_027998560.1 2279581 | 6 | 1856704 | 1856780 | Aphis gossypii 80765 | CGA|GTAAGTATGC...TATATTTTAATC/TATATTTTAATC...ATAAG|CTT | 2 | 1 | 41.148 |
12239520 | GT-AG | 0 | 0.0003221251992266 | 56 | rna-XM_027998560.1 2279581 | 7 | 1856890 | 1856945 | Aphis gossypii 80765 | TCA|GTAAGTTAAA...TAATTTTTAATG/TTATGATTTATT...TTTAG|TTA | 0 | 1 | 43.109 |
12239521 | GT-AG | 0 | 1.7036831439353825e-05 | 979 | rna-XM_027998560.1 2279581 | 8 | 1857193 | 1858171 | Aphis gossypii 80765 | AAG|GTAAATTGTA...TGCATTTTATTT/ATGCATTTTATT...TTTAG|ACC | 1 | 1 | 47.553 |
12239522 | GT-AG | 0 | 0.0248827925044186 | 64 | rna-XM_027998560.1 2279581 | 9 | 1858299 | 1858362 | Aphis gossypii 80765 | TGG|GTATTTTTAT...TTTTTTTTACTC/TTTTTTTTTACT...TATAG|GAG | 2 | 1 | 49.838 |
12239523 | GT-AG | 0 | 1.2244033170427058 | 61 | rna-XM_027998560.1 2279581 | 10 | 1858548 | 1858608 | Aphis gossypii 80765 | AAG|GTATCTTATT...TATTATTTAATT/TATTATTTAATT...TTTAG|ATT | 1 | 1 | 53.167 |
12239524 | GT-AG | 0 | 0.0732731282050584 | 752 | rna-XM_027998560.1 2279581 | 11 | 1858728 | 1859479 | Aphis gossypii 80765 | AAA|GTATGTTTAT...TTATTTTTATTT/ATTATTTTTATT...TTCAG|GTA | 0 | 1 | 55.308 |
12239525 | GT-AG | 0 | 1.000000099473604e-05 | 76 | rna-XM_027998560.1 2279581 | 12 | 1859658 | 1859733 | Aphis gossypii 80765 | AAA|GTAAAACAAA...ATACTTTTAATG/TTATTGTTTATT...TTTAG|AAA | 1 | 1 | 58.51 |
12239526 | GT-AG | 0 | 0.0055500908295997 | 677 | rna-XM_027998560.1 2279581 | 13 | 1859803 | 1860479 | Aphis gossypii 80765 | CCG|GTATTTATTT...TATAACTTAATT/TTTATATTTATT...TATAG|GAA | 1 | 1 | 59.752 |
12239527 | GT-AG | 0 | 3.17847659300185e-05 | 710 | rna-XM_027998560.1 2279581 | 14 | 1860690 | 1861399 | Aphis gossypii 80765 | AAT|GTAAGTTAAG...TAATTATTAATT/ATTTTATTTATA...TGTAG|ACT | 1 | 1 | 63.53 |
12239528 | GT-AG | 0 | 0.0004288510982117 | 64 | rna-XM_027998560.1 2279581 | 15 | 1861557 | 1861620 | Aphis gossypii 80765 | TGA|GTATGTGCCT...AACACTTCAATA/TATATATTTATT...TTTAG|ATT | 2 | 1 | 66.355 |
12239529 | GT-AG | 0 | 1.000000099473604e-05 | 71 | rna-XM_027998560.1 2279581 | 16 | 1861879 | 1861949 | Aphis gossypii 80765 | CTG|GTTAGAATGT...CTAATATTAACT/CTAATATTAACT...TTTAG|TTA | 2 | 1 | 70.997 |
12239530 | GT-AG | 0 | 0.0748483437284518 | 602 | rna-XM_027998560.1 2279581 | 17 | 1862161 | 1862762 | Aphis gossypii 80765 | AAT|GTATGTTATT...TTGTTTTTAAAT/TTGTTTTTAAAT...TTTAG|TAT | 0 | 1 | 74.793 |
12239531 | GT-AG | 0 | 1.000000099473604e-05 | 122 | rna-XM_027998560.1 2279581 | 18 | 1862988 | 1863109 | Aphis gossypii 80765 | ATG|GTAAAGTAAA...GCAATTTTATTT/ATTATACTTATA...TATAG|ATC | 0 | 1 | 78.841 |
12239532 | GT-AG | 0 | 1.000000099473604e-05 | 65 | rna-XM_027998560.1 2279581 | 19 | 1863306 | 1863370 | Aphis gossypii 80765 | AAG|GTAATAAATA...TAATTTTTATTT/TTAATTTTTATT...TTTAG|GGC | 1 | 1 | 82.368 |
12239533 | GT-AG | 0 | 2.86709764420237e-05 | 69 | rna-XM_027998560.1 2279581 | 20 | 1863707 | 1863775 | Aphis gossypii 80765 | ATG|GTAAGTATTT...TTTTTTTTAGTA/TTTTAATTAATT...TATAG|TGG | 1 | 1 | 88.413 |
12240571 | GT-AG | 0 | 1.000000099473604e-05 | 277 | rna-XM_027998560.1 2279581 | 1 | 1854385 | 1854661 | Aphis gossypii 80765 | AAG|GTTTGTAAAT...ATATACTTAAAT/TATATACTTAAA...TTTAG|AAT | 0 | 20.709 |
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]);