metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Nanobdellota"

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_species
26640215	26640215	PRJNA704949_P_NODE_58541_length_1000_cov_1.896951_g47510_i0	PRJNA704949	58541	1000	1.896951	18.96951	Nanobdellota archaeon	2026764	Archaea	Archaea	127	1.13e-32	NR	MEK6884537.1	2026764	g47510	i0	59.2	0.309	103	42	30.9	0	310	618	6	108	MEK6884537.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	309	127	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
26924745	26924745	PRJNA704949_P_NODE_1048642_length_253_cov_1.058824_g1033306_i0	PRJNA704949	1048642	253	1.058824	2.67882472	Nanobdellota archaeon	2026764	Archaea	Archaea	67.8	6.58e-11	NR	MCK4670720.1	2026764	g1033306	i0	54.4	1.06719367588933	90	31	99.6	3	252	1	198	283	MCK4670720.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	270	67.8	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
28251826	28251826	PRJNA704949_P_NODE_632086_length_341_cov_1.167808_g616761_i0	PRJNA704949	632086	341	1.167808	3.98222528	Nanobdellota archaeon	2026764	Archaea	Archaea	58.9	2.09e-7	NR	MEK6828564.1	2026764	g616761	i0	43.9	0.580645161290323	66	37	58.1	0	136	333	79	144	MEK6828564.1 DUF4419 domain-containing protein [Nanoarchaeota archaeon]	diamond	198	58.9	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
28598974	28598974	PRJNA704949_P_NODE_1284987_length_222_cov_1.884393_g1269650_i0	PRJNA704949	1284987	222	1.884393	4.18335246	Nanobdellota archaeon	2026764	Archaea	Archaea	50.4	5.22e-5	NR	MAF99396.1	2026764	g1269650	i0	71.4	0.378378378378378	28	8	37.8	0	221	138	222	249	MAF99396.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	84	50.4	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
29777962	29777962	PRJNA704949_P_NODE_1002531_length_260_cov_1.232227_g987196_i0	PRJNA704949	1002531	260	1.232227	3.2037902	root	1	Root_unresolved	Root_unresolved	43.5	0.0232	NR	MDD4878630.1	2910166	g987196	i0	40.3	1.40769230769231	67	29	64.6	1	191	24	85	151	MDD4878630.1 hypothetical protein [Candidatus Nanoarchaeia archaeon]	diamond	366	43.5	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Nanoarchaeia archaeon
30051660	30051660	PRJNA704949_P_NODE_720431_length_317_cov_0.970149_g705102_i0	PRJNA704949	720431	317	0.970149	3.07537233	Nanobdellota archaeon	2026764	Archaea	Archaea	81.6	2.21e-17	NR	MFH1290086.1	2026764	g705102	i0	43	0.946372239747634	100	55	94.6	1	300	1	1	98	MFH1290086.1 7-cyano-7-deazaguanine synthase [Nanoarchaeota archaeon]	diamond	300	81.6	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
30146235	30146235	PRJNA704949_P_NODE_4672_length_7054_cov_7.491792_g1390_i0	PRJNA704949	4672	7054	7.491792	528.47100768	Nanobdellota archaeon	2026764	Archaea	Archaea	105	1.2600000000000002e-21	NR	MEK6878075.1	2026764	g1390	i0	38.4	0.0676212078253473	159	88	6.5	4	5878	6339	12	165	MEK6878075.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	477	105	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
30368166	30368166	PRJNA704949_P_NODE_612872_length_346_cov_2.562290_g597548_i0	PRJNA704949	612872	346	2.56229	8.8655234	Nanobdellota archaeon	2026764	Archaea	Archaea	67.8	1.87e-10	NR	MFC1685545.1	2026764	g597548	i0	39.8	1.53468208092486	88	48	75.4	3	86	346	222	305	MFC1685545.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	531	67.8	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
31283537	31283537	PRJNA704949_P_NODE_1209555_length_231_cov_1.390110_g1194218_i0	PRJNA704949	1209555	231	1.39011	3.2111541	Nanobdellota archaeon	2026764	Archaea	Archaea	47.4	3.76e-4	NR	MBU1028530.1	2026764	g1194218	i0	41	1.01298701298701	78	43	97.4	1	227	3	15	92	MBU1028530.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	234	47.4	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
31505494	31505494	PRJNA704949_P_NODE_1989476_length_167_cov_1.322034_g1974137_i0	PRJNA704949	1989476	167	1.322034	2.20779678	Nanobdellota archaeon	2026764	Archaea	Archaea	84	2.71e-19	NR	MDP3881948.1	2026764	g1974137	i0	66.7	1.95808383233533	54	18	97	0	6	167	4	57	MDP3881948.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	327	84	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
31548004	31548004	PRJNA704949_P_NODE_347116_length_459_cov_2.612195_g332144_i0	PRJNA704949	347116	459	2.612195	11.98997505	root	1	Root_unresolved	Root_unresolved	129	1.88e-34	NR	MEK6883171.1	2026764	g332144	i0	56.1	2.07843137254902	107	47	69.9	0	348	28	1	107	MEK6883171.1 SMC family ATPase [Nanoarchaeota archaeon]	diamond	954	129	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota 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);;