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

15 rows where analysis = "diamond", bioproject = "PRJNA492406" 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
28324016	28324016	PRJNA492406_P_NODE_4626_length_556_cov_1.240166_g4331_i0	PRJNA492406	4626	556	1.240166	6.89532296	Nostoc	1177	Bacteria	Bacteria	73.2	6.5e-12	NR	WP_245894956.1	246795	g4331	i0	31.9	1.86690647482014	185	109	93.9	5	532	11	50	228	WP_245894956.1 CAP domain-containing protein [Nostoc cycadae]	diamond	1038	73.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc cycadae
28371238	28371238	PRJNA492406_P_NODE_26706_length_251_cov_0.865169_g26407_i0	PRJNA492406	26706	251	0.865169	2.17157419	Roseofilum reptotaenium	1233427	Bacteria	Bacteria	51.2	4.26e-5	NR	WP_271937232.1	1233427	g26407	i0	41.7	0.717131474103586	60	30	71.7	1	33	212	171	225	WP_271937232.1 adenylate/guanylate cyclase domain-containing protein [Roseofilum reptotaenium]	diamond	180	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Desertifilales	Desertifilaceae	Roseofilum	Roseofilum reptotaenium
29066061	29066061	PRJNA492406_P_NODE_20988_length_279_cov_1.121359_g20689_i0	PRJNA492406	20988	279	1.121359	3.12859161	Mastigocoleus sp. MO_188.B34	3036635	Bacteria	Bacteria	43.9	0.0181	NR	WP_300637072.1	3036635	g20689	i0	35.2	0.978494623655914	91	48	92.5	4	268	11	50	134	WP_300637072.1 CAP domain-containing protein [Mastigocoleus sp. MO_188.B34]	diamond	273	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Mastigocoleus	Mastigocoleus sp. MO_188.B34
29570989	29570989	PRJNA492406_P_NODE_29830_length_245_cov_0.895349_g29531_i0	PRJNA492406	29830	245	0.895349	2.19360505	Xenococcaceae cyanobacterium MO_188.B29	3036639	Bacteria	Bacteria	90.5	5.79e-19	NR	MDJ0636065.1	3036639	g29531	i0	67.6	2.62040816326531	71	21	84.5	2	240	34	424	494	MDJ0636065.1 arginine--tRNA ligase [Xenococcaceae cyanobacterium MO_188.B29]	diamond	642	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae		Xenococcaceae cyanobacterium MO_188.B29
29871312	29871312	PRJNA492406_P_NODE_24611_length_260_cov_2.229947_g24312_i0	PRJNA492406	24611	260	2.229947	5.7978622	Microcystis	1125	Bacteria	Bacteria	60.1	3.72e-8	NR	NCT44034.1	2685958	g24312	i0	47.6	2.88461538461538	84	42	95.8	2	249	1	1	83	NCT44034.1 hypothetical protein [Microcystis aeruginosa G11-09]	diamond	750	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
30329686	30329686	PRJNA492406_P_NODE_15752_length_316_cov_1.238683_g15453_i0	PRJNA492406	15752	316	1.238683	3.91423828	Brunnivagina elsteri CCALA 953	987040	Bacteria	Bacteria	52.4	2.4e-5	NR	PAX60035.1	987040	g15453	i0	34.6	0.987341772151899	104	64	97.8	3	309	1	51	151	PAX60035.1 serine protease [Brunnivagina elsteri CCALA 953]	diamond	312	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Brunnivagina	Brunnivagina elsteri
30345726	30345726	PRJNA492406_P_NODE_30972_length_243_cov_0.905882_g30673_i0	PRJNA492406	30972	243	0.905882	2.20129326	Cyanophyceae	3028117	Bacteria	Bacteria	55.1	1.15e-6	NR	ARV63193.1	1940762	g30673	i0	48.1	10.283950617284	81	36	98.8	4	2	241	133	208	ARV63193.1 serine protease [Nostocales cyanobacterium HT-58-2]	diamond	2499	55.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
30771686	30771686	PRJNA492406_P_NODE_29214_length_246_cov_0.907514_g28915_i0	PRJNA492406	29214	246	0.907514	2.23248444	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	157	5.74e-45	NR	QQR55791.1	2052166	g28915	i0	96.3	1	82	3	100	0	246	1	247	328	QQR55791.1 MAG: NAD(P)-dependent alcohol dehydrogenase [Candidatus Melainabacteria bacterium]	diamond	246	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31276981	31276981	PRJNA492406_P_NODE_23435_length_266_cov_1.844560_g23136_i0	PRJNA492406	23435	266	1.84456	4.9065296	cyanobacterium TDX16	1503470	Bacteria	Bacteria	43.5	0.0257	NR	OWY69758.1	1503470	g23136	i0	36.7	1.45488721804511	60	34	63.2	1	168	1	74	133	OWY69758.1 hypothetical protein B7486_19135 [cyanobacterium TDX16]	diamond	387	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
32289806	32289806	PRJNA492406_P_NODE_21499_length_276_cov_1.522167_g21200_i0	PRJNA492406	21499	276	1.522167	4.20118092	Anabaena	1163	Bacteria	Bacteria	138	3.18e-36	NR	WP_015216458.1	1163	g21200	i0	65.9	5.93478260869565	91	31	98.9	0	3	275	284	374	WP_015216458.1 MULTISPECIES: vanadium-dependent haloperoxidase [Anabaena]	diamond	1638	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena
32289819	32289819	PRJNA492406_P_NODE_30379_length_244_cov_0.900585_g30080_i0	PRJNA492406	30379	244	0.900585	2.1974274	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	147	1.9199999999999998e-40	NR	MBX9948888.1	2364082	g30080	i0	96.3	1.99180327868852	81	3	99.6	0	1	243	312	392	MBX9948888.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	486	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32321373	32321373	PRJNA492406_P_NODE_19079_length_288_cov_0.981395_g18780_i0	PRJNA492406	19079	288	0.981395	2.8264176	Nodosilinea sp. LVE12	2497642	Bacteria	Bacteria	51.2	1.87e-5	NR	XGB44019.1	2904796	g18780	i0	52.3	1.9375	44	21	45.8	0	287	156	1	44	XGB44019.1 MAG: tetratricopeptide repeat-containing protein [Nodosilinea sp. LVE1205-7]	diamond	558	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. LVE1205-7
32574424	32574424	PRJNA492406_P_NODE_21899_length_274_cov_1.497512_g21600_i0	PRJNA492406	21899	274	1.497512	4.10318288	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	50.4	1.06e-4	NR	MDY6803201.1	2847862	g21600	i0	34.5	0.91970802919708	84	51	90.9	2	26	274	36	116	MDY6803201.1 ferric reductase-like transmembrane domain-containing protein [Cyanobacteriota bacterium]	diamond	252	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32636844	32636844	PRJNA492406_P_NODE_16380_length_309_cov_2.601695_g16081_i0	PRJNA492406	16380	309	2.601695	8.03923755	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	44.3	0.0104	NR	MFO0138159.1	2847862	g16081	i0	42.9	0.543689320388349	56	28	50.5	1	5	160	98	153	MFO0138159.1 PAN domain-containing protein [Cyanobacteriota bacterium]	diamond	168	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32888864	32888864	PRJNA492406_P_NODE_29340_length_246_cov_0.890173_g29041_i0	PRJNA492406	29340	246	0.890173	2.18982558	Leptolyngbyaceae cyanobacterium bins.59	2971804	Bacteria	Bacteria	137	7.369999999999999e-38	NR	MDX2098332.1	2971804	g29041	i0	75.6	3.90243902439024	82	20	100	0	1	246	90	171	MDX2098332.1 metal-dependent phosphohydrolase [Leptolyngbyaceae cyanobacterium bins.59]	diamond	960	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium bins.59

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