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

5 rows where bioproject = "PRJNA812715", 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_species
27086022	27086022	PRJNA812715_P_NODE_79962_length_284_cov_2.085308_g78162_i0	PRJNA812715	79962	284	2.085308	5.92227472	Candidatus Pacearchaeota archaeon CG1_	2026773	Archaea	Archaea	48.1	1.33e-4	NR	OIO41066.1	1805294	g78162	i0	36.8	1.27816901408451	68	40	70.8	3	260	60	34	99	OIO41066.1 MAG: hypothetical protein AUJ10_01465 [Candidatus Pacearchaeota archaeon CG1_02_31_27]	diamond	363	48.1	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota archaeon CG1_02_31_27
27180481	27180481	PRJNA812715_P_NODE_119102_length_242_cov_0.911243_g117301_i0	PRJNA812715	119102	242	0.911243	2.20520806	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	42	0.0231	NR	MCD6495635.1	3121606	g117301	i0	37.5	0.793388429752066	64	37	79.3	1	20	211	20	80	MCD6495635.1 C4-dicarboxylate ABC transporter [Candidatus Aenigmatarchaeota archaeon]	diamond	192	42	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
27559699	27559699	PRJNA812715_P_NODE_72864_length_299_cov_1.000000_g71064_i0	PRJNA812715	72864	299	1	2.99	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	148	1.9e-39	NR	MDA3855007.1	2026803	g71064	i0	72.7	0.993311036789298	99	27	99.3	0	299	3	347	445	MDA3855007.1 adenylosuccinate synthetase [Candidatus Woesearchaeota archaeon]	diamond	297	148	1	Archaea		Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
31919297	31919297	PRJNA812715_P_NODE_93817_length_262_cov_2.391534_g92016_i0	PRJNA812715	93817	262	2.391534	6.26581908	Nanobdellota archaeon	2026764	Archaea	Archaea	69.3	5.65e-13	NR	MEK6928336.1	2026764	g92016	i0	45.2	0.83587786259542	73	37	81.3	2	49	261	4	75	MEK6928336.1 thioredoxin [Nanoarchaeota archaeon]	diamond	219	69.3	1	Archaea		Nanobdellati	Nanobdellota	Nanobdellota archaeon
32709471	32709471	PRJNA812715_P_NODE_75360_length_292_cov_1.917808_g73560_i0	PRJNA812715	75360	292	1.917808	5.59999936	Candidatus Pacearchaeota archaeon CG1_	2026773	Archaea	Archaea	48.9	7.15e-5	NR	OIO41066.1	1805294	g73560	i0	36.8	1.78767123287671	68	40	68.8	3	254	54	34	99	OIO41066.1 MAG: hypothetical protein AUJ10_01465 [Candidatus Pacearchaeota archaeon CG1_02_31_27]	diamond	522	48.9	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota archaeon CG1_02_31_27

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