metadata: contig_metadata: 19 rows where bioproject = "PRJNA914897", tax_kingdom = "Bacillati" and tax

19 rows where bioproject = "PRJNA914897", 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_species
2526648	2526648	PRJNA914897_P_NODE_4622_length_933_cov_9.388372_g4300_i0	PRJNA914897	4622	933	9.388372	87.59351076	FCB group	1783270	Bacteria	Bacteria	101	5.7500000000000005e-21	NR	OGO04966.1	1797630	g4300	i0	37.9	1.80707395498392	153	90	49.2	2	489	31	125	272	OGO04966.1 MAG: hypothetical protein A2Y91_04580 [Chloroflexi bacterium RBG_13_54_8]	diamond	1686	102	0.990196078431373	Bacteria	Bacillati	Chloroflexota				Chloroflexi bacterium RBG_13_54_8
16197895	16197895	PRJNA914897_P_NODE_40553_length_244_cov_1.707602_g40129_i0	PRJNA914897	40553	244	1.707602	4.16654888	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	206	1.6e-48	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g40129	i0	85.572	311.520491803279	201	23	81	5	28	224	240390	240192	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	76011	206	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
25121078	25121078	PRJNA914897_P_NODE_40620_length_244_cov_1.350877_g40196_i0	PRJNA914897	40620	244	1.350877	3.29613988	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	363	8.949999999999999e-96	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g40196	i0	93.443	123.377049180328	244	16	100	0	1	244	2093153	2093396	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	30104	363	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
27277517	27277517	PRJNA914897_P_NODE_16243_length_434_cov_3.717452_g15821_i0	PRJNA914897	16243	434	3.717452	16.13374168	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	57.8	1.56e-6	NR	MEZ4731472.1	2614250	g15821	i0	35.6	2.42626728110599	87	54	58.8	1	348	94	439	525	MEZ4731472.1 interleukin-like EMT inducer domain-containing protein [Caldilineaceae bacterium]	diamond	1053	57.8	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium
27593427	27593427	PRJNA914897_P_NODE_23524_length_340_cov_1.441948_g23100_i0	PRJNA914897	23524	340	1.441948	4.9026232	Chloroflexota bacterium	2026724	Bacteria	Bacteria	123	5.17e-30	NR	MBI2867192.1	2026724	g23100	i0	50	3.87352941176471	112	56	98.8	0	337	2	451	562	MBI2867192.1 elongation factor 4 [Chloroflexota bacterium]	diamond	1317	123	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27593432	27593432	PRJNA914897_P_NODE_27764_length_304_cov_2.320346_g27340_i0	PRJNA914897	27764	304	2.320346	7.05385184	Anaerolineae bacterium	2052143	Bacteria	Bacteria	50.4	1.44e-4	NR	MBE2220790.1	2052143	g27340	i0	31.9	2.03289473684211	91	55	89.8	2	298	26	178	261	MBE2220790.1 hypothetical protein [Anaerolineae bacterium]	diamond	618	50.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28635446	28635446	PRJNA914897_P_NODE_26147_length_317_cov_1.430328_g25723_i0	PRJNA914897	26147	317	1.430328	4.53413976	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.5	0.0445	NR	MFH0941672.1	2026724	g25723	i0	34.9	0.813880126182965	86	51	81.4	2	311	54	30	110	MFH0941672.1 MiaB/RimO family radical SAM methylthiotransferase [Chloroflexota bacterium]	diamond	258	43.5	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28729969	28729969	PRJNA914897_P_NODE_29647_length_290_cov_1.364055_g29223_i0	PRJNA914897	29647	290	1.364055	3.9557595	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	44.3	0.0191	NR	HEY1389341.1	2306968	g29223	i0	35.6	1.86206896551724	90	55	92.1	2	287	21	892	979	HEY1389341.1 Ig-like domain repeat protein [Ktedonobacterales bacterium]	diamond	540	44.3	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales		Ktedonobacterales bacterium
29203703	29203703	PRJNA914897_P_NODE_17289_length_417_cov_1.409884_g16867_i0	PRJNA914897	17289	417	1.409884	5.87921628	Anaerolineales bacterium	2073117	Bacteria	Bacteria	48.5	0.00215	NR	HVN16980.1	2073117	g16867	i0	34.5	0.60431654676259	84	54	60.4	1	5	256	148	230	HVN16980.1 HD domain-containing protein [Anaerolineales bacterium]	diamond	252	48.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
29242497	29242497	PRJNA914897_P_NODE_4509_length_944_cov_29.938002_g4192_i0	PRJNA914897	4509	944	29.938002	282.61473888	Bacteria	2	Bacteria	Bacteria	328	6.679999999999999e-109	NR	MDA1175223.1	2026724	g4192	i0	57.7	19.5444915254237	279	114	88.7	1	11	847	6	280	MDA1175223.1 aldolase/citrate lyase family protein [Chloroflexota bacterium]	diamond	18450	331	0.990936555891239	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30537450	30537450	PRJNA914897_P_NODE_11713_length_539_cov_2.776824_g11293_i0	PRJNA914897	11713	539	2.776824	14.96708136	Bacillati	1783272	Bacteria	Bacteria	89	4.24e-18	NR	MBI4328609.1	2026724	g11293	i0	33.9	4.64749536178108	177	106	96.3	3	18	536	38	207	MBI4328609.1 MIP family channel protein [Chloroflexota bacterium]	diamond	2505	89.4	0.995525727069351	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30751307	30751307	PRJNA914897_P_NODE_25274_length_324_cov_2.095618_g24850_i0	PRJNA914897	25274	324	2.095618	6.78980232	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.9	1.33e-7	NR	MEC8945559.1	2026724	g24850	i0	48.1	0.731481481481482	79	38	73.1	2	291	55	54	129	MEC8945559.1 pyrroline-5-carboxylate reductase [Chloroflexota bacterium]	diamond	237	58.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30790186	30790186	PRJNA914897_P_NODE_8334_length_667_cov_1.707071_g7930_i0	PRJNA914897	8334	667	1.707071	11.38616357	Bacteria	2	Bacteria	Bacteria	50.8	0.00145	NR	RMG70454.1	2026724	g7930	i0	43.9	0.782608695652174	41	23	18.4	0	288	410	176	216	RMG70454.1 MAG: TIGR01777 family protein [Chloroflexota bacterium]	diamond	522	50.8	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30846063	30846063	PRJNA914897_P_NODE_25814_length_320_cov_1.246964_g25390_i0	PRJNA914897	25814	320	1.246964	3.9902848	Caldilineaceae bacterium SB0661_bin_32	2605255	Bacteria	Bacteria	43.9	0.0335	NR	MYC97119.1	2605255	g25390	i0	33.3	0.84375	90	54	80.6	2	296	39	297	384	MYC97119.1 sigma-70 family RNA polymerase sigma factor [Caldilineaceae bacterium SB0661_bin_32]	diamond	270	43.9	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium SB0661_bin_32
31256768	31256768	PRJNA914897_P_NODE_11075_length_559_cov_1.220165_g10655_i0	PRJNA914897	11075	559	1.220165	6.82072235	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	70.5	2.19e-10	NR	MCB9432494.1	2614247	g10655	i0	33.8	2.54919499105546	130	70	67.1	5	385	11	63	181	MCB9432494.1 protein kinase [Ardenticatenaceae bacterium]	diamond	1425	70.5	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
31667939	31667939	PRJNA914897_P_NODE_40737_length_244_cov_0.900585_g40313_i0	PRJNA914897	40737	244	0.900585	2.1974274	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	120	4.3e-31	NR	HEX9634001.1	3047546	g40313	i0	77.5	5.9016393442623	80	18	98.4	0	3	242	233	312	HEX9634001.1 histone deacetylase [Candidatus Limnocylindria bacterium]	diamond	1440	120	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria			Candidatus Limnocylindria bacterium
32015954	32015954	PRJNA914897_P_NODE_18878_length_394_cov_0.953271_g18456_i0	PRJNA914897	18878	394	0.953271	3.75588774	Anaerolineales bacterium	2073117	Bacteria	Bacteria	95.1	3.6e-20	NR	MCC7361690.1	2073117	g18456	i0	40.8	3.01522842639594	130	76	98.2	1	4	390	112	241	MCC7361690.1 aldo/keto reductase [Anaerolineales bacterium]	diamond	1188	95.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
32459130	32459130	PRJNA914897_P_NODE_42539_length_241_cov_0.916667_g42115_i0	PRJNA914897	42539	241	0.916667	2.20916747	Anaerolineae bacterium	2052143	Bacteria	Bacteria	47.8	2.4e-4	NR	MFN8423645.1	2052143	g42115	i0	40.8	1.49377593360996	71	33	83.4	3	206	6	44	109	MFN8423645.1 FHA domain-containing protein [Anaerolineae bacterium]	diamond	360	47.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
32774226	32774226	PRJNA914897_P_NODE_17360_length_416_cov_0.886297_g16938_i0	PRJNA914897	17360	416	0.886297	3.68699552	Chloroflexota bacterium	2026724	Bacteria	Bacteria	79	2.14e-15	NR	MBI1259600.1	2026724	g16938	i0	47.1	2.97836538461538	87	42	62.7	2	261	1	28	110	MBI1259600.1 hypothetical protein [Chloroflexota bacterium]	diamond	1239	79	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);;