metadata: contig_metadata: 5 rows where bioproject = "PRJNA1196438", tax_kingdom = "Nanobdellati" and tax

5 rows where bioproject = "PRJNA1196438", tax_kingdom = "Nanobdellati" and tax_superkingdom = "Archaea"

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_kingdom	tax_phylum	tax_family	tax_genus	tax_species
27293747	27293747	PRJNA1196438_P_NODE_7983_length_367_cov_1.877551_g7561_i0	PRJNA1196438	7983	367	1.877551	6.89061217	Nanobdellota archaeon	2026764	Archaea	Archaea	55.5	5.24e-6	NR	MBU0906607.1	2026764	g7561	i0	70.7	0.670299727520436	41	11	33.5	1	123	1	1	40	MBU0906607.1 AAA family ATPase [Nanoarchaeota archaeon]	diamond	246	55.5	1	Archaea		Nanobdellati	Nanobdellota			Nanobdellota archaeon
28840842	28840842	PRJNA1196438_P_NODE_19988_length_312_cov_3.025105_g19562_i0	PRJNA1196438	19988	312	3.025105	9.4383276	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	47	0.00256	NR	MBS3056119.1	3121606	g19562	i0	44.9	0.942307692307692	49	26	47.1	1	149	3	29	76	MBS3056119.1 B12-binding domain-containing radical SAM protein [Candidatus Aenigmatarchaeota archaeon]	diamond	294	47	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota			Candidatus Aenigmatarchaeota archaeon
30040885	30040885	PRJNA1196438_P_NODE_56291_length_263_cov_4.473684_g55864_i0	PRJNA1196438	56291	263	4.473684	11.76578892	Candidatus Afararchaeum irisae	3138747	Archaea	Archaea	64.7	8.67e-10	NR	MDY6775964.1	3138747	g55864	i0	57.4	1.39163498098859	61	24	69.6	2	263	81	500	558	MDY6775964.1 ATP-dependent helicase [Candidatus Afararchaeum irisae]	diamond	366	64.7	1	Archaea		Nanobdellati		Candidatus Afararchaeaceae	Candidatus Afararchaeum	Candidatus Afararchaeum irisae
30735911	30735911	PRJNA1196438_P_NODE_61494_length_256_cov_1.699454_g61067_i0	PRJNA1196438	61494	256	1.699454	4.35060224	Candidatus Diapherotrites archaeon CG11_big_fil_rev_8_21_14_	1974407	Archaea	Archaea	101	3.2899999999999996e-23	NR	PIN85158.1	1974407	g61067	i0	73	0.73828125	63	17	73.8	0	68	256	3	65	PIN85158.1 MAG: hypothetical protein COV47_03640 [Candidatus Diapherotrites archaeon CG11_big_fil_rev_8_21_14_0_20_37_9]	diamond	189	101	1	Archaea		Nanobdellati	Candidatus Iainarchaeota			Candidatus Diapherotrites archaeon CG11_big_fil_rev_8_21_14_0_20_37_9
32715030	32715030	PRJNA1196438_P_NODE_3080_length_552_cov_3.340292_g2676_i0	PRJNA1196438	3080	552	3.340292	18.43841184	root	1	Root_unresolved	Root_unresolved	55.1	2.01e-5	NR	MBI2449263.1	2026773	g2676	i0	47.6	1.88586956521739	63	29	34.2	1	73	261	1	59	MBI2449263.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	1041	55.5	0.992792792792793	Archaea	Candidatus Pacearchaeota	Nanobdellati				Candidatus Pacearchaeota 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);;