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)
31 rows where transcript_id = 34480483
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193750759 | GT-AG | 0 | 0.0164552716673808 | 85 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 1 | 3157701 | 3157785 | Syncephalastrum racemosum 13706 | CAG|GTATATTATT...CGTTCTTTATTT/TCTTTATTTATA...GCTAG|ATC | 0 | 1 | 6.496 |
193750760 | GT-AG | 0 | 0.0017296664325324 | 54 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 2 | 3157972 | 3158025 | Syncephalastrum racemosum 13706 | CAG|GTACCTCCAT...AGTTTCCTGACT/AGTTTCCTGACT...GATAG|GAC | 0 | 1 | 8.48 |
193750761 | GT-AG | 0 | 1.342741660521211e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 3 | 3158099 | 3158147 | Syncephalastrum racemosum 13706 | AAG|GTACTGTCAC...GATCCCATAACG/ATAAGTCTGACA...TCAAG|GTG | 1 | 1 | 9.259 |
193750762 | GT-AG | 0 | 1.000000099473604e-05 | 63 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 4 | 3158317 | 3158379 | Syncephalastrum racemosum 13706 | TGG|GTGAGTTTTT...GTCGCCATAAGA/ATAAGATTAATG...TTTAG|CTG | 2 | 1 | 11.061 |
193750763 | GT-AG | 0 | 7.485262862467122e-05 | 50 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 5 | 3158550 | 3158599 | Syncephalastrum racemosum 13706 | AAA|GTATGTGCAT...AAAGTCATAAAG/ATAAAGCTTACA...ATTAG|CGA | 1 | 1 | 12.875 |
193750764 | GT-AG | 0 | 1.000000099473604e-05 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 6 | 3158746 | 3158796 | Syncephalastrum racemosum 13706 | AAG|GTAGGGTAGA...TTTTTCTCACAT/ATTTTTCTCACA...GCCAG|ATT | 0 | 1 | 14.432 |
193750765 | GT-AG | 0 | 1.000000099473604e-05 | 53 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 7 | 3159321 | 3159373 | Syncephalastrum racemosum 13706 | ATG|GTAAGTCACC...GGATGCTGAATA/CGGATGCTGAAT...ATTAG|TCT | 2 | 1 | 20.021 |
193750766 | GT-AG | 0 | 0.0002016320674177 | 55 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 8 | 3159598 | 3159652 | Syncephalastrum racemosum 13706 | TCC|GTAAGTATCA...ATCGCCTAATCT/AATCGCCTAATC...GCTAG|CTT | 1 | 1 | 22.411 |
193750767 | GT-AG | 0 | 1.000000099473604e-05 | 50 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 9 | 3159771 | 3159820 | Syncephalastrum racemosum 13706 | AGG|GTAAGAAGGC...TGATTTTTGACT/TGATTTTTGACT...TACAG|ACT | 2 | 1 | 23.669 |
193750768 | GT-AG | 0 | 1.000000099473604e-05 | 62 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 10 | 3159939 | 3160000 | Syncephalastrum racemosum 13706 | CGG|GTAAGGCGCT...AACCCCATACTG/CCCATACTGAAT...ATCAG|GCT | 0 | 1 | 24.928 |
193750769 | GT-AG | 0 | 1.000000099473604e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 11 | 3160230 | 3160278 | Syncephalastrum racemosum 13706 | AAG|GTAATTGAAA...TATGGCTTATTC/TTATGGCTTATT...TGCAG|CTT | 1 | 1 | 27.371 |
193750770 | GT-AG | 0 | 0.0001768662473336 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 12 | 3160466 | 3160517 | Syncephalastrum racemosum 13706 | TGA|GTATGTGAAA...CGACTCATAGTT/CACCGACTCATA...TTTAG|GGA | 2 | 1 | 29.365 |
193750771 | GT-AG | 0 | 1.000000099473604e-05 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 13 | 3160756 | 3160807 | Syncephalastrum racemosum 13706 | AAG|GTAAAAAGGC...TGTGTCTTATCC/TTGTGTCTTATC...CATAG|CTA | 0 | 1 | 31.904 |
193750772 | GT-AG | 0 | 1.000000099473604e-05 | 48 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 14 | 3160896 | 3160943 | Syncephalastrum racemosum 13706 | TGA|GTAAGTAATC...ACGTACTGAATA/GACGTACTGAAT...CATAG|TCG | 1 | 1 | 32.843 |
193750773 | GT-AG | 0 | 1.000000099473604e-05 | 55 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 15 | 3161091 | 3161145 | Syncephalastrum racemosum 13706 | AAG|GTGAGTCTAT...GCTACCATAAGC/TATCGATTTATA...AATAG|ATA | 1 | 1 | 34.411 |
193750774 | GT-AG | 0 | 1.000000099473604e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 16 | 3161211 | 3161259 | Syncephalastrum racemosum 13706 | ACA|GTAAGTAGAA...GTCTCCGTAGAC/CATAATGTCAAC...CAAAG|GGT | 0 | 1 | 35.104 |
193750775 | GT-AG | 0 | 2.2548558175729492e-05 | 47 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 17 | 3161353 | 3161399 | Syncephalastrum racemosum 13706 | CAG|GTATGGTCAT...TTTTGCTAAACC/GTTTTGCTAAAC...GGAAG|GCT | 0 | 1 | 36.096 |
193750776 | GT-AG | 0 | 0.0003690329681851 | 48 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 18 | 3162711 | 3162758 | Syncephalastrum racemosum 13706 | AAG|GTATTTTCTC...TAAATCATGCTA/ATCATGCTAAGA...TCCAG|TTT | 0 | 1 | 50.08 |
193750777 | GT-AG | 0 | 0.1726602775411186 | 65 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 19 | 3163503 | 3163567 | Syncephalastrum racemosum 13706 | AAA|GTATATTTTC...TTAACATTGATA/TTGATACTTACT...TGCAG|ATC | 0 | 1 | 58.016 |
193750778 | GT-AG | 0 | 1.000000099473604e-05 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 20 | 3164709 | 3164764 | Syncephalastrum racemosum 13706 | TGA|GTAAGTCATA...CTTGGGTTGATC/CTTGGGTTGATC...CTTAG|GCG | 1 | 1 | 70.187 |
193750779 | GT-AG | 0 | 1.000000099473604e-05 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 21 | 3165010 | 3165061 | Syncephalastrum racemosum 13706 | ACG|GTAATAATTA...GATATGATAGCT/TGATAGCTGACA...ATTAG|AAA | 0 | 1 | 72.8 |
193750780 | GT-AG | 0 | 1.000000099473604e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 22 | 3165765 | 3165813 | Syncephalastrum racemosum 13706 | CAG|GTACGCCGAA...CAGTATCTAACG/CAGTATCTAACG...TAAAG|ATG | 1 | 1 | 80.299 |
193750781 | GT-AG | 0 | 0.002318481019028 | 63 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 23 | 3166002 | 3166064 | Syncephalastrum racemosum 13706 | CTG|GTATATCGAA...AAACTCTTGATT/ACTTGACTTATA...AATAG|AGC | 0 | 1 | 82.304 |
193750782 | GT-AG | 0 | 0.0032322053702725 | 45 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 24 | 3166158 | 3166202 | Syncephalastrum racemosum 13706 | AAG|GTATACCATC...ATATTCTAACCG/CATATTCTAACC...TCCAG|AGT | 0 | 1 | 83.296 |
193750783 | GT-AG | 0 | 9.511528049279156e-05 | 54 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 25 | 3166266 | 3166319 | Syncephalastrum racemosum 13706 | CAG|GTATATTAAA...TCATCCATCGTT/CAGATGTTCATC...TATAG|CTC | 0 | 1 | 83.968 |
193750784 | GT-AG | 0 | 2.6906602302743903e-05 | 66 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 26 | 3166620 | 3166685 | Syncephalastrum racemosum 13706 | ATG|GTAAGTTCTT...TGTCACTTAGTC/AAGGTTGTCACT...TTTAG|ATA | 0 | 1 | 87.168 |
193750785 | GT-AG | 0 | 0.0005936565606514 | 64 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 27 | 3166806 | 3166869 | Syncephalastrum racemosum 13706 | CAT|GTAAGCTGGC...TTTTCCTTCTTT/TGTACGCTTATT...TTCAG|TTG | 0 | 1 | 88.448 |
193750786 | GT-AG | 0 | 1.000000099473604e-05 | 58 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 28 | 3167026 | 3167083 | Syncephalastrum racemosum 13706 | AAG|GTAAATCAAT...AACTCCTTTGCT/TAATGGCTTACA...TCTAG|TGC | 0 | 1 | 90.112 |
193750787 | GT-AG | 0 | 1.000000099473604e-05 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 29 | 3167246 | 3167296 | Syncephalastrum racemosum 13706 | ATG|GTAAGGTGAT...TGATCTCTAACG/TGATCTCTAACG...TACAG|AGA | 0 | 1 | 91.84 |
193750788 | GT-AG | 0 | 3.424383159498273e-05 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 30 | 3167582 | 3167633 | Syncephalastrum racemosum 13706 | CTG|GTAAGCTCCA...ATTCTCATACAA/GGCATTCTCATA...CCCAG|TTA | 0 | 1 | 94.88 |
193750789 | GT-AG | 0 | 1.000000099473604e-05 | 65 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 | 31 | 3168036 | 3168100 | Syncephalastrum racemosum 13706 | CAG|GTAGGGACAA...CTACCTCTGATA/GTTCATCTGATA...TTAAG|GTG | 0 | 1 | 99.168 |
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]);