metadata: contig_metadata: 24 rows where bioproject = "PRJNA897077", tax_kingdom = "Bacillati" and tax

24 rows where bioproject = "PRJNA897077", 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
5976880	5976880	PRJNA897077_P_NODE_13985_length_265_cov_1.536458_g13858_i0	PRJNA897077	13985	265	1.536458	4.0716137	Caldilineae bacterium	2420332	Bacteria	Bacteria	99	8.46e-22	NR	HEY53487.1	2420332	g13858	i0	53.4	0.99622641509434	88	41	99.6	0	1	264	647	734	HEY53487.1 alpha/beta fold hydrolase [Caldilineae bacterium]	diamond	264	99	1	Bacteria	Bacillati	Chloroflexota	Caldilineae				Caldilineae bacterium
5976923	5976923	PRJNA897077_P_NODE_16965_length_249_cov_0.886364_g16838_i0	PRJNA897077	16965	249	0.886364	2.20704636	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	87.9	6.18e-13	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g16838	i0	96.226	0.21285140562249	53	2	21	0	194	246	2871506	2871558	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	53	87.9	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8526389	8526389	PRJNA897077_P_NODE_15167_length_253_cov_0.866667_g15040_i0	PRJNA897077	15167	253	0.866667	2.19266751	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.5	1.86e-9	NR	HZT08338.1	2026724	g15040	i0	80.6	0.853754940711462	36	7	42.7	0	145	252	1	36	HZT08338.1 hypothetical protein [Chloroflexota bacterium]	diamond	216	63.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
8526566	8526566	PRJNA897077_P_NODE_6547_length_380_cov_1.270358_g6420_i0	PRJNA897077	6547	380	1.270358	4.8273604	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	300	1.17e-76	NTclustered	gi\|2621706268\|emb\|OY764162.1\|	2026734	g6420	i0	82.857	126.902631578947	350	45	91	13	36	380	1579006	1578667	MAG: Dehalococcoidia bacterium isolate c2b86379-bd31-4c30-aa6f-eeb60e07e050 genome assembly, chromosome: 1	blastn	48223	300	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
9801440	9801440	PRJNA897077_P_NODE_16008_length_251_cov_0.876404_g15881_i0	PRJNA897077	16008	251	0.876404	2.19977404	Tepidiforma flava	3004094	Bacteria	Bacteria	139	1.7000000000000003e-28	NTclustered	gi\|2421951025\|gb\|CP115149.1\|	3004094	g15881	i0	93.548	36.2868525896414	93	6	37	0	128	220	1586302	1586210	Tepidiforma flava strain YIM 72310 chromosome, complete genome	blastn	9108	139	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma flava
11077147	11077147	PRJNA897077_P_NODE_18809_length_244_cov_1.426901_g18682_i0	PRJNA897077	18809	244	1.426901	3.48163844	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	159	3.98e-44	NR	HEX2907181.1	3069543	g18682	i0	88.9	1.99180327868852	81	9	99.6	0	243	1	476	556	HEX2907181.1 NADH-dependent [FeFe] hydrogenase, group A6 [Phototrophicaceae bacterium]	diamond	486	159	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
16176483	16176483	PRJNA897077_P_NODE_7413_length_358_cov_2.045614_g7286_i0	PRJNA897077	7413	358	2.045614	7.32329812	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	178	5.36e-40	NTclustered	gi\|2621706248\|emb\|OY764157.1\|	2952883	g7286	i0	81.197	14.2346368715084	234	33	64	10	97	326	142910	142684	MAG: Aggregatilineales bacterium isolate e8f4d38d-de70-4490-8638-1b8803f995b9 genome assembly, chromosome: 1	blastn	5096	178	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
22550485	22550485	PRJNA897077_P_NODE_19398_length_243_cov_0.917647_g19271_i0	PRJNA897077	19398	243	0.917647	2.22988221	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	84.2	7.77e-12	NTclustered	gi\|2621704926\|emb\|OY762213.1\|	2026734	g19271	i0	100	1.90534979423868	45	0	19	0	24	68	1547173	1547129	MAG: Dehalococcoidia bacterium isolate 03469a5e-dcd7-4577-8116-c1a2ee551a24 genome assembly, chromosome: 1	blastn	463	84.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26707234	26707234	PRJNA897077_P_NODE_17901_length_247_cov_0.896552_g17774_i0	PRJNA897077	17901	247	0.896552	2.21448344	Caldilineales bacterium	2306055	Bacteria	Bacteria	94	3.71e-20	NR	MCS6842766.1	2306055	g17774	i0	55.4	2.96356275303644	83	36	99.6	1	2	247	192	274	MCS6842766.1 PQQ-dependent sugar dehydrogenase [Caldilineales bacterium]	diamond	732	94	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales			Caldilineales bacterium
27593008	27593008	PRJNA897077_P_NODE_19964_length_242_cov_0.923077_g19837_i0	PRJNA897077	19964	242	0.923077	2.23384634	Anaerolineales bacterium	2073117	Bacteria	Bacteria	166	2.43e-47	NR	CAG1017047.1	2073117	g19837	i0	97.5	3.96694214876033	80	2	99.2	0	1	240	373	452	CAG1017047.1 glucose-6-phosphate 1-dehydrogenase [Anaerolineales bacterium]	diamond	960	166	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
27940256	27940256	PRJNA897077_P_NODE_18605_length_245_cov_0.906977_g18478_i0	PRJNA897077	18605	245	0.906977	2.22209365	Chloroflexota bacterium	2026724	Bacteria	Bacteria	153	7.169999999999998e-42	NR	MEA2548335.1	2026724	g18478	i0	86.1	1.93469387755102	79	11	96.7	0	243	7	162	240	MEA2548335.1 alpha-glucosidase [Chloroflexota bacterium]	diamond	474	153	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28579430	28579430	PRJNA897077_P_NODE_18567_length_245_cov_0.906977_g18440_i0	PRJNA897077	18567	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	99	6.300000000000001e-22	NR	HBY46224.1	2026724	g18440	i0	65.3	3.53877551020408	72	24	88.2	1	234	19	205	275	HBY46224.1 hypothetical protein [Chloroflexota bacterium]	diamond	867	100	0.99	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28603299	28603299	PRJNA897077_P_NODE_19887_length_242_cov_0.923077_g19760_i0	PRJNA897077	19887	242	0.923077	2.23384634	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	50.1	9.41e-5	NR	KAF0108861.1	2024896	g19760	i0	44.6	1.83471074380165	74	34	91.7	3	1	222	345	411	KAF0108861.1 MAG: hypothetical protein FD146_747 [Anaerolineaceae bacterium]	diamond	444	50.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
28958413	28958413	PRJNA897077_P_NODE_19988_length_242_cov_0.923077_g19861_i0	PRJNA897077	19988	242	0.923077	2.23384634	PVC group	1783257	Bacteria	Bacteria	138	7.109999999999999e-38	NR	MEA2547090.1	2026724	g19861	i0	91.1	4.93388429752066	79	7	97.9	0	3	239	164	242	MEA2547090.1 hypothetical protein [Chloroflexota bacterium]	diamond	1194	138	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29045373	29045373	PRJNA897077_P_NODE_20268_length_227_cov_2.006494_g20141_i0	PRJNA897077	20268	227	2.006494	4.55474138	Anaerolineales bacterium	2073117	Bacteria	Bacteria	142	1.2899999999999999e-39	NR	MBE7552989.1	2073117	g20141	i0	89.3	3.9647577092511	75	8	99.1	0	227	3	161	235	MBE7552989.1 NAD(P)-dependent oxidoreductase [Anaerolineales bacterium]	diamond	900	142	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29329357	29329357	PRJNA897077_P_NODE_16849_length_249_cov_0.886364_g16722_i0	PRJNA897077	16849	249	0.886364	2.20704636	Chloroflexota bacterium	2026724	Bacteria	Bacteria	147	6.99e-44	NR	MEO8638711.1	2026724	g16722	i0	84	3.81927710843373	81	13	97.6	0	1	243	41	121	MEO8638711.1 MmcQ/YjbR family DNA-binding protein [Chloroflexota bacterium]	diamond	951	147	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29873912	29873912	PRJNA897077_P_NODE_16151_length_251_cov_0.876404_g16024_i0	PRJNA897077	16151	251	0.876404	2.19977404	Bacteria	2	Bacteria	Bacteria	138	5.13e-38	NR	MCK6628048.1	2052143	g16024	i0	79.5	2.97609561752988	83	17	99.2	0	3	251	132	214	MCK6628048.1 xanthine dehydrogenase family protein subunit M [Anaerolineae bacterium]	diamond	747	138	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29992599	29992599	PRJNA897077_P_NODE_18651_length_245_cov_0.906977_g18524_i0	PRJNA897077	18651	245	0.906977	2.22209365	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	163	1.9699999999999998e-47	NR	HEU5100011.1	2762507	g18524	i0	95.1	1.98367346938776	81	4	99.2	0	245	3	85	165	HEU5100011.1 UDP-glucose 4-epimerase GalE [Roseiflexaceae bacterium]	diamond	486	163	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae		Roseiflexaceae bacterium
30150283	30150283	PRJNA897077_P_NODE_18692_length_245_cov_0.906977_g18565_i0	PRJNA897077	18692	245	0.906977	2.22209365	Anaerolineae bacterium	2052143	Bacteria	Bacteria	133	1.47e-34	NR	MBA3872901.1	2052143	g18565	i0	83.3	1.9469387755102	78	13	95.5	0	235	2	326	403	MBA3872901.1 sugar ABC transporter ATP-binding protein [Anaerolineae bacterium]	diamond	477	133	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30592752	30592752	PRJNA897077_P_NODE_17093_length_249_cov_0.886364_g16966_i0	PRJNA897077	17093	249	0.886364	2.20704636	Anaerolineales bacterium	2073117	Bacteria	Bacteria	70.9	2.51e-12	NR	MCJ7677335.1	2073117	g16966	i0	45	1.97590361445783	80	44	96.4	0	9	248	204	283	MCJ7677335.1 pilus assembly protein TadG-related protein [Anaerolineales bacterium]	diamond	492	70.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30624275	30624275	PRJNA897077_P_NODE_16013_length_251_cov_0.876404_g15886_i0	PRJNA897077	16013	251	0.876404	2.19977404	Chloroflexota bacterium	2026724	Bacteria	Bacteria	95.9	5.81e-22	NR	MEA3341544.1	2026724	g15886	i0	59.8	0.9800796812749	82	19	98	1	4	249	175	242	MEA3341544.1 Uma2 family endonuclease [Chloroflexota bacterium]	diamond	246	95.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31161218	31161218	PRJNA897077_P_NODE_16475_length_250_cov_0.881356_g16348_i0	PRJNA897077	16475	250	0.881356	2.20339	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	144	2.2399999999999998e-38	NR	HUP35289.1	3047546	g16348	i0	88	0.996	83	10	99.6	0	2	250	3	85	HUP35289.1 ABC transporter substrate-binding protein [Candidatus Limnocylindria bacterium]	diamond	249	144	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
31224640	31224640	PRJNA897077_P_NODE_16055_length_251_cov_0.876404_g15928_i0	PRJNA897077	16055	251	0.876404	2.19977404	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	127	5.19e-33	NR	HLE89004.1	3047546	g15928	i0	79.8	1.00398406374502	84	16	99.2	1	250	2	158	241	HLE89004.1 sodium:calcium antiporter [Candidatus Limnocylindria bacterium]	diamond	252	127	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria				Candidatus Limnocylindria bacterium
32149922	32149922	PRJNA897077_P_NODE_17018_length_249_cov_0.886364_g16891_i0	PRJNA897077	17018	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	43.1	0.00378	NR	MBE0690470.1	2052143	g16891	i0	62.2	0.903614457831325	37	14	44.6	0	119	9	1	37	MBE0690470.1 hypothetical protein [Anaerolineae bacterium]	diamond	225	43.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;