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

19 rows where bioproject = "PRJNA986481", 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
16276148	16276148	PRJNA986481_P_NODE_16333_length_406_cov_3.014006_g15808_i0	PRJNA986481	16333	406	3.014006	12.23686436	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	200	1.31e-46	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15808	i0	87.931	0.583743842364532	174	15	57	3	132	299	3099938	3100111	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	237	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
16276405	16276405	PRJNA986481_P_NODE_32533_length_286_cov_5.202532_g32008_i0	PRJNA986481	32533	286	5.202532	14.87924152	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	462	1.03e-125	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g32008	i0	95.804	137.416083916084	286	12	100	0	1	286	3682448	3682163	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	39301	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
18825228	18825228	PRJNA986481_P_NODE_29295_length_302_cov_8.102767_g28770_i0	PRJNA986481	29295	302	8.102767	24.47035634	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	505	1.7999999999999995e-138	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g28770	i0	97.01	119.370860927152	301	8	99	1	1	301	3682727	3682428	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	36050	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
18825671	18825671	PRJNA986481_P_NODE_57035_length_244_cov_2.102564_g56510_i0	PRJNA986481	57035	244	2.102564	5.13025616	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g56510	i0	92.308	0.159836065573771	39	1	16	2	32	70	711003	710967	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	39	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
20100362	20100362	PRJNA986481_P_NODE_54996_length_247_cov_1.020202_g54471_i0	PRJNA986481	54996	247	1.020202	2.51989894	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	144	9.67e-38	NR	MBX9567657.1	2364082	g54471	i0	93.7	0.959514170040486	79	5	96	0	239	3	643	721	MBX9567657.1 glycogen/starch/alpha-glucan phosphorylase [Candidatus Obscuribacterales bacterium]	diamond	237	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27279368	27279368	PRJNA986481_P_NODE_43803_length_259_cov_0.961905_g43278_i0	PRJNA986481	43803	259	0.961905	2.49133395	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	103	1.0199999999999999e-23	NR	MBK8225287.1	2711154	g43278	i0	54.8	1.94594594594595	84	38	97.3	0	3	254	61	144	MBK8225287.1 transposase [Candidatus Obscuribacter sp.]	diamond	504	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27500531	27500531	PRJNA986481_P_NODE_39003_length_265_cov_0.935185_g38478_i0	PRJNA986481	39003	265	0.935185	2.47824025	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	143	1.47e-39	NR	MBX9722290.1	2364082	g38478	i0	86.2	2.95471698113208	87	12	98.5	0	3	263	162	248	MBX9722290.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	783	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27595265	27595265	PRJNA986481_P_NODE_59764_length_241_cov_2.072917_g59239_i0	PRJNA986481	59764	241	2.072917	4.99572997	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	86.7	1.21e-17	NR	MBX9666278.1	2364082	g59239	i0	59.7	2.77593360995851	77	27	95.9	1	239	9	3	75	MBX9666278.1 FAD-dependent monooxygenase [Candidatus Obscuribacterales bacterium]	diamond	669	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28479219	28479219	PRJNA986481_P_NODE_21226_length_356_cov_1.315961_g20701_i0	PRJNA986481	21226	356	1.315961	4.68482116	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	177	6.95e-51	NR	RTL35142.1	2052166	g20701	i0	70.5	7.82022471910112	112	33	94.4	0	350	15	247	358	RTL35142.1 MAG: putrescine aminotransferase [Candidatus Melainabacteria bacterium]	diamond	2784	177	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
28573843	28573843	PRJNA986481_P_NODE_49607_length_253_cov_0.990196_g49082_i0	PRJNA986481	49607	253	0.990196	2.50519588	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	153	3.189999999999999e-42	NR	MBX9687239.1	2364082	g49082	i0	85.7	0.99604743083004	84	12	99.6	0	253	2	126	209	MBX9687239.1 MBL fold metallo-hydrolase [Candidatus Obscuribacterales bacterium]	diamond	252	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28763235	28763235	PRJNA986481_P_NODE_37627_length_267_cov_0.926606_g37102_i0	PRJNA986481	37627	267	0.926606	2.47403802	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	102	3.07e-25	NR	MBX9689602.1	2364082	g37102	i0	79.3	0.651685393258427	58	12	65.2	0	265	92	129	186	MBX9689602.1 dTDP-4-dehydrorhamnose 3,5-epimerase [Candidatus Obscuribacterales bacterium]	diamond	174	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29331657	29331657	PRJNA986481_P_NODE_23129_length_341_cov_1.801370_g22604_i0	PRJNA986481	23129	341	1.80137	6.1426717	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	164	6.92e-47	NR	MBX9940161.1	2364082	g22604	i0	74	6.48387096774194	100	26	88	0	7	306	72	171	MBX9940161.1 pirin family protein [Candidatus Obscuribacterales bacterium]	diamond	2211	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29394917	29394917	PRJNA986481_P_NODE_59489_length_242_cov_1.046632_g58964_i0	PRJNA986481	59489	242	1.046632	2.53284944	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	117	7.62e-30	NR	MBX3072339.1	2364082	g58964	i0	72.5	0.991735537190083	80	22	99.2	0	2	241	225	304	MBX3072339.1 HAD family hydrolase [Candidatus Obscuribacterales bacterium]	diamond	240	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29773571	29773571	PRJNA986481_P_NODE_35951_length_272_cov_1.798206_g35426_i0	PRJNA986481	35951	272	1.798206	4.89112032	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	104	8.000000000000001e-24	NR	MBX9688754.1	2364082	g35426	i0	62.2	0.992647058823529	90	32	97.1	1	9	272	6	95	MBX9688754.1 response regulator [Candidatus Obscuribacterales bacterium]	diamond	270	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29900172	29900172	PRJNA986481_P_NODE_1231_length_1201_cov_3.075521_g1010_i0	PRJNA986481	1231	1201	3.075521	36.93700721	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	128	1.4399999999999998e-30	NR	HEY9814218.1	2364082	g1010	i0	34.1	0.636969192339717	255	151	62.7	9	1028	276	17	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	765	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30595000	30595000	PRJNA986481_P_NODE_48113_length_254_cov_0.985366_g47588_i0	PRJNA986481	48113	254	0.985366	2.50282964	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	145	7.45e-39	NR	MBX9724476.1	2364082	g47588	i0	76.2	1.99606299212598	84	20	99.2	0	254	3	191	274	MBX9724476.1 porin [Candidatus Obscuribacterales bacterium]	diamond	507	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30853810	30853810	PRJNA986481_P_NODE_29814_length_300_cov_1.207171_g29289_i0	PRJNA986481	29814	300	1.207171	3.621513	Bacteria	2	Bacteria	Bacteria	147	9.98e-40	NR	MCC6980616.1	2052166	g29289	i0	75.8	9.49	95	21	95	1	3	287	161	253	MCC6980616.1 aspartate aminotransferase family protein [Candidatus Melainabacteria bacterium]	diamond	2847	148	0.993243243243243	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
31638170	31638170	PRJNA986481_P_NODE_60236_length_241_cov_1.052083_g59711_i0	PRJNA986481	60236	241	1.052083	2.53552003	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	166	1.32e-51	NR	HIN65447.1	2364082	g59711	i0	100	0.995850622406639	80	0	99.6	0	241	2	4	83	HIN65447.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	240	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31733026	31733026	PRJNA986481_P_NODE_49537_length_253_cov_0.990196_g49012_i0	PRJNA986481	49537	253	0.990196	2.50519588	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	65.9	2.75e-11	NR	MBX9688519.1	2364082	g49012	i0	53.8	0.616600790513834	52	24	61.7	0	97	252	4	55	MBX9688519.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	156	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;