metadata: contig_metadata: 8 rows where bioproject = "PRJNA274362" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where bioproject = "PRJNA274362" 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
1058665	1058665	PRJNA274362_S_NODE_34201_length_166_cov_0.931624_g34081_i0	PRJNA274362	34201	166	0.931624	1.54649584	Oscillatoriales	1150	Bacteria	Bacteria	285	1.26e-72	NTclustered	gi\|2395771017\|gb\|CP066886.2\|	147317	g34081	i0	97.59	100.289156626506	166	4	100	0	1	166	2243644	2243809	Arthrospira sp. PCC 9108 chromosome, complete genome	blastn	16648	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PCC 9108
5474154	5474154	PRJNA274362_S_NODE_33725_length_167_cov_0.881356_g33605_i0	PRJNA274362	33725	167	0.881356	1.47186452	Dolichospermum circinale	109265	Bacteria	Bacteria	185	1.3199999999999999e-42	NTclustered	gi\|1566846258\|dbj\|LC455636.1\|	109265	g33605	i0	86.55	199.976047904192	171	19	100	4	1	167	320	150	Dolichospermum circinale NIES-1908 gene for 23S ribosomal RNA, partial sequence	blastn	33396	185	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum circinale
7436535	7436535	PRJNA274362_S_NODE_30386_length_173_cov_0.862903_g30266_i0	PRJNA274362	30386	173	0.862903	1.49282219	Oscillatoriales	1150	Bacteria	Bacteria	268	1.33e-67	NTclustered	gi\|2395771017\|gb\|CP066886.2\|	147317	g30266	i0	97.452	265.578034682081	157	4	92	0	1	157	3704581	3704425	Arthrospira sp. PCC 9108 chromosome, complete genome	blastn	45945	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PCC 9108
9298785	9298785	PRJNA274362_S_NODE_31688_length_169_cov_1.708333_g31568_i0	PRJNA274362	31688	169	1.708333	2.88708277	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	255	1e-63	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g31568	i0	94.048	50.0118343195266	168	10	99	0	1	168	4315782	4315949	Leptolyngbya sp. 7M chromosome	blastn	8452	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
18222481	18222481	PRJNA274362_S_NODE_34255_length_166_cov_0.888889_g34135_i0	PRJNA274362	34255	166	0.888889	1.47555574	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	206	1.01e-48	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g34135	i0	93.007	106.777108433735	143	6	85	3	24	164	1719	1859	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17725	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18222509	18222509	PRJNA274362_S_NODE_35695_length_164_cov_1.226087_g35575_i0	PRJNA274362	35695	164	1.226087	2.01078268	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	195	2.15e-45	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g35575	i0	88.75	94.9634146341463	160	16	97	2	6	164	2959	3117	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	15574	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20184644	20184644	PRJNA274362_S_NODE_24576_length_190_cov_0.957447_g24456_i0	PRJNA274362	24576	190	0.957447	1.8191493	Oscillatoriales	1150	Bacteria	Bacteria	311	2.44e-80	NTclustered	gi\|2395771017\|gb\|CP066886.2\|	147317	g24456	i0	96.316	303.957894736842	190	6	100	1	1	190	507410	507598	Arthrospira sp. PCC 9108 chromosome, complete genome	blastn	57752	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PCC 9108
30674266	30674266	PRJNA274362_S_NODE_2793_length_491_cov_1.638009_g2675_i0	PRJNA274362	2793	491	1.638009	8.04262419	Nostoc sp. FACHB-19	1180	Bacteria	Bacteria	126	3.08e-32	NR	WP_190670668.1	2692838	g2675	i0	51.3	2.84725050916497	150	66	91	4	472	26	129	272	WP_190670668.1 DUF4397 domain-containing protein [Nostoc sp. FACHB-190]	diamond	1398	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. FACHB-190

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