metadata: contig_metadata: 19 rows where bioproject = "PRJNA1129273" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where bioproject = "PRJNA1129273" 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
2833901	2833901	PRJNA1129273_P_NODE_10603_length_242_cov_0.911243_g10323_i0	PRJNA1129273	10603	242	0.911243	2.20520806	Phormidium nigroviride	482564	Bacteria	Bacteria	405	1.45e-108	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g10323	i0	97.083	4.55785123966942	240	7	99	0	2	241	4398135	4398374	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1103	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3582167	3582167	PRJNA1129273_P_NODE_10023_length_244_cov_1.807018_g9743_i0	PRJNA1129273	10023	244	1.807018	4.40912392	Nostoc	1177	Bacteria	Bacteria	350	6.969999999999998e-92	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g9743	i0	92.623	2.99590163934426	244	17	99	1	2	244	5889113	5888870	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	731	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
5386420	5386420	PRJNA1129273_P_NODE_10005_length_244_cov_2.374269_g9725_i0	PRJNA1129273	10005	244	2.374269	5.79321636	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	387	5.31e-103	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g9725	i0	95.455	6.19672131147541	242	11	99	0	2	243	6206586	6206827	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	1512	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
6661134	6661134	PRJNA1129273_P_NODE_646_length_1101_cov_10.027237_g194_i1	PRJNA1129273	646	1101	10.027237	110.39987937	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1592	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g194	i1	92.831	106.465031789282	1102	74	99	4	2	1100	1633	2732	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	117218	1592	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7409576	7409576	PRJNA1129273_P_NODE_5386_length_305_cov_1.517241_g5106_i0	PRJNA1129273	5386	305	1.517241	4.62758505	Microcystis	1125	Bacteria	Bacteria	211	4.43e-50	NTclustered	gi\|1861038541\|dbj\|LC557454.1\|	1126	g5106	i0	79.672	135.714754098361	305	53	100	6	1	305	691	986	Microcystis aeruginosa NIES-1062 gene for 23S rRNA, partial sequence	blastn	41393	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
8684746	8684746	PRJNA1129273_P_NODE_3527_length_390_cov_2.274448_g3247_i0	PRJNA1129273	3527	390	2.274448	8.8703472	Hassallia	482629	Bacteria	Bacteria	617	2.9299999999999997e-172	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g3247	i0	95.361	307.569230769231	388	18	99	0	2	389	2356	1969	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	119952	617	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
11761895	11761895	PRJNA1129273_P_NODE_8370_length_253_cov_2.627778_g8090_i0	PRJNA1129273	8370	253	2.627778	6.64827834	Microcoleus sp. PCC 8701	272133	Bacteria	Bacteria	267	7.529999999999999e-67	NTclustered	gi\|46409899\|gb\|AY584524.1\|	272133	g8090	i0	88.106	139.391304347826	227	23	89	4	1	225	862	1086	Microcoleus sp. PCC 8701 23S ribosomal RNA gene, partial sequence	blastn	35266	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PCC 8701
13036991	13036991	PRJNA1129273_P_NODE_7851_length_260_cov_2.588235_g7571_i0	PRJNA1129273	7851	260	2.588235	6.729411	Pleurocapsa concharum	980867	Bacteria	Bacteria	477	3.3e-130	NTclustered	gi\|322504116\|emb\|FR798927.1\|	980868	g7571	i0	100	101.880769230769	258	0	99	0	2	259	847	590	Pleurocapsa concharum VP3-02 partial 16S rRNA gene, strain VP3-02	blastn	26489	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa concharum
13784997	13784997	PRJNA1129273_P_NODE_10751_length_239_cov_2.765060_g10471_i0	PRJNA1129273	10751	239	2.76506	6.6084934	Hassallia	482629	Bacteria	Bacteria	363	8.74e-96	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g10471	i0	97.209	257.928870292887	215	5	90	1	24	238	2229	2442	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	61645	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
13785003	13785003	PRJNA1129273_P_NODE_291_length_1599_cov_11.199214_g194_i0	PRJNA1129273	291	1599	11.199214	179.07543186	Chroococcidiopsis	54298	Bacteria	Bacteria	2115	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g194	i0	90.841	103.249530956848	1594	124	99	17	2	1586	795691	794111	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	165096	2128	0.993890977443609	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
14312247	14312247	PRJNA1129273_P_NODE_9872_length_245_cov_0.901163_g9592_i0	PRJNA1129273	9872	245	0.901163	2.20784935	Aliterella atlantica	1827278	Bacteria	Bacteria	142	2.88e-40	NR	WP_045052785.1	1827278	g9592	i0	88.9	0.991836734693878	81	9	99.2	0	243	1	143	223	WP_045052785.1 ATP-dependent Clp protease proteolytic subunit [Aliterella atlantica]	diamond	243	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
15059361	15059361	PRJNA1129273_P_NODE_1372_length_716_cov_2.279938_g1116_i0	PRJNA1129273	1372	716	2.279938	16.32435608	Nostocales	1161	Bacteria	Bacteria	1179	0	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g1116	i0	96.508	297.719273743017	716	20	99	5	3	716	1915827	1916539	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	213167	1190	0.990756302521008	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
15586218	15586218	PRJNA1129273_P_NODE_9653_length_246_cov_1.098266_g9373_i0	PRJNA1129273	9653	246	1.098266	2.70173436	Nostoc flagelliforme	1306274	Bacteria	Bacteria	431	2.4399999999999992e-116	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g9373	i0	98.367	259.349593495935	245	4	99	0	1	245	30604	30848	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	63800	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
18135042	18135042	PRJNA1129273_P_NODE_7795_length_261_cov_1.643617_g7515_i0	PRJNA1129273	7795	261	1.643617	4.28984037	Phormidium nigroviride	482564	Bacteria	Bacteria	257	4.7e-64	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g7515	i0	89.048	1.72030651340996	210	20	80	1	52	261	3776413	3776207	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	449	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
21433566	21433566	PRJNA1129273_P_NODE_3157_length_418_cov_3.217391_g2878_i0	PRJNA1129273	3157	418	3.217391	13.44869438	Calothrix	1186	Bacteria	Bacteria	640	6.749999999999999e-179	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g2878	i0	94.272	211.117224880383	419	22	99	1	1	417	4990252	4989834	Calothrix sp. PCC 6303, complete genome	blastn	88247	643	0.995334370139969	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
23235563	23235563	PRJNA1129273_P_NODE_11179_length_226_cov_4.568627_g10899_i0	PRJNA1129273	11179	226	4.568627	10.32509702	Spirirestis rafaelensis	293980	Bacteria	Bacteria	399	6.239999999999999e-107	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g10899	i0	98.667	168.641592920354	225	3	99	0	1	225	611	387	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	38113	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
23235581	23235581	PRJNA1129273_P_NODE_4159_length_353_cov_1.103571_g3879_i0	PRJNA1129273	4159	353	1.103571	3.89560563	Microcoleus vaginatus	119532	Bacteria	Bacteria	494	4.61e-135	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g3879	i0	92.045	4.94050991501416	352	26	99	1	2	353	5013326	5013675	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1744	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
28460108	28460108	PRJNA1129273_P_NODE_426_length_1355_cov_3.113105_g292_i0	PRJNA1129273	426	1355	3.113105	42.18257275	Nostoc cycadae	246795	Bacteria	Bacteria	79.3	1.32e-12	NR	WP_245894956.1	246795	g292	i0	33.3	0.832472324723247	195	111	40.5	6	1328	780	50	237	WP_245894956.1 CAP domain-containing protein [Nostoc cycadae]	diamond	1128	79.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc cycadae
30891974	30891974	PRJNA1129273_P_NODE_6214_length_285_cov_2.155660_g5934_i0	PRJNA1129273	6214	285	2.15566	6.143631	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	167	1.04e-45	NR	WP_009633886.1	927677	g5934	i0	86.2	2.96842105263158	94	13	98.9	0	3	284	327	420	WP_009633886.1 eIF2A-related protein [Synechocystis sp. PCC 7509]	diamond	846	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509

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