metadata: contig_metadata: 8 rows where bioproject = "PRJNA577580", tax_clade = "FCB group" and tax

8 rows where bioproject = "PRJNA577580", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

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_species
17141724	17141724	PRJNA577580_P_NODE_954_length_900_cov_3.822249_g890_i0	PRJNA577580	954	900	3.822249	34.400241	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	238	3.3100000000000006e-73	NR	MEJ2187353.1	2026742	g890	i0	46.7	0.97	291	142	96.3	6	2	868	53	332	MEJ2187353.1 M20/M25/M40 family metallo-hydrolase [Gemmatimonadota bacterium]	diamond	873	238	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
26618300	26618300	PRJNA577580_P_NODE_13241_length_255_cov_1.593407_g13163_i0	PRJNA577580	13241	255	1.593407	4.06318785	FCB group	1783270	Bacteria	Bacteria	68.2	3.68e-11	NR	HEX8942952.1	2026741	g13163	i0	38.3	7.68235294117647	81	49	95.3	1	2	244	57	136	HEX8942952.1 ferritin-like protein [Gemmatimonadaceae bacterium]	diamond	1959	68.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
27124418	27124418	PRJNA577580_P_NODE_5042_length_399_cov_3.297546_g4964_i0	PRJNA577580	5042	399	3.297546	13.15720854	Pseudomonadati	3379134	Bacteria	Bacteria	109	1.51e-25	NR	MBT8396589.1	2026742	g4964	i0	47.8	4.37593984962406	113	59	85	0	2	340	221	333	MBT8396589.1 aminotransferase class V-fold PLP-dependent enzyme [Gemmatimonadota bacterium]	diamond	1746	110	0.990909090909091	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
27819861	27819861	PRJNA577580_P_NODE_10524_length_283_cov_1.485714_g10446_i0	PRJNA577580	10524	283	1.485714	4.20457062	Pseudomonadati	3379134	Bacteria	Bacteria	66.6	1.74e-10	NR	MBL8959732.1	2026742	g10446	i0	54.2	2.90459363957597	59	21	56.2	1	118	276	137	195	MBL8959732.1 pyridoxal-phosphate dependent enzyme [Gemmatimonadota bacterium]	diamond	822	66.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
29132459	29132459	PRJNA577580_P_NODE_9629_length_294_cov_3.891403_g9551_i0	PRJNA577580	9629	294	3.891403	11.44072482	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	47.4	0.00161	NR	HEX7938559.1	2026741	g9551	i0	37.9	0.591836734693878	58	31	59.2	1	174	1	318	370	HEX7938559.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	174	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
30237642	30237642	PRJNA577580_P_NODE_15752_length_244_cov_1.368421_g15674_i0	PRJNA577580	15752	244	1.368421	3.33894724	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.1	0.0236	NR	HEX9631870.1	2448054	g15674	i0	29.7	1.86885245901639	74	51	91	1	11	232	65	137	HEX9631870.1 chalcone isomerase family protein [Gemmatimonadales bacterium]	diamond	456	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
30440827	30440827	PRJNA577580_P_NODE_9493_length_296_cov_2.565022_g9415_i0	PRJNA577580	9493	296	2.565022	7.59246512	Pseudomonadati	3379134	Bacteria	Bacteria	62.8	6.37e-9	NR	MCH7475869.1	2026742	g9415	i0	47.2	3.88175675675676	72	37	72	1	57	269	628	699	MCH7475869.1 acyl-CoA dehydrogenase family protein [Gemmatimonadota bacterium]	diamond	1149	62.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
30788267	30788267	PRJNA577580_P_NODE_4114_length_444_cov_1.913747_g4036_i0	PRJNA577580	4114	444	1.913747	8.49703668	FCB group	1783270	Bacteria	Bacteria	109	1.2099999999999999e-24	NR	MCA9752280.1	2026742	g4036	i0	44	1.47297297297297	109	61	73.6	0	439	113	262	370	MCA9752280.1 DUF839 domain-containing protein [Gemmatimonadota bacterium]	diamond	654	110	0.990909090909091	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota 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);;