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

13 rows where analysis = "diamond", bioproject = "PRJNA1105232" 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
6590692	6590692	PRJNA1105232_S_NODE_5386_length_257_cov_2.389423_g5170_i0	PRJNA1105232	5386	257	2.389423	6.14081711	Bacteria	2	Bacteria	Bacteria	99	7.200000000000001e-22	NR	NJL47407.1	2720474	g5170	i0	60.5	1.77431906614786	76	30	88.7	0	28	255	526	601	NJL47407.1 SLC13 family permease [Leptolyngbyaceae cyanobacterium SM2_5_2]	diamond	456	100	0.99	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Leptolyngbyaceae cyanobacterium SM2_5_2
18871988	18871988	PRJNA1105232_S_NODE_2155_length_365_cov_5.487342_g1939_i0	PRJNA1105232	2155	365	5.487342	20.0287983	Cyanophyceae	3028117	Bacteria	Bacteria	182	2.14e-56	NR	WP_009756874.1	372787	g1939	i0	69.4	30.7479452054795	121	37	99.5	0	2	364	17	137	WP_009756874.1 nucleoside-diphosphate kinase [Fischerella thermalis]	diamond	11223	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella thermalis
26655951	26655951	PRJNA1105232_S_NODE_10581_length_197_cov_1.756757_g10365_i0	PRJNA1105232	10581	197	1.756757	3.46081129	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	42.4	0.0283	NR	MDZ4835227.1	2052166	g10365	i0	41.7	0.913705583756345	60	35	91.4	0	2	181	792	851	MDZ4835227.1 serine/threonine-protein kinase [Candidatus Melainabacteria bacterium]	diamond	180	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27185283	27185283	PRJNA1105232_S_NODE_1422_length_427_cov_8.589947_g1208_i0	PRJNA1105232	1422	427	8.589947	36.67907369	Nostoc	1177	Bacteria	Bacteria	57	1.69e-6	NR	WP_289798355.1	3056647	g1208	i0	54.3	1.26463700234192	46	21	32.3	0	414	277	62	107	WP_289798355.1 hypothetical protein [Nostoc sp. GT001]	diamond	540	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. GT001
27216782	27216782	PRJNA1105232_S_NODE_16622_length_164_cov_1.791304_g16406_i0	PRJNA1105232	16622	164	1.791304	2.93773856	Cyanophyceae	3028117	Bacteria	Bacteria	82.4	3.01e-18	NR	WP_006100767.1	64178	g16406	i0	69.8	11.5060975609756	53	16	97	0	164	6	72	124	WP_006100767.1 nucleoside-diphosphate kinase [Coleofasciculus chthonoplastes]	diamond	1887	82.8	0.995169082125604	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
28678474	28678474	PRJNA1105232_S_NODE_15507_length_168_cov_1.310924_g15291_i0	PRJNA1105232	15507	168	1.310924	2.20235232	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	58.5	2.69e-9	NR	HEY9785743.1	2364082	g15291	i0	50	1	56	27	98.2	1	168	4	26	81	HEY9785743.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	168	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28710057	28710057	PRJNA1105232_S_NODE_2047_length_373_cov_2.083333_g1831_i0	PRJNA1105232	2047	373	2.083333	7.77083209	Cuspidothrix sp.	3019649	Bacteria	Bacteria	60.8	7.59e-8	NR	MFM7363647.1	3019649	g1831	i0	61.5	0.932975871313673	39	15	31.4	0	365	249	662	700	MFM7363647.1 FG-GAP-like repeat-containing protein [Cuspidothrix sp.]	diamond	348	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cuspidothrix	Cuspidothrix sp.
28772928	28772928	PRJNA1105232_S_NODE_6927_length_233_cov_1.690217_g6711_i0	PRJNA1105232	6927	233	1.690217	3.93820561	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	41.6	0.0483	NR	MEY4839990.1	2847862	g6711	i0	58.6	0.373390557939914	29	12	37.3	0	162	76	1	29	MEY4839990.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	87	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29711190	29711190	PRJNA1105232_S_NODE_5230_length_260_cov_1.867299_g5014_i0	PRJNA1105232	5230	260	1.867299	4.8549774	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	110	4.39e-28	NR	MFH7026001.1	1735366	g5014	i0	54.5	11.1115384615385	88	38	99.2	1	260	3	89	176	MFH7026001.1 ureidoglycolate lyase [Heteroscytonema crispum UTEX LB 1556]	diamond	2889	111	0.990990990990991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Heteroscytonemataceae	Heteroscytonema	Heteroscytonema crispum
29909902	29909902	PRJNA1105232_S_NODE_5971_length_247_cov_2.095960_g5755_i0	PRJNA1105232	5971	247	2.09596	5.1770212	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	100	1.39e-22	NR	MBK9142933.1	2052166	g5755	i0	53.7	0.995951417004049	82	38	99.6	0	246	1	783	864	MBK9142933.1 thiamine pyrophosphate-requiring protein [Candidatus Melainabacteria bacterium]	diamond	246	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30595960	30595960	PRJNA1105232_S_NODE_13433_length_178_cov_1.728682_g13217_i0	PRJNA1105232	13433	178	1.728682	3.07705396	root	1	Root_unresolved	Root_unresolved	52.8	4.32e-6	NR	WP_334846380.1	1180	g13217	i0	58.1	3.20224719101124	43	18	72.5	0	50	178	1	43	WP_334846380.1 WD40 repeat domain-containing protein, partial [Nostoc sp.]	diamond	570	53.1	0.994350282485876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
31679440	31679440	PRJNA1105232_S_NODE_217_length_1063_cov_5.724852_g50_i0	PRJNA1105232	217	1063	5.724852	60.85517676	Candidatus Tanganyikabacteria bacterium	2961651	Bacteria	Bacteria	52	0.0027	NR	MBM3270526.1	2961651	g50	i0	28.6	0.375352775164628	133	87	35.6	4	531	154	131	262	MBM3270526.1 VWD domain-containing protein [Candidatus Tanganyikabacteria bacterium]	diamond	399	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Tanganyikabacteria bacterium
32303925	32303925	PRJNA1105232_S_NODE_16359_length_165_cov_1.344828_g16143_i0	PRJNA1105232	16359	165	1.344828	2.2189662	Annamia	1278161	Bacteria	Bacteria	51.6	8.86e-6	NR	BDG64151.1	2759045	g16143	i0	50	4.12727272727273	52	22	94.5	1	9	164	218	265	BDG64151.1 hypothetical protein Anndu_15260 [Annamia dubia NIES-4383]	diamond	681	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia

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