metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax

30 rows where analysis = "diamond", bioproject = "PRJNA432257" 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
429303	429303	PRJNA432257_S_NODE_18161_length_332_cov_806.766102_g17780_i0	PRJNA432257	18161	332	806.766102	2678.4634586400002	Cyanobacteria bacterium J149	2420335	Bacteria	Bacteria	135	2.34e-38	NR	RMD70806.1	2420335	g17780	i0	90.8	0.686746987951807	76	7	68.7	0	33	260	72	147	RMD70806.1 MAG: 50S ribosomal protein L11 [Cyanobacteria bacterium J149]	diamond	228	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J149
5532661	5532661	PRJNA432257_S_NODE_104285_length_172_cov_12.837037_g103904_i0	PRJNA432257	104285	172	12.837037	22.07970364	Leptolyngbyaceae cyanobacterium C42_A2020_001	2811131	Bacteria	Bacteria	73.9	2.44e-14	NR	MBF2027065.1	2811131	g103904	i0	67.4	5.31976744186047	46	15	80.2	0	171	34	156	201	MBF2027065.1 signal peptidase I [Leptolyngbyaceae cyanobacterium C42_A2020_001]	diamond	915	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium C42_A2020_001
22105551	22105551	PRJNA432257_S_NODE_10538_length_401_cov_2.425824_g10177_i0	PRJNA432257	10538	401	2.425824	9.72755424	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	75.1	6.43e-13	NR	RYY00132.1	2847862	g10177	i0	42.1	1.08478802992519	145	57	92	6	371	3	99	238	RYY00132.1 MAG: hypothetical protein EOO35_00520 [Cyanobacteriota bacterium]	diamond	435	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27107207	27107207	PRJNA432257_S_NODE_29042_length_282_cov_51.906122_g28661_i0	PRJNA432257	29042	282	51.906122	146.37526404	cyanobacterium G8-9	2137193	Bacteria	Bacteria	77.8	2.96e-15	NR	PTB86440.1	2137193	g28661	i0	82.2	3.42553191489362	45	8	47.9	0	255	121	158	202	PTB86440.1 hypothetical protein C9925_02150 [cyanobacterium G8-9]	diamond	966	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium G8-9
27486644	27486644	PRJNA432257_S_NODE_80923_length_192_cov_2.606452_g80542_i0	PRJNA432257	80923	192	2.606452	5.00438784	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	50.8	2.56e-5	NR	WP_106369807.1	2107693	g80542	i0	50.8	0.984375	63	29	98.4	2	191	3	249	309	WP_106369807.1 response regulator [Chlorogloea sp. CCALA 695]	diamond	189	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
27644689	27644689	PRJNA432257_S_NODE_16604_length_343_cov_1.627451_g16223_i0	PRJNA432257	16604	343	1.627451	5.58215693	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	58.5	3.26e-7	NR	MFM2063929.1	2847862	g16223	i0	64.1	0.341107871720117	39	14	34.1	0	289	173	141	179	MFM2063929.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	117	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27865322	27865322	PRJNA432257_S_NODE_13605_length_367_cov_37.930303_g13224_i0	PRJNA432257	13605	367	37.930303	139.20421201	Planktothrix sp.	3088171	Bacteria	Bacteria	90.9	2.33e-19	NR	HEY9775633.1	3088171	g13224	i0	44.7	0.931880108991826	114	52	93.2	1	344	3	98	200	HEY9775633.1 septal ring lytic transglycosylase RlpA family protein [Planktothrix sp.]	diamond	342	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp.
27928669	27928669	PRJNA432257_S_NODE_42105_length_246_cov_12.248804_g41724_i0	PRJNA432257	42105	246	12.248804	30.13205784	Aphanothece hegewaldii	1521625	Bacteria	Bacteria	99.8	3.51e-22	NR	WP_106457619.1	1521625	g41724	i0	89.3	0.682926829268293	56	6	68.3	0	34	201	688	743	WP_106457619.1 ATP-dependent RecD-like DNA helicase [Aphanothece hegewaldii]	diamond	168	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece hegewaldii
28086365	28086365	PRJNA432257_S_NODE_101625_length_175_cov_1.695652_g101244_i0	PRJNA432257	101625	175	1.695652	2.967391	Vulcanococcus sp.	2856995	Bacteria	Bacteria	41.6	0.0373	NR	WP_398335015.1	2856995	g101244	i0	40.9	0.754285714285714	44	22	68.6	1	6	125	246	289	WP_398335015.1 amidohydrolase [Vulcanococcus sp.]	diamond	132	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Vulcanococcus	Vulcanococcus sp.
28591815	28591815	PRJNA432257_S_NODE_77667_length_195_cov_10.601266_g77286_i0	PRJNA432257	77667	195	10.601266	20.6724687	unclassified Nostoc	2593658	Bacteria	Bacteria	47	6.41e-4	NR	WP_292786205.1	2593658	g77286	i0	43.5	1.41538461538462	46	26	70.8	0	13	150	55	100	WP_292786205.1 MULTISPECIES: PIN-like domain-containing protein [unclassified Nostoc]	diamond	276	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc
28623402	28623402	PRJNA432257_S_NODE_17627_length_336_cov_2.732441_g17246_i0	PRJNA432257	17627	336	2.732441	9.18100176	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	50.8	1.4e-4	NR	RYY00132.1	2847862	g17246	i0	61.5	0.348214285714286	39	15	34.8	0	332	216	244	282	RYY00132.1 MAG: hypothetical protein EOO35_00520 [Cyanobacteriota bacterium]	diamond	117	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29065396	29065396	PRJNA432257_S_NODE_16248_length_345_cov_35.048701_g15867_i0	PRJNA432257	16248	345	35.048701	120.91801845	Picosynechococcus sp. PCC 7	32049	Bacteria	Bacteria	80.1	8.13e-17	NR	WP_217833304.1	32049	g15867	i0	74.2	0.539130434782609	62	16	53.9	0	139	324	41	102	WP_217833304.1 hypothetical protein, partial [Picosynechococcus sp. PCC 7002]	diamond	186	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7002
29475446	29475446	PRJNA432257_S_NODE_45430_length_239_cov_42.425743_g45049_i0	PRJNA432257	45430	239	42.425743	101.39752577	Alkalinema sp. CACIAM 7	3100328	Bacteria	Bacteria	125	9.529999999999999e-32	NR	OUC16573.1	1934309	g45049	i0	95.4	0.815899581589958	65	3	81.6	0	231	37	118	182	OUC16573.1 MAG: hypothetical protein B0A82_00925 [Alkalinema sp. CACIAM 70d]	diamond	195	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema sp. CACIAM 70d
29507247	29507247	PRJNA432257_S_NODE_104170_length_172_cov_51.940741_g103789_i0	PRJNA432257	104170	172	51.940741	89.33807452	Synechococcus sp. RSCCF1	1131	Bacteria	Bacteria	56.6	1.73e-7	NR	WP_370455485.1	2511069	g103789	i0	69.2	0.680232558139535	39	11	66.3	1	169	56	290	328	WP_370455485.1 aspartate-semialdehyde dehydrogenase [Synechococcus sp. RSCCF101]	diamond	117	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RSCCF101
29570353	29570353	PRJNA432257_S_NODE_58150_length_218_cov_34.121547_g57769_i0	PRJNA432257	58150	218	34.121547	74.38497246	Cyanobacteria bacterium REEB446	2800105	Bacteria	Bacteria	50.4	6.39e-6	NR	MBU6197850.1	2800105	g57769	i0	55.6	0.495412844036697	36	16	49.5	0	40	147	58	93	MBU6197850.1 hypothetical protein [Cyanobacteria bacterium REEB446]	diamond	108	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB446
29917976	29917976	PRJNA432257_S_NODE_116491_length_160_cov_1.268293_g116110_i0	PRJNA432257	116491	160	1.268293	2.0292688	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	103	3.36e-24	NR	WP_319423089.1	3040204	g116110	i0	88.7	1.9875	53	6	99.4	0	1	159	59	111	WP_319423089.1 AAA family ATPase [Pleurocapsa sp. FMAR1]	diamond	318	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
30123688	30123688	PRJNA432257_S_NODE_7612_length_449_cov_38.601942_g7293_i0	PRJNA432257	7612	449	38.601942	173.32271958	Cyanophyceae	3028117	Bacteria	Bacteria	49.7	0.0011	NR	WP_009631888.1	927677	g7293	i0	76.7	1.10244988864143	30	7	20	0	35	124	96	125	WP_009631888.1 gluconeogenesis factor YvcK family protein [Synechocystis sp. PCC 7509]	diamond	495	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
30170443	30170443	PRJNA432257_S_NODE_15772_length_349_cov_3.439103_g15391_i0	PRJNA432257	15772	349	3.439103	12.00246947	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	166	3.29e-51	NR	WP_009631000.1	927677	g15391	i0	98.9	0.765042979942693	89	1	76.5	0	334	68	1	89	WP_009631000.1 30S ribosomal protein S15 [Synechocystis sp. PCC 7509]	diamond	267	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
30360643	30360643	PRJNA432257_S_NODE_73412_length_199_cov_292.845679_g73031_i0	PRJNA432257	73412	199	292.845679	582.76290121	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	82.4	5.64e-17	NR	MBS1954896.1	2807733	g73031	i0	79.6	0.814070351758794	54	11	81.4	0	3	164	97	150	MBS1954896.1 hypothetical protein [Cyanobacteria bacterium SZAS-4]	diamond	162	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
30612800	30612800	PRJNA432257_S_NODE_78453_length_194_cov_39.464968_g78072_i0	PRJNA432257	78453	194	39.464968	76.56203792	Cyanomargarita calcarea	1982362	Bacteria	Bacteria	44.3	0.00552	NR	MBW4667069.1	2839659	g78072	i0	45.8	0.742268041237113	48	26	74.2	0	191	48	262	309	MBW4667069.1 hypothetical protein [Cyanomargarita calcarea GSE-NOS-MK-12-04C]	diamond	144	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Cyanomargaritaceae	Cyanomargarita	Cyanomargarita calcarea
30675965	30675965	PRJNA432257_S_NODE_61993_length_213_cov_9.034091_g61612_i0	PRJNA432257	61993	213	9.034091	19.24261383	Microcystis sp. 53598_E5	2904985	Bacteria	Bacteria	56.2	4.37e-7	NR	MCE2674445.1	2904985	g61612	i0	51	0.71830985915493	51	25	71.8	0	212	60	777	827	MCE2674445.1 hypothetical protein [Microcystis sp. 53598_E5]	diamond	153	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. 53598_E5
31371599	31371599	PRJNA432257_S_NODE_98016_length_178_cov_1.581560_g97635_i0	PRJNA432257	98016	178	1.58156	2.8151768	Hydrocoleum sp. CS-953	1671698	Bacteria	Bacteria	41.2	0.0446	NR	WP_371357361.1	1671698	g97635	i0	43.8	0.808988764044944	48	27	80.9	0	19	162	35	82	WP_371357361.1 DUF928 domain-containing protein, partial [Hydrocoleum sp. CS-953]	diamond	144	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Hydrocoleum	Hydrocoleum sp. CS-953
31403179	31403179	PRJNA432257_S_NODE_42896_length_244_cov_187.763285_g42515_i0	PRJNA432257	42896	244	187.763285	458.1424154	Calothrix sp. CCY 0018	3103864	Bacteria	Bacteria	63.9	1.13e-9	NR	WP_414621273.1	3103864	g42515	i0	43.8	0.897540983606557	73	41	89.8	0	17	235	31	103	WP_414621273.1 acyltransferase family protein [Calothrix sp. CCY 0018]	diamond	219	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. CCY 0018
31466465	31466465	PRJNA432257_S_NODE_61716_length_213_cov_241.914773_g61335_i0	PRJNA432257	61716	213	241.914773	515.27846649	Geminocystis sp.	2664100	Bacteria	Bacteria	78.2	1.37e-16	NR	MCS6941428.1	2664100	g61335	i0	79.6	5.70422535211268	49	10	69	0	211	65	44	92	MCS6941428.1 urease subunit beta [Geminocystis sp.]	diamond	1215	78.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp.
31877304	31877304	PRJNA432257_S_NODE_11757_length_386_cov_3.375358_g11386_i0	PRJNA432257	11757	386	3.375358	13.02888188	Chroococcidiopsis sp. CCALA	3088168	Bacteria	Bacteria	139	3.2299999999999997e-37	NR	WP_106545729.1	869949	g11386	i0	92.8	3.18652849740933	83	6	64.5	0	3	251	259	341	WP_106545729.1 AI-2E family transporter [Chroococcidiopsis sp. CCALA 051]	diamond	1230	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCALA 051
32067196	32067196	PRJNA432257_S_NODE_14558_length_358_cov_473.323988_g14177_i0	PRJNA432257	14558	358	473.323988	1694.49987704	Dolichospermum sp. ST_sed3	2916807	Bacteria	Bacteria	152	4.64e-44	NR	MDD1444115.1	2916807	g14177	i0	64.5	0.921787709497207	110	38	92.2	1	351	22	15	123	MDD1444115.1 hypothetical protein [Dolichospermum sp. ST_sed3]	diamond	330	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. ST_sed3
32098896	32098896	PRJNA432257_S_NODE_23538_length_304_cov_61.737828_g23157_i0	PRJNA432257	23538	304	61.737828	187.68299712	Nostoc sp. NIES-3756	1751286	Bacteria	Bacteria	57.4	2.57e-7	NR	WP_067776638.1	1751286	g23157	i0	36.1	0.601973684210526	61	39	60.2	0	238	56	125	185	WP_067776638.1 hypothetical protein [Nostoc sp. NIES-3756]	diamond	183	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
32415493	32415493	PRJNA432257_S_NODE_53479_length_225_cov_18.845745_g53098_i0	PRJNA432257	53479	225	18.845745	42.40292625	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	114	1.44e-27	NR	WP_009633221.1	927677	g53098	i0	88.5	0.813333333333333	61	7	81.3	0	220	38	139	199	WP_009633221.1 NADH-quinone oxidoreductase subunit M [Synechocystis sp. PCC 7509]	diamond	183	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
32636252	32636252	PRJNA432257_S_NODE_45560_length_239_cov_4.589109_g45179_i0	PRJNA432257	45560	239	4.589109	10.96797051	Cyanophyceae	3028117	Bacteria	Bacteria	147	1.53e-43	NR	WP_190768994.1	3028117	g45179	i0	98.7	0.941422594142259	75	1	94.1	0	13	237	50	124	WP_190768994.1 MULTISPECIES: ribosome maturation factor RimP [Cyanophyceae]	diamond	225	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
32888278	32888278	PRJNA432257_S_NODE_96200_length_179_cov_9.992958_g95819_i0	PRJNA432257	96200	179	9.992958	17.88739482	Thermosynechococcus sp. NK55a	1394889	Bacteria	Bacteria	47.8	2.72e-4	NR	WP_024125875.1	1394889	g95819	i0	79.3	0.486033519553073	29	6	48.6	0	67	153	3	31	WP_024125875.1 site-specific DNA-methyltransferase [Thermosynechococcus sp. NK55a]	diamond	87	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus sp. NK55a

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