metadata: contig_metadata: 5 rows where bioproject = "PRJEB75017" and tax

5 rows where bioproject = "PRJEB75017" and tax_kingdom = "Nanobdellati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27476563	27476563	PRJEB75017_P_NODE_15183_length_250_cov_0.881356_g15054_i0	PRJEB75017	15183	250	0.881356	2.20339	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	57	3.79e-7	NR	MEM3857766.1	2953041	g15054	i0	42.2	0.768	64	36	76.8	1	248	57	727	789	MEM3857766.1 DEAD/DEAH box helicase family protein [Candidatus Micrarchaeaceae archaeon]	diamond	192	57	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
29395392	29395392	PRJEB75017_P_NODE_1549_length_694_cov_2.252818_g1426_i0	PRJEB75017	1549	694	2.252818	15.63455692	root	1	Root_unresolved	Root_unresolved	45.1	0.0341	NR	MDP3881813.1	2026764	g1426	i0	69	0.285302593659942	29	7	12.5	1	494	580	93	119	MDP3881813.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	198	45.4	0.993392070484582	Archaea	Nanobdellati	Nanobdellota					Nanobdellota archaeon
29844579	29844579	PRJEB75017_P_NODE_11751_length_272_cov_0.969849_g11622_i0	PRJEB75017	11751	272	0.969849	2.63798928	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	47	0.00164	NR	MBL7055094.1	2026803	g11622	i0	34.4	0.992647058823529	90	57	97.1	2	264	1	69	158	MBL7055094.1 phosphopyruvate hydratase [Candidatus Woesearchaeota archaeon]	diamond	270	47	1	Archaea	Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
32595125	32595125	PRJEB75017_P_NODE_13680_length_253_cov_1.722222_g13551_i0	PRJEB75017	13680	253	1.722222	4.35722166	Candidatus Nanohalobium sp.	3101483	Archaea	Archaea	135	5.79e-36	NR	MFB6174630.1	3101483	g13551	i0	75.6	1.93280632411067	82	20	97.2	0	6	251	1	82	MFB6174630.1 phosphoglycerate kinase [Candidatus Nanohalobium sp.]	diamond	489	135	1	Archaea	Nanobdellati	Candidatus Nanohalarchaeota	Candidatus Nanohalobia	Candidatus Nanohalobiales	Candidatus Nanohalobiaceae	Candidatus Nanohalobium	Candidatus Nanohalobium sp.
32783800	32783800	PRJEB75017_P_NODE_16220_length_247_cov_0.896552_g16091_i0	PRJEB75017	16220	247	0.896552	2.21448344	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	45.4	0.00315	NR	MDD5133717.1	2910166	g16091	i0	62.9	0.425101214574899	35	13	42.5	0	242	138	1	35	MDD5133717.1 hypothetical protein [Candidatus Nanoarchaeia archaeon]	diamond	105	45.4	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia				Candidatus Nanoarchaeia archaeon

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);;