metadata: contig_metadata: 24 rows where analysis = "diamond", bioproject = "PRJNA408129" and tax_clade = "Cyanobacteriota/Melainabacteria group"

24 rows where analysis = "diamond", bioproject = "PRJNA408129" 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
1082729	1082729	PRJNA408129_S_NODE_25121_length_167_cov_1.123077_g25103_i0	PRJNA408129	25121	167	1.123077	1.87553859	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	90.5	2.52e-20	NR	HEY9754880.1	3088181	g25103	i0	91.7	0.862275449101796	48	4	86.2	0	23	166	4	51	HEY9754880.1 response regulator [Oculatellaceae cyanobacterium]	diamond	144	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
3633599	3633599	PRJNA408129_S_NODE_2423_length_320_cov_20224.950530_g2405_i0	PRJNA408129	2423	320	20224.95053	64719.841696	Aphanothece hegewaldii	1521625	Bacteria	Bacteria	160	1.16e-46	NR	WP_106457901.1	1521625	g2405	i0	82	0.834375	89	16	83.4	0	1	267	34	122	WP_106457901.1 aspartyl/asparaginyl beta-hydroxylase domain-containing protein [Aphanothece hegewaldii]	diamond	267	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece hegewaldii
26885908	26885908	PRJNA408129_S_NODE_6041_length_254_cov_2.036866_g6023_i0	PRJNA408129	6041	254	2.036866	5.17363964	Brunnivagina elsteri	1247191	Bacteria	Bacteria	43.9	0.0153	NR	WP_095721592.1	1247191	g6023	i0	32.5	0.909448818897638	77	51	90.9	1	7	237	124	199	WP_095721592.1 alpha/beta hydrolase [Brunnivagina elsteri]	diamond	231	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Brunnivagina	Brunnivagina elsteri
27075531	27075531	PRJNA408129_S_NODE_35502_length_150_cov_6.867257_g35484_i0	PRJNA408129	35502	150	6.867257	10.3008855	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	94.4	1.14e-21	NR	MEY3826593.1	2847862	g35484	i0	87	0.92	46	6	92	0	138	1	84	129	MEY3826593.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	138	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27580974	27580974	PRJNA408129_S_NODE_18104_length_184_cov_3.319728_g18086_i0	PRJNA408129	18104	184	3.319728	6.10829952	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	70.9	3.76e-13	NR	HEY9783424.1	3088178	g18086	i0	72.5	0.831521739130435	51	14	83.2	0	1	153	152	202	HEY9783424.1 MFS transporter [Leptolyngbyaceae cyanobacterium]	diamond	153	70.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
27660987	27660987	PRJNA408129_S_NODE_13284_length_203_cov_3.548193_g13266_i0	PRJNA408129	13284	203	3.548193	7.20283179	Cyanophyceae	3028117	Bacteria	Bacteria	47	1.22e-4	NR	MBW4525067.1	2835093	g13266	i0	80	0.738916256157635	25	5	36.9	0	2	76	64	88	MBW4525067.1 DUF86 domain-containing protein [Phormidium tanganyikae FI6-MK23]	diamond	150	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium tanganyikae
27896670	27896670	PRJNA408129_S_NODE_14145_length_199_cov_3.277778_g14127_i0	PRJNA408129	14145	199	3.277778	6.52277822	Nostoc sp. UHCC	1180	Bacteria	Bacteria	69.7	1.39e-12	NR	WP_323231610.1	3110241	g14127	i0	58.7	0.949748743718593	63	26	95	0	10	198	65	127	WP_323231610.1 hypothetical protein [Nostoc sp. UHCC 0252]	diamond	189	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0252
28149496	28149496	PRJNA408129_S_NODE_27225_length_163_cov_1.230159_g27207_i0	PRJNA408129	27225	163	1.230159	2.00515917	Thermosynechococcaceae cyanobacterium	3083423	Bacteria	Bacteria	92	2.9e-22	NR	HEY9906023.1	3083423	g27207	i0	81.1	0.975460122699387	53	10	97.5	0	3	161	42	94	HEY9906023.1 DUF1818 family protein [Thermosynechococcaceae cyanobacterium]	diamond	159	92	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae		Thermosynechococcaceae cyanobacterium
28212293	28212293	PRJNA408129_S_NODE_31546_length_156_cov_1.294118_g31528_i0	PRJNA408129	31546	156	1.294118	2.01882408	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	50.4	2.12e-5	NR	HEY9759600.1	3088181	g31528	i0	67.6	0.653846153846154	34	11	65.4	0	103	2	83	116	HEY9759600.1 tetratricopeptide repeat protein [Oculatellaceae cyanobacterium]	diamond	102	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28275568	28275568	PRJNA408129_S_NODE_27526_length_162_cov_3.232000_g27508_i0	PRJNA408129	27526	162	3.232	5.23584	Cyanobacteria bacterium J06649_11	3023232	Bacteria	Bacteria	49.3	5.94e-5	NR	MEO0684792.1	3023232	g27508	i0	45.3	0.981481481481482	53	26	98.1	1	2	160	132	181	MEO0684792.1 hypothetical protein [Cyanobacteria bacterium J06649_11]	diamond	159	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06649_11
28292180	28292180	PRJNA408129_S_NODE_10386_length_219_cov_4.137363_g10368_i0	PRJNA408129	10386	219	4.137363	9.06082497	Phormidesmis	1005722	Bacteria	Bacteria	100	8.54e-23	NR	NJM96251.1	2720422	g10368	i0	83.6	2.61643835616438	61	10	83.6	0	28	210	252	312	NJM96251.1 response regulator [Phormidesmis sp. RL_2_1]	diamond	573	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Phormidesmis	Phormidesmis sp. RL_2_1
28843830	28843830	PRJNA408129_S_NODE_32268_length_155_cov_1.296610_g32250_i0	PRJNA408129	32268	155	1.29661	2.0097455	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	85.5	2.68e-18	NR	HEY9760528.1	3088181	g32250	i0	97.7	0.832258064516129	43	1	83.2	0	4	132	49	91	HEY9760528.1 UbiA-like polyprenyltransferase [Oculatellaceae cyanobacterium]	diamond	129	85.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28875578	28875578	PRJNA408129_S_NODE_29408_length_159_cov_2.237705_g29390_i0	PRJNA408129	29408	159	2.237705	3.55795095	Stenomitos sp.	3088177	Bacteria	Bacteria	46.6	5.12e-4	NR	HEY9833652.1	3088177	g29390	i0	44.7	0.886792452830189	47	26	88.7	0	11	151	163	209	HEY9833652.1 reverse transcriptase domain-containing protein [Stenomitos sp.]	diamond	141	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
28970365	28970365	PRJNA408129_S_NODE_34948_length_151_cov_3.271930_g34930_i0	PRJNA408129	34948	151	3.27193	4.9406143	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	76.3	1.56e-14	NR	HEY9755201.1	3088181	g34930	i0	79.6	0.973509933774834	49	10	97.4	0	3	149	427	475	HEY9755201.1 type I DNA topoisomerase [Oculatellaceae cyanobacterium]	diamond	147	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30043869	30043869	PRJNA408129_S_NODE_22251_length_173_cov_2.323529_g22233_i0	PRJNA408129	22251	173	2.323529	4.01970517	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	72	4.72e-13	NR	HEY9680950.1	3088181	g22233	i0	68	0.867052023121387	50	16	86.7	0	14	163	216	265	HEY9680950.1 NAD(P)/FAD-dependent oxidoreductase [Oculatellaceae cyanobacterium]	diamond	150	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30612517	30612517	PRJNA408129_S_NODE_25253_length_166_cov_4.627907_g25235_i0	PRJNA408129	25253	166	4.627907	7.68232562	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	77.4	7.41e-15	NR	MDZ4834118.1	2052166	g25235	i0	71.4	0.885542168674699	49	14	88.6	0	3	149	363	411	MDZ4834118.1 serine/threonine-protein kinase [Candidatus Melainabacteria bacterium]	diamond	147	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31023424	31023424	PRJNA408129_S_NODE_29875_length_158_cov_3.066116_g29857_i0	PRJNA408129	29875	158	3.066116	4.84446328	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	87.8	8.82e-20	NR	HEY9754452.1	3088181	g29857	i0	86.5	0.987341772151899	52	7	98.7	0	3	158	60	111	HEY9754452.1 TetR/AcrR family transcriptional regulator [Oculatellaceae cyanobacterium]	diamond	156	87.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
31324461	31324461	PRJNA408129_S_NODE_7855_length_237_cov_3.445000_g7837_i0	PRJNA408129	7855	237	3.445	8.16465	Cyanophyceae	3028117	Bacteria	Bacteria	91.3	6.88e-21	NR	CAA9376163.1	259945	g7837	i0	95.5	1.11392405063291	44	2	55.7	0	2	133	144	187	CAA9376163.1 hypothetical protein AVDCRST_MAG84-4735 [uncultured Microcoleus sp.]	diamond	264	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	uncultured Microcoleus sp.
31466206	31466206	PRJNA408129_S_NODE_33116_length_153_cov_9.905172_g33098_i0	PRJNA408129	33116	153	9.905172	15.15491316	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	77	8.7e-15	NR	HEY9754506.1	3088181	g33098	i0	87	0.901960784313726	46	6	90.2	0	139	2	266	311	HEY9754506.1 OPT family oligopeptide transporter [Oculatellaceae cyanobacterium]	diamond	138	77	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
31529423	31529423	PRJNA408129_S_NODE_20976_length_176_cov_3.136691_g20958_i0	PRJNA408129	20976	176	3.136691	5.52057616	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	73.6	1.85e-13	NR	HEY9755057.1	3088181	g20958	i0	72.2	0.920454545454545	54	15	92	0	167	6	235	288	HEY9755057.1 MFS transporter [Oculatellaceae cyanobacterium]	diamond	162	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
31529424	31529424	PRJNA408129_S_NODE_21456_length_175_cov_2.115942_g21438_i0	PRJNA408129	21456	175	2.115942	3.7028985	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	57.4	7.36e-8	NR	HEY9680173.1	3088181	g21438	i0	59.3	0.925714285714286	54	12	77.1	2	137	3	1	53	HEY9680173.1 signal peptidase I [Oculatellaceae cyanobacterium]	diamond	162	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
31561088	31561088	PRJNA408129_S_NODE_27376_length_162_cov_5.336000_g27358_i0	PRJNA408129	27376	162	5.336	8.64432	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	80.5	4.51e-16	NR	MDZ4836864.1	2052166	g27358	i0	77.1	0.888888888888889	48	10	87	1	144	4	53	100	MDZ4836864.1 DNA repair exonuclease [Candidatus Melainabacteria bacterium]	diamond	144	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31877037	31877037	PRJNA408129_S_NODE_28717_length_160_cov_3.081301_g28699_i0	PRJNA408129	28717	160	3.081301	4.9300816	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	67.4	1.14e-11	NR	HEY9759194.1	3088181	g28699	i0	69	0.7875	42	13	78.8	0	136	11	174	215	HEY9759194.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	126	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
32225352	32225352	PRJNA408129_S_NODE_11558_length_212_cov_6.348571_g11540_i0	PRJNA408129	11558	212	6.348571	13.45897052	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	82.8	1.5e-16	NR	HEY9754835.1	3088181	g11540	i0	75.4	0.806603773584906	57	14	80.7	0	13	183	314	370	HEY9754835.1 MFS transporter [Oculatellaceae cyanobacterium]	diamond	171	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium

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