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)
25 rows where transcript_id = 2279584
This data as json, CSV (advanced)
Suggested facets: score, length, phase
id ▼ | dinucleotide_pair | is_minor | score | length | transcript_id | ordinal_index | start | end | taxonomy_id | scored_motifs | phase | in_cds | relative_position |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239564 | GT-AG | 0 | 1.000000099473604e-05 | 75 | rna-XM_027995819.1 2279584 | 1 | 1797302 | 1797376 | Aphis gossypii 80765 | CAT|GTGAGTGGTG...TAGATCTTATTT/TTAGATCTTATT...TATAG|GAT | 0 | 1 | 2.64 |
12239565 | GT-AG | 0 | 1.000000099473604e-05 | 1986 | rna-XM_027995819.1 2279584 | 2 | 1797532 | 1799517 | Aphis gossypii 80765 | TGT|GTTAGTAAAA...TAAGTTTTAATT/TTTAATTTTATT...TTCAG|AAT | 2 | 1 | 6.651 |
12239566 | GT-AG | 0 | 1.4526388670456318e-05 | 79 | rna-XM_027995819.1 2279584 | 3 | 1799651 | 1799729 | Aphis gossypii 80765 | AAA|GTAAATAAGA...TTTATTTTGATT/TTTATTTTGATT...TTTAG|GAA | 0 | 1 | 10.093 |
12239567 | GT-AG | 0 | 0.0001134336218694 | 62 | rna-XM_027995819.1 2279584 | 4 | 1799838 | 1799899 | Aphis gossypii 80765 | ATT|GTAAGTATTC...CTTATATTAATT/CTTATATTAATT...TTCAG|AAA | 0 | 1 | 12.888 |
12239568 | GT-AG | 0 | 1.000000099473604e-05 | 143 | rna-XM_027995819.1 2279584 | 5 | 1800102 | 1800244 | Aphis gossypii 80765 | ATG|GTAATATAAA...ATACTTTTATCC/TATACTTTTATC...TTTAG|GTG | 1 | 1 | 18.116 |
12239569 | GT-AG | 0 | 0.0297773604327166 | 69 | rna-XM_027995819.1 2279584 | 6 | 1800467 | 1800535 | Aphis gossypii 80765 | AGC|GTATGATCTA...TAATTCTTAAAT/CTTAAATTTATT...TTTAG|CTA | 1 | 1 | 23.861 |
12239570 | GT-AG | 0 | 1.000000099473604e-05 | 125 | rna-XM_027995819.1 2279584 | 7 | 1800692 | 1800816 | Aphis gossypii 80765 | AAT|GTGAGTGTAT...GATATTTTAAAA/ATTATATTGATA...TATAG|ATC | 1 | 1 | 27.899 |
12239571 | GT-AG | 0 | 0.0003887868707347 | 68 | rna-XM_027995819.1 2279584 | 8 | 1800909 | 1800976 | Aphis gossypii 80765 | AAA|GTAAATTTAT...TGCATTTTAAAT/TATATACTCAGT...ATTAG|ATT | 0 | 1 | 30.28 |
12239572 | GT-AG | 0 | 5.806825731532694e-05 | 517 | rna-XM_027995819.1 2279584 | 9 | 1801141 | 1801657 | Aphis gossypii 80765 | AAA|GTAAATATAC...ATAGTTTTATCT/TATAGTTTTATC...TTTAG|ACC | 2 | 1 | 34.524 |
12239573 | GT-AG | 0 | 0.0007113723350316 | 525 | rna-XM_027995819.1 2279584 | 10 | 1801791 | 1802315 | Aphis gossypii 80765 | AAG|GTATTATTTT...CTAGTTTTATAA/ATTGTAATTATT...TTTAG|GGA | 0 | 1 | 37.966 |
12239574 | GT-AG | 0 | 1.000000099473604e-05 | 257 | rna-XM_027995819.1 2279584 | 11 | 1802440 | 1802696 | Aphis gossypii 80765 | TTG|GTCAGTATAC...AATGTTTTAATT/ATTTTACTCATA...TTTAG|AAA | 1 | 1 | 41.175 |
12239575 | GT-AG | 0 | 1.000000099473604e-05 | 82 | rna-XM_027995819.1 2279584 | 12 | 1802796 | 1802877 | Aphis gossypii 80765 | AAG|GTTGTAATAA...TTTATATTATCT/ATAATGTTTATA...TATAG|GCT | 1 | 1 | 43.737 |
12239576 | GT-AG | 0 | 1.000000099473604e-05 | 157 | rna-XM_027995819.1 2279584 | 13 | 1803069 | 1803225 | Aphis gossypii 80765 | ATA|GTAAGTACAT...AAACTTTTATAA/TTGTAATTAATT...ATTAG|GAA | 0 | 1 | 48.68 |
12239577 | GT-AG | 0 | 1.000000099473604e-05 | 71 | rna-XM_027995819.1 2279584 | 14 | 1803390 | 1803460 | Aphis gossypii 80765 | AAA|GTAAGAATAT...TATTTTGTAATT/TATTTTGTAATT...TTTAG|TTT | 2 | 1 | 52.924 |
12239578 | GT-AG | 0 | 1.000000099473604e-05 | 77 | rna-XM_027995819.1 2279584 | 15 | 1803664 | 1803740 | Aphis gossypii 80765 | ATG|GTAAATACAC...TTCATTTTAATA/AAAATACTAACT...ATTAG|CTA | 1 | 1 | 58.178 |
12239579 | GT-AG | 0 | 0.0035803443877094 | 398 | rna-XM_027995819.1 2279584 | 16 | 1804144 | 1804541 | Aphis gossypii 80765 | AAA|GTATGTACCA...TGTTTTTTACTT/ATGTTTTTTACT...TTCAG|ATG | 2 | 1 | 68.608 |
12239580 | GT-AG | 0 | 0.0005136507186473 | 65 | rna-XM_027995819.1 2279584 | 17 | 1804612 | 1804676 | Aphis gossypii 80765 | ACT|GTAAGTTATT...AAATTTTTATTG/AAAATTTTTATT...ACTAG|CCA | 0 | 1 | 70.419 |
12239581 | GT-AG | 0 | 5.198328800719402e-05 | 243 | rna-XM_027995819.1 2279584 | 18 | 1804758 | 1805000 | Aphis gossypii 80765 | GAA|GTAAATATTT...TAATCTTTTATG/ATTATTTTTATG...TTTAG|GAA | 0 | 1 | 72.516 |
12239582 | GT-AG | 0 | 0.0003717823817656 | 61 | rna-XM_027995819.1 2279584 | 19 | 1805160 | 1805220 | Aphis gossypii 80765 | ATT|GTAAGCTAAT...CTTTACTTGATA/CTTTACTTGATA...TTTAG|GAT | 0 | 1 | 76.63 |
12239583 | GT-AG | 0 | 0.0003217216107302 | 60 | rna-XM_027995819.1 2279584 | 20 | 1805262 | 1805321 | Aphis gossypii 80765 | GAG|GTTTGTCTTT...AATTTTTTAACT/AATTTTTTAACT...TTTAG|AAC | 2 | 1 | 77.692 |
12239584 | GT-AG | 0 | 1.000000099473604e-05 | 1735 | rna-XM_027995819.1 2279584 | 21 | 1805417 | 1807151 | Aphis gossypii 80765 | CAA|GTTAGTGCTT...TTTTCTGTAACA/TTATATTTGATT...TTTAG|GAA | 1 | 1 | 80.15 |
12239585 | GT-AG | 0 | 1.6029294230048842e-05 | 59 | rna-XM_027995819.1 2279584 | 22 | 1807244 | 1807302 | Aphis gossypii 80765 | AGA|GTAAGTTAAA...TATGTCTTTGTA/ATATGTTTCATA...TTCAG|CTA | 0 | 1 | 82.531 |
12239586 | GT-AG | 0 | 3.823306641992346e-05 | 79 | rna-XM_027995819.1 2279584 | 23 | 1807360 | 1807438 | Aphis gossypii 80765 | AGT|GTAAATACAT...TTTATTTTAGTC/AATTTATTTATT...AATAG|GAC | 0 | 1 | 84.006 |
12239587 | GT-AG | 0 | 1.258239896272335e-05 | 85 | rna-XM_027995819.1 2279584 | 24 | 1807640 | 1807724 | Aphis gossypii 80765 | CCA|GTAAGTACAA...TGTGTTTTAATT/TGTGTTTTAATT...TGTAG|GAA | 0 | 1 | 89.208 |
12239588 | GT-AG | 0 | 2.367522533427955e-05 | 64 | rna-XM_027995819.1 2279584 | 25 | 1807934 | 1807997 | Aphis gossypii 80765 | AAA|GTAAGTATAA...TTTGTTTTATTA/TTTTGTTTTATT...TTCAG|AGA | 2 | 1 | 94.617 |
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]);