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 = 26266747
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145335657 | GT-AG | 0 | 1.000000099473604e-05 | 40 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 2 | 258975 | 259014 | Paragonimus skrjabini miyazakii 59628 | AAG|GTTAGTCGTC...AAAAGCTAAACG/CAAAAGCTAAAC...TTCAG|AAT | 0 | 1 | 3.794 |
145335658 | GT-AG | 0 | 1.000000099473604e-05 | 37 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 3 | 259073 | 259109 | Paragonimus skrjabini miyazakii 59628 | TCG|GTAAGTGATC...GTGTTAGTAATC/GTGTTAGTAATC...TTCAG|ATA | 1 | 1 | 4.996 |
145335659 | GT-AG | 0 | 1.000000099473604e-05 | 4402 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 4 | 259589 | 263990 | Paragonimus skrjabini miyazakii 59628 | CAG|GTAAGTCGAC...CATGGTTTATTT/TGATTGCTGATT...TGCAG|GAA | 0 | 1 | 14.925 |
145335660 | GT-AG | 0 | 5.170560719625142e-05 | 12141 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 5 | 264084 | 276224 | Paragonimus skrjabini miyazakii 59628 | CAT|GTAAGTATTG...GAATCCTTGTTC/TCCTTGTTCATT...TCTAG|TTA | 0 | 1 | 16.853 |
145335661 | GT-AG | 0 | 1.000000099473604e-05 | 1002 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 6 | 276615 | 277616 | Paragonimus skrjabini miyazakii 59628 | TTG|GTTAGTTTAA...TTGGTCTTTTCA/TTTTCATTCATT...TTTAG|TAT | 0 | 1 | 24.938 |
145335662 | GT-AG | 0 | 1.000000099473604e-05 | 1667 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 7 | 277790 | 279456 | Paragonimus skrjabini miyazakii 59628 | AAA|GTAAGTAATA...GCTTGTTTGATG/GCTTGTTTGATG...ATCAG|AGT | 2 | 1 | 28.524 |
145335663 | GT-AG | 0 | 1.000000099473604e-05 | 1107 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 8 | 279683 | 280789 | Paragonimus skrjabini miyazakii 59628 | CCG|GTGGGTGTGA...AACTTTTCAACC/GAACTTTTCAAC...TCAAG|AAC | 0 | 1 | 33.209 |
145335664 | GT-AG | 0 | 0.001929585142426 | 1394 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 9 | 280942 | 282335 | Paragonimus skrjabini miyazakii 59628 | CCG|GTAATTTTTA...TACTTTTTAGCA/ATACTTTTTAGC...TCCAG|CTA | 2 | 1 | 36.36 |
145335665 | GT-AG | 0 | 5.6453512948627546e-05 | 1111 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 10 | 282438 | 283548 | Paragonimus skrjabini miyazakii 59628 | GAA|GTAAGCGCTT...GCCTTTTTACCT/CTTCTTCTGATA...GATAG|ACG | 2 | 1 | 38.474 |
145335666 | GT-AG | 0 | 1.1351938856402729e-05 | 870 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 11 | 283634 | 284503 | Paragonimus skrjabini miyazakii 59628 | CAC|GTAAGTATAA...CTCCCCTCAATC/TCGTAAATTATT...GACAG|GTT | 0 | 1 | 40.236 |
145335667 | GT-AG | 0 | 1.000000099473604e-05 | 2780 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 12 | 284598 | 287377 | Paragonimus skrjabini miyazakii 59628 | CGT|GTAAGTGATT...TGTCTTTTATTG/GTGTCTTTTATT...TACAG|TTT | 1 | 1 | 42.185 |
145335668 | GT-AG | 0 | 0.008058008161091 | 464 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 13 | 287450 | 287913 | Paragonimus skrjabini miyazakii 59628 | AAG|GTATGCATCT...GTTTCTTTCTTT/AGATGTTTGATA...CCCAG|CTC | 1 | 1 | 43.677 |
145335669 | GT-AG | 0 | 1.000000099473604e-05 | 623 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 14 | 288011 | 288633 | Paragonimus skrjabini miyazakii 59628 | AAG|GTAAGCAAAC...GTTGCCTTCTCC/TATCTATTTATG...TTCAG|TTA | 2 | 1 | 45.688 |
145335670 | GT-AG | 0 | 1.000000099473604e-05 | 1342 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 15 | 288932 | 290273 | Paragonimus skrjabini miyazakii 59628 | CAG|GTAGGTAGCG...TTCTCTTCAATG/CTATTGTTTACT...TCTAG|TGT | 0 | 1 | 51.866 |
145335671 | GT-AG | 0 | 1.000000099473604e-05 | 1191 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 16 | 290439 | 291629 | Paragonimus skrjabini miyazakii 59628 | TCT|GTGAGTTGGA...TTTGTGTTATTT/TTTTGTGTTATT...ATTAG|CGC | 0 | 1 | 55.286 |
145335672 | GT-AG | 0 | 1.000000099473604e-05 | 1556 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 17 | 291699 | 293254 | Paragonimus skrjabini miyazakii 59628 | AAG|GTGAGCATAT...CTACGCTTAATT/GCTTAATTTATC...TCTAG|GCA | 0 | 1 | 56.716 |
145335673 | GT-AG | 0 | 1.000000099473604e-05 | 1476 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 18 | 293477 | 294952 | Paragonimus skrjabini miyazakii 59628 | TGG|GTGAGGTCTT...AATGTCTGACCG/AAATGTCTGACC...TACAG|ACT | 0 | 1 | 61.318 |
145335674 | GT-AG | 0 | 1.000000099473604e-05 | 5558 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 19 | 295256 | 300813 | Paragonimus skrjabini miyazakii 59628 | CGT|GTGAGTGCTG...GGTTTCTTTTTT/GATTACTTCACT...TGCAG|ATC | 0 | 1 | 67.6 |
145335675 | GT-AG | 0 | 0.0009509216039175 | 4003 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 20 | 300985 | 304987 | Paragonimus skrjabini miyazakii 59628 | AAG|GTAACTTCTG...AGACACTTACTT/CACTTACTTATG...TTCAG|GGT | 0 | 1 | 71.144 |
145335676 | GT-AG | 0 | 1.000000099473604e-05 | 887 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 21 | 305246 | 306132 | Paragonimus skrjabini miyazakii 59628 | AAG|GTTCGTCATT...TTTTTCCTACTC/TTCCTACTCATT...ACAAG|GCT | 0 | 1 | 76.493 |
145335677 | GT-AG | 0 | 1.000000099473604e-05 | 1276 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 22 | 306488 | 307763 | Paragonimus skrjabini miyazakii 59628 | ATG|GTGAGTGCAT...ACTACCTAAATC/AACTACCTAAAT...CATAG|ACG | 1 | 1 | 83.852 |
145335678 | GT-AG | 0 | 1.000000099473604e-05 | 1722 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 23 | 307921 | 309642 | Paragonimus skrjabini miyazakii 59628 | ACA|GTAAGTGTTT...GGAACATTAAGT/GTTACACTCACG...TTCAG|ACG | 2 | 1 | 87.106 |
145335679 | GT-AG | 0 | 1.000000099473604e-05 | 216 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 24 | 309711 | 309926 | Paragonimus skrjabini miyazakii 59628 | AAG|GTCAGTATTA...TCGATCTTCATC/TCGATCTTCATC...GCTAG|GTT | 1 | 1 | 88.516 |
145335680 | GT-AG | 0 | 1.000000099473604e-05 | 34379 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 25 | 310025 | 344403 | Paragonimus skrjabini miyazakii 59628 | AAG|GTGAGCAGTC...ACGATGTTGATA/CCTCGTTTCACA...TCCAG|GGA | 0 | 1 | 90.547 |
145335681 | GT-AG | 0 | 1.000000099473604e-05 | 3380 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 26 | 344720 | 348099 | Paragonimus skrjabini miyazakii 59628 | GAA|GTGAGTCAAG...TTTTTTCTATTT/TTTTTTTCTATT...TGTAG|CGC | 1 | 1 | 97.098 |
145335697 | GT-AG | 0 | 4.0315196935815735e-05 | 225 | rna-gnl|WGS:JTDE|EG68_00056 26266747 | 1 | 258623 | 258847 | Paragonimus skrjabini miyazakii 59628 | GTG|GTAAGTTGTA...GATTTTTTATTC/AGATTTTTTATT...TTTAG|TTT | 0 | 3.109 |
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]);