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)
13 rows where transcript_id = 2107365
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11507696 | GT-AG | 0 | 0.000373532957363 | 366 | rna-XM_009868199.1 2107365 | 1 | 188 | 553 | Apaloderma vittatum 57397 | CGG|GTAACGTCTT...TTTATTTGAATT/CTTTATTTGAAT...CATAG|ACC | 2 | 1 | 8.347 |
11507697 | GT-AG | 0 | 1.000000099473604e-05 | 460 | rna-XM_009868199.1 2107365 | 2 | 700 | 1159 | Apaloderma vittatum 57397 | CAG|GTAGAGAAGG...ACCCCTTTATTA/CCTTTATTAATT...TGCAG|ATT | 1 | 1 | 16.209 |
11507698 | GT-AG | 0 | 1.000000099473604e-05 | 838 | rna-XM_009868199.1 2107365 | 3 | 1366 | 2203 | Apaloderma vittatum 57397 | CAG|GTTATAGAAC...AATTTTTTACTT/TAATTTTTTACT...ATCAG|GAA | 0 | 1 | 27.302 |
11507699 | GT-AG | 0 | 1.000000099473604e-05 | 1851 | rna-XM_009868199.1 2107365 | 4 | 2351 | 4201 | Apaloderma vittatum 57397 | TCG|GTAAGAATCG...GCATTTTTGTTG/TATATATTGAAG...TAAAG|GAA | 0 | 1 | 35.218 |
11507700 | GT-AG | 0 | 0.0151874050465939 | 4315 | rna-XM_009868199.1 2107365 | 5 | 4391 | 8705 | Apaloderma vittatum 57397 | AAG|GTAACTTTAG...ATCTTTTTAATC/ATGATACTCATC...TTTAG|GTA | 0 | 1 | 45.396 |
11507701 | GT-AG | 0 | 1.000000099473604e-05 | 6673 | rna-XM_009868199.1 2107365 | 6 | 8776 | 15448 | Apaloderma vittatum 57397 | AAG|GTAGAGTTGA...ATTTTTTTATAA/TATTTTTTTATA...TACAG|AAG | 1 | 1 | 49.165 |
11507702 | GT-AG | 0 | 1.000000099473604e-05 | 922 | rna-XM_009868199.1 2107365 | 7 | 15561 | 16482 | Apaloderma vittatum 57397 | AAG|GTAAAACTGA...GCTATTTTATTG/TTTATTGTAATT...TCCAG|AGA | 2 | 1 | 55.197 |
11507703 | GT-AG | 0 | 0.0353162801937362 | 2170 | rna-XM_009868199.1 2107365 | 8 | 16535 | 18704 | Apaloderma vittatum 57397 | AAG|GTAACTCTTG...ATTTTCTTAATA/TATTTTCTTAAT...ATCAG|TTT | 0 | 1 | 57.997 |
11507704 | GT-AG | 0 | 1.000000099473604e-05 | 341 | rna-XM_009868199.1 2107365 | 9 | 18807 | 19147 | Apaloderma vittatum 57397 | CAG|GTGAGTACTT...CACTCATTAGTA/ATGCCACTCATT...TGCAG|CCT | 0 | 1 | 63.489 |
11507705 | GT-AG | 0 | 1.000000099473604e-05 | 223 | rna-XM_009868199.1 2107365 | 10 | 19314 | 19536 | Apaloderma vittatum 57397 | CTG|GTTAGTCATG...ACATTATTAATT/ACATTATTAATT...TTTAG|TTT | 1 | 1 | 72.429 |
11507706 | GT-AG | 0 | 1.000000099473604e-05 | 1031 | rna-XM_009868199.1 2107365 | 11 | 19620 | 20650 | Apaloderma vittatum 57397 | CAG|GTGAGTTTAC...TTTGTATTGATG/TTTGTATTGATG...TAAAG|AAC | 0 | 1 | 76.898 |
11507707 | GT-AG | 0 | 0.0034298773119162 | 912 | rna-XM_009868199.1 2107365 | 12 | 20779 | 21690 | Apaloderma vittatum 57397 | TAT|GTAAGTTTTG...CTTTTCTTAAAC/ATTGTATTAACT...CAAAG|TGA | 2 | 1 | 83.791 |
11507708 | GT-AG | 0 | 2.025494857984042e-05 | 796 | rna-XM_009868199.1 2107365 | 13 | 21791 | 22586 | Apaloderma vittatum 57397 | CCG|GTAGGTCTTT...CAATATTTAATA/GAGTATCTAACT...GACAG|ATC | 0 | 1 | 89.176 |
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]);