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

5 rows where analysis = "diamond", bioproject = "PRJNA857857" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_genus	tax_species
16147801	16147801	PRJNA857857_P_NODE_35573_length_255_cov_1.269231_g35124_i0	PRJNA857857	35573	255	1.269231	3.23653905	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	120	2.02e-29	NR	MBI4017264.1	3121606	g35124	i0	69.9	1.94117647058824	83	25	97.6	0	252	4	292	374	MBI4017264.1 phosphoenolpyruvate synthase [Candidatus Aenigmatarchaeota archaeon]	diamond	495	120	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota			Candidatus Aenigmatarchaeota archaeon
27758545	27758545	PRJNA857857_P_NODE_40264_length_249_cov_0.875000_g39815_i0	PRJNA857857	40264	249	0.875	2.17875	Nanobdellati	1783276	Archaea	Archaea	45.4	0.004	NR	MEK6800748.1	2026764	g39815	i0	33.3	2.51807228915663	81	49	97.6	3	2	244	127	202	MEK6800748.1 site-specific tyrosine recombinase/integron integrase [Nanoarchaeota archaeon]	diamond	627	45.4	1	Archaea		Nanobdellati	Nanobdellota			Nanobdellota archaeon
29328722	29328722	PRJNA857857_P_NODE_6089_length_630_cov_1.721724_g5669_i0	PRJNA857857	6089	630	1.721724	10.8468612	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	97.8	3.09e-20	NR	MBI3334539.1	2026773	g5669	i0	32.1	2.0047619047619	209	126	99	6	626	3	38	231	MBI3334539.1 FAD-dependent oxidoreductase [Candidatus Pacearchaeota archaeon]	diamond	1263	97.8	1	Archaea	Candidatus Pacearchaeota	Nanobdellati				Candidatus Pacearchaeota archaeon
30403083	30403083	PRJNA857857_P_NODE_45633_length_245_cov_0.895349_g45184_i0	PRJNA857857	45633	245	0.895349	2.19360505	Candidatus Micrarchaeia archaeon	3018267	Archaea	Archaea	53.1	8.39e-6	NR	MFQ5405549.1	3018267	g45184	i0	53.5	0.52653061224489806	43	19	51.4	1	17	142	1153	1195	MFQ5405549.1 hypothetical protein [Candidatus Micrarchaeia archaeon]	diamond	129	53.1	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia		Candidatus Micrarchaeia archaeon
32204836	32204836	PRJNA857857_P_NODE_29098_length_286_cov_2.525822_g28649_i0	PRJNA857857	29098	286	2.525822	7.22385092	Candidatus ainarchaeum sp.	N/A	Archaea	Archaea	70.5	1.1e-11	NR	MDD3159634.1	3018264	g28649	i0	42.1	0.797202797202797	76	39	79.7	2	285	58	380	450	MDD3159634.1 VWA domain-containing protein [Candidatus ainarchaeum sp.]	diamond	228	70.5	1	Archaea		Nanobdellati	Candidatus Iainarchaeota		Candidatus Iainarchaeum	Candidatus ainarchaeum sp.

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