metadata: contig_metadata: 5 rows where bioproject = "PRJNA565778", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA565778", 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
15163872	15163872	PRJNA565778_S_NODE_20172_length_246_cov_107.224880_g19876_i0	PRJNA565778	20172	246	107.22488	263.7732048	Chloroflexaceae bacterium	2562117	Bacteria	Bacteria	133	2.6699999999999996e-35	NR	HMQ31840.1	2562117	g19876	i0	92.8	2.52439024390244	69	5	84.1	0	207	1	256	324	HMQ31840.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPA [Chloroflexaceae bacterium]	diamond	621	133	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae		Chloroflexaceae bacterium
27395770	27395770	PRJNA565778_S_NODE_16283_length_274_cov_3.177215_g15987_i0	PRJNA565778	16283	274	3.177215	8.7055691	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	105	4.55e-24	NR	HET9111491.1	2306968	g15987	i0	82.8	0.700729927007299	64	11	70.1	0	6	197	670	733	HET9111491.1 hypothetical protein [Ktedonobacterales bacterium]	diamond	192	105	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
29227086	29227086	PRJNA565778_S_NODE_3269_length_551_cov_3.538911_g3082_i0	PRJNA565778	3269	551	3.538911	19.49939961	Anaerolineales bacterium	2073117	Bacteria	Bacteria	140	7.26e-36	NR	HRE27638.1	2073117	g3082	i0	43	5.53720508166969	149	84	80.6	1	455	12	73	221	HRE27638.1 helix-hairpin-helix domain-containing protein [Anaerolineales bacterium]	diamond	3051	140	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29890100	29890100	PRJNA565778_S_NODE_18451_length_258_cov_2.384615_g18155_i0	PRJNA565778	18451	258	2.384615	6.1523067	Chloroflexota bacterium	2026724	Bacteria	Bacteria	110	3.5100000000000004e-26	NR	NWF79095.1	2026724	g18155	i0	87.1	1.44186046511628	62	8	72.1	0	256	71	380	441	NWF79095.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPA [Chloroflexota bacterium]	diamond	372	110	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32671567	32671567	PRJNA565778_S_NODE_11400_length_323_cov_428.216783_g11104_i0	PRJNA565778	11400	323	428.216783	1383.14020909	Ktedonosporobacter sp.	2692419	Bacteria	Bacteria	72.4	3.8e-12	NR	HLG60400.1	2692419	g11104	i0	50	2.11764705882353	76	37	70.6	1	284	57	893	967	HLG60400.1 amino acid adenylation domain-containing protein [Ktedonosporobacter sp.]	diamond	684	72.4	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter sp.

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);;