metadata: contig_metadata: 9 rows where bioproject = "PRJNA893346", tax_kingdom = "Bacillati" and tax

9 rows where bioproject = "PRJNA893346", 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_genus	tax_species
28287133	28287133	PRJNA893346_P_NODE_22886_length_320_cov_2.327935_g22396_i0	PRJNA893346	22886	320	2.327935	7.449392	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	143	1.45e-38	NR	HEX2620824.1	3069543	g22396	i0	64.8	2.94375	105	37	98.4	0	316	2	209	313	HEX2620824.1 ornithine--oxo-acid transaminase [Phototrophicaceae bacterium]	diamond	942	143	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
28950616	28950616	PRJNA893346_P_NODE_12368_length_445_cov_1.653226_g11883_i0	PRJNA893346	12368	445	1.653226	7.3568557	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	55.1	1.36e-5	NR	MBN1863051.1	2026733	g11883	i0	40	1.48988764044944	105	52	66.1	5	2	295	256	356	MBN1863051.1 hypothetical protein [Dehalococcoidales bacterium]	diamond	663	55.1	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
30087130	30087130	PRJNA893346_P_NODE_31012_length_265_cov_1.203125_g30522_i0	PRJNA893346	31012	265	1.203125	3.18828125	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	60.1	3.72e-8	NR	HSW56914.1	2026733	g30522	i0	53.4	1.33584905660377	58	24	62.3	2	3	167	299	356	HSW56914.1 Ig-like domain-containing protein [Dehalococcoidales bacterium]	diamond	354	60.1	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
31224531	31224531	PRJNA893346_P_NODE_24755_length_306_cov_1.000000_g24265_i0	PRJNA893346	24755	306	1	3.06	SAR202 cluster bacterium	2030829	Bacteria	Bacteria	43.5	0.0336	NR	MBM3958752.1	2030829	g24265	i0	31.3	0.784313725490196	80	54	78.4	1	14	253	128	206	MBM3958752.1 sulfurtransferase [SAR202 cluster bacterium]	diamond	240	43.5	1	Bacteria	SAR202 cluster	Bacillati	Chloroflexota	Dehalococcoidia				SAR202 cluster bacterium
31319488	31319488	PRJNA893346_P_NODE_14935_length_402_cov_3.519757_g14447_i0	PRJNA893346	14935	402	3.519757	14.14942314	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	143	2.74e-41	NR	MCB9430965.1	2614247	g14447	i0	55.1	0.947761194029851	127	56	94.8	1	391	11	1	126	MCB9430965.1 profilin [Ardenticatenaceae bacterium]	diamond	381	143	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
32173885	32173885	PRJNA893346_P_NODE_22038_length_327_cov_1.417323_g21549_i0	PRJNA893346	22038	327	1.4173230000000001	4.63464621	Anaerolineales bacterium	2073117	Bacteria	Bacteria	43.5	0.0466	NR	TEU14524.1	2073117	g21549	i0	52.6	0.348623853211009	38	16	34.9	1	229	116	268	303	TEU14524.1 MAG: DNA polymerase III subunit delta' [Anaerolineales bacterium]	diamond	114	43.5	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32276580	32276580	PRJNA893346_P_NODE_12758_length_438_cov_0.843836_g12272_i0	PRJNA893346	12758	438	0.843836	3.69600168	Candidatus Defluviilinea	3140592	Bacteria	Bacteria	140	6.32e-36	NR	HKJ37418.1	2073117	g12272	i0	55.2	6.94520547945205	145	61	98.6	2	436	5	107	248	HKJ37418.1 amidase [Anaerolineales bacterium]	diamond	3042	140	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32426829	32426829	PRJNA893346_P_NODE_27699_length_286_cov_1.230047_g27209_i0	PRJNA893346	27699	286	1.230047	3.51793442	Roseiflexus sp.	2562120	Bacteria	Bacteria	84	4.76e-17	NR	MCS6842404.1	2562120	g27209	i0	48.2	0.891608391608392	85	43	88.1	1	285	34	180	264	MCS6842404.1 hypothetical protein [Roseiflexus sp.]	diamond	255	84	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp.
32426838	32426838	PRJNA893346_P_NODE_7279_length_594_cov_0.877159_g6808_i0	PRJNA893346	7279	594	0.877159	5.21032446	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	139	1.32e-36	NR	MEZ4675639.1	2614250	g6808	i0	45.4	3.68686868686869	185	85	90.9	4	592	53	132	305	MEZ4675639.1 ribokinase [Caldilineaceae bacterium]	diamond	2190	139	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae 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);;