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

12 rows where analysis = "blastn", bioproject = "PRJNA667863" 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
634137	634137	PRJNA667863_P_NODE_3681_length_330_cov_1.902724_g3647_i0	PRJNA667863	3681	330	1.902724	6.2789892	uncultured Leptolyngbya sp.	332963	Bacteria	Bacteria	516	9.17e-142	NTclustered	gi\|254039365\|dbj\|AB512146.1\|	332963	g3647	i0	94.848	102.451515151515	330	17	100	0	1	330	443	114	Uncultured Leptolyngbya sp. gene for 16S rRNA, partial sequence, clone: UHM4	blastn	33809	516	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	uncultured Leptolyngbya sp.
634150	634150	PRJNA667863_P_NODE_4521_length_312_cov_1.288703_g4487_i0	PRJNA667863	4521	312	1.288703	4.02075336	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	433	8.92e-117	NTclustered	gi\|225696208\|gb\|FJ805875.1\|	259957	g4487	i0	91.693	149.852564102564	313	24	100	2	1	312	2040	2351	Uncultured Chroococcidiopsis sp. clone A2_17 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46754	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1910184	1910184	PRJNA667863_P_NODE_17882_length_233_cov_6.625000_g17848_i0	PRJNA667863	17882	233	6.625	15.43625	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	322	1.44e-83	NTclustered	gi\|225696251\|gb\|FJ805918.1\|	259957	g17848	i0	92.174	128.733905579399	230	14	97	3	7	233	2868	3096	Uncultured Chroococcidiopsis sp. clone A1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29995	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3715241	3715241	PRJNA667863_P_NODE_4283_length_316_cov_6.942387_g4249_i0	PRJNA667863	4283	316	6.942387	21.93794292	Trichocoleus	450526	Bacteria	Bacteria	342	1.5699999999999999e-89	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g4249	i0	86.52	177.123417721519	319	34	100	7	1	316	1752	1440	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	55971	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
12113181	12113181	PRJNA667863_P_NODE_110_length_1192_cov_6.857015_g94_i0	PRJNA667863	110	1192	6.857015	81.7356188	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1670	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g94	i0	91.987	143.203859060403	1198	84	100	11	1	1192	2831	1640	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	170699	1670	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12113264	12113264	PRJNA667863_P_NODE_17170_length_241_cov_0.916667_g17136_i0	PRJNA667863	17170	241	0.916667	2.20916747	Aphanizomenon flos-aquae	1176	Bacteria	Bacteria	58.4	4.66e-4	NTclustered	gi\|2004380816\|gb\|CP051528.1\|	2723857	g17136	i0	100	0.128630705394191	31	0	13	0	187	217	930270	930300	MAG: Aphanizomenon flos-aquae KM1D3_PB chromosome, complete genome	blastn	31	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
13387961	13387961	PRJNA667863_P_NODE_13171_length_247_cov_4.655172_g13137_i0	PRJNA667863	13171	247	4.655172	11.49827484	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	281	2.62e-71	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g13137	i0	88.696	109.012145748988	230	26	93	0	7	236	3681191	3681420	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	26926	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13388081	13388081	PRJNA667863_P_NODE_4891_length_304_cov_10.692641_g4857_i0	PRJNA667863	4891	304	10.692641	32.50562864	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	562	1.06e-155	NTclustered	gi\|745734142\|gb\|KM458348.1\|	183215	g4857	i0	100	100.240131578947	304	0	100	0	1	304	329	26	Uncultured Pleurocapsales cyanobacterium isolate OTU 00075 23S ribosomal RNA gene, partial sequence	blastn	30473	562	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
20289961	20289961	PRJNA667863_P_NODE_7276_length_276_cov_1.433498_g7242_i0	PRJNA667863	7276	276	1.433498	3.95645448	Leptolyngbya	47251	Bacteria	Bacteria	383	7.92e-102	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g7242	i0	91.667	196.253623188406	276	23	100	0	1	276	246871	247146	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	54166	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
21036419	21036419	PRJNA667863_P_NODE_14977_length_244_cov_1.988304_g14943_i0	PRJNA667863	14977	244	1.988304	4.85146176	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	327	3.27e-85	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g14943	i0	90.984	267.618852459016	244	20	99	2	2	244	1900	1658	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	65299	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21036587	21036587	PRJNA667863_P_NODE_8817_length_265_cov_1.317708_g8783_i0	PRJNA667863	8817	265	1.317708	3.4919262	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	171	6.41e-38	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g8783	i0	78.927	3.71320754716981	261	47	97	7	4	260	3443012	3442756	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	984	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
24860281	24860281	PRJNA667863_P_NODE_7840_length_272_cov_0.939698_g7806_i0	PRJNA667863	7840	272	0.939698	2.55597856	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	254	6.37e-63	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g7806	i0	83.704	0.992647058823529	270	42	99	2	1	269	5586766	5586498	Allocoleopsis franciscana PCC 7113, complete genome	blastn	270	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana

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