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

15 rows where bioproject = "PRJNA994052" 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
2548947	2548947	PRJNA994052_P_NODE_75682_length_205_cov_143.871212_g74426_i0	PRJNA994052	75682	205	143.871212	294.9359846	Planktothrix	54304	Bacteria	Bacteria	359	9.42e-95	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g74426	i0	99	163.960975609756	200	2	99	0	3	202	623222	623421	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	33612	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
3825004	3825004	PRJNA994052_P_NODE_18283_length_311_cov_45.726891_g17061_i0	PRJNA994052	18283	311	45.726891	142.21063101	root	1	Root_unresolved	Root_unresolved	278	4.4e-70	NTclustered	gi\|63022551\|gb\|DQ004310.1\|	1211	g17061	i0	100	169.565916398714	150	0	58	0	1	150	210	61	Uncultured cyanobacterium clone PEN12 16S ribosomal RNA gene, partial sequence	blastn	52735	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
10201931	10201931	PRJNA994052_P_NODE_79168_length_201_cov_138.335938_g77911_i0	PRJNA994052	79168	201	138.335938	278.05523538	Cyanophyceae	3028117	Bacteria	Bacteria	305	1.22e-78	NTclustered	gi\|225696212\|gb\|FJ805879.1\|	259957	g77911	i0	94.444	179.059701492537	198	11	99	0	4	201	1827	1630	Uncultured Chroococcidiopsis sp. clone A3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35991	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15301104	15301104	PRJNA994052_P_NODE_68172_length_215_cov_5.429577_g66916_i0	PRJNA994052	68172	215	5.429577	11.67359055	Planktothrix	54304	Bacteria	Bacteria	398	2.1099999999999997e-106	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g66916	i0	100	12.8697674418605	215	0	100	0	1	215	643611	643397	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	2767	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
22653942	22653942	PRJNA994052_P_NODE_79178_length_201_cov_131.078125_g77921_i0	PRJNA994052	79178	201	131.078125	263.46703125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	300	5.65e-77	NTclustered	gi\|225696212\|gb\|FJ805879.1\|	259957	g77921	i0	93.939	165.094527363184	198	12	99	0	4	201	1827	1630	Uncultured Chroococcidiopsis sp. clone A3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33184	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26678009	26678009	PRJNA994052_P_NODE_64281_length_220_cov_12.374150_g63025_i0	PRJNA994052	64281	220	12.37415	27.22313	Sphaerospermopsis sp.	3100406	Bacteria	Bacteria	90.9	3.06e-19	NR	MEB3151466.1	3100406	g63025	i0	58	0.940909090909091	69	29	94.1	0	214	8	10	78	MEB3151466.1 hypothetical protein [Sphaerospermopsis sp.]	diamond	207	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis sp.
28194913	28194913	PRJNA994052_P_NODE_29126_length_284_cov_21.981043_g27884_i0	PRJNA994052	29126	284	21.981043	62.42616212	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	104	1.2299999999999997e-23	NR	MBK7841898.1	2711154	g27884	i0	94	0.528169014084507	50	3	52.8	0	134	283	279	328	MBK7841898.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	150	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28352932	28352932	PRJNA994052_P_NODE_58506_length_228_cov_30.503226_g57250_i0	PRJNA994052	58506	228	30.503226	69.54735528	Candidatus Saganbacteria bacterium	2575572	Bacteria	Bacteria	59.7	3.12e-8	NR	MBI5399194.1	2575572	g57250	i0	61.7	1.21052631578947	47	18	61.8	0	220	80	149	195	MBI5399194.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Candidatus Saganbacteria bacterium]	diamond	276	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati						Candidatus Saganbacteria bacterium
28889677	28889677	PRJNA994052_P_NODE_65848_length_218_cov_6.165517_g64592_i0	PRJNA994052	65848	218	6.165517	13.44082706	Hassallia byssoidea	482630	Bacteria	Bacteria	59.3	3.83e-8	NR	WP_163519298.1	482630	g64592	i0	47.8	0.922018348623853	67	27	92.2	1	7	207	145	203	WP_163519298.1 glycosyl hydrolase family 28-related protein [Hassallia byssoidea]	diamond	201	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
29331762	29331762	PRJNA994052_P_NODE_61929_length_223_cov_25.120000_g60673_i0	PRJNA994052	61929	223	25.12	56.0176	Microcystis sp. M	1127	Bacteria	Bacteria	143	6.88e-39	NR	WP_287873658.1	2771111	g60673	i0	89	0.982062780269058	73	8	98.2	0	219	1	185	257	WP_287873658.1 PBSX family phage terminase large subunit [Microcystis sp. M034S1]	diamond	219	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M034S1
30215895	30215895	PRJNA994052_P_NODE_13252_length_316_cov_18.654321_g12032_i0	PRJNA994052	13252	316	18.654321	58.94765436	Acaryochloridaceae cyanobacterium RU_4_10	2720443	Bacteria	Bacteria	104	6.569999999999999e-24	NR	NJM77419.1	2720443	g12032	i0	89.1	0.522151898734177	55	6	52.2	0	146	310	245	299	NJM77419.1 diguanylate cyclase [Acaryochloridaceae cyanobacterium RU_4_10]	diamond	165	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae		Acaryochloridaceae cyanobacterium RU_4_10
30317245	30317245	PRJNA994052_P_NODE_22972_length_301_cov_4.381579_g21743_i0	PRJNA994052	22972	301	4.381579	13.18855279	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	63.2	5.67e-10	NR	WP_036903339.1	1218	g21743	i0	39.6	2.85049833887043	96	49	95.7	2	290	3	10	96	WP_036903339.1 MULTISPECIES: LexA family protein [Prochlorococcus]	diamond	858	63.5	0.995275590551181	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus
30658409	30658409	PRJNA994052_P_NODE_64033_length_220_cov_34.238095_g62777_i0	PRJNA994052	64033	220	34.238095	75.323809	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	107	1.12e-25	NR	MFN8579325.1	2762020	g62777	i0	62.5	0.981818181818182	72	27	98.2	0	3	218	234	305	MFN8579325.1 site-specific DNA-methyltransferase [Candidatus Sericytochromatia bacterium]	diamond	216	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31448640	31448640	PRJNA994052_P_NODE_66936_length_216_cov_55.300699_g65680_i0	PRJNA994052	66936	216	55.300699	119.44950984	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	107	2.41e-28	NR	HVO23915.1	2053573	g65680	i0	76.1	0.930555555555556	67	16	93.1	0	203	3	1	67	HVO23915.1 hypothetical protein [Candidatus Margulisiibacteriota bacterium]	diamond	201	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
31827938	31827938	PRJNA994052_P_NODE_23457_length_299_cov_25.876106_g22225_i0	PRJNA994052	23457	299	25.876106	77.36955694	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	123	4.1699999999999995e-30	NR	MBX3154023.1	2364082	g22225	i0	78.4	0.973244147157191	97	17	93.3	1	20	298	1082	1178	MBX3154023.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	291	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;