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)
23 rows where transcript_id = 9114878
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49389555 | GT-AG | 0 | 0.0009635482224958 | 1377 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 1 | 4329731 | 4331107 | Columbina picui 115618 | TAG|GTATTTAATG...AAAGCTTTAGTA/TTACTTTTTATG...TGCAG|GAT | 1 | 1 | 6.43 |
49389556 | GT-AG | 0 | 0.0002048501070323 | 819 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 2 | 4328704 | 4329522 | Columbina picui 115618 | CAG|GTAAACACCT...GTACTCTTGACT/GTACTCTTGACT...TTTAG|ATT | 2 | 1 | 13.469 |
49389557 | GT-AG | 0 | 1.000000099473604e-05 | 3445 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 3 | 4325089 | 4328533 | Columbina picui 115618 | CTG|GTTTGTGAGA...GTATTGTTAACT/GTATTGTTAACT...TCCAG|GGA | 1 | 1 | 19.222 |
49389558 | GT-AG | 0 | 1.000000099473604e-05 | 2481 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 4 | 4322485 | 4324965 | Columbina picui 115618 | GAG|GTGAGTTTTA...ATGTTTTTTCCA/AGAATTGTCACA...TCTAG|AGT | 1 | 1 | 23.384 |
49389559 | GT-AG | 0 | 0.0006525053083113 | 431 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 5 | 4321941 | 4322371 | Columbina picui 115618 | CGG|GTATGTATAG...ATCTCTTTGTTT/CTTTTGTTTATG...CCCAG|CAA | 0 | 1 | 27.208 |
49389560 | GT-AG | 0 | 1.000000099473604e-05 | 473 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 6 | 4321305 | 4321777 | Columbina picui 115618 | AAG|GTAAGTTCTT...TTTATTTTGATT/TTTATTTTGATT...CATAG|GAT | 1 | 1 | 32.724 |
49389561 | GT-AG | 0 | 1.000000099473604e-05 | 540 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 7 | 4320672 | 4321211 | Columbina picui 115618 | TTC|GTAAGTGAAG...TTTTTCTTTGTG/GAATTAGTAAGC...TCCAG|TGC | 1 | 1 | 35.871 |
49389562 | GT-AG | 0 | 3.7102849902966064e-05 | 1491 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 8 | 4319089 | 4320579 | Columbina picui 115618 | AAG|GTACAGTGAT...TTGTCTTTAATA/TTGTCTTTAATA...CCTAG|GAT | 0 | 1 | 38.985 |
49389563 | GT-AG | 0 | 1.000000099473604e-05 | 2869 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 9 | 4316139 | 4319007 | Columbina picui 115618 | CAT|GTAAGTGTGT...TTTTGTTTAATT/TTTTGTTTAATT...TATAG|TAT | 0 | 1 | 41.726 |
49389564 | GT-AG | 0 | 1.000000099473604e-05 | 8004 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 10 | 4308031 | 4316034 | Columbina picui 115618 | TCG|GTAAGTTAAA...TGTCTCTTTGTT/CTTGTACTCATT...TTCAG|AGT | 2 | 1 | 45.245 |
49389565 | GT-AG | 0 | 1.000000099473604e-05 | 986 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 11 | 4306951 | 4307936 | Columbina picui 115618 | GAA|GTCATTAAGG...GTAACCTCATTG/CGTAACCTCATT...TCTAG|AAA | 0 | 1 | 48.426 |
49389566 | GT-AG | 0 | 7.100688941709133e-05 | 892 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 12 | 4305936 | 4306827 | Columbina picui 115618 | AAG|GTAAGCTCTC...GATGACTTAACA/GATGACTTAACA...TGCAG|GAC | 0 | 1 | 52.589 |
49389567 | GT-AG | 0 | 0.0015511622227164 | 4182 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 13 | 4301671 | 4305852 | Columbina picui 115618 | CAG|GTATGCAATG...ATCATTTTAAAC/GCATATTTTACT...TCCAG|CCC | 2 | 1 | 55.398 |
49389568 | GT-AG | 0 | 5.099424112127496e-05 | 2716 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 14 | 4298810 | 4301525 | Columbina picui 115618 | TAT|GTAAGTACCC...ATTCTTTTATCT/TATTCTTTTATC...CATAG|CTT | 0 | 1 | 60.305 |
49389569 | GT-AG | 0 | 1.000000099473604e-05 | 1992 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 15 | 4296707 | 4298698 | Columbina picui 115618 | GCG|GTAAGATACA...AGTTCTGTAATT/TTTGAACTTACT...TTTAG|TAC | 0 | 1 | 64.061 |
49389570 | GT-AG | 0 | 1.000000099473604e-05 | 1745 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 16 | 4294841 | 4296585 | Columbina picui 115618 | ACG|GTAATGTTCT...ACTGTCTAAATA/ATGTAATTGATT...TCCAG|ATG | 1 | 1 | 68.156 |
49389571 | GT-AG | 0 | 1.000000099473604e-05 | 2107 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 17 | 4292642 | 4294748 | Columbina picui 115618 | CAG|GTTGGTGTGA...AAATCCTTATAT/AAAATCCTTATA...TCCAG|GCT | 0 | 1 | 71.269 |
49389572 | GT-AG | 0 | 0.0001479105945652 | 1104 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 18 | 4291426 | 4292529 | Columbina picui 115618 | ACA|GTAAGTTACA...AAAGTTTTAACT/AAAGTTTTAACT...TTTAG|GAG | 1 | 1 | 75.059 |
49389573 | GT-AG | 0 | 0.0052010130119815 | 2593 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 19 | 4288665 | 4291257 | Columbina picui 115618 | TAG|GTACGTTTTG...TTTCTTTTAATT/TTTGTTTTAATT...CCAAG|GTT | 1 | 1 | 80.745 |
49389574 | GT-AG | 0 | 1.000000099473604e-05 | 2199 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 20 | 4286193 | 4288391 | Columbina picui 115618 | GAG|GTAAGACAAA...TAATTTTTACTG/CTTGTTCTAATT...TGCAG|ATA | 1 | 1 | 89.983 |
49389575 | GT-AG | 0 | 1.000000099473604e-05 | 1508 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 21 | 4284623 | 4286130 | Columbina picui 115618 | AAG|GTAAGTTAGT...AAGGGCTTGATG/GTTCTTCTCACA...TGTAG|GTG | 0 | 1 | 92.081 |
49389576 | GT-AG | 0 | 0.0001861924092401 | 1825 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 22 | 4282725 | 4284549 | Columbina picui 115618 | CCT|GTAAGTATTG...TGGTCCTGAATT/AAGGTACTGATT...AATAG|GCC | 1 | 1 | 94.552 |
49389577 | GT-AG | 0 | 1.000000099473604e-05 | 1135 | rna-gnl|WGS:VYZG|COLPIC_R00025_mrna 9114878 | 23 | 4281522 | 4282656 | Columbina picui 115618 | CAG|GTAAAAAGAA...ACTTTTCTGACT/ACTTTTCTGACT...TGCAG|CCA | 0 | 1 | 96.853 |
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]);