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)
14 rows where transcript_id = 3485062
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17202790 | GT-AG | 0 | 1.000000099473604e-05 | 2604 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 2 | 34680 | 37283 | Armadillidium vulgare 13347 | CAG|GTTAAAATTT...ATATATATATAT/TATATATATATA...TATAG|AAC | 0 | 1 | 25.413 |
17202791 | GT-AG | 0 | 1.000000099473604e-05 | 184 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 3 | 34244 | 34427 | Armadillidium vulgare 13347 | GGG|GTGAGATATT...TATATTTTATTT/ATTTTATTTATT...TTCAG|CCT | 0 | 1 | 32.351 |
17202792 | GT-AG | 0 | 0.0001921628913561 | 1904 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 4 | 31888 | 33791 | Armadillidium vulgare 13347 | GGC|GTAAGTTTAG...AATTATTTGACT/TTTTGTTTTATT...TATAG|CGG | 2 | 1 | 44.796 |
17202793 | GT-AG | 0 | 9.401977649831704e-05 | 1197 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 5 | 30536 | 31732 | Armadillidium vulgare 13347 | AAA|GTAAGTTTAT...CATTTCTAAATT/ACATTTCTAAAT...TGTAG|GTA | 1 | 1 | 49.064 |
17202794 | GT-AG | 0 | 3.222783139817646e-05 | 1582 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 6 | 28722 | 30303 | Armadillidium vulgare 13347 | AAG|GTAACAAGTG...TTTATTTTATTT/TTTTATTTTATT...TTTAG|TCG | 2 | 1 | 55.452 |
17202795 | GT-AG | 0 | 0.0001876626689328 | 590 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 7 | 28008 | 28597 | Armadillidium vulgare 13347 | AAA|GTACGTTTAT...ATATATATAATT/ATATATATAATT...TACAG|AGA | 0 | 1 | 58.866 |
17202796 | GT-AG | 0 | 1.000000099473604e-05 | 1880 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 8 | 25986 | 27865 | Armadillidium vulgare 13347 | GAG|GTAAGCGCTT...CAATTCATAATT/CATAATTTTATA...TTCAG|ACT | 1 | 1 | 62.775 |
17202797 | GT-AG | 0 | 0.8271383253031561 | 1790 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 9 | 24028 | 25817 | Armadillidium vulgare 13347 | ATC|GTATCAAGAT...CTTACCTTATCT/AGAATTTTCATC...TGCAG|AAG | 1 | 1 | 67.401 |
17202798 | GT-AG | 0 | 1.000000099473604e-05 | 91 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 10 | 23758 | 23848 | Armadillidium vulgare 13347 | TTG|GTTAGTACAG...GTATTTTTAAAC/GTATTTTTAAAC...TTCAG|GAG | 0 | 1 | 72.329 |
17202799 | GT-AG | 0 | 2.1753690607094515e-05 | 1332 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 11 | 22312 | 23643 | Armadillidium vulgare 13347 | GAA|GTAAGTCTTT...AAAGTTTTAAAT/AAAGTTTTAAAT...TATAG|GGT | 0 | 1 | 75.468 |
17202800 | GT-AG | 0 | 0.0002018584632118 | 5859 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 12 | 16295 | 22153 | Armadillidium vulgare 13347 | AGG|GTATGTAAAT...TTAGTCTTAAGT/TTAGTATTGAGT...TCCAG|ACC | 2 | 1 | 79.818 |
17202801 | GT-AG | 0 | 0.2535248638246685 | 467 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 13 | 15633 | 16099 | Armadillidium vulgare 13347 | GAG|GTATCTTGAA...TTCTTCTAGATA/AATTAATTAATT...TGTAG|GTT | 2 | 1 | 85.187 |
17202802 | GT-AG | 0 | 4.222700080810695e-05 | 99 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 14 | 15459 | 15557 | Armadillidium vulgare 13347 | AAA|GTAAGTTCAT...TTTTTTTTATTA/CTTTTTTTTATT...TATAG|AGC | 2 | 1 | 87.252 |
17202803 | GT-AG | 0 | 0.0242297712202363 | 7891 | rna-gnl|WGS:SAUD|Avbf_03768-RA_mrna 3485062 | 1 | 37744 | 45634 | Armadillidium vulgare 13347 | CGA|GTATGTGTGT...AATATCTTATCT/CATCTTTTTACA...ATCAG|AAT | 0 | 13.023 |
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]);