WtMTA: genomes: 2 rows where family = "Cecidomyiidae", minor_snRNAs = "["u11", "u12", "u4atac", "u6atac"]" and minor_snRNAs contains "u4atac" sorted by percent_minor

Data license: ODbL · Data source: Larue & Roy, 2023 · About: Minor Intron Database (WtMTA)

taxonomy_id: INTEGER (primary key), unique identifier for each species
species: TEXT, binomial name of the species
family: TEXT, taxonomic family of the species
order: TEXT, taxonomic order of the species
phylum: TEXT, taxonomic phylum of the species
accession: TEXT, accession number of the genome assembly
n_minor_introns: INTEGER, total number of minor introns in the genome
n_major_introns: INTEGER, total number of major introns in the genome
percent_minor_introns: REAL, percentage of minor introns in the genome
busco_score: REAL, BUSCO score assessing the genome assembly completeness (vs. eukaryota_odb10)
minor_snRNAs: TEXT, minor snRNAs found in the annotated transcriptome
genome_version: TEXT, version of the genome assembly
source_url: TEXT, URL for the source genome/annotation files
source_metadata: TEXT, additional metadata from the original data source
minor_intron+: INTEGER, indicates if the species is inferred to contain real minor introns (1) or not (0)

2 rows where family = "Cecidomyiidae", minor_snRNAs = "["u11", "u12", "u4atac", "u6atac"]" and minor_snRNAs contains "u4atac" sorted by percent_minor_introns descending

Search:

descending

taxonomy_id	species	family	order	phylum	accession	n_minor_introns	n_major_introns	percent_minor_introns ▲	busco_score	minor_snRNAs	genome_version	source_url	source_metadata	minor_intron+
265458	Contarinia nasturtii	Cecidomyiidae	Diptera	Arthropoda	GCF_009176525.2	21	77572	0.0270642970371038	97.3	["u11", "u12", "u4atac", "u6atac"]	AAFC_CNas_1.1	https://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/009/176/525/GCF_009176525.2_AAFC_CNas_1.1	GCF_009176525.2;PRJNA579966;SAMN12743477;VYII00000000.1;representative genome;265458;265458;Contarinia nasturtii;;CC-2019;latest;Scaffold;Minor;Full;2019/10/18;AAFC_CNas_1.1;Agriculture Canada;GCA_009176525.2;different;https://ftp.ncbi.nlm.nih.gov/genomes/all/GCF/009/176/525/GCF_009176525.2_AAFC_CNas_1.1;;;na	1
39758	Mayetiola destructor	Cecidomyiidae	Diptera	Arthropoda	GCA_000149185.1	12	69098	0.0173636232093763	92.9	["u11", "u12", "u4atac", "u6atac"]	Mdes_1.0	ftp://ftp.ensemblgenomes.org/pub/metazoa/release-51/fasta/mayetiola_destructor/dna/Mayetiola_destructor.Mdes_1.0.dna.toplevel.fa.gz; ftp://ftp.ensemblgenomes.org/pub/metazoa/release-51/gtf/mayetiola_destructor/Mayetiola_destructor.Mdes_1.0.51.gtf.gz	Mayetiola destructor;mayetiola_destructor;EnsemblMetazoa;39758;Mdes_1.0;GCA_000149185.1;OGS1.0;N;N;N;Y;N;Y;mayetiola_destructor_core_51_104_1;1	1

Advanced export

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

CREATE TABLE "genomes" (
"taxonomy_id" INTEGER,
  "species" TEXT,
  "family" TEXT,
  "order" TEXT,
  "phylum" TEXT,
  "accession" TEXT,
  "n_minor_introns" INTEGER,
  "n_major_introns" INTEGER,
  "percent_minor_introns" REAL,
  "busco_score" REAL,
  "minor_snRNAs" TEXT,
  "genome_version" TEXT,
  "source_url" TEXT,
  "source_metadata" TEXT,
  "minor_intron+" INTEGER
  ,PRIMARY KEY ([taxonomy_id])
);
CREATE INDEX [idx_genomes_phylum]
    ON [genomes] ([phylum]);
CREATE INDEX [idx_genomes_order]
    ON [genomes] ([order]);
CREATE INDEX [idx_genomes_family]
    ON [genomes] ([family]);