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

12 rows where analysis = "diamond", bioproject = "PRJNA977246" 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
2544476	2544476	PRJNA977246_S_NODE_21282_length_295_cov_7053.808271_g20290_i0	PRJNA977246	21282	295	7053.808271	20808.73439945	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	141	5.4e-40	NR	MBF2055286.1	2762020	g20290	i0	79.1	0.874576271186441	86	18	87.5	0	37	294	60	145	MBF2055286.1 50S ribosomal protein L3 [Candidatus Sericytochromatia bacterium]	diamond	258	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
21671210	21671210	PRJNA977246_S_NODE_23637_length_274_cov_1.795918_g22645_i0	PRJNA977246	23637	274	1.795918	4.92081532	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	110	6.5e-28	NR	MBF2055286.1	2762020	g22645	i0	82.8	0.700729927007299	64	11	70.1	0	272	81	149	212	MBF2055286.1 50S ribosomal protein L3 [Candidatus Sericytochromatia bacterium]	diamond	192	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29621262	29621262	PRJNA977246_S_NODE_49930_length_154_cov_2.312000_g48938_i0	PRJNA977246	49930	154	2.312	3.56048	root	1	Root_unresolved	Root_unresolved	48.1	2.81e-5	NR	WP_130129199.1	59932	g48938	i0	56.8	1.71428571428571	44	17	85.7	1	19	150	68	109	WP_130129199.1 nucleoside triphosphate pyrophosphohydrolase family protein [Synechococcus sp. WH 8101]	diamond	264	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. WH 8101
29709940	29709940	PRJNA977246_S_NODE_29150_length_232_cov_2.665025_g28158_i0	PRJNA977246	29150	232	2.665025	6.182858	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	112	2.15e-28	NR	MBK9206339.1	2711154	g28158	i0	71.8	7.06034482758621	78	21	99.6	1	231	1	106	183	MBK9206339.1 DUF58 domain-containing protein [Candidatus Obscuribacter sp.]	diamond	1638	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30057613	30057613	PRJNA977246_S_NODE_50751_length_152_cov_2.861789_g49759_i0	PRJNA977246	50751	152	2.861789	4.34991928	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	52.8	1.89e-6	NR	MFN4150756.1	2762020	g49759	i0	77.4	0.611842105263158	31	7	61.2	0	95	3	1	31	MFN4150756.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	93	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30474752	30474752	PRJNA977246_S_NODE_51573_length_150_cov_3.851240_g50581_i0	PRJNA977246	51573	150	3.85124	5.77686	root	1	Root_unresolved	Root_unresolved	88.6	2.45e-21	NR	MFN4152679.1	2762020	g50581	i0	89.8	1.96	49	5	98	0	2	148	32	80	MFN4152679.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	294	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30600892	30600892	PRJNA977246_S_NODE_16633_length_351_cov_4.642857_g15641_i0	PRJNA977246	16633	351	4.642857	16.29642807	Bacteria	2	Bacteria	Bacteria	107	1.97e-24	NR	OGI20147.1	1801607	g15641	i0	68.7	1.14529914529915	67	21	57.3	0	328	128	548	614	OGI20147.1 MAG: hypothetical protein A3B68_00960 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	402	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
30626293	30626293	PRJNA977246_S_NODE_51693_length_150_cov_2.809917_g50701_i0	PRJNA977246	51693	150	2.809917	4.2148755	Candidatus Caenarcanales bacterium	2729995	Bacteria	Bacteria	61.6	2.19e-9	NR	MDX1921287.1	2729995	g50701	i0	67.5	1.6	40	13	80	0	123	4	284	323	MDX1921287.1 DUF2779 domain-containing protein [Candidatus Caenarcanales bacterium]	diamond	240	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
31353386	31353386	PRJNA977246_S_NODE_46756_length_161_cov_4.136364_g45764_i0	PRJNA977246	46756	161	4.136364	6.65954604	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	109	8.71e-28	NR	MFN4149905.1	2762020	g45764	i0	94.3	0.987577639751553	53	3	98.8	0	160	2	76	128	MFN4149905.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	159	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31643953	31643953	PRJNA977246_S_NODE_17236_length_342_cov_5.616613_g16244_i0	PRJNA977246	17236	342	5.616613	19.20881646	Bacteria	2	Bacteria	Bacteria	110	5.67e-27	NR	OGI20819.1	1801607	g16244	i0	86.7	1.57894736842105	60	8	52.6	0	2	181	137	196	OGI20819.1 MAG: hypothetical protein A3B68_09815 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	540	111	0.990990990990991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
31890995	31890995	PRJNA977246_S_NODE_38677_length_186_cov_3.369427_g37685_i0	PRJNA977246	38677	186	3.369427	6.26713422	uncultured Microcoleus sp.	259945	Bacteria	Bacteria	44.3	6.28e-4	NR	CAA9391246.1	259945	g37685	i0	66.7	0.532258064516129	33	11	53.2	0	86	184	2	34	CAA9391246.1 hypothetical protein AVDCRST_MAG84-5622 [uncultured Microcoleus sp.]	diamond	99	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	uncultured Microcoleus sp.
32397412	32397412	PRJNA977246_S_NODE_13439_length_405_cov_4.521277_g12458_i0	PRJNA977246	13439	405	4.521277	18.31117185	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	164	1.86e-46	NR	MBI3591717.1	2052166	g12458	i0	67.3	1.62222222222222	110	35	80.7	1	330	4	95	204	MBI3591717.1 molecular chaperone DnaJ [Candidatus Melainabacteria bacterium]	diamond	657	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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