metadata: contig_metadata: 8 rows where bioproject = "PRJNA886442", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA886442", 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_species
13615483	13615483	PRJNA886442_P_NODE_1391_length_585_cov_1.851562_g1228_i0	PRJNA886442	1391	585	1.851562	10.8316377	Chloroflexi bacterium HGW-Chloroflexi-6	2013729	Bacteria	Bacteria	126	5.279999999999999e-32	NR	PKN92786.1	2013729	g1228	i0	79.2	2.75384615384615	77	16	39.5	0	1	231	174	250	PKN92786.1 MAG: 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Chloroflexi bacterium HGW-Chloroflexi-6]	diamond	1611	126	1	Bacteria	Bacillati	Chloroflexota		Chloroflexi bacterium HGW-Chloroflexi-6
26960354	26960354	PRJNA886442_P_NODE_9582_length_261_cov_1.659574_g9418_i0	PRJNA886442	9582	261	1.659574	4.33148814	Chloroflexota bacterium	2026724	Bacteria	Bacteria	62.8	3.4e-9	NR	NLF65840.1	2026724	g9418	i0	82.9	1.59770114942529	35	6	40.2	0	106	2	1	35	NLF65840.1 aldo/keto reductase [Chloroflexota bacterium]	diamond	417	62.8	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
28350305	28350305	PRJNA886442_P_NODE_13226_length_246_cov_0.901734_g13062_i0	PRJNA886442	13226	246	0.901734	2.21826564	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.9	0.00861	NR	MDP9317264.1	2026724	g13062	i0	45.3	2.41463414634146	53	21	58.5	2	101	244	89	138	MDP9317264.1 AP2 domain-containing protein [Chloroflexota bacterium]	diamond	594	43.9	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
28823678	28823678	PRJNA886442_P_NODE_9948_length_256_cov_2.087432_g9784_i0	PRJNA886442	9948	256	2.087432	5.34382592	Chloroflexota bacterium	2026724	Bacteria	Bacteria	97.4	1.52e-22	NR	MEW6083667.1	2026724	g9784	i0	56.6	2.91796875	83	36	97.3	0	254	6	158	240	MEW6083667.1 MBL fold metallo-hydrolase [Chloroflexota bacterium]	diamond	747	97.4	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
29518496	29518496	PRJNA886442_P_NODE_7190_length_295_cov_1.054054_g7026_i0	PRJNA886442	7190	295	1.054054	3.1094593	Chloroflexota bacterium	2026724	Bacteria	Bacteria	73.2	4.49e-14	NR	MFN8623421.1	2026724	g7026	i0	50	0.813559322033898	80	40	81.4	0	26	265	14	93	MFN8623421.1 hypothetical protein [Chloroflexota bacterium]	diamond	240	73.2	1	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
29676119	29676119	PRJNA886442_P_NODE_14510_length_243_cov_1.235294_g14346_i0	PRJNA886442	14510	243	1.235294	3.00176442	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	92	1.9900000000000003e-21	NR	MEX1254887.1	2026734	g14346	i0	72.1	0.753086419753086	61	14	71.6	1	69	242	5	65	MEX1254887.1 VOC family protein [Dehalococcoidia bacterium]	diamond	183	92	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidia bacterium
31074481	31074481	PRJNA886442_P_NODE_8475_length_276_cov_1.413793_g8311_i0	PRJNA886442	8475	276	1.413793	3.90206868	Bacteria	2	Bacteria	Bacteria	88.2	1.18e-19	NR	MDQ3044264.1	2026724	g8311	i0	53.9	1.65217391304348	76	35	82.6	0	276	49	92	167	MDQ3044264.1 carbonic anhydrase [Chloroflexota bacterium]	diamond	456	89	0.991011235955056	Bacteria	Bacillati	Chloroflexota		Chloroflexota bacterium
31730478	31730478	PRJNA886442_P_NODE_12557_length_248_cov_0.891429_g12393_i0	PRJNA886442	12557	248	0.891429	2.21074392	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.1	0.0276	NR	MEM8861963.1	2026724	g12393	i0	33.7	1.11290322580645	92	50	98	3	248	6	7	98	MEM8861963.1 adenylosuccinate synthetase [Chloroflexota bacterium]	diamond	276	43.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);;