metadata: contig_metadata: 25 rows where bioproject = "PRJNA695273", tax_kingdom = "Bacillati" and tax

25 rows where bioproject = "PRJNA695273", 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
5780715	5780715	PRJNA695273_P_NODE_144825_length_245_cov_1.790698_g144067_i0	PRJNA695273	144825	245	1.790698	4.3872101	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	370	5.38e-98	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g144067	i0	93.902	163.338775510204	246	13	100	2	1	245	2824295	2824051	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	40018	370	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
7055135	7055135	PRJNA695273_P_NODE_116086_length_261_cov_1.638298_g115328_i0	PRJNA695273	116086	261	1.638298	4.27595778	Chloroflexaceae bacterium	2562117	Bacteria	Bacteria	154	3.9e-43	NR	HMQ34856.1	2562117	g115328	i0	94.2	1.97701149425287	86	5	98.9	0	2	259	298	383	HMQ34856.1 MFS transporter [Chloroflexaceae bacterium]	diamond	516	154	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexaceae bacterium
21585634	21585634	PRJNA695273_P_NODE_79477_length_310_cov_1.299578_g78719_i0	PRJNA695273	79477	310	1.299578	4.0286918	Chloroflexota bacterium	2026724	Bacteria	Bacteria	163	4.6e-45	NR	MEW6240184.1	2026724	g78719	i0	71.6	0.987096774193548	102	29	98.7	0	3	308	269	370	MEW6240184.1 phospholipase D-like domain-containing protein [Chloroflexota bacterium]	diamond	306	163	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
24905120	24905120	PRJNA695273_P_NODE_74380_length_320_cov_1.246964_g73622_i0	PRJNA695273	74380	320	1.246964	3.9902848	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	133	1.68e-33	NR	RIK28031.1	2026724	g73622	i0	73.3	16.659375	101	27	94.7	0	312	10	252	352	RIK28031.1 MAG: ATPase [Chloroflexota bacterium]	diamond	5331	134	0.992537313432836	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
26639512	26639512	PRJNA695273_P_NODE_91981_length_289_cov_1.009259_g91223_i0	PRJNA695273	91981	289	1.009259	2.91675851	Chloroflexota bacterium	2026724	Bacteria	Bacteria	108	8.8e-26	NR	HZT07980.1	2026724	g91223	i0	56.3	0.996539792387543	96	42	99.7	0	2	289	88	183	HZT07980.1 ABC transporter substrate-binding protein [Chloroflexota bacterium]	diamond	288	108	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
26924528	26924528	PRJNA695273_P_NODE_144622_length_245_cov_2.656977_g143864_i0	PRJNA695273	144622	245	2.656977	6.50959365	Chloroflexota bacterium	2026724	Bacteria	Bacteria	52	1.69e-5	NR	MDP2950698.1	2026724	g143864	i0	43.9	1.77551020408163	82	34	85.7	3	2	211	138	219	MDP2950698.1 hypothetical protein [Chloroflexota bacterium]	diamond	435	52	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27145455	27145455	PRJNA695273_P_NODE_161482_length_240_cov_2.311377_g160724_i0	PRJNA695273	161482	240	2.311377	5.5473048	Chloroflexota bacterium	2026724	Bacteria	Bacteria	100	9.3e-23	NR	HZT06442.1	2026724	g160724	i0	63.6	0.9625	77	28	96.3	0	239	9	359	435	HZT06442.1 MFS transporter [Chloroflexota bacterium]	diamond	231	100	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27567751	27567751	PRJNA695273_P_NODE_104184_length_275_cov_1.336634_g103426_i0	PRJNA695273	104184	275	1.336634	3.6757435	Bacteria	2	Bacteria	Bacteria	135	3.0799999999999996e-35	NR	MER3437807.1	2026724	g103426	i0	67	8.84727272727273	91	30	99.3	0	1	273	328	418	MER3437807.1 PhoX family phosphatase [Chloroflexota bacterium]	diamond	2433	135	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27651469	27651469	PRJNA695273_P_NODE_146584_length_245_cov_0.895349_g145826_i0	PRJNA695273	146584	245	0.895349	2.19360505	Caldilineae bacterium	2420332	Bacteria	Bacteria	81.6	3.73e-18	NR	RME81276.1	2420332	g145826	i0	69.6	1.15102040816327	46	14	56.3	0	138	1	3	48	RME81276.1 MAG: DUF4326 domain-containing protein [Caldilineae bacterium]	diamond	282	81.6	1	Bacteria	Bacillati	Chloroflexota	Caldilineae			Caldilineae bacterium
28093329	28093329	PRJNA695273_P_NODE_115825_length_262_cov_1.126984_g115067_i0	PRJNA695273	115825	262	1.126984	2.95269808	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	43.5	0.024	NR	HEY7123034.1	2306968	g115067	i0	47.4	0.652671755725191	57	26	61.8	2	69	230	27	82	HEY7123034.1 hypothetical protein [Ktedonobacterales bacterium]	diamond	171	43.5	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales		Ktedonobacterales bacterium
28440817	28440817	PRJNA695273_P_NODE_137206_length_248_cov_0.880000_g136448_i0	PRJNA695273	137206	248	0.88	2.1824	Chloroflexota bacterium	2026724	Bacteria	Bacteria	142	5.01e-37	NR	NLG73045.1	2026724	g136448	i0	80.5	10.9112903225806	82	16	99.2	0	3	248	140	221	NLG73045.1 DNA polymerase III subunit alpha [Chloroflexota bacterium]	diamond	2706	142	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28882607	28882607	PRJNA695273_P_NODE_138708_length_247_cov_0.885057_g137950_i0	PRJNA695273	138708	247	0.885057	2.18609079	Chloroflexia bacterium	2448782	Bacteria	Bacteria	64.7	6.8e-10	NR	HET9494671.1	2448782	g137950	i0	94.1	0.412955465587045	34	2	41.3	0	197	96	123	156	HET9494671.1 SpoVR family protein [Chloroflexia bacterium]	diamond	102	64.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			Chloroflexia bacterium
29040835	29040835	PRJNA695273_P_NODE_41068_length_423_cov_2.254286_g40310_i0	PRJNA695273	41068	423	2.254286	9.53562978	Chloroflexia bacterium	2448782	Bacteria	Bacteria	61.2	9.11e-8	NR	HKP55015.1	2448782	g40310	i0	39.6	1.40425531914894	101	58	71.6	3	384	82	549	646	HKP55015.1 alpha-amylase family glycosyl hydrolase [Chloroflexia bacterium]	diamond	594	61.2	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			Chloroflexia bacterium
29167085	29167085	PRJNA695273_P_NODE_138729_length_247_cov_0.885057_g137971_i0	PRJNA695273	138729	247	0.885057	2.18609079	Anaerolineae bacterium	2052143	Bacteria	Bacteria	89.4	1.07e-20	NR	HLF25825.1	2052143	g137971	i0	92.9	0.510121457489879	42	3	51	0	8	133	85	126	HLF25825.1 VOC family protein [Anaerolineae bacterium]	diamond	126	89.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
29577109	29577109	PRJNA695273_P_NODE_163010_length_226_cov_2.869281_g162252_i0	PRJNA695273	163010	226	2.869281	6.48457506	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	85.9	1.86e-17	NR	MDO9333948.1	2026733	g162252	i0	56.8	0.982300884955752	74	32	98.2	0	3	224	278	351	MDO9333948.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	222	85.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales		Dehalococcoidales bacterium
30125288	30125288	PRJNA695273_P_NODE_67412_length_335_cov_1.129771_g66654_i0	PRJNA695273	67412	335	1.129771	3.78473285	FCB group	1783270	Bacteria	Bacteria	94	8.58e-20	NR	MBI1277320.1	2024896	g66654	i0	43.4	1.88955223880597	106	60	94.9	0	4	321	331	436	MBI1277320.1 cytochrome P450 [Anaerolineaceae bacterium]	diamond	633	94.7	0.992608236536431	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
31188195	31188195	PRJNA695273_P_NODE_94535_length_286_cov_1.140845_g93777_i0	PRJNA695273	94535	286	1.140845	3.2628167	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	187	9.07e-56	NR	MFL5803722.1	2762507	g93777	i0	93.7	0.996503496503496	95	6	99.7	0	286	2	177	271	MFL5803722.1 enolase C-terminal domain-like protein [Roseiflexaceae bacterium]	diamond	285	187	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexaceae bacterium
31219787	31219787	PRJNA695273_P_NODE_157255_length_242_cov_0.911243_g156497_i0	PRJNA695273	157255	242	0.911243	2.20520806	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	50.1	4.13e-5	NR	HEU5097753.1	2762507	g156497	i0	46.3	1.64876033057851	67	31	81.8	2	229	32	77	139	HEU5097753.1 GNAT family N-acetyltransferase [Roseiflexaceae bacterium]	diamond	399	50.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexaceae bacterium
31251672	31251672	PRJNA695273_P_NODE_144535_length_246_cov_0.878613_g143777_i0	PRJNA695273	144535	246	0.878613	2.16138798	Chloroflexota bacterium	2026724	Bacteria	Bacteria	123	1.06e-33	NR	HZT05440.1	2026724	g143777	i0	77.8	1.97560975609756	81	18	98.8	0	3	245	64	144	HZT05440.1 pantetheine-phosphate adenylyltransferase [Chloroflexota bacterium]	diamond	486	123	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31421151	31421151	PRJNA695273_P_NODE_106896_length_272_cov_1.311558_g106138_i0	PRJNA695273	106896	272	1.311558	3.56743776	Bacteria	2	Bacteria	Bacteria	98.6	4.14e-23	NR	MBI3164770.1	2026724	g106138	i0	62.9	9.89338235294118	70	26	77.2	0	269	60	153	222	MBI3164770.1 sulfotransferase family protein [Chloroflexota bacterium]	diamond	2691	99	0.995959595959596	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31737298	31737298	PRJNA695273_P_NODE_97337_length_283_cov_1.100000_g96579_i0	PRJNA695273	97337	283	1.1	3.113	Bacteria	2	Bacteria	Bacteria	62.4	5.9e-9	NR	MEA3408511.1	2026724	g96579	i0	65.9	1.46289752650177	44	15	46.6	0	174	43	215	258	MEA3408511.1 peptide chain release factor N(5)-glutamine methyltransferase [Chloroflexota bacterium]	diamond	414	62.4	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31789198	31789198	PRJNA695273_P_NODE_113277_length_264_cov_3.005236_g112519_i0	PRJNA695273	113277	264	3.005236	7.93382304	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.4	0.0259	NR	HLH21866.1	2026724	g112519	i0	39.7	0.659090909090909	58	35	65.9	0	6	179	62	119	HLH21866.1 hypothetical protein [Chloroflexota bacterium]	diamond	174	42.4	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
32010952	32010952	PRJNA695273_P_NODE_134178_length_249_cov_0.875000_g133420_i0	PRJNA695273	134178	249	0.875	2.17875	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	110	5.99e-26	NR	HEU4326707.1	2762507	g133420	i0	63.4	0.987951807228916	82	30	98.8	0	246	1	503	584	HEU4326707.1 alpha-amylase family glycosyl hydrolase [Roseiflexaceae bacterium]	diamond	246	110	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexaceae bacterium
32232695	32232695	PRJNA695273_P_NODE_72338_length_324_cov_1.533865_g71580_i0	PRJNA695273	72338	324	1.533865	4.9697226	Anaerolineae bacterium	2052143	Bacteria	Bacteria	186	1.52e-52	NR	RIK31797.1	2052143	g71580	i0	84.9	12.9259259259259	106	16	98.1	0	7	324	455	560	RIK31797.1 MAG: thiamine ABC transporter permease [Anaerolineae bacterium]	diamond	4188	186	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
32800614	32800614	PRJNA695273_P_NODE_138800_length_247_cov_0.885057_g138042_i0	PRJNA695273	138800	247	0.885057	2.18609079	Chloroflexaceae bacterium	2562117	Bacteria	Bacteria	79.7	1e-16	NR	HMQ35857.1	2562117	g138042	i0	75.6	0.546558704453441	45	11	54.7	0	111	245	1	45	HMQ35857.1 hypothetical protein [Chloroflexaceae bacterium]	diamond	135	79.7	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexaceae 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);;