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

7 rows where analysis = "blastn", bioproject = "PRJNA757618" 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
9661270	9661270	PRJNA757618_P_NODE_6388_length_478_cov_1.387654_g5336_i0	PRJNA757618	6388	478	1.387654	6.63298612	Aliterella chasmolithica	2739056	Bacteria	Bacteria	839	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g5336	i0	98.326	114.301255230126	478	8	100	0	1	478	2459	1982	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54636	839	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
10130945	10130945	PRJNA757618_P_NODE_10348_length_348_cov_1.687273_g9296_i0	PRJNA757618	10348	348	1.687273	5.87171004	Chroococcidiopsis	54298	Bacteria	Bacteria	459	1.66e-124	NTclustered	gi\|225696268\|gb\|FJ805935.1\|	259957	g9296	i0	90.725	126.341954022989	345	30	99	2	1	345	3337	2995	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	43967	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12212357	12212357	PRJNA757618_P_NODE_5710_length_542_cov_1.782516_g4660_i0	PRJNA757618	5710	542	1.782516	9.66123672	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	843	0	NTclustered	gi\|225696221\|gb\|FJ805888.1\|	259957	g4660	i0	94.679	113.479704797048	545	25	100	4	1	542	2835	2292	Uncultured Chroococcidiopsis sp. clone NA2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	61506	843	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15231058	15231058	PRJNA757618_P_NODE_37392_length_247_cov_0.896552_g36340_i0	PRJNA757618	37392	247	0.896552	2.21448344	Leptolyngbya	47251	Bacteria	Bacteria	276	1.22e-69	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g36340	i0	87.448	5.80566801619433	239	30	97	0	9	247	763386	763624	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	1434	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
16035296	16035296	PRJNA757618_P_NODE_39753_length_246_cov_0.895954_g38701_i0	PRJNA757618	39753	246	0.895954	2.20404684	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g38701	i0	100	2	246	0	100	0	1	246	2077292	2077537	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	492	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
21604665	21604665	PRJNA757618_P_NODE_31317_length_250_cov_0.881356_g30265_i0	PRJNA757618	31317	250	0.881356	2.20339	Prochlorococcus	1218	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|78711884\|gb\|CP000111.1\|	74546	g30265	i0	100	0.224	28	0	11	0	44	71	595274	595301	Prochlorococcus marinus str. MIT 9312, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
24958716	24958716	PRJNA757618_P_NODE_10140_length_351_cov_1.482014_g9088_i0	PRJNA757618	10140	351	1.482014	5.20186914	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	527	4.519999999999999e-145	NTclustered	gi\|225696229\|gb\|FJ805896.1\|	259957	g9088	i0	93.768	152.623931623932	353	19	100	3	1	351	3761	4112	Uncultured Chroococcidiopsis sp. clone NA2_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53571	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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