metadata: contig_metadata: 17 rows where bioproject = "PRJNA352610" and tax_clade = "Cyanobacteriota/Melainabacteria group"

17 rows where bioproject = "PRJNA352610" 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
8047199	8047199	PRJNA352610_P_NODE_28867_length_246_cov_0.878613_g28806_i0	PRJNA352610	28867	246	0.878613	2.16138798	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g28806	i0	89.431	112.878048780488	246	26	100	0	1	246	3325	3080	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27768	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11872359	11872359	PRJNA352610_P_NODE_19210_length_285_cov_2.452830_g19149_i0	PRJNA352610	19210	285	2.45283	6.9905655	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	516	7.77e-142	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g19149	i0	99.298	259.550877192982	285	2	100	0	1	285	1858164	1858448	Calothrix sp. PCC 7716 DNA, complete genome	blastn	73972	516	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
12549008	12549008	PRJNA352610_P_NODE_14670_length_319_cov_1.166667_g14609_i0	PRJNA352610	14670	319	1.166667	3.72166773	Microcoleus	44471	Bacteria	Bacteria	566	8.64e-157	NTclustered	gi\|1804756945\|gb\|MT013207.1\|	2705320	g14609	i0	98.742	135.391849529781	318	4	99	0	2	319	2175	2492	Microcoleus anatoxicus PTRS1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43190	566	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
17648155	17648155	PRJNA352610_P_NODE_28394_length_246_cov_0.953757_g28333_i0	PRJNA352610	28394	246	0.953757	2.34624222	Oscillatoriales	1150	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g28333	i0	97.131	103.926829268293	244	4	98	3	3	244	2459	2217	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	25566	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
22747441	22747441	PRJNA352610_P_NODE_20258_length_279_cov_1.320388_g20197_i0	PRJNA352610	20258	279	1.320388	3.68388252	Microcoleus	44471	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g20197	i0	100	132.498207885305	279	0	100	0	1	279	103580	103302	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	36967	516	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
25296743	25296743	PRJNA352610_P_NODE_27760_length_247_cov_0.885057_g27699_i0	PRJNA352610	27760	247	0.885057	2.18609079	Tolypothrix	111782	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2316438351\|gb\|CP064879.1\|	1188	g27699	i0	100	0.226720647773279	28	0	11	0	4	31	5217578	5217605	Tolypothrix sp. PCC 7601 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7601
26790069	26790069	PRJNA352610_P_NODE_3061_length_576_cov_1.809145_g3000_i0	PRJNA352610	3061	576	1.809145	10.4206752	Moorena sp. SIOASIH	2607817	Bacteria	Bacteria	127	7.7e-34	NR	WP_293091305.1	2607817	g3000	i0	56.6	0.671875	129	47	62.5	3	2	361	8	136	WP_293091305.1 profilin [Moorena sp. SIOASIH]	diamond	387	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIOASIH
27201000	27201000	PRJNA352610_P_NODE_1342_length_781_cov_2.807910_g1291_i0	PRJNA352610	1342	781	2.80791	21.9297771	Hormoscilla sp. GUM202	2480853	Bacteria	Bacteria	75.1	3.28e-12	NR	MBO1348701.1	2480853	g1291	i0	32.6	0.553137003841229	144	87	51.9	3	514	110	16	158	MBO1348701.1 hypothetical protein [Hormoscilla sp. GUM202]	diamond	432	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	Hormoscilla sp. GUM202
28134386	28134386	PRJNA352610_P_NODE_19425_length_284_cov_1.350711_g19364_i0	PRJNA352610	19425	284	1.350711	3.83601924	Bacillati	1783272	Bacteria	Bacteria	46.6	0.00268	NR	WP_015200734.1	1170562	g19364	i0	31.3	2.71478873239437	64	43	67.6	1	279	88	145	207	WP_015200734.1 S-layer homology domain-containing protein [Calothrix sp. PCC 6303]	diamond	771	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
28717055	28717055	PRJNA352610_P_NODE_2647_length_611_cov_1.280669_g2586_i0	PRJNA352610	2647	611	1.280669	7.82488759	Acaryochloris thomasi	2929456	Bacteria	Bacteria	72.8	3.45e-11	NR	WP_110988953.1	2929456	g2586	i0	32.4	1.33551554828151	136	80	65.3	4	41	439	230	356	WP_110988953.1 fatty acid desaturase family protein [Acaryochloris thomasi]	diamond	816	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris thomasi
29001529	29001529	PRJNA352610_P_NODE_4248_length_511_cov_1.397260_g4187_i0	PRJNA352610	4248	511	1.39726	7.1399986	Planktothrix mougeotii	54306	Bacteria	Bacteria	45.8	0.04	NR	WP_193867723.1	54306	g4187	i0	29.2	0.622309197651663	106	66	59.9	4	23	328	155	255	WP_193867723.1 ABC transporter ATP-binding protein/permease [Planktothrix mougeotii]	diamond	318	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix mougeotii
29159173	29159173	PRJNA352610_P_NODE_17689_length_295_cov_1.653153_g17628_i0	PRJNA352610	17689	295	1.653153	4.87680135	Dolichospermum sp.	2720786	Bacteria	Bacteria	47	3.42e-4	NR	MFM6701535.1	2720786	g17628	i0	47.6	0.640677966101695	63	31	62	2	206	24	30	92	MFM6701535.1 hypothetical protein [Dolichospermum sp.]	diamond	189	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
29537809	29537809	PRJNA352610_P_NODE_16830_length_302_cov_1.008734_g16769_i0	PRJNA352610	16830	302	1.008734	3.04637668	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	43.1	0.0293	NR	MEY3867867.1	2847862	g16769	i0	37.5	1.20198675496689	48	30	47.7	0	5	148	69	116	MEY3867867.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	363	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29600759	29600759	PRJNA352610_P_NODE_4170_length_515_cov_1.257919_g4109_i0	PRJNA352610	4170	515	1.257919	6.47828285	Calothrix sp. MO_192.B10	3036784	Bacteria	Bacteria	153	1.95e-44	NR	MDJ0619854.1	3036784	g4109	i0	63.8	2.15533980582524	127	44	72.8	2	3	377	13	139	MDJ0619854.1 profilin [Calothrix sp. MO_192.B10]	diamond	1110	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. MO_192.B10
29727063	29727063	PRJNA352610_P_NODE_22010_length_268_cov_1.528205_g21949_i0	PRJNA352610	22010	268	1.528205	4.0955894	Romeriopsis navalis	2992132	Bacteria	Bacteria	48.9	2.59e-4	NR	WP_264326716.1	2992132	g21949	i0	35.1	1.69029850746269	77	33	86.2	1	264	34	51	110	WP_264326716.1 glutathione S-transferase family protein [Romeriopsis navalis]	diamond	453	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Romeriopsis	Romeriopsis navalis
30801363	30801363	PRJNA352610_P_NODE_27234_length_248_cov_0.880000_g27173_i0	PRJNA352610	27234	248	0.88	2.1824	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	82.4	4.32e-16	NR	HEY9780274.1	3088178	g27173	i0	55	0.967741935483871	80	35	95.6	1	245	9	44	123	HEY9780274.1 GAF domain-containing protein [Leptolyngbyaceae cyanobacterium]	diamond	240	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
31623366	31623366	PRJNA352610_P_NODE_29756_length_244_cov_0.900585_g29695_i0	PRJNA352610	29756	244	0.900585	2.1974274	Amazonocrinis nigriterrae	2840443	Bacteria	Bacteria	128	3.3099999999999995e-32	NR	WP_198125450.1	2840443	g29695	i0	74.7	3.87295081967213	79	17	97.1	1	242	6	225	300	WP_198125450.1 N,N-dimethylformamidase beta subunit family domain-containing protein [Amazonocrinis nigriterrae]	diamond	945	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Amazonocrinis	Amazonocrinis nigriterrae

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