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

6 rows where analysis = "diamond", bioproject = "PRJNA577226" 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
28216379	28216379	PRJNA577226_S_NODE_59386_length_163_cov_1.238095_g58447_i0	PRJNA577226	59386	163	1.238095	2.01809485	unclassified Synechococcus	2626047	Bacteria	Bacteria	84.7	1.44e-17	NR	WP_259726860.1	2626047	g58447	i0	75.9	0.993865030674847	54	13	99.4	0	162	1	246	299	WP_259726860.1 MULTISPECIES: restriction endonuclease subunit S [unclassified Synechococcus]	diamond	162	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus
28532539	28532539	PRJNA577226_S_NODE_5867_length_572_cov_2.310280_g4947_i0	PRJNA577226	5867	572	2.31028	13.2148016	Cyanobium sp.	2164130	Bacteria	Bacteria	51.6	4.68e-4	NR	MFM7266224.1	2164130	g4947	i0	42.2	1.27447552447552	64	35	33.6	1	332	523	230	291	MFM7266224.1 J domain-containing protein [Cyanobium sp.]	diamond	729	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp.
30079460	30079460	PRJNA577226_S_NODE_41152_length_194_cov_1.242038_g40213_i0	PRJNA577226	41152	194	1.242038	2.40955372	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	60.1	6.24e-9	NR	MBX9690932.1	2847862	g40213	i0	40	1.00515463917526	65	35	99	2	193	2	110	171	MBX9690932.1 replication initiation factor domain-containing protein [Cyanobacteriota bacterium]	diamond	195	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31438369	31438369	PRJNA577226_S_NODE_37916_length_202_cov_1.533333_g36977_i0	PRJNA577226	37916	202	1.533333	3.09733266	Leptolyngbya sp. SIOISBB	2607771	Bacteria	Bacteria	42.7	0.0215	NR	NEQ46644.1	2607771	g36977	i0	45.8	0.712871287128713	48	26	71.3	0	197	54	283	330	NEQ46644.1 TonB-dependent receptor [Leptolyngbya sp. SIOISBB]	diamond	144	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIOISBB
31817941	31817941	PRJNA577226_S_NODE_42497_length_191_cov_1.266234_g41558_i0	PRJNA577226	42497	191	1.266234	2.41850694	Leptolyngbyaceae cyanobacterium MO_188.B28	3036643	Bacteria	Bacteria	44.3	0.00151	NR	MDJ0702823.1	3036643	g41558	i0	50	0.816753926701571	52	19	77	3	160	14	4	51	MDJ0702823.1 hypothetical protein [Leptolyngbyaceae cyanobacterium MO_188.B28]	diamond	156	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium MO_188.B28
32590955	32590955	PRJNA577226_S_NODE_27719_length_238_cov_1.164179_g26780_i0	PRJNA577226	27719	238	1.164179	2.77074602	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	47.4	7.37e-4	NR	WP_373541143.1	2814140	g26780	i0	56.3	2.29411764705882	32	14	40.3	0	1	96	98	129	WP_373541143.1 DUF488 family protein [Chamaesiphon sp.]	diamond	546	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon 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);;