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

10 rows where analysis = "blastn", bioproject = "PRJNA896554" 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
2147610	2147610	PRJNA896554_P_NODE_79962_length_400_cov_1.807339_g72422_i0	PRJNA896554	79962	400	1.807339	7.229356	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	684	0	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g72422	i0	97.5	114.035	400	10	100	0	1	400	1014	1413	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	45614	684	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
5974066	5974066	PRJNA896554_P_NODE_162125_length_246_cov_0.890173_g154585_i0	PRJNA896554	162125	246	0.890173	2.18982558	Nostoc sp. C117	3349875	Bacteria	Bacteria	359	1.1699999999999999e-94	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g154585	i0	93.388	1.8739837398374	242	16	98	0	5	246	1280823	1280582	Nostoc sp. C117 chromosome, complete genome	blastn	461	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
8523274	8523274	PRJNA896554_P_NODE_148387_length_252_cov_1.810056_g140847_i0	PRJNA896554	148387	252	1.810056	4.56134112	Nostoc edaphicum	264686	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g140847	i0	100	150.936507936508	252	0	100	0	1	252	1355529	1355278	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	38036	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
9798908	9798908	PRJNA896554_P_NODE_176148_length_239_cov_4.337349_g168608_i0	PRJNA896554	176148	239	4.337349	10.36626411	Aliterella chasmolithica	2739056	Bacteria	Bacteria	355	1.46e-93	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g168608	i0	93.671	134.882845188285	237	15	99	0	1	237	1989	2225	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32237	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
12723356	12723356	PRJNA896554_P_NODE_58490_length_554_cov_1.353430_g50985_i0	PRJNA896554	58490	554	1.35343	7.4980022	Bacteria	2	Bacteria	Bacteria	99	6.91e-16	NTclustered	gi\|2814330024\|gb\|CP067995.1\|	309035	g50985	i0	83.178	12.3393501805054	107	18	19	0	438	544	1104131	1104025	MAG: cyanobacterium endosymbiont of Rhopalodia gibba isolate 17Bon1-SB chromosome, complete genome	blastn	6836	100	0.99	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Rhopalodia gibba
15271710	15271710	PRJNA896554_P_NODE_173452_length_241_cov_2.785714_g165912_i0	PRJNA896554	173452	241	2.785714	6.71357074	Microcoleus	44471	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g165912	i0	100	138.97510373444	241	0	100	0	1	241	103340	103580	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	33493	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
17448099	17448099	PRJNA896554_P_NODE_126034_length_282_cov_1.181818_g118494_i0	PRJNA896554	126034	282	1.181818	3.33272676	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	488	1.6699999999999998e-133	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g118494	i0	97.88	471.301418439716	283	5	100	1	1	282	4315935	4315653	Leptolyngbya sp. 7M chromosome	blastn	132907	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
19095197	19095197	PRJNA896554_P_NODE_129035_length_277_cov_2.764706_g121495_i0	PRJNA896554	129035	277	2.764706	7.65823562	Oscillatoriales	1150	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g121495	i0	99.639	141.906137184116	277	1	100	0	1	277	1373291	1373567	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	39308	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
19997514	19997514	PRJNA896554_P_NODE_165596_length_245_cov_0.895349_g158056_i0	PRJNA896554	165596	245	0.895349	2.19360505	Microcoleus vaginatus	119532	Bacteria	Bacteria	331	2.5400000000000002e-86	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g158056	i0	91.02	8	245	22	100	0	1	245	6331148	6331392	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1960	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
23823653	23823653	PRJNA896554_P_NODE_42339_length_828_cov_2.017219_g35216_i0	PRJNA896554	42339	828	2.017219	16.70257332	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1295	0	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g35216	i0	94.928	185.311594202899	828	40	99	2	1	827	1702	2528	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	153438	1295	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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