metadata: contig_metadata: 25 rows where bioproject = "PRJNA1016321" and tax_clade = "Cyanobacteriota/Melainabacteria group"

25 rows where bioproject = "PRJNA1016321" 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
1002726	1002726	PRJNA1016321_P_NODE_16761_length_475_cov_4.527363_g16531_i0	PRJNA1016321	16761	475	4.527363	21.50497425	Oscillatoriales	1150	Bacteria	Bacteria	817	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g16531	i0	98.911	172.061052631579	459	1	96	3	19	473	812400	812858	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	81729	817	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
3553317	3553317	PRJNA1016321_P_NODE_46323_length_255_cov_4.714286_g46092_i0	PRJNA1016321	46323	255	4.714286	12.0214293	Planktothrix	54304	Bacteria	Bacteria	446	9.1e-121	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g46092	i0	100	156.294117647059	241	0	95	0	1	241	622252	622012	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	39855	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
8655915	8655915	PRJNA1016321_P_NODE_44607_length_262_cov_1.529101_g44376_i0	PRJNA1016321	44607	262	1.529101	4.00624462	root	1	Root_unresolved	Root_unresolved	472	1.55e-128	NTclustered	gi\|1241187607\|dbj\|LC319764.1\|	1160	g44376	i0	100	109.007633587786	255	0	97	0	1	255	762	508	Planktothrix agardhii gene for 16S ribosomal RNA, partial sequence, strain: NIES-1265	blastn	28560	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
9930847	9930847	PRJNA1016321_P_NODE_57728_length_226_cov_2.013072_g57497_i0	PRJNA1016321	57728	226	2.013072	4.54954272	Nostoc	1177	Bacteria	Bacteria	196	8.78e-46	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g57497	i0	83.105	7.86283185840708	219	33	96	2	1	217	5553524	5553740	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	1777	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
11206007	11206007	PRJNA1016321_P_NODE_38029_length_288_cov_1.772093_g37798_i0	PRJNA1016321	38029	288	1.772093	5.10362784	Planktothrix	54304	Bacteria	Bacteria	514	2.83e-141	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g37798	i0	99.645	173.493055555556	282	0	98	1	8	288	623231	622950	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	49966	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
11638602	11638602	PRJNA1016321_P_NODE_56270_length_241_cov_0.916667_g56039_i0	PRJNA1016321	56270	241	0.916667	2.20916747	Pleurocapsa	44474	Bacteria	Bacteria	131	9.97e-34	NR	WP_106241728.1	2107688	g56039	i0	83.5	10.804979253112	79	13	98.3	0	2	238	53	131	WP_106241728.1 ABC transporter ATP-binding protein [Pleurocapsa sp. CCALA 161]	diamond	2604	132	0.992424242424242	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. CCALA 161
14188682	14188682	PRJNA1016321_P_NODE_7052_length_768_cov_4.617266_g6853_i0	PRJNA1016321	7052	768	4.617266	35.46060288	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	1147	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g6853	i0	94.071	198.950520833333	759	40	99	5	12	768	9969837	9969082	Calothrix sp. PCC 7716 DNA, complete genome	blastn	152794	1147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
19285394	19285394	PRJNA1016321_P_NODE_41556_length_274_cov_1.144279_g41325_i0	PRJNA1016321	41556	274	1.144279	3.13532446	Stanieria cyanosphaera	102116	Bacteria	Bacteria	451	2.12e-122	NTclustered	gi\|428272017\|gb\|CP003654.1\|	111780	g41325	i0	96.35	1	274	10	100	0	1	274	208304	208577	Stanieria cyanosphaera PCC 7437 plasmid pSTA7437.01, complete sequence	blastn	274	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
20129107	20129107	PRJNA1016321_P_NODE_21336_length_410_cov_2.231454_g21105_i0	PRJNA1016321	21336	410	2.231454	9.1489614	Chroococcidiopsis	54298	Bacteria	Bacteria	728	0	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g21105	i0	99.748	132.375609756098	397	1	97	0	1	397	2947	3343	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	54274	728	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
21835985	21835985	PRJNA1016321_P_NODE_13138_length_546_cov_3.976744_g12915_i0	PRJNA1016321	13138	546	3.976744	21.71302224	Dulcicalothrix desertica	32056	Bacteria	Bacteria	773	0	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g12915	i0	92.91	204.531135531136	536	30	98	6	1	535	9	537	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	111674	773	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
24385691	24385691	PRJNA1016321_P_NODE_3620_length_1064_cov_5.580222_g3470_i0	PRJNA1016321	3620	1064	5.580222	59.37356208	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	1622	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g3470	i0	95.068	214.332706766917	1034	46	97	5	22	1051	3670366	3669334	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	228050	1622	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
26749573	26749573	PRJNA1016321_P_NODE_33961_length_308_cov_2.953191_g33730_i0	PRJNA1016321	33961	308	2.953191	9.09582828	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	173	1.05e-51	NR	MBN9395106.1	2052166	g33730	i0	96.7	0.886363636363636	91	3	88.6	0	28	300	1	91	MBN9395106.1 response regulator transcription factor [Candidatus Melainabacteria bacterium]	diamond	273	173	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26845244	26845244	PRJNA1016321_P_NODE_56761_length_237_cov_3.463415_g56530_i0	PRJNA1016321	56761	237	3.463415	8.20829355	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	124	9.33e-31	NR	MBX9674316.1	2364082	g56530	i0	98.4	0.784810126582278	62	1	78.5	0	3	188	1010	1071	MBX9674316.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	186	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
26971465	26971465	PRJNA1016321_P_NODE_53742_length_244_cov_0.900585_g53511_i0	PRJNA1016321	53742	244	0.900585	2.1974274	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	164	2.48e-46	NR	HEY9757364.1	3088181	g53511	i0	100	0.983606557377049	80	0	98.4	0	3	242	191	270	HEY9757364.1 PLP-dependent transferase [Oculatellaceae cyanobacterium]	diamond	240	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27256090	27256090	PRJNA1016321_P_NODE_44303_length_263_cov_1.621053_g44072_i0	PRJNA1016321	44303	263	1.621053	4.26336939	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	181	2.8599999999999996e-56	NR	MBN9396101.1	2052166	g44072	i0	100	0.992395437262357	87	0	99.2	0	2	262	54	140	MBN9396101.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	261	181	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27666899	27666899	PRJNA1016321_P_NODE_52924_length_245_cov_0.895349_g52693_i0	PRJNA1016321	52924	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	93.6	4.33e-20	NR	MBX9672592.1	2364082	g52693	i0	97.9	0.575510204081633	47	1	57.6	0	162	22	179	225	MBX9672592.1 HAMP domain-containing histidine kinase [Candidatus Obscuribacterales bacterium]	diamond	141	93.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27761729	27761729	PRJNA1016321_P_NODE_56644_length_239_cov_2.783133_g56413_i0	PRJNA1016321	56644	239	2.783133	6.65168787	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	95.9	1.26e-23	NR	WP_106367560.1	2107693	g56413	i0	86.5	0.652719665271967	52	7	65.3	0	157	2	1	52	WP_106367560.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	156	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
28424633	28424633	PRJNA1016321_P_NODE_54206_length_243_cov_1.382353_g53975_i0	PRJNA1016321	54206	243	1.382353	3.35911779	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	104	6.240000000000001e-26	NR	MBN9394593.1	2052166	g53975	i0	98.1	0.641975308641975	52	1	64.2	0	174	19	1	52	MBN9394593.1 GTP cyclohydrolase I FolE [Candidatus Melainabacteria bacterium]	diamond	156	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28740272	28740272	PRJNA1016321_P_NODE_52807_length_245_cov_0.895349_g52576_i0	PRJNA1016321	52807	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	73.6	5.22e-13	NR	HEY9791152.1	2364082	g52576	i0	53.2	0.759183673469388	62	29	75.9	0	226	41	331	392	HEY9791152.1 DDE-type integrase/transposase/recombinase [Candidatus Obscuribacterales bacterium]	diamond	186	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29087721	29087721	PRJNA1016321_P_NODE_42168_length_271_cov_1.555556_g41937_i0	PRJNA1016321	42168	271	1.555556	4.21555676	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	173	3.19e-49	NR	MBN9393660.1	2052166	g41937	i0	97.8	0.996309963099631	90	2	99.6	0	270	1	317	406	MBN9393660.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	270	173	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29687145	29687145	PRJNA1016321_P_NODE_55150_length_242_cov_0.911243_g54919_i0	PRJNA1016321	55150	242	0.911243	2.20520806	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	125	1.1299999999999998e-31	NR	MDJ0595363.1	3036786	g54919	i0	90	0.991735537190083	80	8	99.2	0	2	241	241	320	MDJ0595363.1 alanine/glycine:cation symporter family protein [Pleurocapsa sp. MO_226.B13]	diamond	240	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
31298756	31298756	PRJNA1016321_P_NODE_44195_length_263_cov_3.000000_g43964_i0	PRJNA1016321	44195	263	3	7.89	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	122	1.39e-34	NR	HEY9760802.1	3088181	g43964	i0	100	0.695817490494297	61	0	69.6	0	185	3	1	61	HEY9760802.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	183	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
32057946	32057946	PRJNA1016321_P_NODE_40198_length_279_cov_2.087379_g39967_i0	PRJNA1016321	40198	279	2.087379	5.82378741	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	45.8	0.00475	NR	MBN9394940.1	2052166	g39967	i0	100	0.193548387096774	18	0	19.4	0	56	3	1	18	MBN9394940.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Melainabacteria bacterium]	diamond	54	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32437929	32437929	PRJNA1016321_P_NODE_49819_length_249_cov_0.875000_g49588_i0	PRJNA1016321	49819	249	0.875	2.17875	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	164	4.399999999999998e-47	NR	HEY9760500.1	3088181	g49588	i0	100	0.987951807228916	82	0	98.8	0	248	3	280	361	HEY9760500.1 hydroxymethylglutaryl-CoA reductase [Oculatellaceae cyanobacterium]	diamond	246	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
32713868	32713868	PRJNA1016321_P_NODE_54480_length_243_cov_0.905882_g54249_i0	PRJNA1016321	54480	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	137	1.3e-35	NR	HAX79343.1	2055768	g54249	i0	83.5	4.91358024691358	79	13	97.5	0	238	2	194	272	HAX79343.1 hypothetical protein [Cyanobacteria bacterium UBA11372]	diamond	1194	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11372

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