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)
32 rows where transcript_id = 34480504
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193750970 | GT-AG | 0 | 58.67674579771504 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 1 | 3386370 | 3386425 | Syncephalastrum racemosum 13706 | AAG|GTATCCTTTT...TCTTCCCTAATC/TCTTCCCTAATC...CTCAG|TCT | 2 | 1 | 1.845 |
193750971 | GT-AG | 0 | 0.5478179352179712 | 101 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 2 | 3386554 | 3386654 | Syncephalastrum racemosum 13706 | CCC|GTATGTTTGC...TGATTTTTGATG/TGATTTTTGATG...TTTAG|AGC | 1 | 1 | 4.59 |
193750972 | GT-AG | 0 | 1.000000099473604e-05 | 60 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 3 | 3386776 | 3386835 | Syncephalastrum racemosum 13706 | CAG|GTACGGCGTT...GCCCTCATATCA/AGCGCCCTCATA...CGTAG|CAC | 2 | 1 | 7.186 |
193750973 | GT-AG | 0 | 1.6178185899257447e-05 | 60 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 4 | 3386921 | 3386980 | Syncephalastrum racemosum 13706 | AAG|GTAGACACCC...TCACACTTACCG/CATACATTCATC...TGCAG|ATT | 0 | 1 | 9.009 |
193750974 | GT-AG | 0 | 1.000000099473604e-05 | 66 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 5 | 3387083 | 3387148 | Syncephalastrum racemosum 13706 | GAG|GTTAGAAGAG...ATCCATATAACC/ATCCATATAACC...TTTAG|GAC | 0 | 1 | 11.197 |
193750975 | GT-AG | 0 | 1.000000099473604e-05 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 6 | 3387257 | 3387308 | Syncephalastrum racemosum 13706 | ATG|GTATGAATAT...CTAGTCATACAT/TACATGCTAATG...AGTAG|AAA | 0 | 1 | 13.514 |
193750976 | GT-AG | 0 | 1.000000099473604e-05 | 53 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 7 | 3387374 | 3387426 | Syncephalastrum racemosum 13706 | CGG|GTACGGCTCT...ATTGACATATTG/GCGAGATTGACA...CCTAG|ATG | 2 | 1 | 14.908 |
193750977 | GT-AG | 0 | 2.4229892379166257e-05 | 55 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 8 | 3387554 | 3387608 | Syncephalastrum racemosum 13706 | CGG|GTAAGCTTCA...AAAACCAAAGCT/CCAAAGCTGAAG...ACTAG|GAC | 0 | 1 | 17.632 |
193750978 | GT-AG | 0 | 1.000000099473604e-05 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 9 | 3387680 | 3387730 | Syncephalastrum racemosum 13706 | ATG|GTAACAGCAG...ACACTCAAAATT/CTATTGGTCACA...TTTAG|GCG | 2 | 1 | 19.155 |
193750979 | GT-AG | 0 | 1.000000099473604e-05 | 60 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 10 | 3388057 | 3388116 | Syncephalastrum racemosum 13706 | CCG|GTAAGATGCA...CACCCCATAATC/ACTCGTTTAACA...ACTAG|ATT | 1 | 1 | 26.148 |
193750980 | GT-AG | 0 | 1.000000099473604e-05 | 55 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 11 | 3388143 | 3388197 | Syncephalastrum racemosum 13706 | GCG|GTAAGTGGAA...TGTATTTTGAAA/AATGCACTCATT...CACAG|ATA | 0 | 1 | 26.705 |
193750981 | GC-AG | 0 | 1.000000099473604e-05 | 54 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 12 | 3388280 | 3388333 | Syncephalastrum racemosum 13706 | GGG|GCAAGTACCT...TATGTCTAATAG/TTATGTCTAATA...AACAG|AAC | 1 | 1 | 28.464 |
193750982 | GT-AG | 0 | 1.000000099473604e-05 | 47 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 13 | 3388552 | 3388598 | Syncephalastrum racemosum 13706 | GTG|GTAAGCGCTT...ACGATTTTAGAA/TAGAATTTCATC...TGTAG|CTC | 0 | 1 | 33.14 |
193750983 | GT-AG | 0 | 0.0002794199428833 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 14 | 3388770 | 3388820 | Syncephalastrum racemosum 13706 | CAG|GTATTTGCTT...TTGTTATTGACA/TTGTTATTGACA...TACAG|CTT | 0 | 1 | 36.808 |
193750984 | GT-AG | 0 | 1.000000099473604e-05 | 52 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 15 | 3388884 | 3388935 | Syncephalastrum racemosum 13706 | GAG|GTAGATGAGT...CTAACCTTGCTG/GTAAGGCTAACC...ACTAG|TCA | 0 | 1 | 38.16 |
193750985 | GT-AG | 0 | 2.536082506572843e-05 | 49 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 16 | 3389145 | 3389193 | Syncephalastrum racemosum 13706 | AAG|GTATGAATTG...TAATTCATACTT/TAGTAATTCATA...AATAG|TGC | 2 | 1 | 42.643 |
193750986 | GT-AG | 0 | 0.0003905108633509 | 55 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 17 | 3389289 | 3389343 | Syncephalastrum racemosum 13706 | CCG|GTAATCTATG...TCACCTTTGCCC/ATTCAGCTCACC...CAAAG|ATG | 1 | 1 | 44.68 |
193750987 | GC-AG | 0 | 1.000000099473604e-05 | 55 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 18 | 3389488 | 3389542 | Syncephalastrum racemosum 13706 | ACG|GCAAGTAAAA...TTGTACATAATT/TTGTACATAATT...TATAG|GTT | 1 | 1 | 47.769 |
193750988 | GT-AG | 0 | 1.000000099473604e-05 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 19 | 3389689 | 3389739 | Syncephalastrum racemosum 13706 | CCG|GTGAGTGACA...CATGCCTCAATA/AATATATTTATC...TCCAG|CTA | 0 | 1 | 50.901 |
193750989 | GT-AG | 0 | 1.000000099473604e-05 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 20 | 3389894 | 3389944 | Syncephalastrum racemosum 13706 | AAG|GTGAGGAATC...GGTATCTAACTC/ATCTAACTCATA...TGTAG|GGT | 1 | 1 | 54.204 |
193750990 | GT-AG | 0 | 0.0191637290864005 | 46 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 21 | 3389997 | 3390042 | Syncephalastrum racemosum 13706 | CGA|GTATGTACAT...TGCTCCTTACCA/TTACATCTAACA...ATTAG|AGA | 2 | 1 | 55.32 |
193750991 | GT-AG | 0 | 1.704304879033066e-05 | 50 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 22 | 3390154 | 3390203 | Syncephalastrum racemosum 13706 | TGA|GTAAGTATAC...TTGTTCTTGGTA/CAGTGCCTCATT...TGCAG|TAG | 2 | 1 | 57.701 |
193750992 | GT-AG | 0 | 1.000000099473604e-05 | 51 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 23 | 3390238 | 3390288 | Syncephalastrum racemosum 13706 | GAA|GTAAGACAGA...TAGTCTTTAGTA/AGTGATTTGACA...TGTAG|AAG | 0 | 1 | 58.43 |
193750993 | GT-AG | 0 | 3.18223107211947e-05 | 50 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 24 | 3390403 | 3390452 | Syncephalastrum racemosum 13706 | TTG|GTAAGCTAAA...TAGAGCTTATCT/GCTTATCTAATT...TTCAG|TAT | 0 | 1 | 60.875 |
193750994 | GT-AG | 0 | 1.000000099473604e-05 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 25 | 3390479 | 3390534 | Syncephalastrum racemosum 13706 | ACG|GTAAGAGACT...TCTCGCTGAAAA/ATACAAGTAACA...TATAG|CCG | 2 | 1 | 61.433 |
193750995 | GT-AG | 0 | 1.000000099473604e-05 | 59 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 26 | 3391068 | 3391126 | Syncephalastrum racemosum 13706 | ATG|GTAAGAATGG...TTCCTCCTATAC/CCTATACCAACT...ATTAG|GAA | 1 | 1 | 72.866 |
193750996 | GT-AG | 0 | 0.000354852752001 | 47 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 27 | 3391301 | 3391347 | Syncephalastrum racemosum 13706 | AAG|GTAAACTAAA...ATTTTCTTGATG/ATTTTCTTGATG...GCTAG|GCG | 1 | 1 | 76.598 |
193750997 | GT-AG | 0 | 0.0011653730777845 | 57 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 28 | 3391433 | 3391489 | Syncephalastrum racemosum 13706 | TAG|GTACACTACT...TGATCCTTGGTT/TTGGTTCTCATT...TGTAG|GGT | 2 | 1 | 78.421 |
193750998 | GT-AG | 0 | 1.000000099473604e-05 | 48 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 29 | 3391600 | 3391647 | Syncephalastrum racemosum 13706 | GCA|GTAAGTGAAG...TTATTCTAATCG/ATTATTCTAATC...TGTAG|ATG | 1 | 1 | 80.781 |
193750999 | GC-AG | 0 | 1.000000099473604e-05 | 54 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 30 | 3391774 | 3391827 | Syncephalastrum racemosum 13706 | ATG|GCAAGTTTCC...CAATTCTTGAAT/CAATTCTTGAAT...CTTAG|GGC | 1 | 1 | 83.483 |
193751000 | GT-AG | 0 | 0.0002058650501337 | 54 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 31 | 3392136 | 3392189 | Syncephalastrum racemosum 13706 | AAG|GTACTCACAA...TCTGTCTTACAA/GTCTGTCTTACA...TTTAG|CCA | 0 | 1 | 90.09 |
193751001 | GT-AG | 0 | 1.000000099473604e-05 | 56 | rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA483381 34480504 | 32 | 3392414 | 3392469 | Syncephalastrum racemosum 13706 | CAG|GTATAAAGAG...GCAAACTGAACG/AGCAAACTGAAC...AATAG|TAC | 2 | 1 | 94.895 |
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]);