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 = 6831664
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35541504 | GT-AG | 0 | 0.0001108576463987 | 13031 | rna-XM_009702176.1 6831664 | 2 | 71242 | 84272 | Cariama cristata 54380 | TTG|GTAAGCATGT...GTATTTTTAGTG/ACTTCTCTTACT...TTCAG|ATG | 0 | 1 | 6.058 |
35541505 | GT-AG | 0 | 0.0003381568260548 | 3850 | rna-XM_009702176.1 6831664 | 3 | 67232 | 71081 | Cariama cristata 54380 | CAG|GTATAGTCAT...TTTTTTTTACTT/CTTTTTTTTACT...TACAG|AAA | 1 | 1 | 8.9 |
35541506 | GT-AG | 0 | 1.000000099473604e-05 | 5368 | rna-XM_009702176.1 6831664 | 4 | 61607 | 66974 | Cariama cristata 54380 | ATA|GTAAGTAAAC...ATATTCTAATCT/AATATTCTAATC...TTTAG|GTT | 0 | 1 | 13.466 |
35541507 | GT-AG | 0 | 1.000000099473604e-05 | 703 | rna-XM_009702176.1 6831664 | 5 | 60820 | 61522 | Cariama cristata 54380 | CAG|GTAGGAAAAA...AAGCCCTTATTT/AAAGCCCTTATT...CTTAG|GAA | 0 | 1 | 14.958 |
35541508 | GT-AG | 0 | 4.873856067185106e-05 | 932 | rna-XM_009702176.1 6831664 | 6 | 59763 | 60694 | Cariama cristata 54380 | TAG|GTACAGTATC...ATTCTTTTATTT/TATTCTTTTATT...TCAAG|GGA | 2 | 1 | 17.179 |
35541509 | GT-AG | 0 | 1.000000099473604e-05 | 317 | rna-XM_009702176.1 6831664 | 7 | 59405 | 59721 | Cariama cristata 54380 | TTG|GTGAGTTATT...AAGCTTTTATAT/TGAAAATTCATT...TGCAG|GTT | 1 | 1 | 17.907 |
35541510 | GT-AG | 0 | 5.5023541212248105e-05 | 1104 | rna-XM_009702176.1 6831664 | 8 | 58195 | 59298 | Cariama cristata 54380 | CGT|GTAAGTACCT...TATTCCTGAATT/TTATTCCTGAAT...TTTAG|ATT | 2 | 1 | 19.79 |
35541511 | GT-AG | 0 | 6.975980766680058e-05 | 647 | rna-XM_009702176.1 6831664 | 9 | 57401 | 58047 | Cariama cristata 54380 | TGA|GTAAGTATCA...GATTTATTGACA/GATTTATTGACA...GACAG|TAC | 2 | 1 | 22.402 |
35541512 | GT-AG | 0 | 1.000000099473604e-05 | 1349 | rna-XM_009702176.1 6831664 | 10 | 55910 | 57258 | Cariama cristata 54380 | CTG|GTGAGTGAAC...GTAATCTTGTTT/TAATGTCTAAAA...TTTAG|AAA | 0 | 1 | 24.924 |
35541513 | GT-AG | 0 | 0.0003135221321738 | 8476 | rna-XM_009702176.1 6831664 | 11 | 47329 | 55804 | Cariama cristata 54380 | ATG|GTAAGCCTTC...TTTTGCTTGACT/TTTTGCTTGACT...TGCAG|CAC | 0 | 1 | 26.79 |
35541514 | GT-AG | 0 | 0.1922971278855931 | 1374 | rna-XM_009702176.1 6831664 | 12 | 45809 | 47182 | Cariama cristata 54380 | AGA|GTATGTTTTT...TATGTTTTACAT/TTTACATTTACC...GTCAG|ACC | 2 | 1 | 29.384 |
35541515 | GT-AG | 0 | 1.9815773129934736e-05 | 96 | rna-XM_009702176.1 6831664 | 13 | 45531 | 45626 | Cariama cristata 54380 | GTA|GTAAGTAATT...AAAGTTTTAAAA/AAAGTTTTAAAA...TCCAG|TTT | 1 | 1 | 32.617 |
35541516 | GT-AG | 0 | 0.0001236040678705 | 1151 | rna-XM_009702176.1 6831664 | 14 | 44243 | 45393 | Cariama cristata 54380 | AGG|GTATTTAAAT...GTATTTTTTTTT/TTGTTTTCCATT...TGTAG|CAA | 0 | 1 | 35.051 |
35541517 | GT-AG | 0 | 0.0049192440668615 | 3269 | rna-XM_009702176.1 6831664 | 15 | 40856 | 44124 | Cariama cristata 54380 | ATG|GTATGTTTGT...TAGTATTTGACT/TAGTATTTGACT...TGCAG|GTT | 1 | 1 | 37.147 |
35541518 | GT-AG | 0 | 1.000000099473604e-05 | 1220 | rna-XM_009702176.1 6831664 | 16 | 39540 | 40759 | Cariama cristata 54380 | TTG|GTAAAAGCCT...AACCTTTTAACT/TTTTTTTTTACT...TATAG|CCT | 1 | 1 | 38.852 |
35541519 | GT-AG | 0 | 1.000000099473604e-05 | 111 | rna-XM_009702176.1 6831664 | 17 | 39262 | 39372 | Cariama cristata 54380 | CAG|GTGCATGTTT...ATCATTTTATCT/TTCAAATTCACT...TTAAG|GTT | 0 | 1 | 41.819 |
35541520 | GT-AG | 0 | 3.16489640296362e-05 | 1096 | rna-XM_009702176.1 6831664 | 18 | 38036 | 39131 | Cariama cristata 54380 | AAG|GTACTGTGAA...CTTACTTTAGCC/GGCACTCTTACT...CCAAG|GTG | 1 | 1 | 44.129 |
35541521 | GT-AG | 0 | 1.000000099473604e-05 | 634 | rna-XM_009702176.1 6831664 | 19 | 37275 | 37908 | Cariama cristata 54380 | AAG|GTAAAAAGAG...GTTTTTTTAAAA/CTTTCTCTAACA...TGTAG|GTG | 2 | 1 | 46.385 |
35541522 | GT-AG | 0 | 3.4318826934159046e-05 | 533 | rna-XM_009702176.1 6831664 | 20 | 36531 | 37063 | Cariama cristata 54380 | GAG|GTACAAATTC...CTGGTTTTATCA/CCTGGTTTTATC...CACAG|TGT | 0 | 1 | 50.133 |
35541523 | GT-AG | 0 | 1.000000099473604e-05 | 714 | rna-XM_009702176.1 6831664 | 21 | 35652 | 36365 | Cariama cristata 54380 | GAG|GTAATGAACC...ACGATTCTAATA/ACGATTCTAATA...TACAG|TGT | 0 | 1 | 53.064 |
35541524 | GT-AG | 0 | 1.000000099473604e-05 | 1701 | rna-XM_009702176.1 6831664 | 22 | 33786 | 35486 | Cariama cristata 54380 | TCA|GTGAGTACAT...TAATTTTTAATT/TAATTTTTAATT...AACAG|TGT | 0 | 1 | 55.996 |
35541525 | GT-AG | 0 | 1.000000099473604e-05 | 1310 | rna-XM_009702176.1 6831664 | 23 | 32353 | 33662 | Cariama cristata 54380 | CAA|GTAAGTTAAA...TTTTCCTCACCC/TTTTTCCTCACC...TACAG|GAA | 0 | 1 | 58.181 |
35541526 | GT-AG | 0 | 0.0048436807104154 | 294 | rna-XM_009702176.1 6831664 | 24 | 31951 | 32244 | Cariama cristata 54380 | CCA|GTATGTAATG...TGAGCTTGGACT/GCTCTCCTAAAG...GACAG|TGC | 0 | 1 | 60.099 |
35541527 | GT-AG | 0 | 0.0001842830381995 | 226 | rna-XM_009702176.1 6831664 | 25 | 31560 | 31785 | Cariama cristata 54380 | CCT|GTAAGTATTA...TAATTATTAATA/CGGTTATTAATT...GTCAG|TGC | 0 | 1 | 63.031 |
35541528 | GT-AG | 0 | 1.000000099473604e-05 | 332 | rna-XM_009702176.1 6831664 | 26 | 30937 | 31268 | Cariama cristata 54380 | GCA|GTAAGAATTT...TTTTTCTGATTA/ATTTTTCTGATT...GGTAG|TGC | 0 | 1 | 68.2 |
35541529 | GT-AG | 0 | 1.000000099473604e-05 | 1453 | rna-XM_009702176.1 6831664 | 27 | 29322 | 30774 | Cariama cristata 54380 | GAA|GTAAGATCAT...ACTCTCTTAAAA/TATGTGATGACT...TTCAG|TGT | 0 | 1 | 71.078 |
35541530 | GT-AG | 0 | 1.0820164214082344e-05 | 16156 | rna-XM_009702176.1 6831664 | 28 | 12989 | 29144 | Cariama cristata 54380 | TCG|GTACGATAGC...ATTACTTTGAGA/TTTCTTATTACT...TTCAG|TGT | 0 | 1 | 74.223 |
35541531 | GT-AG | 0 | 0.0001209926063975 | 1234 | rna-XM_009702176.1 6831664 | 29 | 11587 | 12820 | Cariama cristata 54380 | GAG|GTATGTAAAA...CTAATTTTGATC/CTAATTTTGATC...TTTAG|TGT | 0 | 1 | 77.207 |
35541532 | GT-AG | 0 | 1.000000099473604e-05 | 2986 | rna-XM_009702176.1 6831664 | 30 | 8427 | 11412 | Cariama cristata 54380 | GAT|GTAAGTAAGG...AAAACTGTGACT/GTTTTTCTCACT...CTCAG|TGC | 0 | 1 | 80.298 |
35541533 | GT-AG | 0 | 1.000000099473604e-05 | 665 | rna-XM_009702176.1 6831664 | 31 | 7591 | 8255 | Cariama cristata 54380 | CAG|GTAAACGAAC...GGTTGTTTCACA/GGTTGTTTCACA...TTCAG|TGC | 0 | 1 | 83.336 |
35541534 | GT-AG | 0 | 1.000000099473604e-05 | 127 | rna-XM_009702176.1 6831664 | 32 | 7263 | 7389 | Cariama cristata 54380 | CAA|GTGAGTACAG...TAACCCTTGCTG/TGGTTATTTACT...CCTAG|TGC | 0 | 1 | 86.907 |
35541535 | GT-AG | 0 | 1.000000099473604e-05 | 159 | rna-XM_009702176.1 6831664 | 33 | 6974 | 7132 | Cariama cristata 54380 | AAT|GTAAGTGATA...TATGATTTAATC/TAATCATTCATT...TGAAG|GTG | 1 | 1 | 89.217 |
35541536 | GT-AG | 0 | 0.0030866386143249 | 97 | rna-XM_009702176.1 6831664 | 34 | 6782 | 6878 | Cariama cristata 54380 | AAG|GTACTCTTAA...ACTTTTCTAATA/ACTTTTCTAATA...TCCAG|ATT | 0 | 1 | 90.904 |
35541537 | GT-AG | 0 | 1.000000099473604e-05 | 405 | rna-XM_009702176.1 6831664 | 35 | 6282 | 6686 | Cariama cristata 54380 | CAG|GTACAAAAGT...AAATCTTTGCTA/TGTTGTGTTATG...TCTAG|GCT | 2 | 1 | 92.592 |
35541538 | GT-AG | 0 | 0.0004518037499894 | 737 | rna-XM_009702176.1 6831664 | 36 | 5411 | 6147 | Cariama cristata 54380 | AAA|GTAAGCATTT...TTCACCTGAACT/TGTTAAGTAATT...TCTAG|CCA | 1 | 1 | 94.972 |
35541539 | GT-AG | 0 | 0.0013431432252095 | 2878 | rna-XM_009702176.1 6831664 | 37 | 2441 | 5318 | Cariama cristata 54380 | CAG|GTATTTATGG...TGTATTTTACCT/CTGTATTTTACC...GTTAG|GGA | 0 | 1 | 96.607 |
35541540 | GT-AG | 0 | 1.6687960078692333e-05 | 646 | rna-XM_009702176.1 6831664 | 38 | 1690 | 2335 | Cariama cristata 54380 | CAC|GTAAGTCAAT...CTTTTCTTGATT/CTTTGTCTAATT...CCCAG|GAT | 0 | 1 | 98.472 |
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]);