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)
16 rows where transcript_id = 9114901
This data as json, CSV (advanced)
Suggested facets: score, phase
id ▼ | dinucleotide_pair | is_minor | score | length | transcript_id | ordinal_index | start | end | taxonomy_id | scored_motifs | phase | in_cds | relative_position |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49389860 | GT-AG | 0 | 2.2493286319278016e-05 | 11428 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 1 | 966814 | 978241 | Columbina picui 115618 | CCG|GTAAGTTGTT...ATGGCTTTATTT/AAAATGCTCATA...TACAG|GGT | 2 | 1 | 5.948 |
49389861 | GT-AG | 0 | 1.000000099473604e-05 | 16373 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 2 | 978316 | 994688 | Columbina picui 115618 | CTG|GTGAGTATCT...AATTTTCTAACT/AATTTTCTAACT...TACAG|TGT | 1 | 1 | 10.306 |
49389862 | GT-AG | 0 | 1.000000099473604e-05 | 1369 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 3 | 994807 | 996175 | Columbina picui 115618 | CAG|GTAAATGACT...CATATCTTAAAT/CATGTCTTCATA...AACAG|AGG | 2 | 1 | 17.256 |
49389863 | GT-AG | 0 | 1.000000099473604e-05 | 1389 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 4 | 996272 | 997660 | Columbina picui 115618 | AGG|GTGAGTACTG...TCCACCTTATCT/TGTGGTTTCATT...CTCAG|GCC | 2 | 1 | 22.909 |
49389864 | GT-AG | 0 | 1.000000099473604e-05 | 191 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 5 | 997753 | 997943 | Columbina picui 115618 | CAG|GTGAGTATAA...CCTGTTTTAAAA/CCTGTTTTAAAA...TGCAG|AGA | 1 | 1 | 28.327 |
49389865 | GT-AG | 0 | 0.000114289700706 | 1320 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 6 | 998002 | 999321 | Columbina picui 115618 | TAG|GTACGTATTC...TGTTTCGTACCT/CCTGCTGTGACT...CACAG|CTG | 2 | 1 | 31.743 |
49389866 | GT-AG | 0 | 1.000000099473604e-05 | 1004 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 7 | 999416 | 1000419 | Columbina picui 115618 | AAG|GTGATTGCAA...TGTCTCTTACAT/CATTACCTCACT...TTCAG|GGA | 0 | 1 | 37.279 |
49389867 | GT-AG | 0 | 1.000000099473604e-05 | 1176 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 8 | 1000474 | 1001649 | Columbina picui 115618 | GAT|GTAAGTGTGA...TATCCCTTGGCT/GTGATTTTCATA...TTCAG|GGG | 0 | 1 | 40.459 |
49389868 | GT-AG | 0 | 1.000000099473604e-05 | 742 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 9 | 1001734 | 1002475 | Columbina picui 115618 | GAT|GTAAGTCCTC...GGATGTTTAAAA/TGGATGTTTAAA...TTCAG|AAA | 0 | 1 | 45.406 |
49389869 | GT-AG | 0 | 2.7408594234752976e-05 | 1123 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 10 | 1002518 | 1003640 | Columbina picui 115618 | AAG|GTATGTGATT...TGTACCTGATTC/TTGTACCTGATT...TGCAG|CCT | 0 | 1 | 47.88 |
49389870 | GT-AG | 0 | 1.000000099473604e-05 | 336 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 11 | 1003749 | 1004084 | Columbina picui 115618 | ACG|GTAAGTGGCA...TGTTCCGTACTA/TCCGTACTAAAA...CTCAG|GTG | 0 | 1 | 54.24 |
49389871 | GT-AG | 0 | 1.000000099473604e-05 | 655 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 12 | 1004152 | 1004806 | Columbina picui 115618 | GAG|GTGAGACAAG...TTCCCTTTGGCT/TCTGTTCTGAGT...CTCAG|GCT | 1 | 1 | 58.186 |
49389872 | GT-AG | 0 | 1.000000099473604e-05 | 843 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 13 | 1004978 | 1005820 | Columbina picui 115618 | GCG|GTCAGTAGCA...CTTTTCTGGATT/TTTAAACTTACC...TCCAG|CCC | 1 | 1 | 68.257 |
49389873 | GT-AG | 0 | 1.000000099473604e-05 | 248 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 14 | 1005873 | 1006120 | Columbina picui 115618 | CAA|GTGAGTACTC...TTTACCTTCTCG/CATGTATTTACC...ACTAG|GCA | 2 | 1 | 71.319 |
49389874 | GT-AG | 0 | 0.0014107397013675 | 535 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 15 | 1006182 | 1006716 | Columbina picui 115618 | AAG|GTACCAATCA...CTGCCCTTTGCT/CAGGATCTAACC...TCTAG|AAA | 0 | 1 | 74.912 |
49389875 | GT-AG | 0 | 1.000000099473604e-05 | 213 | rna-gnl|WGS:VYZG|COLPIC_R04149_mrna 9114901 | 16 | 1006894 | 1007106 | Columbina picui 115618 | CTG|GTGAGTTGCA...TCTCTCTTCCAC/CTCTCTTCCACA...TGCAG|ATG | 0 | 1 | 85.336 |
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]);