metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJEB36940" and tax_clade = "Cyanobacteriota/Melainabacteria group"

26 rows where analysis = "diamond", bioproject = "PRJEB36940" 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
5159145	5159145	PRJEB36940_P_NODE_4285_length_413_cov_0.941176_g4156_i0	PRJEB36940	4285	413	0.941176	3.88705688	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	56.2	1.41e-6	NR	MBL8086383.1	2711154	g4156	i0	69.2	0.283292978208232	39	12	28.3	0	1	117	106	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	117	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
11534893	11534893	PRJEB36940_P_NODE_12270_length_253_cov_0.866667_g12141_i0	PRJEB36940	12270	253	0.866667	2.19266751	Cyanophyceae	3028117	Bacteria	Bacteria	155	9.87e-42	NR	WP_058997311.1	1552121	g12141	i0	92.8	9.84189723320158	83	6	98.4	0	3	251	830	912	WP_058997311.1 carbamoyl-phosphate synthase large subunit [Leptolyngbya sp. NIES-2104]	diamond	2490	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-2104
13742465	13742465	PRJEB36940_P_NODE_6551_length_337_cov_0.867424_g6422_i0	PRJEB36940	6551	337	0.867424	2.92321888	root	1	Root_unresolved	Root_unresolved	137	4.069999999999999e-35	NR	TAD74245.1	1151	g6422	i0	62.2	4.9406528189911	111	40	98.8	1	5	337	56	164	TAD74245.1 MAG: arginine--tRNA ligase [Oscillatoriales cyanobacterium]	diamond	1665	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
27096491	27096491	PRJEB36940_P_NODE_7322_length_319_cov_1.902439_g7193_i0	PRJEB36940	7322	319	1.902439	6.06878041	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	99.8	9.22e-23	NR	MBX9693408.1	2847862	g7193	i0	68.1	0.884012539184953	94	19	82.8	3	2	265	17	105	MBX9693408.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	282	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27697107	27697107	PRJEB36940_P_NODE_12484_length_252_cov_0.871508_g12355_i0	PRJEB36940	12484	252	0.871508	2.19620016	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	114	7.349999999999998e-30	NR	MBL8086383.1	2711154	g12355	i0	71.4	1	84	23	100	1	1	252	61	143	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	252	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28139052	28139052	PRJEB36940_P_NODE_6745_length_332_cov_1.204633_g6616_i0	PRJEB36940	6745	332	1.204633	3.99938156	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	79.7	6.66e-16	NR	MBL8086383.1	2711154	g6616	i0	68.3	0.569277108433735	63	16	53.3	1	155	331	61	123	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	189	79.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28233244	28233244	PRJEB36940_P_NODE_5446_length_367_cov_1.085034_g5317_i0	PRJEB36940	5446	367	1.085034	3.98207478	Leptolyngbyaceae cyanobacterium C42_A2020_001	2811131	Bacteria	Bacteria	65.9	9.48e-10	NR	MBF2028644.1	2811131	g5317	i0	40.3	5.01089918256131	72	43	58.9	0	120	335	21	92	MBF2028644.1 fatty acid desaturase [Leptolyngbyaceae cyanobacterium C42_A2020_001]	diamond	1839	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium C42_A2020_001
28833381	28833381	PRJEB36940_P_NODE_10728_length_268_cov_2.820513_g10599_i0	PRJEB36940	10728	268	2.820513	7.55897484	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	102	1.03e-23	NR	MBX9692038.1	2847862	g10599	i0	62.8	0.873134328358209	78	28	86.2	1	232	2	4	81	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	234	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28864939	28864939	PRJEB36940_P_NODE_15468_length_243_cov_0.917647_g15339_i0	PRJEB36940	15468	243	0.917647	2.22988221	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	50.1	9.43e-5	NR	MCM1044743.1	2137880	g15339	i0	38.8	1.7037037037037	67	41	82.7	0	209	9	53	119	MCM1044743.1 WG repeat-containing protein [Candidatus Gastranaerophilales bacterium]	diamond	414	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
28991620	28991620	PRJEB36940_P_NODE_9788_length_279_cov_1.674757_g9659_i0	PRJEB36940	9788	279	1.674757	4.67257203	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	111	1.82e-28	NR	MBX9690857.1	2847862	g9659	i0	86.5	0.559139784946237	52	7	55.9	0	158	3	3	54	MBX9690857.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	156	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29054583	29054583	PRJEB36940_P_NODE_6888_length_329_cov_1.214844_g6759_i0	PRJEB36940	6888	329	1.214844	3.99683676	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	144	1.22e-41	NR	MEB3284465.1	2762020	g6759	i0	73.4	12.9483282674772	94	25	85.7	0	287	6	2	95	MEB3284465.1 nucleoside-diphosphate kinase [Candidatus Sericytochromatia bacterium]	diamond	4260	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29117773	29117773	PRJEB36940_P_NODE_8489_length_297_cov_1.732143_g8360_i0	PRJEB36940	8489	297	1.732143	5.14446471	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	162	2.42e-48	NR	MBX9690857.1	2847862	g8360	i0	75.8	1	99	23	100	1	297	1	66	163	MBX9690857.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	297	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29149550	29149550	PRJEB36940_P_NODE_6749_length_332_cov_1.196911_g6620_i0	PRJEB36940	6749	332	1.196911	3.97374452	Oscillatoria sp. FACHB-14	1159	Bacteria	Bacteria	89.7	3.47e-18	NR	WP_190712339.1	2692846	g6620	i0	45	0.903614457831325	100	54	89.5	1	331	35	122	221	WP_190712339.1 colicin uptake protein [Oscillatoria sp. FACHB-1406]	diamond	300	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. FACHB-1406
29401752	29401752	PRJEB36940_P_NODE_7689_length_312_cov_1.297071_g7560_i0	PRJEB36940	7689	312	1.297071	4.04686152	Cyanobacteria bacterium J06635_10	3023201	Bacteria	Bacteria	43.1	0.0499	NR	MEO1373427.1	3023201	g7560	i0	33.3	0.836538461538462	87	56	82.7	2	13	270	46	131	MEO1373427.1 CAP domain-containing protein [Cyanobacteria bacterium J06635_10]	diamond	261	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06635_10
29401753	29401753	PRJEB36940_P_NODE_8469_length_298_cov_0.880000_g8340_i0	PRJEB36940	8469	298	0.88	2.6224	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	76.6	2.37e-14	NR	MBX9693789.1	2847862	g8340	i0	76.9	0.523489932885906	52	12	52.3	0	158	3	4	55	MBX9693789.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	156	76.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29653964	29653964	PRJEB36940_P_NODE_7110_length_324_cov_1.231076_g6981_i0	PRJEB36940	7110	324	1.231076	3.98868624	Potamolinea sp.	3100419	Bacteria	Bacteria	99	1.78e-21	NR	MFB8788235.1	3100419	g6981	i0	51.4	0.990740740740741	107	52	99.1	0	2	322	756	862	MFB8788235.1 colicin uptake protein [Potamolinea sp.]	diamond	321	99	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Potamolinea	Potamolinea sp.
30127828	30127828	PRJEB36940_P_NODE_3332_length_465_cov_1.130102_g3204_i0	PRJEB36940	3332	465	1.130102	5.2549743	Hassallia sp. WJT32-NPBG1	2835088	Bacteria	Bacteria	75.9	1.08e-12	NR	MBW4609009.1	2835088	g3204	i0	34.6	1.98709677419355	153	79	98.1	4	1	456	409	541	MBW4609009.1 Dyp-type peroxidase [Hassallia sp. WJT32-NPBG1]	diamond	924	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia sp. WJT32-NPBG1
30184674	30184674	PRJEB36940_P_NODE_10772_length_268_cov_1.364103_g10643_i0	PRJEB36940	10772	268	1.364103	3.65579604	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	62	3.91e-9	NR	WP_096566227.1	752201	g10643	i0	43.5	2.75373134328358	85	39	88.4	2	11	247	132	213	WP_096566227.1 MULTISPECIES: CAP domain-containing protein [Sphaerospermopsis]	diamond	738	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis
30475769	30475769	PRJEB36940_P_NODE_13533_length_249_cov_0.875000_g13404_i0	PRJEB36940	13533	249	0.875	2.17875	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	134	4.95e-38	NR	WP_106368732.1	2107693	g13404	i0	89.5	0.91566265060241	76	7	91.6	1	249	22	76	150	WP_106368732.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	228	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
30854763	30854763	PRJEB36940_P_NODE_454_length_1183_cov_16.593694_g377_i0	PRJEB36940	454	1183	16.593694	196.30340002	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	464	9.69e-161	NR	MBX9694561.1	2847862	g377	i0	73.4	2.47252747252747	308	77	76.8	2	54	962	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2925	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30981386	30981386	PRJEB36940_P_NODE_15134_length_244_cov_0.912281_g15005_i0	PRJEB36940	15134	244	0.912281	2.22596564	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	95.9	1.13e-22	NR	MBL8086383.1	2711154	g15005	i0	70.1	0.94672131147541	77	19	89.8	1	14	232	58	134	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	231	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31360645	31360645	PRJEB36940_P_NODE_10716_length_269_cov_0.974490_g10587_i0	PRJEB36940	10716	269	0.97449	2.6213781	Pantanalinema sp.	3088176	Bacteria	Bacteria	53.5	8.16e-6	NR	HEY9897812.1	3088176	g10587	i0	33.3	0.903345724907063	81	51	87	1	235	2	567	647	HEY9897812.1 5-histidylcysteine sulfoxide synthase [Pantanalinema sp.]	diamond	243	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Pantanalinema	Pantanalinema sp.
31613535	31613535	PRJEB36940_P_NODE_2696_length_515_cov_8.529412_g2569_i0	PRJEB36940	2696	515	8.529412	43.9264718	Nostoc sp. PCC 71	1180	Bacteria	Bacteria	71.6	1.89e-11	NR	WP_253274458.1	317936	g2569	i0	33.1	1.93980582524272	160	91	87.4	4	450	1	73	226	WP_253274458.1 CAP domain-containing protein [Nostoc sp. PCC 7107]	diamond	999	71.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7107
32436399	32436399	PRJEB36940_P_NODE_5319_length_370_cov_2.777778_g5190_i0	PRJEB36940	5319	370	2.777778	10.2777786	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	47.4	0.00321	NR	WP_015142697.1	118163	g5190	i0	48.6	0.283783783783784	35	18	28.4	0	105	1	7	41	WP_015142697.1 fatty acid desaturase [Pleurocapsa sp. PCC 7327]	diamond	105	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
32688512	32688512	PRJEB36940_P_NODE_14480_length_246_cov_0.895954_g14351_i0	PRJEB36940	14480	246	0.895954	2.20404684	Plectonema radiosum	945768	Bacteria	Bacteria	135	2.77e-35	NR	WP_263743508.1	945768	g14351	i0	84	1.97560975609756	81	13	98.8	0	244	2	217	297	WP_263743508.1 histidine kinase N-terminal 7TM domain-containing protein [Plectonema radiosum]	diamond	486	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum
32814535	32814535	PRJEB36940_P_NODE_10920_length_266_cov_2.155440_g10791_i0	PRJEB36940	10920	266	2.15544	5.7334704	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	121	1.28e-33	NR	MBX9693409.1	2847862	g10791	i0	71.7	1.03759398496241	92	21	98.1	1	261	1	1	92	MBX9693409.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	276	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium

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