metadata: contig_metadata: 18 rows where bioproject = "PRJNA1248424", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

18 rows where bioproject = "PRJNA1248424", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_kingdom = "Bacillati"

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
1627698	1627698	PRJNA1248424_P_NODE_58502_length_279_cov_2.325243_g52434_i0	PRJNA1248424	58502	279	2.325243	6.48742797	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g52434	i0	100	0.204301075268817	29	0	10	0	247	275	3686208	3686236	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	57	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
2327250	2327250	PRJNA1248424_P_NODE_52742_length_296_cov_1.251121_g46674_i0	PRJNA1248424	52742	296	1.251121	3.70331816	Nostoc	1177	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g46674	i0	100	0.189189189189189	28	0	9	0	217	244	4156477	4156504	Nostoc sp. NIES-3756 DNA, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
5456547	5456547	PRJNA1248424_P_NODE_68225_length_253_cov_1.161111_g62156_i0	PRJNA1248424	68225	253	1.161111	2.93761083	Microcoleus vaginatus	119532	Bacteria	Bacteria	300	7.43e-77	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g62156	i0	88.189	4.90909090909091	254	26	99	4	2	253	4415518	4415267	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1242	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
8006109	8006109	PRJNA1248424_P_NODE_47687_length_322_cov_2.349398_g41620_i0	PRJNA1248424	47687	322	2.349398	7.56506156	Moorena producens 3L	489825	Bacteria	Bacteria	84	7.78e-18	NR	EGJ32297.1	489825	g41620	i0	95	0.745341614906832	40	2	37.3	0	320	201	122	161	EGJ32297.1 carbon dioxide concentrating mechanism/carboxysome shell protein [Moorena producens 3L]	diamond	240	84	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
10557318	10557318	PRJNA1248424_P_NODE_69469_length_251_cov_0.865169_g63400_i0	PRJNA1248424	69469	251	0.865169	2.17157419	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	272	1.6e-68	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g63400	i0	89.72	120.892430278884	214	20	85	2	4	216	3681304	3681092	Leptolyngbya sp. 7M chromosome	blastn	30344	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
14382239	14382239	PRJNA1248424_P_NODE_64732_length_262_cov_2.534392_g58663_i0	PRJNA1248424	64732	262	2.534392	6.64010704	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	65.8	3.07e-6	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g58663	i0	93.333	2.12595419847328	45	1	17	2	218	262	7141396	7141438	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	557	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
16929920	16929920	PRJNA1248424_P_NODE_43854_length_344_cov_2.557196_g37791_i0	PRJNA1248424	43854	344	2.557196	8.79675424	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g37791	i0	100	0.0813953488372093	28	0	8	0	227	254	804753	804726	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23305682	23305682	PRJNA1248424_P_NODE_77199_length_244_cov_0.900585_g71130_i0	PRJNA1248424	77199	244	0.900585	2.1974274	Trichodesmium erythraeum	1206	Bacteria	Bacteria	71.3	6.08e-8	NTclustered	gi\|110164990\|gb\|CP000393.1\|	203124	g71130	i0	100	0.307377049180328	38	0	16	0	93	130	7378766	7378729	Trichodesmium erythraeum IMS101, complete genome	blastn	75	71.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium erythraeum
28052678	28052678	PRJNA1248424_P_NODE_72705_length_248_cov_0.880000_g66636_i0	PRJNA1248424	72705	248	0.88	2.1824	Nostoc sp. NMS7	2815391	Bacteria	Bacteria	145	4.16e-38	NR	WP_292796573.1	2815391	g66636	i0	78	0.991935483870968	82	18	99.2	0	246	1	158	239	WP_292796573.1 SNF2-related protein [Nostoc sp. NMS7]	diamond	246	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NMS7
28841945	28841945	PRJNA1248424_P_NODE_28088_length_558_cov_1.247423_g22077_i0	PRJNA1248424	28088	558	1.247423	6.96062034	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	46.6	0.0263	NR	MEL7522491.1	3023125	g22077	i0	37.7	0.327956989247312	61	37	32.3	1	402	223	313	373	MEL7522491.1 ribonuclease H family protein [Cyanobacteria bacterium J06553_1]	diamond	183	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
29315690	29315690	PRJNA1248424_P_NODE_46889_length_325_cov_2.166667_g40822_i0	PRJNA1248424	46889	325	2.166667	7.04166775	Microcystis sp. 53602_E8	2904984	Bacteria	Bacteria	63.9	3.49e-9	NR	MCE2664493.1	2904984	g40822	i0	54.2	0.443076923076923	48	22	44.3	0	182	39	744	791	MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8]	diamond	144	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. 53602_E8
29536723	29536723	PRJNA1248424_P_NODE_58690_length_279_cov_1.325243_g52622_i0	PRJNA1248424	58690	279	1.325243	3.69742797	Kaiparowitsia implicata	2303525	Bacteria	Bacteria	43.1	0.0397	NR	MBW4655476.1	2057771	g52622	i0	27.5	0.860215053763441	80	56	86	1	12	251	88	165	MBW4655476.1 amino acid ABC transporter permease [Kaiparowitsia implicata GSE-PSE-MK54-09C]	diamond	240	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Kaiparowitsia	Kaiparowitsia implicata
29725857	29725857	PRJNA1248424_P_NODE_15450_length_1193_cov_1.629464_g10875_i0	PRJNA1248424	15450	1193	1.629464	19.43950552	Microcystis sp. 53602_E8	2904984	Bacteria	Bacteria	49.7	0.0248	NR	MCE2664493.1	2904984	g10875	i0	41.7	0.12070410729254	48	28	12.1	0	794	651	754	801	MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8]	diamond	144	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. 53602_E8
31369420	31369420	PRJNA1248424_P_NODE_45356_length_334_cov_2.191571_g39292_i0	PRJNA1248424	45356	334	2.191571	7.31984714	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	63.9	3.89e-9	NR	MDJ0596593.1	3036786	g39292	i0	46	0.565868263473054	63	34	56.6	0	281	93	832	894	MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13]	diamond	189	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
31748626	31748626	PRJNA1248424_P_NODE_55297_length_287_cov_2.635514_g49229_i0	PRJNA1248424	55297	287	2.635514	7.56392518	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	62.8	5.73e-9	NR	HEY9742802.1	3081323	g49229	i0	86.7	0.313588850174216	30	4	31.4	0	287	198	342	371	HEY9742802.1 ATP-binding protein [Coleofasciculaceae cyanobacterium]	diamond	90	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
32033512	32033512	PRJNA1248424_P_NODE_65398_length_261_cov_1.122340_g59329_i0	PRJNA1248424	65398	261	1.12234	2.9293074	Coleofasciculus sp. FACHB-112	3100458	Bacteria	Bacteria	164	1.17e-44	NR	WP_190818153.1	2692783	g59329	i0	96.5	0.988505747126437	86	3	98.9	0	3	260	45	130	WP_190818153.1 glycerol-3-phosphate acyltransferase [Coleofasciculus sp. FACHB-1120]	diamond	258	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. FACHB-1120
32508332	32508332	PRJNA1248424_P_NODE_47879_length_322_cov_0.907631_g41812_i0	PRJNA1248424	47879	322	0.907631	2.92257182	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	64.3	2.56e-9	NR	MDJ0596593.1	3036786	g41812	i0	47	0.614906832298137	66	35	61.5	0	199	2	827	892	MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13]	diamond	198	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
32886029	32886029	PRJNA1248424_P_NODE_17820_length_1007_cov_1.926124_g12708_i0	PRJNA1248424	17820	1007	1.926124	19.39606868	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	159	3.78e-39	NR	MEL7520018.1	3023125	g12708	i0	38.7	1.35849056603774	230	135	67.3	2	321	998	695	922	MEL7520018.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	1368	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1

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