metadata: contig_metadata: 9 rows where bioproject = "PRJEB6055" and tax_clade = "Cyanobacteriota/Melainabacteria group"

9 rows where bioproject = "PRJEB6055" 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
125533	125533	PRJEB6055_S_NODE_201_length_435_cov_7.525000_g179_i0	PRJEB6055	201	435	7.525	32.73375	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	640	7.05e-179	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g179	i0	95.522	123.767816091954	402	14	92	4	1	401	2413	2015	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53839	640	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6095424	6095424	PRJEB6055_S_NODE_565_length_326_cov_5.756014_g541_i0	PRJEB6055	565	326	5.756014	18.76460564	Cyanophyceae	3028117	Bacteria	Bacteria	590	5.2499999999999984e-164	NTclustered	gi\|372198042\|gb\|JN814218.1\|	1211	g541	i0	99.385	99.3036809815951	325	2	99	0	2	326	125	449	Uncultured cyanobacterium clone 23-21 16S ribosomal RNA gene, partial sequence	blastn	32373	590	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8645371	8645371	PRJEB6055_S_NODE_1287_length_252_cov_7.055300_g1263_i0	PRJEB6055	1287	252	7.0553	17.779356	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	142	4.389999999999999e-40	NR	MFN4150446.1	2762020	g1263	i0	86.1	0.94047619047619	79	11	94	0	1	237	121	199	MFN4150446.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	237	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
11195576	11195576	PRJEB6055_S_NODE_29_length_772_cov_8.194030_g17_i0	PRJEB6055	29	772	8.19403	63.2579116	Cyanophyceae	3028117	Bacteria	Bacteria	1103	0	NTclustered	gi\|225696276\|gb\|FJ805943.1\|	259957	g17	i0	93.458	98.9274611398964	749	39	96	8	29	772	3126	2383	Uncultured Chroococcidiopsis sp. clone AS5_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	76372	1103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14153936	14153936	PRJEB6055_S_NODE_112_length_508_cov_7.143763_g90_i0	PRJEB6055	112	508	7.143763	36.29031604	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	623	8.399999999999999e-174	NTclustered	gi\|225696276\|gb\|FJ805943.1\|	259957	g90	i0	91.164	112.433070866142	464	33	91	8	49	508	2842	2383	Uncultured Chroococcidiopsis sp. clone AS5_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57116	623	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21802291	21802291	PRJEB6055_S_NODE_398_length_358_cov_15.315789_g374_i0	PRJEB6055	398	358	15.315789	54.83052462	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	401	2.9199999999999995e-107	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g374	i0	91.216	102.030726256983	296	25	82	1	7	301	1898	1603	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36527	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23077556	23077556	PRJEB6055_S_NODE_259_length_404_cov_15.563686_g235_i0	PRJEB6055	259	404	15.563686	62.87729144	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	486	8.96e-133	NTclustered	gi\|225696226\|gb\|FJ805893.1\|	259957	g235	i0	91.785	167.559405940594	353	23	86	5	1	348	1953	1602	Uncultured Chroococcidiopsis sp. clone NA2_7 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	67694	486	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24351376	24351376	PRJEB6055_S_NODE_2400_length_206_cov_3.309942_g2376_i0	PRJEB6055	2400	206	3.309942	6.81848052	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	270	4.569999999999999e-68	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g2376	i0	90.338	181.087378640777	207	19	100	1	1	206	2343	2549	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37304	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
30444507	30444507	PRJEB6055_S_NODE_3733_length_178_cov_2.517483_g3709_i0	PRJEB6055	3733	178	2.517483	4.48111974	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	51.6	3.7e-6	NR	MFN4151784.1	2762020	g3709	i0	51.9	0.876404494382023	52	21	87.6	1	157	2	47	94	MFN4151784.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	156	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia 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);;