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)
23 rows where transcript_id = 17285680
This data as json, CSV (advanced)
Suggested facets: score, length, phase
id ▼ | dinucleotide_pair | is_minor | score | length | transcript_id | ordinal_index | start | end | taxonomy_id | scored_motifs | phase | in_cds | relative_position |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92354219 | GT-AG | 0 | 1.000000099473604e-05 | 107 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 1 | 933862 | 933968 | Hesseltinella vesiculosa 101127 | CAG|GTAAGACAAT...TAGATTTTAACT/TTTTAACTCATA...TGTAG|ATC | 0 | 1 | 0.239 |
92354220 | GT-AG | 0 | 3.766825387192781e-05 | 64 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 2 | 933716 | 933779 | Hesseltinella vesiculosa 101127 | TTG|GTAAAGTTTA...TTCTTTTTAATC/TTCTTTTTAATC...TGCAG|GAG | 1 | 1 | 2.413 |
92354221 | GT-AG | 0 | 1.000000099473604e-05 | 71 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 3 | 933575 | 933645 | Hesseltinella vesiculosa 101127 | TTG|GTAATGCATT...AAAGCCTTATTC/ATAATATTAATT...ATTAG|GGT | 2 | 1 | 4.269 |
92354222 | GT-AG | 0 | 0.0005468219615363 | 60 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 4 | 933430 | 933489 | Hesseltinella vesiculosa 101127 | GAA|GTAAGCCTGT...ATGACTTTATTT/AATGACTTTATT...CATAG|CTG | 0 | 1 | 6.523 |
92354223 | GT-AG | 0 | 1.000000099473604e-05 | 64 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 5 | 933018 | 933081 | Hesseltinella vesiculosa 101127 | AAG|GTAAACAAAA...CCTTTCTTCTTC/TCTTCCATCACA...TCCAG|GGC | 0 | 1 | 15.752 |
92354224 | GT-AG | 0 | 1.000000099473604e-05 | 71 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 6 | 932864 | 932934 | Hesseltinella vesiculosa 101127 | AAA|GTAAGCGCAG...ATGATTTTATTT/ATTTTATTTATA...CATAG|TGG | 2 | 1 | 17.953 |
92354225 | GT-AG | 0 | 1.000000099473604e-05 | 73 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 7 | 932730 | 932802 | Hesseltinella vesiculosa 101127 | AAC|GTAAGAACCC...TATTTTTTAATG/TATTTTTTAATG...TCTAG|GAC | 0 | 1 | 19.57 |
92354226 | GT-AG | 0 | 2.9417883912112425e-05 | 67 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 8 | 932549 | 932615 | Hesseltinella vesiculosa 101127 | ACT|GTAAGATTGT...CTCTCCTCACCA/TCTCTCCTCACC...TCTAG|ATC | 0 | 1 | 22.593 |
92354227 | GT-AG | 0 | 1.000000099473604e-05 | 85 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 9 | 932385 | 932469 | Hesseltinella vesiculosa 101127 | CAG|GTAAGACGAT...CCTCTCATGACT/CAGCCTCTCATG...CTTAG|AAT | 1 | 1 | 24.688 |
92354228 | GT-AG | 0 | 1.000000099473604e-05 | 69 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 10 | 932160 | 932228 | Hesseltinella vesiculosa 101127 | ATG|GTCAGCCTCA...GATTCCTCATTT/ATTTTGTTTATT...ACTAG|CTG | 1 | 1 | 28.825 |
92354229 | GT-AG | 0 | 3.669838919486132e-05 | 63 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 11 | 932014 | 932076 | Hesseltinella vesiculosa 101127 | AAG|GTAAATATGA...CGTTCCTTACCT/CCGTTCCTTACC...AACAG|CTT | 0 | 1 | 31.026 |
92354230 | GT-AG | 0 | 1.000000099473604e-05 | 63 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 12 | 931810 | 931872 | Hesseltinella vesiculosa 101127 | CAT|GTAAGCGGCA...TAGTGCTCATCC/ATAGTGCTCATC...GACAG|GTA | 0 | 1 | 34.765 |
92354231 | GT-AG | 0 | 1.000000099473604e-05 | 68 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 13 | 931599 | 931666 | Hesseltinella vesiculosa 101127 | CAG|GTTAGCGACG...ACCCTCTTAGCG/TCCTTTTTTATT...GTTAG|AGA | 2 | 1 | 38.557 |
92354232 | GT-AG | 0 | 0.0184824229680311 | 64 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 14 | 931282 | 931345 | Hesseltinella vesiculosa 101127 | CAG|GTATCTACAA...TAACTCTTCCCT/CTCCATCTAACA...TTTAG|TTC | 0 | 1 | 45.267 |
92354233 | GT-AG | 0 | 1.000000099473604e-05 | 66 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 15 | 931056 | 931121 | Hesseltinella vesiculosa 101127 | CAG|GTACAGACGG...TACATCTTACTC/TTACATCTTACT...CAAAG|TGA | 1 | 1 | 49.509 |
92354234 | GT-AG | 0 | 0.0021034136534692 | 83 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 16 | 930676 | 930758 | Hesseltinella vesiculosa 101127 | AAG|GTATTTTGTG...TTTTTTTTCATG/TTTTTTTTCATG...TCAAG|GAC | 1 | 1 | 57.385 |
92354235 | GT-AG | 0 | 1.1422219831239048e-05 | 73 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 17 | 930433 | 930505 | Hesseltinella vesiculosa 101127 | AAA|GTAATATCTG...TTATTCTCAACG/CTTATTCTCAAC...CGTAG|GCA | 0 | 1 | 61.893 |
92354236 | GT-AG | 0 | 1.000000099473604e-05 | 52 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 18 | 930246 | 930297 | Hesseltinella vesiculosa 101127 | AAG|GTACAACAGA...TGGCATTTATTT/CTGGCATTTATT...GACAG|GGC | 0 | 1 | 65.473 |
92354237 | GT-AG | 0 | 1.000000099473604e-05 | 76 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 19 | 929990 | 930065 | Hesseltinella vesiculosa 101127 | AAA|GTACGAGAGG...CAAATCTTACCT/ACAAATCTTACC...TTTAG|CGC | 0 | 1 | 70.247 |
92354238 | GT-AG | 0 | 1.000000099473604e-05 | 67 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 20 | 929475 | 929541 | Hesseltinella vesiculosa 101127 | CAG|GTAAGCGTAT...TTTTTTTTTTCT/GATGCGCTTATC...AGCAG|ATG | 1 | 1 | 82.127 |
92354239 | GT-AG | 0 | 0.0025147316446991 | 68 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 21 | 929237 | 929304 | Hesseltinella vesiculosa 101127 | CAT|GTATATGCTT...ACAATCTTCATT/ACAATCTTCATT...CTTAG|AAA | 0 | 1 | 86.635 |
92354240 | GT-AG | 0 | 1.000000099473604e-05 | 68 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 22 | 928977 | 929044 | Hesseltinella vesiculosa 101127 | AAG|GTAATGAATT...CCAGCCCTGACA/CCAGCCCTGACA...TGTAG|AAA | 0 | 1 | 91.726 |
92354241 | GT-AG | 0 | 1.000000099473604e-05 | 65 | rna-gnl|WGS:MCGT|DM01DRAFT_mRNA1314518 17285680 | 23 | 928690 | 928754 | Hesseltinella vesiculosa 101127 | CGG|GTAAAAAAAA...CGTTTCCTGACT/CGTTTCCTGACT...TCTAG|GCT | 0 | 1 | 97.613 |
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]);