metadata: contig_metadata: 21 rows where bioproject = "PRJNA876641" and tax_clade = "Cyanobacteriota/Melainabacteria group"

21 rows where bioproject = "PRJNA876641" 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
13606789	13606789	PRJNA876641_P_NODE_18031_length_248_cov_0.880000_g17957_i0	PRJNA876641	18031	248	0.88	2.1824	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g17957	i0	99.597	1.7741935483871	248	1	100	0	1	248	5557264	5557511	Anabaena sp. YBS01 chromosome, complete genome	blastn	440	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
19979887	19979887	PRJNA876641_P_NODE_21356_length_244_cov_0.871345_g21282_i0	PRJNA876641	21356	244	0.871345	2.1260818	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	276	1.1999999999999998e-69	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g21282	i0	87.712	2.79918032786885	236	29	97	0	9	244	903938	903703	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	683	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
22529987	22529987	PRJNA876641_P_NODE_2678_length_439_cov_2.254098_g2604_i0	PRJNA876641	2678	439	2.254098	9.89549022	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	203	8.2e-64	NR	CAI8350359.1	2024869	g2604	i0	70	3.77220956719818	140	42	95.7	0	19	438	46	185	CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6]	diamond	1656	203	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ARS6
26683334	26683334	PRJNA876641_P_NODE_5201_length_347_cov_1.281022_g5127_i0	PRJNA876641	5201	347	1.281022	4.44514634	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	109	1.16e-26	NR	WP_017314218.1	221287	g5127	i0	60.4	2.60230547550432	101	39	86.5	1	345	46	151	251	WP_017314218.1 SDR family oxidoreductase [Mastigocladopsis repens]	diamond	903	110	0.990909090909091	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Symphyonemataceae	Mastigocladopsis	Mastigocladopsis repens
27568735	27568735	PRJNA876641_P_NODE_3944_length_381_cov_2.412338_g3870_i0	PRJNA876641	3944	381	2.412338	9.19100778	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	130	8.95e-34	NR	WP_152088701.1	118562	g3870	i0	62.8	7.03937007874016	94	35	74	0	283	2	4	97	WP_152088701.1 alkene reductase [Arthrospira platensis]	diamond	2682	131	0.99236641221374	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
28042478	28042478	PRJNA876641_P_NODE_20085_length_245_cov_1.186047_g20011_i0	PRJNA876641	20085	245	1.186047	2.90581515	Cyanophyceae	3028117	Bacteria	Bacteria	75.1	1.51e-13	NR	WP_006277167.1	77022	g20011	i0	83.7	2.51020408163265	43	7	52.7	0	1	129	195	237	WP_006277167.1 ABC transporter ATP-binding protein [Cylindrospermopsis raciborskii]	diamond	615	75.5	0.994701986754967	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cylindrospermopsis	Cylindrospermopsis raciborskii
28192005	28192005	PRJNA876641_P_NODE_1606_length_535_cov_2.335498_g1533_i0	PRJNA876641	1606	535	2.335498	12.4949143	Microcystis panniformis	513223	Bacteria	Bacteria	88.6	8.6e-17	NR	MFM6677489.1	513223	g1533	i0	48.6	3.00560747663551	109	51	60.6	2	3	326	476	580	MFM6677489.1 Calx-beta domain-containing protein [Microcystis panniformis]	diamond	1608	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis panniformis
28381690	28381690	PRJNA876641_P_NODE_9626_length_284_cov_1.459716_g9552_i0	PRJNA876641	9626	284	1.459716	4.14559344	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	50.4	1.08e-4	NR	HEY9849636.1	3088178	g9552	i0	36.5	1.79577464788732	85	53	88.7	1	278	27	94	178	HEY9849636.1 choice-of-anchor A family protein [Leptolyngbyaceae cyanobacterium]	diamond	510	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
28634530	28634530	PRJNA876641_P_NODE_20107_length_245_cov_0.895349_g20033_i0	PRJNA876641	20107	245	0.895349	2.19360505	Hassallia sp. WJT32-NPBG1	2835088	Bacteria	Bacteria	64.7	6.86e-10	NR	MBW4609009.1	2835088	g20033	i0	43.2	1.98367346938776	81	34	99.2	1	1	243	405	473	MBW4609009.1 Dyp-type peroxidase [Hassallia sp. WJT32-NPBG1]	diamond	486	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia sp. WJT32-NPBG1
28768548	28768548	PRJNA876641_P_NODE_14087_length_259_cov_1.462366_g14013_i0	PRJNA876641	14087	259	1.462366	3.78752794	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	62.8	3.95e-9	NR	WP_235355026.1	1827278	g14013	i0	39.7	5.5019305019305	73	43	83.4	1	217	2	372	444	WP_235355026.1 GMC family oxidoreductase [Aliterella atlantica]	diamond	1425	63.2	0.993670886075949	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
28918260	28918260	PRJNA876641_P_NODE_22568_length_242_cov_0.911243_g22494_i0	PRJNA876641	22568	242	0.911243	2.20520806	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	50.8	4.96e-5	NR	PWU01433.1	2052166	g22494	i0	46.3	2.3801652892562	67	31	78.1	2	189	1	68	133	PWU01433.1 MAG: hypothetical protein C5B53_02920 [Candidatus Melainabacteria bacterium]	diamond	576	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29076475	29076475	PRJNA876641_P_NODE_15588_length_251_cov_1.556180_g15514_i0	PRJNA876641	15588	251	1.55618	3.9060118	Cyanobacteria bacterium J06632_3	3023193	Bacteria	Bacteria	46.6	0.00178	NR	MEO1621046.1	3023193	g15514	i0	45	0.717131474103586	60	32	70.5	1	4	180	240	299	MEO1621046.1 pantoate--beta-alanine ligase [Cyanobacteria bacterium J06632_3]	diamond	180	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06632_3
29139741	29139741	PRJNA876641_P_NODE_9589_length_284_cov_2.118483_g9515_i0	PRJNA876641	9589	284	2.118483	6.01649172	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	154	3.1699999999999993e-46	NR	MBX9722668.1	2364082	g9515	i0	79.8	0.992957746478873	94	19	99.3	0	282	1	33	126	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	282	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29392185	29392185	PRJNA876641_P_NODE_9549_length_285_cov_1.108491_g9475_i0	PRJNA876641	9549	285	1.108491	3.15919935	Dolichospermum sp.	2720786	Bacteria	Bacteria	70.5	4.37e-12	NR	MFN7661193.1	2720786	g9475	i0	78.7	0.494736842105263	47	10	49.5	0	1	141	84	130	MFN7661193.1 hypothetical protein [Dolichospermum sp.]	diamond	141	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
29549738	29549738	PRJNA876641_P_NODE_10890_length_277_cov_1.406863_g10816_i0	PRJNA876641	10890	277	1.406863	3.89701051	Scytonema sp. PCC 1	1204	Bacteria	Bacteria	136	6.92e-36	NR	WP_414588783.1	1680591	g10816	i0	67.4	0.996389891696751	92	30	99.6	0	277	2	200	291	WP_414588783.1 hypothetical protein [Scytonema sp. PCC 10023]	diamond	276	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023
29770806	29770806	PRJNA876641_P_NODE_21351_length_244_cov_0.883041_g21277_i0	PRJNA876641	21351	244	0.883041	2.15462004	Chroococcidiopsis sp. SAG 2	3088168	Bacteria	Bacteria	75.9	1e-15	NR	WP_410500733.1	171389	g21277	i0	87.8	2.01639344262295	41	5	50.4	0	49	171	24	64	WP_410500733.1 transposase [Chroococcidiopsis sp. SAG 2025]	diamond	492	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
30971645	30971645	PRJNA876641_P_NODE_1494_length_549_cov_1.258403_g1421_i0	PRJNA876641	1494	549	1.258403	6.90863247	Cyanobacteria bacterium P01_H01_bin.130	3023312	Bacteria	Bacteria	57.4	3.79e-6	NR	MEM1425791.1	3023312	g1421	i0	63.2	0.207650273224044	38	14	20.8	0	25	138	242	279	MEM1425791.1 hypothetical protein [Cyanobacteria bacterium P01_H01_bin.130]	diamond	114	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.130
31540697	31540697	PRJNA876641_P_NODE_236_length_1116_cov_3.565676_g197_i0	PRJNA876641	236	1116	3.565676	39.79294416	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	468	1.2699999999999996e-162	NR	MBX9694561.1	2847862	g197	i0	74.4	2.59677419354839	308	74	81.5	2	44	952	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31888415	31888415	PRJNA876641_P_NODE_18257_length_248_cov_0.880000_g18183_i0	PRJNA876641	18257	248	0.88	2.1824	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	98.2	3.88e-22	NR	HEY9754159.1	3088181	g18183	i0	55.8	0.931451612903226	77	34	93.1	0	2	232	258	334	HEY9754159.1 DNA-directed RNA polymerase subunit D [Oculatellaceae cyanobacterium]	diamond	231	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
32023197	32023197	PRJNA876641_P_NODE_15578_length_251_cov_1.617978_g15504_i0	PRJNA876641	15578	251	1.617978	4.06112478	Microcystis	1125	Bacteria	Bacteria	46.6	0.00184	NR	WP_253852038.1	1126	g15504	i0	45	1.94820717131474	80	36	95.6	2	11	250	1028	1099	WP_253852038.1 FG-GAP-like repeat-containing protein [Microcystis aeruginosa]	diamond	489	47	0.991489361702128	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
32497966	32497966	PRJNA876641_P_NODE_23799_length_236_cov_2.441718_g23725_i0	PRJNA876641	23799	236	2.441718	5.76245448	Bacteria	2	Bacteria	Bacteria	159	7.009999999999999e-47	NR	MBA4077649.1	2067979	g23725	i0	98.7	1.98305084745763	78	1	99.2	0	234	1	68	145	MBA4077649.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	468	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023

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