metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB12296" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where analysis = "blastn", bioproject = "PRJEB12296" 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
10223492	10223492	PRJEB12296_P_NODE_769_length_167_cov_4.528986_g756_i0	PRJEB12296	769	167	4.528986	7.56340662	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	268	1.28e-67	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g756	i0	95.783	166.479041916168	166	7	99	0	2	167	795226	795391	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	27802	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
25500658	25500658	PRJEB12296_S_NODE_14265_length_160_cov_2.104000_g14233_i0	PRJEB12296	14265	160	2.104	3.3664	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	209	7.44e-50	NTclustered	gi\|225696268\|gb\|FJ805935.1\|	259957	g14233	i0	91.447	233.44375	152	13	95	0	1	152	1573	1724	Uncultured Chroococcidiopsis sp. clone NA1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37351	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25772649	25772649	PRJEB12296_S_NODE_10675_length_170_cov_3.703704_g10643_i0	PRJEB12296	10675	170	3.703704	6.2962968	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	163	6.29e-36	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g10643	i0	90.909	3.70588235294118	121	11	71	0	33	153	3679474	3679594	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	630	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25772856	25772856	PRJEB12296_S_NODE_683_length_408_cov_5.211796_g652_i0	PRJEB12296	683	408	5.211796	21.26412768	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	364	4.429999999999999e-96	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g652	i0	84.433	33.6372549019608	379	50	92	8	6	380	3681251	3680878	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13724	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25878874	25878874	PRJEB12296_S_NODE_7939_length_183_cov_3.790541_g7907_i0	PRJEB12296	7939	183	3.790541	6.93669003	root	1	Root_unresolved	Root_unresolved	71.3	4.3e-8	NTclustered	gi\|427988066\|gb\|CP003592.1\|	82654	g7907	i0	97.619	30.551912568306	42	0	23	1	142	183	1761539	1761499	Pseudanabaena sp. PCC 7367, complete genome	blastn	5591	71.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Thalassoporaceae	Thalassoporum	Thalassoporum mexicanum
25908895	25908895	PRJEB12296_S_NODE_2228_length_285_cov_7580.336000_g2196_i0	PRJEB12296	2228	285	7580.336	21603.9576	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	278	3.9900000000000005e-70	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2196	i0	87.815	49.3017543859649	238	28	83	1	1	237	3679989	3679752	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	14051	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26316902	26316902	PRJEB12296_S_NODE_263_length_546_cov_45.600783_g240_i0	PRJEB12296	263	546	45.600783	248.98027518	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	520	1.22e-142	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g240	i0	85.573	236.227106227106	506	61	92	11	31	530	3682681	3682182	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	128980	520	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26423154	26423154	PRJEB12296_S_NODE_2311_length_282_cov_6.890688_g2279_i0	PRJEB12296	2311	282	6.890688	19.43174016	root	1	Root_unresolved	Root_unresolved	514	2.76e-141	NTclustered	gi\|338192687\|gb\|JF788700.1\|	1211	g2279	i0	99.645	161.556737588652	282	0	99	1	1	281	405	124	Uncultured cyanobacterium clone ANSCYA_H05 16S ribosomal RNA gene, partial sequence	blastn	45559	516	0.996124031007752	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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