metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax_clade = "Cyanobacteriota/Melainabacteria group"

14 rows where analysis = "blastn", bioproject = "PRJNA404067" 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
1689295	1689295	PRJNA404067_P_NODE_18322_length_243_cov_5.576923_g17935_i0	PRJNA404067	18322	243	5.576923	13.55192289	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	344	3.23e-90	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g17935	i0	92.181	182.814814814815	243	19	100	0	1	243	22	264	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	44424	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
2965408	2965408	PRJNA404067_P_NODE_31423_length_209_cov_0.864865_g31036_i0	PRJNA404067	31423	209	0.864865	1.80756785	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	291	3.57e-74	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g31036	i0	97.11	171.382775119617	173	4	82	1	1	172	1243408	1243236	Calothrix sp. NIES-4101 DNA, complete genome	blastn	35819	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
3632043	3632043	PRJNA404067_P_NODE_17203_length_251_cov_0.910526_g16816_i0	PRJNA404067	17203	251	0.910526	2.28542026	Chroococcidiopsis	54298	Bacteria	Bacteria	435	1.93e-117	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g16816	i0	98.008	60.4621513944223	251	4	100	1	1	251	1622	1373	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	15176	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
4909503	4909503	PRJNA404067_P_NODE_44384_length_171_cov_4.181818_g43997_i0	PRJNA404067	44384	171	4.181818	7.15090878	Oscillatoriales	1150	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|1566846289\|dbj\|LC455669.1\|	118562	g43997	i0	100	169.116959064327	171	0	100	0	1	171	462	292	Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence	blastn	28919	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
4909524	4909524	PRJNA404067_P_NODE_45064_length_167_cov_6.283019_g44677_i0	PRJNA404067	45064	167	6.283019	10.49264173	Nodosilinea	1120752	Bacteria	Bacteria	261	2.14e-65	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g44677	i0	95.152	166.646706586826	165	8	99	0	1	165	343	507	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	27830	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
6792458	6792458	PRJNA404067_P_NODE_34326_length_205_cov_1.548611_g33939_i0	PRJNA404067	34326	205	1.548611	3.17465255	uncultured Leptolyngbya sp.	332963	Bacteria	Bacteria	340	3.41e-89	NTclustered	gi\|453201742\|gb\|JQ999650.1\|	332963	g33939	i0	96.585	165.970731707317	205	7	100	0	1	205	132	336	Uncultured Leptolyngbya sp. clone GKJWQY101BHUYF 23S ribosomal RNA gene, partial sequence	blastn	34024	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	uncultured Leptolyngbya sp.
8734088	8734088	PRJNA404067_P_NODE_21547_length_232_cov_1.280702_g21160_i0	PRJNA404067	21547	232	1.280702	2.97122864	root	1	Root_unresolved	Root_unresolved	412	8.26e-111	NTclustered	gi\|892164921\|gb\|KT182535.1\|	1211	g21160	i0	98.707	100	232	3	100	0	1	232	786	555	Uncultured cyanobacterium clone MBR Ca 100ppm 6 16S ribosomal RNA gene, partial sequence	blastn	23200	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
10618830	10618830	PRJNA404067_P_NODE_6229_length_506_cov_4.800000_g5854_i0	PRJNA404067	6229	506	4.8	24.288	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	294	7.45e-75	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5854	i0	78.395	64.998023715415	486	81	93	18	33	502	3680916	3681393	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	32889	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14443408	14443408	PRJNA404067_P_NODE_18072_length_245_cov_0.847826_g17685_i0	PRJNA404067	18072	245	0.847826	2.0771737	Thermoleptolyngbya oregonensis	2303529	Bacteria	Bacteria	353	5.41e-93	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g17685	i0	92.653	3.04489795918367	245	18	100	0	1	245	857176	857420	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	746	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
19540168	19540168	PRJNA404067_P_NODE_11016_length_323_cov_5.164122_g10631_i0	PRJNA404067	11016	323	5.164122	16.68011406	uncultured cyanobacterium	1211	Bacteria	Bacteria	497	3.2399999999999993e-136	NTclustered	gi\|672011990\|gb\|KF544977.1\|	1211	g10631	i0	94.688	99.5572755417957	320	17	99	0	1	320	493	812	Uncultured cyanobacterium clone MSmat.4.16 16S ribosomal RNA gene, partial sequence	blastn	32157	497	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20207386	20207386	PRJNA404067_P_NODE_15876_length_260_cov_2.422111_g15489_i0	PRJNA404067	15876	260	2.422111	6.2974886	Chroococcidiopsis	54298	Bacteria	Bacteria	392	1.2299999999999999e-104	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g15489	i0	96.25	114.284615384615	240	7	92	1	23	260	3532	3771	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	29714	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
22091081	22091081	PRJNA404067_P_NODE_27478_length_217_cov_1.051282_g27091_i0	PRJNA404067	27478	217	1.051282	2.28128194	Cyanobacteria bacterium LVE1205-1	2903134	Bacteria	Bacteria	388	1.29e-103	NTclustered	gi\|2800745465\|gb\|CP089922.1\|	2903134	g27091	i0	99.078	1	217	1	100	1	1	217	2741870	2741655	MAG: Cyanobacteria bacterium LVE1205-1 chromosome, complete genome	blastn	217	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium LVE1205-1
22758342	22758342	PRJNA404067_P_NODE_34138_length_205_cov_9.298611_g33751_i0	PRJNA404067	34138	205	9.298611	19.06215255	Cyanophyceae	3028117	Bacteria	Bacteria	324	3.44e-84	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g33751	i0	95.122	132.263414634146	205	10	100	0	1	205	2199377	2199581	Oscillatoria acuminata PCC 6304, complete genome	blastn	27114	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
24641335	24641335	PRJNA404067_P_NODE_9840_length_350_cov_1.865052_g9455_i0	PRJNA404067	9840	350	1.865052	6.527682	Oculatella lusitanica	2928764	Bacteria	Bacteria	346	1.35e-90	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g9455	i0	86.25	144.305714285714	320	42	91	2	27	346	3263	3580	Oculatella lusitanica LEGE 161147 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	50507	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica

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