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

9 rows where analysis = "blastn", bioproject = "PRJNA541476" 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
8161333	8161333	PRJNA541476_P_NODE_17927_length_292_cov_1.022831_g17721_i0	PRJNA541476	17927	292	1.022831	2.98666652	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	243	1.5e-59	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17721	i0	82.909	8.44178082191781	275	41	93	6	22	292	3681096	3681368	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	2465	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8161464	8161464	PRJNA541476_P_NODE_23467_length_268_cov_1.687179_g23261_i0	PRJNA541476	23467	268	1.687179	4.52163972	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g23261	i0	100	102.992537313433	268	0	100	0	1	268	1168	1435	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	27602	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
9436840	9436840	PRJNA541476_P_NODE_20268_length_281_cov_1.341346_g20062_i0	PRJNA541476	20268	281	1.341346	3.76918226	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	455	1.69e-123	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g20062	i0	96.057	119.932384341637	279	11	99	0	3	281	3417	3139	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33701	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10713386	10713386	PRJNA541476_P_NODE_649_length_1391_cov_11.785281_g556_i0	PRJNA541476	649	1391	11.785281	163.93325871	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1567	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g556	i0	87.044	128.230050323508	1397	169	100	10	1	1391	3682228	3680838	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	178368	1567	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13263115	13263115	PRJNA541476_P_NODE_791_length_1280_cov_4.792875_g683_i0	PRJNA541476	791	1280	4.792875	61.3488	Stanieria cyanosphaera	102116	Bacteria	Bacteria	634	1.0199999999999998e-176	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g683	i0	79.707	15.090625	887	173	69	6	186	1067	1	885	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	19316	634	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
14537189	14537189	PRJNA541476_P_NODE_12232_length_333_cov_4.003846_g12026_i0	PRJNA541476	12232	333	4.003846	13.33280718	Nostoc sp. C052	2576902	Bacteria	Bacteria	65.8	4.03e-6	NTclustered	gi\|1866639087\|gb\|CP040272.1\|	2576902	g12026	i0	93.182	109.594594594595	44	3	13	0	4	47	566460	566417	Nostoc sp. C052 chromosome, complete genome	blastn	36495	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C052
14537280	14537280	PRJNA541476_P_NODE_16592_length_299_cov_1.929204_g16386_i0	PRJNA541476	16592	299	1.929204	5.76831996	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	508	1.37e-139	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g16386	i0	97.324	115.066889632107	299	8	100	0	1	299	2814	2516	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34405	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23460733	23460733	PRJNA541476_P_NODE_18179_length_290_cov_6.105991_g17973_i0	PRJNA541476	18179	290	6.105991	17.7073739	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	351	2.36e-92	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17973	i0	88.621	79.4172413793103	290	32	100	1	1	290	3679729	3680017	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23031	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
24070509	24070509	PRJNA541476_P_NODE_22479_length_272_cov_1.321608_g22273_i0	PRJNA541476	22479	272	1.321608	3.59477376	Prochlorococcus	1218	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|33772317\|emb\|BX548174.1\|	59919	g22273	i0	100	8.99264705882353	272	0	100	0	1	272	873542	873271	Prochlorococcus marinus MED4 complete genome	blastn	2446	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus

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