metadata: contig_metadata: 23 rows where bioproject = "PRJNA1132896" and tax_clade = "Cyanobacteriota/Melainabacteria group"

23 rows where bioproject = "PRJNA1132896" 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
5386817	5386817	PRJNA1132896_P_NODE_2845_length_330_cov_1.198444_g2754_i0	PRJNA1132896	2845	330	1.198444	3.9548652	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	593	4.119999999999999e-165	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g2754	i0	99.091	113.324242424242	330	3	100	0	1	330	2581	2252	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37397	593	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19409501	19409501	PRJNA1132896_P_NODE_2496_length_348_cov_1.320000_g2405_i0	PRJNA1132896	2496	348	1.32	4.5936	Stanieria cyanosphaera PCC 7437	111780	Bacteria	Bacteria	154	2.2099999999999993e-43	NR	CAC81002.1	111780	g2405	i0	74.5	0.948275862068966	110	28	94.8	0	348	19	191	300	CAC81002.1 NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating), partial [Stanieria cyanosphaera PCC 7437]	diamond	330	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
24509586	24509586	PRJNA1132896_P_NODE_5640_length_265_cov_2.218750_g5549_i0	PRJNA1132896	5640	265	2.21875	5.8796875	Synechococcus sp. CBW1107	2789857	Bacteria	Bacteria	137	6.5e-28	NTclustered	gi\|2638498304\|emb\|OY986430.1\|	2789857	g5549	i0	79	13.577358490566	200	42	75	0	14	213	1782203	1782402	Synechococcus sp. CBW1107 isolate KAC_114 genome assembly, chromosome: 1	blastn	3598	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
25258084	25258084	PRJNA1132896_P_NODE_5380_length_269_cov_1.556122_g5289_i0	PRJNA1132896	5380	269	1.556122	4.18596818	Chroococcidiopsis	54298	Bacteria	Bacteria	464	2.67e-126	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g5289	i0	97.77	178.60594795539	269	6	100	0	1	269	3162	2894	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	48045	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
26849009	26849009	PRJNA1132896_P_NODE_6181_length_258_cov_1.470270_g6090_i0	PRJNA1132896	6181	258	1.47027	3.7932966	Cyanobacteria bacterium J06634_5	3023198	Bacteria	Bacteria	72.4	1.48e-12	NR	MEO1392645.1	3023198	g6090	i0	46.9	0.941860465116279	81	42	93	1	16	255	88	168	MEO1392645.1 hypothetical protein [Cyanobacteria bacterium J06634_5]	diamond	243	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06634_5
27164989	27164989	PRJNA1132896_P_NODE_4942_length_276_cov_1.137931_g4851_i0	PRJNA1132896	4942	276	1.137931	3.14068956	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	87.4	8.15e-20	NR	MBX9695543.1	2847862	g4851	i0	93.2	0.478260869565217	44	3	47.8	0	145	276	1	44	MBX9695543.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	132	87.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28133421	28133421	PRJNA1132896_P_NODE_3885_length_290_cov_1.912442_g3794_i0	PRJNA1132896	3885	290	1.912442	5.5460818	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	97.1	2.44e-22	NR	WP_200327281.1	459663	g3794	i0	50	1.97586206896552	96	44	99.3	2	3	290	6	97	WP_200327281.1 SDR family oxidoreductase [Sphaerospermopsis aphanizomenoides]	diamond	573	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis aphanizomenoides
28333612	28333612	PRJNA1132896_P_NODE_9546_length_243_cov_0.905882_g9455_i0	PRJNA1132896	9546	243	0.905882	2.20129326	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	52.8	4.89e-6	NR	MBL8086383.1	2711154	g9455	i0	43	0.975308641975309	79	37	97.5	1	1	237	65	135	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	237	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28396773	28396773	PRJNA1132896_P_NODE_4306_length_284_cov_2.715640_g4215_i0	PRJNA1132896	4306	284	2.71564	7.7124176	Candidatus Obscuribacter phosphatis	1906157	Bacteria	Bacteria	61.2	1.9e-8	NR	MBN8662132.1	1906157	g4215	i0	36.5	1.01408450704225	96	56	97.2	3	283	8	437	531	MBN8662132.1 TerD family protein [Candidatus Obscuribacter phosphatis]	diamond	288	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter phosphatis
28523197	28523197	PRJNA1132896_P_NODE_8767_length_245_cov_0.895349_g8676_i0	PRJNA1132896	8767	245	0.895349	2.19360505	Synechococcus sp.	1131	Bacteria	Bacteria	117	8.11e-29	NR	MEB3202796.1	1131	g8676	i0	69.7	0.930612244897959	76	23	93.1	0	236	9	343	418	MEB3202796.1 hypothetical protein [Synechococcus sp.]	diamond	228	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
28554832	28554832	PRJNA1132896_P_NODE_9527_length_243_cov_0.905882_g9436_i0	PRJNA1132896	9527	243	0.905882	2.20129326	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	169	2.43e-49	NR	HEY9682826.1	3088181	g9436	i0	100	1	81	0	100	0	243	1	220	300	HEY9682826.1 peptidoglycan bridge formation glycyltransferase FemA/FemB family protein [Oculatellaceae cyanobacterium]	diamond	243	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28670138	28670138	PRJNA1132896_P_NODE_8367_length_246_cov_1.728324_g8276_i0	PRJNA1132896	8367	246	1.728324	4.25167704	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	95.9	9.03e-22	NR	WP_036482484.1	1541065	g8276	i0	56.1	3	82	32	100	2	1	246	195	272	WP_036482484.1 S-formylglutathione hydrolase [Myxosarcina sp. GI1]	diamond	738	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. GI1
28775600	28775600	PRJNA1132896_P_NODE_9987_length_242_cov_0.911243_g9896_i0	PRJNA1132896	9987	242	0.911243	2.20520806	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	155	1.14e-41	NR	MDR3615325.1	2364082	g9896	i0	90	0.991735537190083	80	8	99.2	0	1	240	759	838	MDR3615325.1 TonB-dependent receptor [Candidatus Obscuribacterales bacterium]	diamond	240	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29186350	29186350	PRJNA1132896_P_NODE_10309_length_241_cov_0.916667_g10218_i0	PRJNA1132896	10309	241	0.916667	2.20916747	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	142	3.0599999999999995e-37	NR	HEY9756534.1	3088181	g10218	i0	91.1	0.983402489626556	79	7	98.3	0	238	2	284	362	HEY9756534.1 C2 family cysteine protease [Oculatellaceae cyanobacterium]	diamond	237	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29312448	29312448	PRJNA1132896_P_NODE_8229_length_247_cov_0.885057_g8138_i0	PRJNA1132896	8229	247	0.885057	2.18609079	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	181	1.22e-52	NR	HEY9683813.1	3088181	g8138	i0	100	0.995951417004049	82	0	99.6	0	246	1	144	225	HEY9683813.1 TIGR03936 family radical SAM-associated protein [Oculatellaceae cyanobacterium]	diamond	246	181	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
29912570	29912570	PRJNA1132896_P_NODE_8211_length_247_cov_0.885057_g8120_i0	PRJNA1132896	8211	247	0.885057	2.18609079	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	153	8.02e-45	NR	MDR3613645.1	2364082	g8120	i0	79	0.983805668016194	81	17	98.4	0	4	246	119	199	MDR3613645.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	243	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29944091	29944091	PRJNA1132896_P_NODE_9491_length_243_cov_0.905882_g9400_i0	PRJNA1132896	9491	243	0.905882	2.20129326	Halothece sp. Uz-M2-17	3074377	Bacteria	Bacteria	60.1	6.79e-9	NR	MDR9405380.1	3074377	g9400	i0	68.4	0.469135802469136	38	12	46.9	0	233	120	128	165	MDR9405380.1 hypothetical protein [Halothece sp. Uz-M2-17]	diamond	114	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Halothece	Halothece sp. Uz-M2-17
30691243	30691243	PRJNA1132896_P_NODE_5053_length_274_cov_1.353234_g4962_i0	PRJNA1132896	5053	274	1.353234	3.70786116	Bacillati	1783272	Bacteria	Bacteria	157	3.65e-43	NR	MBK9143677.1	2052166	g4962	i0	85.7	4.98175182481752	91	13	99.6	0	274	2	352	442	MBK9143677.1 arginine--tRNA ligase [Candidatus Melainabacteria bacterium]	diamond	1365	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31144145	31144145	PRJNA1132896_P_NODE_8635_length_246_cov_0.890173_g8544_i0	PRJNA1132896	8635	246	0.890173	2.18982558	Spirulinaceae cyanobacterium SM2_1_0	2720463	Bacteria	Bacteria	50.1	1.05e-4	NR	NJL03205.1	2720463	g8544	i0	31.6	0.963414634146341	79	50	91.5	1	225	1	236	314	NJL03205.1 hypothetical protein [Spirulinaceae cyanobacterium SM2_1_0]	diamond	237	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae		Spirulinaceae cyanobacterium SM2_1_0
31429126	31429126	PRJNA1132896_P_NODE_7376_length_249_cov_1.687500_g7285_i0	PRJNA1132896	7376	249	1.6875	4.201875	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	140	7.45e-41	NR	HEY9681203.1	3088181	g7285	i0	100	0.879518072289157	73	0	88	0	1	219	60	132	HEY9681203.1 tetratricopeptide repeat protein [Oculatellaceae cyanobacterium]	diamond	219	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
31618930	31618930	PRJNA1132896_P_NODE_7976_length_248_cov_0.880000_g7885_i0	PRJNA1132896	7976	248	0.88	2.1824	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	103	1.32e-24	NR	HEY9758655.1	3088181	g7885	i0	94.7	0.689516129032258	57	3	69	0	173	3	40	96	HEY9758655.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	171	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
32599653	32599653	PRJNA1132896_P_NODE_10080_length_241_cov_1.565476_g9989_i0	PRJNA1132896	10080	241	1.565476	3.77279716	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	83.6	6.95e-18	NR	MBL8086383.1	2711154	g9989	i0	74.1	0.672199170124481	54	13	66	1	160	2	90	143	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	162	83.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32725545	32725545	PRJNA1132896_P_NODE_3160_length_316_cov_0.950617_g3069_i0	PRJNA1132896	3160	316	0.950617	3.00394972	Dolichospermum sp.	2720786	Bacteria	Bacteria	70.1	1.89e-11	NR	MFO0056101.1	2720786	g3069	i0	44.1	2.65822784810127	68	38	64.6	0	57	260	209	276	MFO0056101.1 hypothetical protein [Dolichospermum sp.]	diamond	840	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.

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