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)

25 rows where transcript_id = 2279584

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
12239564 GT-AG 0 1.000000099473604e-05 75 rna-XM_027995819.1 2279584 1 1797302 1797376 Aphis gossypii 80765 CAT|GTGAGTGGTG...TAGATCTTATTT/TTAGATCTTATT...TATAG|GAT 0 1 2.64
12239565 GT-AG 0 1.000000099473604e-05 1986 rna-XM_027995819.1 2279584 2 1797532 1799517 Aphis gossypii 80765 TGT|GTTAGTAAAA...TAAGTTTTAATT/TTTAATTTTATT...TTCAG|AAT 2 1 6.651
12239566 GT-AG 0 1.4526388670456318e-05 79 rna-XM_027995819.1 2279584 3 1799651 1799729 Aphis gossypii 80765 AAA|GTAAATAAGA...TTTATTTTGATT/TTTATTTTGATT...TTTAG|GAA 0 1 10.093
12239567 GT-AG 0 0.0001134336218694 62 rna-XM_027995819.1 2279584 4 1799838 1799899 Aphis gossypii 80765 ATT|GTAAGTATTC...CTTATATTAATT/CTTATATTAATT...TTCAG|AAA 0 1 12.888
12239568 GT-AG 0 1.000000099473604e-05 143 rna-XM_027995819.1 2279584 5 1800102 1800244 Aphis gossypii 80765 ATG|GTAATATAAA...ATACTTTTATCC/TATACTTTTATC...TTTAG|GTG 1 1 18.116
12239569 GT-AG 0 0.0297773604327166 69 rna-XM_027995819.1 2279584 6 1800467 1800535 Aphis gossypii 80765 AGC|GTATGATCTA...TAATTCTTAAAT/CTTAAATTTATT...TTTAG|CTA 1 1 23.861
12239570 GT-AG 0 1.000000099473604e-05 125 rna-XM_027995819.1 2279584 7 1800692 1800816 Aphis gossypii 80765 AAT|GTGAGTGTAT...GATATTTTAAAA/ATTATATTGATA...TATAG|ATC 1 1 27.899
12239571 GT-AG 0 0.0003887868707347 68 rna-XM_027995819.1 2279584 8 1800909 1800976 Aphis gossypii 80765 AAA|GTAAATTTAT...TGCATTTTAAAT/TATATACTCAGT...ATTAG|ATT 0 1 30.28
12239572 GT-AG 0 5.806825731532694e-05 517 rna-XM_027995819.1 2279584 9 1801141 1801657 Aphis gossypii 80765 AAA|GTAAATATAC...ATAGTTTTATCT/TATAGTTTTATC...TTTAG|ACC 2 1 34.524
12239573 GT-AG 0 0.0007113723350316 525 rna-XM_027995819.1 2279584 10 1801791 1802315 Aphis gossypii 80765 AAG|GTATTATTTT...CTAGTTTTATAA/ATTGTAATTATT...TTTAG|GGA 0 1 37.966
12239574 GT-AG 0 1.000000099473604e-05 257 rna-XM_027995819.1 2279584 11 1802440 1802696 Aphis gossypii 80765 TTG|GTCAGTATAC...AATGTTTTAATT/ATTTTACTCATA...TTTAG|AAA 1 1 41.175
12239575 GT-AG 0 1.000000099473604e-05 82 rna-XM_027995819.1 2279584 12 1802796 1802877 Aphis gossypii 80765 AAG|GTTGTAATAA...TTTATATTATCT/ATAATGTTTATA...TATAG|GCT 1 1 43.737
12239576 GT-AG 0 1.000000099473604e-05 157 rna-XM_027995819.1 2279584 13 1803069 1803225 Aphis gossypii 80765 ATA|GTAAGTACAT...AAACTTTTATAA/TTGTAATTAATT...ATTAG|GAA 0 1 48.68
12239577 GT-AG 0 1.000000099473604e-05 71 rna-XM_027995819.1 2279584 14 1803390 1803460 Aphis gossypii 80765 AAA|GTAAGAATAT...TATTTTGTAATT/TATTTTGTAATT...TTTAG|TTT 2 1 52.924
12239578 GT-AG 0 1.000000099473604e-05 77 rna-XM_027995819.1 2279584 15 1803664 1803740 Aphis gossypii 80765 ATG|GTAAATACAC...TTCATTTTAATA/AAAATACTAACT...ATTAG|CTA 1 1 58.178
12239579 GT-AG 0 0.0035803443877094 398 rna-XM_027995819.1 2279584 16 1804144 1804541 Aphis gossypii 80765 AAA|GTATGTACCA...TGTTTTTTACTT/ATGTTTTTTACT...TTCAG|ATG 2 1 68.608
12239580 GT-AG 0 0.0005136507186473 65 rna-XM_027995819.1 2279584 17 1804612 1804676 Aphis gossypii 80765 ACT|GTAAGTTATT...AAATTTTTATTG/AAAATTTTTATT...ACTAG|CCA 0 1 70.419
12239581 GT-AG 0 5.198328800719402e-05 243 rna-XM_027995819.1 2279584 18 1804758 1805000 Aphis gossypii 80765 GAA|GTAAATATTT...TAATCTTTTATG/ATTATTTTTATG...TTTAG|GAA 0 1 72.516
12239582 GT-AG 0 0.0003717823817656 61 rna-XM_027995819.1 2279584 19 1805160 1805220 Aphis gossypii 80765 ATT|GTAAGCTAAT...CTTTACTTGATA/CTTTACTTGATA...TTTAG|GAT 0 1 76.63
12239583 GT-AG 0 0.0003217216107302 60 rna-XM_027995819.1 2279584 20 1805262 1805321 Aphis gossypii 80765 GAG|GTTTGTCTTT...AATTTTTTAACT/AATTTTTTAACT...TTTAG|AAC 2 1 77.692
12239584 GT-AG 0 1.000000099473604e-05 1735 rna-XM_027995819.1 2279584 21 1805417 1807151 Aphis gossypii 80765 CAA|GTTAGTGCTT...TTTTCTGTAACA/TTATATTTGATT...TTTAG|GAA 1 1 80.15
12239585 GT-AG 0 1.6029294230048842e-05 59 rna-XM_027995819.1 2279584 22 1807244 1807302 Aphis gossypii 80765 AGA|GTAAGTTAAA...TATGTCTTTGTA/ATATGTTTCATA...TTCAG|CTA 0 1 82.531
12239586 GT-AG 0 3.823306641992346e-05 79 rna-XM_027995819.1 2279584 23 1807360 1807438 Aphis gossypii 80765 AGT|GTAAATACAT...TTTATTTTAGTC/AATTTATTTATT...AATAG|GAC 0 1 84.006
12239587 GT-AG 0 1.258239896272335e-05 85 rna-XM_027995819.1 2279584 24 1807640 1807724 Aphis gossypii 80765 CCA|GTAAGTACAA...TGTGTTTTAATT/TGTGTTTTAATT...TGTAG|GAA 0 1 89.208
12239588 GT-AG 0 2.367522533427955e-05 64 rna-XM_027995819.1 2279584 25 1807934 1807997 Aphis gossypii 80765 AAA|GTAAGTATAA...TTTGTTTTATTA/TTTTGTTTTATT...TTCAG|AGA 2 1 94.617

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