metadata: contig_metadata: 6 rows where bioproject = "PRJNA685607", tax_kingdom = "Bacillati" and tax

6 rows where bioproject = "PRJNA685607", 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_genus	tax_species
666324	666324	PRJNA685607_P_NODE_44621_length_289_cov_1.314815_g44262_i0	PRJNA685607	44621	289	1.314815	3.79981535	Anaerolineales bacterium	2073117	Bacteria	Bacteria	148	8.83e-40	NR	MCA9992291.1	2073117	g44262	i0	75.5	2.92733564013841	94	23	97.6	0	283	2	149	242	MCA9992291.1 NAD-dependent malic enzyme [Anaerolineales bacterium]	diamond	846	148	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
7044929	7044929	PRJNA685607_P_NODE_22386_length_362_cov_1.065744_g22027_i0	PRJNA685607	22386	362	1.065744	3.85799328	PVC group	1783257	Bacteria	Bacteria	186	1.32e-54	NR	WP_200808152.1	1495650	g22027	i0	66.7	13.8977900552486	120	40	99.4	0	2	361	229	348	WP_200808152.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Thermoflexus hugenholtzii]	diamond	5031	187	0.994652406417112	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales	Thermoflexaceae	Thermoflexus	Thermoflexus hugenholtzii
13420359	13420359	PRJNA685607_P_NODE_73931_length_248_cov_0.880000_g73572_i0	PRJNA685607	73931	248	0.88	2.1824	Bacillati	1783272	Bacteria	Bacteria	140	5e-38	NR	MBI5828431.1	2026724	g73572	i0	81	4.86290322580645	79	15	95.6	0	241	5	93	171	MBI5828431.1 aspartate aminotransferase family protein [Chloroflexota bacterium]	diamond	1206	140	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
23619360	23619360	PRJNA685607_P_NODE_95159_length_241_cov_0.916667_g94800_i0	PRJNA685607	95159	241	0.916667	2.20916747	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621703475\|emb\|OY762538.1\|	3022862	g94800	i0	100	0.120331950207469	29	0	12	0	165	193	1052349	1052321	MAG: Tepidiformaceae bacterium isolate 22918afd-2252-4b5b-9d47-9fe66d5d45bf genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
26892589	26892589	PRJNA685607_P_NODE_37921_length_306_cov_0.991416_g37562_i0	PRJNA685607	37921	306	0.991416	3.03373296	Anaerolineae bacterium	2052143	Bacteria	Bacteria	43.1	0.0454	NR	HUT17765.1	2052143	g37562	i0	31.5	0.901960784313726	92	58	85.3	2	45	305	140	231	HUT17765.1 response regulator transcription factor [Anaerolineae bacterium]	diamond	276	43.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30872054	30872054	PRJNA685607_P_NODE_72474_length_249_cov_0.875000_g72115_i0	PRJNA685607	72474	249	0.875	2.17875	Chloroflexota bacterium	2026724	Bacteria	Bacteria	133	1.52e-36	NR	MBM3136615.1	2026724	g72115	i0	68.7	7.93975903614458	83	26	100	0	249	1	19	101	MBM3136615.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Chloroflexota bacterium]	diamond	1977	133	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);;