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)
12 rows where transcript_id = 2279595
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12239734 | GT-AG | 0 | 1.000000099473604e-05 | 840 | rna-XM_027987341.1 2279595 | 2 | 4361117 | 4361956 | Aphis gossypii 80765 | CAG|GTAAGCACTA...TATATTTTATTA/ATATATTTTATT...TTTAG|GTG | 2 | 1 | 30.649 |
12239735 | GT-AG | 0 | 2.6391671852019173e-05 | 72 | rna-XM_027987341.1 2279595 | 3 | 4360855 | 4360926 | Aphis gossypii 80765 | GAG|GTAAATTAAT...ATACTTTTAATT/TTTATATTCATT...TACAG|ATT | 0 | 1 | 36.696 |
12239736 | GT-AG | 0 | 1.000000099473604e-05 | 98 | rna-XM_027987341.1 2279595 | 4 | 4360569 | 4360666 | Aphis gossypii 80765 | GAG|GTAAAATGAT...ATGACTTTAAAA/TATATTATGACT...ATTAG|ACA | 2 | 1 | 42.68 |
12239737 | GT-AG | 0 | 4.359900542982804e-05 | 73 | rna-XM_027987341.1 2279595 | 5 | 4360360 | 4360432 | Aphis gossypii 80765 | AAA|GTAAATATAA...TTATATTTAACA/TTTTTTATAATT...ATTAG|AAA | 0 | 1 | 47.008 |
12239738 | GT-AG | 0 | 0.6620847176697721 | 70 | rna-XM_027987341.1 2279595 | 6 | 4360099 | 4360168 | Aphis gossypii 80765 | AAA|GTATGTTTTT...TTTTCTTTATTT/ATTTTCTTTATT...TTTAG|CTG | 2 | 1 | 53.087 |
12239739 | GT-AG | 0 | 0.0001299523169504 | 63 | rna-XM_027987341.1 2279595 | 7 | 4359498 | 4359560 | Aphis gossypii 80765 | AAT|GTAATATTAT...TTTTTCTTAAAC/ATTAATCTAATT...TTTAG|GTT | 0 | 1 | 70.21 |
12239740 | GT-AG | 0 | 0.0004766906529653 | 284 | rna-XM_027987341.1 2279595 | 8 | 4359101 | 4359384 | Aphis gossypii 80765 | TAT|GTAAGTTGTT...TTAACCTTATTA/ATTAACCTTATT...TCTAG|AAT | 2 | 1 | 73.806 |
12239741 | GT-AG | 0 | 1.798150961722291e-05 | 114 | rna-XM_027987341.1 2279595 | 9 | 4358799 | 4358912 | Aphis gossypii 80765 | TAG|GTAAACAATT...TATTCATTATTG/TATCTATTCATT...TGTAG|AAC | 1 | 1 | 79.79 |
12239742 | GT-AG | 0 | 1.000000099473604e-05 | 63 | rna-XM_027987341.1 2279595 | 10 | 4358629 | 4358691 | Aphis gossypii 80765 | AAG|GTAAAAAAAA...CTAGTATTATCA/TAAAAATTAACT...TTTAG|ACG | 0 | 1 | 83.195 |
12239743 | GT-AG | 0 | 1.000000099473604e-05 | 105 | rna-XM_027987341.1 2279595 | 11 | 4358380 | 4358484 | Aphis gossypii 80765 | GAT|GTGCGTAATT...ATACATTTATCT/GATACATTTATC...TGAAG|GTA | 0 | 1 | 87.778 |
12239744 | GC-AG | 0 | 1.000000099473604e-05 | 70 | rna-XM_027987341.1 2279595 | 12 | 4358149 | 4358218 | Aphis gossypii 80765 | TAG|GCAAGTTAAA...ATTGTTTTATTA/GTTTTATTAATT...ATTAG|AAG | 2 | 1 | 92.903 |
12240580 | GT-AG | 0 | 1.000000099473604e-05 | 1689 | rna-XM_027987341.1 2279595 | 1 | 4362319 | 4364007 | Aphis gossypii 80765 | AAA|GTGAGTTTTC...AAAATTTTAGAT/AAAGGTTTAATA...TTTAG|ATG | 0 | 19.128 |
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]);