metadata: contig_metadata: 28 rows where bioproject = "PRJNA1086823", tax_kingdom = "Bacillati" and tax

28 rows where bioproject = "PRJNA1086823", 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
1468392	1468392	PRJNA1086823_P_NODE_17242_length_245_cov_0.906977_g17125_i0	PRJNA1086823	17242	245	0.906977	2.22209365	Chloroflexota bacterium	2026724	Bacteria	Bacteria	132	6.18e-34	NR	MDQ1323348.1	2026724	g17125	i0	89.7	2.48571428571429	68	7	83.3	0	244	41	485	552	MDQ1323348.1 bidirectional [NiFe] hydrogenase diaphorase subunit [Chloroflexota bacterium]	diamond	609	132	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
7846455	7846455	PRJNA1086823_P_NODE_18327_length_243_cov_0.917647_g18210_i0	PRJNA1086823	18327	243	0.917647	2.22988221	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	119	2.54e-30	NR	HEU5102422.1	2762507	g18210	i0	72.5	2.93827160493827	80	22	98.8	0	241	2	42	121	HEU5102422.1 Gfo/Idh/MocA family oxidoreductase [Roseiflexaceae bacterium]	diamond	714	119	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
9121276	9121276	PRJNA1086823_P_NODE_11428_length_258_cov_1.686486_g11311_i0	PRJNA1086823	11428	258	1.686486	4.35113388	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	172	1.73e-38	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g11311	i0	83.158	100.100775193798	190	30	73	2	62	249	2679265	2679454	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	25826	172	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
9121284	9121284	PRJNA1086823_P_NODE_11728_length_255_cov_2.126374_g11611_i0	PRJNA1086823	11728	255	2.126374	5.4222537	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	422	1.53e-113	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g11611	i0	96.471	580.607843137255	255	9	100	0	1	255	1859430	1859176	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	148055	422	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9121515	9121515	PRJNA1086823_P_NODE_4968_length_357_cov_1.510563_g4851_i0	PRJNA1086823	4968	357	1.510563	5.39270991	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	527	4.6099999999999984e-145	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g4851	i0	93.277	87.4985994397759	357	24	100	0	1	357	1857471	1857827	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	31237	527	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10397083	10397083	PRJNA1086823_P_NODE_1629_length_584_cov_4.230920_g1514_i0	PRJNA1086823	1629	584	4.23092	24.7085728	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	222	4.16e-53	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g1514	i0	74.781	39.4554794520548	571	106	95	33	16	568	571	21	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	23042	222	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
10397105	10397105	PRJNA1086823_P_NODE_17129_length_245_cov_0.906977_g17012_i0	PRJNA1086823	17129	245	0.906977	2.22209365	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	403	5.299999999999998e-108	NTclustered	gi\|338184653\|gb\|JF985161.1\|	166587	g17012	i0	96.341	99.469387755102	246	8	100	1	1	245	41	286	Uncultured Chloroflexi bacterium clone Paddy_8_4459 16S ribosomal RNA gene, partial sequence	blastn	24370	403	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
10397238	10397238	PRJNA1086823_P_NODE_6829_length_313_cov_1.950000_g6712_i0	PRJNA1086823	6829	313	1.95	6.1035	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	529	1.1099999999999996e-145	NTclustered	gi\|389546740\|gb\|JQ401668.1\|	166587	g6712	i0	97.125	99.4281150159744	313	9	100	0	1	313	323	11	Uncultured Chloroflexi bacterium clone CNY_01836 16S ribosomal RNA gene, partial sequence	blastn	31121	529	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
18045619	18045619	PRJNA1086823_P_NODE_6855_length_313_cov_1.075000_g6738_i0	PRJNA1086823	6855	313	1.075	3.36475	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	418	2.51e-112	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g6738	i0	90.735	644.258785942492	313	29	100	0	1	313	565862	566174	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	201653	418	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19319493	19319493	PRJNA1086823_P_NODE_16976_length_245_cov_0.906977_g16859_i0	PRJNA1086823	16976	245	0.906977	2.22209365	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	276	1.21e-69	NTclustered	gi\|2874254062\|emb\|OY970386.1\|	1672391	g16859	i0	87.449	66.6040816326531	247	21	99	9	3	245	1890453	1890693	MAG: uncultured Chloroflexia bacterium isolate MFD03726.bin.c.14 genome assembly, chromosome: 1	blastn	16318	276	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21870494	21870494	PRJNA1086823_P_NODE_12878_length_252_cov_0.871508_g12761_i0	PRJNA1086823	12878	252	0.871508	2.19620016	Anaerolineales bacterium	2073117	Bacteria	Bacteria	381	2.569999999999999e-101	NTclustered	gi\|2556910457\|gb\|CP129484.1\|	2073117	g12761	i0	94.694	1.21825396825397	245	13	97	0	8	252	1721863	1721619	MAG: Anaerolineales bacterium isolate cMAG.12 chromosome, complete genome	blastn	307	381	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
21870785	21870785	PRJNA1086823_P_NODE_9458_length_278_cov_1.351220_g9341_i0	PRJNA1086823	9458	278	1.35122	3.7563916	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	331	2.9400000000000002e-86	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g9341	i0	89.695	382.881294964029	262	24	94	3	8	267	1857810	1857550	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	106441	331	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23145853	23145853	PRJNA1086823_P_NODE_12159_length_253_cov_0.866667_g12042_i0	PRJNA1086823	12159	253	0.866667	2.19266751	Chloroflexota bacterium	2026724	Bacteria	Bacteria	129	4.48e-36	NR	NLG72210.1	2026724	g12042	i0	88.3	2.72727272727273	77	9	91.3	0	253	23	83	159	NLG72210.1 cyclic pyranopterin monophosphate synthase MoaC [Chloroflexota bacterium]	diamond	690	129	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26592442	26592442	PRJNA1086823_P_NODE_15961_length_247_cov_0.896552_g15844_i0	PRJNA1086823	15961	247	0.896552	2.21448344	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	143	6.939999999999998e-42	NR	HLC30776.1	2026734	g15844	i0	79.3	0.995951417004049	82	17	99.6	0	2	247	49	130	HLC30776.1 3TM-type holin [Dehalococcoidia bacterium]	diamond	246	143	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27478305	27478305	PRJNA1086823_P_NODE_16943_length_245_cov_0.906977_g16826_i0	PRJNA1086823	16943	245	0.906977	2.22209365	Chloroflexi bacterium RBG_16_57_11	1797651	Bacteria	Bacteria	145	1.71e-38	NR	OGO36634.1	1797651	g16826	i0	92.6	0.991836734693878	81	6	99.2	0	244	2	350	430	OGO36634.1 MAG: hypothetical protein A2W35_16610 [Chloroflexi bacterium RBG_16_57_11]	diamond	243	145	1	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium RBG_16_57_11
27509999	27509999	PRJNA1086823_P_NODE_12143_length_253_cov_0.866667_g12026_i0	PRJNA1086823	12143	253	0.866667	2.19266751	Candidatus Avedoeria danica	3140675	Bacteria	Bacteria	45.4	0.00455	NR	MBK6767969.1	3140675	g12026	i0	81.8	0.260869565217391	22	4	26.1	0	170	105	456	477	MBK6767969.1 hypothetical protein [Candidatus Avedoeria danica]	diamond	66	45.4	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Epilineales	Candidatus Epilineaceae	Candidatus Avedoeria	Candidatus Avedoeria danica
27762750	27762750	PRJNA1086823_P_NODE_13524_length_251_cov_0.876404_g13407_i0	PRJNA1086823	13524	251	0.876404	2.19977404	Chloroflexota bacterium	2026724	Bacteria	Bacteria	150	3.54e-40	NR	MBI5652903.1	2026724	g13407	i0	88	2.97609561752988	83	10	99.2	0	249	1	38	120	MBI5652903.1 glycosyltransferase family 39 protein [Chloroflexota bacterium]	diamond	747	150	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27857121	27857121	PRJNA1086823_P_NODE_11705_length_256_cov_1.054645_g11588_i0	PRJNA1086823	11705	256	1.054645	2.6998912	Chloroflexia bacterium	2448782	Bacteria	Bacteria	148	2.66e-41	NR	MFN8514720.1	2448782	g11588	i0	87.1	0.99609375	85	11	99.6	0	255	1	59	143	MFN8514720.1 selenide, water dikinase SelD [Chloroflexia bacterium]	diamond	255	148	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
28258929	28258929	PRJNA1086823_P_NODE_14246_length_250_cov_0.881356_g14129_i0	PRJNA1086823	14246	250	0.881356	2.20339	Bacteria	2	Bacteria	Bacteria	104	6.06e-24	NR	MBI3958924.1	2026724	g14129	i0	57.5	2.904	80	34	96	0	242	3	185	264	MBI3958924.1 S9 family peptidase [Chloroflexota bacterium]	diamond	726	105	0.990476190476191	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29215115	29215115	PRJNA1086823_P_NODE_16469_length_246_cov_0.901734_g16352_i0	PRJNA1086823	16469	246	0.901734	2.21826564	Chloroflexota bacterium	2026724	Bacteria	Bacteria	127	5.17e-33	NR	HEX2325813.1	2026724	g16352	i0	79	1.97560975609756	81	17	98.8	0	245	3	34	114	HEX2325813.1 amidohydrolase family protein [Chloroflexota bacterium]	diamond	486	127	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29435599	29435599	PRJNA1086823_P_NODE_17790_length_244_cov_0.912281_g17673_i0	PRJNA1086823	17790	244	0.912281	2.22596564	Chloroflexota bacterium	2026724	Bacteria	Bacteria	146	2.78e-39	NR	HET7767275.1	2026724	g17673	i0	76.5	0.995901639344262	81	19	99.6	0	1	243	184	264	HET7767275.1 ABC transporter substrate-binding protein [Chloroflexota bacterium]	diamond	243	146	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30383880	30383880	PRJNA1086823_P_NODE_17993_length_244_cov_0.912281_g17876_i0	PRJNA1086823	17993	244	0.912281	2.22596564	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	44.3	0.00319	NR	HSP56482.1	2026734	g17876	i0	42.4	2.40983606557377	66	37	81.1	1	243	46	30	94	HSP56482.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	588	44.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31109969	31109969	PRJNA1086823_P_NODE_1775_length_558_cov_2.047423_g1660_i0	PRJNA1086823	1775	558	2.047423	11.42462034	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	55.1	1.89e-5	NR	MBI9051853.1	2024896	g1660	i0	48.1	0.279569892473118	52	27	28	0	549	394	174	225	MBI9051853.1 peptidase E [Anaerolineaceae bacterium]	diamond	156	55.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
31679253	31679253	PRJNA1086823_P_NODE_12477_length_253_cov_0.866667_g12360_i0	PRJNA1086823	12477	253	0.866667	2.19266751	Chloroflexota bacterium	2026724	Bacteria	Bacteria	98.2	6.66e-22	NR	MBI3738358.1	2026724	g12360	i0	70.1	0.91304347826087	77	22	90.1	1	253	26	340	416	MBI3738358.1 DUF190 domain-containing protein [Chloroflexota bacterium]	diamond	231	98.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31900816	31900816	PRJNA1086823_P_NODE_6077_length_329_cov_1.175781_g5960_i0	PRJNA1086823	6077	329	1.175781	3.86831949	Chloroflexota bacterium	2026724	Bacteria	Bacteria	136	4.849999999999999e-38	NR	RYF28988.1	2026724	g5960	i0	62.7	0.930091185410334	102	38	93	0	328	23	27	128	RYF28988.1 MAG: hypothetical protein EOO17_03160 [Chloroflexota bacterium]	diamond	306	136	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32090681	32090681	PRJNA1086823_P_NODE_19378_length_242_cov_0.869822_g19261_i0	PRJNA1086823	19378	242	0.869822	2.10496924	Anaerolineae bacterium	2052143	Bacteria	Bacteria	90.1	7.84e-19	NR	CAG1014194.1	2052143	g19261	i0	54.4	0.979338842975207	79	36	97.9	0	238	2	202	280	CAG1014194.1 hypothetical protein ANRL4_05137 [Anaerolineae bacterium]	diamond	237	90.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32785542	32785542	PRJNA1086823_P_NODE_12380_length_253_cov_0.866667_g12263_i0	PRJNA1086823	12380	253	0.866667	2.19266751	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.9	1.31e-9	NR	MQC83261.1	2026724	g12263	i0	73.8	0.49802371541502	42	11	49.8	0	127	2	86	127	MQC83261.1 hypothetical protein [Chloroflexota bacterium]	diamond	126	63.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32785544	32785544	PRJNA1086823_P_NODE_13400_length_251_cov_0.876404_g13283_i0	PRJNA1086823	13400	251	0.876404	2.19977404	Chloroflexota bacterium	2026724	Bacteria	Bacteria	143	1.47e-41	NR	MEP7135496.1	2026724	g13283	i0	87.8	0.9800796812749	82	10	98	0	5	250	54	135	MEP7135496.1 DUF456 family protein [Chloroflexota bacterium]	diamond	246	143	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);;