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 = 34480484
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193750790 | GT-AG | 0 | 1.000000099473604e-05 | 92 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 1 | 4828781 | 4828872 | Syncephalastrum racemosum 13706 | CAG|GTAATGGAAA...AGACTCATACCT/TATAGACTCATA...TGCAG|GAG | 1 | 1 | 1.035 |
193750791 | GT-AG | 0 | 1.2332815302306104e-05 | 69 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 2 | 4828634 | 4828702 | Syncephalastrum racemosum 13706 | AAG|GTAAGTTTTT...GGCGGTTTAACA/AGACTTCTCAGA...ACAAG|GTC | 1 | 1 | 1.867 |
193750792 | GT-AG | 0 | 1.000000099473604e-05 | 80 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 3 | 4828441 | 4828520 | Syncephalastrum racemosum 13706 | AAT|GTGAGTTCTG...AGGATCATAGTA/ATCATAGTAACA...TGTAG|ACG | 0 | 1 | 3.072 |
193750793 | GT-AG | 0 | 1.000000099473604e-05 | 61 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 4 | 4828074 | 4828134 | Syncephalastrum racemosum 13706 | AAG|GTAAAAACAT...CTCATCTTATTC/GCTCATCTTATT...TTTAG|TTG | 0 | 1 | 6.336 |
193750794 | GT-AG | 0 | 3.9367018044281934e-05 | 61 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 5 | 4827914 | 4827974 | Syncephalastrum racemosum 13706 | ATG|GTAAGCCTTT...GGTAACTTAGTC/TGGTAACTTAGT...TTTAG|ATT | 0 | 1 | 7.392 |
193750795 | GT-AG | 0 | 1.000000099473604e-05 | 82 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 6 | 4827199 | 4827280 | Syncephalastrum racemosum 13706 | CAG|GTAAGGAAAA...GACGCCTTTTTG/GTATGGTTCACC...CTTAG|GGA | 0 | 1 | 14.144 |
193750796 | GT-AG | 0 | 1.000000099473604e-05 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 7 | 4827032 | 4827087 | Syncephalastrum racemosum 13706 | GAT|GTAAGTTGAA...AATGCAATATCA/AGTATATTCACG...GTTAG|ACA | 0 | 1 | 15.328 |
193750797 | GT-AG | 0 | 0.0002906990245503 | 58 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 8 | 4826369 | 4826426 | Syncephalastrum racemosum 13706 | GGA|GTAAGTTACT...TTTCTTTTATTC/CTTTCTTTTATT...TCTAG|CTG | 2 | 1 | 21.781 |
193750798 | GT-AG | 0 | 0.0011661781473681 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 9 | 4823207 | 4823262 | Syncephalastrum racemosum 13706 | GCG|GTATGTGTCT...GGTTACTTACCC/AGGTTACTTACC...TGCAG|CTT | 0 | 1 | 54.912 |
193750799 | GT-AG | 0 | 1.000000099473604e-05 | 63 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 10 | 4823027 | 4823089 | Syncephalastrum racemosum 13706 | TCG|GTAAGCAAAA...ACATCCTTGCTC/TCCTTGCTCACT...TACAG|CTC | 0 | 1 | 56.16 |
193750800 | GT-AG | 0 | 0.0009914587449523 | 61 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 11 | 4822549 | 4822609 | Syncephalastrum racemosum 13706 | GAG|GTAACGTATA...TATACTTTATCA/ATATACTTTATC...GACAG|ACG | 0 | 1 | 60.608 |
193750801 | GT-AG | 0 | 7.1583721400209e-05 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 12 | 4821788 | 4821839 | Syncephalastrum racemosum 13706 | CAG|GTACATCTTT...GAGCTCGTAGCG/CGTGATCTAACG...GACAG|AAT | 1 | 1 | 68.171 |
193750802 | GT-AG | 0 | 1.000000099473604e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 13 | 4821618 | 4821666 | Syncephalastrum racemosum 13706 | TAT|GTAAGACCGA...ATGTATTCGACT/ATTCGACTGACT...AACAG|TGA | 2 | 1 | 69.461 |
193750803 | GT-AG | 0 | 1.000000099473604e-05 | 57 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 14 | 4821398 | 4821454 | Syncephalastrum racemosum 13706 | AAG|GTAAGAGAAA...ACATCCTTATTT/CACATCCTTATT...TATAG|TCT | 0 | 1 | 71.2 |
193750804 | GT-AG | 0 | 1.000000099473604e-05 | 50 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 15 | 4820959 | 4821008 | Syncephalastrum racemosum 13706 | ATG|GTAAGTACAT...TAGGACTAACAT/ATAGGACTAACA...GCCAG|GTC | 2 | 1 | 75.349 |
193750805 | GT-AG | 0 | 1.000000099473604e-05 | 61 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 16 | 4820696 | 4820756 | Syncephalastrum racemosum 13706 | GCG|GTACGAGGAC...AAATTCTCGAAT/CTCGAATTGACC...TCTAG|GAT | 0 | 1 | 77.504 |
193750806 | GT-AG | 0 | 1.000000099473604e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 17 | 4820440 | 4820488 | Syncephalastrum racemosum 13706 | CAG|GTAGGTTTGA...TGTGGCTGACCG/ATGTGGCTGACC...TTTAG|GGA | 0 | 1 | 79.712 |
193750807 | GT-AG | 0 | 1.000000099473604e-05 | 59 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 18 | 4820114 | 4820172 | Syncephalastrum racemosum 13706 | CAG|GTGAGCTTCC...AATACCTTATAT/AAATACCTTATA...TATAG|GAA | 0 | 1 | 82.56 |
193750808 | GT-AG | 0 | 0.0001965395480964 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 19 | 4819841 | 4819896 | Syncephalastrum racemosum 13706 | ATT|GTAAGTTCCG...GATGGCTTAACC/GATGGCTTAACC...TATAG|CCC | 1 | 1 | 84.875 |
193750809 | GT-AG | 0 | 1.000000099473604e-05 | 54 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 20 | 4819501 | 4819554 | Syncephalastrum racemosum 13706 | AAG|GTAAGTGAAA...GGATACTTATCA/GGGATACTTATC...CATAG|ACC | 2 | 1 | 87.925 |
193750810 | GT-AG | 0 | 1.000000099473604e-05 | 74 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 21 | 4819360 | 4819433 | Syncephalastrum racemosum 13706 | AAT|GTAAATGAAT...CGGCCATTCACC/CGGCCATTCACC...ATTAG|GCT | 0 | 1 | 88.64 |
193750811 | GT-AG | 0 | 1.000000099473604e-05 | 64 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 22 | 4819145 | 4819208 | Syncephalastrum racemosum 13706 | CAG|GTAAAGCACG...TATTCTATATCA/TGGATACTGATG...CATAG|TTG | 1 | 1 | 90.251 |
193750812 | GT-AG | 0 | 1.000000099473604e-05 | 64 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA560572 34480484 | 23 | 4818971 | 4819034 | Syncephalastrum racemosum 13706 | CGG|GTGAGTATTA...TATGCTAAAGTA/GATATGCTAAAG...TACAG|GGC | 0 | 1 | 91.424 |
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]);