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

6 rows where analysis = "diamond", bioproject = "PRJNA781427" 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
28316975	28316975	PRJNA781427_P_NODE_97226_length_241_cov_0.857143_g96342_i0	PRJNA781427	97226	241	0.857143	2.06571463	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	43.9	0.0134	NR	MEW5819744.1	2847862	g96342	i0	30.4	0.983402489626556	79	48	98.3	2	3	239	253	324	MEW5819744.1 FAD-binding oxidoreductase [Cyanobacteriota bacterium]	diamond	237	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29453218	29453218	PRJNA781427_P_NODE_89490_length_244_cov_0.900585_g88606_i0	PRJNA781427	89490	244	0.900585	2.1974274	Leptolyngbya sp. BL	47254	Bacteria	Bacteria	158	2.1e-45	NR	WP_198806809.1	1115757	g88606	i0	96.3	0.995901639344262	81	3	99.6	0	243	1	244	324	WP_198806809.1 glucokinase [Leptolyngbya sp. BL0902]	diamond	243	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
30622163	30622163	PRJNA781427_P_NODE_69973_length_261_cov_1.526596_g69089_i0	PRJNA781427	69973	261	1.526596	3.98441556	Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35	2801880	Bacteria	Bacteria	127	5.219999999999999e-32	NR	MBV8883153.1	2801880	g69089	i0	77.8	0.931034482758621	81	18	93.1	0	243	1	12	92	MBV8883153.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	243	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
31254224	31254224	PRJNA781427_P_NODE_85355_length_246_cov_0.890173_g84471_i0	PRJNA781427	85355	246	0.890173	2.18982558	Coleofasciculus chthonoplastes	64178	Bacteria	Bacteria	57.4	1.16e-7	NR	MEQ9359083.1	3069538	g84471	i0	50	1.39024390243902	56	28	68.3	0	4	171	148	203	MEQ9359083.1 methyltransferase domain-containing protein [Coleofasciculus chthonoplastes F2-STO-03]	diamond	342	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
31981670	31981670	PRJNA781427_P_NODE_51958_length_312_cov_1.200837_g51075_i0	PRJNA781427	51958	312	1.200837	3.74661144	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	50.8	1.26e-4	NR	MFH2033148.1	2053573	g51075	i0	46.9	0.615384615384615	64	28	61.5	2	291	100	399	456	MFH2033148.1 LPD23 domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	192	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
32203300	32203300	PRJNA781427_P_NODE_75298_length_251_cov_0.865169_g74414_i0	PRJNA781427	75298	251	0.865169	2.17157419	Oscillatoriales cyanobacterium	1151	Bacteria	Bacteria	83.2	2.21e-16	NR	TAF54585.1	1151	g74414	i0	95.5	0.525896414342629	44	2	52.6	0	119	250	1	44	TAF54585.1 MAG: F0F1 ATP synthase subunit beta [Oscillatoriales cyanobacterium]	diamond	132	83.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium

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