metadata: contig_metadata: 20 rows where bioproject = "PRJNA1186363" and tax_clade = "Cyanobacteriota/Melainabacteria group"

20 rows where bioproject = "PRJNA1186363" 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
2870529	2870529	PRJNA1186363_P_NODE_26423_length_349_cov_1.268116_g25535_i0	PRJNA1186363	26423	349	1.268116	4.42572484	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	59.3	2.15e-9	NR	MBL8086392.1	2711154	g25535	i0	90	0.257879656160458	30	3	25.8	0	201	112	1	30	MBL8086392.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	90	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
11245291	11245291	PRJNA1186363_P_NODE_39509_length_251_cov_0.876404_g38621_i0	PRJNA1186363	39509	251	0.876404	2.19977404	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	157	5.52e-45	NR	WP_106369292.1	2107693	g38621	i0	86.7	0.99203187250996006	83	11	99.2	0	249	1	136	218	WP_106369292.1 beta-ketoacyl-ACP synthase III [Chlorogloea sp. CCALA 695]	diamond	249	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
14348724	14348724	PRJNA1186363_P_NODE_20332_length_419_cov_1.864162_g19444_i0	PRJNA1186363	20332	419	1.864162	7.81083878	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	58.2	1.18e-8	NR	MBL8086392.1	2711154	g19444	i0	90	0.214797136038186	30	3	21.5	0	214	125	1	30	MBL8086392.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	90	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
21443903	21443903	PRJNA1186363_P_NODE_10837_length_626_cov_79.216998_g9956_i0	PRJNA1186363	10837	626	79.216998	495.89840748	root	1	Root_unresolved	Root_unresolved	67.6	2.22e-6	NTclustered	gi\|1373819911\|dbj\|AP018318.1\|	196308	g9956	i0	93.333	5.73642172523962	45	3	7	0	377	421	5803672	5803716	Nostoc sp. HK-01 DNA, complete genome	blastn	3591	67.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. HK-01
27767516	27767516	PRJNA1186363_P_NODE_7024_length_800_cov_1.141678_g6234_i0	PRJNA1186363	7024	800	1.141678	9.133424	Myxosarcina sp. GI1	1541065	Bacteria	Bacteria	96.7	1.3e-19	NR	WP_052055755.1	1541065	g6234	i0	34.8	0.77625	207	105	75.8	7	16	621	18	199	WP_052055755.1 spherulation-specific family 4 protein [Myxosarcina sp. GI1]	diamond	621	96.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. GI1
28020054	28020054	PRJNA1186363_P_NODE_5565_length_903_cov_1.897590_g4582_i1	PRJNA1186363	5565	903	1.89759	17.1352377	Myxosarcina sp. GI1	1541065	Bacteria	Bacteria	158	1.2399999999999997e-42	NR	WP_052055755.1	1541065	g4582	i1	35.6	0.933554817275748	281	156	92.4	8	46	879	18	276	WP_052055755.1 spherulation-specific family 4 protein [Myxosarcina sp. GI1]	diamond	843	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. GI1
28020055	28020055	PRJNA1186363_P_NODE_5985_length_870_cov_3.276035_g5265_i0	PRJNA1186363	5985	870	3.276035	28.5015045	Leptolyngbyaceae cyanobacterium CSU_1_4	2720411	Bacteria	Bacteria	161	4.01e-44	NR	NJR39198.1	2720411	g5265	i0	36.1	2.76206896551724	252	138	85.2	7	775	35	34	267	NJR39198.1 Spherulation-specific family 4 [Leptolyngbyaceae cyanobacterium CSU_1_4]	diamond	2403	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium CSU_1_4
28272253	28272253	PRJNA1186363_P_NODE_28386_length_331_cov_0.906977_g27498_i0	PRJNA1186363	28386	331	0.906977	3.00209387	[Phormidium ambiguum] IAM M-71	454136	Bacteria	Bacteria	45.8	0.00828	NR	WP_218616874.1	454136	g27498	i0	30	0.725075528700906	80	53	71.6	2	60	296	283	360	WP_218616874.1 dynamin family protein [[Phormidium ambiguum] IAM M-71]	diamond	240	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Floridanema	[Phormidium ambiguum] IAM M-71
28714582	28714582	PRJNA1186363_P_NODE_42067_length_246_cov_0.895954_g41179_i0	PRJNA1186363	42067	246	0.895954	2.20404684	unclassified Nostoc	2593658	Bacteria	Bacteria	87	4.29e-18	NR	WP_190696167.1	2593658	g41179	i0	55.3	0.926829268292683	76	31	89	1	221	3	14	89	WP_190696167.1 MULTISPECIES: isopenicillin N synthase family dioxygenase [unclassified Nostoc]	diamond	228	87	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc
29125260	29125260	PRJNA1186363_P_NODE_34089_length_284_cov_0.848341_g33201_i0	PRJNA1186363	34089	284	0.848341	2.40928844	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	124	1.94e-33	NR	MBL8086323.1	2711154	g33201	i0	76.3	1.02464788732394	97	20	99.3	1	283	2	71	167	MBL8086323.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	291	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30376180	30376180	PRJNA1186363_P_NODE_38872_length_252_cov_0.871508_g37984_i0	PRJNA1186363	38872	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	80.5	1.08e-15	NR	WP_348230987.1	1481672	g37984	i0	55.1	5.60714285714286	78	32	92.9	2	3	236	225	299	WP_348230987.1 DUF6929 family protein [Trichocoleus desertorum]	diamond	1413	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
30546228	30546228	PRJNA1186363_P_NODE_30173_length_315_cov_1.289256_g29285_i0	PRJNA1186363	30173	315	1.289256	4.0611564	Symplocastrum torsivum	1552229	Bacteria	Bacteria	48.5	7.46e-4	NR	MBW4548882.1	450513	g29285	i0	34.6	2.23809523809524	78	48	74.3	1	280	47	6	80	MBW4548882.1 low temperature requirement protein A [Symplocastrum torsivum CPER-KK1]	diamond	705	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Symplocastrum	Symplocastrum torsivum
30830547	30830547	PRJNA1186363_P_NODE_38734_length_252_cov_1.307263_g37846_i0	PRJNA1186363	38734	252	1.307263	3.29430276	Prochlorococcus sp. ALOHA_A2.0_51	2919293	Bacteria	Bacteria	85.5	3.68e-17	NR	MCH2566828.1	2919293	g37846	i0	56.2	4.53571428571429	73	32	86.9	0	250	32	617	689	MCH2566828.1 reverse transcriptase family protein [Prochlorococcus sp. ALOHA_A2.0_51]	diamond	1143	85.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. ALOHA_A2.0_51
30830580	30830580	PRJNA1186363_P_NODE_9614_length_672_cov_2.098497_g8745_i0	PRJNA1186363	9614	672	2.098497	14.10189984	Desmonostoc muscorum	1179	Bacteria	Bacteria	217	2.04e-64	NR	MBX9253278.1	2756293	g8745	i0	50.2	1.96428571428571	221	108	98.7	1	6	668	1	219	MBX9253278.1 indoleacetamide hydrolase [Desmonostoc muscorum CCALA 125]	diamond	1320	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Desmonostoc	Desmonostoc muscorum
30849619	30849619	PRJNA1186363_P_NODE_14194_length_530_cov_2.849015_g13310_i0	PRJNA1186363	14194	530	2.849015	15.0997795	root	1	Root_unresolved	Root_unresolved	163	1.0199999999999999e-47	NR	MFH7242584.1	1157	g13310	i0	47.6	1.89622641509434	166	86	94	1	530	33	6	170	MFH7242584.1 hypothetical protein [Spirulina sp.]	diamond	1005	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp.
30925648	30925648	PRJNA1186363_P_NODE_5254_length_925_cov_2.153756_g4582_i0	PRJNA1186363	5254	925	2.153756	19.922243	Myxosarcina sp. GI1	1541065	Bacteria	Bacteria	159	7.679999999999999e-43	NR	WP_052055755.1	1541065	g4582	i0	35.9	0.911351351351351	281	155	90.2	8	858	25	18	276	WP_052055755.1 spherulation-specific family 4 protein [Myxosarcina sp. GI1]	diamond	843	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. GI1
31304571	31304571	PRJNA1186363_P_NODE_28795_length_327_cov_1.228346_g27907_i0	PRJNA1186363	28795	327	1.228346	4.01669142	Nostocaceae cyanobacterium	2723028	Bacteria	Bacteria	75.5	3.22e-13	NR	HLP88410.1	2723028	g27907	i0	37.9	0.944954128440367	103	61	94.5	2	18	326	728	827	HLP88410.1 hypothetical protein [Nostocaceae cyanobacterium]	diamond	309	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae		Nostocaceae cyanobacterium
31431117	31431117	PRJNA1186363_P_NODE_4476_length_994_cov_1.926167_g3865_i0	PRJNA1186363	4476	994	1.926167	19.14609998	Prochlorococcus sp. ALOHA_A2.0_51	2919293	Bacteria	Bacteria	97.1	4.51e-18	NR	MCH2566828.1	2919293	g3865	i0	54.8	0.570422535211268	84	38	25.4	0	320	571	606	689	MCH2566828.1 reverse transcriptase family protein [Prochlorococcus sp. ALOHA_A2.0_51]	diamond	567	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. ALOHA_A2.0_51
31463003	31463003	PRJNA1186363_P_NODE_37256_length_260_cov_1.251337_g36368_i0	PRJNA1186363	37256	260	1.251337	3.2534762	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	42.7	0.0356	NR	MCD7740524.1	2137880	g36368	i0	34.9	0.726923076923077	63	39	70.4	1	39	221	39	101	MCD7740524.1 hypothetical protein [Candidatus Gastranaerophilales bacterium]	diamond	189	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
32380381	32380381	PRJNA1186363_P_NODE_9139_length_692_cov_0.956381_g8282_i0	PRJNA1186363	9139	692	0.956381	6.61815652	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	47	0.0375	NR	RAI12352.1	2052166	g8282	i0	33.3	0.63728323699422	147	84	58.1	6	442	41	9	154	RAI12352.1 MAG: hypothetical protein DKM24_03210 [Candidatus Melainabacteria bacterium]	diamond	441	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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