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)
24 rows where transcript_id = 3485101
This data as json, CSV (advanced)
Suggested facets: dinucleotide_pair, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17203043 | GT-AG | 0 | 1.000000099473604e-05 | 857 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 2 | 55402 | 56258 | Armadillidium vulgare 13347 | AAG|GTAAATTGAA...ATATATATATTT/TATATATATATT...CATAG|AGA | 2 | 1 | 6.469 |
17203044 | GT-AG | 0 | 0.0001572547673828 | 1796 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 3 | 53539 | 55334 | Armadillidium vulgare 13347 | AAG|GTATGTTATA...ATATATATATTC/TATATATATATT...AGCAG|AAA | 0 | 1 | 8.345 |
17203045 | GT-AG | 0 | 1.000000099473604e-05 | 119 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 4 | 53330 | 53448 | Armadillidium vulgare 13347 | CAG|GTAAGTTTCG...TTATTATTATTT/ATTATTATTATT...TTCAG|GAA | 0 | 1 | 10.865 |
17203046 | GT-AG | 0 | 1.000000099473604e-05 | 3028 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 5 | 50179 | 53206 | Armadillidium vulgare 13347 | CAG|GTACGTATTT...ATATATATATAT/TATATATATATA...TATAG|AAT | 0 | 1 | 14.31 |
17203047 | GT-AG | 0 | 0.0003652091462728 | 234 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 6 | 49862 | 50095 | Armadillidium vulgare 13347 | TAA|GTAAGTTTGT...ATTTTTTTATTT/AATTTTTTTATT...TTTAG|AGT | 2 | 1 | 16.634 |
17203048 | GT-AG | 0 | 1.000000099473604e-05 | 155 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 7 | 49538 | 49692 | Armadillidium vulgare 13347 | GAG|GTAAGAATAT...ATATATATAAAA/ATATATATAAAA...TTCAG|GAA | 0 | 1 | 21.367 |
17203049 | GT-AG | 0 | 1.000000099473604e-05 | 191 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 8 | 49177 | 49367 | Armadillidium vulgare 13347 | AAG|GTTGGCATTG...TTTCTGTTATTT/CTTTCTGTTATT...TTCAG|TGA | 2 | 1 | 26.127 |
17203050 | GT-AG | 0 | 0.2216354851589176 | 114 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 9 | 48848 | 48961 | Armadillidium vulgare 13347 | CAA|GTATGTTTGT...TCATCCTTATTT/CTTATTTTCATC...TATAG|CTA | 1 | 1 | 32.148 |
17203051 | GT-AG | 0 | 0.1208256626180199 | 120 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 10 | 48537 | 48656 | Armadillidium vulgare 13347 | GGA|GTATGTTTCA...TGCTTTTTGAAT/TGCTTTTTGAAT...TATAG|GGT | 0 | 1 | 37.496 |
17203052 | GT-AG | 0 | 3.0754562051906106e-05 | 83 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 11 | 48300 | 48382 | Armadillidium vulgare 13347 | CAG|GTAATTTTTA...TTATTATTATTA/ATTATTATTATT...TTCAG|GAA | 1 | 1 | 41.809 |
17203053 | GT-AG | 0 | 1.000000099473604e-05 | 107 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 12 | 48050 | 48156 | Armadillidium vulgare 13347 | GAG|GTTAGATCAT...AAATTATTAATT/AAATTATTAATT...ATTAG|GGT | 0 | 1 | 45.813 |
17203054 | GT-AG | 0 | 0.0002207094884398 | 152 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 13 | 47768 | 47919 | Armadillidium vulgare 13347 | ATG|GTATGAATTT...AGTCCTTTATTT/CTTTATTTCAAA...CACAG|GAG | 1 | 1 | 49.454 |
17203055 | GT-AG | 0 | 1.000000099473604e-05 | 1232 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 14 | 46370 | 47601 | Armadillidium vulgare 13347 | TGC|GTAAGTAATA...ATATATATATAT/TATATATATATA...ATTAG|AGT | 2 | 1 | 54.102 |
17203056 | GT-AG | 0 | 0.0011407431938964 | 1525 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 15 | 44772 | 46296 | Armadillidium vulgare 13347 | AAG|GTTTGTTTTC...TTTTTTTTATTA/TTTTTTTTTATT...TGTAG|ACA | 0 | 1 | 56.147 |
17203057 | GT-AG | 0 | 1.000000099473604e-05 | 221 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 16 | 44432 | 44652 | Armadillidium vulgare 13347 | TAG|GTTAGGACCT...ATGTTATTAACT/ATGTTATTAACT...TGCAG|CTT | 2 | 1 | 59.479 |
17203058 | GT-AG | 0 | 0.1255605978261823 | 309 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 17 | 43582 | 43890 | Armadillidium vulgare 13347 | AAG|GTATACTACA...TTAGTCTTAAAT/TTATTGTTGATT...TGCAG|AAA | 0 | 1 | 74.629 |
17203059 | GT-AG | 0 | 1.000000099473604e-05 | 153 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 18 | 43256 | 43408 | Armadillidium vulgare 13347 | AAG|GTAAAAATAC...TAAATCTTATTA/TTAAATCTTATT...TGAAG|GGT | 2 | 1 | 79.474 |
17203060 | GT-AG | 0 | 4.360494807028299e-05 | 174 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 19 | 42926 | 43099 | Armadillidium vulgare 13347 | GTC|GTAAGTAATA...TTTGCCTTGCTT/TGTATAGTAAAA...TGTAG|TTT | 2 | 1 | 83.842 |
17203061 | GT-AG | 0 | 1.000000099473604e-05 | 1243 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 20 | 41631 | 42873 | Armadillidium vulgare 13347 | AGT|GTGAGTAAAA...AGTGTCTGAAAT/TAATTATTCATT...CTTAG|GCC | 0 | 1 | 85.298 |
17203062 | GT-AG | 0 | 3.367359365051932e-05 | 875 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 21 | 40656 | 41530 | Armadillidium vulgare 13347 | TTG|GTAAGTTGGA...TTTTTTTTATTT/TTTTTTTTTATT...AATAG|AAG | 1 | 1 | 88.099 |
17203063 | GT-AG | 0 | 1.000000099473604e-05 | 85 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 22 | 40479 | 40563 | Armadillidium vulgare 13347 | CAT|GTAAGTAGTT...TGTCTTTTATAT/GTGTCTTTTATA...TTCAG|GTT | 0 | 1 | 90.675 |
17203064 | GT-AG | 0 | 0.0004986284728515 | 159 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 23 | 40221 | 40379 | Armadillidium vulgare 13347 | GTT|GTAAGTTGAG...TATGTCTTATTT/TTATGTCTTATT...ATTAG|ATT | 0 | 1 | 93.447 |
17203065 | GT-AG | 0 | 1.000000099473604e-05 | 90 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 24 | 40047 | 40136 | Armadillidium vulgare 13347 | GAG|GTAGAAGTTT...ATTTTCTAAATT/TATTTTCTAAAT...TTCAG|ATT | 0 | 1 | 95.799 |
17203096 | GT-AT | 0 | 1.000000099473604e-05 | 7189 | rna-gnl|WGS:SAUD|Avbf_00033-RA_mrna 3485101 | 1 | 56360 | 63548 | Armadillidium vulgare 13347 | AAT|GTGTGAAACT...TATATATTAATT/TATATATTAATT...TAAAT|TTT | 0 | 5.069 |
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]);