metadata: contig_metadata: 17 rows where bioproject = "PRJNA1087264" and tax_clade = "Cyanobacteriota/Melainabacteria group"

17 rows where bioproject = "PRJNA1087264" 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
2744818	2744818	PRJNA1087264_P_NODE_9063_length_209_cov_1.275000_g8981_i0	PRJNA1087264	9063	209	1.275	2.66475	Synechococcus sp. JA-2-3B'a(2-13)	321332	Bacteria	Bacteria	101	1.17e-24	NR	WP_011431785.1	321332	g8981	i0	71	1.98086124401914	69	20	99	0	1	207	103	171	WP_011431785.1 peroxiredoxin [Synechococcus sp. JA-2-3B'a(2-13)]	diamond	414	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. JA-2-3B'a(2-13)
9121672	9121672	PRJNA1087264_P_NODE_21068_length_161_cov_1.223214_g20986_i0	PRJNA1087264	21068	161	1.223214	1.96937454	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	90.9	9.96e-22	NR	MBX9722668.1	2364082	g20986	i0	76.9	0.968944099378882	52	12	96.9	0	1	156	63	114	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	156	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
26846271	26846271	PRJNA1087264_P_NODE_17041_length_165_cov_0.879310_g16959_i0	PRJNA1087264	17041	165	0.87931	1.4508615	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	41.2	0.0471	NR	MDD9897597.1	2052166	g16959	i0	47.7	0.8	44	22	80	1	1	132	344	386	MDD9897597.1 metallophosphoesterase family protein [Candidatus Melainabacteria bacterium]	diamond	132	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27162101	27162101	PRJNA1087264_P_NODE_2142_length_460_cov_1.464720_g2061_i0	PRJNA1087264	2142	460	1.46472	6.737712	Cyanobacteria bacterium P01_G01_bin.54	3023307	Bacteria	Bacteria	48.5	0.00207	NR	MEM8642542.1	3023307	g2061	i0	36.7	0.952173913043478	79	41	51.5	3	459	223	149	218	MEM8642542.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Cyanobacteria bacterium P01_G01_bin.54]	diamond	438	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_G01_bin.54
27636333	27636333	PRJNA1087264_P_NODE_1304_length_584_cov_1.042991_g1229_i0	PRJNA1087264	1304	584	1.042991	6.09106744	Leptolyngbya ohadii	1962290	Bacteria	Bacteria	61.6	3.75e-8	NR	WP_088892697.1	1962290	g1229	i0	63.4	0.642123287671233	41	15	21.1	0	8	130	124	164	WP_088892697.1 glutathione peroxidase [Leptolyngbya ohadii]	diamond	375	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya ohadii
27825738	27825738	PRJNA1087264_P_NODE_13764_length_169_cov_1.683333_g13682_i0	PRJNA1087264	13764	169	1.683333	2.84483277	Cyanobacteria bacterium P01_H01_bin.74	3023322	Bacteria	Bacteria	96.7	1.22e-21	NR	MEM0951379.1	3023322	g13682	i0	82.1	5.96449704142012	56	10	99.4	0	169	2	415	470	MEM0951379.1 IMP dehydrogenase [Cyanobacteria bacterium P01_H01_bin.74]	diamond	1008	96.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.74
27880216	27880216	PRJNA1087264_P_NODE_965_length_676_cov_2.028708_g895_i0	PRJNA1087264	965	676	2.028708	13.71406608	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	114	3.86e-26	NR	WP_015138290.1	28072	g895	i0	37.7	3.46597633136095	204	114	89.6	6	71	676	90	282	WP_015138290.1 hypothetical protein [Nostoc sp. PCC 7524]	diamond	2343	115	0.991304347826087	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
28038203	28038203	PRJNA1087264_P_NODE_11125_length_189_cov_1.457143_g11043_i0	PRJNA1087264	11125	189	1.457143	2.75400027	root	1	Root_unresolved	Root_unresolved	102	2.4299999999999998e-23	NR	WP_288916497.1	154535	g11043	i0	94.3	2.50793650793651	53	3	84.1	0	1	159	637	689	WP_288916497.1 30S ribosomal protein S12 [uncultured Synechococcus sp.]	diamond	474	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	uncultured Synechococcus sp.
28046618	28046618	PRJNA1087264_P_NODE_6125_length_258_cov_0.913876_g6043_i0	PRJNA1087264	6125	258	0.913876	2.35780008	Pseudanabaenaceae cyanobacterium SKYG29	2972672	Bacteria	Bacteria	80.9	1.21e-16	NR	MCS6959555.1	2972672	g6043	i0	51.2	1	86	38	97.7	2	253	2	89	172	MCS6959555.1 VWA domain-containing protein [Pseudanabaenaceae cyanobacterium SKYG29]	diamond	258	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium SKYG29
29332642	29332642	PRJNA1087264_P_NODE_19749_length_163_cov_0.894737_g19667_i0	PRJNA1087264	19749	163	0.894737	1.45842131	Cyanophyceae	3028117	Bacteria	Bacteria	62	1.93e-9	NR	NER81772.1	2607807	g19667	i0	60	5.52147239263804	50	20	92	0	6	155	345	394	NER81772.1 folate/biopterin family MFS transporter [Leptolyngbya sp. SIO1D8]	diamond	900	62.4	0.993589743589744	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIO1D8
30699329	30699329	PRJNA1087264_P_NODE_20654_length_162_cov_0.902655_g20572_i0	PRJNA1087264	20654	162	0.902655	1.4623011	Brunnivagina elsteri	1247191	Bacteria	Bacteria	74.7	6.37e-14	NR	WP_095720204.1	1247191	g20572	i0	70	1.85185185185185	50	15	92.6	0	2	151	91	140	WP_095720204.1 carotenoid oxygenase family protein [Brunnivagina elsteri]	diamond	300	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Brunnivagina	Brunnivagina elsteri
31268249	31268249	PRJNA1087264_P_NODE_13835_length_169_cov_1.083333_g13753_i0	PRJNA1087264	13835	169	1.083333	1.83083277	Cyanobacteria bacterium SBLK	2821505	Bacteria	Bacteria	78.2	7.51e-16	NR	MBP0019669.1	2821505	g13753	i0	63.6	0.976331360946746	55	20	97.6	0	165	1	99	153	MBP0019669.1 class I SAM-dependent methyltransferase [Cyanobacteria bacterium SBLK]	diamond	165	78.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SBLK
32018790	32018790	PRJNA1087264_P_NODE_20438_length_162_cov_0.902655_g20356_i0	PRJNA1087264	20438	162	0.902655	1.4623011	root	1	Root_unresolved	Root_unresolved	88.2	5.66e-19	NR	MBX9940161.1	2364082	g20356	i0	76	6.62962962962963	50	12	92.6	0	162	13	114	163	MBX9940161.1 pirin family protein [Candidatus Obscuribacterales bacterium]	diamond	1074	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32145420	32145420	PRJNA1087264_P_NODE_3858_length_332_cov_1.961131_g3776_i0	PRJNA1087264	3858	332	1.961131	6.51095492	Lusitaniella	1983104	Bacteria	Bacteria	78.6	3.01e-14	NR	WP_194028312.1	1983105	g3776	i0	44.1	3.79518072289157	102	48	92.2	1	311	6	3712	3804	WP_194028312.1 amino acid adenylation domain-containing protein [Lusitaniella coriacea]	diamond	1260	78.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Lusitaniellaceae	Lusitaniella	Lusitaniella coriacea
32312448	32312448	PRJNA1087264_P_NODE_17199_length_165_cov_0.879310_g17117_i0	PRJNA1087264	17199	165	0.87931	1.4508615	Gomphosphaeria aponina	1521626	Bacteria	Bacteria	87.4	2.29e-18	NR	MBR8826767.1	1521640	g17117	i0	68.5	3.89090909090909	54	17	98.2	0	164	3	354	407	MBR8826767.1 AMP-binding protein [Gomphosphaeria aponina SAG 52.96 = DSM 107014]	diamond	642	87.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Gomphosphaeriaceae	Gomphosphaeria	Gomphosphaeria aponina
32312454	32312454	PRJNA1087264_P_NODE_9579_length_204_cov_0.890323_g9497_i0	PRJNA1087264	9579	204	0.890323	1.81625892	Candidatus Caenarcanales bacterium	2729995	Bacteria	Bacteria	61.2	2.71e-9	NR	HEY9847790.1	2729995	g9497	i0	48.3	1.76470588235294	60	28	86.8	2	204	28	156	213	HEY9847790.1 class I SAM-dependent methyltransferase [Candidatus Caenarcanales bacterium]	diamond	360	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
32722775	32722775	PRJNA1087264_P_NODE_7860_length_225_cov_0.869318_g7778_i0	PRJNA1087264	7860	225	0.869318	1.9559655	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	72.4	1.02e-12	NR	MBC7545162.1	2762020	g7778	i0	46.3	2.2	82	36	98.7	2	224	3	479	560	MBC7545162.1 glutamine synthetase III [Candidatus Sericytochromatia bacterium]	diamond	495	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia 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);;