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

16 rows where analysis = "blastn", bioproject = "PRJNA599208" 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
572152	572152	PRJNA599208_P_NODE_11201_length_198_cov_2.850932_g11005_i0	PRJNA599208	11201	198	2.850932	5.64484536	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	289	1.1999999999999999e-73	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g11005	i0	92.965	124.136363636364	199	13	100	1	1	198	3177	2979	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24579	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
572222	572222	PRJNA599208_P_NODE_2301_length_596_cov_16.928444_g2125_i0	PRJNA599208	2301	596	16.928444	100.89352624	uncultured cyanobacterium	1211	Bacteria	Bacteria	734	0	NTclustered	gi\|2874253781\|emb\|OY969765.1\|	1211	g2125	i0	88.945	167.582214765101	597	63	99	3	1	595	2239553	2238958	MAG: uncultured cyanobacterium isolate MFD03250.bin.1.145 genome assembly, chromosome: 1	blastn	99879	734	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1141508	1141508	PRJNA599208_P_NODE_8701_length_239_cov_6.995050_g8505_i0	PRJNA599208	8701	239	6.99505	16.7181695	Nostocales	1161	Bacteria	Bacteria	324	4.1199999999999995e-84	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g8505	i0	90.947	197.313807531381	243	18	100	3	1	239	445	203	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	47158	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
3692916	3692916	PRJNA599208_P_NODE_15423_length_158_cov_2.504132_g15227_i0	PRJNA599208	15423	158	2.504132	3.95652856	Cyanophyceae	3028117	Bacteria	Bacteria	219	1.22e-52	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g15227	i0	93.793	123.449367088608	145	9	92	0	1	145	1244524	1244668	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	19505	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
4969624	4969624	PRJNA599208_P_NODE_8804_length_237_cov_7.010000_g8608_i0	PRJNA599208	8804	237	7.01	16.6137	Hassallia	482629	Bacteria	Bacteria	366	6.69e-97	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g8608	i0	94.515	269.666666666667	237	13	100	0	1	237	2416	2180	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	63911	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
6950506	6950506	PRJNA599208_P_NODE_406_length_1656_cov_71.232242_g252_i1	PRJNA599208	406	1656	71.232242	1179.60592752	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2255	0	NTclustered	gi\|225696175\|gb\|FJ805842.1\|	259957	g252	i1	92.385	144.7711352657	1589	112	96	7	73	1655	1521	3106	Uncultured Chroococcidiopsis sp. clone AU1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	239741	2255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9500765	9500765	PRJNA599208_P_NODE_8348_length_247_cov_24.719048_g8152_i0	PRJNA599208	8348	247	24.719048	61.05604856	Leptolyngbya sp. LEGE 07075	915308	Bacteria	Bacteria	433	6.82e-117	NTclustered	gi\|311502691\|gb\|HM217080.1\|	915308	g8152	i0	98.381	99.1781376518219	247	2	99	2	3	247	4	250	Leptolyngbya sp. LEGE 07075 16S ribosomal RNA gene, partial sequence	blastn	24497	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. LEGE 07075
10070024	10070024	PRJNA599208_P_NODE_14248_length_167_cov_2.969231_g14052_i0	PRJNA599208	14248	167	2.969231	4.95861577	Nostocaceae	1162	Bacteria	Bacteria	268	1.28e-67	NTclustered	gi\|428256439\|gb\|CP003642.1\|	56107	g14052	i0	97.468	91.622754491018	158	3	94	1	1	157	586374	586217	Cylindrospermum stagnale PCC 7417, complete genome	blastn	15301	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
10070035	10070035	PRJNA599208_P_NODE_15988_length_155_cov_1.101695_g15792_i0	PRJNA599208	15988	155	1.101695	1.70762725	Nodularia	159191	Bacteria	Bacteria	259	7e-65	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g15792	i0	96.774	255.212903225806	155	5	100	0	1	155	3673138	3673292	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	39558	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12620568	12620568	PRJNA599208_P_NODE_4470_length_390_cov_24.665722_g4276_i0	PRJNA599208	4470	390	24.665722	96.1963158	Nostocales	1161	Bacteria	Bacteria	281	4.37e-71	NTclustered	gi\|648713590\|gb\|KF934131.1\|	1494766	g4276	i0	88.066	102.069230769231	243	22	62	7	1	241	276	39	Hassallia sp. UB1-KK1 clone 1 leader 16S ribosomal RNA gene, partial sequence; 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39807	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
13326169	13326169	PRJNA599208_P_NODE_16031_length_154_cov_2.743590_g15835_i0	PRJNA599208	16031	154	2.74359	4.2251286	Nostoc sp. C117	3349875	Bacteria	Bacteria	148	1.57e-31	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g15835	i0	84.211	10.4415584415584	152	24	99	0	1	152	584065	583914	Nostoc sp. C117 chromosome, complete genome	blastn	1608	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
15169716	15169716	PRJNA599208_P_NODE_6112_length_310_cov_37.959707_g5916_i0	PRJNA599208	6112	310	37.959707	117.6750917	Oscillatoriales	1150	Bacteria	Bacteria	562	1.08e-155	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g5916	i0	99.355	140.741935483871	310	2	100	0	1	310	2139	2448	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43630	562	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17719390	17719390	PRJNA599208_P_NODE_9834_length_219_cov_1.175824_g9638_i0	PRJNA599208	9834	219	1.175824	2.57505456	root	1	Root_unresolved	Root_unresolved	399	6.009999999999999e-107	NTclustered	gi\|192337817\|gb\|EU751426.1\|	1211	g9638	i0	99.543	100.018264840183	219	1	100	0	1	219	479	697	Uncultured cyanobacterium clone HK04-B12 16S ribosomal RNA gene, partial sequence	blastn	21904	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
18992874	18992874	PRJNA599208_P_NODE_4035_length_417_cov_104.402632_g3841_i0	PRJNA599208	4035	417	104.402632	435.35897544	Nostocales	1161	Bacteria	Bacteria	632	1.1299999999999995e-176	NTclustered	gi\|29824074\|dbj\|AB093486.1\|	210999	g3841	i0	94.217	106.354916067146	415	22	99	2	1	414	302	715	Tolypothrix sp. IAM M-259 gene for 16S ribosomal RNA, partial sequence	blastn	44350	638	0.990595611285266	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. IAM M-259
19698778	19698778	PRJNA599208_P_NODE_5376_length_341_cov_6.467105_g5180_i0	PRJNA599208	5376	341	6.467105	22.05282805	Nostoc sp. C117	3349875	Bacteria	Bacteria	370	7.83e-98	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g5180	i0	86.377	100.161290322581	345	39	100	8	1	341	6456654	6456314	Nostoc sp. C117 chromosome, complete genome	blastn	34155	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
20974457	20974457	PRJNA599208_P_NODE_11457_length_195_cov_1.455696_g11261_i0	PRJNA599208	11457	195	1.455696	2.8386072	Gloeocapsa sp. UTEX B EE3	2094041	Bacteria	Bacteria	250	5.57e-62	NTclustered	gi\|1358126417\|gb\|KY963615.1\|	2094041	g11261	i0	89.744	76.1948717948718	195	20	100	0	1	195	570	764	Gloeocapsa sp. UTEX B EE3 23S ribosomal RNA gene, partial sequence	blastn	14858	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UTEX B EE3

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