metadata: contig_metadata: 13 rows where bioproject = "PRJNA1262902" and tax_clade = "Cyanobacteriota/Melainabacteria group"

13 rows where 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
27295156	27295156	PRJNA1262902_P_NODE_9503_length_247_cov_0.885057_g9461_i0	PRJNA1262902	9503	247	0.885057	2.18609079	Aliterella atlantica	1827278	Bacteria	Bacteria	127	4.34e-32	NR	WP_072044968.1	1827278	g9461	i0	77.8	0.983805668016194	81	18	98.4	0	3	245	35	115	WP_072044968.1 putative bifunctional diguanylate cyclase/phosphodiesterase [Aliterella atlantica]	diamond	243	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
28052943	28052943	PRJNA1262902_P_NODE_11905_length_242_cov_0.911243_g11863_i0	PRJNA1262902	11905	242	0.911243	2.20520806	Nostoc mirabile	2907820	Bacteria	Bacteria	117	2.68e-28	NR	WP_229499096.1	2907820	g11863	i0	81.3	0.991735537190083	80	15	99.2	0	3	242	482	561	WP_229499096.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Nostoc mirabile]	diamond	240	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc mirabile
28589945	28589945	PRJNA1262902_P_NODE_8727_length_248_cov_0.880000_g8685_i0	PRJNA1262902	8727	248	0.88	2.1824	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	152	4.99e-45	NR	WP_009629898.1	927677	g8685	i0	97.6	0.991935483870968	82	2	99.2	0	2	247	57	138	WP_009629898.1 recombinase family protein [Synechocystis sp. PCC 7509]	diamond	246	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
29554635	29554635	PRJNA1262902_P_NODE_7890_length_250_cov_0.870056_g7848_i0	PRJNA1262902	7890	250	0.870056	2.17514	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	60.8	1.16e-8	NR	WP_286003993.1	1471433	g7848	i0	59.3	1.284	54	22	64.8	0	249	88	218	271	WP_286003993.1 hypothetical protein [Geitlerinema calcuttense]	diamond	321	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema calcuttense
30136707	30136707	PRJNA1262902_P_NODE_6732_length_257_cov_1.592391_g6690_i0	PRJNA1262902	6732	257	1.592391	4.09244487	Pseudanabaenaceae cyanobacterium LEGE 13415	2777976	Bacteria	Bacteria	89	5.64e-19	NR	MBE9012643.1	2777976	g6690	i0	83.1	1.51750972762646	59	10	68.9	0	10	186	2	60	MBE9012643.1 AAA family ATPase [Pseudanabaenaceae cyanobacterium LEGE 13415]	diamond	390	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium LEGE 13415
31053637	31053637	PRJNA1262902_P_NODE_10355_length_245_cov_0.895349_g10313_i0	PRJNA1262902	10355	245	0.895349	2.19360505	Synechococcaceae cyanobacterium SM1_2_3	2720456	Bacteria	Bacteria	148	3.4599999999999987e-41	NR	NJM12592.1	2720456	g10313	i0	86.4	0.991836734693878	81	11	99.2	0	1	243	170	250	NJM12592.1 N4-gp56 family major capsid protein [Synechococcaceae cyanobacterium SM1_2_3]	diamond	243	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium SM1_2_3

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