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

14 rows where analysis = "diamond", bioproject = "PRJEB29441" 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
6404786	6404786	PRJEB29441_P_NODE_31286_length_187_cov_1.478261_g30845_i0	PRJEB29441	31286	187	1.478261	2.76434807	Cyanophyceae	3028117	Bacteria	Bacteria	104	5.13e-26	NR	WP_334726191.1	1180	g30845	i0	96.1	4.09090909090909	51	2	81.8	0	185	33	90	140	WP_334726191.1 manganese catalase family protein [Nostoc sp.]	diamond	765	105	0.990476190476191	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
27152729	27152729	PRJEB29441_P_NODE_41982_length_165_cov_0.879310_g41541_i0	PRJEB29441	41982	165	0.87931	1.4508615	Cyanophyceae	3028117	Bacteria	Bacteria	42	0.0151	NR	WP_035992714.1	1229172	g41541	i0	100	1.6	22	0	40	0	68	3	1	22	WP_035992714.1 phage holin family protein [Leptolyngbya sp. KIOST-1]	diamond	264	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. KIOST-1
27823168	27823168	PRJEB29441_P_NODE_45584_length_162_cov_0.902655_g45143_i0	PRJEB29441	45584	162	0.902655	1.4623011	Leptolyngbya sp. CCNP13	47254	Bacteria	Bacteria	100	1.18e-24	NR	WP_323349933.1	3110255	g45143	i0	88.9	1	54	6	100	0	162	1	10	63	WP_323349933.1 general stress protein [Leptolyngbya sp. CCNP1308]	diamond	162	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. CCNP1308
29111126	29111126	PRJEB29441_P_NODE_18428_length_250_cov_1.348259_g17987_i0	PRJEB29441	18428	250	1.348259	3.3706475	Crocosphaera	263510	Bacteria	Bacteria	76.3	5.21e-16	NR	EAM52380.1	165597	g17987	i0	61	4.176	59	17	70.8	1	248	72	35	87	EAM52380.1 xenobiotic reductase B [Crocosphaera watsonii WH 8501]	diamond	1044	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera watsonii
29117683	29117683	PRJEB29441_P_NODE_17389_length_258_cov_2.440191_g16948_i0	PRJEB29441	17389	258	2.440191	6.29569278	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	123	1.7900000000000002e-33	NR	MBX9724270.1	2364082	g16948	i0	98.3	0.686046511627907	59	1	68.6	0	1	177	112	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	177	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29117690	29117690	PRJEB29441_P_NODE_41529_length_165_cov_0.879310_g41088_i0	PRJEB29441	41529	165	0.87931	1.4508615	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	57	1.17e-7	NR	MFN4152311.1	2762020	g41088	i0	57.7	2.87272727272727	52	21	94.5	1	161	6	350	400	MFN4152311.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	474	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30854698	30854698	PRJEB29441_P_NODE_43574_length_163_cov_5.122807_g43133_i0	PRJEB29441	43574	163	5.122807	8.35017541	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.4	8.14e-7	NR	PZM84364.1	2052166	g43133	i0	68.6	0.644171779141104	35	11	64.4	0	160	56	67	101	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	105	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31076019	31076019	PRJEB29441_P_NODE_47275_length_161_cov_0.910714_g46834_i0	PRJEB29441	47275	161	0.910714	1.46624954	Nodosilinea sp. LEGE	2497642	Bacteria	Bacteria	107	1.23e-26	NR	WP_228052409.1	2777970	g46834	i0	96.2	7.90062111801242	53	2	98.8	0	159	1	190	242	WP_228052409.1 M23 family metallopeptidase [Nodosilinea sp. LEGE 07298]	diamond	1272	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. LEGE 07298
31676620	31676620	PRJEB29441_P_NODE_39437_length_167_cov_0.864407_g38996_i0	PRJEB29441	39437	167	0.864407	1.44355969	Allocoleopsis sp.	3088169	Bacteria	Bacteria	57	1.19e-7	NR	HEY9703711.1	3088169	g38996	i0	45.5	0.988023952095808	55	30	98.8	0	2	166	45	99	HEY9703711.1 hypothetical protein [Allocoleopsis sp.]	diamond	165	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
32056334	32056334	PRJEB29441_P_NODE_48278_length_155_cov_5.905660_g47837_i0	PRJEB29441	48278	155	5.90566	9.153773	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	42.4	0.00558	NR	PZM84364.1	2052166	g47837	i0	60.5	0.735483870967742	38	15	73.5	0	25	138	77	114	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	114	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32278060	32278060	PRJEB29441_P_NODE_36459_length_172_cov_6.422764_g36018_i0	PRJEB29441	36459	172	6.422764	11.04715408	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	46.6	1.56e-4	NR	PZM84364.1	2052166	g36018	i0	63.2	0.662790697674419	38	14	66.3	0	45	158	78	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	114	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32309805	32309805	PRJEB29441_P_NODE_30959_length_188_cov_1.467626_g30518_i0	PRJEB29441	30959	188	1.467626	2.75913688	Gloeocapsa sp. DLM2.Bin57	2480214	Bacteria	Bacteria	94.7	8.76e-21	NR	TVQ47685.1	2480214	g30518	i0	78.7	15.5904255319149	61	13	97.3	0	185	3	718	778	TVQ47685.1 MAG: glutamate synthase large subunit [Gloeocapsa sp. DLM2.Bin57]	diamond	2931	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. DLM2.Bin57
32625492	32625492	PRJEB29441_P_NODE_35380_length_175_cov_2.920635_g34939_i0	PRJEB29441	35380	175	2.920635	5.11111125	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	45.8	3.37e-4	NR	PZM84364.1	2052166	g34939	i0	66.7	0.514285714285714	30	10	51.4	0	2	91	63	92	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	90	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32688456	32688456	PRJEB29441_P_NODE_41580_length_165_cov_0.879310_g41139_i0	PRJEB29441	41580	165	0.87931	1.4508615	filamentous cyanobacterium CCP5	2107701	Bacteria	Bacteria	55.8	1.78e-7	NR	PSN10382.1	2107701	g41139	i0	93.1	0.527272727272727	29	2	52.7	0	75	161	1	29	PSN10382.1 hypothetical protein C7271_26085 [filamentous cyanobacterium CCP5]	diamond	87	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					filamentous cyanobacterium CCP5

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