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

7 rows where analysis = "blastn", bioproject = "PRJEB12237" 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
2260848	2260848	PRJEB12237_P_NODE_11822_length_152_cov_3.615385_g11626_i0	PRJEB12237	11822	152	3.615385	5.4953852	root	1	Root_unresolved	Root_unresolved	279	5.24e-71	NTclustered	gi\|146141747\|gb\|EF522251.1\|	1211	g11626	i0	100	107.315789473684	151	0	99	0	1	151	817	667	Uncultured cyanobacterium clone FQSS031 16S ribosomal RNA gene, partial sequence	blastn	16312	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2570585	2570585	PRJEB12237_P_NODE_423_length_1085_cov_2.396190_g334_i0	PRJEB12237	423	1085	2.39619	25.9986615	Stanieria cyanosphaera	102116	Bacteria	Bacteria	640	1.8499999999999997e-178	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g334	i0	79.865	16.7898617511521	889	168	81	10	20	901	1	885	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	18217	640	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
3846902	3846902	PRJEB12237_P_NODE_404_length_1107_cov_3.556903_g317_i0	PRJEB12237	404	1107	3.556903	39.37491621	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1535	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g317	i0	91.712	120.57091237579	1110	87	100	5	1	1107	1633	2740	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	133472	1535	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17872321	17872321	PRJEB12237_P_NODE_4975_length_276_cov_3.875519_g4779_i0	PRJEB12237	4975	276	3.875519	10.69643244	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	436	5.999999999999999e-118	NTclustered	gi\|225696213\|gb\|FJ805880.1\|	259957	g4779	i0	95.29	101.38768115942	276	12	100	1	1	276	3070	2796	Uncultured Chroococcidiopsis sp. clone A3_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27983	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20421351	20421351	PRJEB12237_P_NODE_5777_length_246_cov_1.085308_g5581_i0	PRJEB12237	5777	246	1.085308	2.66985768	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	318	1.98e-82	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g5581	i0	90	110.060975609756	250	19	100	6	1	246	1832	2079	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27075	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20421368	20421368	PRJEB12237_P_NODE_8777_length_183_cov_3.344595_g8581_i0	PRJEB12237	8777	183	3.344595	6.12060885	uncultured Cyanobacterium sp.	751952	Bacteria	Bacteria	322	1.08e-83	NTclustered	gi\|1240396314\|gb\|MF895807.1\|	751952	g8581	i0	98.361	100.207650273224	183	3	100	0	1	183	50	232	Uncultured Cyanobacterium sp. clone CSMB_2452 16S ribosomal RNA gene, partial sequence	blastn	18338	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	uncultured Cyanobacterium sp.
23937967	23937967	PRJEB12237_P_NODE_6139_length_235_cov_3.170000_g5943_i0	PRJEB12237	6139	235	3.17	7.4495	Bacteria	2	Bacteria	Bacteria	379	8.509999999999998e-101	NTclustered	gi\|389547670\|gb\|JQ402598.1\|	1211	g5943	i0	95.781	106.36170212766	237	6	100	4	1	235	4	238	Uncultured cyanobacterium clone CNY_02999 16S ribosomal RNA gene, partial sequence	blastn	24995	379	1	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);;