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

12 rows where analysis = "diamond", bioproject = "PRJNA235310" 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
23319427	23319427	PRJNA235310_P_NODE_439_length_555_cov_10.677866_g415_i0	PRJNA235310	439	555	10.677866	59.2621563	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	219	1.4899999999999998e-69	NR	CAI8350359.1	2024869	g415	i0	70.3	2.4	148	44	80	0	35	478	46	193	CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6]	diamond	1332	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ARS6
27200221	27200221	PRJNA235310_P_NODE_5582_length_166_cov_0.888889_g5556_i0	PRJNA235310	5582	166	0.888889	1.47555574	Leptolyngbyaceae cyanobacterium C42_A2020_001	2811131	Bacteria	Bacteria	50.8	1.81e-5	NR	MBF2028644.1	2811131	g5556	i0	41.8	3.97590361445783	55	32	99.4	0	1	165	24	78	MBF2028644.1 fatty acid desaturase [Leptolyngbyaceae cyanobacterium C42_A2020_001]	diamond	660	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium C42_A2020_001
28274007	28274007	PRJNA235310_P_NODE_1526_length_327_cov_1.169065_g1500_i0	PRJNA235310	1526	327	1.169065	3.82284255	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	130	1.2e-35	NR	MBL8086383.1	2711154	g1500	i0	76.1	0.807339449541284	88	16	77.1	2	325	74	58	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	264	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28670908	28670908	PRJNA235310_P_NODE_5867_length_164_cov_1.686957_g5841_i0	PRJNA235310	5867	164	1.686957	2.76660948	Chroococcidiopsis	54298	Bacteria	Bacteria	90.5	1.89e-19	NR	MEO1095502.1	3023210	g5841	i0	75.5	19.3719512195122	53	13	97	0	2	160	180	232	MEO1095502.1 transketolase [Cyanobacteria bacterium J06638_28]	diamond	3177	90.9	0.995599559955996	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06638_28
28684810	28684810	PRJNA235310_P_NODE_5647_length_166_cov_0.863248_g5621_i0	PRJNA235310	5647	166	0.863248	1.43299168	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	74.3	3.71e-14	NR	MFN8673338.1	2762020	g5621	i0	70	0.903614457831325	50	15	90.4	0	3	152	31	80	MFN8673338.1 SDR family oxidoreductase [Candidatus Sericytochromatia bacterium]	diamond	150	74.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29757989	29757989	PRJNA235310_P_NODE_2871_length_225_cov_1.181818_g2845_i0	PRJNA235310	2871	225	1.181818	2.6590905	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	60.5	1.64e-8	NR	BAU09863.1	1752064	g2845	i0	45.9	0.813333333333333	61	33	81.3	0	11	193	341	401	BAU09863.1 hypothetical protein LEP3755_03380 [Leptolyngbya sp. NIES-3755]	diamond	183	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
29902305	29902305	PRJNA235310_P_NODE_951_length_407_cov_1.581006_g925_i0	PRJNA235310	951	407	1.581006	6.43469442	Bacteria	2	Bacteria	Bacteria	51.2	2.54e-4	NR	WP_260324468.1	1126	g925	i0	37	3.1990171990172	100	59	71.5	3	21	311	884	982	WP_260324468.1 Calx-beta domain-containing protein [Microcystis aeruginosa]	diamond	1302	51.6	0.992248062015504	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
31210959	31210959	PRJNA235310_P_NODE_835_length_435_cov_1.318653_g809_i0	PRJNA235310	835	435	1.318653	5.73614055	Oscillatoria sp. PCC 1	1159	Bacteria	Bacteria	160	3.84e-46	NR	WP_017716299.1	1173028	g809	i0	64.7	3.28275862068966	119	39	82.1	1	435	79	124	239	WP_017716299.1 SDR family oxidoreductase [Oscillatoria sp. PCC 10802]	diamond	1428	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. PCC 10802
31591180	31591180	PRJNA235310_P_NODE_5696_length_165_cov_0.896552_g5670_i0	PRJNA235310	5696	165	0.896552	1.4793108	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	48.1	1.66e-4	NR	MEB3285026.1	2762020	g5670	i0	92.3	0.945454545454545	26	2	47.3	0	88	165	20	45	MEB3285026.1 diguanylate cyclase [Candidatus Sericytochromatia bacterium]	diamond	156	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31812404	31812404	PRJNA235310_P_NODE_6317_length_162_cov_0.920354_g6291_i0	PRJNA235310	6317	162	0.920354	1.49097348	Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11	1801609	Bacteria	Bacteria	52.4	4.81e-6	NR	OGI09100.1	1801609	g6291	i0	58.3	0.666666666666667	36	15	66.7	0	108	1	125	160	OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11]	diamond	108	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11
32083204	32083204	PRJNA235310_P_NODE_1458_length_335_cov_1.482517_g1432_i0	PRJNA235310	1458	335	1.482517	4.96643195	Bacillati	1783272	Bacteria	Bacteria	125	3.8e-33	NR	MBI3590799.1	2052166	g1432	i0	58.2	2.95522388059702	110	40	98.5	3	2	331	109	212	MBI3590799.1 SDR family oxidoreductase [Candidatus Melainabacteria bacterium]	diamond	990	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32255734	32255734	PRJNA235310_P_NODE_1778_length_299_cov_1.872000_g1752_i0	PRJNA235310	1778	299	1.872	5.59728	Crocosphaera sp.	2729996	Bacteria	Bacteria	46.6	0.00176	NR	WP_300508675.1	2729996	g1752	i0	37	1.55518394648829	81	42	75.3	3	293	69	13	90	WP_300508675.1 EF-hand domain-containing protein [Crocosphaera sp.]	diamond	465	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera 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);;