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)
26 rows where transcript_id = 2279586
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239606 | GT-AG | 0 | 0.0002455268480271 | 9121 | rna-XM_027998101.1 2279586 | 2 | 5196573 | 5205693 | Aphis gossypii 80765 | TAT|GTAAGTTTAT...CAAATTTTAATT/TTAATTTTTATT...AATAG|GTA | 1 | 1 | 5.319 |
12239607 | GT-AG | 0 | 4.10322004871865e-05 | 10486 | rna-XM_027998101.1 2279586 | 3 | 5205844 | 5216329 | Aphis gossypii 80765 | GTG|GTAATATTTT...TTTTTTTTAAAT/TTTTTTTTAAAT...TCCAG|GAT | 1 | 1 | 9.608 |
12239608 | GT-AG | 0 | 0.0005650678425575 | 4107 | rna-XM_027998101.1 2279586 | 4 | 5216435 | 5220541 | Aphis gossypii 80765 | GTA|GTAAGTTTAT...TTATTTTTATTT/TTTTTATTTATT...TATAG|AAA | 1 | 1 | 12.611 |
12239609 | GT-AG | 0 | 0.0001352601545414 | 63 | rna-XM_027998101.1 2279586 | 5 | 5220659 | 5220721 | Aphis gossypii 80765 | GCA|GTGGGTTTTA...AACTTTTTAATT/AACTTTTTAATT...TTTAG|AGC | 1 | 1 | 15.957 |
12239610 | GT-AG | 0 | 6.428810086084297e-05 | 7489 | rna-XM_027998101.1 2279586 | 6 | 5220845 | 5228333 | Aphis gossypii 80765 | TAA|GTAAGTTGAA...ATTTTCTTGAAT/TCGTTATTGATC...TTCAG|GCG | 1 | 1 | 19.474 |
12239611 | GT-AG | 0 | 0.0003324105377028 | 67 | rna-XM_027998101.1 2279586 | 7 | 5228433 | 5228499 | Aphis gossypii 80765 | TAT|GTAGTTATTA...TATACTTGGACT/CTTGGACTTATT...AATAG|GTA | 1 | 1 | 22.305 |
12239612 | GT-AG | 0 | 0.1831868070829015 | 1307 | rna-XM_027998101.1 2279586 | 8 | 5228656 | 5229962 | Aphis gossypii 80765 | ATG|GTATGCTTAT...TAATTTTTAAAA/TTGTATTTGATT...TTCAG|ATG | 1 | 1 | 26.766 |
12239613 | GT-AG | 0 | 1.000000099473604e-05 | 5592 | rna-XM_027998101.1 2279586 | 9 | 5230107 | 5235698 | Aphis gossypii 80765 | GCG|GTGAGTGATG...ATAAAATTGATA/ATAAAATTGATA...TACAG|ATA | 1 | 1 | 30.884 |
12239614 | GT-AG | 0 | 0.000210779472561 | 885 | rna-XM_027998101.1 2279586 | 10 | 5235942 | 5236826 | Aphis gossypii 80765 | GTA|GTAAGTATTG...GTTTCCATAATT/TAATTATTGATG...TTTAG|TGA | 1 | 1 | 37.832 |
12239615 | GT-AG | 0 | 9.231329402739448e-05 | 550 | rna-XM_027998101.1 2279586 | 11 | 5236950 | 5237499 | Aphis gossypii 80765 | GCC|GTAAGTATTG...GAATTTATGACC/ATAGAATTTATG...GACAG|AAT | 1 | 1 | 41.35 |
12239616 | GT-AG | 0 | 0.0008602842004703 | 658 | rna-XM_027998101.1 2279586 | 12 | 5237629 | 5238286 | Aphis gossypii 80765 | GCG|GTATGTTAAA...TTGATTTTGGTT/CAATGGTTGATT...CTTAG|ATG | 1 | 1 | 45.039 |
12239617 | GT-AG | 0 | 0.0005298212057026 | 68 | rna-XM_027998101.1 2279586 | 13 | 5238410 | 5238477 | Aphis gossypii 80765 | GTT|GTAAGATTTT...AATTCCTTATAA/AATATTTTGAAT...TTCAG|ATT | 1 | 1 | 48.556 |
12239618 | GT-AG | 0 | 1.2734352484322572e-05 | 83 | rna-XM_027998101.1 2279586 | 14 | 5238593 | 5238675 | Aphis gossypii 80765 | TTT|GTAAGTACAT...ATATTATTAAAT/ATATTATTAAAT...TATAG|CCA | 2 | 1 | 51.844 |
12239619 | GT-AG | 0 | 1.2394023389385117e-05 | 69 | rna-XM_027998101.1 2279586 | 15 | 5238751 | 5238819 | Aphis gossypii 80765 | TTT|GTAAGTGAAT...TATATTTTAATT/TATATTTTAATT...TACAG|AGA | 2 | 1 | 53.989 |
12239620 | GT-AG | 0 | 1.000000099473604e-05 | 538 | rna-XM_027998101.1 2279586 | 16 | 5238964 | 5239501 | Aphis gossypii 80765 | ATT|GTGAGATTAA...CTGGTTTTAATA/CTGGTTTTAATA...TTTAG|ACA | 2 | 1 | 58.107 |
12239621 | GT-AG | 0 | 0.0001381033809519 | 63 | rna-XM_027998101.1 2279586 | 17 | 5239574 | 5239636 | Aphis gossypii 80765 | ACT|GTAAGTACTT...CAGTTTTTGATT/CAGTTTTTGATT...TATAG|CGA | 2 | 1 | 60.166 |
12239622 | GT-AG | 0 | 1.2230863208253632e-05 | 59 | rna-XM_027998101.1 2279586 | 18 | 5239709 | 5239767 | Aphis gossypii 80765 | TTT|GTTAGTATCA...TTGTTTTTATTT/ATTGTTTTTATT...TTTAG|AGA | 2 | 1 | 62.225 |
12239623 | GT-AG | 0 | 1.000000099473604e-05 | 87 | rna-XM_027998101.1 2279586 | 19 | 5239840 | 5239926 | Aphis gossypii 80765 | TCT|GTGAGTATAA...TGAAACTTAATT/TTAATTTTCAAC...TACAG|AAA | 2 | 1 | 64.284 |
12239624 | GT-AG | 0 | 1.000000099473604e-05 | 1197 | rna-XM_027998101.1 2279586 | 20 | 5239999 | 5241195 | Aphis gossypii 80765 | ACT|GTGAGTCATT...TTAGCATTATCA/TATATATTTACA...TGTAG|GTT | 2 | 1 | 66.343 |
12239625 | GT-AG | 0 | 1.000000099473604e-05 | 2513 | rna-XM_027998101.1 2279586 | 21 | 5241594 | 5244106 | Aphis gossypii 80765 | CCG|GTAAGTGCAA...TTGTATTTATTT/ATTGTATTTATT...TTTAG|TGA | 1 | 1 | 77.724 |
12239626 | GT-AG | 0 | 1.000000099473604e-05 | 127 | rna-XM_027998101.1 2279586 | 22 | 5244255 | 5244381 | Aphis gossypii 80765 | CAG|GTAAATAAAA...TTATTTTTATTT/ATTATTTTTATT...TTCAG|AAA | 2 | 1 | 81.956 |
12239627 | GT-AG | 0 | 4.578934455492424e-05 | 116 | rna-XM_027998101.1 2279586 | 23 | 5244474 | 5244589 | Aphis gossypii 80765 | TAT|GTAAATGTTA...ATAATCATATTT/CATATTTTCATA...ATAAG|TTG | 1 | 1 | 84.587 |
12239628 | GT-AG | 0 | 1.000000099473604e-05 | 1966 | rna-XM_027998101.1 2279586 | 24 | 5244817 | 5246782 | Aphis gossypii 80765 | CAA|GTAAAAATAT...TATATTTTGAAT/TATATTTTGAAT...TTTAG|GTG | 0 | 1 | 91.078 |
12239629 | GT-AG | 0 | 1.673946424130183e-05 | 3203 | rna-XM_027998101.1 2279586 | 25 | 5246976 | 5250178 | Aphis gossypii 80765 | AAT|GTACGGTAAA...TATTTTTTGTCA/TTTTTTGTCATT...TGTAG|ATA | 1 | 1 | 96.597 |
12239630 | GT-AG | 0 | 1.000000099473604e-05 | 63 | rna-XM_027998101.1 2279586 | 26 | 5250228 | 5250290 | Aphis gossypii 80765 | TAG|GTAAAAAAAA...GTTTTATTAATA/TTAATATTTATT...TTCAG|AGG | 2 | 1 | 97.998 |
12240576 | GT-AG | 0 | 1.000000099473604e-05 | 8551 | rna-XM_027998101.1 2279586 | 1 | 5187859 | 5196409 | Aphis gossypii 80765 | GAG|GTAAGTCTAG...ATAATTTTGAAT/ATAATTTTGAAT...TCTAG|AAA | 0 | 2.202 |
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]);