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)
15 rows where transcript_id = 2279636
This data as json, CSV (advanced)
Suggested facets: score, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12240044 | GT-AG | 0 | 1.000000099473604e-05 | 29047 | rna-XM_027989990.1 2279636 | 2 | 1762051 | 1791097 | Aphis gossypii 80765 | CAG|GTAAGTGCTT...TGTTTCTTTTTT/GTTATATTAATG...TTCAG|ACA | 2 | 1 | 21.659 |
12240045 | GT-AG | 0 | 0.0001588854848366 | 194 | rna-XM_027989990.1 2279636 | 3 | 1761774 | 1761967 | Aphis gossypii 80765 | ATC|GTAAGTATAA...GTTTCTTTAAAT/ATATTTTTTATA...TACAG|AAG | 1 | 1 | 25.663 |
12240046 | GT-AG | 0 | 0.0002995031634373 | 74 | rna-XM_027989990.1 2279636 | 4 | 1761592 | 1761665 | Aphis gossypii 80765 | AAT|GTACGTATCA...ATAATTTTGTTC/TGTATATTCAAT...CCTAG|ACA | 1 | 1 | 30.873 |
12240047 | GT-AG | 0 | 2.926693855613419e-05 | 278 | rna-XM_027989990.1 2279636 | 5 | 1761239 | 1761516 | Aphis gossypii 80765 | ACG|GTAGGTATTT...TTAACCTAAATT/CTGCATTTAACC...TTTAG|AGT | 1 | 1 | 34.491 |
12240048 | GT-AG | 0 | 1.000000099473604e-05 | 1168 | rna-XM_027989990.1 2279636 | 6 | 1759982 | 1761149 | Aphis gossypii 80765 | CAG|GTCAGTTTTT...ATTTTATTAATT/ATTTTATTAATT...GTTAG|GCT | 0 | 1 | 38.784 |
12240049 | GT-AG | 0 | 1.7447342594985625e-05 | 252 | rna-XM_027989990.1 2279636 | 7 | 1759640 | 1759891 | Aphis gossypii 80765 | AAG|GTACGATATC...TTTTTTTTATTG/TTTTTTTTTATT...TACAG|ATT | 0 | 1 | 43.126 |
12240050 | GT-AG | 0 | 0.0010543857202376 | 99 | rna-XM_027989990.1 2279636 | 8 | 1759462 | 1759560 | Aphis gossypii 80765 | CGG|GTATGTATTA...AATATATTAATA/AATATATTAATA...TGCAG|GTT | 1 | 1 | 46.937 |
12240051 | GT-AG | 0 | 1.519831025538072e-05 | 137 | rna-XM_027989990.1 2279636 | 9 | 1759254 | 1759390 | Aphis gossypii 80765 | ACT|GTAAGTGTCG...ATTATATTATTC/TATTATATTATT...TTTAG|GTA | 0 | 1 | 50.362 |
12240052 | GT-AG | 0 | 1.000000099473604e-05 | 889 | rna-XM_027989990.1 2279636 | 10 | 1758160 | 1759048 | Aphis gossypii 80765 | AGG|GTAGGTATAA...CACCTATTAATT/CACCTATTAATT...TTCAG|ACG | 1 | 1 | 60.251 |
12240053 | GT-AG | 0 | 0.2933387794306757 | 132 | rna-XM_027989990.1 2279636 | 11 | 1757770 | 1757901 | Aphis gossypii 80765 | TCT|GTAACTTGAT...TTGATCTTATTT/TTTGATCTTATT...AATAG|CTG | 1 | 1 | 72.697 |
12240054 | GT-AG | 0 | 2.140797321415586e-05 | 111 | rna-XM_027989990.1 2279636 | 12 | 1757485 | 1757595 | Aphis gossypii 80765 | CCG|GTAGGCCGCT...TAGACATTAATT/TTTGTTGTAATT...CCTAG|GTC | 1 | 1 | 81.09 |
12240055 | GT-AG | 0 | 1.000000099473604e-05 | 119 | rna-XM_027989990.1 2279636 | 13 | 1757290 | 1757408 | Aphis gossypii 80765 | AAG|GTAATGCAAA...CCTATTTTAATC/CCTATTTTAATC...CACAG|GTC | 2 | 1 | 84.756 |
12240056 | GT-AG | 0 | 0.0002023058891067 | 364 | rna-XM_027989990.1 2279636 | 14 | 1756825 | 1757188 | Aphis gossypii 80765 | CAG|GTATGGTACA...TTACTCTTATTT/CTTATTTTAATT...GACAG|GTA | 1 | 1 | 89.629 |
12240057 | GT-AG | 0 | 1.000000099473604e-05 | 131 | rna-XM_027989990.1 2279636 | 15 | 1756558 | 1756688 | Aphis gossypii 80765 | ATT|GTGAGTATTT...TATACCTAAACG/GTCTGTTTTATA...TGCAG|AAA | 2 | 1 | 96.189 |
12240604 | GT-AG | 0 | 3.740417922248618e-05 | 66 | rna-XM_027989990.1 2279636 | 1 | 1791323 | 1791388 | Aphis gossypii 80765 | GCC|GTCCGTAACT...TATCTCTTATAT/CTATCTCTTATA...TATAG|GTA | 0 | 15.774 |
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]);