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)

31 rows where transcript_id = 34480483

✎ 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
193750759 GT-AG 0 0.0164552716673808 85 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 1 3157701 3157785 Syncephalastrum racemosum 13706 CAG|GTATATTATT...CGTTCTTTATTT/TCTTTATTTATA...GCTAG|ATC 0 1 6.496
193750760 GT-AG 0 0.0017296664325324 54 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 2 3157972 3158025 Syncephalastrum racemosum 13706 CAG|GTACCTCCAT...AGTTTCCTGACT/AGTTTCCTGACT...GATAG|GAC 0 1 8.48
193750761 GT-AG 0 1.342741660521211e-05 49 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 3 3158099 3158147 Syncephalastrum racemosum 13706 AAG|GTACTGTCAC...GATCCCATAACG/ATAAGTCTGACA...TCAAG|GTG 1 1 9.259
193750762 GT-AG 0 1.000000099473604e-05 63 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 4 3158317 3158379 Syncephalastrum racemosum 13706 TGG|GTGAGTTTTT...GTCGCCATAAGA/ATAAGATTAATG...TTTAG|CTG 2 1 11.061
193750763 GT-AG 0 7.485262862467122e-05 50 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 5 3158550 3158599 Syncephalastrum racemosum 13706 AAA|GTATGTGCAT...AAAGTCATAAAG/ATAAAGCTTACA...ATTAG|CGA 1 1 12.875
193750764 GT-AG 0 1.000000099473604e-05 51 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 6 3158746 3158796 Syncephalastrum racemosum 13706 AAG|GTAGGGTAGA...TTTTTCTCACAT/ATTTTTCTCACA...GCCAG|ATT 0 1 14.432
193750765 GT-AG 0 1.000000099473604e-05 53 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 7 3159321 3159373 Syncephalastrum racemosum 13706 ATG|GTAAGTCACC...GGATGCTGAATA/CGGATGCTGAAT...ATTAG|TCT 2 1 20.021
193750766 GT-AG 0 0.0002016320674177 55 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 8 3159598 3159652 Syncephalastrum racemosum 13706 TCC|GTAAGTATCA...ATCGCCTAATCT/AATCGCCTAATC...GCTAG|CTT 1 1 22.411
193750767 GT-AG 0 1.000000099473604e-05 50 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 9 3159771 3159820 Syncephalastrum racemosum 13706 AGG|GTAAGAAGGC...TGATTTTTGACT/TGATTTTTGACT...TACAG|ACT 2 1 23.669
193750768 GT-AG 0 1.000000099473604e-05 62 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 10 3159939 3160000 Syncephalastrum racemosum 13706 CGG|GTAAGGCGCT...AACCCCATACTG/CCCATACTGAAT...ATCAG|GCT 0 1 24.928
193750769 GT-AG 0 1.000000099473604e-05 49 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 11 3160230 3160278 Syncephalastrum racemosum 13706 AAG|GTAATTGAAA...TATGGCTTATTC/TTATGGCTTATT...TGCAG|CTT 1 1 27.371
193750770 GT-AG 0 0.0001768662473336 52 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 12 3160466 3160517 Syncephalastrum racemosum 13706 TGA|GTATGTGAAA...CGACTCATAGTT/CACCGACTCATA...TTTAG|GGA 2 1 29.365
193750771 GT-AG 0 1.000000099473604e-05 52 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 13 3160756 3160807 Syncephalastrum racemosum 13706 AAG|GTAAAAAGGC...TGTGTCTTATCC/TTGTGTCTTATC...CATAG|CTA 0 1 31.904
193750772 GT-AG 0 1.000000099473604e-05 48 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 14 3160896 3160943 Syncephalastrum racemosum 13706 TGA|GTAAGTAATC...ACGTACTGAATA/GACGTACTGAAT...CATAG|TCG 1 1 32.843
193750773 GT-AG 0 1.000000099473604e-05 55 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 15 3161091 3161145 Syncephalastrum racemosum 13706 AAG|GTGAGTCTAT...GCTACCATAAGC/TATCGATTTATA...AATAG|ATA 1 1 34.411
193750774 GT-AG 0 1.000000099473604e-05 49 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 16 3161211 3161259 Syncephalastrum racemosum 13706 ACA|GTAAGTAGAA...GTCTCCGTAGAC/CATAATGTCAAC...CAAAG|GGT 0 1 35.104
193750775 GT-AG 0 2.2548558175729492e-05 47 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 17 3161353 3161399 Syncephalastrum racemosum 13706 CAG|GTATGGTCAT...TTTTGCTAAACC/GTTTTGCTAAAC...GGAAG|GCT 0 1 36.096
193750776 GT-AG 0 0.0003690329681851 48 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 18 3162711 3162758 Syncephalastrum racemosum 13706 AAG|GTATTTTCTC...TAAATCATGCTA/ATCATGCTAAGA...TCCAG|TTT 0 1 50.08
193750777 GT-AG 0 0.1726602775411186 65 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 19 3163503 3163567 Syncephalastrum racemosum 13706 AAA|GTATATTTTC...TTAACATTGATA/TTGATACTTACT...TGCAG|ATC 0 1 58.016
193750778 GT-AG 0 1.000000099473604e-05 56 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 20 3164709 3164764 Syncephalastrum racemosum 13706 TGA|GTAAGTCATA...CTTGGGTTGATC/CTTGGGTTGATC...CTTAG|GCG 1 1 70.187
193750779 GT-AG 0 1.000000099473604e-05 52 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 21 3165010 3165061 Syncephalastrum racemosum 13706 ACG|GTAATAATTA...GATATGATAGCT/TGATAGCTGACA...ATTAG|AAA 0 1 72.8
193750780 GT-AG 0 1.000000099473604e-05 49 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 22 3165765 3165813 Syncephalastrum racemosum 13706 CAG|GTACGCCGAA...CAGTATCTAACG/CAGTATCTAACG...TAAAG|ATG 1 1 80.299
193750781 GT-AG 0 0.002318481019028 63 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 23 3166002 3166064 Syncephalastrum racemosum 13706 CTG|GTATATCGAA...AAACTCTTGATT/ACTTGACTTATA...AATAG|AGC 0 1 82.304
193750782 GT-AG 0 0.0032322053702725 45 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 24 3166158 3166202 Syncephalastrum racemosum 13706 AAG|GTATACCATC...ATATTCTAACCG/CATATTCTAACC...TCCAG|AGT 0 1 83.296
193750783 GT-AG 0 9.511528049279156e-05 54 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 25 3166266 3166319 Syncephalastrum racemosum 13706 CAG|GTATATTAAA...TCATCCATCGTT/CAGATGTTCATC...TATAG|CTC 0 1 83.968
193750784 GT-AG 0 2.6906602302743903e-05 66 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 26 3166620 3166685 Syncephalastrum racemosum 13706 ATG|GTAAGTTCTT...TGTCACTTAGTC/AAGGTTGTCACT...TTTAG|ATA 0 1 87.168
193750785 GT-AG 0 0.0005936565606514 64 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 27 3166806 3166869 Syncephalastrum racemosum 13706 CAT|GTAAGCTGGC...TTTTCCTTCTTT/TGTACGCTTATT...TTCAG|TTG 0 1 88.448
193750786 GT-AG 0 1.000000099473604e-05 58 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 28 3167026 3167083 Syncephalastrum racemosum 13706 AAG|GTAAATCAAT...AACTCCTTTGCT/TAATGGCTTACA...TCTAG|TGC 0 1 90.112
193750787 GT-AG 0 1.000000099473604e-05 51 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 29 3167246 3167296 Syncephalastrum racemosum 13706 ATG|GTAAGGTGAT...TGATCTCTAACG/TGATCTCTAACG...TACAG|AGA 0 1 91.84
193750788 GT-AG 0 3.424383159498273e-05 52 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 30 3167582 3167633 Syncephalastrum racemosum 13706 CTG|GTAAGCTCCA...ATTCTCATACAA/GGCATTCTCATA...CCCAG|TTA 0 1 94.88
193750789 GT-AG 0 1.000000099473604e-05 65 rna-gnl|WGS:MCGN|BCR43DRAFT_mRNA450733 34480483 31 3168036 3168100 Syncephalastrum racemosum 13706 CAG|GTAGGGACAA...CTACCTCTGATA/GTTCATCTGATA...TTAAG|GTG 0 1 99.168

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