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)
37 rows where transcript_id = 6831576
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35540458 | GT-AG | 0 | 1.000000099473604e-05 | 194 | rna-XM_009708808.1 6831576 | 1 | 918 | 1111 | Cariama cristata 54380 | GAG|GTAAGGAAAA...GCTGCCTGATCT/TATTTTCTCACA...CCCAG|CTA | 0 | 1 | 2.269 |
35540459 | GT-AG | 0 | 1.000000099473604e-05 | 401 | rna-XM_009708808.1 6831576 | 2 | 1304 | 1704 | Cariama cristata 54380 | AAG|GTGAGAAGCT...TTTTTCTCAGAG/CTTTTTCTCAGA...CACAG|GAG | 0 | 1 | 5.672 |
35540460 | GT-AG | 0 | 1.000000099473604e-05 | 436 | rna-XM_009708808.1 6831576 | 3 | 1824 | 2259 | Cariama cristata 54380 | CAG|GTGAAGTGCA...CTTTTCTTAACT/CTTTTCTTAACT...TGCAG|GCC | 2 | 1 | 7.781 |
35540461 | GT-AG | 0 | 1.000000099473604e-05 | 87 | rna-XM_009708808.1 6831576 | 4 | 2502 | 2588 | Cariama cristata 54380 | AAG|GTGAGATCAA...GTCTTTCTGACT/GTCTTTCTGACT...CCCAG|GAC | 1 | 1 | 12.07 |
35540462 | GT-AG | 0 | 2.92575510265488e-05 | 131 | rna-XM_009708808.1 6831576 | 5 | 2717 | 2847 | Cariama cristata 54380 | TCA|GTAAGTGACG...TTTCTTTTACCT/TTTTCTTTTACC...ATCAG|AGT | 0 | 1 | 14.339 |
35540463 | GT-AG | 0 | 3.129459242989538e-05 | 432 | rna-XM_009708808.1 6831576 | 6 | 2984 | 3415 | Cariama cristata 54380 | AAG|GTATTGATGC...AACTCCTCACCA/TAACTCCTCACC...TGCAG|GTG | 1 | 1 | 16.749 |
35540464 | GT-AG | 0 | 1.000000099473604e-05 | 132 | rna-XM_009708808.1 6831576 | 7 | 3598 | 3729 | Cariama cristata 54380 | TGT|GTGAGTACTG...GTTTTCTGATTT/GGTTTTCTGATT...TGTAG|GAA | 0 | 1 | 19.975 |
35540465 | GT-AG | 0 | 1.000000099473604e-05 | 942 | rna-XM_009708808.1 6831576 | 8 | 3970 | 4911 | Cariama cristata 54380 | ACT|GTGAGTTTCT...CTCTGTTTAACT/CTCTGTTTAACT...TTCAG|TGC | 0 | 1 | 24.229 |
35540466 | GT-AG | 0 | 1.000000099473604e-05 | 86 | rna-XM_009708808.1 6831576 | 9 | 5116 | 5201 | Cariama cristata 54380 | CAG|GTGAGTGATG...AACATCCTAGTA/ATCCTAGTAACT...TCCAG|CTG | 0 | 1 | 27.845 |
35540467 | GT-AG | 0 | 1.000000099473604e-05 | 228 | rna-XM_009708808.1 6831576 | 10 | 5408 | 5635 | Cariama cristata 54380 | TAG|GTAGGGGAGG...TAAGACTTACTG/TTAAGACTTACT...CACAG|TGT | 2 | 1 | 31.496 |
35540468 | GT-AG | 0 | 1.000000099473604e-05 | 305 | rna-XM_009708808.1 6831576 | 11 | 5768 | 6072 | Cariama cristata 54380 | CAG|GTAAGAGAAA...AAGCCATTAAAC/CAGTCTGTTACA...CATAG|GGA | 2 | 1 | 33.836 |
35540469 | GT-AG | 0 | 6.588235170240886e-05 | 384 | rna-XM_009708808.1 6831576 | 12 | 6170 | 6553 | Cariama cristata 54380 | GAT|GTAAGTTACT...TCTTCCTTCTTT/AGTTGTCTAACC...TGTAG|CCA | 0 | 1 | 35.555 |
35540470 | GT-AG | 0 | 1.000000099473604e-05 | 150 | rna-XM_009708808.1 6831576 | 13 | 6746 | 6895 | Cariama cristata 54380 | GAG|GTGAGAGCTG...ATACTCTTACTG/CTCTTACTGACT...CATAG|GGC | 0 | 1 | 38.958 |
35540471 | GT-AG | 0 | 1.000000099473604e-05 | 1008 | rna-XM_009708808.1 6831576 | 14 | 7097 | 8104 | Cariama cristata 54380 | AAG|GTACAGAACT...TCATCCTTTTCC/ACCATGTTCATC...TGCAG|AAG | 0 | 1 | 42.52 |
35540472 | GT-AG | 0 | 1.000000099473604e-05 | 2014 | rna-XM_009708808.1 6831576 | 15 | 8243 | 10256 | Cariama cristata 54380 | AAG|GTACAGAGAA...CATTTCTTCACC/CATTTCTTCACC...TCCAG|TTC | 0 | 1 | 44.966 |
35540473 | GT-AG | 0 | 0.0362441148558931 | 109 | rna-XM_009708808.1 6831576 | 16 | 10364 | 10472 | Cariama cristata 54380 | CCA|GTATGTCTTG...TTCTCCTTTGTG/CTTTTGCTGAGT...TGCAG|TAA | 2 | 1 | 46.863 |
35540474 | GT-AG | 0 | 1.000000099473604e-05 | 319 | rna-XM_009708808.1 6831576 | 17 | 10647 | 10965 | Cariama cristata 54380 | GAA|GTGAGTGTGA...TTCTCTTTTTCT/ATGTTAGTCATT...TTCAG|GAA | 2 | 1 | 49.947 |
35540475 | GT-AG | 0 | 0.0005907761058897 | 471 | rna-XM_009708808.1 6831576 | 18 | 11108 | 11578 | Cariama cristata 54380 | ATG|GTATGTCCAG...CACCCCTTACTC/CCACCCCTTACT...CTCAG|GAA | 0 | 1 | 52.464 |
35540476 | GT-AG | 0 | 0.0001106026005046 | 112 | rna-XM_009708808.1 6831576 | 19 | 11711 | 11822 | Cariama cristata 54380 | CAG|GTATATGAGG...ATCCCCTTGTCC/GTTTTTCTGATG...TGCAG|ATG | 0 | 1 | 54.803 |
35540477 | GT-AG | 0 | 6.072069085254858e-05 | 209 | rna-XM_009708808.1 6831576 | 20 | 11941 | 12149 | Cariama cristata 54380 | ATG|GTATGGAGTC...CTCTCCCTGATT/CTCTCCCTGATT...CTAAG|CTC | 1 | 1 | 56.895 |
35540478 | GT-AG | 0 | 1.000000099473604e-05 | 287 | rna-XM_009708808.1 6831576 | 21 | 12275 | 12561 | Cariama cristata 54380 | CAG|GTGAGTCTGA...TAGCTCTAGACT/ACTGTTCTGAGC...TCTAG|GCC | 0 | 1 | 59.11 |
35540479 | GT-AG | 0 | 1.000000099473604e-05 | 166 | rna-XM_009708808.1 6831576 | 22 | 12800 | 12965 | Cariama cristata 54380 | GGG|GTGAGTGCCT...AGTCCCTTGAGA/GATCCACTCAGC...CTCAG|GGG | 1 | 1 | 63.329 |
35540480 | GT-AG | 0 | 1.000000099473604e-05 | 162 | rna-XM_009708808.1 6831576 | 23 | 13139 | 13300 | Cariama cristata 54380 | GGG|GTGAGTATGA...GGGCTCTAAATT/AAATTTGTTACT...GGCAG|GAG | 0 | 1 | 66.395 |
35540481 | GT-AG | 0 | 1.000000099473604e-05 | 100 | rna-XM_009708808.1 6831576 | 24 | 13482 | 13581 | Cariama cristata 54380 | GAG|GTACAAATCC...TGCTGTTTTTCT/CTCAGGCTCACG...TTCAG|ACT | 1 | 1 | 69.603 |
35540482 | GT-AG | 0 | 0.0001283760320504 | 171 | rna-XM_009708808.1 6831576 | 25 | 13669 | 13839 | Cariama cristata 54380 | AAG|GTAAGTTCTG...TCTTCCTTAGCT/CTCTTCCTTAGC...TTCAG|CAG | 1 | 1 | 71.145 |
35540483 | GT-AG | 0 | 1.000000099473604e-05 | 86 | rna-XM_009708808.1 6831576 | 26 | 13929 | 14014 | Cariama cristata 54380 | GAG|GTAAGTAGTG...CTTGCCATATCT/TCTTGCCATATC...TCTAG|GTC | 0 | 1 | 72.722 |
35540484 | GT-AG | 0 | 1.000000099473604e-05 | 504 | rna-XM_009708808.1 6831576 | 27 | 14149 | 14652 | Cariama cristata 54380 | CAA|GTGAGTCTGC...TGTCTCTCAACT/TTGTCTCTCAAC...TCCAG|GGC | 2 | 1 | 75.097 |
35540485 | GT-AG | 0 | 1.000000099473604e-05 | 186 | rna-XM_009708808.1 6831576 | 28 | 14798 | 14983 | Cariama cristata 54380 | AAG|GTAGGTGTCT...TTTCTCTTCCTC/CTTTGTATGACT...TGCAG|GTG | 0 | 1 | 77.667 |
35540486 | GT-AG | 0 | 1.000000099473604e-05 | 373 | rna-XM_009708808.1 6831576 | 29 | 15150 | 15522 | Cariama cristata 54380 | CTG|GTGAGAGCTC...TTCTCTTTTGTG/TGCTGTGCTACT...CACAG|AAG | 1 | 1 | 80.61 |
35540487 | GT-AG | 0 | 1.000000099473604e-05 | 220 | rna-XM_009708808.1 6831576 | 30 | 15633 | 15852 | Cariama cristata 54380 | GAG|GTGAGTGTTG...TTCTCATTGATT/CCACTTCTCATT...CTCAG|CAG | 0 | 1 | 82.559 |
35540488 | GT-AG | 0 | 0.9305394730769492 | 261 | rna-XM_009708808.1 6831576 | 31 | 15989 | 16249 | Cariama cristata 54380 | AAG|GTATCCCTAG...TCCCTCTTCTCT/CTACATCTCATG...TGCAG|CTG | 1 | 1 | 84.97 |
35540489 | GT-AG | 0 | 1.000000099473604e-05 | 112 | rna-XM_009708808.1 6831576 | 32 | 16328 | 16439 | Cariama cristata 54380 | AAG|GTAAGTCATA...TTCTTTCTAATA/TTCTTTCTAATA...TACAG|ATG | 1 | 1 | 86.352 |
35540490 | GT-AG | 0 | 1.000000099473604e-05 | 97 | rna-XM_009708808.1 6831576 | 33 | 16578 | 16674 | Cariama cristata 54380 | CTG|GTATGAGGAA...TAACTTTTGAAC/CTTGTATTCATG...TCCAG|AGC | 1 | 1 | 88.798 |
35540491 | GT-AG | 0 | 74.58369939831847 | 317 | rna-XM_009708808.1 6831576 | 34 | 16784 | 17100 | Cariama cristata 54380 | CAA|GTATCCTTAG...TTTGCCTGAGCT/CTTGTTCTCACT...CTCAG|TCA | 2 | 1 | 90.73 |
35540492 | GT-AG | 0 | 1.000000099473604e-05 | 978 | rna-XM_009708808.1 6831576 | 35 | 17234 | 18211 | Cariama cristata 54380 | AAG|GTAAGGATTT...TTTCTCTCATTA/CTTTCTCTCATT...TGCAG|CTT | 0 | 1 | 93.088 |
35540493 | GT-AG | 0 | 1.000000099473604e-05 | 115 | rna-XM_009708808.1 6831576 | 36 | 18408 | 18522 | Cariama cristata 54380 | AAG|GTAATGCAGT...TATCCCTTTCCC/TCCCCTCTGAAC...TCCAG|TTT | 1 | 1 | 96.562 |
35540494 | GT-AG | 0 | 1.000000099473604e-05 | 122 | rna-XM_009708808.1 6831576 | 37 | 18699 | 18820 | Cariama cristata 54380 | CAA|GTGCGTACCT...GGTCCCTTGACC/TCTTCTCTCACC...TACAG|GTG | 0 | 1 | 99.681 |
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]);