metadata: contig_metadata: 24 rows where bioproject = "PRJEB50332", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

24 rows where bioproject = "PRJEB50332", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
119456	119456	PRJEB50332_P_NODE_17421_length_203_cov_0.915493_g17339_i0	PRJEB50332	17421	203	0.915493	1.85845079	Nostoc sp. C052	2576902	Bacteria	Bacteria	276	9.64e-70	NTclustered	gi\|1866639087\|gb\|CP040272.1\|	2576902	g17339	i0	91.133	33.8472906403941	203	18	100	0	1	203	1211147	1210945	Nostoc sp. C052 chromosome, complete genome	blastn	6871	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C052
2266527	2266527	PRJEB50332_P_NODE_1822_length_416_cov_1.163380_g1741_i0	PRJEB50332	1822	416	1.16338	4.8396608	Synechococcales	1890424	Bacteria	Bacteria	680	0	NTclustered	gi\|146740641\|emb\|AM709628.1\|	115743	g1741	i0	96.386	191.745192307692	415	11	99	2	2	416	4374	3964	Synechococcus sp. PCC 7009 partial ribosomal RNA operon, strain PCC 7009	blastn	79766	686	0.991253644314869	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. PCC 7009
2669532	2669532	PRJEB50332_P_NODE_2743_length_346_cov_2.112281_g2661_i0	PRJEB50332	2743	346	2.112281	7.30849226	Cyanothece	43988	Bacteria	Bacteria	172	1.58e-52	NR	NEQ95720.1	2607797	g2661	i0	70.2	1.97687861271676	114	34	98.8	0	4	345	28	141	NEQ95720.1 nucleoside-diphosphate kinase [Cyanothece sp. SIO2G6]	diamond	684	173	0.994219653179191	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. SIO2G6
4819181	4819181	PRJEB50332_P_NODE_1324_length_477_cov_1.560096_g1243_i0	PRJEB50332	1324	477	1.560096	7.44165792	Cyanobium	167375	Bacteria	Bacteria	870	0	NTclustered	gi\|146740641\|emb\|AM709628.1\|	115743	g1243	i0	99.582	176.40251572327	478	1	100	1	1	477	2953	2476	Synechococcus sp. PCC 7009 partial ribosomal RNA operon, strain PCC 7009	blastn	84144	876	0.993150684931507	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. PCC 7009
7771842	7771842	PRJEB50332_P_NODE_17387_length_203_cov_0.915493_g17305_i0	PRJEB50332	17387	203	0.915493	1.85845079	Bacteria	2	Bacteria	Bacteria	125	3.99e-33	NR	WP_096595497.1	1954171	g17305	i0	80.6	15.8275862068966	67	13	99	0	3	203	99	165	WP_096595497.1 hydrogenase small subunit [Calothrix sp. NIES-2098]	diamond	3213	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-2098
13744670	13744670	PRJEB50332_P_NODE_1371_length_467_cov_2.435961_g1290_i0	PRJEB50332	1371	467	2.435961	11.37593787	Tolypothrichaceae	119859	Bacteria	Bacteria	813	0	NTclustered	gi\|521763816\|gb\|KC463682.1\|	1211	g1290	i0	98.081	104.443254817987	469	5	100	3	1	467	342	808	Uncultured cyanobacterium clone BkfYyy_700 16S ribosomal RNA gene, partial sequence	blastn	48775	813	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16293957	16293957	PRJEB50332_P_NODE_13993_length_208_cov_1.768707_g13911_i0	PRJEB50332	13993	208	1.768707	3.67891056	Aliterella	1827277	Bacteria	Bacteria	129	8.170000000000001e-33	NR	WP_045053183.1	1827278	g13911	i0	91.3	1.99038461538462	69	6	99.5	0	2	208	795	863	WP_045053183.1 transcription-repair coupling factor [Aliterella atlantica]	diamond	414	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
17971096	17971096	PRJEB50332_P_NODE_9775_length_226_cov_1.181818_g9693_i0	PRJEB50332	9775	226	1.181818	2.67090868	Annamia dubia NIES-4383	2759045	Bacteria	Bacteria	75.9	6.46e-14	NR	BDG64460.1	2759045	g9693	i0	52	2.98672566371681	75	36	99.6	0	225	1	621	695	BDG64460.1 hypothetical protein Anndu_18350 [Annamia dubia NIES-4383]	diamond	675	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
21393375	21393375	PRJEB50332_P_NODE_2997_length_333_cov_1.536765_g2915_i0	PRJEB50332	2997	333	1.536765	5.11742745	root	1	Root_unresolved	Root_unresolved	616	8.87e-172	NTclustered	gi\|213389485\|gb\|FJ024312.1\|	1211	g2915	i0	100	100	333	0	100	0	1	333	736	404	Uncultured cyanobacterium clone 3 16S ribosomal RNA gene, partial sequence	blastn	33300	616	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23071549	23071549	PRJEB50332_P_NODE_9319_length_228_cov_1.556886_g9237_i0	PRJEB50332	9319	228	1.556886	3.54970008	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	165	2.4999999999999997e-36	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g9237	i0	81.373	1.75438596491228	204	36	89	2	1	203	3129433	3129231	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	400	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
27475938	27475938	PRJEB50332_P_NODE_6823_length_242_cov_2.016575_g6741_i0	PRJEB50332	6823	242	2.016575	4.8801115	Leptolyngbya sp. NIES-21	47254	Bacteria	Bacteria	74.7	5.08e-14	NR	WP_059002758.1	1552121	g6741	i0	90.5	1.04132231404959	42	4	52.1	0	240	115	146	187	WP_059002758.1 ParA family protein [Leptolyngbya sp. NIES-2104]	diamond	252	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-2104
27539186	27539186	PRJEB50332_P_NODE_7204_length_240_cov_1.815642_g7122_i0	PRJEB50332	7204	240	1.815642	4.3575408	Richelia intracellularis HH	1164990	Bacteria	Bacteria	72	2.41e-14	NR	CCH68009.1	1165094	g7122	i0	97.1	0.425	34	1	42.5	0	239	138	59	92	CCH68009.1 hypothetical protein RINTHH_18540 [Richelia intracellularis HH01]	diamond	102	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia intracellularis
28044264	28044264	PRJEB50332_P_NODE_7505_length_238_cov_3.129944_g7423_i0	PRJEB50332	7505	238	3.129944	7.44926672	Symploca sp. SIO3C6	2607803	Bacteria	Bacteria	43.9	0.0128	NR	NEO30896.1	2607803	g7423	i0	47.6	0.529411764705882	42	22	52.9	0	37	162	1	42	NEO30896.1 hypothetical protein [Symploca sp. SIO3C6]	diamond	126	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO3C6
28960165	28960165	PRJEB50332_P_NODE_11348_length_217_cov_1.596154_g11266_i0	PRJEB50332	11348	217	1.596154	3.46365418	Cyanobacteria bacterium PR.3.49	2067978	Bacteria	Bacteria	124	7.199999999999999e-31	NR	MBA3859903.1	2067978	g11266	i0	84.7	1.99078341013825	72	11	99.5	0	216	1	217	288	MBA3859903.1 AcrB/AcrD/AcrF family protein [Cyanobacteria bacterium PR.3.49]	diamond	432	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.3.49
29528346	29528346	PRJEB50332_P_NODE_10370_length_222_cov_1.683230_g10288_i0	PRJEB50332	10370	222	1.68323	3.7367706	Planktothrix sp.	3088171	Bacteria	Bacteria	93.2	2.3100000000000003e-21	NR	HEY9778463.1	3088171	g10288	i0	67.6	0.918918918918919	68	22	91.9	0	15	218	18	85	HEY9778463.1 guanylate kinase [Planktothrix sp.]	diamond	204	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp.
29837166	29837166	PRJEB50332_P_NODE_12211_length_212_cov_1.721854_g12129_i0	PRJEB50332	12211	212	1.721854	3.65033048	Coleofasciculus	669368	Bacteria	Bacteria	99.8	1.56e-23	NR	MEQ9238021.1	3069524	g12129	i0	70.6	3.84905660377358	68	19	96.2	1	6	209	11	77	MEQ9238021.1 ParB/RepB/Spo0J family partition protein [Coleofasciculus sp. E2-BRE-01]	diamond	816	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. E2-BRE-01
30191406	30191406	PRJEB50332_P_NODE_14672_length_207_cov_1.335616_g14590_i0	PRJEB50332	14672	207	1.335616	2.76472512	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	128	2.62e-33	NR	MBS2004951.1	2807734	g14590	i0	91.2	0.985507246376812	68	6	98.6	0	3	206	108	175	MBS2004951.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-5]	diamond	204	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
30633668	30633668	PRJEB50332_P_NODE_7193_length_240_cov_1.988827_g7111_i0	PRJEB50332	7193	240	1.988827	4.7731848	Pseudanabaena sp.	1153	Bacteria	Bacteria	40	0.0458	NR	MFN4832332.1	1153	g7111	i0	41.5	0.5125	41	24	51.3	0	174	52	1	41	MFN4832332.1 double zinc ribbon domain-containing protein [Pseudanabaena sp.]	diamond	123	40	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
31044941	31044941	PRJEB50332_P_NODE_10875_length_219_cov_2.221519_g10793_i0	PRJEB50332	10875	219	2.221519	4.86512661	Hassallia sp. WJT32-NPBG1	2835088	Bacteria	Bacteria	54.3	2.27e-7	NR	MBW4609971.1	2835088	g10793	i0	96.3	0.36986301369863	27	1	37	0	217	137	36	62	MBW4609971.1 hypothetical protein [Hassallia sp. WJT32-NPBG1]	diamond	81	54.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia sp. WJT32-NPBG1
32151588	32151588	PRJEB50332_P_NODE_7118_length_241_cov_1.166667_g7036_i0	PRJEB50332	7118	241	1.166667	2.81166747	Nostoc flagelliforme	1306274	Bacteria	Bacteria	72.4	2.09e-13	NR	WP_100898116.1	1306274	g7036	i0	87.8	1.0207468879668	41	5	51	0	237	115	163	203	WP_100898116.1 hypothetical protein [Nostoc flagelliforme]	diamond	246	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
32310071	32310071	PRJEB50332_P_NODE_14239_length_208_cov_0.884354_g14157_i0	PRJEB50332	14239	208	0.884354	1.83945632	Parathermosynechococcus lividus	33070	Bacteria	Bacteria	42	0.0458	NR	WP_099799142.1	33070	g14157	i0	34.8	0.995192307692308	69	44	98.1	1	1	204	668	736	WP_099799142.1 response regulator [Parathermosynechococcus lividus]	diamond	207	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Parathermosynechococcus	Parathermosynechococcus lividus
32493024	32493024	PRJEB50332_P_NODE_13799_length_209_cov_0.878378_g13717_i0	PRJEB50332	13799	209	0.878378	1.83581002	Cyanophyceae	3028117	Bacteria	Bacteria	115	8.08e-28	NR	WP_009632270.1	927677	g13717	i0	88.4	1.98086124401914	69	8	99	0	207	1	68	136	WP_009632270.1 tetratricopeptide repeat protein [Synechocystis sp. PCC 7509]	diamond	414	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
32493026	32493026	PRJEB50332_P_NODE_17459_length_202_cov_2.609929_g17377_i0	PRJEB50332	17459	202	2.609929	5.27205658	Cyanophyceae	3028117	Bacteria	Bacteria	63.9	6.45e-10	NR	WP_045052996.1	1827278	g17377	i0	100	2.4950495049505	28	0	41.6	0	3	86	334	361	WP_045052996.1 calcium/proton exchanger [Aliterella atlantica]	diamond	504	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
32808053	32808053	PRJEB50332_P_NODE_13140_length_210_cov_0.872483_g13058_i0	PRJEB50332	13140	210	0.872483	1.8322143	Cyanophyceae	3028117	Bacteria	Bacteria	70.9	1.28e-12	NR	WP_038027048.1	195250	g13058	i0	47.1	1.94285714285714	68	36	97.1	0	207	4	119	186	WP_038027048.1 DUF3800 domain-containing protein [Synechococcus sp. PCC 7336]	diamond	408	70.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PCC 7336

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