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)
17 rows where transcript_id = 34480489
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193750848 | GT-AG | 0 | 1.000000099473604e-05 | 60 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 1 | 1872698 | 1872757 | Syncephalastrum racemosum 13706 | AAG|GTAAGAAATA...ACAACTTTAAAA/ACAACTTTAAAA...GACAG|CTA | 0 | 1 | 0.889 |
193750849 | GT-AG | 0 | 0.0003505070909939 | 75 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 2 | 1872946 | 1873020 | Syncephalastrum racemosum 13706 | CCC|GTAAATATTC...TTCTCATTGACG/CCTGTTCTCATT...TCTAG|CAC | 2 | 1 | 3.82 |
193750850 | GT-AG | 0 | 0.0114042651908935 | 82 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 3 | 1873148 | 1873229 | Syncephalastrum racemosum 13706 | ATC|GTACGTTCCT...TTTTCCATGACA/GGATCTCTGATT...CACAG|GAA | 0 | 1 | 5.8 |
193750851 | GT-AG | 0 | 1.000000099473604e-05 | 71 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 4 | 1873401 | 1873471 | Syncephalastrum racemosum 13706 | GAG|GTCAGAGTCA...CAAACCCTACCA/AATCAGCTCAAC...TGCAG|GCG | 0 | 1 | 8.466 |
193750852 | GT-AG | 0 | 0.0001514198087968 | 57 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 5 | 1873671 | 1873727 | Syncephalastrum racemosum 13706 | TGG|GTAAGCTGCA...GCTTTCTAAATG/CGCTTTCTAAAT...CCTAG|ATA | 1 | 1 | 11.568 |
193750853 | GT-AG | 0 | 0.0002870864926323 | 47 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 6 | 1873853 | 1873899 | Syncephalastrum racemosum 13706 | AGT|GTAACAAATG...ATTATATTAAAC/ATTATATTAAAC...ACTAG|GCG | 0 | 1 | 13.517 |
193750854 | GT-AG | 0 | 1.4316886672009218e-05 | 48 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 7 | 1874014 | 1874061 | Syncephalastrum racemosum 13706 | AAA|GTACAGTCGT...CTATCACTGACC/CTATCACTGACC...TACAG|CGT | 0 | 1 | 15.295 |
193750855 | GT-AG | 0 | 1.7568471455486713e-05 | 57 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 8 | 1874164 | 1874220 | Syncephalastrum racemosum 13706 | GTA|GTAAGTCATC...CCTTCTTGAATT/ACACAACTCACA...GCCAG|GTC | 0 | 1 | 16.885 |
193750856 | GT-AG | 0 | 1.000000099473604e-05 | 53 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 9 | 1874689 | 1874741 | Syncephalastrum racemosum 13706 | AAG|GTGAATATGA...TATGCCTTTGCC/CTTTGCCTAATA...TCCAG|GGA | 0 | 1 | 24.181 |
193750857 | GT-AG | 0 | 1.000000099473604e-05 | 53 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 10 | 1875292 | 1875344 | Syncephalastrum racemosum 13706 | AAG|GTATGGAGAA...AATTCCACAAAA/AGTGGACTGACG...TTCAG|TCT | 1 | 1 | 32.756 |
193750858 | GT-AG | 0 | 1.000000099473604e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 11 | 1875657 | 1875705 | Syncephalastrum racemosum 13706 | CGG|GTAAGCTAAA...CAAAGATTAGAG/TATACACTCATG...AACAG|AGG | 1 | 1 | 37.621 |
193750859 | GT-AG | 0 | 0.0001561967733603 | 45 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 12 | 1875813 | 1875857 | Syncephalastrum racemosum 13706 | ACG|GTAGGCTTCT...TCAGACTAAATT/GTCAGACTAAAT...TATAG|GTT | 0 | 1 | 39.289 |
193750860 | GT-AG | 0 | 1.000000099473604e-05 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 13 | 1876081 | 1876132 | Syncephalastrum racemosum 13706 | TTG|GTGAGTTTCT...TTATTTTTAGCT/TAGCTGTTCACT...TCTAG|GTG | 1 | 1 | 42.766 |
193750861 | GT-AG | 0 | 1.000000099473604e-05 | 61 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 14 | 1877326 | 1877386 | Syncephalastrum racemosum 13706 | AAG|GTATGAAAAA...TGTGTCTTACAT/TTGTGTCTTACA...GATAG|ATT | 0 | 1 | 61.366 |
193750862 | GT-AG | 0 | 2.124818296490881e-05 | 53 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 15 | 1878520 | 1878572 | Syncephalastrum racemosum 13706 | TAG|GTAAGCACAT...TCAACCTTGACG/GCGTGTCTCAAC...CTTAG|TGC | 2 | 1 | 79.03 |
193750863 | GT-AG | 0 | 1.000000099473604e-05 | 57 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 16 | 1879390 | 1879446 | Syncephalastrum racemosum 13706 | CAG|GTGAGATAGA...GCTAACATATAT/ACTCGGCTAACA...CGCAG|GGT | 0 | 1 | 91.768 |
193750864 | GT-AG | 0 | 1.000000099473604e-05 | 48 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA449895 34480489 | 17 | 1879889 | 1879936 | Syncephalastrum racemosum 13706 | CAG|GTAAGCTCTT...TGAGCCGAAAAA/CGCGAGCTCACA...AATAG|ATG | 1 | 1 | 98.659 |
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]);