metadata: contig_metadata: 9 rows where bioproject = "PRJNA1108487", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

9 rows where bioproject = "PRJNA1108487", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_kingdom = "Bacillati"

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
10416879	10416879	PRJNA1108487_P_NODE_7429_length_266_cov_1.616580_g7363_i0	PRJNA1108487	7429	266	1.61658	4.3001028	Leptolyngbya sp. BL0902	1115757	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1949996095\|gb\|CP046155.1\|	1115757	g7363	i0	96.875	0.120300751879699	32	1	12	0	6	37	3559780	3559749	Leptolyngbya sp. BL0902 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
26963945	26963945	PRJNA1108487_P_NODE_9322_length_249_cov_0.886364_g9256_i0	PRJNA1108487	9322	249	0.886364	2.20704636	Scytonemataceae	1182	Bacteria	Bacteria	51.2	2.85e-5	NR	WP_073636339.1	1137095	g9256	i0	39.5	2.92771084337349	81	46	95.2	2	241	5	67	146	WP_073636339.1 CAP domain-containing protein [Scytonema sp. HK-05]	diamond	729	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05
26995481	26995481	PRJNA1108487_P_NODE_6422_length_283_cov_1.857143_g6356_i0	PRJNA1108487	6422	283	1.857143	5.25571469	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	48.5	4.73e-4	NR	WP_253274458.1	317936	g6356	i0	38.3	2.16254416961131	94	48	89	2	261	10	73	166	WP_253274458.1 CAP domain-containing protein [Nostoc sp. PCC 7107]	diamond	612	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7107
27225599	27225599	PRJNA1108487_P_NODE_6483_length_282_cov_1.492823_g6417_i0	PRJNA1108487	6483	282	1.492823	4.20976086	Gloeobacter violaceus	33072	Bacteria	Bacteria	112	6.3099999999999996e-27	NR	WP_011142310.1	33072	g6417	i0	79.2	3.26595744680851	77	15	81.9	1	3	233	332	407	WP_011142310.1 phosphoglycerate kinase [Gloeobacter violaceus]	diamond	921	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
27352453	27352453	PRJNA1108487_P_NODE_9163_length_250_cov_0.881356_g9097_i0	PRJNA1108487	9163	250	0.881356	2.20339	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	44.7	0.00793	NR	MEY3401625.1	2847862	g9097	i0	34.1	1.02	85	53	98.4	2	4	249	190	274	MEY3401625.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	255	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27447194	27447194	PRJNA1108487_P_NODE_2343_length_443_cov_2.756757_g2277_i0	PRJNA1108487	2343	443	2.756757	12.21243351	Geminocystis sp. NIES-37	2664100	Bacteria	Bacteria	69.7	4.44e-11	NR	WP_066348180.1	1615909	g2277	i0	51.6	1.73363431151242	64	29	42	1	187	2	113	176	WP_066348180.1 hypothetical protein [Geminocystis sp. NIES-3708]	diamond	768	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3708
30257644	30257644	PRJNA1108487_P_NODE_9752_length_248_cov_0.880000_g9686_i0	PRJNA1108487	9752	248	0.88	2.1824	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	58.5	1.07e-7	NR	MBX9690430.1	2364082	g9686	i0	55.6	3.01209677419355	54	20	65.3	1	87	248	577	626	MBX9690430.1 PAS domain S-box protein [Candidatus Obscuribacterales bacterium]	diamond	747	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31300026	31300026	PRJNA1108487_P_NODE_275_length_1132_cov_6.537299_g236_i0	PRJNA1108487	275	1132	6.537299	74.00222468	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	464	5.099999999999999e-161	NR	MBX9694561.1	2847862	g236	i0	73.4	2.5839222614841	308	77	80.3	2	1085	177	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2925	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32619723	32619723	PRJNA1108487_P_NODE_5540_length_302_cov_1.362445_g5474_i0	PRJNA1108487	5540	302	1.362445	4.1145839	Cyanophyceae	3028117	Bacteria	Bacteria	51.2	7.82e-5	NR	RNJ66447.1	2483801	g5474	i0	32.6	2.75165562913907	92	56	91.4	3	25	300	173	258	RNJ66447.1 MAG: HAMP domain-containing protein [Leptolyngbya sp. IPPAS B-1204]	diamond	831	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. IPPAS B-1204

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