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)

19 rows where transcript_id = 2279574

✎ 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
12239397 GT-AG 0 1.000000099473604e-05 72 rna-XM_027989115.1 2279574 2 2754278 2754349 Aphis gossypii 80765 ATG|GTAATATTAT...GATTTTTTAAAA/TATTGCTTTATT...TTTAG|TGG 0 1 2.97
12239398 GT-AG 0 5.900013065228525e-05 1477 rna-XM_027989115.1 2279574 3 2758817 2760293 Aphis gossypii 80765 ATG|GTAAATATAT...TTTTTCTTATTA/ATTTTTCTTATT...TTTAG|CTT 0 1 60.9
12239399 GT-AG 0 1.000000099473604e-05 78 rna-XM_027989115.1 2279574 4 2760414 2760491 Aphis gossypii 80765 AAG|GTAAATTATT...TATTTGTTAAAA/ATTATATTTAAA...TATAG|AAC 0 1 62.456
12239400 GT-AG 0 0.0001140679870297 13661 rna-XM_027989115.1 2279574 5 2760997 2774657 Aphis gossypii 80765 AAG|GTAAATTTAT...ATTATTTTAACT/ATTATTTTAACT...AGCAG|TAA 1 1 69.005
12239401 GT-AG 0 1.000000099473604e-05 116 rna-XM_027989115.1 2279574 6 2774823 2774938 Aphis gossypii 80765 GCG|GTGAGTACAG...CTTGTCTTTTCT/GTTGTTGTTATT...TCCAG|AGA 1 1 71.145
12239402 GT-AG 0 0.0004131693363118 921 rna-XM_027989115.1 2279574 7 2775275 2776195 Aphis gossypii 80765 CTA|GTAAGTTTAT...TATTTTTTATTT/TTATTTTTTATT...TTCAG|AAG 1 1 75.503
12239403 GT-AG 0 0.0178296791300135 67 rna-XM_027989115.1 2279574 8 2776382 2776448 Aphis gossypii 80765 ATG|GTATTTTAAG...TGGTTTTTAATT/TGGTTTTTAATT...TTTAG|AAA 1 1 77.915
12239404 GT-AG 0 1.000000099473604e-05 637 rna-XM_027989115.1 2279574 9 2776554 2777190 Aphis gossypii 80765 AAG|GTTAGTACCT...TAATATTTGACT/TAATATTTGACT...TATAG|GTG 1 1 79.276
12239405 GT-AG 0 3.0467556878650304e-05 655 rna-XM_027989115.1 2279574 10 2777611 2778265 Aphis gossypii 80765 CTG|GTAATTTATT...TAATATTTAATT/TAATATTTAATT...TTCAG|TTT 1 1 84.723
12239406 GT-AG 0 1.000000099473604e-05 118 rna-XM_027989115.1 2279574 11 2778461 2778578 Aphis gossypii 80765 TAG|GTAAATAATG...TAATTTGTAATT/TTTATGCTAATT...TATAG|TTG 1 1 87.252
12239407 GT-AG 0 1.000000099473604e-05 4129 rna-XM_027989115.1 2279574 12 2778752 2782880 Aphis gossypii 80765 CAG|GTACAACAAT...TACTATTTACCA/ATACTATTTACC...TTCAG|AAA 0 1 89.496
12239408 GT-AG 0 1.000000099473604e-05 79 rna-XM_027989115.1 2279574 13 2782959 2783037 Aphis gossypii 80765 TTG|GTTAGTATCA...GTTTATTTAACA/AAATGTTTAATT...TTTAG|TTG 0 1 90.507
12239409 GT-AG 0 0.0018082705289978 1050 rna-XM_027989115.1 2279574 14 2783114 2784163 Aphis gossypii 80765 AAG|GTAACTTAAC...GTTTTCATAACT/GTTGTTTTCATA...TTCAG|CGT 1 1 91.493
12239410 GT-AG 0 1.000000099473604e-05 3428 rna-XM_027989115.1 2279574 15 2784227 2787654 Aphis gossypii 80765 ACG|GTGAGTTATT...TTTTACTTAATT/TTTTTGTTTACT...TTTAG|AAG 1 1 92.31
12239411 GT-AG 0 2.53532390855897e-05 68 rna-XM_027989115.1 2279574 16 2787724 2787791 Aphis gossypii 80765 AAG|GTATGATAAC...ATTATTTTATTG/AATTATTTTATT...TTTAG|TGC 1 1 93.205
12239412 GT-AG 0 1.000000099473604e-05 82 rna-XM_027989115.1 2279574 17 2787834 2787915 Aphis gossypii 80765 AAG|GTAAATTGTT...TAAATTTTGTCA/TTTAAAATTATT...TACAG|CAA 1 1 93.749
12239413 GT-AG 0 1.000000099473604e-05 768 rna-XM_027989115.1 2279574 18 2787983 2788750 Aphis gossypii 80765 AAA|GTAAGTAATT...TCTACAGTAACA/ATAATGGTAACA...TATAG|CTC 2 1 94.618
12239414 GT-AG 0 0.0251154647562814 677 rna-XM_027989115.1 2279574 19 2788863 2789539 Aphis gossypii 80765 AAG|GTATACATTT...CATACATTAATA/TATATTATTATT...TTTAG|AAC 0 1 96.071
12239415 GT-AG 0 6.372879413222475e-05 437 rna-XM_027989115.1 2279574 20 2789692 2790128 Aphis gossypii 80765 TGA|GTAAGTCGTA...TTTTTTTTAAAA/TTTTTTTTTAAA...CTCAG|GGA 2 1 98.042

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