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

13 rows where analysis = "diamond", bioproject = "PRJNA861969" 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
26770272	26770272	PRJNA861969_P_NODE_26161_length_270_cov_1.563452_g25930_i0	PRJNA861969	26161	270	1.563452	4.2213204	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	161	4.53e-44	NR	MBX9672589.1	2364082	g25930	i0	100	0.988888888888889	89	0	98.9	0	269	3	409	497	MBX9672589.1 serine/threonine protein kinase [Candidatus Obscuribacterales bacterium]	diamond	267	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28097345	28097345	PRJNA861969_P_NODE_5545_length_546_cov_2.114165_g5315_i0	PRJNA861969	5545	546	2.114165	11.5433409	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	46.2	0.0324	NR	MEW5820732.1	2847862	g5315	i0	35.1	0.423076923076923	77	50	42.3	0	440	210	144	220	MEW5820732.1 SGNH/GDSL hydrolase family protein [Cyanobacteriota bacterium]	diamond	231	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28831635	28831635	PRJNA861969_P_NODE_35588_length_247_cov_0.885057_g35357_i0	PRJNA861969	35588	247	0.885057	2.18609079	Spirulina	1154	Bacteria	Bacteria	94.4	2.69e-20	NR	NEO87136.1	2607816	g35357	i0	57.3	3.95951417004049	82	34	99.6	1	2	247	472	552	NEO87136.1 GHKL domain-containing protein [Spirulina sp. SIO3F2]	diamond	978	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. SIO3F2
29486421	29486421	PRJNA861969_P_NODE_42290_length_233_cov_2.775000_g42059_i0	PRJNA861969	42290	233	2.775	6.46575	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	74.7	3.33e-14	NR	MBK9774186.1	2711154	g42059	i0	44.3	0.901287553648069	70	39	90.1	0	5	214	9	78	MBK9774186.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	210	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
29644118	29644118	PRJNA861969_P_NODE_25510_length_273_cov_1.540000_g25279_i0	PRJNA861969	25510	273	1.54	4.2042	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	182	5.11e-51	NR	MDQ5937995.1	3070899	g25279	i0	98.9	1	91	1	100	0	273	1	371	461	MDQ5937995.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	273	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
29675766	29675766	PRJNA861969_P_NODE_22690_length_286_cov_1.446009_g22459_i0	PRJNA861969	22690	286	1.446009	4.13558574	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	64.7	1.38e-10	NR	MDR3614999.1	2364082	g22459	i0	56.6	1.6993006993007	53	23	55.6	0	285	127	100	152	MDR3614999.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	486	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30023694	30023694	PRJNA861969_P_NODE_26831_length_267_cov_1.484536_g26600_i0	PRJNA861969	26831	267	1.484536	3.96371112	Iningainema tapete	2806730	Bacteria	Bacteria	51.6	4.04e-5	NR	WP_190835607.1	2806730	g26600	i0	88.5	0.292134831460674	26	3	29.2	0	73	150	2085	2110	WP_190835607.1 type I polyketide synthase [Iningainema tapete]	diamond	78	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Iningainema	Iningainema tapete
30031735	30031735	PRJNA861969_P_NODE_36191_length_246_cov_0.890173_g35960_i0	PRJNA861969	36191	246	0.890173	2.18982558	Bacillati	1783272	Bacteria	Bacteria	78.6	1.93e-15	NR	MCC7528080.1	2052166	g35960	i0	82.1	1.92682926829268	39	7	47.6	0	244	128	208	246	MCC7528080.1 response regulator transcription factor [Candidatus Melainabacteria bacterium]	diamond	474	79.3	0.991172761664565	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30189556	30189556	PRJNA861969_P_NODE_31792_length_250_cov_0.870056_g31561_i0	PRJNA861969	31792	250	0.870056	2.17514	Cyanophyceae	3028117	Bacteria	Bacteria	71.2	3.54e-12	NR	WP_190595277.1	1162	g31561	i0	58.8	2.304	68	28	81.6	0	1	204	364	431	WP_190595277.1 MULTISPECIES: glycosyltransferase [Nostocaceae]	diamond	576	71.6	0.994413407821229	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
30876580	30876580	PRJNA861969_P_NODE_31114_length_251_cov_0.865169_g30883_i0	PRJNA861969	31114	251	0.865169	2.17157419	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	166	4.539999999999999e-46	NR	PZM78708.1	2052166	g30883	i0	98.8	0.99203187250996006	83	1	99.2	0	2	250	235	317	PZM78708.1 MAG: hypothetical protein DKT66_23540 [Candidatus Melainabacteria bacterium]	diamond	249	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31003041	31003041	PRJNA861969_P_NODE_22654_length_286_cov_1.446009_g22423_i0	PRJNA861969	22654	286	1.446009	4.13558574	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	99.8	5.7099999999999996e-24	NR	MBP6348882.1	2711154	g22423	i0	86.8	0.555944055944056	53	7	55.6	0	160	2	6	58	MBP6348882.1 gamma carbonic anhydrase family protein [Candidatus Obscuribacter sp.]	diamond	159	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31603788	31603788	PRJNA861969_P_NODE_36476_length_246_cov_0.890173_g36245_i0	PRJNA861969	36476	246	0.890173	2.18982558	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	73.6	5.28e-13	NR	MBN9396211.1	2052166	g36245	i0	51.6	0.75609756097561	62	30	75.6	0	187	2	1	62	MBN9396211.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	186	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32521515	32521515	PRJNA861969_P_NODE_28799_length_258_cov_1.664865_g28568_i0	PRJNA861969	28799	258	1.664865	4.2953517	Nostoc ellipsosporum	45916	Bacteria	Bacteria	102	6.5e-23	NR	MDF2385032.1	2804519	g28568	i0	100	1	86	0	100	0	1	258	755	840	MDF2385032.1 RHS repeat protein [Nostoc ellipsosporum NOK]	diamond	258	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc ellipsosporum

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