metadata: contig_metadata: 8 rows where bioproject = "PRJNA861969", tax_phylum = "Chloroflexota" and tax

8 rows where bioproject = "PRJNA861969", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"

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
846504	846504	PRJNA861969_P_NODE_36421_length_246_cov_0.890173_g36190_i0	PRJNA861969	36421	246	0.890173	2.18982558	PVC group	1783257	Bacteria	Bacteria	109	1.58e-26	NR	HWC29319.1	2026734	g36190	i0	71.8	9.47560975609756	71	20	86.6	0	33	245	189	259	HWC29319.1 GTP 3',8-cyclase MoaA [Dehalococcoidia bacterium]	diamond	2331	110	0.990909090909091	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
19973046	19973046	PRJNA861969_P_NODE_33036_length_249_cov_0.875000_g32805_i0	PRJNA861969	33036	249	0.875	2.17875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	353	5.52e-93	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g32805	i0	92.126	526.81124497992	254	15	100	5	1	249	1027500	1027247	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	131176	353	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
28034391	28034391	PRJNA861969_P_NODE_22665_length_286_cov_1.446009_g22434_i0	PRJNA861969	22665	286	1.446009	4.13558574	Chloroflexota bacterium	2026724	Bacteria	Bacteria	47.4	0.00138	NR	HEY8685962.1	2026724	g22434	i0	46.7	0.629370629370629	60	32	62.9	0	272	93	370	429	HEY8685962.1 hypothetical protein [Chloroflexota bacterium]	diamond	180	47.4	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29738959	29738959	PRJNA861969_P_NODE_23910_length_280_cov_1.487923_g23679_i0	PRJNA861969	23910	280	1.487923	4.1661844	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	130	7.04e-33	NR	HEX2844304.1	3047546	g23679	i0	67.7	0.996428571428571	93	30	99.6	0	2	280	16	108	HEX2844304.1 4-alpha-glucanotransferase [Candidatus Limnocylindria bacterium]	diamond	279	130	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria			Candidatus Limnocylindria bacterium
29897264	29897264	PRJNA861969_P_NODE_9531_length_418_cov_1.524638_g9300_i0	PRJNA861969	9531	418	1.524638	6.37298684	Chloroflexia bacterium	2448782	Bacteria	Bacteria	43.1	0.0394	NR	MBA2278354.1	2448782	g9300	i0	36.5	0.5311004784689	74	42	49.5	2	265	59	8	81	MBA2278354.1 YnfA family protein [Chloroflexia bacterium]	diamond	222	43.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			Chloroflexia bacterium
30813356	30813356	PRJNA861969_P_NODE_38734_length_244_cov_0.900585_g38503_i0	PRJNA861969	38734	244	0.900585	2.1974274	Chloroflexales bacterium	2725990	Bacteria	Bacteria	77	1.57e-15	NR	MBC8077218.1	2725990	g38503	i0	62.7	0.922131147540984	75	26	89.8	1	25	243	1	75	MBC8077218.1 ATP synthase F1 subunit delta [Chloroflexales bacterium]	diamond	225	77	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales		Chloroflexales bacterium
30939937	30939937	PRJNA861969_P_NODE_23154_length_284_cov_1.208531_g22923_i0	PRJNA861969	23154	284	1.208531	3.43222804	Chloroflexota bacterium	2026724	Bacteria	Bacteria	81.6	1.03e-15	NR	MBI1256535.1	2026724	g22923	i0	66.7	1.90140845070423	60	20	63.4	0	3	182	358	417	MBI1256535.1 DUF4113 domain-containing protein [Chloroflexota bacterium]	diamond	540	81.6	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
32647008	32647008	PRJNA861969_P_NODE_33620_length_248_cov_1.760000_g33389_i0	PRJNA861969	33620	248	1.76	4.3648	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	157	7.07e-44	NR	HQJ32294.1	2024896	g33389	i0	91.5	1.98387096774194	82	7	99.2	0	248	3	213	294	HQJ32294.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Anaerolineaceae bacterium]	diamond	492	157	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae 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);;