metadata: contig_metadata: 15 rows where bioproject = "PRJNA688352" and tax_clade = "Cyanobacteriota/Melainabacteria group"

15 rows where bioproject = "PRJNA688352" 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
3728527	3728527	PRJNA688352_P_NODE_1363_length_510_cov_2.302059_g1260_i0	PRJNA688352	1363	510	2.302059	11.7405009	Microcoleus	44471	Bacteria	Bacteria	881	0	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g1260	i0	97.847	156.364705882353	511	9	100	2	1	510	133450	132941	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	79746	881	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
9595469	9595469	PRJNA688352_P_NODE_6828_length_254_cov_1.701657_g6725_i0	PRJNA688352	6828	254	1.701657	4.32220878	uncultured cyanobacterium	1211	Bacteria	Bacteria	459	1.1599999999999999e-124	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g6725	i0	99.213	176.850393700787	254	2	100	0	1	254	3343	3596	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44920	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15969611	15969611	PRJNA688352_P_NODE_7693_length_250_cov_0.870056_g7590_i0	PRJNA688352	7693	250	0.870056	2.17514	Stanieria cyanosphaera	102116	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|428267688\|gb\|CP003653.1\|	111780	g7590	i0	100	1.616	30	0	12	0	56	85	3017614	3017643	Stanieria cyanosphaera PCC 7437, complete genome	blastn	404	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
22344169	22344169	PRJNA688352_P_NODE_11458_length_243_cov_0.905882_g11355_i0	PRJNA688352	11458	243	0.905882	2.20129326	Synechococcus sp. CBW1108	1353147	Bacteria	Bacteria	388	1.47e-103	NTclustered	gi\|1940487417\|gb\|CP060395.1\|	1353147	g11355	i0	95.492	1.00411522633745	244	10	100	1	1	243	3052975	3053218	Synechococcus sp. CBW1108 chromosome, complete genome	blastn	244	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1108
26797405	26797405	PRJNA688352_P_NODE_10901_length_244_cov_0.900585_g10798_i0	PRJNA688352	10901	244	0.900585	2.1974274	Pseudanabaena sp. PCC 68	1153	Bacteria	Bacteria	72.8	9.53e-13	NR	WP_019498846.1	118173	g10798	i0	68	0.614754098360656	50	16	61.5	0	90	239	363	412	WP_019498846.1 peptidase domain-containing ABC transporter [Pseudanabaena sp. PCC 6802]	diamond	150	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802
28061278	28061278	PRJNA688352_P_NODE_9125_length_247_cov_0.885057_g9022_i0	PRJNA688352	9125	247	0.885057	2.18609079	Candidatus Saganbacteria bacterium	2575572	Bacteria	Bacteria	56.2	4.72e-7	NR	NQU18409.1	2575572	g9022	i0	50.9	0.643724696356275	53	26	64.4	0	85	243	10	62	NQU18409.1 flagellar hook-length control protein FliK [Candidatus Saganbacteria bacterium]	diamond	159	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						Candidatus Saganbacteria bacterium
28218993	28218993	PRJNA688352_P_NODE_8786_length_248_cov_0.880000_g8683_i0	PRJNA688352	8786	248	0.88	2.1824	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	114	2.6e-27	NR	MCL4385349.1	2847862	g8683	i0	69.9	1.00403225806452	83	24	99.2	1	2	247	121	203	MCL4385349.1 DUF4214 domain-containing protein [Cyanobacteriota bacterium]	diamond	249	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28787376	28787376	PRJNA688352_P_NODE_11607_length_242_cov_0.911243_g11504_i0	PRJNA688352	11607	242	0.911243	2.20520806	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	76.3	6.78e-16	NR	HEY9868908.1	2364082	g11504	i0	64.4	0.731404958677686	59	21	73.1	0	66	242	1	59	HEY9868908.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	177	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28957246	28957246	PRJNA688352_P_NODE_7208_length_251_cov_0.865169_g7105_i0	PRJNA688352	7208	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	153	5.3099999999999984e-43	NR	WP_228675523.1	446679	g7105	i0	92.8	8.91633466135458	83	6	99.2	0	1	249	53	135	WP_228675523.1 LLM class flavin-dependent oxidoreductase [Nostoc sphaeroides]	diamond	2238	154	0.993506493506494	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
29935970	29935970	PRJNA688352_P_NODE_11811_length_242_cov_0.911243_g11708_i0	PRJNA688352	11811	242	0.911243	2.20520806	Bacillati	1783272	Bacteria	Bacteria	65.5	2.22e-10	NR	MCL4384894.1	2847862	g11708	i0	44.8	1.66115702479339	67	37	83.1	0	42	242	114	180	MCL4384894.1 PKD domain-containing protein [Cyanobacteriota bacterium]	diamond	402	65.9	0.993930197268589	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30335412	30335412	PRJNA688352_P_NODE_8712_length_248_cov_0.880000_g8609_i0	PRJNA688352	8712	248	0.88	2.1824	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	147	6.42e-39	NR	WP_211626907.1	2812896	g8609	i0	82.9	3.96774193548387	82	14	99.2	0	1	246	88	169	WP_211626907.1 strawberry notch family protein [Leptolyngbya sp. 7M]	diamond	984	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
30441489	30441489	PRJNA688352_P_NODE_11633_length_242_cov_0.911243_g11530_i0	PRJNA688352	11633	242	0.911243	2.20520806	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	47	1.34e-4	NR	WP_300506911.1	2729996	g11530	i0	65.6	2.34297520661157	32	11	39.7	0	240	145	49	80	WP_300506911.1 type II toxin-antitoxin system HicA family toxin [Crocosphaera sp.]	diamond	567	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera sp.
30757340	30757340	PRJNA688352_P_NODE_9754_length_246_cov_0.890173_g9651_i0	PRJNA688352	9754	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	74.3	2.65e-13	NR	OLE44052.1	1805101	g9651	i0	100	21.2317073170732	33	0	40.2	0	2	100	138	170	OLE44052.1 MAG: hypothetical protein AUI36_23505 [Cyanobacteria bacterium 13_1_40CM_2_61_4]	diamond	5223	74.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium 13_1_40CM_2_61_4
31915523	31915523	PRJNA688352_P_NODE_10277_length_245_cov_0.895349_g10174_i0	PRJNA688352	10277	245	0.895349	2.19360505	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	92	1.73e-19	NR	MFN7739829.1	2847862	g10174	i0	56.4	1.91020408163265	78	34	95.5	0	4	237	587	664	MFN7739829.1 reverse transcriptase domain-containing protein [Cyanobacteriota bacterium]	diamond	468	92	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32200369	32200369	PRJNA688352_P_NODE_11618_length_242_cov_0.911243_g11515_i0	PRJNA688352	11618	242	0.911243	2.20520806	Candidatus Saganbacteria bacterium	2575572	Bacteria	Bacteria	82.8	2.86e-16	NR	MCX5749651.1	2575572	g11515	i0	55.7	0.979338842975207	79	35	97.9	0	238	2	9	87	MCX5749651.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Saganbacteria bacterium]	diamond	237	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						Candidatus Saganbacteria 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);;