metadata: contig_metadata: 27 rows where bioproject = "PRJNA674050", tax_phylum = "Chloroflexota" and tax

27 rows where bioproject = "PRJNA674050", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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
3194674	3194674	PRJNA674050_P_NODE_26663_length_249_cov_1.664773_g26460_i0	PRJNA674050	26663	249	1.664773	4.14528477	Anaerolineales bacterium	2073117	Bacteria	Bacteria	399	6.989999999999999e-107	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g26460	i0	95.582	184.911646586345	249	11	100	0	1	249	2030127	2029879	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	46043	399	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
4472486	4472486	PRJNA674050_P_NODE_8744_length_309_cov_2.631356_g8541_i0	PRJNA674050	8744	309	2.631356	8.13089004	Anaerolineales bacterium	2073117	Bacteria	Bacteria	462	1.12e-125	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g8541	i0	93.831	272.11003236246	308	17	99	2	2	309	2029552	2029857	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	84082	462	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
5747605	5747605	PRJNA674050_P_NODE_3565_length_385_cov_2.394231_g3362_i0	PRJNA674050	3565	385	2.394231	9.21778935	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	390	6.86e-104	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g3362	i0	86.517	618.875324675325	356	47	92	1	29	384	2827800	2827446	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	238267	390	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
7544175	7544175	PRJNA674050_P_NODE_12066_length_288_cov_1.395349_g11863_i0	PRJNA674050	12066	288	1.395349	4.01860512	Tepidiforma	2682228	Bacteria	Bacteria	449	8.090000000000001e-122	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g11863	i0	94.792	240.555555555556	288	15	100	0	1	288	2204644	2204931	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	69280	449	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
8296981	8296981	PRJNA674050_P_NODE_2307_length_448_cov_2.528000_g2104_i0	PRJNA674050	2307	448	2.528	11.32544	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	497	4.64e-136	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g2104	i0	86.83	394	448	56	99	3	2	448	10391	10836	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	176512	497	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
8297122	8297122	PRJNA674050_P_NODE_26747_length_249_cov_1.448864_g26544_i0	PRJNA674050	26747	249	1.448864	3.60767136	Bacillati	1783272	Bacteria	Bacteria	162	9.63e-47	NR	MAS34095.1	2024896	g26544	i0	95.2	3	83	4	100	0	1	249	54	136	MAS34095.1 cyclic nucleotide-binding protein [Anaerolineaceae bacterium]	diamond	747	162	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
8297793	8297793	PRJNA674050_P_NODE_7027_length_324_cov_4.394422_g6824_i0	PRJNA674050	7027	324	4.394422	14.23792728	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	279	1.28e-70	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g6824	i0	83.077	63.2654320987654	325	37	97	13	1	315	2203450	2203766	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	20498	279	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
9571752	9571752	PRJNA674050_P_NODE_10688_length_295_cov_4.918919_g10485_i0	PRJNA674050	10688	295	4.918919	14.51081105	Anaerolineales bacterium	2073117	Bacteria	Bacteria	379	1.11e-100	NTclustered	gi\|2108400823\|gb\|CP070639.1\|	2073117	g10485	i0	89.933	116.959322033898	298	24	100	6	1	295	3337161	3336867	MAG: Anaerolineales bacterium isolate bin917 chromosome	blastn	34503	379	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
9571832	9571832	PRJNA674050_P_NODE_13128_length_283_cov_1.842857_g12925_i0	PRJNA674050	13128	283	1.842857	5.21528531	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	444	3.69e-120	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g12925	i0	95.035	433.611307420495	282	14	99	0	1	282	2202816	2203097	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	122712	444	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
13397725	13397725	PRJNA674050_P_NODE_2251_length_452_cov_3.889182_g2048_i0	PRJNA674050	2251	452	3.889182	17.57910264	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	460	6.14e-125	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g2048	i0	85.333	215.564159292035	450	60	99	5	5	452	2828273	2827828	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	97435	460	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
22321757	22321757	PRJNA674050_P_NODE_6558_length_329_cov_2.109375_g6355_i0	PRJNA674050	6558	329	2.109375	6.93984375	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	534	2.52e-147	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g6355	i0	96.049	466.188449848024	329	11	100	2	1	329	1028689	1028363	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	153376	534	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23597195	23597195	PRJNA674050_P_NODE_4139_length_368_cov_1.935593_g3936_i0	PRJNA674050	4139	368	1.935593	7.12298224	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	571	2.17e-158	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g3936	i0	94.624	144.489130434783	372	14	100	6	1	368	1858944	1858575	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	53172	571	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27018485	27018485	PRJNA674050_P_NODE_22842_length_252_cov_0.871508_g22639_i0	PRJNA674050	22842	252	0.871508	2.19620016	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	48.9	2.67e-5	NR	MBN2100151.1	2026734	g22639	i0	70.4	0.321428571428571	27	8	32.1	0	5	85	7	33	MBN2100151.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	81	48.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27144564	27144564	PRJNA674050_P_NODE_31862_length_246_cov_0.901734_g31659_i0	PRJNA674050	31862	246	0.901734	2.21826564	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	108	3.1e-25	NR	MEX1252800.1	2026734	g31659	i0	61	1	82	32	100	0	246	1	242	323	MEX1252800.1 ATPase, T2SS/T4P/T4SS family [Dehalococcoidia bacterium]	diamond	246	108	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27366520	27366520	PRJNA674050_P_NODE_27263_length_249_cov_0.886364_g27060_i0	PRJNA674050	27263	249	0.886364	2.20704636	Chloroflexota bacterium	2026724	Bacteria	Bacteria	88.2	3.58e-18	NR	MEP7289128.1	2026724	g27060	i0	58.9	0.879518072289157	73	30	88	0	219	1	272	344	MEP7289128.1 UDP-N-acetylmuramate--L-alanine ligase [Chloroflexota bacterium]	diamond	219	88.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28471481	28471481	PRJNA674050_P_NODE_22206_length_253_cov_0.866667_g22003_i0	PRJNA674050	22206	253	0.866667	2.19266751	Anaerolineae bacterium	2052143	Bacteria	Bacteria	78.6	1e-14	NR	MBZ0291734.1	2052143	g22003	i0	48.7	0.924901185770751	78	40	92.5	0	3	236	165	242	MBZ0291734.1 PAS domain S-box protein [Anaerolineae bacterium]	diamond	234	78.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28976676	28976676	PRJNA674050_P_NODE_23028_length_252_cov_0.871508_g22825_i0	PRJNA674050	23028	252	0.871508	2.19620016	Chloroflexota bacterium	2026724	Bacteria	Bacteria	50.4	7.86e-5	NR	MCX6050304.1	2026724	g22825	i0	32.1	0.964285714285714	81	55	96.4	0	245	3	265	345	MCX6050304.1 Wzz/FepE/Etk N-terminal domain-containing protein [Chloroflexota bacterium]	diamond	243	50.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29039913	29039913	PRJNA674050_P_NODE_38968_length_242_cov_0.923077_g38765_i0	PRJNA674050	38968	242	0.923077	2.23384634	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	50.4	9.5e-6	NR	MFA5379426.1	2026734	g38765	i0	38	0.880165289256198	71	43	88	1	22	234	17	86	MFA5379426.1 phage head closure protein [Dehalococcoidia bacterium]	diamond	213	50.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
29398851	29398851	PRJNA674050_P_NODE_33349_length_245_cov_1.348837_g33146_i0	PRJNA674050	33349	245	1.348837	3.30465065	Bacillati	1783272	Bacteria	Bacteria	128	1.6100000000000002e-33	NR	MBZ0300000.1	2052143	g33146	i0	76.6	1.88571428571429	77	18	94.3	0	1	231	119	195	MBZ0300000.1 UDP-N-acetylglucosamine--N-acetylmuramyl-(pentapeptide) pyrophosphoryl-undecaprenol N-acetylglucosamine transferase [Anaerolineae bacterium]	diamond	462	129	0.992248062015504	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29430255	29430255	PRJNA674050_P_NODE_28969_length_248_cov_0.885714_g28766_i0	PRJNA674050	28969	248	0.885714	2.19657072	Chloroflexota	200795	Bacteria	Bacteria	124	1.5999999999999998e-32	NR	MCA9967201.1	2073117	g28766	i0	66.3	4.82661290322581	80	27	96.8	0	3	242	4	83	MCA9967201.1 tRNA-dihydrouridine synthase family protein [Anaerolineales bacterium]	diamond	1197	125	0.992	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29714293	29714293	PRJNA674050_P_NODE_24470_length_251_cov_0.870787_g24267_i0	PRJNA674050	24470	251	0.870787	2.18567537	Bacteria	2	Bacteria	Bacteria	96.7	1.73e-21	NR	MYA60366.1	2026724	g24267	i0	72.4	2.05577689243028	58	16	69.3	0	3	176	323	380	MYA60366.1 Gfo/Idh/MocA family oxidoreductase [Chloroflexota bacterium]	diamond	516	97.4	0.992813141683778	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30725537	30725537	PRJNA674050_P_NODE_30214_length_247_cov_0.896552_g30011_i0	PRJNA674050	30214	247	0.896552	2.21448344	Bacillati	1783272	Bacteria	Bacteria	124	5.779999999999999e-32	NR	MDP8905305.1	2026724	g30011	i0	73.2	3.01214574898785	82	20	99.6	2	2	247	213	292	MDP8905305.1 hypothetical protein [Chloroflexota bacterium]	diamond	744	124	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30871601	30871601	PRJNA674050_P_NODE_29854_length_247_cov_1.620690_g29651_i0	PRJNA674050	29854	247	1.62069	4.0031043	Anaerolineae bacterium	2052143	Bacteria	Bacteria	120	8.77e-33	NR	MCI0552902.1	2052143	g29651	i0	74.4	0.995951417004049	82	21	99.6	0	246	1	16	97	MCI0552902.1 SDR family NAD(P)-dependent oxidoreductase [Anaerolineae bacterium]	diamond	246	120	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30966614	30966614	PRJNA674050_P_NODE_30974_length_247_cov_0.885057_g30771_i0	PRJNA674050	30974	247	0.885057	2.18609079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	88.6	2.66e-18	NR	MCL6650630.1	2026724	g30771	i0	54.4	1.93117408906883	79	36	96	0	3	239	224	302	MCL6650630.1 PAS domain S-box protein [Chloroflexota bacterium]	diamond	477	88.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31915046	31915046	PRJNA674050_P_NODE_30877_length_247_cov_0.890805_g30674_i0	PRJNA674050	30877	247	0.890805	2.20028835	Anaerolineae bacterium	2052143	Bacteria	Bacteria	141	8.14e-39	NR	MCC7449544.1	2052143	g30674	i0	88.8	0.97165991902834	80	9	97.2	0	245	6	274	353	MCC7449544.1 ABC transporter substrate-binding protein [Anaerolineae bacterium]	diamond	240	141	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32104877	32104877	PRJNA674050_P_NODE_5638_length_341_cov_1.156716_g5435_i0	PRJNA674050	5638	341	1.156716	3.94440156	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	74.3	9.56e-13	NR	MAS34279.1	2024896	g5435	i0	57.9	0.501466275659824	57	24	50.1	0	176	6	1	57	MAS34279.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	171	74.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
32748771	32748771	PRJNA674050_P_NODE_12320_length_287_cov_1.205607_g12117_i0	PRJNA674050	12320	287	1.205607	3.46009209	Bacteria	2	Bacteria	Bacteria	173	3.85e-49	NR	RLC65980.1	2026724	g12117	i0	84.2	7.94425087108014	95	15	99.3	0	286	2	447	541	RLC65980.1 MAG: hypothetical protein DRI48_05765 [Chloroflexota bacterium]	diamond	2280	174	0.994252873563218	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);;