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)
9 rows where transcript_id = 26266774
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145335857 | GT-AG | 0 | 6.470716158796003e-05 | 40 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 1 | 328382 | 328421 | Paragonimus skrjabini miyazakii 59628 | TCA|GTAGGTTACT...TTCATTTCATTT/GTTCATTTCATT...TCGAG|GAG | 2 | 1 | 0.995 |
145335858 | GT-AG | 0 | 1.000000099473604e-05 | 37 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 2 | 328567 | 328603 | Paragonimus skrjabini miyazakii 59628 | GAG|GTAAATATTC...GGTTTGTCAGCC/CGGTTTGTCAGC...TTCAG|GAT | 0 | 1 | 11.301 |
145335859 | GT-AG | 0 | 6.900984529971296e-05 | 1225 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 3 | 328728 | 329952 | Paragonimus skrjabini miyazakii 59628 | ACG|GTAATCTAAG...TTTATTCTAATT/TTTATTCTAATT...TACAG|AGT | 1 | 1 | 20.114 |
145335860 | GT-AG | 0 | 0.0002114559883853 | 18375 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 4 | 330136 | 348510 | Paragonimus skrjabini miyazakii 59628 | TCG|GTATGTAACG...TGCAGTTTAGCT/GCTTTTGTCATT...TTCAG|ATG | 1 | 1 | 33.12 |
145335861 | GT-AG | 0 | 1.000000099473604e-05 | 2304 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 5 | 348798 | 351101 | Paragonimus skrjabini miyazakii 59628 | AAG|GTGCGTTTGG...CTTTCTTCGATT/GCGTTGCTGATT...TTCAG|TTT | 0 | 1 | 53.518 |
145335862 | GT-AG | 0 | 0.0010249823462769 | 3590 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 6 | 351172 | 354761 | Paragonimus skrjabini miyazakii 59628 | TAA|GTAAGTTTTC...ATTGTTTTAATT/ATTGTTTTAATT...TACAG|AAC | 1 | 1 | 58.493 |
145335863 | GT-AG | 0 | 1.000000099473604e-05 | 593 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 7 | 354837 | 355429 | Paragonimus skrjabini miyazakii 59628 | CCG|GTAAGTGTGA...TTCTTTTTATTT/CTTCTTTTTATT...TACAG|ATC | 1 | 1 | 63.824 |
145335864 | GT-AG | 0 | 1.000000099473604e-05 | 3633 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 8 | 355494 | 359126 | Paragonimus skrjabini miyazakii 59628 | TAG|GTAAGGTTCC...TATGTCCTAACA/TATGTCCTAACA...TATAG|ACT | 2 | 1 | 68.372 |
145335865 | GT-AG | 0 | 0.000172037977879 | 1433 | rna-gnl|WGS:JTDE|EG68_00077 26266774 | 9 | 359394 | 360826 | Paragonimus skrjabini miyazakii 59628 | AGC|GTACGTCAAA...TACTTCTCGACA/TCTGATTTCACT...CACAG|ATT | 2 | 1 | 87.349 |
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]);