metadata: contig_metadata: 24 rows where bioproject = "PRJNA971593" and tax_clade = "Cyanobacteriota/Melainabacteria group"

24 rows where bioproject = "PRJNA971593" 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
2541961	2541961	PRJNA971593_P_NODE_28722_length_242_cov_0.893491_g28573_i0	PRJNA971593	28722	242	0.893491	2.16224822	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	121	8.83e-30	NR	WP_015152496.1	54299	g28573	i0	67.5	8.92561983471074	80	26	99.2	0	3	242	360	439	WP_015152496.1 glycogen/starch/alpha-glucan phosphorylase [Chroococcidiopsis thermalis]	diamond	2160	122	0.991803278688525	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
9872354	9872354	PRJNA971593_P_NODE_15288_length_307_cov_0.987179_g15139_i0	PRJNA971593	15288	307	0.987179	3.03063953	Prochlorococcaceae cyanobacterium ETNP1_MAG_8	3042809	Bacteria	Bacteria	124	5.46e-34	NR	MDP6852307.1	3042809	g15139	i0	67	8.89250814332248	97	32	94.8	0	304	14	42	138	MDP6852307.1 TCP-1/cpn60 chaperonin family protein [Prochlorococcaceae cyanobacterium ETNP1_MAG_8]	diamond	2730	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae		Prochlorococcaceae cyanobacterium ETNP1_MAG_8
9872655	9872655	PRJNA971593_P_NODE_9588_length_392_cov_1.686520_g9439_i0	PRJNA971593	9588	392	1.68652	6.6111584	Synechococcaceae	1890426	Bacteria	Bacteria	202	1.34e-58	NR	WP_197210768.1	1353136	g9439	i0	72.3	14.8928571428571	130	36	99.5	0	392	3	148	277	WP_197210768.1 transketolase [Synechococcus sp. CBW1004]	diamond	5838	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1004
11470165	11470165	PRJNA971593_P_NODE_7189_length_453_cov_1.918421_g7040_i0	PRJNA971593	7189	453	1.918421	8.69044713	Leptolyngbya	47251	Bacteria	Bacteria	760	0	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g7040	i0	96.909	257.9293598234	453	14	100	0	1	453	247928	247476	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	116842	760	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
20070885	20070885	PRJNA971593_P_NODE_19236_length_271_cov_1.757576_g19087_i0	PRJNA971593	19236	271	1.757576	4.76303096	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g19087	i0	96.774	0.114391143911439	31	1	11	0	88	118	3342870	3342900	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	31	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
20070924	20070924	PRJNA971593_P_NODE_22236_length_251_cov_0.865169_g22087_i0	PRJNA971593	22236	251	0.865169	2.17157419	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g22087	i0	98.413	177.669322709163	252	3	100	1	1	251	1243927	1243676	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	44595	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
26772773	26772773	PRJNA971593_P_NODE_18161_length_280_cov_1.101449_g18012_i0	PRJNA971593	18161	280	1.101449	3.0840572	Alkalinema sp. FACHB-956	2692768	Bacteria	Bacteria	58.5	1.49e-7	NR	WP_190574967.1	2692768	g18012	i0	46.5	3.3	71	35	72.9	2	75	278	68	138	WP_190574967.1 VWD domain-containing protein [Alkalinema sp. FACHB-956]	diamond	924	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema sp. FACHB-956
26867924	26867924	PRJNA971593_P_NODE_10401_length_375_cov_2.228477_g10252_i0	PRJNA971593	10401	375	2.228477	8.35678875	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	141	1.14e-39	NR	MBI5172228.1	2052166	g10252	i0	53.3	0.96	120	55	96	1	14	373	68	186	MBI5172228.1 C40 family peptidase [Candidatus Melainabacteria bacterium]	diamond	360	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27405407	27405407	PRJNA971593_P_NODE_5123_length_536_cov_1.062635_g4976_i0	PRJNA971593	5123	536	1.062635	5.6957236	Planktothrix agardhii	1160	Bacteria	Bacteria	66.2	4.75e-9	NR	WP_027250225.1	1160	g4976	i0	30	0.83955223880597	150	101	84	2	469	20	193	338	WP_027250225.1 hypothetical protein [Planktothrix agardhii]	diamond	450	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
28257547	28257547	PRJNA971593_P_NODE_11846_length_351_cov_1.104317_g11697_i0	PRJNA971593	11846	351	1.104317	3.87615267	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	154	3.0099999999999993e-43	NR	MBX9694561.1	2847862	g11697	i0	74.3	0.897435897435897	105	23	86.3	1	321	19	15	119	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	315	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28478765	28478765	PRJNA971593_P_NODE_25846_length_246_cov_0.890173_g25697_i0	PRJNA971593	25846	246	0.890173	2.18982558	Potamolinea sp.	3100419	Bacteria	Bacteria	106	4.12e-26	NR	MFB8790588.1	3100419	g25697	i0	71.2	0.804878048780488	66	19	80.5	0	1	198	178	243	MFB8790588.1 methyltransferase domain-containing protein [Potamolinea sp.]	diamond	198	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Potamolinea	Potamolinea sp.
28857485	28857485	PRJNA971593_P_NODE_23088_length_250_cov_0.870056_g22939_i0	PRJNA971593	23088	250	0.870056	2.17514	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	105	4.55e-26	NR	MBW4639845.1	2839657	g22939	i0	80	0.78	65	12	78	1	3	197	50	113	MBW4639845.1 iron uptake porin [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	195	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
29488945	29488945	PRJNA971593_P_NODE_27690_length_243_cov_0.905882_g27541_i0	PRJNA971593	27690	243	0.905882	2.20129326	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	57.8	1.26e-7	NR	MSR89129.1	2053573	g27541	i0	39.5	3.88888888888889	81	46	97.5	2	1	237	65	144	MSR89129.1 DUF1295 domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	945	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
29552052	29552052	PRJNA971593_P_NODE_25250_length_247_cov_0.885057_g25101_i0	PRJNA971593	25250	247	0.885057	2.18609079	Cyanomargarita calcarea	1982362	Bacteria	Bacteria	72	1.96e-12	NR	MBW4670471.1	2839659	g25101	i0	45.6	9.31578947368421	79	41	96	1	244	8	436	512	MBW4670471.1 response regulator [Cyanomargarita calcarea GSE-NOS-MK-12-04C]	diamond	2301	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Cyanomargaritaceae	Cyanomargarita	Cyanomargarita calcarea
30317110	30317110	PRJNA971593_P_NODE_13412_length_329_cov_1.039062_g13263_i0	PRJNA971593	13412	329	1.039062	3.41851398	Microseira	1609595	Bacteria	Bacteria	63.5	3.47e-9	NR	WP_226593065.1	467598	g13263	i0	38.1	1.61398176291793	84	51	75.7	1	274	26	212	295	WP_226593065.1 ATP adenylyltransferase family protein [Microseira wollei]	diamond	531	63.9	0.993740219092332	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei
30474697	30474697	PRJNA971593_P_NODE_27993_length_243_cov_0.905882_g27844_i0	PRJNA971593	27993	243	0.905882	2.20129326	Cyanophyceae	3028117	Bacteria	Bacteria	137	6.26e-39	NR	MBW4542508.1	1601998	g27844	i0	77.5	11.8395061728395	80	18	98.8	0	3	242	28	107	MBW4542508.1 transposase [Myxacorys chilensis ATA2-1-KO14]	diamond	2877	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys chilensis
30948703	30948703	PRJNA971593_P_NODE_3334_length_660_cov_2.998296_g3191_i0	PRJNA971593	3334	660	2.998296	19.7887536	Bacteria	2	Bacteria	Bacteria	186	1.2499999999999995e-55	NR	WP_007312344.1	263510	g3191	i0	48.4	6.72272727272727	184	95	83.6	0	97	648	13	196	WP_007312344.1 MULTISPECIES: nitroreductase family protein [Crocosphaera]	diamond	4437	187	0.994652406417112	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera
31005431	31005431	PRJNA971593_P_NODE_2674_length_729_cov_3.754573_g2538_i0	PRJNA971593	2674	729	3.754573	27.37083717	Adonisia turfae	2950184	Bacteria	Bacteria	53.9	1.7e-4	NR	WP_163696729.1	2950184	g2538	i0	29	0.440329218106996	107	73	42.8	2	464	153	4	110	WP_163696729.1 hypothetical protein [Adonisia turfae]	diamond	321	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota				Adonisia	Adonisia turfae
31258236	31258236	PRJNA971593_P_NODE_8955_length_406_cov_1.150150_g8806_i0	PRJNA971593	8955	406	1.15015	4.669609	Okeania sp.	3100323	Bacteria	Bacteria	89.7	2.69e-19	NR	WP_324237148.1	3100323	g8806	i0	36.7	2.05418719211823	139	83	99	1	405	4	28	166	WP_324237148.1 hypothetical protein [Okeania sp.]	diamond	834	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp.
31416377	31416377	PRJNA971593_P_NODE_13376_length_329_cov_1.351562_g13227_i0	PRJNA971593	13376	329	1.351562	4.44663898	Spirulina sp. CCNP131	1157	Bacteria	Bacteria	114	4.03e-27	NR	WP_323257193.1	3110249	g13227	i0	46.8	1.98784194528875	109	57	98.5	1	1	324	348	456	WP_323257193.1 flavin monoamine oxidase family protein [Spirulina sp. CCNP1310]	diamond	654	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. CCNP1310
32080622	32080622	PRJNA971593_P_NODE_7478_length_445_cov_1.309140_g7329_i0	PRJNA971593	7478	445	1.30914	5.825673	Cyanobacteria bacterium P01_A01_bin.40	3023249	Bacteria	Bacteria	55.8	6.55e-6	NR	MEM7757232.1	3023249	g7329	i0	45.5	0.728089887640449	55	30	37.1	0	2	166	201	255	MEM7757232.1 LCCL domain-containing protein [Cyanobacteria bacterium P01_A01_bin.40]	diamond	324	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.40
32112387	32112387	PRJNA971593_P_NODE_20518_length_261_cov_1.632979_g20369_i0	PRJNA971593	20518	261	1.632979	4.26207519	Cyanobacteria bacterium UBA12227	2055765	Bacteria	Bacteria	41.2	0.0132	NR	HAG80149.1	2055765	g20369	i0	69.6	0.264367816091954	23	7	26.4	0	260	192	21	43	HAG80149.1 NAD-dependent dehydratase [Cyanobacteria bacterium UBA12227]	diamond	69	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA12227
32112390	32112390	PRJNA971593_P_NODE_21978_length_251_cov_0.865169_g21829_i0	PRJNA971593	21978	251	0.865169	2.17157419	Tolypothrix sp. T3-bin4	2768888	Bacteria	Bacteria	169	9.69e-51	NR	MBD0303271.1	2768888	g21829	i0	100	0.99203187250996006	83	0	99.2	0	3	251	98	180	MBD0303271.1 class I SAM-dependent methyltransferase [Tolypothrix sp. T3-bin4]	diamond	249	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. T3-bin4
32744402	32744402	PRJNA971593_P_NODE_25720_length_246_cov_0.890173_g25571_i0	PRJNA971593	25720	246	0.890173	2.18982558	Leptolyngbya sp. FACHB-671	2692812	Bacteria	Bacteria	42.7	0.0382	NR	WP_190678703.1	2692812	g25571	i0	33.3	0.878048780487805	72	46	85.4	1	23	232	402	473	WP_190678703.1 hypothetical protein [Leptolyngbya sp. FACHB-671]	diamond	216	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-671

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