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)

33 rows where transcript_id = 26266730

✎ View and edit SQL

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
145335532 GT-AG 0 1.000000099473604e-05 39 rna-gnl|WGS:JTDE|EG68_00146 26266730 1 347466 347504 Paragonimus skrjabini miyazakii 59628 AAT|GTGAGCCGCT...CCGTTTTTGAGT/CCGTTTTTGAGT...TTCAG|ATA 2 1 0.264
145335533 GT-AG 0 1.000000099473604e-05 5491 rna-gnl|WGS:JTDE|EG68_00146 26266730 2 341804 347294 Paragonimus skrjabini miyazakii 59628 GAG|GTAAATCAAT...TGCGCCTAACCA/TTGTATCTCATT...CTCAG|CAT 2 1 2.525
145335534 GT-AG 0 1.3437692843390995e-05 2137 rna-gnl|WGS:JTDE|EG68_00146 26266730 3 339062 341198 Paragonimus skrjabini miyazakii 59628 TCG|GTAAGTTGTG...TCAATTTTAAAC/AATTTTGTTATT...TACAG|GGG 1 1 10.525
145335535 GT-AG 0 2.5092375889513027e-05 342 rna-gnl|WGS:JTDE|EG68_00146 26266730 4 338433 338774 Paragonimus skrjabini miyazakii 59628 AAA|GTAAGCAACA...TTTCTCGTAATA/TAGATACTTACT...CGCAG|GTG 0 1 14.32
145335536 GT-AG 0 1.000000099473604e-05 670 rna-gnl|WGS:JTDE|EG68_00146 26266730 5 337630 338299 Paragonimus skrjabini miyazakii 59628 AAA|GTGAGTTTGT...TTTTTTTTGTTT/TTGTTTCTCACA...TCCAG|AGG 1 1 16.078
145335537 GT-AG 0 1.000000099473604e-05 3751 rna-gnl|WGS:JTDE|EG68_00146 26266730 6 333499 337249 Paragonimus skrjabini miyazakii 59628 AAG|GTTAGAAAAC...AATATCTTAATT/AATATCTTAATT...AACAG|GTT 0 1 21.103
145335538 GT-AG 0 0.0006732466987661 2078 rna-gnl|WGS:JTDE|EG68_00146 26266730 7 331285 333362 Paragonimus skrjabini miyazakii 59628 CGC|GTAAGTTGCA...TTTCTTTTAACG/TAAATGCTCATT...TAAAG|AAA 1 1 22.901
145335539 GT-AG 0 0.0001166920598821 1848 rna-gnl|WGS:JTDE|EG68_00146 26266730 8 329138 330985 Paragonimus skrjabini miyazakii 59628 AAA|GTAGGTTATT...AACTTCTTGCTT/AACTATATTATT...TTCAG|ATC 0 1 26.854
145335540 GT-AG 0 1.000000099473604e-05 1554 rna-gnl|WGS:JTDE|EG68_00146 26266730 9 327448 329001 Paragonimus skrjabini miyazakii 59628 AAG|GTAAGTCATA...GATTACTTAACT/ACTTAACTAACT...TTCAG|TCT 1 1 28.653
145335541 GT-AG 0 5.428283964633262e-05 9426 rna-gnl|WGS:JTDE|EG68_00146 26266730 10 317867 327292 Paragonimus skrjabini miyazakii 59628 CAG|GTAGGTTTTC...TATTCCGTATAA/TCATTACTAAAA...CCCAG|ATG 0 1 30.702
145335542 GT-AG 0 1.000000099473604e-05 2306 rna-gnl|WGS:JTDE|EG68_00146 26266730 11 315403 317708 Paragonimus skrjabini miyazakii 59628 TCG|GTAAGTTCAA...TTGCTCATAAAA/TTGTTGCTCATA...TCCAG|CTG 2 1 32.791
145335543 GT-AG 0 1.000000099473604e-05 1757 rna-gnl|WGS:JTDE|EG68_00146 26266730 12 313578 315334 Paragonimus skrjabini miyazakii 59628 AAG|GTAAGCACTT...TTCCGTTTAATT/TACATTTTCATA...TCTAG|ATT 1 1 33.69
145335544 GT-AG 0 1.000000099473604e-05 1560 rna-gnl|WGS:JTDE|EG68_00146 26266730 13 311824 313383 Paragonimus skrjabini miyazakii 59628 GAG|GTTAGTTGCC...TTTGCCTTTTCT/TCTGTTTTCAAC...ATTAG|CTC 0 1 36.255
145335545 GT-AG 0 7.48151773154093e-05 1245 rna-gnl|WGS:JTDE|EG68_00146 26266730 14 310386 311630 Paragonimus skrjabini miyazakii 59628 AAA|GTAAGTTCAA...TGTCACTTAACT/TTTCTTGTGATT...CTCAG|CCG 1 1 38.807
145335546 GT-AG 0 1.000000099473604e-05 653 rna-gnl|WGS:JTDE|EG68_00146 26266730 15 309566 310218 Paragonimus skrjabini miyazakii 59628 AAA|GTAAGCACAC...TTTGCCGAAACC/ATGTGTGTAAAT...TTCAG|GTA 0 1 41.015
145335547 GT-AG 0 3.628024828978615e-05 604 rna-gnl|WGS:JTDE|EG68_00146 26266730 16 308781 309384 Paragonimus skrjabini miyazakii 59628 CTG|GTATGAATAT...CAATGTTTAATT/CAATGTTTAATT...TTCAG|CCT 1 1 43.409
145335548 GT-AG 0 0.0013297764583903 2202 rna-gnl|WGS:JTDE|EG68_00146 26266730 17 306339 308540 Paragonimus skrjabini miyazakii 59628 TCA|GTAAGTTTTC...TTCATTTTATTT/ATTTTATTTATT...TATAG|AAT 1 1 46.582
145335549 GT-AG 0 1.000000099473604e-05 6662 rna-gnl|WGS:JTDE|EG68_00146 26266730 18 299507 306168 Paragonimus skrjabini miyazakii 59628 GAG|GTCAGTCTCT...ATTTTTTCAATG/GATTTTTTCAAT...CACAG|TTG 0 1 48.83
145335550 GT-AG 0 1.000000099473604e-05 1699 rna-gnl|WGS:JTDE|EG68_00146 26266730 19 297537 299235 Paragonimus skrjabini miyazakii 59628 CCG|GTAAGCAAGC...ATTTGCTAAGTG/ATTGGTCTCATA...TTCAG|ATC 1 1 52.413
145335551 GT-AG 0 1.000000099473604e-05 1467 rna-gnl|WGS:JTDE|EG68_00146 26266730 20 295841 297307 Paragonimus skrjabini miyazakii 59628 CCA|GTGAGTTGCG...ATGGTCTTGTAT/TTCTGTTTCATA...ATCAG|TAT 2 1 55.441
145335552 GT-AG 0 0.003146788690303 2599 rna-gnl|WGS:JTDE|EG68_00146 26266730 21 293057 295655 Paragonimus skrjabini miyazakii 59628 CAA|GTATGACTTA...CTCATTTTAATT/TTGTTTTTCACT...ATCAG|CTA 1 1 57.887
145335553 GT-AG 0 7.862382236333285e-05 2527 rna-gnl|WGS:JTDE|EG68_00146 26266730 22 290234 292760 Paragonimus skrjabini miyazakii 59628 GAG|GTACGCAGAC...CAAATTTTAGTG/GTAAAACTCAAC...TGCAG|ATA 0 1 61.801
145335554 GT-AG 0 0.0001268189130177 3887 rna-gnl|WGS:JTDE|EG68_00146 26266730 23 286041 289927 Paragonimus skrjabini miyazakii 59628 CAC|GTAAGTATCG...GTGCTTTTATCA/GCTTTTATCATC...ACAAG|ACC 0 1 65.847
145335555 GT-AG 0 1.000000099473604e-05 1562 rna-gnl|WGS:JTDE|EG68_00146 26266730 24 284019 285580 Paragonimus skrjabini miyazakii 59628 CAA|GTAAGTGTAA...AGAATGTTACTC/AAGTGACTAATG...CACAG|CGA 1 1 71.929
145335556 GT-AG 0 1.000000099473604e-05 1533 rna-gnl|WGS:JTDE|EG68_00146 26266730 25 282277 283809 Paragonimus skrjabini miyazakii 59628 GAG|GTAATACTTA...CTCTCCGTAACC/CTTTTGCTGAAT...TTCAG|GTC 0 1 74.693
145335557 GT-AG 0 7.255292176270087e-05 486 rna-gnl|WGS:JTDE|EG68_00146 26266730 26 281604 282089 Paragonimus skrjabini miyazakii 59628 AAT|GTAAGTTACC...TTTTTTTTCACG/TTTTTTTTCACG...CTTAG|TGA 1 1 77.165
145335558 GT-AG 0 1.000000099473604e-05 2809 rna-gnl|WGS:JTDE|EG68_00146 26266730 27 278577 281385 Paragonimus skrjabini miyazakii 59628 CAA|GTAAGTTGCC...TCATTCTTTTCA/ATGTGCTTCATT...CACAG|GGT 0 1 80.048
145335559 GT-AG 0 0.0537983952649838 6487 rna-gnl|WGS:JTDE|EG68_00146 26266730 28 271924 278410 Paragonimus skrjabini miyazakii 59628 GAA|GTATGCTATT...ACCACCTAAAAC/TGTGCACTCACG...CACAG|GTG 1 1 82.242
145335560 GT-AG 0 0.0006833929643881 1255 rna-gnl|WGS:JTDE|EG68_00146 26266730 29 270514 271768 Paragonimus skrjabini miyazakii 59628 GCT|GTAAGTTGCT...TTGTCATTAACA/TAGTTATTAATT...GACAG|GTA 0 1 84.292
145335561 GT-AG 0 0.0001581338242513 2334 rna-gnl|WGS:JTDE|EG68_00146 26266730 30 267825 270158 Paragonimus skrjabini miyazakii 59628 TTG|GTAAGTTTGC...TGAACTTTATTT/TTGAACTTTATT...ATAAG|CCT 1 1 88.986
145335562 GT-AG 0 0.1701757661946858 3271 rna-gnl|WGS:JTDE|EG68_00146 26266730 31 264394 267664 Paragonimus skrjabini miyazakii 59628 CAA|GTATGCTTCA...AGGTTCCTACCA/GCTAAGTTTACA...ACTAG|GCT 2 1 91.101
145335563 GT-AG 0 1.000000099473604e-05 1979 rna-gnl|WGS:JTDE|EG68_00146 26266730 32 262125 264103 Paragonimus skrjabini miyazakii 59628 GAG|GTAAGCCATT...TTGATCTTGCCA/CCTCGGTTGATC...GTCAG|AAA 1 1 94.936
145335564 GT-AG 0 1.000000099473604e-05 3105 rna-gnl|WGS:JTDE|EG68_00146 26266730 33 258822 261926 Paragonimus skrjabini miyazakii 59628 TTG|GTAAGATCAG...TTTCTCTTCTCT/TGTTTATTCATC...GATAG|GTA 1 1 97.554

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 23.783ms · Data license: ODbL · Data source: Larue & Roy, 2023 · About: Minor Intron Database (WtMTA)