home / WtMTA

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)

26 rows where transcript_id = 26266747

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: score, phase, in_cds

id ▼ dinucleotide_pair is_minor score length transcript_id ordinal_index start end taxonomy_id scored_motifs phase in_cds relative_position
145335657 GT-AG 0 1.000000099473604e-05 40 rna-gnl|WGS:JTDE|EG68_00056 26266747 2 258975 259014 Paragonimus skrjabini miyazakii 59628 AAG|GTTAGTCGTC...AAAAGCTAAACG/CAAAAGCTAAAC...TTCAG|AAT 0 1 3.794
145335658 GT-AG 0 1.000000099473604e-05 37 rna-gnl|WGS:JTDE|EG68_00056 26266747 3 259073 259109 Paragonimus skrjabini miyazakii 59628 TCG|GTAAGTGATC...GTGTTAGTAATC/GTGTTAGTAATC...TTCAG|ATA 1 1 4.996
145335659 GT-AG 0 1.000000099473604e-05 4402 rna-gnl|WGS:JTDE|EG68_00056 26266747 4 259589 263990 Paragonimus skrjabini miyazakii 59628 CAG|GTAAGTCGAC...CATGGTTTATTT/TGATTGCTGATT...TGCAG|GAA 0 1 14.925
145335660 GT-AG 0 5.170560719625142e-05 12141 rna-gnl|WGS:JTDE|EG68_00056 26266747 5 264084 276224 Paragonimus skrjabini miyazakii 59628 CAT|GTAAGTATTG...GAATCCTTGTTC/TCCTTGTTCATT...TCTAG|TTA 0 1 16.853
145335661 GT-AG 0 1.000000099473604e-05 1002 rna-gnl|WGS:JTDE|EG68_00056 26266747 6 276615 277616 Paragonimus skrjabini miyazakii 59628 TTG|GTTAGTTTAA...TTGGTCTTTTCA/TTTTCATTCATT...TTTAG|TAT 0 1 24.938
145335662 GT-AG 0 1.000000099473604e-05 1667 rna-gnl|WGS:JTDE|EG68_00056 26266747 7 277790 279456 Paragonimus skrjabini miyazakii 59628 AAA|GTAAGTAATA...GCTTGTTTGATG/GCTTGTTTGATG...ATCAG|AGT 2 1 28.524
145335663 GT-AG 0 1.000000099473604e-05 1107 rna-gnl|WGS:JTDE|EG68_00056 26266747 8 279683 280789 Paragonimus skrjabini miyazakii 59628 CCG|GTGGGTGTGA...AACTTTTCAACC/GAACTTTTCAAC...TCAAG|AAC 0 1 33.209
145335664 GT-AG 0 0.001929585142426 1394 rna-gnl|WGS:JTDE|EG68_00056 26266747 9 280942 282335 Paragonimus skrjabini miyazakii 59628 CCG|GTAATTTTTA...TACTTTTTAGCA/ATACTTTTTAGC...TCCAG|CTA 2 1 36.36
145335665 GT-AG 0 5.6453512948627546e-05 1111 rna-gnl|WGS:JTDE|EG68_00056 26266747 10 282438 283548 Paragonimus skrjabini miyazakii 59628 GAA|GTAAGCGCTT...GCCTTTTTACCT/CTTCTTCTGATA...GATAG|ACG 2 1 38.474
145335666 GT-AG 0 1.1351938856402729e-05 870 rna-gnl|WGS:JTDE|EG68_00056 26266747 11 283634 284503 Paragonimus skrjabini miyazakii 59628 CAC|GTAAGTATAA...CTCCCCTCAATC/TCGTAAATTATT...GACAG|GTT 0 1 40.236
145335667 GT-AG 0 1.000000099473604e-05 2780 rna-gnl|WGS:JTDE|EG68_00056 26266747 12 284598 287377 Paragonimus skrjabini miyazakii 59628 CGT|GTAAGTGATT...TGTCTTTTATTG/GTGTCTTTTATT...TACAG|TTT 1 1 42.185
145335668 GT-AG 0 0.008058008161091 464 rna-gnl|WGS:JTDE|EG68_00056 26266747 13 287450 287913 Paragonimus skrjabini miyazakii 59628 AAG|GTATGCATCT...GTTTCTTTCTTT/AGATGTTTGATA...CCCAG|CTC 1 1 43.677
145335669 GT-AG 0 1.000000099473604e-05 623 rna-gnl|WGS:JTDE|EG68_00056 26266747 14 288011 288633 Paragonimus skrjabini miyazakii 59628 AAG|GTAAGCAAAC...GTTGCCTTCTCC/TATCTATTTATG...TTCAG|TTA 2 1 45.688
145335670 GT-AG 0 1.000000099473604e-05 1342 rna-gnl|WGS:JTDE|EG68_00056 26266747 15 288932 290273 Paragonimus skrjabini miyazakii 59628 CAG|GTAGGTAGCG...TTCTCTTCAATG/CTATTGTTTACT...TCTAG|TGT 0 1 51.866
145335671 GT-AG 0 1.000000099473604e-05 1191 rna-gnl|WGS:JTDE|EG68_00056 26266747 16 290439 291629 Paragonimus skrjabini miyazakii 59628 TCT|GTGAGTTGGA...TTTGTGTTATTT/TTTTGTGTTATT...ATTAG|CGC 0 1 55.286
145335672 GT-AG 0 1.000000099473604e-05 1556 rna-gnl|WGS:JTDE|EG68_00056 26266747 17 291699 293254 Paragonimus skrjabini miyazakii 59628 AAG|GTGAGCATAT...CTACGCTTAATT/GCTTAATTTATC...TCTAG|GCA 0 1 56.716
145335673 GT-AG 0 1.000000099473604e-05 1476 rna-gnl|WGS:JTDE|EG68_00056 26266747 18 293477 294952 Paragonimus skrjabini miyazakii 59628 TGG|GTGAGGTCTT...AATGTCTGACCG/AAATGTCTGACC...TACAG|ACT 0 1 61.318
145335674 GT-AG 0 1.000000099473604e-05 5558 rna-gnl|WGS:JTDE|EG68_00056 26266747 19 295256 300813 Paragonimus skrjabini miyazakii 59628 CGT|GTGAGTGCTG...GGTTTCTTTTTT/GATTACTTCACT...TGCAG|ATC 0 1 67.6
145335675 GT-AG 0 0.0009509216039175 4003 rna-gnl|WGS:JTDE|EG68_00056 26266747 20 300985 304987 Paragonimus skrjabini miyazakii 59628 AAG|GTAACTTCTG...AGACACTTACTT/CACTTACTTATG...TTCAG|GGT 0 1 71.144
145335676 GT-AG 0 1.000000099473604e-05 887 rna-gnl|WGS:JTDE|EG68_00056 26266747 21 305246 306132 Paragonimus skrjabini miyazakii 59628 AAG|GTTCGTCATT...TTTTTCCTACTC/TTCCTACTCATT...ACAAG|GCT 0 1 76.493
145335677 GT-AG 0 1.000000099473604e-05 1276 rna-gnl|WGS:JTDE|EG68_00056 26266747 22 306488 307763 Paragonimus skrjabini miyazakii 59628 ATG|GTGAGTGCAT...ACTACCTAAATC/AACTACCTAAAT...CATAG|ACG 1 1 83.852
145335678 GT-AG 0 1.000000099473604e-05 1722 rna-gnl|WGS:JTDE|EG68_00056 26266747 23 307921 309642 Paragonimus skrjabini miyazakii 59628 ACA|GTAAGTGTTT...GGAACATTAAGT/GTTACACTCACG...TTCAG|ACG 2 1 87.106
145335679 GT-AG 0 1.000000099473604e-05 216 rna-gnl|WGS:JTDE|EG68_00056 26266747 24 309711 309926 Paragonimus skrjabini miyazakii 59628 AAG|GTCAGTATTA...TCGATCTTCATC/TCGATCTTCATC...GCTAG|GTT 1 1 88.516
145335680 GT-AG 0 1.000000099473604e-05 34379 rna-gnl|WGS:JTDE|EG68_00056 26266747 25 310025 344403 Paragonimus skrjabini miyazakii 59628 AAG|GTGAGCAGTC...ACGATGTTGATA/CCTCGTTTCACA...TCCAG|GGA 0 1 90.547
145335681 GT-AG 0 1.000000099473604e-05 3380 rna-gnl|WGS:JTDE|EG68_00056 26266747 26 344720 348099 Paragonimus skrjabini miyazakii 59628 GAA|GTGAGTCAAG...TTTTTTCTATTT/TTTTTTTCTATT...TGTAG|CGC 1 1 97.098
145335697 GT-AG 0 4.0315196935815735e-05 225 rna-gnl|WGS:JTDE|EG68_00056 26266747 1 258623 258847 Paragonimus skrjabini miyazakii 59628 GTG|GTAAGTTGTA...GATTTTTTATTC/AGATTTTTTATT...TTTAG|TTT   0 3.109

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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]);
Powered by Datasette · Queries took 62.47ms · Data license: ODbL · Data source: Larue & Roy, 2023 · About: Minor Intron Database (WtMTA)