metadata: contig_metadata: 29 rows where analysis = "diamond", bioproject = "PRJNA694557" and tax

29 rows where analysis = "diamond", bioproject = "PRJNA694557" and tax_phylum = "Cyanobacteriota"

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
8326262	8326262	PRJNA694557_P_NODE_10467_length_420_cov_1.608069_g10247_i0	PRJNA694557	10467	420	1.608069	6.7538898	Chroococcidiopsis sp. [FACHB-1243]	2692781	Bacteria	Bacteria	215	1.46e-67	NR	WP_347276447.1	2692781	g10247	i0	86.2	1.63571428571429	116	16	82.9	0	71	418	1	116	WP_347276447.1 IS5 family transposase [Chroococcidiopsis sp. [FACHB-1243]]	diamond	687	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. [FACHB-1243]
15976282	15976282	PRJNA694557_P_NODE_8853_length_465_cov_2.821429_g8633_i0	PRJNA694557	8853	465	2.821429	13.11964485	Chroococcidiopsis sp. [FACHB-1243]	2692781	Bacteria	Bacteria	125	8.419999999999998e-32	NR	WP_192154478.1	2692781	g8633	i0	94.1	0.438709677419355	68	4	43.9	0	262	465	1	68	WP_192154478.1 YihY/virulence factor BrkB family protein [Chroococcidiopsis sp. [FACHB-1243]]	diamond	204	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. [FACHB-1243]
22350602	22350602	PRJNA694557_P_NODE_16658_length_314_cov_3.319502_g16438_i0	PRJNA694557	16658	314	3.319502	10.42323628	Chroococcidiopsis sp. CCALA	3088168	Bacteria	Bacteria	167	8.509999999999998e-48	NR	WP_106546297.1	869949	g16438	i0	80.8	0.945859872611465	99	19	94.6	0	17	313	272	370	WP_106546297.1 cation:proton antiporter [Chroococcidiopsis sp. CCALA 051]	diamond	297	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCALA 051
27430458	27430458	PRJNA694557_P_NODE_24563_length_246_cov_1.283237_g24343_i0	PRJNA694557	24563	246	1.283237	3.15676302	Chroococcidiopsis sp. [FACHB-1243]	2692781	Bacteria	Bacteria	71.6	2.38e-12	NR	WP_192160069.1	2692781	g24343	i0	91.7	0.439024390243902	36	3	43.9	0	137	244	5	40	WP_192160069.1 chloride channel protein [Chroococcidiopsis sp. [FACHB-1243]]	diamond	108	71.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. [FACHB-1243]
27461954	27461954	PRJNA694557_P_NODE_16103_length_321_cov_2.399194_g15883_i0	PRJNA694557	16103	321	2.399194	7.70141274	Dulcicalothrix desertica	32056	Bacteria	Bacteria	125	1.18e-33	NR	WP_201800810.1	32056	g15883	i0	86.6	0.766355140186916	82	11	76.6	0	319	74	28	109	WP_201800810.1 hypothetical protein [Dulcicalothrix desertica]	diamond	246	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
27524942	27524942	PRJNA694557_P_NODE_24963_length_244_cov_2.421053_g24743_i0	PRJNA694557	24963	244	2.421053	5.90736932	Chroococcidiopsis sp. [FACHB-1243]	2692781	Bacteria	Bacteria	138	7.799999999999999e-36	NR	WP_192161305.1	2692781	g24743	i0	88.5	0.959016393442623	78	9	95.9	0	2	235	470	547	WP_192161305.1 CHAT domain-containing protein [Chroococcidiopsis sp. [FACHB-1243]]	diamond	234	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. [FACHB-1243]
27588200	27588200	PRJNA694557_P_NODE_21404_length_267_cov_1.417526_g21184_i0	PRJNA694557	21404	267	1.417526	3.78479442	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	141	1.0400000000000001e-36	NR	HEY9783395.1	3088178	g21184	i0	87.5	0.898876404494382	80	10	89.9	0	265	26	69	148	HEY9783395.1 filamentous hemagglutinin N-terminal domain-containing protein [Leptolyngbyaceae cyanobacterium]	diamond	240	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
28072930	28072930	PRJNA694557_P_NODE_15865_length_324_cov_1.717131_g15645_i0	PRJNA694557	15865	324	1.717131	5.56350444	Kalymmatonema	3452864	Bacteria	Bacteria	183	2.86e-53	NR	MBW4502635.1	1939789	g15645	i0	80.4	1.88888888888889	102	20	94.4	0	2	307	217	318	MBW4502635.1 IS66 family transposase [Scytonema hyalinum WJT4-NPBG1]	diamond	612	183	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
28409053	28409053	PRJNA694557_P_NODE_22866_length_255_cov_1.604396_g22646_i0	PRJNA694557	22866	255	1.604396	4.0912098	Synechococcaceae cyanobacterium	2588875	Bacteria	Bacteria	146	1.07e-38	NR	MFO0015468.1	2588875	g22646	i0	87.3	4.64705882352941	79	10	92.9	0	11	247	555	633	MFO0015468.1 DUF4157 domain-containing protein [Synechococcaceae cyanobacterium]	diamond	1185	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium
28440739	28440739	PRJNA694557_P_NODE_4406_length_719_cov_4.897833_g4195_i0	PRJNA694557	4406	719	4.897833	35.21541927	Cyanobacteria bacterium RYN_339	2812886	Bacteria	Bacteria	47.4	0.0363	NR	MDB5101573.1	2812886	g4195	i0	34.5	0.726008344923505	174	75	64.3	10	620	159	386	540	MDB5101573.1 hypothetical protein [Cyanobacteria bacterium RYN_339]	diamond	522	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium RYN_339
28503741	28503741	PRJNA694557_P_NODE_9027_length_460_cov_1.782946_g8807_i0	PRJNA694557	9027	460	1.782946	8.2015516	Nostoc sp. LEGE	1180	Bacteria	Bacteria	59.3	4.86e-7	NR	WP_193890479.1	915325	g8807	i0	37.1	0.580434782608696	89	46	54.1	3	52	300	27	111	WP_193890479.1 hypothetical protein [Nostoc sp. LEGE 06077]	diamond	267	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. LEGE 06077
29450677	29450677	PRJNA694557_P_NODE_22730_length_256_cov_1.683060_g22510_i0	PRJNA694557	22730	256	1.68306	4.3086336	Synechococcus sp. CBW11	1131	Bacteria	Bacteria	164	3.15e-46	NR	WP_197148206.1	1353147	g22510	i0	92.9	1.9921875	85	6	99.6	0	2	256	265	349	WP_197148206.1 Z1 domain-containing protein [Synechococcus sp. CBW1108]	diamond	510	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1108
29777916	29777916	PRJNA694557_P_NODE_20671_length_273_cov_2.940000_g20451_i0	PRJNA694557	20671	273	2.94	8.0262	Moorena	1155738	Bacteria	Bacteria	117	2.05e-29	NR	HAZ47363.1	2055770	g20451	i0	77	10.7032967032967	74	17	81.3	0	51	272	4	77	HAZ47363.1 glycosyl transferase family 2 [Cyanobacteria bacterium UBA11371]	diamond	2922	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11371
29829804	29829804	PRJNA694557_P_NODE_9911_length_434_cov_2.759003_g9691_i0	PRJNA694557	9911	434	2.759003	11.97407302	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	144	7.38e-40	NR	HCF27868.1	2055787	g9691	i0	94	0.580645161290323	84	5	58.1	0	434	183	153	236	HCF27868.1 hypothetical protein [Cyanobacteria bacterium UBA11049]	diamond	252	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
30156861	30156861	PRJNA694557_P_NODE_5192_length_650_cov_10.421144_g4975_i0	PRJNA694557	5192	650	10.421144	67.737436	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	84	1.31e-17	NR	WP_169153706.1	383615	g4975	i0	64.7	2.30307692307692	51	18	23.5	0	436	284	4	54	WP_169153706.1 rubredoxin [Brasilonema bromeliae]	diamond	1497	84	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema bromeliae
30378649	30378649	PRJNA694557_P_NODE_12352_length_378_cov_1.639344_g12132_i0	PRJNA694557	12352	378	1.639344	6.19672032	Cyanophyceae	3028117	Bacteria	Bacteria	176	4.099999999999999e-48	NR	OWY65343.1	1503470	g12132	i0	64.1	12.484126984127	117	42	92.9	0	23	373	892	1008	OWY65343.1 hypothetical protein B7486_42420 [cyanobacterium TDX16]	diamond	4719	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
30430515	30430515	PRJNA694557_P_NODE_17473_length_305_cov_1.870690_g17253_i0	PRJNA694557	17473	305	1.87069	5.7056045	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	167	7.589999999999999e-48	NR	HCF26412.1	2055787	g17253	i0	93.8	0.944262295081967	96	6	94.4	0	2	289	317	412	HCF26412.1 [cytidine(C)-cytidine(C)-adenosine (A)]-adding enzyme [Cyanobacteria bacterium UBA11049]	diamond	288	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
30820649	30820649	PRJNA694557_P_NODE_14934_length_336_cov_2.596958_g14714_i0	PRJNA694557	14934	336	2.596958	8.72577888	Nostocaceae	1162	Bacteria	Bacteria	144	2.24e-39	NR	WP_235116449.1	1179	g14714	i0	82.1	4.5	84	15	75	0	24	275	249	332	WP_235116449.1 IS630 family transposase [Desmonostoc muscorum]	diamond	1512	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Desmonostoc	Desmonostoc muscorum
31093634	31093634	PRJNA694557_P_NODE_10595_length_416_cov_3.218659_g10375_i0	PRJNA694557	10595	416	3.218659	13.38962144	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	226	7.64e-70	NR	HCF28024.1	2055787	g10375	i0	83.3	0.951923076923077	132	22	95.2	0	410	15	23	154	HCF28024.1 IS1380 family transposase [Cyanobacteria bacterium UBA11049]	diamond	396	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
31726003	31726003	PRJNA694557_P_NODE_14037_length_350_cov_1.880866_g13817_i0	PRJNA694557	14037	350	1.880866	6.583031	Acaryochloris sp. 'Moss Beach'	2740837	Bacteria	Bacteria	73.2	2.82e-12	NR	WP_235109357.1	2740837	g13817	i0	42.2	2.43428571428571	83	47	70.3	1	85	330	578	660	WP_235109357.1 NB-ARC domain-containing protein [Acaryochloris sp. 'Moss Beach']	diamond	852	73.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris sp. 'Moss Beach'
31820851	31820851	PRJNA694557_P_NODE_21797_length_264_cov_0.837696_g21577_i0	PRJNA694557	21797	264	0.837696	2.21151744	Drouetiella sp.	3088174	Bacteria	Bacteria	167	1.57e-48	NR	HEY9733116.1	3088174	g21577	i0	100	0.954545454545455	84	0	95.5	0	263	12	272	355	HEY9733116.1 alpha/beta fold hydrolase [Drouetiella sp.]	diamond	252	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
31884180	31884180	PRJNA694557_P_NODE_21137_length_269_cov_1.780612_g20917_i0	PRJNA694557	21137	269	1.780612	4.78984628	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	156	1.97e-44	NR	HCF28007.1	2055787	g20917	i0	96.4	0.936802973977695	84	3	93.7	0	252	1	129	212	HCF28007.1 heat-inducible transcriptional repressor HrcA [Cyanobacteria bacterium UBA11049]	diamond	252	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
31915860	31915860	PRJNA694557_P_NODE_23477_length_251_cov_0.865169_g23257_i0	PRJNA694557	23477	251	0.865169	2.17157419	Microseira wollei	467598	Bacteria	Bacteria	138	3.92e-40	NR	WP_226584722.1	467598	g23257	i0	95.7	0.824701195219124	69	3	82.5	0	43	249	1	69	WP_226584722.1 DUF1830 domain-containing protein [Microseira wollei]	diamond	207	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei
32390550	32390550	PRJNA694557_P_NODE_22959_length_254_cov_2.254144_g22739_i0	PRJNA694557	22959	254	2.254144	5.72552576	Drouetiella sp.	3088174	Bacteria	Bacteria	46.2	6.87e-4	NR	HEY9732073.1	3088174	g22739	i0	100	0.307086614173228	26	0	30.7	0	189	112	6	31	HEY9732073.1 hypothetical protein [Drouetiella sp.]	diamond	78	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
32485618	32485618	PRJNA694557_P_NODE_24159_length_248_cov_0.880000_g23939_i0	PRJNA694557	24159	248	0.88	2.1824	Drouetiella sp.	3088174	Bacteria	Bacteria	164	5.09e-46	NR	HEY9731594.1	3088174	g23939	i0	97.6	0.991935483870968	82	2	99.2	0	3	248	33	114	HEY9731594.1 glycosyltransferase family 39 protein [Drouetiella sp.]	diamond	246	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
32611785	32611785	PRJNA694557_P_NODE_14640_length_340_cov_2.520599_g14420_i0	PRJNA694557	14640	340	2.520599	8.5700366	Anabaena subtropica	425380	Bacteria	Bacteria	155	5.999999999999998e-42	NR	WP_190406849.1	425380	g14420	i0	67	1.97647058823529	112	37	98.8	0	1	336	66	177	WP_190406849.1 asparagine synthase-related protein [Anabaena subtropica]	diamond	672	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena subtropica
32674557	32674557	PRJNA694557_P_NODE_12120_length_383_cov_1.464516_g11900_i0	PRJNA694557	12120	383	1.464516	5.60909628	Rivularia sp. ALOHA_DT_140	2916564	Bacteria	Bacteria	53.5	1.06e-6	NR	MCJ8280304.1	2916564	g11900	i0	56.1	0.321148825065274	41	18	32.1	0	249	371	23	63	MCJ8280304.1 hypothetical protein [Rivularia sp. ALOHA_DT_140]	diamond	123	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. ALOHA_DT_140
32706127	32706127	PRJNA694557_P_NODE_3780_length_784_cov_3.766526_g3579_i0	PRJNA694557	3780	784	3.766526	29.52956384	Chroococcidiopsis sp. [FACHB-1243]	2692781	Bacteria	Bacteria	391	3.94e-126	NR	WP_192161305.1	2692781	g3579	i0	88.5	0.899234693877551	235	27	89.9	0	8	712	548	782	WP_192161305.1 CHAT domain-containing protein [Chroococcidiopsis sp. [FACHB-1243]]	diamond	705	391	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. [FACHB-1243]
32843343	32843343	PRJNA694557_P_NODE_21740_length_264_cov_1.863874_g21520_i0	PRJNA694557	21740	264	1.863874	4.92062736	Cyanophyceae	3028117	Bacteria	Bacteria	144	2.66e-39	NR	WP_193923684.1	945768	g21520	i0	81.5	2.76136363636364	81	15	92	0	263	21	144	224	WP_193923684.1 glutathione S-transferase family protein [Plectonema radiosum]	diamond	729	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum

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