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

7 rows where analysis = "blastn", bioproject = "PRJNA1262902" 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
2914253	2914253	PRJNA1262902_P_NODE_4883_length_280_cov_1.705314_g4841_i0	PRJNA1262902	4883	280	1.705314	4.7748792	cyanobacterium endosymbiont of Rhopalodia gibba	309035	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2814330024\|gb\|CP067995.1\|	309035	g4841	i0	100	0.1	28	0	10	0	215	242	1716845	1716818	MAG: cyanobacterium endosymbiont of Rhopalodia gibba isolate 17Bon1-SB chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Rhopalodia gibba
4190623	4190623	PRJNA1262902_P_NODE_4184_length_291_cov_1.059633_g4142_i0	PRJNA1262902	4184	291	1.059633	3.08353203	Aphanizomenon flos-aquae	1176	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2004375065\|gb\|CP051188.1\|	2717882	g4142	i0	94.286	0.120274914089347	35	1	12	1	142	176	3901901	3901934	Aphanizomenon flos-aquae DEX188 chromosome, complete genome	blastn	35	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
7431939	7431939	PRJNA1262902_P_NODE_2006_length_353_cov_1.085714_g1964_i0	PRJNA1262902	2006	353	1.085714	3.83257042	Thermoleptolyngbya	2303528	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g1964	i0	100	1.51274787535411	30	0	10	0	102	131	338079	338050	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	534	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
16940838	16940838	PRJNA1262902_P_NODE_9674_length_246_cov_0.890173_g9632_i0	PRJNA1262902	9674	246	0.890173	2.18982558	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'	1618022	Bacteria	Bacteria	126	1.29e-24	NTclustered	gi\|1349670869\|gb\|CP026692.1\|	1618022	g9632	i0	86.842	1.20325203252033	114	14	46	1	103	216	586264	586376	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont' strain 5183 chromosome, complete genome	blastn	296	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'
18215246	18215246	PRJNA1262902_P_NODE_115_length_1049_cov_5.322746_g94_i0	PRJNA1262902	115	1049	5.322746	55.83560554	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	749	0	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g94	i0	80.575	135.178265014299	1009	165	94	30	59	1049	1478459	1477464	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	141802	749	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
18215291	18215291	PRJNA1262902_P_NODE_6275_length_262_cov_1.582011_g6233_i0	PRJNA1262902	6275	262	1.582011	4.14486882	Synechococcus sp. LTW-R	2751170	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1891299085\|gb\|CP059060.1\|	2751170	g6233	i0	100	0.106870229007634	28	0	11	0	124	151	1878264	1878237	Synechococcus sp. LTW-R chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LTW-R
19489526	19489526	PRJNA1262902_P_NODE_1016_length_442_cov_3.409214_g974_i0	PRJNA1262902	1016	442	3.409214	15.06872588	Pseudanabaena mucicola	71190	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2522923893\|gb\|CP097329.1\|	2942274	g974	i0	94.595	1.44343891402715	37	1	8	1	372	408	525914	525879	Pseudanabaena mucicola str. Chao 1806 chromosome, complete genome	blastn	638	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena mucicola

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