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

17 rows where analysis = "diamond", bioproject = "PRJNA758087" 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
2009642	2009642	PRJNA758087_P_NODE_35862_length_324_cov_2.075697_g34542_i0	PRJNA758087	35862	324	2.075697	6.72525828	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	216	3.81e-66	NR	MBX9687186.1	2364082	g34542	i0	96.3	1	108	4	100	0	324	1	109	216	MBX9687186.1 NADP-dependent phosphogluconate dehydrogenase [Candidatus Obscuribacterales bacterium]	diamond	324	216	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
12682479	12682479	PRJNA758087_P_NODE_39190_length_282_cov_2.459330_g37870_i0	PRJNA758087	39190	282	2.45933	6.9353106	Drouetiella sp.	3088174	Bacteria	Bacteria	110	2.53e-26	NR	HEY9732054.1	3088174	g37870	i0	100	0.531914893617021	50	0	53.2	0	131	280	1	50	HEY9732054.1 MFS transporter [Drouetiella sp.]	diamond	150	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
16036291	16036291	PRJNA758087_P_NODE_36473_length_316_cov_1.296296_g35153_i0	PRJNA758087	36473	316	1.296296	4.09629536	Cyanobacteria bacterium RM1_2_2	2720432	Bacteria	Bacteria	167	1.42e-45	NR	NJO77397.1	2720432	g35153	i0	94.2	5.71518987341772	86	5	81.6	0	2	259	228	313	NJO77397.1 TIGR03960 family B12-binding radical SAM protein [Cyanobacteria bacterium RM1_2_2]	diamond	1806	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium RM1_2_2
18585269	18585269	PRJNA758087_P_NODE_27315_length_457_cov_12.450521_g25995_i0	PRJNA758087	27315	457	12.450521	56.89888097	Candidatus Melainabacteria bacterium RIFCSPHIGHO2_	2052166	Bacteria	Bacteria	185	2.93e-54	NR	OGI18742.1	1801607	g25995	i0	65.9	0.905908096280088	138	34	82.7	2	79	456	148	284	OGI18742.1 MAG: tRNA preQ1(34) S-adenosylmethionine ribosyltransferase-isomerase QueA [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	414	185	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
18585757	18585757	PRJNA758087_P_NODE_7475_length_1218_cov_4.045415_g6558_i0	PRJNA758087	7475	1218	4.045415	49.2731547	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	427	6.019999999999998e-145	NR	WP_190379852.1	2650499	g6558	i0	94.1	1.6256157635468	220	13	54.2	0	1185	526	126	345	WP_190379852.1 MULTISPECIES: zinc-dependent alcohol dehydrogenase [unclassified Leptolyngbya]	diamond	1980	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
21136138	21136138	PRJNA758087_P_NODE_34117_length_348_cov_7.123636_g32797_i0	PRJNA758087	34117	348	7.123636	24.79025328	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	143	2.54e-37	NR	MBX9688495.1	2364082	g32797	i0	77.6	2.22413793103448	85	19	73.3	0	70	324	9	93	MBX9688495.1 ATP-binding cassette domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	774	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
21604854	21604854	PRJNA758087_P_NODE_13257_length_836_cov_68.372215_g12068_i0	PRJNA758087	13257	836	68.372215	571.5917174	Cyanophyceae	3028117	Bacteria	Bacteria	77	8.34e-12	NR	WP_190763162.1	3028117	g12068	i0	41.1	0.566985645933014	158	80	53.8	8	796	347	262	414	WP_190763162.1 MULTISPECIES: SBBP repeat-containing protein [Cyanophyceae]	diamond	474	77	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
22410685	22410685	PRJNA758087_P_NODE_24638_length_509_cov_19.823394_g23318_i0	PRJNA758087	24638	509	19.823394	100.90107546	Cyanophyceae	3028117	Bacteria	Bacteria	236	4.77e-77	NR	WP_179046445.1	2576904	g23318	i0	80	8.63457760314342	145	29	85.5	0	5	439	13	157	WP_179046445.1 GNAT family N-acetyltransferase [Nostoc sp. TCL26-01]	diamond	4395	237	0.9957805907173	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
27716742	27716742	PRJNA758087_P_NODE_13484_length_827_cov_2.259947_g12290_i0	PRJNA758087	13484	827	2.259947	18.68976169	Leptolyngbya sp. ERB_1_1	2083155	Bacteria	Bacteria	366	9.2e-125	NR	MER3435257.1	2083155	g12290	i0	93.2	0.696493349455865	192	13	69.6	0	804	229	77	268	MER3435257.1 hypothetical protein [Leptolyngbya sp. ERB_1_1]	diamond	576	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. ERB_1_1
27905541	27905541	PRJNA758087_P_NODE_23265_length_539_cov_1.156652_g21948_i0	PRJNA758087	23265	539	1.156652	6.23435428	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	202	9.84e-61	NR	HEY9781437.1	3088178	g21948	i0	66.1	0.951762523191095	171	52	92.4	4	36	533	3	172	HEY9781437.1 FAD-dependent oxidoreductase [Leptolyngbyaceae cyanobacterium]	diamond	513	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
28063602	28063602	PRJNA758087_P_NODE_39985_length_272_cov_4.015075_g38665_i0	PRJNA758087	39985	272	4.015075	10.921004	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	80.9	2.05e-15	NR	MBX9686575.1	2364082	g38665	i0	57.1	1.48897058823529	70	30	77.2	0	56	265	226	295	MBX9686575.1 S53 family peptidase [Candidatus Obscuribacterales bacterium]	diamond	405	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28347818	28347818	PRJNA758087_P_NODE_15566_length_747_cov_3.488131_g14322_i0	PRJNA758087	15566	747	3.488131	26.05633857	Drouetiella sp.	3088174	Bacteria	Bacteria	444	2.4899999999999993e-152	NR	HEY9730898.1	3088174	g14322	i0	99.6	0.943775100401606	235	1	94.4	0	727	23	49	283	HEY9730898.1 hypothetical protein [Drouetiella sp.]	diamond	705	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
29011284	29011284	PRJNA758087_P_NODE_42888_length_245_cov_1.343023_g41568_i0	PRJNA758087	42888	245	1.343023	3.29040635	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	88.6	2.77e-18	NR	WP_202807234.1	927677	g41568	i0	58.7	1.99591836734694	92	26	99.2	2	3	245	320	410	WP_202807234.1 DUF1565 domain-containing protein [Synechocystis sp. PCC 7509]	diamond	489	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
29137457	29137457	PRJNA758087_P_NODE_31809_length_383_cov_1.470968_g30489_i0	PRJNA758087	31809	383	1.470968	5.63380744	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	159	8.88e-44	NR	MBX9687936.1	2364082	g30489	i0	85.4	1.2845953002611	82	12	64.2	0	354	109	129	210	MBX9687936.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Candidatus Obscuribacterales bacterium]	diamond	492	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30526825	30526825	PRJNA758087_P_NODE_41733_length_251_cov_0.865169_g40413_i0	PRJNA758087	41733	251	0.865169	2.17157419	Trichocoleus sp. Lan	2933927	Bacteria	Bacteria	167	4.66e-50	NR	WP_348239706.1	2933927	g40413	i0	91.1	7.58964143426295	79	7	94.4	0	13	249	110	188	WP_348239706.1 IS1 family transposase [Trichocoleus sp. Lan]	diamond	1905	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. Lan
30653094	30653094	PRJNA758087_P_NODE_33793_length_353_cov_3.528571_g32473_i0	PRJNA758087	33793	353	3.528571	12.45585563	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	60.1	1.03e-8	NR	MBX9687174.1	2364082	g32473	i0	40	0.637393767705382	75	43	63.7	1	120	344	4	76	MBX9687174.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	225	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32739830	32739830	PRJNA758087_P_NODE_7580_length_1208_cov_22.822907_g6656_i0	PRJNA758087	7580	1208	22.822907	275.70071656	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	166	6.79e-41	NR	MBX9696243.1	2847862	g6656	i0	46.7	0.824503311258278	332	167	81.7	6	151	1137	90	414	MBX9696243.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	996	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota 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);;