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

9 rows where analysis = "blastn", bioproject = "PRJEB14803" 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
21531	21531	PRJEB14803_P_NODE_37041_length_174_cov_0.949640_g36575_i0	PRJEB14803	37041	174	0.94964	1.6523736	Synechococcus sp. JA-2-3B'a(2-13)	321332	Bacteria	Bacteria	73.1	1.12e-8	NTclustered	gi\|86556045\|gb\|CP000240.1\|	321332	g36575	i0	90.741	0.310344827586207	54	5	31	0	29	82	1063124	1063071	Synechococcus sp. JA-2-3B'a(2-13), complete genome	blastn	54	73.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. JA-2-3B'a(2-13)
8638883	8638883	PRJEB14803_P_NODE_31587_length_192_cov_1.006369_g31121_i0	PRJEB14803	31587	192	1.006369	1.93222848	Prochlorococcus	1218	Bacteria	Bacteria	84.2	5.86e-12	NTclustered	gi\|154949252\|gb\|CP000095.2\|	59920	g31121	i0	87.179	81.7395833333333	78	5	41	3	8	85	373180	373252	Prochlorococcus marinus str. NATL2A, complete genome	blastn	15694	84.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
8948319	8948319	PRJEB14803_P_NODE_1188_length_1288_cov_8.493216_g1007_i0	PRJEB14803	1188	1288	8.493216	109.39262208	Stanieria cyanosphaera	102116	Bacteria	Bacteria	634	1.0299999999999998e-176	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g1007	i0	79.707	15.3369565217391	887	173	68	6	186	1067	1	885	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	19754	634	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
8948475	8948475	PRJEB14803_P_NODE_32568_length_188_cov_1.437908_g32102_i0	PRJEB14803	32568	188	1.437908	2.70326704	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	207	3.25e-49	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g32102	i0	91.892	70.1276595744681	148	12	79	0	2	149	3680929	3681076	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13184	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
10224179	10224179	PRJEB14803_P_NODE_2809_length_857_cov_27.083942_g2501_i0	PRJEB14803	2809	857	27.083942	232.10938294	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	647	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2501	i0	80.8	793.634772462077	875	127	99	37	5	857	3681115	3681970	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	680145	647	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
10224225	10224225	PRJEB14803_P_NODE_35949_length_177_cov_1.126761_g35483_i0	PRJEB14803	35949	177	1.126761	1.99436697	Cyanobium sp. NS01	261284	Bacteria	Bacteria	60.2	8.94e-5	NTclustered	gi\|1895767613\|gb\|CP047940.1\|	261284	g35483	i0	92.683	0.412429378531073	41	3	23	0	118	158	177621	177581	Cyanobium sp. NS01 chromosome, complete genome	blastn	73	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NS01
21387903	21387903	PRJEB14803_P_NODE_11737_length_368_cov_1.378378_g11272_i0	PRJEB14803	11737	368	1.378378	5.07243104	Planktothrix	54304	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g11272	i0	100	0.540760869565217	28	0	8	0	78	105	1344660	1344687	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	199	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
21698071	21698071	PRJEB14803_P_NODE_16218_length_297_cov_4.087786_g15752_i0	PRJEB14803	16218	297	4.087786	12.14072442	Moorena producens	1155739	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2412135964\|gb\|CP017708.2\|	1454205	g15752	i0	100	0.0976430976430976	29	0	10	0	68	96	7903636	7903608	Moorena producens JHB chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
24247355	24247355	PRJEB14803_P_NODE_42560_length_159_cov_2.241935_g42094_i0	PRJEB14803	42560	159	2.241935	3.56467665	Euhalothece natronophila	577489	Bacteria	Bacteria	113	5.95e-21	NTclustered	gi\|1720260411\|gb\|CP042326.1\|	522448	g42094	i0	82.143	1.69811320754717	140	17	86	7	11	146	767909	768044	Euhalothece natronophila Z-M001 chromosome, complete genome	blastn	270	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Euhalothece	Euhalothece natronophila

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