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)
16 rows where transcript_id = 2107351
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11507527 | GT-AG | 0 | 1.000000099473604e-05 | 1502 | rna-XM_009866386.1 2107351 | 1 | 54573 | 56074 | Apaloderma vittatum 57397 | AAT|GTGAGTAGGT...TATTTCTGATAT/GTATTTCTGATA...TTAAG|AGG | 2 | 1 | 2.632 |
11507528 | GT-AG | 0 | 8.557892598588525e-05 | 2835 | rna-XM_009866386.1 2107351 | 2 | 51615 | 54449 | Apaloderma vittatum 57397 | TTT|GTAAGTATGG...TAAAACTTAACG/TTAAAACTTAAC...CTTAG|TCT | 2 | 1 | 9.237 |
11507529 | GT-AG | 0 | 0.0002847499994843 | 2724 | rna-XM_009866386.1 2107351 | 3 | 48702 | 51425 | Apaloderma vittatum 57397 | CCG|GTAAACTTGA...ATTTTATTACAG/CCAGAGTTCATT...TTTAG|TGA | 2 | 1 | 19.388 |
11507530 | GT-AG | 0 | 0.0006691039742072 | 1711 | rna-XM_009866386.1 2107351 | 4 | 46876 | 48586 | Apaloderma vittatum 57397 | TCA|GTAAGTTCAT...TTTTCTTTGAAT/TGAATTCTGATA...CAAAG|GTC | 0 | 1 | 25.564 |
11507531 | GT-AG | 0 | 3.984654923919061e-05 | 1263 | rna-XM_009866386.1 2107351 | 5 | 45474 | 46736 | Apaloderma vittatum 57397 | AAG|GTATGACTTC...ATATGCTTACCA/CATATGCTTACC...TCCAG|GGT | 1 | 1 | 33.029 |
11507532 | GT-AG | 0 | 1.000000099473604e-05 | 3790 | rna-XM_009866386.1 2107351 | 6 | 41571 | 45360 | Apaloderma vittatum 57397 | CAG|GTACAGCGCT...TAACTCCTGACC/TAACTCCTGACC...TGTAG|ATC | 0 | 1 | 39.098 |
11507533 | GT-AG | 0 | 1.000000099473604e-05 | 679 | rna-XM_009866386.1 2107351 | 7 | 40829 | 41507 | Apaloderma vittatum 57397 | GAG|GTAAGGTGAA...ACTCTCTAGACT/TGAGAACTTACA...TACAG|AAT | 0 | 1 | 42.481 |
11507534 | GT-AG | 0 | 0.0001033493917514 | 1393 | rna-XM_009866386.1 2107351 | 8 | 39298 | 40690 | Apaloderma vittatum 57397 | GAG|GTAATTTTTT...TCTTTCTTCAAG/TCTTTCTTCAAG...CTCAG|TGT | 0 | 1 | 49.893 |
11507535 | GT-AG | 0 | 1.000000099473604e-05 | 1256 | rna-XM_009866386.1 2107351 | 9 | 37951 | 39206 | Apaloderma vittatum 57397 | CAG|GTAAGATAGT...TTTTTCTTTGTA/TATGTAATCACT...CTTAG|CGG | 1 | 1 | 54.78 |
11507536 | GT-AG | 0 | 1.000000099473604e-05 | 4752 | rna-XM_009866386.1 2107351 | 10 | 33065 | 37816 | Apaloderma vittatum 57397 | CAG|GTGAGTTGGA...TTTTTCTGTGCT/TCTGTGCTCAAA...TGCAG|TGT | 0 | 1 | 61.976 |
11507537 | GT-AG | 0 | 2.164995865012214e-05 | 4124 | rna-XM_009866386.1 2107351 | 11 | 28744 | 32867 | Apaloderma vittatum 57397 | CAA|GTAAGTTGGA...TTGTCCTTCTCA/TTTGTATTCATT...TGCAG|CAA | 2 | 1 | 72.556 |
11507538 | GT-AG | 0 | 0.0001737645164884 | 1476 | rna-XM_009866386.1 2107351 | 12 | 27174 | 28649 | Apaloderma vittatum 57397 | TCT|GTAAGCATAT...CGTTTTTGGACC/TGGATATTGACA...TGTAG|GTT | 0 | 1 | 77.605 |
11507539 | GT-AG | 0 | 0.0002117542527507 | 8221 | rna-XM_009866386.1 2107351 | 13 | 18883 | 27103 | Apaloderma vittatum 57397 | ACG|GTAAATTACT...TTTGCCTTGAAA/TATGATTTTATT...TTCAG|TGA | 1 | 1 | 81.364 |
11507540 | GT-AG | 0 | 1.000000099473604e-05 | 361 | rna-XM_009866386.1 2107351 | 14 | 18412 | 18772 | Apaloderma vittatum 57397 | AAG|GTAATGTTAA...ATATTTTTAATA/ATATTTTTAATA...TCCAG|CTG | 0 | 1 | 87.272 |
11507541 | GT-AG | 0 | 1.000000099473604e-05 | 2026 | rna-XM_009866386.1 2107351 | 15 | 16289 | 18314 | Apaloderma vittatum 57397 | AAG|GTAGGATGGC...ATCTTTTTATTT/TATCTTTTTATT...TTTAG|ACA | 1 | 1 | 92.481 |
11507542 | GT-AG | 0 | 0.0262284976263196 | 5660 | rna-XM_009866386.1 2107351 | 16 | 10561 | 16220 | Apaloderma vittatum 57397 | AAG|GTATCGTGTT...AGGATCTGAGTT/AGTTTTGTCAGT...TTCAG|TTC | 0 | 1 | 96.133 |
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]);