metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax_phylum = "Planctomycetota"

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_order	tax_family	tax_genus	tax_species
6273090	6273090	PRJNA680334_S_NODE_104125_length_151_cov_6.728814_g103639_i0	PRJNA680334	104125	151	6.728814	10.16050914	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	65.9	7.09e-11	NR	MCC7423088.1	2026779	g103639	i0	76.6	0.933774834437086	47	10	93.4	1	9	149	15	60	MCC7423088.1 DUF1254 domain-containing protein [Planctomycetaceae bacterium]	diamond	141	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
8303351	8303351	PRJNA680334_S_NODE_59327_length_182_cov_1.369128_g58841_i0	PRJNA680334	59327	182	1.369128	2.49181296	Bacteria	2	Bacteria	Bacteria	124	2.08e-33	NR	MBM4070672.1	2026780	g58841	i0	100	2.93406593406593	59	0	97.3	0	2	178	39	97	MBM4070672.1 DUF4405 domain-containing protein [Planctomycetota bacterium]	diamond	534	125	0.992	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26797144	26797144	PRJNA680334_S_NODE_9341_length_320_cov_32.076655_g8855_i0	PRJNA680334	9341	320	32.076655	102.645296	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.0198	NR	MEY4673374.1	2026780	g8855	i0	37	0.684375	73	43	66.6	2	61	273	1013	1084	MEY4673374.1 hypothetical protein [Planctomycetota bacterium]	diamond	219	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27124981	27124981	PRJNA680334_S_NODE_45082_length_198_cov_3.315152_g44596_i0	PRJNA680334	45082	198	3.315152	6.56400096	Pseudomonadati	3379134	Bacteria	Bacteria	92	7.56e-21	NR	HEY3966710.1	2026779	g44596	i0	80.7	12.0909090909091	57	11	86.4	0	172	2	1	57	HEY3966710.1 glucose 1-dehydrogenase [Planctomycetaceae bacterium]	diamond	2394	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28092612	28092612	PRJNA680334_S_NODE_47585_length_195_cov_1.586420_g47099_i0	PRJNA680334	47585	195	1.58642	3.093519	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	79	6.76e-16	NR	HVT27669.1	2691534	g47099	i0	55.7	0.938461538461538	61	27	93.8	0	3	185	89	149	HVT27669.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	183	79	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
28534895	28534895	PRJNA680334_S_NODE_45647_length_197_cov_4.865854_g45161_i0	PRJNA680334	45647	197	4.865854	9.58573238	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	109	8.67e-27	NR	HEY7090212.1	2876886	g45161	i0	83.1	0.989847715736041	65	11	99	0	1	195	81	145	HEY7090212.1 lipopolysaccharide heptosyltransferase I [Tepidisphaeraceae bacterium]	diamond	195	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29197897	29197897	PRJNA680334_S_NODE_27029_length_232_cov_2.869347_g26543_i0	PRJNA680334	27029	232	2.869347	6.65688504	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	113	1.98e-29	NR	HEY7087992.1	2876886	g26543	i0	63.1	1.08620689655172	84	23	98.3	1	3	230	9	92	HEY7087992.1 nicotinate (nicotinamide) nucleotide adenylyltransferase [Tepidisphaeraceae bacterium]	diamond	252	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29260701	29260701	PRJNA680334_S_NODE_69429_length_173_cov_1.735714_g68943_i0	PRJNA680334	69429	173	1.735714	3.00278522	Planctomycetota bacterium	2026780	Bacteria	Bacteria	57	1.33e-7	NR	MAG57786.1	2026780	g68943	i0	50	0.901734104046243	52	25	88.4	1	172	20	15	66	MAG57786.1 hypothetical protein [Planctomycetota bacterium]	diamond	156	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29670997	29670997	PRJNA680334_S_NODE_15630_length_274_cov_4.701245_g15144_i0	PRJNA680334	15630	274	4.701245	12.8814113	Candidatus Laterigemmans baculatus	2770505	Bacteria	Bacteria	94	4.549999999999999e-23	NR	WP_164102970.1	2770505	g15144	i0	76.8	1.21532846715328	56	13	61.3	0	273	106	11	66	WP_164102970.1 RNA-binding S4 domain-containing protein [Candidatus Laterigemmans baculatus]	diamond	333	94	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Candidatus Laterigemmans	Candidatus Laterigemmans baculatus
29904298	29904298	PRJNA680334_S_NODE_58191_length_183_cov_1.846667_g57705_i0	PRJNA680334	58191	183	1.846667	3.37940061	PVC group	1783257	Bacteria	Bacteria	57.8	7.41e-9	NR	MDP6541725.1	2052180	g57705	i0	83.3	4.91803278688525	30	5	49.2	0	177	88	81	110	MDP6541725.1 adenosylhomocysteinase [Phycisphaerales bacterium]	diamond	900	57.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31219014	31219014	PRJNA680334_S_NODE_47215_length_195_cov_4.006173_g46729_i0	PRJNA680334	47215	195	4.006173	7.81203735	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	95.9	1.48e-21	NR	WP_082840152.1	1630693	g46729	i0	68.3	1.93846153846154	63	20	96.9	0	189	1	169	231	WP_082840152.1 ISAs1 family transposase [Gemmata sp. SH-PL17]	diamond	378	95.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
31535907	31535907	PRJNA680334_S_NODE_18136_length_262_cov_3.703057_g17650_i0	PRJNA680334	18136	262	3.703057	9.70200934	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0377	NR	MCC6672320.1	2026780	g17650	i0	42.6	0.698473282442748	61	28	61.8	1	20	181	14	74	MCC6672320.1 hypothetical protein [Planctomycetota bacterium]	diamond	183	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31757091	31757091	PRJNA680334_S_NODE_24937_length_238_cov_1.546341_g24451_i0	PRJNA680334	24937	238	1.546341	3.68029158	Pirellulales bacterium	2715253	Bacteria	Bacteria	65.5	3.2e-10	NR	HUY88976.1	2715253	g24451	i0	46.6	0.920168067226891	73	33	92	1	12	230	367	433	HUY88976.1 hypothetical protein [Pirellulales bacterium]	diamond	219	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32611166	32611166	PRJNA680334_S_NODE_39560_length_206_cov_3.965318_g39074_i0	PRJNA680334	39560	206	3.965318	8.16855508	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	68.9	7e-13	NR	HVT27674.1	2691534	g39074	i0	78.4	0.538834951456311	37	8	53.9	0	203	93	96	132	HVT27674.1 co-chaperone GroES family protein [Lacipirellulaceae bacterium]	diamond	111	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium

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