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)
33 rows where transcript_id = 26266730
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145335532 | GT-AG | 0 | 1.000000099473604e-05 | 39 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 1 | 347466 | 347504 | Paragonimus skrjabini miyazakii 59628 | AAT|GTGAGCCGCT...CCGTTTTTGAGT/CCGTTTTTGAGT...TTCAG|ATA | 2 | 1 | 0.264 |
145335533 | GT-AG | 0 | 1.000000099473604e-05 | 5491 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 2 | 341804 | 347294 | Paragonimus skrjabini miyazakii 59628 | GAG|GTAAATCAAT...TGCGCCTAACCA/TTGTATCTCATT...CTCAG|CAT | 2 | 1 | 2.525 |
145335534 | GT-AG | 0 | 1.3437692843390995e-05 | 2137 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 3 | 339062 | 341198 | Paragonimus skrjabini miyazakii 59628 | TCG|GTAAGTTGTG...TCAATTTTAAAC/AATTTTGTTATT...TACAG|GGG | 1 | 1 | 10.525 |
145335535 | GT-AG | 0 | 2.5092375889513027e-05 | 342 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 4 | 338433 | 338774 | Paragonimus skrjabini miyazakii 59628 | AAA|GTAAGCAACA...TTTCTCGTAATA/TAGATACTTACT...CGCAG|GTG | 0 | 1 | 14.32 |
145335536 | GT-AG | 0 | 1.000000099473604e-05 | 670 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 5 | 337630 | 338299 | Paragonimus skrjabini miyazakii 59628 | AAA|GTGAGTTTGT...TTTTTTTTGTTT/TTGTTTCTCACA...TCCAG|AGG | 1 | 1 | 16.078 |
145335537 | GT-AG | 0 | 1.000000099473604e-05 | 3751 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 6 | 333499 | 337249 | Paragonimus skrjabini miyazakii 59628 | AAG|GTTAGAAAAC...AATATCTTAATT/AATATCTTAATT...AACAG|GTT | 0 | 1 | 21.103 |
145335538 | GT-AG | 0 | 0.0006732466987661 | 2078 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 7 | 331285 | 333362 | Paragonimus skrjabini miyazakii 59628 | CGC|GTAAGTTGCA...TTTCTTTTAACG/TAAATGCTCATT...TAAAG|AAA | 1 | 1 | 22.901 |
145335539 | GT-AG | 0 | 0.0001166920598821 | 1848 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 8 | 329138 | 330985 | Paragonimus skrjabini miyazakii 59628 | AAA|GTAGGTTATT...AACTTCTTGCTT/AACTATATTATT...TTCAG|ATC | 0 | 1 | 26.854 |
145335540 | GT-AG | 0 | 1.000000099473604e-05 | 1554 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 9 | 327448 | 329001 | Paragonimus skrjabini miyazakii 59628 | AAG|GTAAGTCATA...GATTACTTAACT/ACTTAACTAACT...TTCAG|TCT | 1 | 1 | 28.653 |
145335541 | GT-AG | 0 | 5.428283964633262e-05 | 9426 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 10 | 317867 | 327292 | Paragonimus skrjabini miyazakii 59628 | CAG|GTAGGTTTTC...TATTCCGTATAA/TCATTACTAAAA...CCCAG|ATG | 0 | 1 | 30.702 |
145335542 | GT-AG | 0 | 1.000000099473604e-05 | 2306 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 11 | 315403 | 317708 | Paragonimus skrjabini miyazakii 59628 | TCG|GTAAGTTCAA...TTGCTCATAAAA/TTGTTGCTCATA...TCCAG|CTG | 2 | 1 | 32.791 |
145335543 | GT-AG | 0 | 1.000000099473604e-05 | 1757 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 12 | 313578 | 315334 | Paragonimus skrjabini miyazakii 59628 | AAG|GTAAGCACTT...TTCCGTTTAATT/TACATTTTCATA...TCTAG|ATT | 1 | 1 | 33.69 |
145335544 | GT-AG | 0 | 1.000000099473604e-05 | 1560 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 13 | 311824 | 313383 | Paragonimus skrjabini miyazakii 59628 | GAG|GTTAGTTGCC...TTTGCCTTTTCT/TCTGTTTTCAAC...ATTAG|CTC | 0 | 1 | 36.255 |
145335545 | GT-AG | 0 | 7.48151773154093e-05 | 1245 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 14 | 310386 | 311630 | Paragonimus skrjabini miyazakii 59628 | AAA|GTAAGTTCAA...TGTCACTTAACT/TTTCTTGTGATT...CTCAG|CCG | 1 | 1 | 38.807 |
145335546 | GT-AG | 0 | 1.000000099473604e-05 | 653 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 15 | 309566 | 310218 | Paragonimus skrjabini miyazakii 59628 | AAA|GTAAGCACAC...TTTGCCGAAACC/ATGTGTGTAAAT...TTCAG|GTA | 0 | 1 | 41.015 |
145335547 | GT-AG | 0 | 3.628024828978615e-05 | 604 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 16 | 308781 | 309384 | Paragonimus skrjabini miyazakii 59628 | CTG|GTATGAATAT...CAATGTTTAATT/CAATGTTTAATT...TTCAG|CCT | 1 | 1 | 43.409 |
145335548 | GT-AG | 0 | 0.0013297764583903 | 2202 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 17 | 306339 | 308540 | Paragonimus skrjabini miyazakii 59628 | TCA|GTAAGTTTTC...TTCATTTTATTT/ATTTTATTTATT...TATAG|AAT | 1 | 1 | 46.582 |
145335549 | GT-AG | 0 | 1.000000099473604e-05 | 6662 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 18 | 299507 | 306168 | Paragonimus skrjabini miyazakii 59628 | GAG|GTCAGTCTCT...ATTTTTTCAATG/GATTTTTTCAAT...CACAG|TTG | 0 | 1 | 48.83 |
145335550 | GT-AG | 0 | 1.000000099473604e-05 | 1699 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 19 | 297537 | 299235 | Paragonimus skrjabini miyazakii 59628 | CCG|GTAAGCAAGC...ATTTGCTAAGTG/ATTGGTCTCATA...TTCAG|ATC | 1 | 1 | 52.413 |
145335551 | GT-AG | 0 | 1.000000099473604e-05 | 1467 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 20 | 295841 | 297307 | Paragonimus skrjabini miyazakii 59628 | CCA|GTGAGTTGCG...ATGGTCTTGTAT/TTCTGTTTCATA...ATCAG|TAT | 2 | 1 | 55.441 |
145335552 | GT-AG | 0 | 0.003146788690303 | 2599 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 21 | 293057 | 295655 | Paragonimus skrjabini miyazakii 59628 | CAA|GTATGACTTA...CTCATTTTAATT/TTGTTTTTCACT...ATCAG|CTA | 1 | 1 | 57.887 |
145335553 | GT-AG | 0 | 7.862382236333285e-05 | 2527 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 22 | 290234 | 292760 | Paragonimus skrjabini miyazakii 59628 | GAG|GTACGCAGAC...CAAATTTTAGTG/GTAAAACTCAAC...TGCAG|ATA | 0 | 1 | 61.801 |
145335554 | GT-AG | 0 | 0.0001268189130177 | 3887 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 23 | 286041 | 289927 | Paragonimus skrjabini miyazakii 59628 | CAC|GTAAGTATCG...GTGCTTTTATCA/GCTTTTATCATC...ACAAG|ACC | 0 | 1 | 65.847 |
145335555 | GT-AG | 0 | 1.000000099473604e-05 | 1562 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 24 | 284019 | 285580 | Paragonimus skrjabini miyazakii 59628 | CAA|GTAAGTGTAA...AGAATGTTACTC/AAGTGACTAATG...CACAG|CGA | 1 | 1 | 71.929 |
145335556 | GT-AG | 0 | 1.000000099473604e-05 | 1533 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 25 | 282277 | 283809 | Paragonimus skrjabini miyazakii 59628 | GAG|GTAATACTTA...CTCTCCGTAACC/CTTTTGCTGAAT...TTCAG|GTC | 0 | 1 | 74.693 |
145335557 | GT-AG | 0 | 7.255292176270087e-05 | 486 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 26 | 281604 | 282089 | Paragonimus skrjabini miyazakii 59628 | AAT|GTAAGTTACC...TTTTTTTTCACG/TTTTTTTTCACG...CTTAG|TGA | 1 | 1 | 77.165 |
145335558 | GT-AG | 0 | 1.000000099473604e-05 | 2809 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 27 | 278577 | 281385 | Paragonimus skrjabini miyazakii 59628 | CAA|GTAAGTTGCC...TCATTCTTTTCA/ATGTGCTTCATT...CACAG|GGT | 0 | 1 | 80.048 |
145335559 | GT-AG | 0 | 0.0537983952649838 | 6487 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 28 | 271924 | 278410 | Paragonimus skrjabini miyazakii 59628 | GAA|GTATGCTATT...ACCACCTAAAAC/TGTGCACTCACG...CACAG|GTG | 1 | 1 | 82.242 |
145335560 | GT-AG | 0 | 0.0006833929643881 | 1255 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 29 | 270514 | 271768 | Paragonimus skrjabini miyazakii 59628 | GCT|GTAAGTTGCT...TTGTCATTAACA/TAGTTATTAATT...GACAG|GTA | 0 | 1 | 84.292 |
145335561 | GT-AG | 0 | 0.0001581338242513 | 2334 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 30 | 267825 | 270158 | Paragonimus skrjabini miyazakii 59628 | TTG|GTAAGTTTGC...TGAACTTTATTT/TTGAACTTTATT...ATAAG|CCT | 1 | 1 | 88.986 |
145335562 | GT-AG | 0 | 0.1701757661946858 | 3271 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 31 | 264394 | 267664 | Paragonimus skrjabini miyazakii 59628 | CAA|GTATGCTTCA...AGGTTCCTACCA/GCTAAGTTTACA...ACTAG|GCT | 2 | 1 | 91.101 |
145335563 | GT-AG | 0 | 1.000000099473604e-05 | 1979 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 32 | 262125 | 264103 | Paragonimus skrjabini miyazakii 59628 | GAG|GTAAGCCATT...TTGATCTTGCCA/CCTCGGTTGATC...GTCAG|AAA | 1 | 1 | 94.936 |
145335564 | GT-AG | 0 | 1.000000099473604e-05 | 3105 | rna-gnl|WGS:JTDE|EG68_00146 26266730 | 33 | 258822 | 261926 | Paragonimus skrjabini miyazakii 59628 | TTG|GTAAGATCAG...TTTCTCTTCTCT/TGTTTATTCATC...GATAG|GTA | 1 | 1 | 97.554 |
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]);