metadata: contig_metadata: 22 rows where bioproject = "PRJNA640143", tax_kingdom = "Bacillati" and tax

22 rows where bioproject = "PRJNA640143", 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
1885856	1885856	PRJNA640143_S_NODE_12882_length_241_cov_261.441176_g12672_i0	PRJNA640143	12882	241	261.441176	630.07323416	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	289	1.52e-73	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g12672	i0	92.574	103.50622406639	202	14	83	1	1	201	598734	598935	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	24945	289	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
4983585	4983585	PRJNA640143_S_NODE_10664_length_264_cov_9.101322_g10454_i0	PRJNA640143	10664	264	9.101322	24.02749008	Caldilinea	233191	Bacteria	Bacteria	348	2.7500000000000004e-91	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g10454	i0	94.643	276.746212121212	224	12	85	0	40	263	3	226	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	73061	348	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
8262994	8262994	PRJNA640143_S_NODE_16247_length_216_cov_14.882682_g16037_i0	PRJNA640143	16247	216	14.882682	32.14659312	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	102	1.87e-17	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g16037	i0	96.721	12.5416666666667	61	2	28	0	123	183	9447	9387	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	2709	102	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
10814134	10814134	PRJNA640143_S_NODE_23429_length_182_cov_1.931034_g23219_i0	PRJNA640143	23429	182	1.931034	3.51448188	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	196	6.76e-46	NTclustered	gi\|2893358453\|emb\|OZ220745.1\|	2026734	g23219	i0	87.283	17.6923076923077	173	20	95	2	2	173	2300011	2299840	MAG: Dehalococcoidia bacterium isolate d99f35f8-e104-4752-81ca-da635d51ba71 genome assembly, chromosome: 1	blastn	3220	196	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
10814437	10814437	PRJNA640143_S_NODE_6929_length_319_cov_6.673759_g6719_i0	PRJNA640143	6929	319	6.673759	21.28929121	Anaerolineae bacterium	2052143	Bacteria	Bacteria	171	7.91e-38	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g6719	i0	81.951	73.166144200627	205	31	63	5	34	235	3692700	3692499	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	23340	171	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
13363777	13363777	PRJNA640143_S_NODE_10751_length_263_cov_5.442478_g10541_i0	PRJNA640143	10751	263	5.442478	14.31371714	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	403	5.75e-108	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g10541	i0	99.107	114.152091254753	224	2	85	0	8	231	596285	596508	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	30022	403	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
13909387	13909387	PRJNA640143_S_NODE_26251_length_172_cov_1.511111_g26041_i0	PRJNA640143	26251	172	1.511111	2.59911092	Bacteria	2	Bacteria	Bacteria	80.5	6.62e-11	NTclustered	gi\|2107717100\|gb\|CP070842.1\|	2026733	g26041	i0	92.727	5.80232558139535	55	4	32	0	1	55	456037	455983	MAG: Dehalococcoidales bacterium isolate bin10 chromosome	blastn	998	80.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
22286891	22286891	PRJNA640143_S_NODE_18058_length_206_cov_2.355030_g17848_i0	PRJNA640143	18058	206	2.35503	4.8513618	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	250	5.9499999999999995e-62	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g17848	i0	91.257	17.8203883495146	183	16	89	0	1	183	6889468	6889650	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	3671	250	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
23562328	23562328	PRJNA640143_S_NODE_14679_length_227_cov_3.994737_g14469_i0	PRJNA640143	14679	227	3.994737	9.06805299	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	261	3.09e-65	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g14469	i0	87.665	586.145374449339	227	25	99	3	3	227	8453	8678	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	133055	261	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
26796235	26796235	PRJNA640143_S_NODE_25321_length_175_cov_5.007246_g25111_i0	PRJNA640143	25321	175	5.007246	8.7626805	Chloroflexota bacterium	2026724	Bacteria	Bacteria	55.1	6.44e-7	NR	HKC72677.1	2026724	g25111	i0	51.7	0.994285714285714	58	21	87.4	1	158	6	131	188	HKC72677.1 cytochrome c peroxidase [Chloroflexota bacterium]	diamond	174	55.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27239000	27239000	PRJNA640143_S_NODE_28963_length_162_cov_1.208000_g28753_i0	PRJNA640143	28963	162	1.208	1.95696	Anaerolineae bacterium	2052143	Bacteria	Bacteria	72	5.42e-13	NR	HSN77056.1	2052143	g28753	i0	94.3	0.648148148148148	35	2	64.8	0	22	126	314	348	HSN77056.1 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Anaerolineae bacterium]	diamond	105	72	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28439183	28439183	PRJNA640143_S_NODE_32926_length_150_cov_1.035398_g32716_i0	PRJNA640143	32926	150	1.035398	1.553097	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	64.7	4.48e-12	NR	HLA44010.1	2952883	g32716	i0	56	1	50	22	100	0	150	1	11	60	HLA44010.1 hypothetical protein [Aggregatilineales bacterium]	diamond	150	64.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
28577819	28577819	PRJNA640143_S_NODE_14527_length_228_cov_15.481675_g14317_i0	PRJNA640143	14527	228	15.481675	35.298219	Bacteria	2	Bacteria	Bacteria	85.1	6.13e-20	NR	MDQ2655419.1	2026724	g14317	i0	95.3	2.82894736842105	43	2	56.6	0	36	164	19	61	MDQ2655419.1 SelB C-terminal domain-containing protein [Chloroflexota bacterium]	diamond	645	85.5	0.9953216374269	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29039179	29039179	PRJNA640143_S_NODE_4608_length_381_cov_3.802326_g4401_i0	PRJNA640143	4608	381	3.802326	14.48686206	Anaerolineae bacterium	2052143	Bacteria	Bacteria	138	9.44e-37	NR	MCC6606799.1	2052143	g4401	i0	95.6	0.535433070866142	68	3	53.5	0	239	36	1	68	MCC6606799.1 DUF4097 family beta strand repeat protein [Anaerolineae bacterium]	diamond	204	138	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29480653	29480653	PRJNA640143_S_NODE_19450_length_199_cov_1.604938_g19240_i0	PRJNA640143	19450	199	1.604938	3.19382662	Anaerolineae bacterium	2052143	Bacteria	Bacteria	73.6	5.18e-14	NR	HIP69882.1	2052143	g19240	i0	52.5	0.919597989949749	61	29	92	0	15	197	98	158	HIP69882.1 hypothetical protein [Anaerolineae bacterium]	diamond	183	73.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31313311	31313311	PRJNA640143_S_NODE_13855_length_234_cov_1.781726_g13645_i0	PRJNA640143	13855	234	1.781726	4.16923884	Anaerolineae bacterium	2052143	Bacteria	Bacteria	40.8	0.0467	NR	MCI0554478.1	2052143	g13645	i0	31.9	0.923076923076923	72	46	92.3	2	14	229	18	86	MCI0554478.1 nucleotide pyrophosphohydrolase [Anaerolineae bacterium]	diamond	216	40.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31661101	31661101	PRJNA640143_S_NODE_12397_length_246_cov_18.521531_g12187_i0	PRJNA640143	12397	246	18.521531	45.56296626	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	68.2	9.68e-12	NR	MDD5486726.1	2026733	g12187	i0	48.5	0.829268292682927	68	33	82.9	1	214	11	76	141	MDD5486726.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	204	68.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
32420662	32420662	PRJNA640143_S_NODE_22199_length_187_cov_1.560000_g21989_i0	PRJNA640143	22199	187	1.56	2.9172	Anaerolineales bacterium	2073117	Bacteria	Bacteria	43.5	0.00934	NR	MCA9874541.1	2073117	g21989	i0	50	0.641711229946524	40	20	64.2	0	185	66	582	621	MCA9874541.1 hypothetical protein [Anaerolineales bacterium]	diamond	120	43.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32515772	32515772	PRJNA640143_S_NODE_21999_length_188_cov_1.033113_g21789_i0	PRJNA640143	21999	188	1.033113	1.94225244	Anaerolineae bacterium	2052143	Bacteria	Bacteria	83.6	6.66e-17	NR	MCC6605898.1	2052143	g21789	i0	95.2	0.670212765957447	42	2	67	0	41	166	1	42	MCC6605898.1 hypothetical protein [Anaerolineae bacterium]	diamond	126	83.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32610239	32610239	PRJNA640143_S_NODE_6960_length_319_cov_2.042553_g6750_i0	PRJNA640143	6960	319	2.042553	6.51574407	Candidatus Leptofilum proximum	3140689	Bacteria	Bacteria	143	4.37e-40	NR	MBK8901908.1	3140689	g6750	i0	84.4	0.846394984326019	90	13	84.6	1	272	3	140	228	MBK8901908.1 S1 RNA-binding domain-containing protein [Candidatus Leptofilum proximum]	diamond	270	143	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Leptofilum	Candidatus Leptofilum proximum
32736351	32736351	PRJNA640143_S_NODE_8280_length_295_cov_3.930233_g8070_i0	PRJNA640143	8280	295	3.930233	11.59418735	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	102	9.93e-23	NR	MAU01042.1	2024896	g8070	i0	62.5	1.77966101694915	88	33	89.5	0	266	3	551	638	MAU01042.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	525	102	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
32862084	32862084	PRJNA640143_S_NODE_18200_length_205_cov_4.595238_g17990_i0	PRJNA640143	18200	205	4.595238	9.4202379	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	90.5	8.64e-20	NR	NJN83033.1	2614250	g17990	i0	67.8	1.72682926829268	59	19	86.3	0	177	1	177	235	NJN83033.1 sulfite exporter TauE/SafE family protein [Caldilineaceae bacterium]	diamond	354	90.5	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae 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);;