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)
10 rows where transcript_id = 6831639
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35541202 | GT-AG | 0 | 0.0063711204011424 | 1207 | rna-XM_009699095.1 6831639 | 4 | 41553 | 42759 | Cariama cristata 54380 | TCG|GTAGGCTTAA...CTGACTTTGATA/CAAATGCTGACT...AATAG|ATG | 0 | 1 | 12.191 |
35541203 | GT-AG | 0 | 1.000000099473604e-05 | 1345 | rna-XM_009699095.1 6831639 | 5 | 42922 | 44266 | Cariama cristata 54380 | AAG|GTAAGATTTT...TTTGCCTTTACA/TTTGCCTTTACA...GGCAG|AAG | 0 | 1 | 17.019 |
35541204 | GT-AG | 0 | 1.000000099473604e-05 | 971 | rna-XM_009699095.1 6831639 | 6 | 44381 | 45351 | Cariama cristata 54380 | CAA|GTGAGTCCCA...TTATCCTTCCCC/ATGGTGGTTATC...CGCAG|GAG | 0 | 1 | 20.417 |
35541205 | GT-AG | 0 | 1.000000099473604e-05 | 418 | rna-XM_009699095.1 6831639 | 8 | 46759 | 47176 | Cariama cristata 54380 | CAG|GTATGGAGGT...TTCTCTTTCATC/TTCTCTTTCATC...TGCAG|GTT | 2 | 1 | 61.162 |
35541206 | GT-AG | 0 | 7.894982348131041e-05 | 1272 | rna-XM_009699095.1 6831639 | 10 | 47399 | 48670 | Cariama cristata 54380 | GCG|GTAGGTTTAT...ATTCTCTTCCCC/AGTGTGTTGAAC...AGCAG|AAG | 0 | 1 | 67.72 |
35541207 | GT-AG | 0 | 1.000000099473604e-05 | 229 | rna-XM_009699095.1 6831639 | 12 | 51864 | 52092 | Cariama cristata 54380 | TCG|GTGAGAGCAC...GACCTCATAGTA/GTGGACCTCATA...TTTAG|GTA | 1 | 1 | 93.592 |
35541208 | GT-AG | 0 | 1.000000099473604e-05 | 1079 | rna-XM_009699095.1 6831639 | 13 | 52274 | 53352 | Cariama cristata 54380 | CAG|GTGAGAGGTG...TTTTCTTTCTCT/GTTTTGTTAAAA...TTCAG|TCG | 2 | 1 | 98.987 |
35541209 | GT-AG | 0 | 1.000000099473604e-05 | 37525 | rna-XM_009699095.1 6831639 | 1 | 555 | 38079 | Cariama cristata 54380 | ACT|GTAAGTACAT...GCCCCTCTAACA/GCCCCTCTAACA...TGCAG|GGA | 0 | 2.235 | |
35541210 | GT-AG | 0 | 2.272047752126633e-05 | 2241 | rna-XM_009699095.1 6831639 | 2 | 38243 | 40483 | Cariama cristata 54380 | TCT|GTAAGTGGAA...TGTTCTTTACTT/TTGTTCTTTACT...TTCAG|TGG | 0 | 7.094 | |
35541211 | GT-AG | 0 | 0.1251752404345278 | 776 | rna-XM_009699095.1 6831639 | 3 | 40577 | 41352 | Cariama cristata 54380 | CCA|GTATGCACCT...TATTTCTAAGCT/GTATTTCTAAGC...CTAAG|CCT | 0 | 9.866 |
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]);