metadata: contig_metadata: 34 rows where bioproject = "PRJNA994052", tax_kingdom = "Bacillati" and tax

34 rows where bioproject = "PRJNA994052", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2252053	2252053	PRJNA994052_P_NODE_71662_length_210_cov_58.744526_g70406_i0	PRJNA994052	71662	210	58.744526	123.3635046	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	76.8	1.09e-9	NTclustered	gi\|2626216229\|emb\|OY821634.1\|	2026734	g70406	i0	85.333	6.23809523809524	75	10	35	1	135	208	2458634	2458560	MAG: Dehalococcoidia bacterium isolate 1c9b0e2f-99e9-4817-8d5d-eeea35646e5a genome assembly, chromosome: 1	blastn	1310	76.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
4804780	4804780	PRJNA994052_P_NODE_81064_length_199_cov_90.896825_g79807_i0	PRJNA994052	81064	199	90.896825	180.88468175	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	147	7.699999999999999e-31	NTclustered	gi\|2621701266\|emb\|OY759986.1\|	2952883	g79807	i0	81.319	8.57788944723618	182	32	91	2	12	192	53594	53414	MAG: Aggregatilineales bacterium isolate 77605d95-9063-427a-b0a2-1f26f0f1d72f genome assembly, chromosome: 1	blastn	1707	147	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
6079865	6079865	PRJNA994052_P_NODE_62685_length_222_cov_20.483221_g61429_i0	PRJNA994052	62685	222	20.483221	45.47275062	Caldilinea	233191	Bacteria	Bacteria	109	5.56e-26	NR	HAJ37263.1	2026724	g61429	i0	70.8	6.82432432432432	72	21	97.3	0	5	220	75	146	HAJ37263.1 NADH:flavin oxidoreductase [Chloroflexota bacterium]	diamond	1515	110	0.990909090909091	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
6079998	6079998	PRJNA994052_P_NODE_76025_length_205_cov_30.424242_g74769_i0	PRJNA994052	76025	205	30.424242	62.3696961	Thermoflexales bacterium	2497639	Bacteria	Bacteria	103	4.53e-27	NR	MBP8240862.1	2497639	g74769	i0	98.1	0.760975609756098	52	1	76.1	0	8	163	24	75	MBP8240862.1 hypothetical protein [Thermoflexales bacterium]	diamond	156	103	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales			Thermoflexales bacterium
20103163	20103163	PRJNA994052_P_NODE_60616_length_225_cov_20.664474_g59360_i0	PRJNA994052	60616	225	20.664474	46.4950665	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	137	4.55e-40	NR	MBP8292865.1	2614250	g59360	i0	97.2	0.946666666666667	71	2	94.7	0	11	223	5	75	MBP8292865.1 hypothetical protein [Caldilineaceae bacterium]	diamond	213	137	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
26646356	26646356	PRJNA994052_P_NODE_34981_length_269_cov_47.551020_g33736_i0	PRJNA994052	34981	269	47.55102	127.9122438	Chloroflexota bacterium	2026724	Bacteria	Bacteria	53.1	5.21e-6	NR	MBI4496850.1	2026724	g33736	i0	50.8	0.680297397769517	61	29	68	1	84	266	110	169	MBI4496850.1 hypothetical protein [Chloroflexota bacterium]	diamond	183	53.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26678011	26678011	PRJNA994052_P_NODE_77181_length_204_cov_7.290076_g75924_i0	PRJNA994052	77181	204	7.290076	14.87175504	Anaerolineae bacterium	2052143	Bacteria	Bacteria	103	1.54e-26	NR	MFN8374661.1	2052143	g75924	i0	77.6	0.985294117647059	67	15	98.5	0	202	2	58	124	MFN8374661.1 hypothetical protein [Anaerolineae bacterium]	diamond	201	103	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
26900020	26900020	PRJNA994052_P_NODE_56541_length_231_cov_21.867089_g55286_i0	PRJNA994052	56541	231	21.867089	50.51297559	Chloroflexota bacterium	2026724	Bacteria	Bacteria	69.7	5.48e-14	NR	MEZ4596620.1	2026724	g55286	i0	81	0.545454545454545	42	8	54.5	0	91	216	1	42	MEZ4596620.1 hypothetical protein [Chloroflexota bacterium]	diamond	126	69.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27063946	27063946	PRJNA994052_P_NODE_39882_length_259_cov_12.715054_g38636_i0	PRJNA994052	39882	259	12.715054	32.93198986	PVC group	1783257	Bacteria	Bacteria	63.2	6.08e-10	NR	OGO11459.1	1797639	g38636	i0	42.4	2.96525096525097	85	42	90.3	2	250	17	52	136	OGO11459.1 MAG: hypothetical protein A2Y53_00130 [Chloroflexi bacterium RBG_16_47_49]	diamond	768	63.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium RBG_16_47_49
27847650	27847650	PRJNA994052_P_NODE_19244_length_310_cov_34.379747_g18021_i0	PRJNA994052	19244	310	34.379747	106.5772157	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.9	0.00335	NR	MBI2322983.1	2026724	g18021	i0	35.6	1.22903225806452	45	29	43.5	0	299	165	20	64	MBI2322983.1 hypothetical protein [Chloroflexota bacterium]	diamond	381	43.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28542647	28542647	PRJNA994052_P_NODE_74447_length_207_cov_20.201493_g73191_i0	PRJNA994052	74447	207	20.201493	41.81709051	Anaerolineales bacterium	2073117	Bacteria	Bacteria	68.9	2.78e-12	NR	HQV63587.1	2073117	g73191	i0	48.4	0.898550724637681	62	32	89.9	0	17	202	79	140	HQV63587.1 hypothetical protein [Anaerolineales bacterium]	diamond	186	68.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
28763349	28763349	PRJNA994052_P_NODE_74667_length_207_cov_6.238806_g73411_i0	PRJNA994052	74667	207	6.238806	12.91432842	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	48.9	1.58e-4	NR	HJT54852.1	2740538	g73411	i0	58.1	3.82608695652174	31	13	44.9	0	99	7	432	462	HJT54852.1 EsaB/YukD family protein [Ktedonobacteraceae bacterium]	diamond	792	48.9	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
29268443	29268443	PRJNA994052_P_NODE_20329_length_308_cov_20.710638_g19103_i0	PRJNA994052	20329	308	20.710638	63.78876504	Anaerolineae bacterium	2052143	Bacteria	Bacteria	82	1.32e-15	NR	MEZ4669283.1	2052143	g19103	i0	84.8	0.448051948051948	46	7	44.8	0	163	300	14	59	MEZ4669283.1 tetratricopeptide repeat protein [Anaerolineae bacterium]	diamond	138	82	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29300202	29300202	PRJNA994052_P_NODE_15189_length_313_cov_9.591667_g13968_i0	PRJNA994052	15189	313	9.591667	30.02191771	Herpetosiphon sp.	71864	Bacteria	Bacteria	74.7	5.32e-13	NR	WP_287044914.1	71864	g13968	i0	71.1	0.862619808306709	45	12	42.2	1	164	295	456	500	WP_287044914.1 RHS repeat-associated core domain-containing protein [Herpetosiphon sp.]	diamond	270	74.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon sp.
29615594	29615594	PRJNA994052_P_NODE_32510_length_275_cov_37.178218_g31266_i0	PRJNA994052	32510	275	37.178218	102.2400995	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	85.1	7.1e-17	NR	MFN8489237.1	2614250	g31266	i0	51.6	1.03636363636364	95	42	99.3	2	275	3	338	432	MFN8489237.1 ABC transporter substrate-binding protein [Caldilineaceae bacterium]	diamond	285	85.1	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
29615608	29615608	PRJNA994052_P_NODE_67010_length_216_cov_40.615385_g65754_i0	PRJNA994052	67010	216	40.615385	87.7292316	Anaerolineales bacterium	2073117	Bacteria	Bacteria	41.2	0.0204	NR	HZM24852.1	2073117	g65754	i0	42.9	0.583333333333333	42	24	58.3	0	212	87	34	75	HZM24852.1 hypothetical protein [Anaerolineales bacterium]	diamond	126	41.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29647113	29647113	PRJNA994052_P_NODE_15730_length_312_cov_31.334728_g14509_i0	PRJNA994052	15730	312	31.334728	97.76435136	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.4	0.00858	NR	MBI5671290.1	2026724	g14509	i0	45.7	0.442307692307692	46	25	44.2	0	144	7	36	81	MBI5671290.1 3'-5' exonuclease [Chloroflexota bacterium]	diamond	138	45.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30121118	30121118	PRJNA994052_P_NODE_20852_length_307_cov_12.961538_g19625_i0	PRJNA994052	20852	307	12.961538	39.79192166	Caldilinea sp. CFX5	2293554	Bacteria	Bacteria	131	3.5700000000000004e-33	NR	MCE7988670.1	2293554	g19625	i0	46.5	1.66123778501629	170	22	98.7	1	304	2	215	384	MCE7988670.1 hypothetical protein [Caldilinea sp. CFX5]	diamond	510	131	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp. CFX5
30215903	30215903	PRJNA994052_P_NODE_51712_length_238_cov_66.393939_g50457_i0	PRJNA994052	51712	238	66.393939	158.01757482	Anaerolineales bacterium	2073117	Bacteria	Bacteria	100	2.17e-22	NR	HLE92731.1	2073117	g50457	i0	65.8	0.957983193277311	76	22	90.8	2	21	236	345	420	HLE92731.1 phage major capsid protein [Anaerolineales bacterium]	diamond	228	100	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30658403	30658403	PRJNA994052_P_NODE_44773_length_250_cov_4.881356_g43524_i0	PRJNA994052	44773	250	4.881356	12.20339	Anaerolineae bacterium	2052143	Bacteria	Bacteria	66.2	2.09e-10	NR	MBC8097902.1	2052143	g43524	i0	43.4	0.996	83	42	93.6	2	3	236	210	292	MBC8097902.1 hypothetical protein [Anaerolineae bacterium]	diamond	249	66.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30695797	30695797	PRJNA994052_P_NODE_18693_length_311_cov_15.306723_g17471_i0	PRJNA994052	18693	311	15.306723	47.60390853	Bacillati	1783272	Bacteria	Bacteria	101	9.09e-25	NR	HOU23988.1	2052143	g17471	i0	100	0.964630225080386	50	0	48.2	0	151	2	103	152	HOU23988.1 replication protein RepA [Anaerolineae bacterium]	diamond	300	101	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31011797	31011797	PRJNA994052_P_NODE_26534_length_291_cov_10.032110_g25294_i0	PRJNA994052	26534	291	10.03211	29.1934401	Bacteria	2	Bacteria	Bacteria	90.9	1.53e-19	NR	MCW5856709.1	2306055	g25294	i0	55.6	6.43298969072165	81	36	83.5	0	2	244	198	278	MCW5856709.1 hypothetical protein [Caldilineales bacterium]	diamond	1872	90.9	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales			Caldilineales bacterium
31037858	31037858	PRJNA994052_P_NODE_19735_length_309_cov_39.711864_g18512_i0	PRJNA994052	19735	309	39.711864	122.70965976	Anaerolineae bacterium	2052143	Bacteria	Bacteria	99.8	2.21e-22	NR	MEZ4670920.1	2052143	g18512	i0	96	0.485436893203884	50	2	48.5	0	307	158	142	191	MEZ4670920.1 ABC transporter substrate-binding protein [Anaerolineae bacterium]	diamond	150	99.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31037868	31037868	PRJNA994052_P_NODE_69235_length_213_cov_53.014286_g67979_i0	PRJNA994052	69235	213	53.014286	112.92042918	Flexilinea sp.	2017390	Bacteria	Bacteria	44.7	0.00393	NR	MBQ6502468.1	2017390	g67979	i0	36.5	0.732394366197183	52	33	73.2	0	208	53	131	182	MBQ6502468.1 hypothetical protein [Flexilinea sp.]	diamond	156	44.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Flexilinea	Flexilinea sp.
31132038	31132038	PRJNA994052_P_NODE_60555_length_225_cov_27.230263_g59299_i0	PRJNA994052	60555	225	27.230263	61.26809175	Anaerolineales bacterium	2073117	Bacteria	Bacteria	68.2	2.82e-11	NR	MBX3035500.1	2073117	g59299	i0	79.5	1.56	39	8	52	0	210	94	323	361	MBX3035500.1 membrane dipeptidase [Anaerolineales bacterium]	diamond	351	68.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31232832	31232832	PRJNA994052_P_NODE_53295_length_236_cov_8.865031_g52040_i0	PRJNA994052	53295	236	8.865031	20.92147316	Bacteria	2	Bacteria	Bacteria	74.3	1.23e-13	NR	MBN8620615.1	2052143	g52040	i0	89.7	2.47881355932203	39	4	49.6	0	232	116	258	296	MBN8620615.1 carbohydrate ABC transporter permease [Anaerolineae bacterium]	diamond	585	74.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31321964	31321964	PRJNA994052_P_NODE_22835_length_301_cov_28.486842_g21606_i0	PRJNA994052	22835	301	28.486842	85.74539442	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	78.2	1.07e-16	NR	RPJ58836.1	2026734	g21606	i0	65.3	0.966777408637874	49	17	48.8	0	149	3	11	59	RPJ58836.1 MAG: hypothetical protein EHM12_07470, partial [Dehalococcoidia bacterium]	diamond	291	78.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31321967	31321967	PRJNA994052_P_NODE_48435_length_244_cov_1.608187_g47183_i0	PRJNA994052	48435	244	1.608187	3.92397628	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	100	2.39e-22	NR	MCB0072610.1	2614250	g47183	i0	61.3	0.922131147540984	75	29	92.2	0	233	9	663	737	MCB0072610.1 phage portal protein [Caldilineaceae bacterium]	diamond	225	100	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
31827945	31827945	PRJNA994052_P_NODE_60137_length_226_cov_7.235294_g58881_i0	PRJNA994052	60137	226	7.235294	16.35176444	Chloroflexota bacterium	2026724	Bacteria	Bacteria	83.2	1.59e-16	NR	NLH06981.1	2026724	g58881	i0	54.9	0.942477876106195	71	32	94.2	0	8	220	49	119	NLH06981.1 terminase [Chloroflexota bacterium]	diamond	213	83.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32081175	32081175	PRJNA994052_P_NODE_81598_length_199_cov_9.611111_g80341_i0	PRJNA994052	81598	199	9.611111	19.12611089	Anaerolineae bacterium	2052143	Bacteria	Bacteria	41.6	0.0495	NR	MEZ4670015.1	2052143	g80341	i0	72	0.376884422110553	25	7	37.7	0	192	118	208	232	MEZ4670015.1 SHOCT domain-containing protein [Anaerolineae bacterium]	diamond	75	41.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32429361	32429361	PRJNA994052_P_NODE_19739_length_309_cov_39.046610_g18516_i0	PRJNA994052	19739	309	39.04661	120.6540249	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	142	1.91e-41	NR	MBP8294344.1	2614250	g18516	i0	77.5	0.990291262135922	102	21	99	1	2	307	9	108	MBP8294344.1 hypothetical protein [Caldilineaceae bacterium]	diamond	306	142	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
32461022	32461022	PRJNA994052_P_NODE_14719_length_313_cov_40.750000_g13498_i0	PRJNA994052	14719	313	40.75	127.5475	Anaerolineae bacterium	2052143	Bacteria	Bacteria	66.2	4.81e-11	NR	GIV81703.1	2052143	g13498	i0	58.3	0.460063897763578	48	20	46	0	150	7	63	110	GIV81703.1 MAG: hypothetical protein KatS3mg051_1057 [Anaerolineae bacterium]	diamond	144	66.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32650025	32650025	PRJNA994052_P_NODE_70100_length_212_cov_47.489209_g68844_i0	PRJNA994052	70100	212	47.489209	100.67712308	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	42.4	0.0342	NR	HLQ00328.1	3047546	g68844	i0	49	0.721698113207547	51	21	72.2	1	177	25	4	49	HLQ00328.1 membrane protein insertase YidC [Candidatus Limnocylindria bacterium]	diamond	153	42.4	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
32870733	32870733	PRJNA994052_P_NODE_15000_length_313_cov_18.808333_g13779_i0	PRJNA994052	15000	313	18.808333	58.87008229	Chloroflexota bacterium	2026724	Bacteria	Bacteria	57	8.63e-7	NR	NWF70226.1	2026724	g13779	i0	61.2	1.36102236421725	49	19	47	0	312	166	624	672	NWF70226.1 protein kinase [Chloroflexota bacterium]	diamond	426	57	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota 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);;