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)
34 rows where transcript_id = 2279575
This data as json, CSV (advanced)
Suggested facets: dinucleotide_pair, is_minor, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239416 | AT-AC | 1 | 99.99999999965829 | 45293 | rna-XM_027997514.1 2279575 | 2 | 1058909 | 1104201 | Aphis gossypii 80765 | CCC|ATATCCTTTT...ATTTCCTTAACC/AATTTTTTGATA...TACAC|GTG | 2 | 1 | 11.252 |
12239417 | GT-AG | 0 | 1.849281523504559e-05 | 67 | rna-XM_027997514.1 2279575 | 3 | 1058730 | 1058796 | Aphis gossypii 80765 | CAA|GTAATATATT...TCTTTTTTAAAT/TCTTTTTTAAAT...TACAG|GTG | 0 | 1 | 12.889 |
12239418 | GT-AG | 0 | 1.369703070944429e-05 | 137 | rna-XM_027997514.1 2279575 | 4 | 1058459 | 1058595 | Aphis gossypii 80765 | AGG|GTATGAAACT...ATTATATTAATA/ATTATATTAATA...TTTAG|TGC | 2 | 1 | 14.847 |
12239419 | GT-AG | 0 | 1.000000099473604e-05 | 8873 | rna-XM_027997514.1 2279575 | 5 | 1049488 | 1058360 | Aphis gossypii 80765 | CAA|GTGAGTAAAA...GATTTCTAAATT/CGATTTCTAAAT...TACAG|GTA | 1 | 1 | 16.279 |
12239420 | GT-AG | 0 | 1.000000099473604e-05 | 35906 | rna-XM_027997514.1 2279575 | 6 | 1013410 | 1049315 | Aphis gossypii 80765 | CAA|GTAAGAAAAA...AGTCTTTTGATG/AGTCTTTTGATG...TGCAG|GAT | 2 | 1 | 18.793 |
12239421 | GT-AG | 0 | 1.419363416197646e-05 | 16803 | rna-XM_027997514.1 2279575 | 7 | 996333 | 1013135 | Aphis gossypii 80765 | GTT|GTAAGTATAA...ATTTATTTATTT/TATTTATTTATT...TCCAG|GTC | 0 | 1 | 22.797 |
12239422 | GT-AG | 0 | 2.951273234160668e-05 | 21659 | rna-XM_027997514.1 2279575 | 8 | 974581 | 996239 | Aphis gossypii 80765 | GTG|GTAAGTTTCG...TTATTTATAATA/GATTTATTTATA...TTTAG|ATC | 0 | 1 | 24.156 |
12239423 | GT-AG | 0 | 1.000000099473604e-05 | 28989 | rna-XM_027997514.1 2279575 | 9 | 945413 | 974401 | Aphis gossypii 80765 | GAA|GTAAGTATTT...CGAATATTAATG/ATATTAATGATC...GACAG|GTA | 2 | 1 | 26.772 |
12239424 | GT-AG | 0 | 1.000000099473604e-05 | 1631 | rna-XM_027997514.1 2279575 | 10 | 943621 | 945251 | Aphis gossypii 80765 | ACG|GTAAGGGAAA...AGTTTTTTATTA/TTTTTATTAATC...AACAG|TTA | 1 | 1 | 29.125 |
12239425 | GT-AG | 0 | 1.3504423116024823e-05 | 2003 | rna-XM_027997514.1 2279575 | 11 | 941508 | 943510 | Aphis gossypii 80765 | TCG|GTAAGTAATG...TTCTTTTTAATT/TTCTTTTTAATT...TCTAG|AGC | 0 | 1 | 30.732 |
12239426 | GT-AG | 0 | 1.000000099473604e-05 | 3143 | rna-XM_027997514.1 2279575 | 12 | 938014 | 941156 | Aphis gossypii 80765 | CTG|GTAAATCACA...ACGTTTATAACA/ATTATGATAATT...TATAG|AAT | 0 | 1 | 35.861 |
12239427 | GT-AG | 0 | 3.263898135694558e-05 | 175 | rna-XM_027997514.1 2279575 | 13 | 937584 | 937758 | Aphis gossypii 80765 | CTC|GTAAGTTAAT...ATTTTCTTCCCC/CTTATTATAATT...TACAG|ATG | 0 | 1 | 39.588 |
12239428 | GT-AG | 0 | 1.5154423203612e-05 | 970 | rna-XM_027997514.1 2279575 | 14 | 936383 | 937352 | Aphis gossypii 80765 | CAG|GTAACGCAGA...TATGTTTTATTT/TTATGTTTTATT...TTTAG|CCT | 0 | 1 | 42.964 |
12239429 | GT-AG | 0 | 0.0015573143713934 | 792 | rna-XM_027997514.1 2279575 | 15 | 935439 | 936230 | Aphis gossypii 80765 | AAG|GTATATTCAC...AAACACTTAATA/ATAAGTTTGAAC...TTTAG|TAT | 2 | 1 | 45.185 |
12239430 | GT-AG | 0 | 1.000000099473604e-05 | 4804 | rna-XM_027997514.1 2279575 | 16 | 930422 | 935225 | Aphis gossypii 80765 | CAG|GTAAAACAAT...ATTTAATTAACC/ATTTAATTAACC...TGTAG|TAT | 2 | 1 | 48.298 |
12239431 | GT-AG | 0 | 0.0057196443189662 | 4605 | rna-XM_027997514.1 2279575 | 17 | 925690 | 930294 | Aphis gossypii 80765 | CAG|GTACCTGGAA...GCGTTTTTAACG/TTATTATTTATT...AACAG|ATT | 0 | 1 | 50.153 |
12239432 | GT-AG | 0 | 1.000000099473604e-05 | 1088 | rna-XM_027997514.1 2279575 | 18 | 924446 | 925533 | Aphis gossypii 80765 | GAG|GTAATAGCTA...ATTATTTTAATG/ATTATTTTAATG...TTCAG|CGC | 0 | 1 | 52.433 |
12239433 | GT-AG | 0 | 2.234620881421276e-05 | 2352 | rna-XM_027997514.1 2279575 | 19 | 921883 | 924234 | Aphis gossypii 80765 | AGG|GTAAGTTATA...ATTATTTTATTT/AATTATTTTATT...GATAG|ACA | 1 | 1 | 55.517 |
12239434 | GT-AG | 0 | 1.000000099473604e-05 | 875 | rna-XM_027997514.1 2279575 | 20 | 920820 | 921694 | Aphis gossypii 80765 | GTG|GTTTGTAAAA...TTATGTTTAAAT/TTATGTTTAAAT...AATAG|CGT | 0 | 1 | 58.264 |
12239435 | GT-AG | 0 | 1.000000099473604e-05 | 3515 | rna-XM_027997514.1 2279575 | 21 | 917171 | 920685 | Aphis gossypii 80765 | TAG|GTAAATATAA...ATATTTTTATAT/TATATTTTTATA...TACAG|TGG | 2 | 1 | 60.222 |
12239436 | GT-AG | 0 | 1.000000099473604e-05 | 131 | rna-XM_027997514.1 2279575 | 22 | 916890 | 917020 | Aphis gossypii 80765 | AGG|GTAAATAATT...GTATTTGTAAAT/TGTAAATTAATA...TTTAG|TGG | 2 | 1 | 62.414 |
12239437 | GT-AG | 0 | 1.6919757060487296e-05 | 2756 | rna-XM_027997514.1 2279575 | 23 | 914007 | 916762 | Aphis gossypii 80765 | CAG|GTAATCAATT...TTTATTTTACCA/TATTTATTTATT...TACAG|AGC | 0 | 1 | 64.27 |
12239438 | GT-AG | 0 | 2.065822788824725e-05 | 3686 | rna-XM_027997514.1 2279575 | 24 | 910088 | 913773 | Aphis gossypii 80765 | CGG|GTAAGCCGGA...TAGATCTTACTT/ATCTTACTTATA...TCAAG|TTT | 2 | 1 | 67.675 |
12239439 | GT-AG | 0 | 5.4247321497110087e-05 | 130 | rna-XM_027997514.1 2279575 | 25 | 909765 | 909894 | Aphis gossypii 80765 | AAA|GTAAAATTGG...TTGCTTTTGATT/TTGCTTTTGATT...CATAG|GTT | 0 | 1 | 70.495 |
12239440 | GT-AG | 0 | 1.2913480798039384e-05 | 311 | rna-XM_027997514.1 2279575 | 26 | 909304 | 909614 | Aphis gossypii 80765 | AGT|GTAAGTACGC...ATTGTGTTAACT/ATTGTGTTAACT...CGCAG|GTG | 0 | 1 | 72.687 |
12239441 | GT-AG | 0 | 1.000000099473604e-05 | 3598 | rna-XM_027997514.1 2279575 | 27 | 905544 | 909141 | Aphis gossypii 80765 | CAA|GTGAGTATAT...AATTTCGTAAAA/AAATTTGTCAAT...AACAG|CTT | 0 | 1 | 75.055 |
12239442 | GT-AG | 0 | 5.387756083045921e-05 | 145 | rna-XM_027997514.1 2279575 | 28 | 905180 | 905324 | Aphis gossypii 80765 | CAA|GTACGTGAAA...CCCTTTTTAATT/TTAATTTTAATT...CTCAG|CCG | 0 | 1 | 78.255 |
12239443 | GT-AG | 0 | 1.000000099473604e-05 | 91 | rna-XM_027997514.1 2279575 | 29 | 904896 | 904986 | Aphis gossypii 80765 | GAA|GTGAGTTTCC...ACAATCAAAATA/AATAAATTGAAA...TATAG|AAA | 1 | 1 | 81.076 |
12239444 | GT-AG | 0 | 7.632917491061658e-05 | 245 | rna-XM_027997514.1 2279575 | 30 | 904499 | 904743 | Aphis gossypii 80765 | AAA|GTAAGTTTTT...ATATACTTGAAA/CGAGTATTCACC...TACAG|GCG | 0 | 1 | 83.297 |
12239445 | GT-AG | 0 | 0.0001005165284166 | 146 | rna-XM_027997514.1 2279575 | 31 | 904243 | 904388 | Aphis gossypii 80765 | CAA|GTACGTATAC...TTTGTATTGATA/TTTGTATTGATA...TTTAG|ATG | 2 | 1 | 84.904 |
12239446 | GC-AG | 0 | 1.000000099473604e-05 | 8924 | rna-XM_027997514.1 2279575 | 32 | 895195 | 904118 | Aphis gossypii 80765 | ATC|GCTAGGGGTG...TTCTTTTTCATT/TTCTTTTTCATT...CATAG|ATG | 0 | 1 | 86.716 |
12239447 | GT-AG | 0 | 1.000000099473604e-05 | 184 | rna-XM_027997514.1 2279575 | 33 | 894830 | 895013 | Aphis gossypii 80765 | AAA|GTAAATCAAC...ACTTTTTTATTG/CACTTTTTTATT...AACAG|GTC | 1 | 1 | 89.361 |
12239448 | GT-AG | 0 | 9.584407738621096e-05 | 63 | rna-XM_027997514.1 2279575 | 34 | 894570 | 894632 | Aphis gossypii 80765 | GAT|GTAACGCGAT...GAAACTATAACT/CTATAACTAATT...CGCAG|GTC | 0 | 1 | 92.24 |
12240568 | GT-AG | 0 | 1.000000099473604e-05 | 27778 | rna-XM_027997514.1 2279575 | 1 | 1104565 | 1132342 | Aphis gossypii 80765 | TGA|GTGAGTAAAT...GTTCTCATATTG/AAAGTTCTCATA...TTTAG|GTA | 0 | 6.313 |
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]);