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 = 2279606
This data as json, CSV (advanced)
Suggested facets: score, phase
id ▼ | dinucleotide_pair | is_minor | score | length | transcript_id | ordinal_index | start | end | taxonomy_id | scored_motifs | phase | in_cds | relative_position |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239831 | GT-AG | 0 | 1.000000099473604e-05 | 134 | rna-XM_027987747.1 2279606 | 1 | 1754501 | 1754634 | Aphis gossypii 80765 | TTT|GTGAGTGTCG...TGTTTCTTTTTT/GTTATATTAATG...TTCAG|ACA | 2 | 1 | 0.364 |
12239832 | GT-AG | 0 | 0.0001588854848366 | 192 | rna-XM_027987747.1 2279606 | 2 | 1754226 | 1754417 | Aphis gossypii 80765 | ATC|GTAAGTATAA...GTTTCTTTAAAT/ATATTTTTTATA...TACAG|AAG | 1 | 1 | 4.138 |
12239833 | GT-AG | 0 | 0.0002995031634373 | 74 | rna-XM_027987747.1 2279606 | 3 | 1754044 | 1754117 | Aphis gossypii 80765 | AAT|GTACGTATCA...ATAATTTTGTTC/TGTATATTCAAT...CCTAG|ACA | 1 | 1 | 9.05 |
12239834 | GT-AG | 0 | 1.8836426613876824e-05 | 278 | rna-XM_027987747.1 2279606 | 4 | 1753691 | 1753968 | Aphis gossypii 80765 | ATG|GTAGGTATTT...TTAACCTAAATT/CTGCATTTAACC...TTTAG|AGT | 1 | 1 | 12.46 |
12239835 | GT-AG | 0 | 1.000000099473604e-05 | 1168 | rna-XM_027987747.1 2279606 | 5 | 1752434 | 1753601 | Aphis gossypii 80765 | CAG|GTCAGTTTTT...ATTTTATTAATT/ATTTTATTAATT...GTTAG|GCT | 0 | 1 | 16.508 |
12239836 | GT-AG | 0 | 1.000000099473604e-05 | 250 | rna-XM_027987747.1 2279606 | 6 | 1752094 | 1752343 | Aphis gossypii 80765 | AAG|GTACGATATC...TTTTTTTTTTCT/CTATTTTTCATC...TACAG|ATT | 0 | 1 | 20.6 |
12239837 | GT-AG | 0 | 0.0010543857202376 | 99 | rna-XM_027987747.1 2279606 | 7 | 1751916 | 1752014 | Aphis gossypii 80765 | CGG|GTATGTATTA...AATATATTAATA/AATATATTAATA...TGCAG|GTT | 1 | 1 | 24.193 |
12239838 | GT-AG | 0 | 3.9630334920764135e-05 | 137 | rna-XM_027987747.1 2279606 | 8 | 1751708 | 1751844 | Aphis gossypii 80765 | ACT|GTAAGTATCG...ATTATATTATTC/TATTATATTATT...TTTAG|GTA | 0 | 1 | 27.422 |
12239839 | GT-AG | 0 | 1.000000099473604e-05 | 873 | rna-XM_027987747.1 2279606 | 9 | 1750630 | 1751502 | Aphis gossypii 80765 | AGG|GTAGGTATAA...CACCTATTAATT/CACCTATTAATT...TTCAG|ACG | 1 | 1 | 36.744 |
12239840 | GT-AG | 0 | 0.2933387794306757 | 132 | rna-XM_027987747.1 2279606 | 10 | 1750240 | 1750371 | Aphis gossypii 80765 | TCT|GTAACTTGAT...TTGATCTTATTT/TTTGATCTTATT...AATAG|CTG | 1 | 1 | 48.477 |
12239841 | GT-AG | 0 | 2.140797321415586e-05 | 111 | rna-XM_027987747.1 2279606 | 11 | 1749955 | 1750065 | Aphis gossypii 80765 | CCG|GTAGGCCGCT...TAGACATTAATT/TTTGTTGTAATT...CCTAG|GTC | 1 | 1 | 56.389 |
12239842 | GT-AG | 0 | 1.000000099473604e-05 | 119 | rna-XM_027987747.1 2279606 | 12 | 1749760 | 1749878 | Aphis gossypii 80765 | AAG|GTAATGCAAA...CCTATTTTAATC/CCTATTTTAATC...CACAG|GTC | 2 | 1 | 59.845 |
12239843 | GT-AG | 0 | 0.0002023058891067 | 364 | rna-XM_027987747.1 2279606 | 13 | 1749295 | 1749658 | Aphis gossypii 80765 | CAG|GTATGGTACA...TTACTCTTATTT/CTTATTTTAATT...GACAG|GTA | 1 | 1 | 64.438 |
12239844 | GT-AG | 0 | 1.000000099473604e-05 | 131 | rna-XM_027987747.1 2279606 | 14 | 1749028 | 1749158 | Aphis gossypii 80765 | ATT|GTGAGTATTT...TATACCTAAACG/GTCTGTTTTATA...TGCAG|AAA | 2 | 1 | 70.623 |
12239845 | GT-AG | 0 | 1.000000099473604e-05 | 505 | rna-XM_027987747.1 2279606 | 15 | 1748448 | 1748952 | Aphis gossypii 80765 | GCG|GTAATTATCG...ATTATTTCAAAT/AATTATTTCAAA...TTCAG|GTA | 2 | 1 | 74.034 |
12239846 | GT-AG | 0 | 1.000000099473604e-05 | 812 | rna-XM_027987747.1 2279606 | 16 | 1747578 | 1748389 | Aphis gossypii 80765 | CAG|GTTAGTATTG...TATATTGTAATG/TATATTGTAATG...GTCAG|ACC | 0 | 1 | 76.671 |
12239847 | GT-AG | 0 | 1.000000099473604e-05 | 780 | rna-XM_027987747.1 2279606 | 17 | 1746492 | 1747271 | Aphis gossypii 80765 | AAA|GTAAGTGCAA...CAAATTTTAATT/CAAATTTTAATT...TTTAG|AAT | 0 | 1 | 90.587 |
12239848 | GT-AG | 0 | 1.000000099473604e-05 | 3167 | rna-XM_027987747.1 2279606 | 18 | 1743289 | 1746455 | Aphis gossypii 80765 | CAA|GTAAGTAAAC...TTATCTTTATCT/ATCTGTTTCATT...TGAAG|GTA | 0 | 1 | 92.224 |
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]);