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)
27 rows where transcript_id = 11132757
This data as json, CSV (advanced)
Suggested facets: dinucleotide_pair, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61608320 | GT-AG | 0 | 0.004893789468825 | 7623 | rna-XM_027344350.1 11132757 | 1 | 3384329 | 3391951 | Dermatophagoides pteronyssinus 6956 | CAG|GTATGTTTAG...TTTTCTTTCATT/TTTTCTTTCATT...AATAG|ATC | 1 | 1 | 6.0 |
61608321 | GT-AG | 0 | 0.0005504603278532 | 85 | rna-XM_027344350.1 11132757 | 2 | 3392022 | 3392106 | Dermatophagoides pteronyssinus 6956 | CAA|GTAAGCTATG...ATTATTTTATTT/ATGAATTTCATT...TTAAG|TAC | 2 | 1 | 7.304 |
61608322 | GT-AG | 0 | 1.000000099473604e-05 | 1791 | rna-XM_027344350.1 11132757 | 3 | 3392202 | 3393992 | Dermatophagoides pteronyssinus 6956 | CAG|GTAAGTCATA...GGAATATTAAAT/GGAATATTAAAT...AAAAG|GCA | 1 | 1 | 9.074 |
61608323 | GT-AG | 0 | 1.000000099473604e-05 | 18416 | rna-XM_027344350.1 11132757 | 4 | 3394143 | 3412558 | Dermatophagoides pteronyssinus 6956 | CCG|GTAAGTGTGT...TATATGTTAAAC/TATATGTTAAAC...AACAG|TGG | 1 | 1 | 11.869 |
61608324 | GT-AG | 0 | 0.0020917327159867 | 87 | rna-XM_027344350.1 11132757 | 5 | 3412793 | 3412879 | Dermatophagoides pteronyssinus 6956 | CAG|GTATATAATG...TTATTTTTGAAA/TATCTTTTCATC...AACAG|ATA | 1 | 1 | 16.229 |
61608325 | GT-AG | 0 | 1.000000099473604e-05 | 151 | rna-XM_027344350.1 11132757 | 6 | 3413027 | 3413177 | Dermatophagoides pteronyssinus 6956 | CCG|GTAAGTAGAC...AAATTCTGATAA/AAAATTCTGATA...TGCAG|AGC | 1 | 1 | 18.968 |
61608326 | GT-AG | 0 | 1.000000099473604e-05 | 4004 | rna-XM_027344350.1 11132757 | 7 | 3413520 | 3417523 | Dermatophagoides pteronyssinus 6956 | GAT|GTAAGTGATG...TCAATTTTATTT/ATTTTATTTATT...TTTAG|CAC | 1 | 1 | 25.34 |
61608327 | GT-AG | 0 | 3.773563412415336e-05 | 71 | rna-XM_027344350.1 11132757 | 8 | 3417890 | 3417960 | Dermatophagoides pteronyssinus 6956 | GTG|GTAAGTTTTC...GACTTTTTCATT/GACTTTTTCATT...TACAG|ATA | 1 | 1 | 32.159 |
61608328 | GT-AG | 0 | 1.687376621158152e-05 | 2231 | rna-XM_027344350.1 11132757 | 9 | 3418032 | 3420262 | Dermatophagoides pteronyssinus 6956 | AAG|GTAAGTTTTT...TCTACTTTCACA/CACTTTCTCACA...ATCAG|TGT | 0 | 1 | 33.482 |
61608329 | GT-AG | 0 | 4.4872729328408864e-05 | 145 | rna-XM_027344350.1 11132757 | 10 | 3420420 | 3420564 | Dermatophagoides pteronyssinus 6956 | AAG|GTTTGTGTTT...CTATCTTTATTT/TTTTTTCTTACT...GTCAG|ATG | 1 | 1 | 36.408 |
61608330 | GT-AG | 0 | 4.744151767257958e-05 | 57 | rna-XM_027344350.1 11132757 | 11 | 3420751 | 3420807 | Dermatophagoides pteronyssinus 6956 | GAG|GTATGATGAG...AATTTCTTTTTT/AAATTATTTAAA...TAAAG|ATT | 1 | 1 | 39.873 |
61608331 | GT-AG | 0 | 0.0090921128262784 | 8413 | rna-XM_027344350.1 11132757 | 12 | 3420976 | 3429388 | Dermatophagoides pteronyssinus 6956 | TCG|GTATTTGGTG...CTTTTTTTAATC/CTTTTTTTAATC...TTTAG|TTC | 1 | 1 | 43.004 |
61608332 | GT-AG | 0 | 0.0057368583228161 | 119 | rna-XM_027344350.1 11132757 | 13 | 3429490 | 3429608 | Dermatophagoides pteronyssinus 6956 | AAA|GTATGTTAAC...TTATCATTATCA/AATTTTATCATT...TTCAG|GTT | 0 | 1 | 44.885 |
61608333 | GT-AG | 0 | 1.000000099473604e-05 | 87 | rna-XM_027344350.1 11132757 | 14 | 3429730 | 3429816 | Dermatophagoides pteronyssinus 6956 | GAG|GTAAAGAAGT...TTACCTTTAAGA/TTCTTTCTCAAA...AATAG|GTA | 1 | 1 | 47.14 |
61608334 | GT-AG | 0 | 0.0001349488377938 | 2095 | rna-XM_027344350.1 11132757 | 15 | 3429886 | 3431980 | Dermatophagoides pteronyssinus 6956 | ACG|GTAAGTTTTA...CTTTTTTTATAT/TCTTTTTTTATA...TACAG|TAC | 1 | 1 | 48.426 |
61608335 | GT-AG | 0 | 0.0008613982748754 | 106 | rna-XM_027344350.1 11132757 | 16 | 3432101 | 3432206 | Dermatophagoides pteronyssinus 6956 | AAG|GTATAATTAA...TATATTTTGAAA/TATATTTTGAAA...TTAAG|GTC | 1 | 1 | 50.661 |
61608336 | GT-AG | 0 | 2.0729809625101795e-05 | 220 | rna-XM_027344350.1 11132757 | 17 | 3432396 | 3432615 | Dermatophagoides pteronyssinus 6956 | ATG|GTAAGCCACT...TGCTTTTTATTA/TTGTTATTTATT...ATTAG|TTG | 1 | 1 | 54.183 |
61608337 | GT-AG | 0 | 1.000000099473604e-05 | 124 | rna-XM_027344350.1 11132757 | 18 | 3432704 | 3432827 | Dermatophagoides pteronyssinus 6956 | TAA|GTAAGTGGAA...TTTGTTTTATTT/GTTTGTTTTATT...GATAG|GCC | 2 | 1 | 55.823 |
61608338 | GT-AG | 0 | 0.003277439459118 | 2532 | rna-XM_027344350.1 11132757 | 19 | 3433169 | 3435700 | Dermatophagoides pteronyssinus 6956 | GTG|GTATGTATTA...ATGTCTTTGTCT/CTTTGTCTGATT...ACTAG|AAA | 1 | 1 | 62.176 |
61608339 | GT-AG | 0 | 0.0001043426184612 | 66 | rna-XM_027344350.1 11132757 | 20 | 3436229 | 3436294 | Dermatophagoides pteronyssinus 6956 | TTG|GTATGATATT...CACTTGTTAAAT/CAAATTTTTATT...TATAG|ATC | 1 | 1 | 72.014 |
61608340 | GC-AG | 0 | 1.000000099473604e-05 | 89 | rna-XM_027344350.1 11132757 | 21 | 3436388 | 3436476 | Dermatophagoides pteronyssinus 6956 | CAG|GCATGTTTAA...TAGCCATTATTG/GATTATTTCATT...TTTAG|GAT | 1 | 1 | 73.747 |
61608341 | GT-AG | 0 | 0.0002437619175053 | 3284 | rna-XM_027344350.1 11132757 | 22 | 3436660 | 3439943 | Dermatophagoides pteronyssinus 6956 | CTT|GTAAGTTAAC...TATTTTTTATCT/TTATTTTTTATC...TATAG|CTC | 1 | 1 | 77.157 |
61608342 | GT-AG | 0 | 0.0002831656197409 | 253 | rna-XM_027344350.1 11132757 | 23 | 3440025 | 3440277 | Dermatophagoides pteronyssinus 6956 | ATG|GTAAGTTTTT...CTATTCTTGATT/TTTTTTTTTATT...CAAAG|GCG | 1 | 1 | 78.666 |
61608343 | GT-AG | 0 | 1.000000099473604e-05 | 90 | rna-XM_027344350.1 11132757 | 24 | 3440485 | 3440574 | Dermatophagoides pteronyssinus 6956 | AAA|GTAATAATAT...CTTCTCTTATCT/TATCTATTCATT...TTCAG|ATG | 1 | 1 | 82.523 |
61608344 | GT-AG | 0 | 1.000000099473604e-05 | 58 | rna-XM_027344350.1 11132757 | 25 | 3440746 | 3440803 | Dermatophagoides pteronyssinus 6956 | ATG|GTAAGCCCTG...AATGCTTTTTCT/AATGAATTAATT...TTTAG|GCA | 1 | 1 | 85.709 |
61608345 | GT-AG | 0 | 1.000000099473604e-05 | 70 | rna-XM_027344350.1 11132757 | 26 | 3441091 | 3441160 | Dermatophagoides pteronyssinus 6956 | AAC|GTGAGTTTTA...AAATCTATGATT/ACTAAACTAATT...TACAG|TAT | 0 | 1 | 91.056 |
61608346 | GT-AG | 0 | 0.0074875560564815 | 232 | rna-XM_027344350.1 11132757 | 27 | 3441282 | 3441513 | Dermatophagoides pteronyssinus 6956 | ATA|GTATTGTTGA...CATTCTGTGATT/TCATAACTAATT...TTTAG|GTG | 1 | 1 | 93.311 |
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]);