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

10 rows where analysis = "diamond", bioproject = "PRJNA902848" 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
26802599	26802599	PRJNA902848_P_NODE_8281_length_307_cov_2.000000_g8231_i0	PRJNA902848	8281	307	2	6.14	cyanobacterium TDX16	1503470	Bacteria	Bacteria	61.6	5.27e-10	NR	OWY71756.1	1503470	g8231	i0	72	0.488599348534202	50	14	48.9	0	12	161	34	83	OWY71756.1 hypothetical protein B7486_08805 [cyanobacterium TDX16]	diamond	150	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
26834462	26834462	PRJNA902848_P_NODE_16621_length_247_cov_1.787356_g16571_i0	PRJNA902848	16621	247	1.787356	4.41476932	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	157	1.7499999999999999e-46	NR	MEB3194172.1	2847862	g16571	i0	97.5	0.983805668016194	81	2	98.4	0	3	245	60	140	MEB3194172.1 ABC transporter ATP-binding protein [Cyanobacteriota bacterium]	diamond	243	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
26866289	26866289	PRJNA902848_P_NODE_10301_length_281_cov_1.418269_g10251_i0	PRJNA902848	10301	281	1.418269	3.98533589	Synechococcales	1890424	Bacteria	Bacteria	107	1.62e-28	NR	WP_198953869.1	1890424	g10251	i0	84.2	0.608540925266904	57	9	60.9	0	176	6	1	57	WP_198953869.1 MULTISPECIES: hypothetical protein [Synechococcales]	diamond	171	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales
28263425	28263425	PRJNA902848_P_NODE_15306_length_250_cov_0.881356_g15256_i0	PRJNA902848	15306	250	0.881356	2.20339	Bacillati	1783272	Bacteria	Bacteria	134	6.67e-36	NR	WP_323272828.1	1118279	g15256	i0	73.2	2.94	82	22	98.4	0	2	247	248	329	WP_323272828.1 ISAs1 family transposase [Limnoraphis robusta]	diamond	735	135	0.992592592592593	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnoraphis	Limnoraphis robusta
28571699	28571699	PRJNA902848_P_NODE_14247_length_251_cov_0.876404_g14197_i0	PRJNA902848	14247	251	0.876404	2.19977404	Nodosilinea sp.	2497642	Bacteria	Bacteria	59.7	4.28e-8	NR	MFM7324549.1	2497642	g14197	i0	43.4	2.86852589641434	83	43	95.6	2	11	250	202	283	MFM7324549.1 NADH-quinone oxidoreductase subunit M [Nodosilinea sp.]	diamond	720	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp.
30000388	30000388	PRJNA902848_P_NODE_20011_length_242_cov_0.923077_g19961_i0	PRJNA902848	20011	242	0.923077	2.23384634	Prochlorococcus	1218	Bacteria	Bacteria	118	9.529999999999999e-30	NR	WP_261792576.1	1219	g19961	i0	80.3	4.06611570247934	66	13	81.8	0	3	200	296	361	WP_261792576.1 FkbM family methyltransferase [Prochlorococcus marinus]	diamond	984	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
30845792	30845792	PRJNA902848_P_NODE_20374_length_242_cov_0.923077_g20324_i0	PRJNA902848	20374	242	0.923077	2.23384634	Nodosilinea sp.	2497642	Bacteria	Bacteria	58.2	1.34e-7	NR	HSM84046.1	2497642	g20324	i0	44.2	0.644628099173554	52	29	64.5	0	235	80	510	561	HSM84046.1 glycosyltransferase family 39 protein [Nodosilinea sp.]	diamond	156	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp.
31327328	31327328	PRJNA902848_P_NODE_18875_length_244_cov_0.912281_g18825_i0	PRJNA902848	18875	244	0.912281	2.22596564	Cyanophyceae	3028117	Bacteria	Bacteria	92.4	3.54e-20	NR	TAF53186.1	1151	g18825	i0	61.3	2.76639344262295	75	28	91	1	15	236	1	75	TAF53186.1 MAG: hypothetical protein EAZ61_07195 [Oscillatoriales cyanobacterium]	diamond	675	92.8	0.995689655172414	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
31446330	31446330	PRJNA902848_P_NODE_17616_length_246_cov_0.901734_g17566_i0	PRJNA902848	17616	246	0.901734	2.21826564	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	150	3.7e-42	NR	MBL0189678.1	2711154	g17566	i0	86.4	0.98780487804878	81	11	98.8	0	245	3	36	116	MBL0189678.1 aldo/keto reductase [Candidatus Obscuribacter sp.]	diamond	243	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32490529	32490529	PRJNA902848_P_NODE_6739_length_333_cov_2.615385_g6689_i0	PRJNA902848	6739	333	2.615385	8.70923205	cyanobacterium TDX16	1503470	Bacteria	Bacteria	49.3	4.68e-5	NR	OWY71756.1	1503470	g6689	i0	70.3	0.333333333333333	37	11	33.3	0	195	85	47	83	OWY71756.1 hypothetical protein B7486_08805 [cyanobacterium TDX16]	diamond	111	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16

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