metadata: contig_metadata: 4 rows where bioproject = "PRJNA376117", tax_clade = "Apusozoa" and tax

4 rows where bioproject = "PRJNA376117", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_order	tax_family	tax_genus	tax_species
10603664	10603664	PRJNA376117_P_NODE_31689_length_258_cov_2.232432_g31387_i0	PRJNA376117	31689	258	2.232432	5.75967456	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	121	2.24e-32	NR	XP_013757026.1	461836	g31387	i0	75.3	10.1046511627907	77	19	89.5	0	23	253	2	78	XP_013757026.1 60S ribosomal protein L13a [Thecamonas trahens ATCC 50062]	diamond	2607	121	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29523532	29523532	PRJNA376117_P_NODE_35230_length_250_cov_0.870056_g34928_i0	PRJNA376117	35230	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	102	4.55e-25	NR	XP_013758337.1	461836	g34928	i0	63.4	5.844	82	22	93.6	2	234	1	13	90	XP_013758337.1 PfpI family Intracellular protease [Thecamonas trahens ATCC 50062]	diamond	1461	102	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
31592052	31592052	PRJNA376117_P_NODE_29276_length_267_cov_3.458763_g28974_i0	PRJNA376117	29276	267	3.458763	9.23489721	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	71.6	3.26e-12	NR	XP_013759207.1	461836	g28974	i0	46.6	0.98876404494382	88	41	98.9	2	265	2	380	461	XP_013759207.1 glucoamylase [Thecamonas trahens ATCC 50062]	diamond	264	71.6	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
31623455	31623455	PRJNA376117_P_NODE_10756_length_410_cov_2.545994_g10454_i0	PRJNA376117	10756	410	2.545994	10.4385754	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	48.5	0.00171	NR	XP_013759479.1	461836	g10454	i0	54	0.460975609756098	63	26	44.6	3	373	191	1	62	XP_013759479.1 uncharacterized protein AMSG_02572 [Thecamonas trahens ATCC 50062]	diamond	189	48.5	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;