metadata: contig_metadata: 15 rows where bioproject = "PRJNA1020854", tax_kingdom = "Bacillati" and tax

15 rows where bioproject = "PRJNA1020854", 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
7813753	7813753	PRJNA1020854_S_NODE_38127_length_162_cov_3.195489_g35363_i0	PRJNA1020854	38127	162	3.195489	5.17669218	FCB group	1783270	Bacteria	Bacteria	102	2.4099999999999998e-24	NR	MDQ2673325.1	2026724	g35363	i0	94.3	5.88888888888889	53	3	98.1	0	3	161	72	124	MDQ2673325.1 PilT/PilU family type 4a pilus ATPase [Chloroflexota bacterium]	diamond	954	102	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
26717935	26717935	PRJNA1020854_S_NODE_16241_length_286_cov_4.062257_g13477_i0	PRJNA1020854	16241	286	4.062257	11.61805502	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	155	1.1599999999999999e-41	NR	MBX7110512.1	2026734	g13477	i0	80.2	1.90909090909091	91	18	95.5	0	285	13	512	602	MBX7110512.1 UPF0182 family protein [Dehalococcoidia bacterium]	diamond	546	155	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
26781798	26781798	PRJNA1020854_S_NODE_30201_length_188_cov_2.238994_g27437_i0	PRJNA1020854	30201	188	2.238994	4.20930872	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.2	7.7e-10	NR	MCE9645330.1	2026724	g27437	i0	60	0.718085106382979	45	18	71.8	0	53	187	53	97	MCE9645330.1 hypothetical protein [Chloroflexota bacterium]	diamond	135	63.2	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27129255	27129255	PRJNA1020854_S_NODE_23902_length_219_cov_3.731579_g21138_i0	PRJNA1020854	23902	219	3.731579	8.17215801	Chloroflexota bacterium	2026724	Bacteria	Bacteria	113	3.1500000000000004e-27	NR	MBN9391927.1	2026724	g21138	i0	72.2	0.986301369863014	72	20	98.6	0	218	3	453	524	MBN9391927.1 hypothetical protein [Chloroflexota bacterium]	diamond	216	113	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27477276	27477276	PRJNA1020854_S_NODE_26583_length_204_cov_2.640000_g23819_i0	PRJNA1020854	26583	204	2.64	5.3856	Chloroflexota bacterium	2026724	Bacteria	Bacteria	65.9	5.73e-12	NR	HCF99586.1	2026724	g23819	i0	53.5	0.632352941176471	43	20	63.2	0	5	133	58	100	HCF99586.1 hypothetical protein [Chloroflexota bacterium]	diamond	129	65.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
27856114	27856114	PRJNA1020854_S_NODE_16805_length_279_cov_3.584000_g14041_i0	PRJNA1020854	16805	279	3.584	9.99936	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	78.2	1.2e-15	NR	MBO36975.1	2024896	g14041	i0	50	1.78494623655914	84	38	89.2	2	27	275	36	116	MBO36975.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	498	78.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
28014256	28014256	PRJNA1020854_S_NODE_22325_length_229_cov_3.335000_g19561_i0	PRJNA1020854	22325	229	3.335	7.63715	Anaerolineae bacterium	2052143	Bacteria	Bacteria	106	8.97e-25	NR	MFQ5813912.1	2052143	g19561	i0	76.5	0.890829694323144	68	16	89.1	0	21	224	229	296	MFQ5813912.1 cytochrome ubiquinol oxidase subunit I [Anaerolineae bacterium]	diamond	204	106	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28771786	28771786	PRJNA1020854_S_NODE_27807_length_198_cov_3.644970_g25043_i0	PRJNA1020854	27807	198	3.64497	7.2170406	Chloroflexota bacterium	2026724	Bacteria	Bacteria	110	6.380000000000001e-27	NR	MBI1882270.1	2026724	g25043	i0	81.3	1.93939393939394	64	12	97	0	194	3	113	176	MBI1882270.1 phosphopentomutase [Chloroflexota bacterium]	diamond	384	110	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29087734	29087734	PRJNA1020854_S_NODE_33288_length_176_cov_271.809524_g30524_i0	PRJNA1020854	33288	176	271.809524	478.38476224	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	43.1	0.00754	NR	MEO7908284.1	2762507	g30524	i0	83.3	0.409090909090909	24	4	40.9	0	104	175	1	24	MEO7908284.1 aldehyde dehydrogenase family protein [Roseiflexaceae bacterium]	diamond	72	43.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexaceae bacterium
29718809	29718809	PRJNA1020854_S_NODE_43530_length_150_cov_2.380165_g40766_i0	PRJNA1020854	43530	150	2.380165	3.5702475	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	91.7	6.24e-20	NR	MCZ7574062.1	2614247	g40766	i0	86	2	50	7	100	0	1	150	851	900	MCZ7574062.1 molybdopterin-dependent oxidoreductase [Ardenticatenaceae bacterium]	diamond	300	91.7	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
30722090	30722090	PRJNA1020854_S_NODE_8274_length_494_cov_6.083871_g5606_i0	PRJNA1020854	8274	494	6.083871	30.05432274	FCB group	1783270	Bacteria	Bacteria	51.6	1.47e-5	NR	HXJ14103.1	2952938	g5606	i0	47.5	0.947368421052632	59	28	35.2	2	356	183	7	63	HXJ14103.1 hypothetical protein [Candidatus Limnocylindrales bacterium]	diamond	468	51.6	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales		Candidatus Limnocylindrales bacterium
31773163	31773163	PRJNA1020854_S_NODE_17757_length_268_cov_2.447699_g14993_i0	PRJNA1020854	17757	268	2.447699	6.55983332	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	61.2	1.29e-9	NR	MDP2726812.1	2026734	g14993	i0	73.5	2.05970149253731	34	9	38.1	0	1	102	88	121	MDP2726812.1 WecB/TagA/CpsF family glycosyltransferase [Dehalococcoidia bacterium]	diamond	552	61.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
31899806	31899806	PRJNA1020854_S_NODE_33977_length_174_cov_3.468966_g31213_i0	PRJNA1020854	33977	174	3.468966	6.03600084	Chloroflexota bacterium	2026724	Bacteria	Bacteria	104	1.86e-25	NR	MCE9645330.1	2026724	g31213	i0	74.1	1	58	15	100	0	1	174	95	152	MCE9645330.1 hypothetical protein [Chloroflexota bacterium]	diamond	174	104	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31962997	31962997	PRJNA1020854_S_NODE_21318_length_236_cov_3.855072_g18554_i0	PRJNA1020854	21318	236	3.855072	9.09796992	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	109	1.9999999999999998e-26	NR	HET8776606.1	3047546	g18554	i0	67.1	1.04237288135593	82	22	99.2	2	235	2	202	282	HET8776606.1 helicase-related protein [Candidatus Limnocylindria bacterium]	diamond	246	109	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria			Candidatus Limnocylindria bacterium
32627117	32627117	PRJNA1020854_S_NODE_24360_length_216_cov_4.128342_g21596_i0	PRJNA1020854	24360	216	4.128342	8.91721872	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.1	0.00142	NR	MCH8186028.1	2026724	g21596	i0	53.7	1.68055555555556	41	19	56.9	0	86	208	27	67	MCH8186028.1 type II secretion system protein [Chloroflexota bacterium]	diamond	363	45.1	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);;