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

15 rows where analysis = "diamond", bioproject = "PRJNA971676" 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
8597576	8597576	PRJNA971676_P_NODE_18347_length_246_cov_0.890173_g18258_i0	PRJNA971676	18347	246	0.890173	2.18982558	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	154	5.059999999999998e-42	NR	MEA3493317.1	2053573	g18258	i0	93.8	0.98780487804878	81	5	98.8	0	2	244	360	440	MEA3493317.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Candidatus Margulisiibacteriota bacterium]	diamond	243	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
20392882	20392882	PRJNA971676_P_NODE_9076_length_297_cov_1.325893_g8987_i0	PRJNA971676	9076	297	1.325893	3.93790221	root	1	Root_unresolved	Root_unresolved	155	2.44e-43	NR	PLS69741.1	2054928	g8987	i0	76.5	9.8989898989899	98	23	99	0	3	296	284	381	PLS69741.1 MAG: phosphoglycerate kinase [Cyanobacteria bacterium M5B4]	diamond	2940	156	0.993589743589744	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium M5B4
27151963	27151963	PRJNA971676_P_NODE_20782_length_244_cov_0.900585_g20693_i0	PRJNA971676	20782	244	0.900585	2.1974274	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	49.7	1.28e-4	NR	MFM2061251.1	2847862	g20693	i0	35.4	1.00819672131148	82	49	95.9	2	239	6	337	418	MFM2061251.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	246	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28320838	28320838	PRJNA971676_P_NODE_22266_length_242_cov_0.911243_g22177_i0	PRJNA971676	22266	242	0.911243	2.20520806	Candidatus Saganbacteria bacterium	2575572	Bacteria	Bacteria	125	2.47e-33	NR	MCX5751257.1	2575572	g22177	i0	67.1	0.979338842975207	79	26	97.9	0	3	239	152	230	MCX5751257.1 Fic family protein [Candidatus Saganbacteria bacterium]	diamond	237	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						Candidatus Saganbacteria bacterium
28737682	28737682	PRJNA971676_P_NODE_4367_length_389_cov_1.430380_g4278_i0	PRJNA971676	4367	389	1.43038	5.5641782	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	44.7	0.0407	NR	MBW4442205.1	1601948	g4278	i0	39.8	1.2879177377892	88	47	65.6	3	262	8	580	664	MBW4442205.1 DUF4347 domain-containing protein [Plectolyngbya sp. WJT66-NPBG17]	diamond	501	45.1	0.991130820399113	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya sp. WJT66-NPBG17
29362913	29362913	PRJNA971676_P_NODE_13669_length_251_cov_1.842697_g13580_i0	PRJNA971676	13669	251	1.842697	4.62516947	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	94.4	6.58e-21	NR	MBX9694561.1	2847862	g13580	i0	70.4	0.848605577689243	71	17	80.1	1	49	249	15	85	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	213	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29457219	29457219	PRJNA971676_P_NODE_810_length_796_cov_1.466113_g735_i0	PRJNA971676	810	796	1.466113	11.67025948	Coleofasciculus sp. G2-EDA-02	3069529	Bacteria	Bacteria	127	2.24e-31	NR	MEQ9669851.1	3069529	g735	i0	39.6	2.51005025125628	217	114	79.9	8	157	792	34	238	MEQ9669851.1 carbonic anhydrase family protein [Coleofasciculus sp. G2-EDA-02]	diamond	1998	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. G2-EDA-02
29552064	29552064	PRJNA971676_P_NODE_15650_length_249_cov_0.875000_g15561_i0	PRJNA971676	15650	249	0.875	2.17875	Candidatus Saganbacteria bacterium	2575572	Bacteria	Bacteria	132	1.5599999999999998e-35	NR	NQT29110.1	2575572	g15561	i0	92.8	1	83	6	100	0	249	1	203	285	NQT29110.1 transposase [Candidatus Saganbacteria bacterium]	diamond	249	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						Candidatus Saganbacteria bacterium
29899756	29899756	PRJNA971676_P_NODE_12191_length_266_cov_1.025907_g12102_i0	PRJNA971676	12191	266	1.025907	2.72891262	Symploca sp. SIO2D2	2607789	Bacteria	Bacteria	43.5	0.0184	NR	NEQ66386.1	2607789	g12102	i0	43.6	0.43984962406015	39	22	44	0	139	255	95	133	NEQ66386.1 biotin transporter BioY [Symploca sp. SIO2D2]	diamond	117	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO2D2
29969021	29969021	PRJNA971676_P_NODE_15231_length_250_cov_0.870056_g15142_i0	PRJNA971676	15231	250	0.870056	2.17514	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	97.1	3.3e-21	NR	WP_280654083.1	105352	g15142	i0	63.9	10.776	83	28	99.6	1	250	2	906	986	WP_280654083.1 Eco57I restriction-modification methylase domain-containing protein [Chrysosporum bergii]	diamond	2694	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Chrysosporum	Chrysosporum bergii
30057428	30057428	PRJNA971676_P_NODE_12291_length_265_cov_0.776042_g12202_i0	PRJNA971676	12291	265	0.776042	2.0565113	Symploca sp. SIO2D2	2607789	Bacteria	Bacteria	47	9.76e-4	NR	NEQ66386.1	2607789	g12202	i0	42.9	0.554716981132075	49	28	55.5	0	249	103	88	136	NEQ66386.1 biotin transporter BioY [Symploca sp. SIO2D2]	diamond	147	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO2D2
30120617	30120617	PRJNA971676_P_NODE_11572_length_271_cov_2.232323_g11483_i0	PRJNA971676	11572	271	2.232323	6.04959533	Calothrix sp. HK-	1187	Bacteria	Bacteria	84.7	7.24e-17	NR	OKH54609.1	1137096	g11483	i0	47.9	2.12546125461255	96	38	99.6	3	271	2	113	202	OKH54609.1 hypothetical protein NIES2101_07325 [Calothrix sp. HK-06]	diamond	576	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. HK-06
30973966	30973966	PRJNA971676_P_NODE_14274_length_251_cov_0.865169_g14185_i0	PRJNA971676	14274	251	0.865169	2.17157419	unclassified Limnothrix	2632864	Bacteria	Bacteria	48.9	2.21e-4	NR	WP_190356054.1	2632864	g14185	i0	41.1	3.39442231075697	56	33	66.9	0	3	170	13	68	WP_190356054.1 MULTISPECIES: histidine phosphatase family protein [unclassified Limnothrix]	diamond	852	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix
31606218	31606218	PRJNA971676_P_NODE_17116_length_248_cov_0.880000_g17027_i0	PRJNA971676	17116	248	0.88	2.1824	Leptolyngbyaceae cyanobacterium CSU_1_3	2720410	Bacteria	Bacteria	53.1	6.24e-6	NR	NJR50899.1	2720410	g17027	i0	42.3	2.55241935483871	71	29	85.9	2	227	15	74	132	NJR50899.1 SIMPL domain-containing protein [Leptolyngbyaceae cyanobacterium CSU_1_3]	diamond	633	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium CSU_1_3
31985674	31985674	PRJNA971676_P_NODE_6158_length_343_cov_1.137037_g6069_i0	PRJNA971676	6158	343	1.137037	3.90003691	Phormidium sp.	1199	Bacteria	Bacteria	89	3.16e-18	NR	HEY9300184.1	1199	g6069	i0	41.7	0.900874635568513	103	60	90.1	0	310	2	32	134	HEY9300184.1 reverse transcriptase family protein [Phormidium sp.]	diamond	309	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp.

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