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

14 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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
200498	200498	PRJNA1095825_P_NODE_226541_length_257_cov_2.027174_g223478_i0	PRJNA1095825	226541	257	2.027174	5.20983718	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	420	5.56e-113	NTclustered	gi\|225696189\|gb\|FJ805856.1\|	259957	g223478	i0	96.109	144.357976653697	257	10	100	0	1	257	3424	3168	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	37100	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1475481	1475481	PRJNA1095825_P_NODE_260702_length_247_cov_0.885057_g257639_i0	PRJNA1095825	260702	247	0.885057	2.18609079	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	287	5.62e-73	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g257639	i0	88.017	1.9595141700404901	242	29	98	0	4	245	5463363	5463122	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	484	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
2294788	2294788	PRJNA1095825_P_NODE_169042_length_300_cov_1.506608_g165979_i0	PRJNA1095825	169042	300	1.506608	4.519824	Nostoc	1177	Bacteria	Bacteria	394	4.03e-105	NTclustered	gi\|1345606787\|gb\|MG968521.1\|	2081948	g165979	i0	94.51	199.42	255	14	85	0	46	300	521	267	Nostoc punctiforme UTEX B 1629 23S ribosomal RNA gene, partial sequence	blastn	59826	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
3569965	3569965	PRJNA1095825_P_NODE_196623_length_279_cov_1.208738_g193560_i0	PRJNA1095825	196623	279	1.208738	3.37237902	Oscillatoriales	1150	Bacteria	Bacteria	459	1.3000000000000002e-124	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g193560	i0	96.403	119.455197132616	278	10	99	0	2	279	2333	2056	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	33328	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4026642	4026642	PRJNA1095825_P_NODE_171084_length_298_cov_3.306667_g168021_i0	PRJNA1095825	171084	298	3.306667	9.85386766	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	494	3.83e-135	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g168021	i0	96.644	112.963087248322	298	9	100	1	1	298	2495	2791	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	33663	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5303659	5303659	PRJNA1095825_P_NODE_250705_length_249_cov_0.875000_g247642_i0	PRJNA1095825	250705	249	0.875	2.17875	uncultured cyanobacterium	1211	Bacteria	Bacteria	259	1.24e-64	NTclustered	gi\|2874254044\|emb\|OY970368.1\|	1211	g247642	i0	85.887	0.995983935742972	248	30	99	5	4	249	2139787	2139543	MAG: uncultured cyanobacterium isolate MFD04716.bin.1.71 genome assembly, chromosome: 1	blastn	248	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6579191	6579191	PRJNA1095825_P_NODE_295946_length_241_cov_0.916667_g292883_i0	PRJNA1095825	295946	241	0.916667	2.20916747	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	383	6.77e-102	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g292883	i0	95.455	271.726141078838	242	8	100	3	1	241	1858625	1858864	Calothrix sp. PCC 7716 DNA, complete genome	blastn	65486	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
7397367	7397367	PRJNA1095825_P_NODE_265086_length_246_cov_0.890173_g262023_i0	PRJNA1095825	265086	246	0.890173	2.18982558	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	91.6	4.71e-14	NTclustered	gi\|583826815\|emb\|HG917243.1\|	1211	g262023	i0	89.041	2.27642276422764	73	8	30	0	119	191	226	298	Uncultured cyanobacterium partial 16S rRNA gene, clone R172	blastn	560	91.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12498466	12498466	PRJNA1095825_P_NODE_298050_length_241_cov_0.857143_g294987_i0	PRJNA1095825	298050	241	0.857143	2.06571463	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2261183531\|emb\|LR882963.1\|	1160	g294987	i0	100	7.8298755186722	30	0	12	0	1	30	2542945	2542974	Planktothrix agardhii strain No.66 genome assembly, chromosome: I	blastn	1887	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
15502862	15502862	PRJNA1095825_P_NODE_188733_length_285_cov_1.066038_g185670_i0	PRJNA1095825	188733	285	1.066038	3.0382083	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	477	3.669999999999999e-130	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g185670	i0	96.842	249.908771929825	285	9	100	0	1	285	1859304	1859020	Calothrix sp. PCC 7716 DNA, complete genome	blastn	71224	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
19326732	19326732	PRJNA1095825_P_NODE_268036_length_246_cov_0.890173_g264973_i0	PRJNA1095825	268036	246	0.890173	2.18982558	Cyanobacterium aponinum	379064	Bacteria	Bacteria	111	3.61e-20	NTclustered	gi\|2645842025\|gb\|CP141255.1\|	3088145	g264973	i0	86.869	1.53658536585366	99	13	59	0	142	240	521071	520973	Cyanobacterium aponinum UTEX 3222 chromosome, complete genome	blastn	378	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium aponinum
21421428	21421428	PRJNA1095825_P_NODE_164957_length_304_cov_1.329004_g161894_i0	PRJNA1095825	164957	304	1.329004	4.04017216	Microcoleus	44471	Bacteria	Bacteria	551	2.289999999999999e-152	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g161894	i0	99.342	176.996710526316	304	2	100	0	1	304	132006	132309	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	53807	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
21421617	21421617	PRJNA1095825_P_NODE_277397_length_244_cov_0.900585_g274334_i0	PRJNA1095825	277397	244	0.900585	2.1974274	Microcoleus	44471	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g274334	i0	95.902	8.97540983606557	244	10	100	0	1	244	2801145	2801388	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	2190	399	0.992481203007519	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
22696492	22696492	PRJNA1095825_P_NODE_267918_length_246_cov_0.890173_g264855_i0	PRJNA1095825	267918	246	0.890173	2.18982558	Hassallia	482629	Bacteria	Bacteria	383	6.94e-102	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g264855	i0	94.715	300.105691056911	246	13	100	0	1	246	2118	2363	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	73826	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea

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