metadata: contig_metadata: 13 rows where bioproject = "PRJNA561212", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJNA561212", 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_genus	tax_species
17122997	17122997	PRJNA561212_P_NODE_15094_length_289_cov_1.828704_g14883_i0	PRJNA561212	15094	289	1.828704	5.28495456	root	1	Root_unresolved	Root_unresolved	132	1.3599999999999999e-34	NR	MCA9721193.1	2026742	g14883	i0	68.1	17.5847750865052	91	29	94.5	0	12	284	86	176	MCA9721193.1 multifunctional oxoglutarate decarboxylase/oxoglutarate dehydrogenase thiamine pyrophosphate-binding subunit/dihydrolipoyllysine-residue succinyltransferase subunit [Gemmatimonadota bacterium]	diamond	5082	133	0.992481203007519	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
26712941	26712941	PRJNA561212_P_NODE_12961_length_310_cov_1.059072_g12750_i0	PRJNA561212	12961	310	1.059072	3.2831232	FCB group	1783270	Bacteria	Bacteria	101	2.14e-22	NR	WP_015895729.1	173480	g12750	i0	58.2	4.93548387096774	79	32	76.5	1	239	3	379	456	WP_015895729.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonas aurantiaca]	diamond	1530	101	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
26871897	26871897	PRJNA561212_P_NODE_13321_length_306_cov_1.266094_g13110_i0	PRJNA561212	13321	306	1.266094	3.87424764	Longimicrobium	1804994	Bacteria	Bacteria	97.4	4.63e-21	NR	CAA9378493.1	203437	g13110	i0	51	5.66666666666667	96	44	92.2	2	292	11	389	483	CAA9378493.1 MAG: hypothetical protein AVDCRST_MAG89-5194 [uncultured Gemmatimonadota bacterium]	diamond	1734	97.8	0.995910020449898	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
27472332	27472332	PRJNA561212_P_NODE_17843_length_269_cov_1.265306_g17632_i0	PRJNA561212	17843	269	1.265306	3.40367314	Gemmatimonadia	219685	Bacteria	Bacteria	58.5	1.36e-7	NR	HKV76217.1	2448054	g17632	i0	36.1	3.52416356877323	83	50	92.6	1	260	12	223	302	HKV76217.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium]	diamond	948	58.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28121345	28121345	PRJNA561212_P_NODE_10105_length_347_cov_1.295620_g9894_i0	PRJNA561212	10105	347	1.29562	4.4958014	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.9	0.0394	NR	MEP6780091.1	2026741	g9894	i0	31.5	0.795389048991354	92	61	77.8	1	271	2	2	93	MEP6780091.1 ABC transporter ATP-binding protein [Gemmatimonadaceae bacterium]	diamond	276	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28531990	28531990	PRJNA561212_P_NODE_3227_length_614_cov_1.658041_g3022_i0	PRJNA561212	3227	614	1.658041	10.18037174	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	135	1.33e-33	NR	MBA3760570.1	2448054	g3022	i0	43.2	1.78338762214984	192	93	87.5	5	570	34	280	468	MBA3760570.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	1095	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29352878	29352878	PRJNA561212_P_NODE_2509_length_692_cov_2.544426_g2305_i0	PRJNA561212	2509	692	2.544426	17.60742792	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	143	5.950000000000001e-36	NR	MBA3760570.1	2448054	g2305	i0	39.7	0.927745664739884	214	116	87.6	5	679	74	248	460	MBA3760570.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	642	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29542077	29542077	PRJNA561212_P_NODE_10070_length_348_cov_0.912727_g9859_i0	PRJNA561212	10070	348	0.912727	3.17628996	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	81.6	2.5e-15	NR	MFL5535698.1	2448054	g9859	i0	41.1	7.56034482758621	95	54	81.9	1	291	7	232	324	MFL5535698.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	2631	81.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29745301	29745301	PRJNA561212_P_NODE_25890_length_242_cov_0.923077_g25679_i0	PRJNA561212	25890	242	0.923077	2.23384634	Pseudomonadati	3379134	Bacteria	Bacteria	62	5.9e-9	NR	HUF89944.1	2026742	g25679	i0	53.7	4.5495867768595	67	23	81.8	3	45	242	312	371	HUF89944.1 alpha/beta fold hydrolase [Gemmatimonadota bacterium]	diamond	1101	62	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31596316	31596316	PRJNA561212_P_NODE_1216_length_977_cov_2.735619_g1053_i0	PRJNA561212	1216	977	2.735619	26.72699763	Longimicrobium sp.	2029185	Bacteria	Bacteria	120	4.34e-28	NR	WP_331878696.1	2029185	g1053	i0	46.4	0.847492323439099	140	67	40.8	4	958	560	33	171	WP_331878696.1 leishmanolysin-related zinc metalloendopeptidase, partial [Longimicrobium sp.]	diamond	828	120	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31912388	31912388	PRJNA561212_P_NODE_2017_length_768_cov_4.797122_g971_i1	PRJNA561212	2017	768	4.797122	36.84189696	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	180	2.06e-49	NR	HEY6223032.1	2448054	g971	i1	39.3	2.93359375	262	141	96.9	6	755	12	247	504	HEY6223032.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium]	diamond	2253	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32513875	32513875	PRJNA561212_P_NODE_11199_length_331_cov_1.155039_g10988_i0	PRJNA561212	11199	331	1.155039	3.82317909	Longimicrobium sp.	2029185	Bacteria	Bacteria	44.3	0.0286	NR	WP_414683004.1	2029185	g10988	i0	41.7	0.54380664652568	60	35	54.4	0	274	95	303	362	WP_414683004.1 reverse transcriptase domain-containing protein [Longimicrobium sp.]	diamond	180	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32702678	32702678	PRJNA561212_P_NODE_25320_length_243_cov_0.917647_g25109_i0	PRJNA561212	25320	243	0.917647	2.22988221	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.8	5.43e-5	NR	MDE2733948.1	2026742	g25109	i0	49.1	0.703703703703704	57	26	70.4	1	28	198	1021	1074	MDE2733948.1 leucine-rich repeat domain-containing protein [Gemmatimonadota bacterium]	diamond	171	50.8	1	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);;