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

24 rows where analysis = "blastn", bioproject = "PRJNA330616" 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
1664373	1664373	PRJNA330616_P_NODE_22622_length_178_cov_1.139535_g22213_i0	PRJNA330616	22622	178	1.139535	2.0283723	Halotia branconii	1620816	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g22213	i0	100	0.157303370786517	28	0	16	0	60	87	2752449	2752422	Halotia branconii CENA392 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
5493233	5493233	PRJNA330616_P_NODE_22625_length_178_cov_1.093023_g22216_i0	PRJNA330616	22625	178	1.093023	1.94558094	[Synechococcus] sp. NIES-970	1827144	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|1143527503\|dbj\|AP017959.1\|	1827144	g22216	i0	99.438	178.533707865169	178	1	100	0	1	178	1589055	1589232	Synechococcus sp. NIES-970 DNA, complete genome	blastn	31779	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Synechococcus] sp. NIES-970
5493240	5493240	PRJNA330616_P_NODE_2305_length_592_cov_3.222836_g1907_i0	PRJNA330616	2305	592	3.222836	19.07918912	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	372	3.96e-98	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g1907	i0	82.783	128.64527027027	424	65	71	7	3	422	1477812	1477393	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	76158	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
5493426	5493426	PRJNA330616_P_NODE_645_length_1225_cov_26.743197_g409_i0	PRJNA330616	645	1225	26.743197	327.60416325	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1797	0	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g409	i0	93.236	103.555918367347	1227	73	100	8	1	1225	2042	3260	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	126856	1797	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5493465	5493465	PRJNA330616_P_NODE_945_length_971_cov_28.945770_g660_i0	PRJNA330616	945	971	28.94577	281.0634267	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1550	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g660	i0	95.59	107.446961894954	975	30	100	10	1	971	2044	3009	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	104331	1550	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6767209	6767209	PRJNA330616_P_NODE_17146_length_202_cov_2.084967_g16737_i0	PRJNA330616	17146	202	2.084967	4.21163334	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	279	7.41e-71	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g16737	i0	93.158	194.118811881188	190	13	94	0	13	202	1476	1287	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	39212	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
6767447	6767447	PRJNA330616_P_NODE_32946_length_155_cov_2.858491_g32537_i0	PRJNA330616	32946	155	2.858491	4.43066105	Tildeniella torsiva	2303520	Bacteria	Bacteria	215	1.54e-51	NTclustered	gi\|2547515307\|gb\|OR288165.1\|	3062398	g32537	i0	93.151	209.832258064516	146	10	94	0	2	147	2128	1983	Tildeniella torsiva Vin-5-3-8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32524	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Tildeniella	Tildeniella torsiva
8043189	8043189	PRJNA330616_P_NODE_8887_length_278_cov_2.227074_g8478_i0	PRJNA330616	8887	278	2.227074	6.19126572	Limnospira platensis	118562	Bacteria	Bacteria	514	2.7199999999999996e-141	NTclustered	gi\|83777317\|gb\|DQ120927.1\|	357682	g8478	i0	100	1	278	0	100	0	1	278	376	99	Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds	blastn	278	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
10593569	10593569	PRJNA330616_P_NODE_6729_length_322_cov_2.047619_g6320_i0	PRJNA330616	6729	322	2.047619	6.59333318	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	464	3.28e-126	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g6320	i0	92.615	136.742236024845	325	20	100	3	1	322	1783	2106	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44031	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12547960	12547960	PRJNA330616_P_NODE_32650_length_160_cov_2.954955_g32241_i0	PRJNA330616	32650	160	2.954955	4.727928	Bacteria	2	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|386685926\|gb\|JQ612142.1\|	1211	g32241	i0	100	100.10625	160	0	100	0	1	160	524	365	Uncultured cyanobacterium clone MSmat.3.13 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	16017	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13143214	13143214	PRJNA330616_P_NODE_22071_length_180_cov_1.381679_g21662_i0	PRJNA330616	22071	180	1.381679	2.4870222	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	311	2.28e-80	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g21662	i0	97.778	18.6222222222222	180	4	100	0	1	180	1860668	1860489	Calothrix sp. PCC 6303, complete genome	blastn	3352	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
14418692	14418692	PRJNA330616_P_NODE_632_length_1239_cov_26.762185_g402_i0	PRJNA330616	632	1239	26.762185	331.58347215	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1762	0	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g402	i0	92.456	103.45197740113	1246	74	100	17	1	1239	1778	3010	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	128177	1762	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15692207	15692207	PRJNA330616_P_NODE_13713_length_224_cov_2.845714_g13304_i0	PRJNA330616	13713	224	2.845714	6.37439936	Microcoleus vaginatus	119532	Bacteria	Bacteria	414	2.1999999999999996e-111	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g13304	i0	100	95.2098214285714	224	0	100	0	1	224	101564	101341	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	21327	414	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
15692269	15692269	PRJNA330616_P_NODE_17713_length_199_cov_2.720000_g17304_i0	PRJNA330616	17713	199	2.72	5.4128	Plectolyngbya terrestris	3016457	Bacteria	Bacteria	339	1.18e-88	NTclustered	gi\|2106138546\|gb\|OK382086.1\|	2880694	g17304	i0	97.475	187.180904522613	198	5	99	0	1	198	2003	2200	Plectolyngbya terrestris FBCC-A1479 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37249	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya terrestris
15692306	15692306	PRJNA330616_P_NODE_19993_length_188_cov_3.071942_g19584_i0	PRJNA330616	19993	188	3.071942	5.77525096	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	287	4.06e-73	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g19584	i0	94.149	122.952127659574	188	11	100	0	1	188	2343	2156	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23115	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15692520	15692520	PRJNA330616_P_NODE_4333_length_409_cov_4.677778_g3925_i0	PRJNA330616	4333	409	4.677778	19.13211202	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	645	1.4199999999999994e-180	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g3925	i0	95.122	102.21760391198	410	19	100	1	1	409	4047	3638	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	41807	645	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16371904	16371904	PRJNA330616_P_NODE_19693_length_190_cov_1.276596_g19284_i0	PRJNA330616	19693	190	1.276596	2.4255324	root	1	Root_unresolved	Root_unresolved	351	1.4399999999999997e-92	NTclustered	gi\|321271924\|gb\|HQ419021.1\|	1211	g19284	i0	100	99.9473684210526	190	0	100	0	1	190	747	558	Uncultured cyanobacterium clone AL66_2CY_12 16S ribosomal RNA gene, partial sequence	blastn	18990	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
18241534	18241534	PRJNA330616_P_NODE_9595_length_268_cov_1.433790_g9186_i0	PRJNA330616	9595	268	1.43379	3.8425572	Gloeobacter violaceus	33072	Bacteria	Bacteria	226	1.37e-54	NTclustered	gi\|46409892\|gb\|AY584517.1\|	251221	g9186	i0	82.482	425.955223880597	274	33	100	12	1	268	415	679	Gloeobacter violaceus PCC 7421 23S ribosomal RNA gene, partial sequence	blastn	114156	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
19515712	19515712	PRJNA330616_P_NODE_496_length_1393_cov_33.956101_g304_i0	PRJNA330616	496	1393	33.956101	473.00848693	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2013	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g304	i0	92.77	127.653984206748	1397	93	99	7	1	1391	3027	1633	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	177822	2013	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20791006	20791006	PRJNA330616_P_NODE_12257_length_236_cov_1.593583_g11848_i0	PRJNA330616	12257	236	1.593583	3.76085588	Spirirestis rafaelensis	293980	Bacteria	Bacteria	320	5.26e-83	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g11848	i0	91.102	182.580508474576	236	21	100	0	1	236	419	654	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	43089	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
20791095	20791095	PRJNA330616_P_NODE_17977_length_198_cov_1.436242_g17568_i0	PRJNA330616	17977	198	1.436242	2.84375916	uncultured Antarctic cyanobacterium	216601	Bacteria	Bacteria	333	5.469999999999998e-87	NTclustered	gi\|158712078\|gb\|EU032394.1\|	216601	g17568	i0	96.97	82.8080808080808	198	6	100	0	1	198	832	635	Uncultured Antarctic cyanobacterium clone N184-7 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	16396	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured Antarctic cyanobacterium
20791320	20791320	PRJNA330616_P_NODE_497_length_1393_cov_25.258185_g305_i0	PRJNA330616	497	1393	25.258185	351.84651705	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2104	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g305	i0	93.92	103.329504666188	1398	78	100	6	1	1393	3027	1632	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	143938	2104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22746215	22746215	PRJNA330616_P_NODE_1938_length_647_cov_23.210702_g1557_i0	PRJNA330616	1938	647	23.210702	150.17324194	Cyanophyceae	3028117	Bacteria	Bacteria	798	0	NTclustered	gi\|225696189\|gb\|FJ805856.1\|	259957	g1557	i0	93.68	125.836166924266	538	26	83	6	112	646	3015	2483	Uncultured Chroococcidiopsis sp. clone AR2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	81416	798	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24615669	24615669	PRJNA330616_P_NODE_1480_length_760_cov_1.978903_g1129_i0	PRJNA330616	1480	760	1.978903	15.0396628	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	935	0	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g1129	i0	95.262	163.452631578947	591	26	78	1	172	760	1246009	1245419	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	124224	935	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755

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