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

16 rows where analysis = "blastn", bioproject = "PRJEB10140" 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
2562672	2562672	PRJEB10140_P_NODE_275383_length_164_cov_0.904348_g258074_i0	PRJEB10140	275383	164	0.904348	1.48313072	Microcoleus vaginatus	119532	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g258074	i0	99.39	5.97560975609756	164	1	100	0	1	164	3106478	3106315	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	980	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
3837638	3837638	PRJEB10140_P_NODE_108584_length_336_cov_2.135889_g91280_i0	PRJEB10140	108584	336	2.135889	7.17658704	Okeanomitos corallinicola	3231550	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2715117499\|gb\|CP150886.1\|	3133117	g91280	i0	100	0.172619047619048	30	0	9	0	205	234	4879110	4879081	Okeanomitos corallinicola TIOX110 chromosome, complete genome	blastn	58	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Okeanomitos	Okeanomitos corallinicola
3838837	3838837	PRJEB10140_P_NODE_266264_length_166_cov_0.863248_g248955_i0	PRJEB10140	266264	166	0.863248	1.43299168	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	134	4.83e-27	NTclustered	gi\|2851645142\|gb\|CP137338.1\|	3082949	g248955	i0	84.058	8.64457831325301	138	22	83	0	5	142	1031453	1031316	Altericista sp. CCNU0014 chromosome, complete genome	blastn	1435	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
8938489	8938489	PRJEB10140_P_NODE_123288_length_297_cov_1.500000_g105981_i0	PRJEB10140	123288	297	1.5	4.455	Planktothrix agardhii	1160	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2261138921\|emb\|LR882934.1\|	1160	g105981	i0	100	0.188552188552189	28	0	9	0	4	31	1548867	1548894	Planktothrix agardhii strain NIVA-CYA126/8 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
9910288	9910288	PRJEB10140_P_NODE_190108_length_203_cov_1.623377_g172799_i0	PRJEB10140	190108	203	1.623377	3.29545531	Nodularia	159191	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g172799	i0	100	0.300492610837438	29	0	14	0	95	123	5247058	5247086	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	61	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
10215975	10215975	PRJEB10140_P_NODE_48669_length_747_cov_1.733524_g33064_i0	PRJEB10140	48669	747	1.733524	12.94942428	Pseudanabaena galeata	1112103	Bacteria	Bacteria	56.5	0.006	NTclustered	gi\|2498984945\|gb\|CP112876.1\|	2602720	g33064	i0	96.97	0.0441767068273092	33	1	4	0	673	705	138928	138960	Pseudanabaena galeata CCNP1313 plasmid pPg_02, complete sequence	blastn	33	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena galeata
12765112	12765112	PRJEB10140_P_NODE_128351_length_286_cov_1.156118_g111044_i0	PRJEB10140	128351	286	1.156118	3.30649748	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g111044	i0	97.059	0.118881118881119	34	0	12	1	178	210	4071273	4071306	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	34	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
13735737	13735737	PRJEB10140_P_NODE_259531_length_167_cov_0.872881_g242222_i0	PRJEB10140	259531	167	0.872881	1.45771127	root	1	Root_unresolved	Root_unresolved	71.3	3.87e-8	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g242222	i0	93.75	23.0958083832335	48	1	29	2	81	128	1483374	1483419	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	3857	71.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
14041231	14041231	PRJEB10140_P_NODE_43292_length_832_cov_4.619413_g28486_i0	PRJEB10140	43292	832	4.619413	38.43351616	Annamia dubia	2815909	Bacteria	Bacteria	54.7	0.023	NTclustered	gi\|2663421582\|dbj\|AP025630.1\|	2759045	g28486	i0	100	0.0348557692307692	29	0	3	0	582	610	3592848	3592820	Annamia dubia NIES-4383 DNA, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
16590289	16590289	PRJEB10140_P_NODE_86954_length_421_cov_2.180108_g69677_i0	PRJEB10140	86954	421	2.180108	9.17825468	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|427977893\|gb\|CP003590.1\|	118163	g69677	i0	100	0.0688836104513064	29	0	7	0	181	209	471779	471751	Pleurocapsa sp. PCC 7327, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
17864346	17864346	PRJEB10140_P_NODE_258395_length_167_cov_0.881356_g241086_i0	PRJEB10140	258395	167	0.881356	1.47186452	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g241086	i0	100	6.98203592814371	167	0	100	0	1	167	4246710	4246544	Gloeocapsa sp. PCC 7428, complete genome	blastn	1166	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
22963541	22963541	PRJEB10140_P_NODE_146299_length_253_cov_1.225490_g128991_i0	PRJEB10140	146299	253	1.22549	3.1004897	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	435	1.95e-117	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g128991	i0	98.008	147.332015810277	251	3	99	2	1	250	250	1	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37275	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22964512	22964512	PRJEB10140_P_NODE_264099_length_166_cov_0.888889_g246790_i0	PRJEB10140	264099	166	0.888889	1.47555574	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	191	2.82e-44	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g246790	i0	87.952	42.289156626506	166	14	99	5	1	164	6631712	6631551	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	7020	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
22965348	22965348	PRJEB10140_P_NODE_98659_length_371_cov_1.857143_g81362_i0	PRJEB10140	98659	371	1.857143	6.89000053	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g81362	i0	100	0.078167115902965	29	0	8	0	196	224	5709043	5709071	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
23934708	23934708	PRJEB10140_P_NODE_264959_length_166_cov_0.888889_g247650_i0	PRJEB10140	264959	166	0.888889	1.47555574	Oscillatoriales	1150	Bacteria	Bacteria	279	5.86e-71	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g247650	i0	96.988	22.4277108433735	166	5	100	0	1	166	1265939	1265774	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	3723	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
24238353	24238353	PRJEB10140_P_NODE_250400_length_168_cov_0.873950_g233091_i0	PRJEB10140	250400	168	0.87395	1.468236	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	211	2.2e-50	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g233091	i0	89.286	3.54166666666667	168	18	100	0	1	168	4119375	4119542	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	595	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus

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