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

14 rows where analysis = "blastn", bioproject = "PRJEB39269" 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
989209	989209	PRJEB39269_P_NODE_33701_length_238_cov_1.497487_g33296_i0	PRJEB39269	33701	238	1.497487	3.56401906	Microcoleus	44471	Bacteria	Bacteria	429	8.45e-116	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g33296	i0	99.16	127.021008403361	238	2	100	0	1	238	3173	2936	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30231	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
989262	989262	PRJEB39269_P_NODE_86621_length_153_cov_4.719298_g86216_i0	PRJEB39269	86621	153	4.719298	7.22052594	Nostoc	1177	Bacteria	Bacteria	143	7.23e-30	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g86216	i0	83.929	14.1437908496732	168	8	97	7	1	149	3206304	3206471	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	2164	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
1331402	1331402	PRJEB39269_P_NODE_91362_length_150_cov_1.477477_g90957_i0	PRJEB39269	91362	150	1.477477	2.2162155	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	261	1.86e-65	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g90957	i0	98	12.6266666666667	150	3	100	0	1	150	2150594	2150445	Leptolyngbya sp. 7M chromosome	blastn	1894	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
2606977	2606977	PRJEB39269_P_NODE_37163_length_226_cov_1.491979_g36758_i0	PRJEB39269	37163	226	1.491979	3.37187254	Phormidium nigroviride	482564	Bacteria	Bacteria	399	6.239999999999999e-107	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g36758	i0	98.667	137.938053097345	225	3	99	0	1	225	206	430	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	31174	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3539750	3539750	PRJEB39269_P_NODE_13223_length_385_cov_11.164740_g12818_i0	PRJEB39269	13223	385	11.16474	42.984249	Nostoc	1177	Bacteria	Bacteria	501	3.039999999999999e-137	NTclustered	gi\|312985538\|gb\|HQ189049.1\|	1211	g12818	i0	90.206	78.9844155844156	388	32	100	6	1	385	499	883	Uncultured cyanobacterium clone B108210C 16S ribosomal RNA gene, partial sequence	blastn	30409	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6092362	6092362	PRJEB39269_P_NODE_6745_length_525_cov_3.878601_g6361_i0	PRJEB39269	6745	525	3.878601	20.36265525	Oscillatoriales	1150	Bacteria	Bacteria	856	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g6361	i0	96.381	155.11619047619	525	10	100	5	1	525	2241	2756	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	81436	861	0.994192799070848	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8984190	8984190	PRJEB39269_P_NODE_83128_length_156_cov_2.726496_g82723_i0	PRJEB39269	83128	156	2.726496	4.25333376	Nostoc sphaeroides	446679	Bacteria	Bacteria	132	1.6e-26	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g82723	i0	96.25	3.91666666666667	80	3	51	0	1	80	4737194	4737115	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	611	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
10259835	10259835	PRJEB39269_P_NODE_56929_length_182_cov_11.727273_g56524_i0	PRJEB39269	56929	182	11.727273	21.34363686	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g56524	i0	100	0.153846153846154	28	0	15	0	74	101	1687046	1687073	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
12810565	12810565	PRJEB39269_P_NODE_20831_length_307_cov_3.776119_g20426_i0	PRJEB39269	20831	307	3.776119	11.59268533	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	425	1.47e-114	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g20426	i0	91.64	212.436482084691	311	20	100	5	1	307	2054604	2054912	Leptolyngbya sp. 7M chromosome	blastn	65218	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
14085361	14085361	PRJEB39269_P_NODE_59832_length_178_cov_2.273381_g59427_i0	PRJEB39269	59832	178	2.273381	4.04661818	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	285	1.3599999999999998e-72	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g59427	i0	95.531	186.550561797753	179	7	100	1	1	178	2152357	2152179	Leptolyngbya sp. 7M chromosome	blastn	33206	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
16291914	16291914	PRJEB39269_P_NODE_37873_length_223_cov_9.630435_g37468_i0	PRJEB39269	37873	223	9.630435	21.47587005	Nostoc	1177	Bacteria	Bacteria	405	1.32e-108	NTclustered	gi\|470483128\|ref\|NR_076575.1\|	63737	g37468	i0	99.55	262.313901345291	222	1	99	0	1	222	324	545	Nostoc punctiforme PCC 73102 strain PCC 73102 23S ribosomal RNA gene, complete sequence	blastn	58496	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
18840936	18840936	PRJEB39269_P_NODE_52055_length_190_cov_2.516556_g51650_i0	PRJEB39269	52055	190	2.516556	4.7814564	Nostoc	1177	Bacteria	Bacteria	333	5.209999999999999e-87	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g51650	i0	98.413	177.568421052632	189	3	99	0	2	190	5293239	5293051	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	33738	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
23009111	23009111	PRJEB39269_P_NODE_57739_length_181_cov_2.288732_g57334_i0	PRJEB39269	57739	181	2.288732	4.14260492	Oscillatoria sp. 2.1A	2876722	Bacteria	Bacteria	318	1.37e-82	NTclustered	gi\|2095813707\|gb\|OK161270.1\|	2876722	g57334	i0	98.343	110.28729281768	181	3	100	0	1	181	3469	3649	Oscillatoria sp. 2.1A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	19962	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. 2.1A
25215339	25215339	PRJEB39269_P_NODE_22200_length_297_cov_8.472868_g21795_i0	PRJEB39269	22200	297	8.472868	25.16441796	Nostoc	1177	Bacteria	Bacteria	521	1.7499999999999996e-143	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g21795	i0	98.316	300.545454545455	297	5	100	0	1	297	56571	56867	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	89262	521	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides

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