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 = 34480567
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193751524 | GT-AG | 0 | 1.000000099473604e-05 | 92 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 1 | 4621255 | 4621346 | Syncephalastrum racemosum 13706 | GAG|GTATGAGTCT...TCTGCCTTTTTC/CTTTGTCTCATT...TTCAG|TTG | 0 | 1 | 6.557 |
193751525 | GT-AG | 0 | 0.0826151356063753 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 2 | 4621184 | 4621232 | Syncephalastrum racemosum 13706 | GTT|GTACGTTTTC...CTTTCGTTGACT/CTTTCGTTGACT...TTTAG|CAT | 1 | 1 | 7.265 |
193751526 | GT-AG | 0 | 0.0001092793064072 | 57 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 3 | 4620837 | 4620893 | Syncephalastrum racemosum 13706 | CAG|GTACGTGCTT...TTATCTTTGACA/TTTATCTTTATC...CAAAG|TTC | 0 | 1 | 16.586 |
193751527 | GT-AG | 0 | 0.0001583862175349 | 53 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 4 | 4620561 | 4620613 | Syncephalastrum racemosum 13706 | TCG|GTAAGCATCT...TGTCCCTCATTT/CTGTCCCTCATT...AAAAG|CCG | 1 | 1 | 23.754 |
193751528 | GT-AG | 0 | 0.0004876190640937 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 5 | 4620260 | 4620310 | Syncephalastrum racemosum 13706 | TGT|GTAGGTCTTG...TTCATTTTATTC/ATTTTATTCATT...CATAG|GGA | 2 | 1 | 31.79 |
193751529 | GT-AG | 0 | 1.000000099473604e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 6 | 4620100 | 4620148 | Syncephalastrum racemosum 13706 | TAG|GTAAGAAGGA...TGTACCTTACCC/ATGTACCTTACC...CATAG|TAC | 2 | 1 | 35.358 |
193751530 | GT-AG | 0 | 2.214361567063521e-05 | 60 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 7 | 4619949 | 4620008 | Syncephalastrum racemosum 13706 | CAG|GTACATACTC...CATGCATTGAAA/ATCGTACTCATC...TTAAG|CTC | 0 | 1 | 38.284 |
193751531 | GT-AG | 0 | 1.000000099473604e-05 | 55 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 8 | 4619785 | 4619839 | Syncephalastrum racemosum 13706 | TTG|GTAAGTGGTG...ATGTCCTGGAGT/AGTTGGCTGACA...GAAAG|TGG | 1 | 1 | 41.787 |
193751532 | GT-AG | 0 | 1.000000099473604e-05 | 77 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 9 | 4619610 | 4619686 | Syncephalastrum racemosum 13706 | GCG|GTAGGTGACT...AAAGACTCATCT/GAAAGACTCATC...TTTAG|TAC | 0 | 1 | 44.937 |
193751533 | GT-AG | 0 | 1.000000099473604e-05 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 10 | 4619520 | 4619571 | Syncephalastrum racemosum 13706 | CTC|GTAAGTGGTA...TCGCTCACATTT/AGATCGCTCACA...TTCAG|GAA | 2 | 1 | 46.159 |
193751534 | GC-AG | 0 | 1.000000099473604e-05 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 11 | 4619448 | 4619498 | Syncephalastrum racemosum 13706 | ATA|GCAAGTGTTA...CAAGCATTGATT/CAAGCATTGATT...TATAG|CTC | 2 | 1 | 46.834 |
193751535 | GT-AG | 0 | 1.000000099473604e-05 | 46 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 12 | 4619360 | 4619405 | Syncephalastrum racemosum 13706 | ACA|GTAAGTGCCT...GATACATTATTC/ACATTATTCATG...CGCAG|CAA | 2 | 1 | 48.184 |
193751536 | GC-AG | 0 | 1.000000099473604e-05 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 13 | 4619248 | 4619303 | Syncephalastrum racemosum 13706 | ATG|GCAAGTACTA...ATGGACCTAACG/ATGGACCTAACG...TATAG|GAG | 1 | 1 | 49.984 |
193751537 | GT-AG | 0 | 1.000000099473604e-05 | 59 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 14 | 4619096 | 4619154 | Syncephalastrum racemosum 13706 | TTG|GTAAAAATAA...AATCGCTTACTG/TAATCGCTTACT...CATAG|ACA | 1 | 1 | 52.973 |
193751538 | GT-AG | 0 | 6.565914865252833e-05 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 15 | 4618783 | 4618833 | Syncephalastrum racemosum 13706 | TTC|GTAAGTTACT...AAAATCTTTGCG/TTTGTACTCAAA...TTCAG|TCA | 2 | 1 | 61.395 |
193751539 | GT-AG | 0 | 0.0001309562515073 | 50 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 16 | 4618127 | 4618176 | Syncephalastrum racemosum 13706 | CAG|GTAGGCCTCC...GACCCTTTGAAT/AGCGTACTCATA...CCTAG|CGT | 2 | 1 | 80.874 |
193751540 | GT-AG | 0 | 1.000000099473604e-05 | 57 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 17 | 4617990 | 4618046 | Syncephalastrum racemosum 13706 | AAC|GTAAGTCAAG...AGTGGCTGAATA/TAGTGGCTGAAT...ACCAG|CGG | 1 | 1 | 83.446 |
193751541 | GT-AG | 0 | 6.0721176020599535e-05 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 18 | 4617818 | 4617873 | Syncephalastrum racemosum 13706 | GCA|GTAAGTTTTC...TGTGGATTGACA/TGTGGATTGACA...TGTAG|GGC | 0 | 1 | 87.175 |
193751542 | GT-AG | 0 | 2.6915463275028337e-05 | 58 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560512 34480567 | 19 | 4617505 | 4617562 | Syncephalastrum racemosum 13706 | CAG|GTACGTCTTC...GAGATCATAACA/GAAAGTCTTATG...CTTAG|GGC | 0 | 1 | 95.371 |
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]);