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

17 rows where analysis = "diamond", bioproject = "PRJNA565778" 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
5661990	5661990	PRJNA565778_S_NODE_23485_length_228_cov_6.591623_g23189_i0	PRJNA565778	23485	228	6.591623	15.02890044	Microcystis	1125	Bacteria	Bacteria	65.5	2.53e-10	NR	WP_216645762.1	1126	g23189	i0	55.4	6.73684210526316	65	23	82.9	3	1	189	134	194	WP_216645762.1 DNA cytosine methyltransferase [Microcystis aeruginosa]	diamond	1536	65.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
26730919	26730919	PRJNA565778_S_NODE_37921_length_175_cov_3.963768_g37625_i0	PRJNA565778	37921	175	3.963768	6.936594	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	79	1.13e-16	NR	WP_106370034.1	2107693	g37625	i0	94.9	0.668571428571429	39	2	66.9	0	143	27	58	96	WP_106370034.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	117	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
27079492	27079492	PRJNA565778_S_NODE_40602_length_162_cov_1.872000_g40306_i0	PRJNA565778	40602	162	1.872	3.03264	Limnospira platensis	118562	Bacteria	Bacteria	57	1.74e-8	NR	MDV7394826.1	3080829	g40306	i0	55.8	0.796296296296296	43	19	79.6	0	131	3	67	109	MDV7394826.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	129	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
27174096	27174096	PRJNA565778_S_NODE_32142_length_193_cov_4.346154_g31846_i0	PRJNA565778	32142	193	4.346154	8.38807722	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	43.5	0.00898	NR	MFN4150755.1	2762020	g31846	i0	82.6	0.357512953367876	23	4	35.8	0	149	81	198	220	MFN4150755.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	69	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
27490351	27490351	PRJNA565778_S_NODE_8923_length_362_cov_1.753846_g8627_i0	PRJNA565778	8923	362	1.753846	6.34892252	Candidatus Melainabacteria bacterium RIFCSPHIGHO2_	2052166	Bacteria	Bacteria	83.2	9.62e-16	NR	OGI20280.1	1801607	g8627	i0	40.5	2.00552486187845	121	69	98.6	2	360	4	179	298	OGI20280.1 MAG: hypothetical protein A3B68_05510 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	726	83.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
28816118	28816118	PRJNA565778_S_NODE_22828_length_232_cov_1.353846_g22532_i0	PRJNA565778	22828	232	1.353846	3.14092272	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	68.2	3.07e-11	NR	MBC7472678.1	2762020	g22532	i0	55.2	0.75	58	26	75	0	1	174	158	215	MBC7472678.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	174	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29227080	29227080	PRJNA565778_S_NODE_18849_length_255_cov_10.899083_g18553_i0	PRJNA565778	18849	255	10.899083	27.79266165	Microcystis sp. M020S1	2771109	Bacteria	Bacteria	132	1.29e-33	NR	MCA2924656.1	2771109	g18553	i0	82.4	0.870588235294118	74	13	87.1	0	34	255	523	596	MCA2924656.1 N-6 DNA methylase [Microcystis sp. M020S1]	diamond	222	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M020S1
29840365	29840365	PRJNA565778_S_NODE_32051_length_193_cov_72.205128_g31755_i0	PRJNA565778	32051	193	72.205128	139.35589704	Bacteria	2	Bacteria	Bacteria	56.2	1.64e-7	NR	DAB22467.1	1916215	g31755	i0	45.3	1.64766839378238	53	29	82.4	0	160	2	151	203	DAB22467.1 MAG TPA: hypothetical protein CPT94_05570, partial [Candidatus Gastranaerophilales bacterium HUM_22]	diamond	318	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium HUM_22
29890099	29890099	PRJNA565778_S_NODE_15471_length_281_cov_1.918033_g15175_i0	PRJNA565778	15471	281	1.918033	5.38967273	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	60.1	4.61e-8	NR	MBC7475092.1	2762020	g15175	i0	40.7	1.61209964412811	81	38	75.8	1	68	280	21	101	MBC7475092.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Sericytochromatia bacterium]	diamond	453	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
30742970	30742970	PRJNA565778_S_NODE_15874_length_277_cov_289.770833_g15578_i0	PRJNA565778	15874	277	289.770833	802.66520741	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	165	6.429999999999999e-47	NR	RYY00122.1	2847862	g15578	i0	96.4	1.8194945848375501	84	3	91	0	2	253	67	150	RYY00122.1 MAG: hypothetical protein EOO35_00540, partial [Cyanobacteriota bacterium]	diamond	504	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31248524	31248524	PRJNA565778_S_NODE_34895_length_184_cov_96.802721_g34599_i0	PRJNA565778	34895	184	96.802721	178.11700664	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	87.4	5.12e-19	NR	MFN4152850.1	2762020	g34599	i0	96	0.815217391304348	50	1	79.9	1	148	2	196	245	MFN4152850.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	150	87.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31501794	31501794	PRJNA565778_S_NODE_40356_length_163_cov_2.476190_g40060_i0	PRJNA565778	40356	163	2.47619	4.0361897	Hydrocoleum sp. CS-953	1671698	Bacteria	Bacteria	71.2	1.61e-13	NR	WP_094672650.1	1671698	g40060	i0	56.6	3.90184049079755	53	23	97.5	0	161	3	5	57	WP_094672650.1 hypothetical protein [Hydrocoleum sp. CS-953]	diamond	636	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Hydrocoleum	Hydrocoleum sp. CS-953
31628061	31628061	PRJNA565778_S_NODE_11356_length_324_cov_17.275261_g11060_i0	PRJNA565778	11356	324	17.275261	55.97184564	Microcystis	1125	Bacteria	Bacteria	72	2.98e-12	NR	WP_185237217.1	1125	g11060	i0	53.3	0.694444444444444	75	33	67.6	2	101	319	193	267	WP_185237217.1 MULTISPECIES: tail fiber domain-containing protein [Microcystis]	diamond	225	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis
32261162	32261162	PRJNA565778_S_NODE_29578_length_202_cov_3.818182_g29282_i0	PRJNA565778	29578	202	3.818182	7.71272764	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	99.4	1.4100000000000001e-22	NR	MBI3309483.1	2052166	g29282	i0	82.1	0.831683168316832	56	10	83.2	0	34	201	84	139	MBI3309483.1 TolC family protein [Candidatus Melainabacteria bacterium]	diamond	168	99.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32292889	32292889	PRJNA565778_S_NODE_5059_length_461_cov_6.804245_g4822_i0	PRJNA565778	5059	461	6.804245	31.36756945	Nostoc sp. CHAB 5834	2780403	Bacteria	Bacteria	162	1.64e-44	NR	MCC5612505.1	2780403	g4822	i0	66.4	0.754880694143167	116	39	75.5	0	411	64	306	421	MCC5612505.1 AAA family ATPase [Nostoc sp. CHAB 5834]	diamond	348	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5834
32559511	32559511	PRJNA565778_S_NODE_33419_length_189_cov_2.052632_g33123_i0	PRJNA565778	33419	189	2.052632	3.87947448	Oscillatoriales	1150	Bacteria	Bacteria	102	2.11e-26	NR	WP_254565713.1	2954806	g33123	i0	85.5	1.74603174603175	55	8	87.3	0	165	1	40	94	WP_254565713.1 J domain-containing protein [Oscillatoria sp. HE19RPO]	diamond	330	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. HE19RPO
32874106	32874106	PRJNA565778_S_NODE_18840_length_255_cov_30.536697_g18544_i0	PRJNA565778	18840	255	30.536697	77.86857735	Nostoc	1177	Bacteria	Bacteria	60.8	1.75e-8	NR	MEM6448518.1	3023271	g18544	i0	57.4	3.18823529411765	54	22	63.5	1	38	199	146	198	MEM6448518.1 thioesterase domain-containing protein [Cyanobacteria bacterium P01_D01_bin.123]	diamond	813	61.2	0.993464052287582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_D01_bin.123

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