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)
19 rows where transcript_id = 2279590
This data as json, CSV (advanced)
Suggested facets: dinucleotide_pair, is_minor, score, phase
id ▼ | dinucleotide_pair | is_minor | score | length | transcript_id | ordinal_index | start | end | taxonomy_id | scored_motifs | phase | in_cds | relative_position |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239668 | GT-AG | 0 | 1.000000099473604e-05 | 34724 | rna-XM_027997268.1 2279590 | 1 | 3974556 | 4009279 | Aphis gossypii 80765 | AAG|GTTAGTTACT...TTTTTTTTCATT/TTTTTTTTCATT...TTCAG|GCC | 2 | 1 | 1.244 |
12239669 | GT-AG | 0 | 9.737893136482824e-05 | 58143 | rna-XM_027997268.1 2279590 | 2 | 3916270 | 3974412 | Aphis gossypii 80765 | TGC|GTAAGTCATG...GTTTTTTTATCT/TTTTTTTTTATT...TTCAG|TGT | 1 | 1 | 5.927 |
12239670 | GT-AG | 0 | 1.000000099473604e-05 | 42252 | rna-XM_027997268.1 2279590 | 3 | 3873911 | 3916162 | Aphis gossypii 80765 | AAG|GTTAGTGAAG...TAATTTTCACTG/TAATGAATAATA...TCCAG|GCC | 0 | 1 | 9.43 |
12239671 | GT-AG | 0 | 1.3271985218140855e-05 | 27340 | rna-XM_027997268.1 2279590 | 4 | 3846433 | 3873772 | Aphis gossypii 80765 | GAC|GTAAGTGACA...AGTATCTTAATG/GTAAAATTTATT...TTCAG|AAA | 0 | 1 | 13.949 |
12239672 | GT-AG | 0 | 1.5687736772646515e-05 | 8655 | rna-XM_027997268.1 2279590 | 5 | 3837726 | 3846380 | Aphis gossypii 80765 | ACG|GTAAGATTTG...AACTTTTTGATA/AACTTTTTGATA...TACAG|GTA | 1 | 1 | 15.652 |
12239673 | GT-AG | 0 | 6.185677483978986e-05 | 10019 | rna-XM_027997268.1 2279590 | 6 | 3827597 | 3837615 | Aphis gossypii 80765 | GAG|GTAAACATAA...AATTTCGTAATG/TAATGTATCATA...CGCAG|AAC | 0 | 1 | 19.253 |
12239674 | GT-AG | 0 | 1.000000099473604e-05 | 1452 | rna-XM_027997268.1 2279590 | 7 | 3825901 | 3827352 | Aphis gossypii 80765 | ACG|GTGAGATAAA...TCCATTTTATTC/CTCCATTTTATT...TACAG|CTA | 1 | 1 | 27.243 |
12239675 | GT-AG | 0 | 1.000000099473604e-05 | 92 | rna-XM_027997268.1 2279590 | 8 | 3825625 | 3825716 | Aphis gossypii 80765 | ACC|GTGAGTTACA...TATCTCATATTT/TAATATCTCATA...GATAG|GAG | 2 | 1 | 33.268 |
12239676 | GT-AG | 0 | 1.000000099473604e-05 | 884 | rna-XM_027997268.1 2279590 | 9 | 3824595 | 3825478 | Aphis gossypii 80765 | TAC|GTAAGTGAAT...AACACCTCGATG/ACGATCGTAACA...CGTAG|TTT | 1 | 1 | 38.048 |
12239677 | GT-AG | 0 | 0.0172685454224753 | 84 | rna-XM_027997268.1 2279590 | 10 | 3824366 | 3824449 | Aphis gossypii 80765 | AAG|GTATTTTTAG...ATTTTTTTATAA/GATTTTTTTATA...TCTAG|ATC | 2 | 1 | 42.796 |
12239678 | GT-AG | 0 | 1.0769088381705347e-05 | 98 | rna-XM_027997268.1 2279590 | 11 | 3824109 | 3824206 | Aphis gossypii 80765 | CAA|GTACGACGTT...AATATCATAACT/GTTATATTTATT...CTTAG|ATA | 2 | 1 | 48.003 |
12239679 | AT-AC | 1 | 99.9999999998676 | 100 | rna-XM_027997268.1 2279590 | 12 | 3823838 | 3823937 | Aphis gossypii 80765 | ATA|ATATCCTTTT...ATTTCCTTAACG/ATAATGTTAATT...TTTAC|TTA | 2 | 1 | 53.602 |
12239680 | GT-AG | 0 | 0.0066837526646084 | 71 | rna-XM_027997268.1 2279590 | 13 | 3823628 | 3823698 | Aphis gossypii 80765 | GAG|GTATTTTAAA...ATATTCTTATAT/AATATTCTTATA...ATCAG|GAA | 0 | 1 | 58.153 |
12239681 | GT-AG | 0 | 2.816645056729059e-05 | 146 | rna-XM_027997268.1 2279590 | 14 | 3823241 | 3823386 | Aphis gossypii 80765 | ACA|GTAAGTACAT...GTGCTTTTAAAT/GTGCTTTTAAAT...TTCAG|TTA | 1 | 1 | 66.045 |
12239682 | GT-AG | 0 | 1.000000099473604e-05 | 1036 | rna-XM_027997268.1 2279590 | 15 | 3821951 | 3822986 | Aphis gossypii 80765 | TTG|GTAATTTAAA...AACATCATAAAA/ATGACACTAATA...TTTAG|ACA | 0 | 1 | 74.361 |
12239683 | GT-AG | 0 | 1.000000099473604e-05 | 78 | rna-XM_027997268.1 2279590 | 16 | 3821744 | 3821821 | Aphis gossypii 80765 | GAG|GTACAAAACA...AATTATTTAATT/AATTATTTAATT...TTTAG|TAT | 0 | 1 | 78.585 |
12239684 | GT-AG | 0 | 1.000000099473604e-05 | 1956 | rna-XM_027997268.1 2279590 | 17 | 3819609 | 3821564 | Aphis gossypii 80765 | GTA|GTAAGTGATG...TAATAATTAATT/TAATAATTAATT...TTCAG|CTG | 2 | 1 | 84.447 |
12239685 | GT-AG | 0 | 1.000000099473604e-05 | 405 | rna-XM_027997268.1 2279590 | 18 | 3818974 | 3819378 | Aphis gossypii 80765 | AAG|GTAAGAGTAT...GACACTATAATT/AATAGATTAAAT...TCTAG|ACA | 1 | 1 | 91.978 |
12239686 | GT-AG | 0 | 1.000000099473604e-05 | 1103 | rna-XM_027997268.1 2279590 | 19 | 3817751 | 3818853 | Aphis gossypii 80765 | TGG|GTGAGAAGGG...ACCGCTATAATA/ACTTCATTCATC...TTCAG|TGT | 1 | 1 | 95.907 |
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]);