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

17 rows where analysis = "diamond", bioproject = "PRJNA1086823" 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
12947433	12947433	PRJNA1086823_P_NODE_14551_length_249_cov_0.886364_g14434_i0	PRJNA1086823	14551	249	0.886364	2.20704636	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	144	4.96e-38	NR	HEY9778558.1	3088178	g14434	i0	87.8	0.987951807228916	82	10	98.8	0	247	2	128	209	HEY9778558.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Leptolyngbyaceae cyanobacterium]	diamond	246	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
26814446	26814446	PRJNA1086823_P_NODE_8141_length_291_cov_1.311927_g8024_i0	PRJNA1086823	8141	291	1.311927	3.81770757	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	71.2	1.5e-12	NR	HEY9684379.1	3088181	g8024	i0	97.4	0.391752577319588	38	1	39.2	0	1	114	186	223	HEY9684379.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	114	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27406862	27406862	PRJNA1086823_P_NODE_11163_length_261_cov_1.308511_g11046_i0	PRJNA1086823	11163	261	1.308511	3.41521371	Cyanophyceae	3028117	Bacteria	Bacteria	65.1	6e-10	NR	WP_199245511.1	222819	g11046	i0	50.8	5.5632183908046	63	30	72.4	1	72	260	49	110	WP_199245511.1 CAP domain-containing protein [[Phormidium] sp. ETS-05]	diamond	1452	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Koinonema	[Phormidium] sp. ETS-05
27762751	27762751	PRJNA1086823_P_NODE_18404_length_243_cov_0.917647_g18287_i0	PRJNA1086823	18404	243	0.917647	2.22988221	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	46.6	0.00165	NR	WP_155897956.1	2886352	g18287	i0	66.7	0.444444444444444	36	12	44.4	0	112	5	923	958	WP_155897956.1 CHAT domain-containing protein [Allocoleopsis franciscana]	diamond	108	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
28583562	28583562	PRJNA1086823_P_NODE_12227_length_253_cov_0.866667_g12110_i0	PRJNA1086823	12227	253	0.866667	2.19266751	Geitlerinema sp. PCC 74	3100420	Bacteria	Bacteria	80.9	2.82e-17	NR	WP_015170897.1	1173025	g12110	i0	85.1	0.557312252964427	47	7	55.7	0	1	141	87	133	WP_015170897.1 DUF309 domain-containing protein [Geitlerinema sp. PCC 7407]	diamond	141	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 7407
29057123	29057123	PRJNA1086823_P_NODE_10108_length_271_cov_2.090909_g9991_i0	PRJNA1086823	10108	271	2.090909	5.66636339	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	58.9	7.95e-8	NR	WP_190491935.1	2692827	g9991	i0	43.3	1.43911439114391	67	35	74.2	1	204	4	1	64	WP_190491935.1 hypothetical protein [Microcoleus sp. FACHB-831]	diamond	390	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
29364322	29364322	PRJNA1086823_P_NODE_12229_length_253_cov_0.866667_g12112_i0	PRJNA1086823	12229	253	0.866667	2.19266751	Cyanophyceae	3028117	Bacteria	Bacteria	111	1.71e-29	NR	WP_106370926.1	2107693	g12112	i0	77.9	2.44268774703557	68	14	79.4	1	206	6	44	111	WP_106370926.1 transposase [Chlorogloea sp. CCALA 695]	diamond	618	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
29562060	29562060	PRJNA1086823_P_NODE_13150_length_251_cov_2.443820_g13033_i0	PRJNA1086823	13150	251	2.44382	6.1339882	Acaryochloridaceae cyanobacterium SU_2_1	2720477	Bacteria	Bacteria	95.9	2.26e-21	NR	NJK40782.1	2720477	g13033	i0	62.2	2.54581673306773	74	28	88.4	0	222	1	8	81	NJK40782.1 FAD-dependent oxidoreductase [Acaryochloridaceae cyanobacterium SU_2_1]	diamond	639	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae		Acaryochloridaceae cyanobacterium SU_2_1
29783171	29783171	PRJNA1086823_P_NODE_6591_length_318_cov_1.273469_g6474_i0	PRJNA1086823	6591	318	1.273469	4.04963142	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	77.8	1.41e-14	NR	HEY9635810.1	3081323	g6474	i0	58.1	1.24528301886792	62	26	58.5	0	291	106	210	271	HEY9635810.1 hypothetical protein [Coleofasciculaceae cyanobacterium]	diamond	396	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
30035971	30035971	PRJNA1086823_P_NODE_19211_length_242_cov_0.923077_g19094_i0	PRJNA1086823	19211	242	0.923077	2.23384634	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	50.8	3.2e-5	NR	PZM77368.1	2053573	g19094	i0	44.4	0.669421487603306	54	30	66.9	0	33	194	152	205	PZM77368.1 MAG: hypothetical protein DKM50_12885 [Candidatus Margulisiibacteriota bacterium]	diamond	162	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
30130345	30130345	PRJNA1086823_P_NODE_13592_length_251_cov_0.876404_g13475_i0	PRJNA1086823	13592	251	0.876404	2.19977404	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	128	2.33e-32	NR	WP_106367765.1	2107693	g13475	i0	79.5	0.99203187250996006	83	17	99.2	0	1	249	1	83	WP_106367765.1 ABC transporter ATP-binding protein [Chlorogloea sp. CCALA 695]	diamond	249	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
30383878	30383878	PRJNA1086823_P_NODE_16233_length_246_cov_1.786127_g16116_i0	PRJNA1086823	16233	246	1.786127	4.39387242	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	89	5.36e-19	NR	HEY9781340.1	3088178	g16116	i0	87.3	0.670731707317073	55	7	67.1	0	244	80	239	293	HEY9781340.1 ABC transporter permease [Leptolyngbyaceae cyanobacterium]	diamond	165	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
30478366	30478366	PRJNA1086823_P_NODE_16013_length_247_cov_0.896552_g15896_i0	PRJNA1086823	16013	247	0.896552	2.21448344	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	169	5.21e-49	NR	HEY9782996.1	3088178	g15896	i0	100	0.983805668016194	81	0	98.4	0	245	3	10	90	HEY9782996.1 FtsW/RodA/SpoVE family cell cycle protein [Leptolyngbyaceae cyanobacterium]	diamond	243	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
31236441	31236441	PRJNA1086823_P_NODE_13915_length_250_cov_0.881356_g13798_i0	PRJNA1086823	13915	250	0.881356	2.20339	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	172	1.85e-53	NR	HEY9782956.1	3088178	g13798	i0	95.2	0.996	83	4	99.6	0	2	250	31	113	HEY9782956.1 KGK domain-containing protein [Leptolyngbyaceae cyanobacterium]	diamond	249	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
31584669	31584669	PRJNA1086823_P_NODE_12956_length_252_cov_0.871508_g12839_i0	PRJNA1086823	12956	252	0.871508	2.19620016	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	52.8	1.05e-5	NR	MBF2053141.1	2762020	g12839	i0	36.5	1.97619047619048	85	43	98.8	4	251	3	76	151	MBF2053141.1 S1/P1 nuclease [Candidatus Sericytochromatia bacterium]	diamond	498	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31711048	31711048	PRJNA1086823_P_NODE_2057_length_523_cov_1.755556_g1941_i0	PRJNA1086823	2057	523	1.755556	9.18155788	Microcoleus sp. FACHB-831	2692827	Bacteria	Bacteria	147	4.61e-40	NR	WP_190491935.1	2692827	g1941	i0	50.7	1.73231357552581	150	73	85.5	1	521	75	120	269	WP_190491935.1 hypothetical protein [Microcoleus sp. FACHB-831]	diamond	906	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-831
32470560	32470560	PRJNA1086823_P_NODE_9999_length_272_cov_2.351759_g9882_i0	PRJNA1086823	9999	272	2.351759	6.39678448	Microseira wollei	467598	Bacteria	Bacteria	92.8	1.65e-20	NR	WP_226575606.1	467598	g9882	i0	51.8	0.9375	85	33	84.9	1	3	233	12	96	WP_226575606.1 hypothetical protein [Microseira wollei]	diamond	255	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei

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