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

28 rows where analysis = "diamond", bioproject = "PRJNA473799" 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
6823646	6823646	PRJNA473799_P_NODE_52766_length_242_cov_0.911243_g52492_i0	PRJNA473799	52766	242	0.911243	2.20520806	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	131	2.16e-33	NR	MBY0496550.1	2847862	g52492	i0	75	0.991735537190083	80	20	99.2	0	3	242	453	532	MBY0496550.1 PBP1A family penicillin-binding protein [Cyanobacteriota bacterium]	diamond	240	131	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
10649413	10649413	PRJNA473799_P_NODE_33989_length_252_cov_1.173184_g33715_i0	PRJNA473799	33989	252	1.173184	2.95642368	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	144	8.96e-39	NR	HCF30102.1	2055787	g33715	i0	80.7	1.04761904761905	88	12	98.8	1	250	2	278	365	HCF30102.1 cysteine--tRNA ligase [Cyanobacteria bacterium UBA11049]	diamond	264	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
21497690	21497690	PRJNA473799_P_NODE_49077_length_243_cov_2.394118_g48803_i0	PRJNA473799	49077	243	2.394118	5.81770674	unclassified Nostoc	2593658	Bacteria	Bacteria	82.8	2.4e-16	NR	WP_300421256.1	2593658	g48803	i0	68.4	2.83950617283951	57	18	70.4	0	4	174	362	418	WP_300421256.1 MULTISPECIES: MFS transporter [unclassified Nostoc]	diamond	690	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc
26664381	26664381	PRJNA473799_P_NODE_20341_length_278_cov_0.951220_g20067_i0	PRJNA473799	20341	278	0.95122	2.6443916	Waterburya sp.	3069706	Bacteria	Bacteria	136	8.009999999999998e-35	NR	HEY9674795.1	3069706	g20067	i0	73.6	0.982014388489209	91	24	98.2	0	3	275	471	561	HEY9674795.1 nucleotide exchange factor GrpE [Waterburya sp.]	diamond	273	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Waterburya	Waterburya sp.
26664388	26664388	PRJNA473799_P_NODE_28721_length_261_cov_1.553191_g28447_i0	PRJNA473799	28721	261	1.553191	4.05382851	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	169	5.51e-47	NR	WP_106370731.1	2107693	g28447	i0	94.2	0.988505747126437	86	5	98.9	0	2	259	520	605	WP_106370731.1 transketolase [Chlorogloea sp. CCALA 695]	diamond	258	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
26680745	26680745	PRJNA473799_P_NODE_42101_length_247_cov_0.885057_g41827_i0	PRJNA473799	42101	247	0.885057	2.18609079	Cyanophyceae	3028117	Bacteria	Bacteria	152	5.569999999999999e-46	NR	WP_193883803.1	1828648	g41827	i0	90.1	5.90283400809717	81	8	98.4	0	3	245	35	115	WP_193883803.1 histidine triad nucleotide-binding protein [Oculatella sp. LEGE 06141]	diamond	1458	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella sp. LEGE 06141
26918021	26918021	PRJNA473799_P_NODE_38142_length_249_cov_1.193182_g37868_i0	PRJNA473799	38142	249	1.193182	2.97102318	Cyanobacteria bacterium CRU_2_1	2720403	Bacteria	Bacteria	45.4	0.00466	NR	NJR61219.1	2720403	g37868	i0	33.7	4.51807228915663	83	42	100	2	1	249	145	214	NJR61219.1 DUF3987 domain-containing protein [Cyanobacteria bacterium CRU_2_1]	diamond	1125	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium CRU_2_1
27012862	27012862	PRJNA473799_P_NODE_54562_length_241_cov_0.916667_g54288_i0	PRJNA473799	54562	241	0.916667	2.20916747	Pleurocapsa minor	54308	Bacteria	Bacteria	139	2.55e-39	NR	MBW4436512.1	2839663	g54288	i0	88.8	0.995850622406639	80	9	99.6	0	241	2	124	203	MBW4436512.1 heme ABC exporter ATP-binding protein CcmA [Pleurocapsa minor GSE-CHR-MK 17-07R]	diamond	240	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
27282079	27282079	PRJNA473799_P_NODE_34503_length_251_cov_1.325843_g34229_i0	PRJNA473799	34503	251	1.325843	3.32786593	Bacteria	2	Bacteria	Bacteria	67.8	3.98e-11	NR	HEY9840447.1	2364082	g34229	i0	38.3	1.93625498007968	81	49	96.8	1	247	5	123	202	HEY9840447.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	486	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27377128	27377128	PRJNA473799_P_NODE_54663_length_241_cov_0.916667_g54389_i0	PRJNA473799	54663	241	0.916667	2.20916747	Nostocales	1161	Bacteria	Bacteria	54.7	2.26e-6	NR	OBQ33347.1	1710888	g54389	i0	38.5	1.94190871369295	78	46	97.1	1	238	5	502	577	OBQ33347.1 MAG: hypothetical protein AN487_20595, partial [Anabaena sp. CRKS33]	diamond	468	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. CRKS33
27802882	27802882	PRJNA473799_P_NODE_47824_length_244_cov_0.900585_g47550_i0	PRJNA473799	47824	244	0.900585	2.1974274	Chroococcales cyanobacterium	3088180	Bacteria	Bacteria	164	1.07e-47	NR	HEY9727430.1	3088180	g47550	i0	97.5	0.995901639344262	81	2	99.6	0	1	243	247	327	HEY9727430.1 ATP-dependent 6-phosphofructokinase [Chroococcales cyanobacterium]	diamond	243	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales			Chroococcales cyanobacterium
27929088	27929088	PRJNA473799_P_NODE_40165_length_248_cov_1.005714_g39891_i0	PRJNA473799	40165	248	1.005714	2.49417072	Nostoc sp. UIC 1	1180	Bacteria	Bacteria	73.6	5.56e-13	NR	WP_345940637.1	2100146	g39891	i0	48.1	0.931451612903226	77	38	93.1	2	5	235	644	718	WP_345940637.1 AAA-like domain-containing protein, partial [Nostoc sp. UIC 10630]	diamond	231	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UIC 10630
27992302	27992302	PRJNA473799_P_NODE_49025_length_243_cov_2.882353_g48751_i0	PRJNA473799	49025	243	2.882353	7.00411779	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	112	2.14e-27	NR	HEY9879216.1	3088178	g48751	i0	73.8	3.95061728395062	80	21	98.8	0	3	242	191	270	HEY9879216.1 sodium:proton antiporter [Leptolyngbyaceae cyanobacterium]	diamond	960	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
28497493	28497493	PRJNA473799_P_NODE_40027_length_248_cov_1.200000_g39753_i0	PRJNA473799	40027	248	1.2	2.976	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	97.8	9.81e-22	NR	HEY9782664.1	3088178	g39753	i0	75.9	1.00403225806452	83	17	99.2	2	247	2	142	222	HEY9782664.1 dihydrolipoamide acetyltransferase family protein [Leptolyngbyaceae cyanobacterium]	diamond	249	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
28655319	28655319	PRJNA473799_P_NODE_56927_length_228_cov_2.561290_g56653_i0	PRJNA473799	56927	228	2.56129	5.8397412	Aliterella atlantica	1827278	Bacteria	Bacteria	146	2.67e-40	NR	WP_045052579.1	1827278	g56653	i0	98.7	0.986842105263158	75	1	98.7	0	226	2	113	187	WP_045052579.1 GAF domain-containing sensor histidine kinase [Aliterella atlantica]	diamond	225	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
28781341	28781341	PRJNA473799_P_NODE_36387_length_250_cov_1.163842_g36113_i0	PRJNA473799	36387	250	1.163842	2.909605	Kamptonema animale	92934	Bacteria	Bacteria	48.1	1.63e-4	NR	WP_272034711.1	92934	g36113	i0	31.6	0.948	79	53	94.8	1	13	249	3	80	WP_272034711.1 hypothetical protein [Kamptonema animale]	diamond	237	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema	Kamptonema animale
28781349	28781349	PRJNA473799_P_NODE_55447_length_237_cov_2.658537_g55173_i0	PRJNA473799	55447	237	2.658537	6.30073269	Pleurocapsa minor	54308	Bacteria	Bacteria	128	2.06e-33	NR	MBW4435642.1	2839663	g55173	i0	78.5	1	79	17	100	0	1	237	219	297	MBW4435642.1 ABC transporter substrate-binding protein [Pleurocapsa minor GSE-CHR-MK 17-07R]	diamond	237	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
29633614	29633614	PRJNA473799_P_NODE_14290_length_291_cov_1.926606_g14016_i0	PRJNA473799	14290	291	1.926606	5.60642346	Pegethrix bostrychoides	2303509	Bacteria	Bacteria	79	1.24e-14	NR	MBW4468106.1	2839662	g14016	i0	46.9	1.16494845360825	113	35	97.9	4	3	287	221	326	MBW4468106.1 alpha/beta hydrolase [Pegethrix bostrychoides GSE-TBD4-15B]	diamond	339	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Pegethrix	Pegethrix bostrychoides
29886789	29886789	PRJNA473799_P_NODE_21411_length_275_cov_2.168317_g21137_i0	PRJNA473799	21411	275	2.168317	5.96287175	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	157	1.1899999999999997e-42	NR	HEY9708217.1	3088181	g21137	i0	78.9	0.981818181818182	90	19	98.2	0	272	3	454	543	HEY9708217.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	270	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30170877	30170877	PRJNA473799_P_NODE_42572_length_247_cov_0.885057_g42298_i0	PRJNA473799	42572	247	0.885057	2.18609079	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	50.8	5.47e-5	NR	MFN3428892.1	2762020	g42298	i0	69.4	0.437246963562753	36	11	43.7	0	247	140	507	542	MFN3428892.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	108	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30487045	30487045	PRJNA473799_P_NODE_47533_length_244_cov_1.228070_g47259_i0	PRJNA473799	47533	244	1.22807	2.9964908	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	92.8	7.87e-21	NR	MDR1996928.1	2053573	g47259	i0	55.1	0.959016393442623	78	35	95.9	0	6	239	77	154	MDR1996928.1 flagellar biosynthetic protein FliR [Candidatus Margulisiibacteriota bacterium]	diamond	234	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
30518523	30518523	PRJNA473799_P_NODE_55853_length_235_cov_2.246914_g55579_i0	PRJNA473799	55853	235	2.246914	5.2802479	Gloeotrichia echinulata	212360	Bacteria	Bacteria	44.3	0.00938	NR	MCM0591242.1	2824560	g55579	i0	32.5	0.982978723404255	77	44	88.1	1	212	6	106	182	MCM0591242.1 PAS domain-containing protein [Gloeotrichia echinulata DEX184]	diamond	231	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia echinulata
30724219	30724219	PRJNA473799_P_NODE_51914_length_242_cov_0.911243_g51640_i0	PRJNA473799	51914	242	0.911243	2.20520806	Cyanophyceae	3028117	Bacteria	Bacteria	106	3.29e-25	NR	MBW4474693.1	1382958	g51640	i0	74.6	1.7603305785124	71	17	86.8	1	213	4	1	71	MBW4474693.1 ATP-binding protein [Stenomitos rutilans HA7619-LM2]	diamond	426	107	0.990654205607477	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos rutilans
31403571	31403571	PRJNA473799_P_NODE_34816_length_251_cov_0.865169_g34542_i0	PRJNA473799	34816	251	0.865169	2.17157419	Nodularia spumigena	70799	Bacteria	Bacteria	83.2	5.71e-17	NR	WP_323209430.1	70799	g34542	i0	58.7	0.896414342629482	75	29	87.3	1	2	220	128	202	WP_323209430.1 endonuclease I family protein, partial [Nodularia spumigena]	diamond	225	83.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
31530110	31530110	PRJNA473799_P_NODE_29436_length_260_cov_1.122995_g29162_i0	PRJNA473799	29436	260	1.122995	2.919787	Microcoleus sp. FACHB-672	2692825	Bacteria	Bacteria	122	6.18e-30	NR	WP_199312552.1	2692825	g29162	i0	67.1	1.96153846153846	85	28	98.1	0	2	256	1129	1213	WP_199312552.1 PAS domain S-box protein [Microcoleus sp. FACHB-672]	diamond	510	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-672
32115656	32115656	PRJNA473799_P_NODE_42998_length_247_cov_0.885057_g42724_i0	PRJNA473799	42998	247	0.885057	2.18609079	Floridanema	3396149	Bacteria	Bacteria	129	1.83e-32	NR	MDP8935670.1	2847862	g42724	i0	81.3	12.5951417004049	80	15	97.2	0	245	6	664	743	MDP8935670.1 CHAT domain-containing protein [Cyanobacteriota bacterium]	diamond	3111	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32542551	32542551	PRJNA473799_P_NODE_16099_length_287_cov_1.046729_g15825_i0	PRJNA473799	16099	287	1.046729	3.00411223	Nostoc sp.	1180	Bacteria	Bacteria	53.1	1.33e-5	NR	WP_334708755.1	1180	g15825	i0	32.9	1.65156794425087	79	51	81.5	2	237	4	335	412	WP_334708755.1 hypothetical protein [Nostoc sp.]	diamond	474	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
32605443	32605443	PRJNA473799_P_NODE_17460_length_284_cov_1.161137_g17186_i0	PRJNA473799	17460	284	1.161137	3.29762908	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	163	6.59e-49	NR	MDY6782635.1	2847862	g17186	i0	88.3	0.992957746478873	94	11	99.3	0	3	284	102	195	MDY6782635.1 peptidoglycan-binding domain-containing protein [Cyanobacteriota bacterium]	diamond	282	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota 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);;