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)
7 rows where transcript_id = 34283759
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192054266 | GT-AG | 0 | 1.000000099473604e-05 | 2777 | rna-XM_014883993.1 34283759 | 2 | 4328023 | 4330799 | Sturnus vulgaris 9172 | TAG|GTAAGAACCT...GTGTCTATGACT/ACTTTGGTAACT...CACAG|TCA | 1 | 1 | 30.994 |
| 192054267 | GT-AG | 0 | 1.000000099473604e-05 | 1271 | rna-XM_014883993.1 34283759 | 3 | 4326429 | 4327699 | Sturnus vulgaris 9172 | CAG|GTGAAGTTCC...ACCATTTTATTT/AACCATTTTATT...TTTAG|AAC | 0 | 1 | 49.13 |
| 192054268 | GT-AG | 0 | 4.807226054454841e-05 | 873 | rna-XM_014883993.1 34283759 | 4 | 4325351 | 4326223 | Sturnus vulgaris 9172 | ACA|GTAAGTATGC...CATTCTGTAACC/CATTCTGTAACC...TCCAG|GTA | 1 | 1 | 60.64 |
| 192054269 | GT-AG | 0 | 3.007675117627392e-05 | 1356 | rna-XM_014883993.1 34283759 | 5 | 4323827 | 4325182 | Sturnus vulgaris 9172 | AAG|GTAAACATGG...GTTTTCTTGTTT/AAAATCTTCACT...TTCAG|GGT | 1 | 1 | 70.073 |
| 192054270 | GT-AG | 0 | 1.000000099473604e-05 | 1360 | rna-XM_014883993.1 34283759 | 6 | 4322287 | 4323646 | Sturnus vulgaris 9172 | CAG|GTAAGATGTT...GTTATTTTGAAT/TTTGAATTTATT...TTTAG|ATA | 1 | 1 | 80.18 |
| 192054271 | GT-AG | 0 | 0.0002132323509922 | 529 | rna-XM_014883993.1 34283759 | 7 | 4321611 | 4322139 | Sturnus vulgaris 9172 | CAG|GTAAACTGAA...TTGCTCTTAATA/TTTGCTCTTAAT...TTTAG|GTC | 1 | 1 | 88.433 |
| 192054545 | GT-AG | 0 | 3.640855235049898e-05 | 451 | rna-XM_014883993.1 34283759 | 1 | 4331272 | 4331722 | Sturnus vulgaris 9172 | CAG|GTACAATGCA...TTGTTTTTATTC/CTTGTTTTTATT...CACAG|AGG | 0 | 9.545 |
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]);