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)
17 rows where transcript_id = 2107333
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11507236 | GT-AG | 0 | 1.000000099473604e-05 | 9313 | rna-XM_009879294.1 2107333 | 1 | 24951 | 34263 | Apaloderma vittatum 57397 | CCT|GTAAGTACGA...TGGCTCTGAGCT/GTGGCTCTGAGC...TATAG|GCT | 0 | 1 | 9.326 |
11507237 | GT-AG | 0 | 0.000384635705437 | 15669 | rna-XM_009879294.1 2107333 | 2 | 34385 | 50053 | Apaloderma vittatum 57397 | TAC|GTAAGTATAA...TCTCCCTTAATT/TCTCCCTTAATT...AACAG|AGG | 1 | 1 | 16.292 |
11507238 | GT-AG | 0 | 1.000000099473604e-05 | 7030 | rna-XM_009879294.1 2107333 | 3 | 50175 | 57204 | Apaloderma vittatum 57397 | AAG|GTAAGAGAAA...AAATTCTTCATC/AAATTCTTCATC...TTTAG|GAC | 2 | 1 | 23.258 |
11507239 | GT-AG | 0 | 0.0001259451010178 | 1799 | rna-XM_009879294.1 2107333 | 4 | 57267 | 59065 | Apaloderma vittatum 57397 | CAG|GTAATCTTGC...ATTATCCTGATA/CTGATACTTACT...TATAG|ATA | 1 | 1 | 26.828 |
11507240 | GT-AG | 0 | 1.000000099473604e-05 | 462 | rna-XM_009879294.1 2107333 | 5 | 59199 | 59660 | Apaloderma vittatum 57397 | AAG|GTAAAACTCT...TTGCTTTTATCC/GTTGCTTTTATC...TTCAG|GTT | 2 | 1 | 34.485 |
11507241 | GT-AG | 0 | 1.000000099473604e-05 | 2040 | rna-XM_009879294.1 2107333 | 6 | 59687 | 61726 | Apaloderma vittatum 57397 | TAA|GTAAGTACTC...TGTTTTTTCTCC/CTAATTCTAACA...TTTAG|AGA | 1 | 1 | 35.982 |
11507242 | GT-AG | 0 | 0.0032098588637393 | 2526 | rna-XM_009879294.1 2107333 | 7 | 61819 | 64344 | Apaloderma vittatum 57397 | ATT|GTAAGTTATC...TTCTTCTTAATC/TTTCTTCTTAAT...TGCAG|ATT | 0 | 1 | 41.278 |
11507243 | GT-AG | 0 | 0.0015873226386812 | 991 | rna-XM_009879294.1 2107333 | 8 | 64437 | 65427 | Apaloderma vittatum 57397 | CAG|GTATTTACAT...CTCTCTTTAACT/CTCTCTTTAACT...TCTAG|GGG | 2 | 1 | 46.575 |
11507244 | GT-AG | 0 | 1.4464123215154636e-05 | 819 | rna-XM_009879294.1 2107333 | 9 | 65477 | 66295 | Apaloderma vittatum 57397 | GTG|GTAGGTCTTT...TCCGTTTTAAGT/TCCGTTTTAAGT...CCAAG|GAA | 0 | 1 | 49.396 |
11507245 | GT-AG | 0 | 5.517772259439898e-05 | 1503 | rna-XM_009879294.1 2107333 | 10 | 66368 | 67870 | Apaloderma vittatum 57397 | CAG|GTACTGTGCT...TTGGTTTTAATT/TTGGTTTTAATT...TGCAG|AAC | 0 | 1 | 53.541 |
11507246 | GT-AG | 0 | 6.144713640000839e-05 | 101 | rna-XM_009879294.1 2107333 | 11 | 67915 | 68015 | Apaloderma vittatum 57397 | AAA|GTAAGTTATC...GTTTTCTTTTTT/ACACTAGTAATA...TTCAG|CTT | 2 | 1 | 56.074 |
11507247 | GT-AG | 0 | 0.0001319135389972 | 1196 | rna-XM_009879294.1 2107333 | 12 | 68126 | 69321 | Apaloderma vittatum 57397 | TGG|GTAAACACAA...GATTTCTTGATA/GATTTCTTGATA...TTCAG|GAC | 1 | 1 | 62.406 |
11507248 | GT-AG | 0 | 1.000000099473604e-05 | 3880 | rna-XM_009879294.1 2107333 | 13 | 69477 | 73356 | Apaloderma vittatum 57397 | CGG|GTAAGGGTAA...GTTTTCTTTTTC/CAGCTGTTCAAA...TGCAG|CTT | 0 | 1 | 71.33 |
11507249 | GT-AG | 0 | 1.000000099473604e-05 | 461 | rna-XM_009879294.1 2107333 | 14 | 73505 | 73965 | Apaloderma vittatum 57397 | CAG|GTATGACGCA...TTTCTCATGATT/CTTTTTCTCAAA...TTCAG|TGT | 1 | 1 | 79.85 |
11507250 | GT-AG | 0 | 1.000000099473604e-05 | 1064 | rna-XM_009879294.1 2107333 | 15 | 74060 | 75123 | Apaloderma vittatum 57397 | AAA|GTGAGTCATT...TGTTTCATAACA/CTTTGTTTCATA...TTCAG|TTA | 2 | 1 | 85.262 |
11507251 | GT-AG | 0 | 0.0001436647569386 | 1751 | rna-XM_009879294.1 2107333 | 16 | 75209 | 76959 | Apaloderma vittatum 57397 | AAG|GTATGTCTGT...GTGGTTTTGTTT/TCTTCTGTAAGA...TTTAG|TAT | 0 | 1 | 90.155 |
11507252 | GT-AG | 0 | 1.000000099473604e-05 | 946 | rna-XM_009879294.1 2107333 | 17 | 77029 | 77974 | Apaloderma vittatum 57397 | AAA|GTGAGTAGCT...TCTTTTTTCATT/TCTTTTTTCATT...TTTAG|CCT | 0 | 1 | 94.128 |
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]);