metadata: contig_metadata: 24 rows where bioproject = "PRJNA335774" and tax_clade = "Cyanobacteriota/Melainabacteria group"

24 rows where bioproject = "PRJNA335774" 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
1664769	1664769	PRJNA335774_P_NODE_17442_length_363_cov_1.058621_g17290_i0	PRJNA335774	17442	363	1.058621	3.84279423	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	627	4.499999999999999e-175	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g17290	i0	97.802	241.763085399449	364	6	100	2	1	363	1859013	1858651	Calothrix sp. PCC 7716 DNA, complete genome	blastn	87760	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
1665370	1665370	PRJNA335774_P_NODE_44122_length_246_cov_0.878613_g43970_i0	PRJNA335774	44122	246	0.878613	2.16138798	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g43970	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.
2344892	2344892	PRJNA335774_P_NODE_23702_length_319_cov_1.166667_g23550_i0	PRJNA335774	23702	319	1.166667	3.72166773	Microcoleus	44471	Bacteria	Bacteria	566	8.64e-157	NTclustered	gi\|1804756945\|gb\|MT013207.1\|	2705320	g23550	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
8722206	8722206	PRJNA335774_P_NODE_31947_length_279_cov_1.320388_g31795_i0	PRJNA335774	31947	279	1.320388	3.68388252	Microcoleus	44471	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g31795	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
11272906	11272906	PRJNA335774_P_NODE_43449_length_246_cov_0.953757_g43297_i0	PRJNA335774	43449	246	0.953757	2.34624222	Oscillatoriales	1150	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g43297	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
20195774	20195774	PRJNA335774_P_NODE_42596_length_247_cov_0.885057_g42444_i0	PRJNA335774	42596	247	0.885057	2.18609079	Tolypothrix	111782	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2316438351\|gb\|CP064879.1\|	1188	g42444	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
24616536	24616536	PRJNA335774_P_NODE_30400_length_285_cov_2.452830_g30248_i0	PRJNA335774	30400	285	2.45283	6.9905655	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	516	7.77e-142	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g30248	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
26694693	26694693	PRJNA335774_P_NODE_36021_length_262_cov_1.222222_g35869_i0	PRJNA335774	36021	262	1.222222	3.20222164	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	42.7	0.0357	NR	MFM7447249.1	3088178	g35869	i0	37.5	0.641221374045801	56	34	63	1	54	218	82	137	MFM7447249.1 DUF6444 domain-containing protein [Leptolyngbyaceae cyanobacterium]	diamond	168	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
27043058	27043058	PRJNA335774_P_NODE_5122_length_611_cov_1.280669_g4976_i0	PRJNA335774	5122	611	1.280669	7.82488759	Acaryochloris thomasi	2929456	Bacteria	Bacteria	72.8	3.45e-11	NR	WP_110988953.1	2929456	g4976	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
27327588	27327588	PRJNA335774_P_NODE_30943_length_283_cov_1.466667_g30791_i0	PRJNA335774	30943	283	1.466667	4.15066761	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	75.9	9.07e-14	NR	HMW91886.1	2711154	g30791	i0	43	1.97173144876325	93	50	98.6	2	4	282	96	185	HMW91886.1 DUF4419 domain-containing protein [Candidatus Obscuribacter sp.]	diamond	558	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27454089	27454089	PRJNA335774_P_NODE_44343_length_245_cov_0.994186_g44191_i0	PRJNA335774	44343	245	0.994186	2.4357557	Aphanocapsa feldmannii 277cV	2507553	Bacteria	Bacteria	41.6	0.0373	NR	TGG91043.1	2507553	g44191	i0	32.3	0.759183673469388	62	40	75.9	1	23	208	18	77	TGG91043.1 MAG: NIPSNAP family protein [Aphanocapsa feldmannii 277cV]	diamond	186	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Aphanocapsa	Aphanocapsa feldmannii
27738395	27738395	PRJNA335774_P_NODE_9084_length_478_cov_1.190123_g8932_i0	PRJNA335774	9084	478	1.190123	5.68878794	Anabaena subtropica	425380	Bacteria	Bacteria	45.1	0.0491	NR	WP_190405085.1	425380	g8932	i0	34.5	0.364016736401674	58	36	36.4	1	39	212	165	220	WP_190405085.1 glycosyltransferase family 8 protein [Anabaena subtropica]	diamond	174	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena subtropica
29348407	29348407	PRJNA335774_P_NODE_34529_length_268_cov_1.528205_g34377_i0	PRJNA335774	34529	268	1.528205	4.0955894	Romeriopsis navalis	2992132	Bacteria	Bacteria	48.9	2.59e-4	NR	WP_264326716.1	2992132	g34377	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
29600600	29600600	PRJNA335774_P_NODE_2770_length_781_cov_3.180791_g2641_i0	PRJNA335774	2770	781	3.180791	24.84197771	Okeania sp. SIO3B5	2607811	Bacteria	Bacteria	67.4	2.79e-9	NR	WP_293075235.1	2607811	g2641	i0	29.4	0.745198463508323	194	113	67.6	6	235	762	8	195	WP_293075235.1 hypothetical protein [Okeania sp. SIO3B5]	diamond	582	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO3B5
29790142	29790142	PRJNA335774_P_NODE_11231_length_436_cov_2.812672_g11079_i0	PRJNA335774	11231	436	2.812672	12.26324992	Dolichospermum sp.	2720786	Bacteria	Bacteria	206	1.09e-64	NR	MFM6777601.1	2720786	g11079	i0	72.1	2.91743119266055	140	36	94.3	1	434	24	73	212	MFM6777601.1 hypothetical protein [Dolichospermum sp.]	diamond	1272	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
30296249	30296249	PRJNA335774_P_NODE_26852_length_302_cov_1.008734_g26700_i0	PRJNA335774	26852	302	1.008734	3.04637668	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	43.1	0.0293	NR	MEY3867867.1	2847862	g26700	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
30611624	30611624	PRJNA335774_P_NODE_45553_length_244_cov_0.900585_g45401_i0	PRJNA335774	45553	244	0.900585	2.1974274	Amazonocrinis nigriterrae	2840443	Bacteria	Bacteria	128	3.3099999999999995e-32	NR	WP_198125450.1	2840443	g45401	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
30896299	30896299	PRJNA335774_P_NODE_7594_length_515_cov_1.257919_g7442_i0	PRJNA335774	7594	515	1.257919	6.47828285	Calothrix sp. MO_192.B10	3036784	Bacteria	Bacteria	153	1.95e-44	NR	MDJ0619854.1	3036784	g7442	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
31465343	31465343	PRJNA335774_P_NODE_28216_length_295_cov_1.653153_g28064_i0	PRJNA335774	28216	295	1.653153	4.87680135	Dolichospermum sp.	2720786	Bacteria	Bacteria	47	3.42e-4	NR	MFM6701535.1	2720786	g28064	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.
31988441	31988441	PRJNA335774_P_NODE_19618_length_345_cov_1.132353_g19466_i0	PRJNA335774	19618	345	1.132353	3.90661785	Bacteria	2	Bacteria	Bacteria	160	3.46e-45	NR	MBR8836957.1	221294	g19466	i0	71.3	13.4782608695652	108	31	93.9	0	20	343	137	244	MBR8836957.1 alkene reductase [Stigonema ocellatum SAG 48.90 = DSM 106950]	diamond	4650	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Stigonema	Stigonema ocellatum
32034548	32034548	PRJNA335774_P_NODE_41878_length_248_cov_0.880000_g41726_i0	PRJNA335774	41878	248	0.88	2.1824	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	82.4	4.32e-16	NR	HEY9780274.1	3088178	g41726	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
32446084	32446084	PRJNA335774_P_NODE_5859_length_576_cov_1.809145_g5709_i0	PRJNA335774	5859	576	1.809145	10.4206752	Moorena sp. SIOASIH	2607817	Bacteria	Bacteria	127	7.7e-34	NR	WP_293091305.1	2607817	g5709	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
32824319	32824319	PRJNA335774_P_NODE_7720_length_511_cov_1.397260_g7568_i0	PRJNA335774	7720	511	1.39726	7.1399986	Planktothrix mougeotii	54306	Bacteria	Bacteria	45.8	0.04	NR	WP_193867723.1	54306	g7568	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
32841366	32841366	PRJNA335774_P_NODE_30720_length_284_cov_1.350711_g30568_i0	PRJNA335774	30720	284	1.350711	3.83601924	Bacillati	1783272	Bacteria	Bacteria	46.6	0.00268	NR	WP_015200734.1	1170562	g30568	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

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