metadata: contig_metadata: 15 rows where bioproject = "PRJNA1166865", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

15 rows where bioproject = "PRJNA1166865", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

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_order	tax_family	tax_genus	tax_species
5415828	5415828	PRJNA1166865_P_NODE_37965_length_353_cov_0.960714_g37724_i0	PRJNA1166865	37965	353	0.960714	3.39132042	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	409	1.72e-109	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g37724	i0	89.297	287.889518413598	327	34	93	1	1	327	3681802	3681477	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	101625	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
9240659	9240659	PRJNA1166865_P_NODE_36488_length_359_cov_1.622378_g36247_i0	PRJNA1166865	36488	359	1.622378	5.82433702	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	329	1.4e-85	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g36247	i0	88.806	76.5208913649025	268	30	75	0	5	272	3680254	3680521	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	27471	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
11242953	11242953	PRJNA1166865_P_NODE_89329_length_244_cov_0.900585_g89088_i0	PRJNA1166865	89329	244	0.900585	2.1974274	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	153	3.43e-41	NR	MBX9570231.1	2364082	g89088	i0	95.1	0.995901639344262	81	4	99.6	0	2	244	577	657	MBX9570231.1 type I secretion system permease/ATPase [Candidatus Obscuribacterales bacterium]	diamond	243	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27419947	27419947	PRJNA1166865_P_NODE_24903_length_431_cov_1.290503_g24662_i0	PRJNA1166865	24903	431	1.290503	5.56206793	Candidatus Melainabacteria bacterium GWF2_37_15	1801606	Bacteria	Bacteria	105	3.2899999999999996e-23	NR	OGI00057.1	1801606	g24662	i0	48.7	1.59396751740139	115	59	80	0	87	431	12	126	OGI00057.1 MAG: sodium-translocating pyrophosphatase [Candidatus Melainabacteria bacterium GWF2_37_15]	diamond	687	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium GWF2_37_15
27640916	27640916	PRJNA1166865_P_NODE_59824_length_286_cov_1.446009_g59583_i0	PRJNA1166865	59824	286	1.446009	4.13558574	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	171	1.18e-49	NR	MCC7531882.1	2052166	g59583	i0	93.6	0.986013986013986	94	6	98.6	0	3	284	216	309	MCC7531882.1 HAMP domain-containing histidine kinase [Candidatus Melainabacteria bacterium]	diamond	282	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
28019799	28019799	PRJNA1166865_P_NODE_69545_length_263_cov_2.226316_g69304_i0	PRJNA1166865	69545	263	2.226316	5.85521108	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	124	3.28e-32	NR	HNB24695.1	2052166	g69304	i0	98.5	1.52851711026616	67	1	76.4	0	202	2	1	67	HNB24695.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	402	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
28651164	28651164	PRJNA1166865_P_NODE_58107_length_290_cov_1.359447_g57866_i0	PRJNA1166865	58107	290	1.359447	3.9423963	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	107	8.78e-27	NR	MBL8086383.1	2711154	g57866	i0	79.5	0.755172413793103	73	13	75.5	2	71	289	59	129	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	219	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
29503482	29503482	PRJNA1166865_P_NODE_58170_length_290_cov_1.188940_g57929_i0	PRJNA1166865	58170	290	1.18894	3.447926	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	193	1.21e-60	NR	PZM85907.1	2052166	g57929	i0	100	0.993103448275862	96	0	99.3	0	288	1	89	184	PZM85907.1 MAG: hypothetical protein DKT66_00435 [Candidatus Melainabacteria bacterium]	diamond	288	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
29882729	29882729	PRJNA1166865_P_NODE_53111_length_303_cov_1.339130_g52870_i0	PRJNA1166865	53111	303	1.33913	4.0575639	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	146	2.5699999999999998e-42	NR	MBX9724270.1	2364082	g52870	i0	70.3	6.76237623762376	101	30	100	0	303	1	47	147	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	2049	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30691591	30691591	PRJNA1166865_P_NODE_88873_length_244_cov_0.900585_g88632_i0	PRJNA1166865	88873	244	0.900585	2.1974274	Bacillati	1783272	Bacteria	Bacteria	174	7.27e-49	NR	PZM80709.1	2052166	g88632	i0	100	4.91803278688525	80	0	98.4	0	242	3	480	559	PZM80709.1 MAG: alpha-glucosidase [Candidatus Melainabacteria bacterium]	diamond	1200	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
30798650	30798650	PRJNA1166865_P_NODE_65194_length_274_cov_1.179104_g64953_i0	PRJNA1166865	65194	274	1.179104	3.23074496	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	167	1.26e-45	NR	HIA52797.1	2052166	g64953	i0	100	0.952554744525547	87	0	95.3	0	14	274	324	410	HIA52797.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	261	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
31020034	31020034	PRJNA1166865_P_NODE_69295_length_264_cov_1.492147_g69054_i0	PRJNA1166865	69295	264	1.492147	3.93926808	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	169	2.05e-50	NR	PZM82884.1	2052166	g69054	i0	100	2.96590909090909	87	0	98.9	0	2	262	68	154	PZM82884.1 MAG: slipin family protein [Candidatus Melainabacteria bacterium]	diamond	783	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
31304349	31304349	PRJNA1166865_P_NODE_62975_length_279_cov_1.131068_g62734_i0	PRJNA1166865	62975	279	1.131068	3.15567972	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	69.3	2.75e-11	NR	PZM82876.1	2052166	g62734	i0	85.2	0.870967741935484	81	6	87.1	1	4	246	2170	2244	PZM82876.1 MAG: hypothetical protein DKT66_12880 [Candidatus Melainabacteria bacterium]	diamond	243	69.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
31418510	31418510	PRJNA1166865_P_NODE_89996_length_243_cov_1.670588_g89755_i0	PRJNA1166865	89996	243	1.670588	4.05952884	Bacillati	1783272	Bacteria	Bacteria	167	3.31e-46	NR	MCC6979479.1	2052166	g89755	i0	100	6	81	0	100	0	243	1	46	126	MCC6979479.1 FHA domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	1458	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
31525953	31525953	PRJNA1166865_P_NODE_85936_length_246_cov_0.867052_g85695_i0	PRJNA1166865	85936	246	0.867052	2.13294792	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	149	3.6399999999999997e-40	NR	MBC7997670.1	2052166	g85695	i0	90.1	0.98780487804878	81	8	98.8	0	244	2	505	585	MBC7997670.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium]	diamond	243	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria 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);;