metadata: contig_metadata: 7 rows where bioproject = "PRJNA608660" and tax

7 rows where bioproject = "PRJNA608660" 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_species
27364890	27364890	PRJNA608660_P_NODE_20663_length_308_cov_7.301158_g20307_i0	PRJNA608660	20663	308	7.301158	22.48756664	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	55.1	3.77e-6	NR	HEX8681127.1	2614247	g20307	i0	50	0.545454545454545	56	28	54.5	0	297	130	754	809	HEX8681127.1 DUF2157 domain-containing protein [Ardenticatenaceae bacterium]	diamond	168	55.1	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatenaceae bacterium
29605987	29605987	PRJNA608660_P_NODE_23930_length_278_cov_2.947598_g23574_i0	PRJNA608660	23930	278	2.947598	8.19432244	Chloroflexia bacterium	2448782	Bacteria	Bacteria	168	3.96e-49	NR	MBA2595900.1	2448782	g23574	i0	90.2	1.98561151079137	92	9	99.3	0	278	3	113	204	MBA2595900.1 N-acetylmuramoyl-L-alanine amidase [Chloroflexia bacterium]	diamond	552	168	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			Chloroflexia bacterium
29669147	29669147	PRJNA608660_P_NODE_47470_length_166_cov_0.888889_g47113_i0	PRJNA608660	47470	166	0.888889	1.47555574	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	67	4.49e-12	NR	HEX5572665.1	2306968	g47113	i0	63	1.95180722891566	54	20	97.6	0	163	2	15	68	HEX5572665.1 DNA alkylation repair protein [Ktedonobacterales bacterium]	diamond	324	67	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales		Ktedonobacterales bacterium
30333345	30333345	PRJNA608660_P_NODE_33692_length_215_cov_2.506024_g33336_i0	PRJNA608660	33692	215	2.506024	5.3879516	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	41.2	0.0497	NR	HLY14913.1	2952938	g33336	i0	50	0.586046511627907	42	21	58.6	0	46	171	58	99	HLY14913.1 YbaK/EbsC family protein [Candidatus Limnocylindrales bacterium]	diamond	126	41.2	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales		Candidatus Limnocylindrales bacterium
32166750	32166750	PRJNA608660_P_NODE_32058_length_224_cov_1.188571_g31702_i0	PRJNA608660	32058	224	1.188571	2.66239904	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.9	0.0114	NR	TMF18297.1	2026724	g31702	i0	45.6	0.763392857142857	57	25	69.6	2	50	205	14	69	TMF18297.1 MAG: hypothetical protein E6I33_00085 [Chloroflexota bacterium]	diamond	171	43.9	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
32230050	32230050	PRJNA608660_P_NODE_3518_length_743_cov_11.801153_g3262_i0	PRJNA608660	3518	743	11.801153	87.68256679	Candidatus Limnocylindria bacterium	3047546	Bacteria	Bacteria	115	3.53e-27	NR	HET9498048.1	3047546	g3262	i0	37.1	3.2907133243607	221	129	86	5	730	92	26	244	HET9498048.1 lipoyl(octanoyl) transferase LipB [Candidatus Limnocylindria bacterium]	diamond	2445	115	1	Bacteria	Bacillati	Chloroflexota	Candidatus Limnocylindria			Candidatus Limnocylindria bacterium
32703649	32703649	PRJNA608660_P_NODE_3560_length_739_cov_33.263768_g3304_i0	PRJNA608660	3560	739	33.263768	245.81924552	Chloroflexales bacterium	2725990	Bacteria	Bacteria	97.4	3.29e-19	NR	MEI7771350.1	2725990	g3304	i0	47.1	0.751014884979702	87	44	35.3	1	136	396	29	113	MEI7771350.1 terminase family protein [Chloroflexales bacterium]	diamond	555	97.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales		Chloroflexales 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);;