metadata: contig_metadata: 10 rows where bioproject = "PRJNA657343", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA657343", 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
26701351	26701351	PRJNA657343_P_NODE_38241_length_167_cov_0.881356_g38217_i0	PRJNA657343	38241	167	0.881356	1.47186452	Anaerolineales bacterium HSG6	3055599	Bacteria	Bacteria	64.7	2.38e-10	NR	MDM8518938.1	3055599	g38217	i0	55.8	0.934131736526946	52	23	93.4	0	164	9	123	174	MDM8518938.1 SMP-30/gluconolactonase/LRE family protein [Anaerolineales bacterium HSG6]	diamond	156	64.7	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium HSG6
27366106	27366106	PRJNA657343_P_NODE_30043_length_179_cov_1.330769_g30019_i0	PRJNA657343	30043	179	1.330769	2.38207651	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	40.8	0.0306	NR	HXZ04218.1	2740538	g30019	i0	40.9	0.737430167597765	44	26	73.7	0	46	177	17	60	HXZ04218.1 tryptophan-rich sensory protein [Ktedonobacteraceae bacterium]	diamond	132	40.8	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacteraceae bacterium
28186526	28186526	PRJNA657343_P_NODE_16226_length_224_cov_1.960000_g16202_i0	PRJNA657343	16226	224	1.96	4.3904	Chloroflexota bacterium	2026724	Bacteria	Bacteria	59.7	2.23e-8	NR	MBM4446382.1	2026724	g16202	i0	44.1	1.82142857142857	68	38	91.1	0	2	205	142	209	MBM4446382.1 alpha/beta hydrolase [Chloroflexota bacterium]	diamond	408	59.7	1	Bacteria		Bacillati	Chloroflexota				Chloroflexota bacterium
28407852	28407852	PRJNA657343_P_NODE_44786_length_162_cov_0.920354_g44762_i0	PRJNA657343	44786	162	0.920354	1.49097348	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	42	0.0231	NR	MFI5215412.1	3047546	g44762	i0	36.2	0.87037037037037	47	30	87	0	160	20	32	78	MFI5215412.1 sugar transferase [Candidatus Limnocylindria bacterium]	diamond	141	42	1	Bacteria		Bacillati	Chloroflexota	Candidatus Limnocylindria			Candidatus Limnocylindria bacterium
29860153	29860153	PRJNA657343_P_NODE_10051_length_267_cov_3.142202_g10027_i0	PRJNA657343	10051	267	3.142202	8.38967934	Anaerolineales bacterium	2073117	Bacteria	Bacteria	70.1	1.23e-12	NR	MDX9991097.1	2073117	g10027	i0	43.9	2.73033707865169	82	43	89.9	2	243	4	4	84	MDX9991097.1 SET domain-containing protein [Anaerolineales bacterium]	diamond	729	70.1	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
29955012	29955012	PRJNA657343_P_NODE_10111_length_267_cov_1.348624_g10087_i0	PRJNA657343	10111	267	1.348624	3.60082608	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	49.7	1.79e-4	NR	MQG19260.1	2030829	g10087	i0	42.9	0.707865168539326	63	33	67.4	1	81	260	511	573	MQG19260.1 M1 family metallopeptidase [SAR202 cluster bacterium]	diamond	189	49.7	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia			SAR202 cluster bacterium
31029463	31029463	PRJNA657343_P_NODE_46675_length_155_cov_2.783019_g46651_i0	PRJNA657343	46675	155	2.783019	4.31367945	Anaerolineae bacterium	2052143	Bacteria	Bacteria	70.1	2.51e-12	NR	MCG3209194.1	2052143	g46651	i0	54	6.7741935483871	50	23	96.8	0	2	151	328	377	MCG3209194.1 hypothetical protein [Anaerolineae bacterium]	diamond	1050	70.1	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31198965	31198965	PRJNA657343_P_NODE_9615_length_272_cov_1.345291_g9591_i0	PRJNA657343	9615	272	1.345291	3.65919152	Bacillati	1783272	Bacteria	Bacteria	102	2.05e-24	NR	MEJ2554805.1	2052143	g9591	i0	50	1.91911764705882	88	44	97.1	0	266	3	133	220	MEJ2554805.1 sucrase/ferredoxin-like family protein [Anaerolineae bacterium]	diamond	522	102	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
31503621	31503621	PRJNA657343_P_NODE_23256_length_196_cov_1.346939_g23232_i0	PRJNA657343	23256	196	1.346939	2.64000044	Anaerolineae bacterium	2052143	Bacteria	Bacteria	111	5.86e-29	NR	MBL8157683.1	2052143	g23232	i0	87.7	0.872448979591837	57	7	87.2	0	176	6	1	57	MBL8157683.1 cullin [Anaerolineae bacterium]	diamond	171	111	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
32053417	32053417	PRJNA657343_P_NODE_3638_length_391_cov_1.485380_g3615_i0	PRJNA657343	3638	391	1.48538	5.8078358	Bacteria	2	Bacteria	Bacteria	50.1	1.56e-4	NR	HXF51374.1	2026734	g3615	i0	48.9	1.09718670076726	45	23	34.5	0	295	161	54	98	HXF51374.1 Hsp20/alpha crystallin family protein [Dehalococcoidia bacterium]	diamond	429	50.1	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia 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);;