metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA751877" and tax_clade = "Cyanobacteriota/Melainabacteria group"

26 rows where analysis = "diamond", bioproject = "PRJNA751877" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
2002396	2002396	PRJNA751877_P_NODE_23222_length_250_cov_0.870056_g23100_i0	PRJNA751877	23222	250	0.870056	2.17514	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	144	5.92e-38	NR	HEY9839857.1	2364082	g23100	i0	87.8	0.984	82	10	98.4	0	248	3	627	708	HEY9839857.1 ATP-dependent RecD-like DNA helicase [Candidatus Obscuribacterales bacterium]	diamond	246	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
16503234	16503234	PRJNA751877_P_NODE_26173_length_246_cov_0.890173_g26051_i0	PRJNA751877	26173	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	161	5.62e-44	NR	HEY9839850.1	2364082	g26051	i0	90.2	2	82	8	100	0	246	1	40	121	HEY9839850.1 alanine--tRNA ligase [Candidatus Obscuribacterales bacterium]	diamond	492	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
24952693	24952693	PRJNA751877_P_NODE_15140_length_297_cov_1.031250_g15018_i0	PRJNA751877	15140	297	1.03125	3.0628125	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	197	3.38e-59	NR	MEZ0369224.1	2762020	g15018	i0	90.8	0.98989898989899	98	9	99	0	297	4	223	320	MEZ0369224.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	294	197	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
26682747	26682747	PRJNA751877_P_NODE_24981_length_248_cov_0.880000_g24859_i0	PRJNA751877	24981	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	129	4.84e-34	NR	PKL78988.1	2013813	g24859	i0	74.4	2.95161290322581	82	21	99.2	0	246	1	156	237	PKL78988.1 MAG: anion permease [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	732	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
26767954	26767954	PRJNA751877_P_NODE_6321_length_403_cov_1.360606_g6199_i0	PRJNA751877	6321	403	1.360606	5.48324218	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	183	2.9699999999999996e-56	NR	PKL75061.1	2013813	g6199	i0	89.2	0.759305210918114	102	11	75.9	0	1	306	85	186	PKL75061.1 MAG: hypothetical protein CVV27_17300 [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	306	183	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
26831324	26831324	PRJNA751877_P_NODE_27721_length_244_cov_0.900585_g27599_i0	PRJNA751877	27721	244	0.900585	2.1974274	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	90.5	4.98e-19	NR	MEZ0368829.1	2762020	g27599	i0	69	0.713114754098361	58	18	71.3	0	217	44	90	147	MEZ0368829.1 tetratricopeptide repeat protein [Candidatus Sericytochromatia bacterium]	diamond	174	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
27094300	27094300	PRJNA751877_P_NODE_27322_length_245_cov_0.895349_g27200_i0	PRJNA751877	27322	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	85.9	2.3e-17	NR	HEY9843278.1	2364082	g27200	i0	61.7	1.98367346938776	81	31	99.2	0	2	244	225	305	HEY9843278.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	486	85.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27157183	27157183	PRJNA751877_P_NODE_29282_length_242_cov_0.911243_g29160_i0	PRJNA751877	29282	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	108	1.65e-27	NR	WP_015166226.1	82654	g29160	i0	61.3	19.5371900826446	75	29	93	0	18	242	3	77	WP_015166226.1 peroxiredoxin [Pseudanabaena sp. PCC 7367]	diamond	4728	109	0.990825688073395	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Thalassoporaceae	Thalassoporum	Thalassoporum mexicanum
27188972	27188972	PRJNA751877_P_NODE_21882_length_253_cov_1.266667_g21760_i0	PRJNA751877	21882	253	1.266667	3.20466751	Bacteria	2	Bacteria	Bacteria	115	1.67e-28	NR	HEY9844049.1	2364082	g21760	i0	57.8	1.96837944664032	83	35	98.4	0	251	3	267	349	HEY9844049.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Obscuribacterales bacterium]	diamond	498	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27726521	27726521	PRJNA751877_P_NODE_22704_length_251_cov_0.865169_g22582_i0	PRJNA751877	22704	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	129	8.96e-34	NR	HEY9841248.1	2364082	g22582	i0	72	1.9601593625498	82	23	98	0	250	5	164	245	HEY9841248.1 ATP-grasp domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	492	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28032010	28032010	PRJNA751877_P_NODE_29225_length_242_cov_0.911243_g29103_i0	PRJNA751877	29225	242	0.911243	2.20520806	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	77.8	1.66e-14	NR	MEZ0369609.1	2762020	g29103	i0	47.4	2.90082644628099	76	40	94.2	0	15	242	209	284	MEZ0369609.1 YfhO family protein [Candidatus Sericytochromatia bacterium]	diamond	702	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28189549	28189549	PRJNA751877_P_NODE_19246_length_270_cov_1.228426_g19124_i0	PRJNA751877	19246	270	1.228426	3.3167502	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	133	3.05e-35	NR	MEZ0372746.1	2762020	g19124	i0	76.9	1.01111111111111	91	20	100	1	1	270	246	336	MEZ0372746.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	273	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28221190	28221190	PRJNA751877_P_NODE_18606_length_274_cov_1.447761_g18484_i0	PRJNA751877	18606	274	1.447761	3.96686514	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	77.4	1.37e-14	NR	MEZ0367474.1	2762020	g18484	i0	54.9	0.777372262773723	71	23	77.7	1	17	229	1	62	MEZ0367474.1 formylglycine-generating enzyme family protein [Candidatus Sericytochromatia bacterium]	diamond	213	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28442538	28442538	PRJNA751877_P_NODE_30266_length_241_cov_0.916667_g30144_i0	PRJNA751877	30266	241	0.916667	2.20916747	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	152	1.3899999999999996e-42	NR	PKL74936.1	2013813	g30144	i0	97.5	0.995850622406639	80	2	99.6	0	240	1	174	253	PKL74936.1 MAG: acyl-CoA dehydrogenase [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	240	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
28989332	28989332	PRJNA751877_P_NODE_24368_length_249_cov_0.875000_g24246_i0	PRJNA751877	24368	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	131	1.13e-34	NR	PKL79497.1	2013813	g24246	i0	75	1.93975903614458	80	20	96.4	0	244	5	85	164	PKL79497.1 MAG: cytochrome-c peroxidase [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	483	132	0.992424242424242	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
29074054	29074054	PRJNA751877_P_NODE_28388_length_243_cov_0.905882_g28266_i0	PRJNA751877	28388	243	0.905882	2.20129326	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	65.5	3.44e-10	NR	MEZ0375410.1	2762020	g28266	i0	57.6	0.728395061728395	59	25	72.8	0	236	60	19	77	MEZ0375410.1 IS4 family transposase [Candidatus Sericytochromatia bacterium]	diamond	177	65.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29105597	29105597	PRJNA751877_P_NODE_16888_length_285_cov_1.089623_g16766_i0	PRJNA751877	16888	285	1.089623	3.10542555	Pseudanabaena sp. SR411	1980935	Bacteria	Bacteria	69.7	8.29e-12	NR	WP_094530082.1	1980935	g16766	i0	49.3	0.789473684210526	75	37	77.9	1	222	1	1	75	WP_094530082.1 hypothetical protein [Pseudanabaena sp. SR411]	diamond	225	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. SR411
29137277	29137277	PRJNA751877_P_NODE_20489_length_262_cov_1.629630_g20367_i0	PRJNA751877	20489	262	1.62963	4.2696306	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	152	1.83e-41	NR	MEZ0374821.1	2762020	g20367	i0	93	0.984732824427481	86	6	98.5	0	260	3	289	374	MEZ0374821.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	258	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29263091	29263091	PRJNA751877_P_NODE_28889_length_243_cov_0.905882_g28767_i0	PRJNA751877	28889	243	0.905882	2.20129326	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	151	2.07e-44	NR	PKL75833.1	2013813	g28767	i0	93.8	1	81	5	100	0	1	243	74	154	PKL75833.1 MAG: F420-0:Gamma-glutamyl ligase, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	243	151	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
29547286	29547286	PRJNA751877_P_NODE_28130_length_244_cov_0.900585_g28008_i0	PRJNA751877	28130	244	0.900585	2.1974274	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	108	1.02e-25	NR	MEZ0374454.1	2762020	g28008	i0	76.1	0.823770491803279	67	16	82.4	0	207	7	45	111	MEZ0374454.1 phosphatidylserine/phosphatidylglycerophosphate/cardiolipin synthase family protein [Candidatus Sericytochromatia bacterium]	diamond	201	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31759482	31759482	PRJNA751877_P_NODE_24317_length_249_cov_0.875000_g24195_i0	PRJNA751877	24317	249	0.875	2.17875	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	97.1	2.7800000000000003e-21	NR	HEY9843538.1	2364082	g24195	i0	58.5	0.987951807228916	82	34	98.8	0	248	3	369	450	HEY9843538.1 class I SAM-dependent methyltransferase [Candidatus Obscuribacterales bacterium]	diamond	246	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31854363	31854363	PRJNA751877_P_NODE_8237_length_370_cov_1.030303_g8115_i0	PRJNA751877	8237	370	1.030303	3.8121211	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	123	7.339999999999999e-30	NR	PKL75227.1	2013813	g8115	i0	52.6	1.86486486486486	116	55	94.1	0	23	370	89	204	PKL75227.1 MAG: hypothetical protein CVV27_16445, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	690	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
32171064	32171064	PRJNA751877_P_NODE_18618_length_274_cov_1.388060_g18496_i0	PRJNA751877	18618	274	1.38806	3.8032844	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	144	1.27e-39	NR	PKL76434.1	2013813	g18496	i0	72.5	1.99270072992701	91	25	99.6	0	273	1	124	214	PKL76434.1 MAG: cysteine synthase A [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	546	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
32329373	32329373	PRJNA751877_P_NODE_26099_length_246_cov_0.890173_g25977_i0	PRJNA751877	26099	246	0.890173	2.18982558	Cyanobacteria bacterium P01_A01_bin.37	3023248	Bacteria	Bacteria	86.3	1.46e-17	NR	MEM7770880.1	3023248	g25977	i0	48.8	1	82	42	100	0	246	1	71	152	MEM7770880.1 ISKra4 family transposase [Cyanobacteria bacterium P01_A01_bin.37]	diamond	246	86.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.37
32644732	32644732	PRJNA751877_P_NODE_20020_length_265_cov_1.588542_g19898_i0	PRJNA751877	20020	265	1.588542	4.2096363	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	98.2	1.8299999999999994e-23	NR	MBT9543826.1	2762020	g19898	i0	54.1	0.962264150943396	85	39	96.2	0	255	1	80	164	MBT9543826.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	255	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32708006	32708006	PRJNA751877_P_NODE_27960_length_244_cov_0.900585_g27838_i0	PRJNA751877	27960	244	0.900585	2.1974274	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	90.5	5.63e-19	NR	MBF2053618.1	2762020	g27838	i0	62.3	0.848360655737705	69	26	84.8	0	231	25	368	436	MBF2053618.1 HAMP domain-containing histidine kinase [Candidatus Sericytochromatia bacterium]	diamond	207	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia 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);;