metadata: contig_metadata: 15 rows where bioproject = "PRJNA1215813" and tax_clade = "Cyanobacteriota/Melainabacteria group"

15 rows where bioproject = "PRJNA1215813" 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
2882753	2882753	PRJNA1215813_P_NODE_7623_length_284_cov_2.218009_g7543_i0	PRJNA1215813	7623	284	2.218009	6.29914556	Synechococcus sp. CBW1107	2789857	Bacteria	Bacteria	137	7.04e-28	NTclustered	gi\|2638498304\|emb\|OY986430.1\|	2789857	g7543	i0	79	12.669014084507	200	42	70	0	41	240	1782203	1782402	Synechococcus sp. CBW1107 isolate KAC_114 genome assembly, chromosome: 1	blastn	3598	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
28544439	28544439	PRJNA1215813_P_NODE_2307_length_490_cov_16.426859_g2227_i0	PRJNA1215813	2307	490	16.426859	80.4916091	Cyanophyceae	3028117	Bacteria	Bacteria	226	3.49e-73	NR	WP_212664291.1	155977	g2227	i0	71.6	28.9469387755102	148	42	90.6	0	462	19	2	149	WP_212664291.1 MULTISPECIES: nucleoside-diphosphate kinase [Acaryochloris]	diamond	14184	227	0.995594713656388	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris
29598673	29598673	PRJNA1215813_P_NODE_6010_length_318_cov_1.273469_g5930_i0	PRJNA1215813	6010	318	1.273469	4.04963142	Cyanobacteria bacterium HKST-UBA02	2775582	Bacteria	Bacteria	48.9	4.87e-4	NR	MCA9801257.1	2775582	g5930	i0	48.8	0.792452830188679	43	22	40.6	0	4	132	30	72	MCA9801257.1 tetratricopeptide repeat protein [Cyanobacteria bacterium HKST-UBA02]	diamond	252	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium HKST-UBA02
30198850	30198850	PRJNA1215813_P_NODE_8172_length_274_cov_1.940299_g8092_i0	PRJNA1215813	8172	274	1.940299	5.31641926	Microcoleus sp. bin38.metabat.b11b12b14.	44472	Bacteria	Bacteria	60.1	9.16e-9	NR	WP_293131049.1	2742709	g8092	i0	38	1.00729927007299	92	52	99.6	3	273	1	79	166	WP_293131049.1 universal stress protein [Microcoleus sp. bin38.metabat.b11b12b14.051]	diamond	276	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. bin38.metabat.b11b12b14.051
30546630	30546630	PRJNA1215813_P_NODE_5253_length_337_cov_1.181818_g5173_i0	PRJNA1215813	5253	337	1.181818	3.98272666	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	68.9	7.45e-11	NR	HEY9632936.1	3081323	g5173	i0	42.9	1.74480712166172	98	46	87.2	1	301	8	841	928	HEY9632936.1 nitric oxide synthase oxygenase [Coleofasciculaceae cyanobacterium]	diamond	588	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
30565072	30565072	PRJNA1215813_P_NODE_10813_length_248_cov_0.891429_g10733_i0	PRJNA1215813	10813	248	0.891429	2.21074392	Cyanophyceae	3028117	Bacteria	Bacteria	92.8	6.0700000000000005e-21	NR	CAA9559451.1	1936017	g10733	i0	58.5	4.95967741935484	82	31	99.2	1	3	248	140	218	CAA9559451.1 3-oxoacyl-[acyl-carrier protein] reductase [uncultured Synechococcales cyanobacterium]	diamond	1230	93.6	0.991452991452991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			uncultured Synechococcales cyanobacterium
31052441	31052441	PRJNA1215813_P_NODE_6955_length_297_cov_1.044643_g6875_i0	PRJNA1215813	6955	297	1.044643	3.10258971	Limnoraphis robusta	1118279	Bacteria	Bacteria	62	1.2e-8	NR	WP_072075656.1	1118279	g6875	i0	42.9	2.65656565656566	63	36	63.6	0	270	82	70	132	WP_072075656.1 sulfotransferase domain-containing protein [Limnoraphis robusta]	diamond	789	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnoraphis	Limnoraphis robusta
31463359	31463359	PRJNA1215813_P_NODE_2356_length_485_cov_2.456311_g2276_i0	PRJNA1215813	2356	485	2.456311	11.91310835	Leptolyngbyaceae cyanobacterium RM1_406_9	2720434	Bacteria	Bacteria	116	9.05e-27	NR	NJO74750.1	2720434	g2276	i0	46.8	0.964948453608247	156	76	96.5	3	473	6	2493	2641	NJO74750.1 tandem-95 repeat protein [Leptolyngbyaceae cyanobacterium RM1_406_9]	diamond	468	116	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium RM1_406_9
31558284	31558284	PRJNA1215813_P_NODE_6176_length_314_cov_1.294606_g6096_i0	PRJNA1215813	6176	314	1.294606	4.06506284	Spirulina subsalsa	54311	Bacteria	Bacteria	66.2	4.99e-10	NR	WP_083883620.1	54311	g6096	i0	47.1	0.668789808917197	70	36	66.9	1	3	212	750	818	WP_083883620.1 S8 family serine peptidase [Spirulina subsalsa]	diamond	210	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina subsalsa
32000917	32000917	PRJNA1215813_P_NODE_11398_length_246_cov_0.901734_g11318_i0	PRJNA1215813	11398	246	0.901734	2.21826564	Drouetiella hepatica	2303515	Bacteria	Bacteria	44.7	0.0081	NR	MBW4660317.1	904376	g11318	i0	31.9	0.878048780487805	72	49	87.8	0	217	2	303	374	MBW4660317.1 tetratricopeptide repeat protein [Drouetiella hepatica Uher 2000/2452]	diamond	216	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella hepatica
32241508	32241508	PRJNA1215813_P_NODE_11558_length_245_cov_0.906977_g11478_i0	PRJNA1215813	11558	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	62.8	1.63e-9	NR	MEB3359836.1	2478492	g11478	i0	43.7	3.72244897959184	71	40	86.9	0	214	2	26	96	MEB3359836.1 GTP cyclohydrolase I FolE [Synechococcales cyanobacterium]	diamond	912	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium
32507437	32507437	PRJNA1215813_P_NODE_379_length_1070_cov_3.663992_g334_i0	PRJNA1215813	379	1070	3.663992	39.2047144	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	467	1.4499999999999996e-162	NR	MBX9694561.1	2847862	g334	i0	74.4	2.70841121495327	308	74	85	2	1040	132	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	467	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32589355	32589355	PRJNA1215813_P_NODE_5219_length_338_cov_0.883019_g5139_i0	PRJNA1215813	5219	338	0.883019	2.98460422	Cyanophyceae	3028117	Bacteria	Bacteria	73.6	8.79e-13	NR	WP_006106518.1	64178	g5139	i0	39.1	2.92011834319527	115	59	97.6	4	330	1	170	278	WP_006106518.1 ATP adenylyltransferase family protein [Coleofasciculus chthonoplastes]	diamond	987	74.3	0.990578734858681	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
32727928	32727928	PRJNA1215813_P_NODE_12340_length_242_cov_1.846154_g12260_i0	PRJNA1215813	12340	242	1.846154	4.46769268	Leptolyngbya sp. FACHB-261	2692806	Bacteria	Bacteria	68.6	2.88e-11	NR	WP_190800488.1	2692806	g12260	i0	47.9	0.90495867768595	73	38	90.5	0	221	3	304	376	WP_190800488.1 N-acetylmuramoyl-L-alanine amidase [Leptolyngbya sp. FACHB-261]	diamond	219	68.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-261
32759371	32759371	PRJNA1215813_P_NODE_3760_length_393_cov_1.190625_g3680_i0	PRJNA1215813	3760	393	1.190625	4.67915625	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	197	2.4e-62	NR	MBX9722668.1	2364082	g3680	i0	74.4	1.94656488549618	125	32	95.4	0	18	392	3	127	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	765	197	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium

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