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)
11 rows where transcript_id = 2279578
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239460 | GT-AG | 0 | 1.000000099473604e-05 | 698 | rna-XM_027998337.1 2279578 | 1 | 2639690 | 2640387 | Aphis gossypii 80765 | CAG|GTAAGATGTC...TTATTCTTAATA/TATATATTTATT...TACAG|AAA | 2 | 1 | 3.036 |
12239461 | GT-AG | 0 | 1.35090616512792e-05 | 331 | rna-XM_027998337.1 2279578 | 2 | 2640498 | 2640828 | Aphis gossypii 80765 | AAG|GTTTGTAAAT...TGTTTTTTAATA/TGTTTTTTAATA...ATTAG|ATT | 1 | 1 | 5.277 |
12239462 | GT-AG | 0 | 0.0005279079196871 | 203 | rna-XM_027998337.1 2279578 | 3 | 2641029 | 2641231 | Aphis gossypii 80765 | AAG|GTATATATCA...CTAATATTGATA/CTAATATTGATA...GTCAG|GAT | 0 | 1 | 9.352 |
12239463 | GT-AG | 0 | 1.4446383467018097e-05 | 60 | rna-XM_027998337.1 2279578 | 4 | 2641421 | 2641480 | Aphis gossypii 80765 | TAT|GTAAGTTAAA...TTGTTTATATTT/AATTTGTTTATA...TTCAG|AAT | 0 | 1 | 13.203 |
12239464 | GT-AG | 0 | 0.0110568174584101 | 1008 | rna-XM_027998337.1 2279578 | 5 | 2641631 | 2642638 | Aphis gossypii 80765 | TAT|GTATGTTATT...TATCCCTTGTAT/ATGTATTTTATG...TTTAG|GAT | 0 | 1 | 16.259 |
12239465 | GT-AG | 0 | 1.000000099473604e-05 | 2057 | rna-XM_027998337.1 2279578 | 6 | 2642736 | 2644792 | Aphis gossypii 80765 | TAG|GTGAATCACA...TATTGTTTAATA/TATTGTTTAATA...TTTAG|GTG | 1 | 1 | 18.236 |
12239466 | GT-AG | 0 | 1.000000099473604e-05 | 26803 | rna-XM_027998337.1 2279578 | 7 | 2644958 | 2671760 | Aphis gossypii 80765 | ATG|GTGAGTGAAA...AATTTCATAAAT/TAATAATTAATT...TACAG|GTA | 1 | 1 | 21.597 |
12239467 | GT-AG | 0 | 0.0004150887375483 | 7780 | rna-XM_027998337.1 2279578 | 8 | 2672022 | 2679801 | Aphis gossypii 80765 | AAG|GTATGTTGAT...TTCTATTTAATG/TTTCTATTTAAT...TACAG|TTG | 1 | 1 | 26.915 |
12239468 | GT-AG | 0 | 2.897524764801749e-05 | 209 | rna-XM_027998337.1 2279578 | 9 | 2679948 | 2680156 | Aphis gossypii 80765 | GAC|GTAAATACAT...CGTCTTTTGACA/CGTCTTTTGACA...TTCAG|GCC | 0 | 1 | 29.89 |
12239469 | GT-AG | 0 | 1.000000099473604e-05 | 1267 | rna-XM_027998337.1 2279578 | 10 | 2680398 | 2681664 | Aphis gossypii 80765 | ATG|GTAATAGTTA...GATTTTTTAATT/GATTTTTTAATT...TTCAG|AGC | 1 | 1 | 34.8 |
12239470 | GT-AG | 0 | 1.000000099473604e-05 | 66 | rna-XM_027998337.1 2279578 | 11 | 2684022 | 2684087 | Aphis gossypii 80765 | AAG|GTGAGCTTAA...TTTATTTTATCA/ATTTATTTTATT...TTTAG|GTT | 0 | 1 | 82.824 |
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]);