metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA725806" and tax_clade = "Cyanobacteriota/Melainabacteria group"

20 rows where analysis = "diamond", bioproject = "PRJNA725806" 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
14740896	14740896	PRJNA725806_P_NODE_185272_length_154_cov_1.324786_g184970_i0	PRJNA725806	185272	154	1.324786	2.04017044	Chroococcidiopsis sp. SAG 2	3088168	Bacteria	Bacteria	90.5	9.58e-20	NR	WP_317106051.1	171389	g184970	i0	84.3	0.993506493506494	51	8	99.4	0	1	153	316	366	WP_317106051.1 type III-B CRISPR module-associated Cmr3 family protein [Chroococcidiopsis sp. SAG 2025]	diamond	153	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
27368674	27368674	PRJNA725806_P_NODE_141383_length_173_cov_1.147059_g141081_i0	PRJNA725806	141383	173	1.147059	1.98441207	Leptolyngbyaceae cyanobacterium SM1_4_3	2720459	Bacteria	Bacteria	102	1.8199999999999994e-23	NR	NJL40847.1	2720459	g141081	i0	80.7	6.91907514450867	57	11	98.8	0	2	172	489	545	NJL40847.1 PAS domain S-box protein [Leptolyngbyaceae cyanobacterium SM1_4_3]	diamond	1197	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium SM1_4_3
27841823	27841823	PRJNA725806_P_NODE_184444_length_154_cov_2.632479_g184142_i0	PRJNA725806	184444	154	2.632479	4.05401766	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	75.5	3.12e-14	NR	HEY9873029.1	2364082	g184142	i0	73.5	0.954545454545455	49	12	93.5	1	144	1	5	53	HEY9873029.1 bifunctional orotidine-5'-phosphate decarboxylase/orotate phosphoribosyltransferase [Candidatus Obscuribacterales bacterium]	diamond	147	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28252341	28252341	PRJNA725806_P_NODE_177526_length_157_cov_1.250000_g177224_i0	PRJNA725806	177526	157	1.25	1.9625	Stenomitos sp.	3088177	Bacteria	Bacteria	49.3	5.45e-5	NR	HEY9833652.1	3088177	g177224	i0	50	0.878980891719745	46	22	87.9	1	12	149	48	92	HEY9833652.1 reverse transcriptase domain-containing protein [Stenomitos sp.]	diamond	138	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
29389250	29389250	PRJNA725806_P_NODE_151849_length_168_cov_1.580153_g151547_i0	PRJNA725806	151849	168	1.580153	2.65465704	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	56.2	2.3e-7	NR	MEY3825740.1	2847862	g151547	i0	51.1	1.67857142857143	47	23	83.9	0	3	143	606	652	MEY3825740.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	282	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29389259	29389259	PRJNA725806_P_NODE_196409_length_150_cov_1.026549_g196107_i0	PRJNA725806	196409	150	1.026549	1.5398235	Leptolyngbya sp. NIES-21	47254	Bacteria	Bacteria	96.7	3.98e-23	NR	WP_059002147.1	1552121	g196107	i0	93.9	1.96	49	3	98	0	2	148	119	167	WP_059002147.1 class I SAM-dependent methyltransferase [Leptolyngbya sp. NIES-2104]	diamond	294	96.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-2104
29389289	29389289	PRJNA725806_P_NODE_8869_length_386_cov_5.134670_g8584_i0	PRJNA725806	8869	386	5.13467	19.8198262	Nostocales cyanobacterium	2447902	Bacteria	Bacteria	86.7	2.58e-18	NR	TAF09655.1	2447902	g8584	i0	57.9	0.878238341968912	57	24	44.3	0	385	215	126	182	TAF09655.1 MAG: RNA 2'-phosphotransferase [Nostocales cyanobacterium]	diamond	339	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium
30400272	30400272	PRJNA725806_P_NODE_17053_length_330_cov_5.153584_g16761_i0	PRJNA725806	17053	330	5.153584	17.0068272	filamentous cyanobacterium CCP4	2107699	Bacteria	Bacteria	45.8	0.00832	NR	PSN77425.1	2107699	g16761	i0	31	1.05454545454545	116	62	96.4	6	11	328	489	596	PSN77425.1 polymerase [filamentous cyanobacterium CCP4]	diamond	348	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					filamentous cyanobacterium CCP4
30494735	30494735	PRJNA725806_P_NODE_36633_length_272_cov_3.331915_g36336_i0	PRJNA725806	36633	272	3.331915	9.0628088000000009	Aetokthonos hydrillicola	1550245	Bacteria	Bacteria	52.4	1.18e-5	NR	WP_208344052.1	1550245	g36336	i0	64.5	7.06985294117647	31	11	34.2	0	115	23	7	37	WP_208344052.1 DJ-1/PfpI family protein [Aetokthonos hydrillicola]	diamond	1923	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Aetokthonos	Aetokthonos hydrillicola
30526186	30526186	PRJNA725806_P_NODE_96553_length_200_cov_1.134969_g96251_i0	PRJNA725806	96553	200	1.134969	2.269938	Calothrix sp. CSU_2_0	2720413	Bacteria	Bacteria	79	1.97e-17	NR	NJR18135.1	2720413	g96251	i0	77.8	0.81	54	8	75	1	49	198	1	54	NJR18135.1 hypothetical protein [Calothrix sp. CSU_2_0]	diamond	162	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. CSU_2_0
30589266	30589266	PRJNA725806_P_NODE_124153_length_182_cov_1.593103_g123851_i0	PRJNA725806	124153	182	1.593103	2.89944746	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	40.8	0.0304	NR	PKL74440.1	2013813	g123851	i0	35.7	0.923076923076923	56	30	92.3	1	14	181	34	83	PKL74440.1 MAG: DUF58 domain-containing protein, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	168	40.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
31063559	31063559	PRJNA725806_P_NODE_172435_length_159_cov_1.278689_g172133_i0	PRJNA725806	172435	159	1.278689	2.03311551	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	89	4.61e-20	NR	WP_250122953.1	155894	g172133	i0	80.4	1.94339622641509	51	10	96.2	0	6	158	70	120	WP_250122953.1 bifunctional demethylmenaquinone methyltransferase/2-methoxy-6-polyprenyl-1,4-benzoquinol methylase UbiE [Chroococcidiopsis sp. CCMEE 29]	diamond	309	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
31157757	31157757	PRJNA725806_P_NODE_182895_length_155_cov_0.991525_g182593_i0	PRJNA725806	182895	155	0.991525	1.53686375	Chroococcidiopsis sp. SAG 2	3088168	Bacteria	Bacteria	104	1.65e-24	NR	WP_317108630.1	171389	g182593	i0	96.1	0.987096774193548	51	2	98.7	0	3	155	133	183	WP_317108630.1 VapE domain-containing protein [Chroococcidiopsis sp. SAG 2025]	diamond	153	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
31231476	31231476	PRJNA725806_P_NODE_190855_length_152_cov_1.017391_g190553_i0	PRJNA725806	190855	152	1.017391	1.54643432	Cyanophyceae	3028117	Bacteria	Bacteria	112	1.08e-27	NR	WP_200670356.1	984206	g190553	i0	90	6.90789473684211	50	5	98.7	0	2	151	124	173	WP_200670356.1 circularly permuted type 2 ATP-grasp protein [Oxynema sp. CENA135]	diamond	1050	113	0.991150442477876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oxynema	Oxynema sp. CENA135
31759007	31759007	PRJNA725806_P_NODE_81677_length_212_cov_2.234286_g81376_i0	PRJNA725806	81677	212	2.234286	4.73668632	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	139	1.72e-36	NR	MDQ5936147.1	3070899	g81376	i0	98.6	0.990566037735849	70	1	99.1	0	211	2	329	398	MDQ5936147.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	210	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
32233860	32233860	PRJNA725806_P_NODE_105618_length_193_cov_5.108974_g105316_i0	PRJNA725806	105618	193	5.108974	9.86031982	Calothrix sp. MO_192.B10	3036784	Bacteria	Bacteria	44.7	0.00322	NR	MDJ0615262.1	3036784	g105316	i0	34.6	1.67875647668394	52	34	80.8	0	25	180	107	158	MDJ0615262.1 Uma2 family endonuclease [Calothrix sp. MO_192.B10]	diamond	324	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. MO_192.B10
32233875	32233875	PRJNA725806_P_NODE_156258_length_166_cov_1.201550_g155956_i0	PRJNA725806	156258	166	1.20155	1.994573	Aliterella atlantica	1827278	Bacteria	Bacteria	104	1.03e-26	NR	WP_045055145.1	1827278	g155956	i0	88.9	3.90361445783133	54	6	97.6	0	3	164	67	120	WP_045055145.1 orange carotenoid protein N-terminal domain-containing protein [Aliterella atlantica]	diamond	648	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
32297250	32297250	PRJNA725806_P_NODE_115459_length_187_cov_2.066667_g115157_i0	PRJNA725806	115459	187	2.066667	3.86466729	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	41.6	0.0468	NR	MFN8671614.1	2762020	g115157	i0	47.6	0.67379679144385	42	22	67.4	0	129	4	165	206	MFN8671614.1 response regulator [Candidatus Sericytochromatia bacterium]	diamond	126	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32486869	32486869	PRJNA725806_P_NODE_116879_length_186_cov_2.852349_g116577_i0	PRJNA725806	116879	186	2.852349	5.30536914	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	110	1.83e-26	NR	MBC7473199.1	2762020	g116577	i0	85.5	1	62	9	100	0	1	186	576	637	MBC7473199.1 SDR family oxidoreductase [Candidatus Sericytochromatia bacterium]	diamond	186	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32591970	32591970	PRJNA725806_P_NODE_107919_length_192_cov_1.496774_g107617_i0	PRJNA725806	107919	192	1.496774	2.87380608	Bacteria	2	Bacteria	Bacteria	121	7.2899999999999984e-34	NR	PKL76384.1	2013813	g107617	i0	91.9	3.921875	62	5	96.9	0	188	3	1	62	PKL76384.1 MAG: peptide ABC transporter ATP-binding protein, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	753	122	0.991803278688525	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-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);;