metadata: contig_metadata: 5 rows where bioproject = "PRJNA681822", tax_clade = "Apusozoa" and tax

5 rows where bioproject = "PRJNA681822", 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
28818576	28818576	PRJNA681822_P_NODE_404568_length_249_cov_0.875000_g403079_i0	PRJNA681822	404568	249	0.875	2.17875	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	46.6	0.00178	NR	XP_013752670.1	461836	g403079	i0	39.2	1.50602409638554	51	30	60.2	1	25	174	367	417	XP_013752670.1 uncharacterized protein AMSG_11453 [Thecamonas trahens ATCC 50062]	diamond	375	46.6	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29387381	29387381	PRJNA681822_P_NODE_411029_length_248_cov_1.457143_g409540_i0	PRJNA681822	411029	248	1.457143	3.61371464	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	123	1.33e-34	NR	XP_013760812.1	461836	g409540	i0	70.7	2.95161290322581	82	24	99.2	0	247	2	12	93	XP_013760812.1 60S ribosomal protein L37-A [Thecamonas trahens ATCC 50062]	diamond	732	123	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
29387393	29387393	PRJNA681822_P_NODE_54909_length_503_cov_3.353488_g53443_i0	PRJNA681822	54909	503	3.353488	16.86804464	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	99	6.16e-23	NR	XP_013758370.1	461836	g53443	i0	37.3	0.799204771371769	134	78	79.3	2	451	53	20	148	XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062]	diamond	402	99	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
31946755	31946755	PRJNA681822_P_NODE_123777_length_364_cov_1.587629_g122290_i0	PRJNA681822	123777	364	1.587629	5.77896956	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	129	1.7900000000000002e-33	NR	XP_013760891.1	461836	g122290	i0	50	1.00549450549451	122	60	99.7	1	363	1	78	199	XP_013760891.1 inosine-uridine preferring nucleoside hydrolase superfamily protein [Thecamonas trahens ATCC 50062]	diamond	366	129	1	Eukaryota	Apusozoa	Apusomonadida	Apusomonadidae	Thecamonas	Thecamonas trahens
32831644	32831644	PRJNA681822_P_NODE_476420_length_241_cov_1.833333_g474930_i0	PRJNA681822	476420	241	1.833333	4.41833253	Thecamonas trahens ATCC 5	529818	Root_unresolved	Root_unresolved	64.7	6.67e-10	NR	XP_013756064.1	461836	g474930	i0	51.4	1.81742738589212	72	34	89.6	1	23	238	569	639	XP_013756064.1 dynamin-A [Thecamonas trahens ATCC 50062]	diamond	438	64.7	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);;