metadata: contig_metadata: 8 rows where bioproject = "PRJNA315399", tax_phylum = "Nanobdellota" and tax

8 rows where bioproject = "PRJNA315399", tax_phylum = "Nanobdellota" 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_kingdom	tax_phylum	tax_class	tax_species
26821424	26821424	PRJNA315399_P_NODE_507541_length_150_cov_6.212389_g507093_i0	PRJNA315399	507541	150	6.212389	9.3185835	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	41.6	0.0265	NR	HLC53509.1	2910166	g507093	i0	50	0.76	38	19	76	0	139	26	376	413	HLC53509.1 class II aldolase/adducin family protein [Candidatus Nanoarchaeia archaeon]	diamond	114	41.6	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Nanoarchaeia archaeon
27832529	27832529	PRJNA315399_S_NODE_6284_length_409_cov_3.061828_g6085_i0	PRJNA315399	6284	409	3.061828	12.52287652	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	96.7	3.3e-20	NR	HTX86726.1	2910166	g6085	i0	63	2.77261613691932	81	29	58.7	1	397	158	312	392	HTX86726.1 hypothetical protein [Candidatus Nanoarchaeia archaeon]	diamond	1134	96.7	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Nanoarchaeia archaeon
28653545	28653545	PRJNA315399_S_NODE_173867_length_155_cov_2.550847_g173666_i0	PRJNA315399	173867	155	2.550847	3.95381285	Nanobdellota archaeon	2026764	Archaea	Archaea	47.4	2.59e-4	NR	MCA9496863.1	2026764	g173666	i0	42.9	0.948387096774194	49	28	94.8	0	9	155	196	244	MCA9496863.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	147	47.4	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
28734113	28734113	PRJNA315399_P_NODE_333607_length_174_cov_4.000000_g333159_i0	PRJNA315399	333607	174	4	6.96	root	1	Root_unresolved	Root_unresolved	55.1	6.67e-7	NR	MCA9495373.1	2026764	g333159	i0	52.1	2.44827586206897	48	22	81	1	159	19	141	188	MCA9495373.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	426	55.5	0.992792792792793	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
29144824	29144824	PRJNA315399_P_NODE_271429_length_180_cov_4.881119_g270981_i0	PRJNA315399	271429	180	4.881119	8.7860142	root	1	Root_unresolved	Root_unresolved	43.9	0.00609	NR	MEK6872172.1	2026764	g270981	i0	46.3	1.33333333333333	41	22	68.3	0	52	174	77	117	MEK6872172.1 IS5 family transposase [Nanoarchaeota archaeon]	diamond	240	43.9	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
29821444	29821444	PRJNA315399_P_NODE_459531_length_155_cov_3.822034_g459083_i0	PRJNA315399	459531	155	3.822034	5.9241527	Nanobdellota archaeon	2026764	Archaea	Archaea	57.4	7.5e-8	NR	MCK4930288.1	2026764	g459083	i0	76.5	1.31612903225806	34	8	65.8	0	142	41	354	387	MCK4930288.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	204	57.4	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
31465149	31465149	PRJNA315399_S_NODE_143116_length_163_cov_1.642857_g142915_i0	PRJNA315399	143116	163	1.642857	2.67785691	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	55.8	2.75e-7	NR	HLC58238.1	2910166	g142915	i0	45.3	1.85889570552147	53	29	97.5	0	3	161	149	201	HLC58238.1 hypothetical protein [Candidatus Nanoarchaeia archaeon]	diamond	303	55.8	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Nanoarchaeia archaeon
31749471	31749471	PRJNA315399_S_NODE_192897_length_151_cov_2.657895_g192696_i0	PRJNA315399	192897	151	2.657895	4.01342145	Nanobdellota archaeon	2026764	Archaea	Archaea	52	5.76e-6	NR	MBU2560856.1	2026764	g192696	i0	55.3	1.82781456953642	47	21	93.4	0	11	151	211	257	MBU2560856.1 transposase [Nanoarchaeota archaeon]	diamond	276	52	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);;