metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA689790" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA689790" and tax_clade = "Apusozoa"

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
27082356	27082356	PRJNA689790_S_NODE_11862_length_173_cov_1.639706_g11747_i0	PRJNA689790	11862	173	1.639706	2.83669138	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	62	2.04e-9	NR	XP_013753833.1	461836	g11747	i0	49.1	2.93063583815029	57	29	98.8	0	2	172	188	244	XP_013753833.1 uncharacterized protein AMSG_09979 [Thecamonas trahens ATCC 50062]	diamond	507	62	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
27346892	27346892	PRJNA689790_S_NODE_14223_length_160_cov_1.894309_g14108_i0	PRJNA689790	14223	160	1.894309	3.0308944	root	1	Root_unresolved	Root_unresolved	89	5.96e-19	NR	XP_013752693.1	461836	g14108	i0	78.8	10.9125	52	11	97.5	0	2	157	415	466	XP_013752693.1 hydroxylamine reductase, partial [Thecamonas trahens ATCC 50062]	diamond	1746	89.4	0.995525727069351	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29198285	29198285	PRJNA689790_S_NODE_1749_length_499_cov_2.805195_g1639_i0	PRJNA689790	1749	499	2.805195	13.99792305	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	58.2	2.45e-6	NR	XP_013757898.1	461836	g1639	i0	30.7	0.841683366733467	140	86	84.2	5	7	426	3067	3195	XP_013757898.1 uncharacterized protein AMSG_05495 [Thecamonas trahens ATCC 50062]	diamond	420	58.2	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29356074	29356074	PRJNA689790_S_NODE_10309_length_185_cov_1.054054_g10194_i0	PRJNA689790	10309	185	1.054054	1.9499999	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	85.1	2.03e-17	NR	XP_013759474.1	461836	g10194	i0	60.7	0.989189189189189	61	24	98.9	0	184	2	1690	1750	XP_013759474.1 ubiquitin carboxyl-terminal hydrolase 34 [Thecamonas trahens ATCC 50062]	diamond	183	85.1	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
31536294	31536294	PRJNA689790_S_NODE_16336_length_152_cov_1.060870_g16221_i0	PRJNA689790	16336	152	1.06087	1.6125224	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	45.1	0.00164	NR	XP_013759182.1	461836	g16221	i0	44	0.986842105263158	50	26	98.7	1	3	152	299	346	XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062]	diamond	150	45.1	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);;