metadata: contig_metadata: 23 rows where bioproject = "PRJNA222400" and tax_clade = "Cyanobacteriota/Melainabacteria group"

23 rows where bioproject = "PRJNA222400" 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
367256	367256	PRJNA222400_P_NODE_821_length_569_cov_26.901923_g790_i0	PRJNA222400	821	569	26.901923	153.07194187	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	219	1.7999999999999998e-69	NR	CAI8350359.1	2024869	g790	i0	70.3	2.34094903339192	148	44	78	0	534	91	46	193	CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6]	diamond	1332	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ARS6
5470573	5470573	PRJNA222400_P_NODE_6465_length_176_cov_1.637795_g6432_i0	PRJNA222400	6465	176	1.637795	2.8825192	Microcystis aeruginosa	1126	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2153464463\|gb\|CP086723.1\|	2894165	g6432	i0	100	0.159090909090909	28	0	16	0	147	174	399297	399270	MAG: Microcystis aeruginosa NIBR18 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
25282604	25282604	PRJNA222400_P_NODE_4960_length_200_cov_1.642384_g4927_i0	PRJNA222400	4960	200	1.642384	3.284768	Bacillati	1783272	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g4927	i0	96.97	0.345	33	1	17	0	101	133	3754902	3754870	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	69	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
26789279	26789279	PRJNA222400_P_NODE_9321_length_162_cov_0.920354_g9288_i0	PRJNA222400	9321	162	0.920354	1.49097348	Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11	1801609	Bacteria	Bacteria	52.4	4.81e-6	NR	OGI09100.1	1801609	g9288	i0	58.3	0.666666666666667	36	15	66.7	0	108	1	125	160	OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11]	diamond	108	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11
27453402	27453402	PRJNA222400_P_NODE_6683_length_174_cov_1.192000_g6650_i0	PRJNA222400	6683	174	1.192	2.07408	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	85.1	6.83e-19	NR	MBL8086383.1	2711154	g6650	i0	77.2	0.982758620689655	57	12	98.3	1	3	173	61	116	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	171	85.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27769188	27769188	PRJNA222400_P_NODE_2764_length_288_cov_1.046025_g2731_i0	PRJNA222400	2764	288	1.046025	3.012552	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	77.8	2.15e-15	NR	MBL8086383.1	2711154	g2731	i0	72.3	0.489583333333333	47	13	49	0	287	147	98	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	141	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27849693	27849693	PRJNA222400_P_NODE_584_length_672_cov_4.521669_g554_i0	PRJNA222400	584	672	4.521669	30.38561568	Bacillati	1783272	Bacteria	Bacteria	67.8	4.81e-10	NR	WP_168694645.1	1166	g554	i0	60.4	0.40625	48	19	21.4	0	576	433	38	85	WP_168694645.1 AbfB domain-containing protein [Dolichospermum flos-aquae]	diamond	273	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum flos-aquae
28242386	28242386	PRJNA222400_P_NODE_2946_length_276_cov_0.916300_g2913_i0	PRJNA222400	2946	276	0.9163	2.528988	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	72.8	1.59e-13	NR	MBL8086383.1	2711154	g2913	i0	73.3	0.489130434782609	45	11	48.9	1	3	137	98	141	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	135	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28716253	28716253	PRJNA222400_P_NODE_7187_length_169_cov_0.866667_g7154_i0	PRJNA222400	7187	169	0.866667	1.46466723	Halomicronema hongdechloris	1209493	Bacteria	Bacteria	45.8	0.00109	NR	WP_088429742.1	1209493	g7154	i0	70	2.1301775147929	30	9	53.3	0	167	78	515	544	WP_088429742.1 alpha-D-glucose phosphate-specific phosphoglucomutase [Halomicronema hongdechloris]	diamond	360	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Halomicronema	Halomicronema hongdechloris
28860113	28860113	PRJNA222400_P_NODE_5428_length_192_cov_1.629371_g5395_i0	PRJNA222400	5428	192	1.629371	3.12839232	Floridanema	3396149	Bacteria	Bacteria	47	6.04e-4	NR	WP_084555056.1	454136	g5395	i0	44.9	2.25	49	27	76.6	0	16	162	77	125	WP_084555056.1 choice-of-anchor A family protein [[Phormidium ambiguum] IAM M-71]	diamond	432	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Floridanema	[Phormidium ambiguum] IAM M-71
28968843	28968843	PRJNA222400_P_NODE_468_length_744_cov_1.863309_g441_i0	PRJNA222400	468	744	1.863309	13.86301896	Leptolyngbya sp. NIES-21	47254	Bacteria	Bacteria	58.9	5.79e-6	NR	WP_192843594.1	1552121	g441	i0	42.4	1.07661290322581	66	37	26.6	1	525	722	48	112	WP_192843594.1 DUF4394 domain-containing protein [Leptolyngbya sp. NIES-2104]	diamond	801	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-2104
29032131	29032131	PRJNA222400_P_NODE_1408_length_435_cov_1.217617_g1375_i0	PRJNA222400	1408	435	1.217617	5.29663395	Oscillatoria sp. PCC 1	1159	Bacteria	Bacteria	160	3.84e-46	NR	WP_017716299.1	1173028	g1375	i0	64.7	3.28275862068966	119	39	82.1	1	435	79	124	239	WP_017716299.1 SDR family oxidoreductase [Oscillatoria sp. PCC 10802]	diamond	1428	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. PCC 10802
29158386	29158386	PRJNA222400_P_NODE_209_length_1028_cov_2.371808_g192_i0	PRJNA222400	209	1028	2.371808	24.38218624	Coleofasciculus sp. G2-EDA-02	3069529	Bacteria	Bacteria	132	1.37e-32	NR	MEQ9669851.1	3069529	g192	i0	36	1.40077821011673	250	144	71.5	7	8	742	14	252	MEQ9669851.1 carbonic anhydrase family protein [Coleofasciculus sp. G2-EDA-02]	diamond	1440	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. G2-EDA-02
29599984	29599984	PRJNA222400_P_NODE_5970_length_184_cov_1.148148_g5937_i0	PRJNA222400	5970	184	1.148148	2.11259232	Gloeocapsa sp. DLM2.Bin57	2480214	Bacteria	Bacteria	73.6	4.78e-15	NR	TVQ46901.1	2480214	g5937	i0	80.5	0.668478260869565	41	7	65.2	1	182	63	72	112	TVQ46901.1 MAG: histidine triad nucleotide-binding protein [Gloeocapsa sp. DLM2.Bin57]	diamond	123	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. DLM2.Bin57
29838970	29838970	PRJNA222400_P_NODE_7611_length_167_cov_2.203390_g7578_i0	PRJNA222400	7611	167	2.20339	3.6796613	Bacteria	2	Bacteria	Bacteria	77.8	2.22e-15	NR	WP_193931916.1	693223	g7578	i0	73.3	22.4011976047904	45	12	80.8	0	32	166	225	269	WP_193931916.1 alpha/beta fold hydrolase [Gloeocapsopsis crepidinum]	diamond	3741	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
30534020	30534020	PRJNA222400_P_NODE_3613_length_238_cov_1.116402_g3580_i0	PRJNA222400	3613	238	1.116402	2.65703676	Cyanophyceae	3028117	Bacteria	Bacteria	63.9	7.49e-10	NR	NJR31991.1	2720409	g3580	i0	34.2	13.3865546218487	79	52	99.6	0	238	2	26	104	NJR31991.1 fatty acid desaturase [Chamaesiphon sp. CSU_1_12]	diamond	3186	64.3	0.993779160186625	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon sp. CSU_1_12
30565335	30565335	PRJNA222400_P_NODE_3633_length_237_cov_1.382979_g3600_i0	PRJNA222400	3633	237	1.382979	3.27766023	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	60.8	1.41e-8	NR	BAU09863.1	1752064	g3600	i0	45.9	2.56962025316456	61	33	77.2	0	11	193	341	401	BAU09863.1 hypothetical protein LEP3755_03380 [Leptolyngbya sp. NIES-3755]	diamond	609	61.2	0.993464052287582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
31401405	31401405	PRJNA222400_P_NODE_776_length_586_cov_1.657356_g745_i0	PRJNA222400	776	586	1.657356	9.71210616	Nodosilinea sp. LEGE	2497642	Bacteria	Bacteria	52.8	5.75e-5	NR	WP_194056260.1	2777966	g745	i0	43.6	0.491467576791809	55	30	28.2	1	586	422	97	150	WP_194056260.1 50S ribosomal protein L13 [Nodosilinea sp. LEGE 06152]	diamond	288	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. LEGE 06152
31514125	31514125	PRJNA222400_P_NODE_1676_length_393_cov_1.872093_g1643_i0	PRJNA222400	1676	393	1.872093	7.35732549	Bacteria	2	Bacteria	Bacteria	55.8	5.35e-6	NR	WP_260324468.1	1126	g1643	i0	37.9	4.6793893129771	103	60	76.3	3	371	72	881	982	WP_260324468.1 Calx-beta domain-containing protein [Microcystis aeruginosa]	diamond	1839	56.2	0.99288256227758	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
32002227	32002227	PRJNA222400_P_NODE_4818_length_203_cov_1.012987_g4785_i0	PRJNA222400	4818	203	1.012987	2.05636361	Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11	1801609	Bacteria	Bacteria	48.1	2.62e-4	NR	OGI09100.1	1801609	g4785	i0	51.4	1.064039408867	37	18	54.7	0	197	87	128	164	OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11]	diamond	216	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11
32571947	32571947	PRJNA222400_P_NODE_7899_length_167_cov_0.881356_g7866_i0	PRJNA222400	7899	167	0.881356	1.47186452	Prochloraceae cyanobacterium	2692183	Bacteria	Bacteria	52.8	3.77e-6	NR	MDJ0725641.1	2692183	g7866	i0	75	1.0059880239521	28	7	50.3	0	83	166	4	31	MDJ0725641.1 SDR family oxidoreductase [Prochloraceae cyanobacterium]	diamond	168	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae		Prochloraceae cyanobacterium
32634408	32634408	PRJNA222400_P_NODE_1160_length_478_cov_3.794872_g1127_i0	PRJNA222400	1160	478	3.794872	18.13948816	Symploca sp. SIO2E6	2607809	Bacteria	Bacteria	84.7	2.9e-17	NR	NET61656.1	2607809	g1127	i0	37.6	0.884937238493724	141	82	86.6	4	474	61	31	168	NET61656.1 hypothetical protein [Symploca sp. SIO2E6]	diamond	423	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO2E6
32841198	32841198	PRJNA222400_P_NODE_8580_length_164_cov_1.686957_g8547_i0	PRJNA222400	8580	164	1.686957	2.76660948	Chroococcidiopsis	54298	Bacteria	Bacteria	90.5	1.89e-19	NR	MEO1095502.1	3023210	g8547	i0	75.5	19.3719512195122	53	13	97	0	2	160	180	232	MEO1095502.1 transketolase [Cyanobacteria bacterium J06638_28]	diamond	3177	90.9	0.995599559955996	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06638_28

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