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

28 rows where analysis = "diamond", bioproject = "PRJNA816047" 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
25873301	25873301	PRJNA816047d_S_NODE_122923_length_239_cov_2.091398_g121088_i0	PRJNA816047	122923	239	2.091398	4.99844122	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	81.3	1e-16	NR	HEY9782437.1	3088178	g121088	i0	74.5	0.690376569037657	55	14	69	0	166	2	1	55	HEY9782437.1 helix-turn-helix domain-containing protein [Leptolyngbyaceae cyanobacterium]	diamond	165	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
26013514	26013514	PRJNA816047d_S_NODE_60140_length_291_cov_1.310924_g58305_i0	PRJNA816047	60140	291	1.310924	3.81478884	Aphanizomenon flos-aquae LD13	1710894	Bacteria	Bacteria	200	1.63e-62	NR	OBQ15835.1	1710894	g58305	i0	99	1	97	1	100	0	291	1	107	203	OBQ15835.1 MAG: methylmalonyl-CoA mutase, partial [Aphanizomenon flos-aquae LD13]	diamond	291	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
32921484	32921484	PRJNA816047b_S_NODE_39649_length_271_cov_1.257576_g37337_i0	PRJNA816047	39649	271	1.257576	3.40803096	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	99.8	4.65e-22	NR	MDQ5937159.1	3070899	g37337	i0	73	0.697416974169742	63	17	69.7	0	191	3	8	70	MDQ5937159.1 ligase [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	189	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
32924902	32924902	PRJNA816047b_S_NODE_15817_length_396_cov_2.996904_g13505_i0	PRJNA816047	15817	396	2.996904	11.86773984	Cyanophyceae	3028117	Bacteria	Bacteria	123	8.86e-33	NR	WP_017720595.1	1173028	g13505	i0	88.7	5.9469696969697	71	7	53	1	3	212	106	176	WP_017720595.1 cysteine hydrolase family protein [Oscillatoria sp. PCC 10802]	diamond	2355	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. PCC 10802
32939177	32939177	PRJNA816047d_S_NODE_51457_length_309_cov_1.183594_g49622_i0	PRJNA816047	51457	309	1.183594	3.65730546	Trichormus sp.	3088172	Bacteria	Bacteria	168	3.36e-48	NR	HEY9716583.1	3088172	g49622	i0	83	1.8252427184466	94	16	91.3	0	24	305	245	338	HEY9716583.1 serine hydrolase domain-containing protein [Trichormus sp.]	diamond	564	168	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus sp.
32990301	32990301	PRJNA816047d_S_NODE_120139_length_241_cov_1.196809_g118304_i0	PRJNA816047	120139	241	1.196809	2.88430969	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	112	8.040000000000001e-29	NR	HCF26606.1	2055787	g118304	i0	83.6	0.83402489626556	67	11	83.4	0	1	201	122	188	HCF26606.1 repressor LexA [Cyanobacteria bacterium UBA11049]	diamond	201	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
32993399	32993399	PRJNA816047d_S_NODE_101955_length_249_cov_5.362245_g100120_i0	PRJNA816047	101955	249	5.362245	13.35199005	Bacteria	2	Bacteria	Bacteria	153	5.089999999999998e-43	NR	WP_280690964.1	75695	g100120	i0	92.8	2	83	2	95.2	1	237	1	53	135	WP_280690964.1 type IX secretion system outer membrane channel protein PorV [Umezakia ovalisporum]	diamond	498	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Umezakia	Umezakia ovalisporum
33007336	33007336	PRJNA816047d_S_NODE_27883_length_404_cov_1.464387_g26052_i0	PRJNA816047	27883	404	1.464387	5.91612348	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	168	2.58e-47	NR	WP_190772829.1	2650499	g26052	i0	59.1	10.8044554455446	132	54	98	0	8	403	318	449	WP_190772829.1 MULTISPECIES: aldehyde dehydrogenase [unclassified Leptolyngbya]	diamond	4365	168	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
33007562	33007562	PRJNA816047d_S_NODE_62267_length_287_cov_2.209402_g60432_i0	PRJNA816047	62267	287	2.209402	6.34098374	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	75.9	6.76e-14	NR	MDD5593823.1	2053573	g60432	i0	55.9	0.616724738675958	59	26	61.7	0	191	15	1	59	MDD5593823.1 glycosyltransferase family 2 protein [Candidatus Margulisiibacteriota bacterium]	diamond	177	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
33007596	33007596	PRJNA816047d_S_NODE_67227_length_279_cov_1.075221_g65392_i0	PRJNA816047	67227	279	1.075221	2.99986659	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	102	5.969999999999999e-23	NR	MBW4639462.1	2839657	g65392	i0	57	1	93	38	98.9	2	2	277	270	361	MBW4639462.1 EAL domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	279	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
33024067	33024067	PRJNA816047a_S_NODE_8180_length_710_cov_5.708006_g5706_i0	PRJNA816047	8180	710	5.708006	40.5268426	Nostoc sp. TCL26-	1180	Bacteria	Bacteria	51.2	0.00231	NR	WP_306296915.1	2576904	g5706	i0	31.9	0.397183098591549	94	58	37.6	3	165	431	34	126	WP_306296915.1 calcium-binding protein [Nostoc sp. TCL26-01]	diamond	282	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
33024462	33024462	PRJNA816047d_S_NODE_23052_length_450_cov_2.282116_g21226_i0	PRJNA816047	23052	450	2.282116	10.269522	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	139	2.759999999999999e-38	NR	HEY9755846.1	3088181	g21226	i0	58.5	0.9	135	43	88	3	54	449	3	127	HEY9755846.1 TetR/AcrR family transcriptional regulator [Oculatellaceae cyanobacterium]	diamond	405	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
33041220	33041220	PRJNA816047d_S_NODE_100468_length_250_cov_1.228426_g98633_i0	PRJNA816047	100468	250	1.228426	3.071065	Nostoc flagelliforme	1306274	Bacteria	Bacteria	56.2	7.02e-7	NR	WP_318670528.1	1306274	g98633	i0	49.2	0.732	61	29	73.2	1	248	66	435	493	WP_318670528.1 hypothetical protein [Nostoc flagelliforme]	diamond	183	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
33044651	33044651	PRJNA816047d_S_NODE_72092_length_271_cov_2.123853_g70257_i0	PRJNA816047	72092	271	2.123853	5.75564163	Cyanophyceae	3028117	Bacteria	Bacteria	86.7	1.13e-19	NR	MDV2993066.1	171389	g70257	i0	84.3	2.23616236162362	51	7	55.4	1	252	103	64	114	MDV2993066.1 hypothetical protein [Chroococcidiopsis sp. SAG 2025]	diamond	606	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
33058669	33058669	PRJNA816047d_S_NODE_56773_length_297_cov_2.696721_g54938_i0	PRJNA816047	56773	297	2.696721	8.00926137	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	97.4	3.02e-21	NR	HEY9755252.1	3088181	g54938	i0	54.5	0.888888888888889	88	35	83.8	1	250	2	283	370	HEY9755252.1 LamG-like jellyroll fold domain-containing protein [Oculatellaceae cyanobacterium]	diamond	264	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
33058851	33058851	PRJNA816047d_S_NODE_88101_length_257_cov_2.397059_g86266_i0	PRJNA816047	88101	257	2.397059	6.16044163	Desmonostoc geniculatum	1874532	Bacteria	Bacteria	129	9.099999999999999e-35	NR	MBW4675863.1	1874567	g86266	i0	90.1	4.14396887159533	71	7	82.9	0	213	1	2	72	MBW4675863.1 transposase [Desmonostoc geniculatum HA4340-LM1]	diamond	1065	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Desmonostoc	Desmonostoc geniculatum
33061420	33061420	PRJNA816047a_S_NODE_44941_length_311_cov_6.445378_g42281_i0	PRJNA816047	44941	311	6.445378	20.04512558	Bacillati	1783272	Bacteria	Bacteria	45.8	0.00707	NR	TAD75012.1	1151	g42281	i0	45.1	1.11897106109325	51	28	49.2	0	190	38	595	645	TAD75012.1 MAG: PAS domain S-box protein [Oscillatoriales cyanobacterium]	diamond	348	46.2	0.991341991341991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
33061531	33061531	PRJNA816047d_S_NODE_100277_length_250_cov_1.659898_g98442_i0	PRJNA816047	100277	250	1.659898	4.149745	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	92.4	5.3e-20	NR	WP_335223866.1	1180	g98442	i0	64.4	2.628	73	26	87.6	0	3	221	282	354	WP_335223866.1 Gfo/Idh/MocA family oxidoreductase [Nostoc sp.]	diamond	657	92.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
33091982	33091982	PRJNA816047a_S_NODE_16998_length_490_cov_1.311751_g14364_i0	PRJNA816047	16998	490	1.311751	6.4275799	Microcystis flos-aquae Mf_WU_F_1975	109615	Bacteria	Bacteria	137	9.419999999999999e-39	NR	TRV18648.1	2486237	g14364	i0	68.1	0.575510204081633	94	30	57.6	0	2	283	16	109	TRV18648.1 MAG: hypothetical protein EWV40_16760 [Microcystis flos-aquae Mf_WU_F_19750830_S460]	diamond	282	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis flos-aquae
33093054	33093054	PRJNA816047d_S_NODE_82086_length_261_cov_1.427885_g80251_i0	PRJNA816047	82086	261	1.427885	3.72677985	Prochlorococcus sp. AH-716-N03	2977689	Bacteria	Bacteria	56.2	8e-7	NR	MDC3089370.1	2977689	g80251	i0	53.8	1.77011494252874	39	18	44.8	0	100	216	9	47	MDC3089370.1 NAD(P)-binding protein [Prochlorococcus sp. AH-716-N03]	diamond	462	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. AH-716-N03
33095883	33095883	PRJNA816047d_S_NODE_55918_length_299_cov_1.451220_g54083_i0	PRJNA816047	55918	299	1.45122	4.3391478	Nostocales	1161	Bacteria	Bacteria	118	7.29e-32	NR	WP_017317027.1	221287	g54083	i0	84.5	4.56521739130435	58	9	58.2	0	2	175	78	135	WP_017317027.1 peptide-methionine (R)-S-oxide reductase MsrB [Mastigocladopsis repens]	diamond	1365	119	0.991596638655462	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Symphyonemataceae	Mastigocladopsis	Mastigocladopsis repens
33109527	33109527	PRJNA816047d_S_NODE_125214_length_236_cov_2.956284_g123379_i0	PRJNA816047	125214	236	2.956284	6.97683024	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	100	1.18e-22	NR	WP_106367592.1	2107693	g123379	i0	77.3	0.838983050847458	66	15	83.9	0	200	3	743	808	WP_106367592.1 dynamin family protein [Chlorogloea sp. CCALA 695]	diamond	198	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
33109619	33109619	PRJNA816047d_S_NODE_19398_length_501_cov_2.495536_g17606_i0	PRJNA816047	19398	501	2.495536	12.50263536	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	80.9	5.06e-15	NR	MBR6299217.1	2137880	g17606	i0	49.3	0.437125748502994	73	37	43.7	0	489	271	177	249	MBR6299217.1 TatD family hydrolase [Candidatus Gastranaerophilales bacterium]	diamond	219	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
33143979	33143979	PRJNA816047d_S_NODE_53991_length_303_cov_2.288000_g52156_i0	PRJNA816047	53991	303	2.288	6.93264	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	125	7.41e-35	NR	MBS2004520.1	2807734	g52156	i0	93.2	0.584158415841584	59	4	58.4	0	99	275	1	59	MBS2004520.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-5]	diamond	177	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
33147046	33147046	PRJNA816047d_S_NODE_72255_length_271_cov_1.334862_g70420_i0	PRJNA816047	72255	271	1.334862	3.61747602	Pleurocapsa	44474	Bacteria	Bacteria	97.8	2.1800000000000003e-21	NR	PSP19311.1	1919134	g70420	i0	59	8.63468634686347	78	32	86.3	0	2	235	217	294	PSP19311.1 MAG: arginine--tRNA ligase [Cyanobacteria bacterium QS_8_64_29]	diamond	2340	98.2	0.995926680244399	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium QS_8_64_29
33160893	33160893	PRJNA816047d_S_NODE_44536_length_327_cov_1.500000_g42701_i0	PRJNA816047	44536	327	1.5	4.905	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	157	7.55e-45	NR	HEY9754856.1	3088181	g42701	i0	73.1	0.990825688073395	108	29	99.1	0	325	2	30	137	HEY9754856.1 TlyA family RNA methyltransferase [Oculatellaceae cyanobacterium]	diamond	324	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
33163992	33163992	PRJNA816047d_S_NODE_56832_length_297_cov_2.094262_g54997_i0	PRJNA816047	56832	297	2.094262	6.21995814	Bacillati	1783272	Bacteria	Bacteria	76.3	4.84e-15	NR	WP_148129262.1	32056	g54997	i0	41.8	6.4040404040404	91	53	91.9	0	274	2	36	126	WP_148129262.1 hypothetical protein [Dulcicalothrix desertica]	diamond	1902	77	0.990909090909091	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
33178414	33178414	PRJNA816047d_S_NODE_84920_length_259_cov_2.402913_g83085_i0	PRJNA816047	84920	259	2.402913	6.22354467	Synechococcus sp. L2F	2823739	Bacteria	Bacteria	125	2.6399999999999998e-31	NR	WP_255100223.1	2823739	g83085	i0	77.6	0.88030888030888	76	17	88	0	242	15	419	494	WP_255100223.1 hypothetical protein [Synechococcus sp. L2F]	diamond	228	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. L2F

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