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)
21 rows where transcript_id = 2279583
This data as json, CSV (advanced)
Suggested facets: dinucleotide_pair, score, length, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239544 | GT-AG | 0 | 1.000000099473604e-05 | 291 | rna-XM_027997372.1 2279583 | 1 | 2398022 | 2398312 | Aphis gossypii 80765 | AGA|GTAAGAAAAT...GTTTTTTTACAT/TGTTTTTTTACA...TCCAG|GAG | 0 | 1 | 4.029 |
12239545 | GT-AG | 0 | 0.0010913008988371 | 739 | rna-XM_027997372.1 2279583 | 2 | 2398586 | 2399324 | Aphis gossypii 80765 | GAA|GTATAATCAC...TATACCATAATA/AATTATTTAACG...TATAG|GGT | 0 | 1 | 10.576 |
12239546 | GT-AG | 0 | 1.000000099473604e-05 | 2422 | rna-XM_027997372.1 2279583 | 3 | 2399462 | 2401883 | Aphis gossypii 80765 | CAG|GTAATTACAC...AATTTCTTATTA/TAATTTCTTATT...TTCAG|AAT | 2 | 1 | 13.861 |
12239547 | GT-AG | 0 | 0.0014809398838805 | 113 | rna-XM_027997372.1 2279583 | 4 | 2402045 | 2402157 | Aphis gossypii 80765 | TAG|GTATTTATAA...ATATTTTTATAT/TATATTTTTATA...TATAG|AAA | 1 | 1 | 17.722 |
12239548 | GT-AG | 0 | 0.0001304936078068 | 595 | rna-XM_027997372.1 2279583 | 5 | 2402297 | 2402891 | Aphis gossypii 80765 | TAG|GTAAACTACT...CATCCATTAATA/CTATATCTAATT...CGCAG|ACC | 2 | 1 | 21.055 |
12239549 | GT-AG | 0 | 0.0001316541631256 | 514 | rna-XM_027997372.1 2279583 | 6 | 2403106 | 2403619 | Aphis gossypii 80765 | TGT|GTAAGTATAA...AAAACTTTAATG/TTTATTTTTATC...CGTAG|ACT | 0 | 1 | 26.187 |
12239550 | GT-AG | 0 | 1.000000099473604e-05 | 1507 | rna-XM_027997372.1 2279583 | 7 | 2403788 | 2405294 | Aphis gossypii 80765 | ACT|GTAAGTAGAA...TTTGTATTGAAT/TTTGTATTGAAT...CATAG|GTA | 0 | 1 | 30.216 |
12239551 | GT-AG | 0 | 1.000000099473604e-05 | 80 | rna-XM_027997372.1 2279583 | 8 | 2405625 | 2405704 | Aphis gossypii 80765 | GAC|GTAAGTGTAT...GGCTATTTAAAA/ATTGGTATAATA...TACAG|ACT | 0 | 1 | 38.129 |
12239552 | GT-AG | 0 | 0.0002168895768017 | 300 | rna-XM_027997372.1 2279583 | 9 | 2405791 | 2406090 | Aphis gossypii 80765 | AAG|GTACACATAT...TATATTTCGATA/AACACAATCACT...TTTAG|TTA | 2 | 1 | 40.192 |
12239553 | GT-AG | 0 | 1.000000099473604e-05 | 371 | rna-XM_027997372.1 2279583 | 10 | 2406181 | 2406551 | Aphis gossypii 80765 | TAA|GTGAGCACAT...ACAAACTTATTT/AACAAACTTATT...TTTAG|ATC | 2 | 1 | 42.35 |
12239554 | GT-AG | 0 | 1.000000099473604e-05 | 69 | rna-XM_027997372.1 2279583 | 11 | 2406623 | 2406691 | Aphis gossypii 80765 | CAA|GTAATGACGT...TTTTTTTTAATG/TTTTTTTTAATG...TACAG|GTA | 1 | 1 | 44.053 |
12239555 | GC-AG | 0 | 1.000000099473604e-05 | 68 | rna-XM_027997372.1 2279583 | 12 | 2406748 | 2406815 | Aphis gossypii 80765 | AAG|GCAATGACTT...TTTTTTTTATAT/ATTTTTTTTATA...TTTAG|AAA | 0 | 1 | 45.396 |
12239556 | GT-AG | 0 | 1.9504605926592065e-05 | 69 | rna-XM_027997372.1 2279583 | 13 | 2406950 | 2407018 | Aphis gossypii 80765 | TAA|GTAAGTTAAA...AAAATTTTAAAC/CTAATATTTATT...TTCAG|CTC | 2 | 1 | 48.609 |
12239557 | GT-AG | 0 | 1.000000099473604e-05 | 65 | rna-XM_027997372.1 2279583 | 14 | 2407553 | 2407617 | Aphis gossypii 80765 | GAG|GTAAGTAAAA...AACGTTTTGGCA/TATGTACTTATT...CATAG|ACC | 2 | 1 | 61.415 |
12239558 | GT-AG | 0 | 0.0107851366331372 | 101 | rna-XM_027997372.1 2279583 | 15 | 2407797 | 2407897 | Aphis gossypii 80765 | CAG|GTATCAAATA...TATTTCGTATTA/TGTGTACTCAAT...CCCAG|AAA | 1 | 1 | 65.707 |
12239559 | GT-AG | 0 | 0.0282956482284149 | 60 | rna-XM_027997372.1 2279583 | 16 | 2408054 | 2408113 | Aphis gossypii 80765 | TTG|GTATGTTTTA...TAAATATTAACA/TAAATATTAACA...TACAG|ATA | 1 | 1 | 69.448 |
12239560 | GT-AG | 0 | 0.0020317348676635 | 67 | rna-XM_027997372.1 2279583 | 17 | 2408536 | 2408602 | Aphis gossypii 80765 | AGA|GTACGTTTTT...TAGTTTTTGCTT/TGGATATTAATG...TATAG|GAC | 0 | 1 | 79.568 |
12239561 | GT-AG | 0 | 1.0634086609692844e-05 | 464 | rna-XM_027997372.1 2279583 | 18 | 2408792 | 2409255 | Aphis gossypii 80765 | GCA|GTAAGTATAT...TTATTCATACTG/TAATTATTCATA...TACAG|TCG | 0 | 1 | 84.101 |
12239562 | GT-AG | 0 | 0.1000179017656098 | 81 | rna-XM_027997372.1 2279583 | 19 | 2409440 | 2409520 | Aphis gossypii 80765 | ACG|GTAGCTATTA...TGTTTCTTAAAT/ATGTTTTTGAGT...TACAG|GAA | 1 | 1 | 88.513 |
12239563 | GT-AG | 0 | 0.0007774932530121 | 97 | rna-XM_027997372.1 2279583 | 20 | 2409660 | 2409756 | Aphis gossypii 80765 | AAG|GTATATATGG...GTCGTTATAATA/GTTATAATAACT...ATTAG|ATG | 2 | 1 | 91.847 |
12240574 | GT-AG | 0 | 0.0002817809854496 | 815 | rna-XM_027997372.1 2279583 | 21 | 2409855 | 2410669 | Aphis gossypii 80765 | GAT|GTAAGTTTTT...TTGGTTTTATAT/ATTGGTTTTATA...TCCAG|GGC | 0 | 94.197 |
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]);