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

15 rows where bioproject = "PRJNA1067443" 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
181628	181628	PRJNA1067443_P_NODE_24021_length_226_cov_2.601307_g24003_i0	PRJNA1067443	24021	226	2.601307	5.87895382	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	329	8.3e-86	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g24003	i0	92.92	17.8716814159292	226	16	100	0	1	226	4087973	4087748	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	4039	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
8666651	8666651	PRJNA1067443_P_NODE_17587_length_249_cov_0.875000_g17569_i0	PRJNA1067443	17587	249	0.875	2.17875	Nostoc	1177	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|1866646741\|gb\|CP040281.1\|	2576903	g17569	i0	96.787	25.3172690763052	249	8	100	0	1	249	3592920	3593168	Nostoc sp. C057 chromosome, complete genome	blastn	6304	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C057
13766707	13766707	PRJNA1067443_P_NODE_10931_length_280_cov_1.178744_g10913_i0	PRJNA1067443	10931	280	1.178744	3.3004832	Tolypothrix sp. NIES-4	3100432	Bacteria	Bacteria	170	3.2299999999999997e-48	NR	WP_089127509.1	2005459	g10913	i0	92.4	0.985714285714286	92	7	98.6	0	278	3	227	318	WP_089127509.1 mercuric reductase [Tolypothrix sp. NIES-4075]	diamond	276	170	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. NIES-4075
26782634	26782634	PRJNA1067443_P_NODE_17121_length_250_cov_0.870056_g17103_i0	PRJNA1067443	17121	250	0.870056	2.17514	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	157	6.75e-44	NR	WP_106370059.1	2107693	g17103	i0	91.5	0.984	82	7	98.4	0	248	3	290	371	WP_106370059.1 DICT sensory domain-containing protein [Chlorogloea sp. CCALA 695]	diamond	246	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
26940628	26940628	PRJNA1067443_P_NODE_20142_length_245_cov_0.895349_g20124_i0	PRJNA1067443	20142	245	0.895349	2.19360505	Scytonema sp. PCC 1	1204	Bacteria	Bacteria	155	8.67e-42	NR	WP_414587761.1	1680591	g20124	i0	100	0.991836734693878	81	0	99.2	0	3	245	479	559	WP_414587761.1 CHAT domain-containing tetratricopeptide repeat protein [Scytonema sp. PCC 10023]	diamond	243	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023
26963809	26963809	PRJNA1067443_P_NODE_622_length_653_cov_2.039655_g604_i0	PRJNA1067443	622	653	2.039655	13.31894715	Cyanophyceae	3028117	Bacteria	Bacteria	156	2.9199999999999996e-45	NR	WP_396095035.1	2627006	g604	i0	73.6	2.50842266462481	110	27	50.1	2	320	646	2	110	WP_396095035.1 MULTISPECIES: cupin domain-containing protein [unclassified Cyanobium]	diamond	1638	157	0.993630573248408	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium
27193585	27193585	PRJNA1067443_P_NODE_19822_length_245_cov_1.790698_g19804_i0	PRJNA1067443	19822	245	1.790698	4.3872101	Scytonema sp. HK-	1204	Bacteria	Bacteria	143	1.36e-37	NR	WP_096549433.1	1137095	g19804	i0	96.3	0.991836734693878	81	3	99.2	0	3	245	93	173	WP_096549433.1 PAS domain S-box protein [Scytonema sp. HK-05]	diamond	243	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05
27825500	27825500	PRJNA1067443_P_NODE_284_length_809_cov_15.354620_g270_i0	PRJNA1067443	284	809	15.35462	124.2188758	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	360	6.92e-123	NR	MBC7998560.1	2052166	g270	i0	87	2.74412855377009	185	24	68.6	0	804	250	54	238	MBC7998560.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	2220	360	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27911489	27911489	PRJNA1067443_P_NODE_22105_length_242_cov_0.911243_g22087_i0	PRJNA1067443	22105	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	56.2	6.38e-7	NR	MCA0312712.1	2052166	g22087	i0	44.9	1.8099173553719	78	36	93	3	240	16	57	130	MCA0312712.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium]	diamond	438	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29048528	29048528	PRJNA1067443_P_NODE_18988_length_247_cov_0.885057_g18970_i0	PRJNA1067443	18988	247	0.885057	2.18609079	Cyanophyceae	3028117	Bacteria	Bacteria	110	3.71e-26	NR	WP_194014801.1	1126	g18970	i0	66.7	8.92712550607287	81	27	98.4	0	247	5	74	154	WP_194014801.1 thiamine pyrophosphate-binding protein, partial [Microcystis aeruginosa]	diamond	2205	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
29972495	29972495	PRJNA1067443_P_NODE_8351_length_300_cov_2.030837_g8333_i0	PRJNA1067443	8351	300	2.030837	6.092511	Pseudanabaena sp.	1153	Bacteria	Bacteria	79	7.69e-15	NR	MFO0300550.1	1153	g8333	i0	76	0.97	50	10	48	1	274	131	1	50	MFO0300550.1 IS110 family transposase [Pseudanabaena sp.]	diamond	291	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
31457875	31457875	PRJNA1067443_P_NODE_2536_length_438_cov_12.323288_g2518_i0	PRJNA1067443	2536	438	12.323288	53.97600144	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	225	1.33e-66	NR	HIA54118.1	2052166	g2518	i0	79.6	1.95205479452055	142	28	96.6	1	423	1	489	630	HIA54118.1 efflux RND transporter permease subunit [Candidatus Melainabacteria bacterium]	diamond	855	225	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31647363	31647363	PRJNA1067443_P_NODE_13117_length_267_cov_1.355670_g13099_i0	PRJNA1067443	13117	267	1.35567	3.6196389	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	93.2	2.86e-21	NR	WP_106369774.1	2107693	g13099	i0	98.1	0.584269662921348	52	1	58.4	0	265	110	156	207	WP_106369774.1 DsbA family oxidoreductase [Chlorogloea sp. CCALA 695]	diamond	156	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
32122267	32122267	PRJNA1067443_P_NODE_18298_length_248_cov_0.880000_g18280_i0	PRJNA1067443	18298	248	0.88	2.1824	Aliterella atlantica	1827278	Bacteria	Bacteria	152	3.52e-42	NR	WP_045052720.1	1827278	g18280	i0	95.1	0.979838709677419	81	3	98	1	247	5	235	314	WP_045052720.1 glycosyltransferase family 2 protein [Aliterella atlantica]	diamond	243	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
32879869	32879869	PRJNA1067443_P_NODE_21760_length_242_cov_1.378698_g21742_i0	PRJNA1067443	21760	242	1.378698	3.33644916	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	46.2	0.0021	NR	MCX5943945.1	2847862	g21742	i0	32.9	1.05371900826446	85	49	99.2	2	240	1	163	244	MCX5943945.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	255	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota 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);;