metadata: contig_metadata: 10 rows where bioproject = "PRJNA782551", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJNA782551", 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
5867204	5867204	PRJNA782551_P_NODE_22225_length_244_cov_0.900585_g22103_i0	PRJNA782551	22225	244	0.900585	2.1974274	Roseisolibacter agri	2014610	Bacteria	Bacteria	165	1.64e-45	NR	WP_284352572.1	2014610	g22103	i0	90.1	0.995901639344262	81	8	99.6	0	2	244	218	298	WP_284352572.1 copper resistance system multicopper oxidase [Roseisolibacter agri]	diamond	243	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
16066076	16066076	PRJNA782551_P_NODE_16673_length_250_cov_0.870056_g16551_i0	PRJNA782551	16673	250	0.870056	2.17514	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	151	1.45e-40	NR	HEX5581326.1	2026741	g16551	i0	84.3	1.992	83	13	99.6	0	250	2	426	508	HEX5581326.1 penicillin acylase family protein [Gemmatimonadaceae bacterium]	diamond	498	151	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
16066157	16066157	PRJNA782551_P_NODE_22373_length_244_cov_0.865497_g22251_i0	PRJNA782551	22373	244	0.865497	2.11181268	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	246	9.409999999999999e-61	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g22251	i0	85.294	2.90163934426229	238	35	98	0	3	240	3816291	3816528	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	708	246	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
17341872	17341872	PRJNA782551_P_NODE_17934_length_249_cov_0.875000_g17812_i0	PRJNA782551	17934	249	0.875	2.17875	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	167	7.709999999999999e-37	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g17812	i0	79.032	1.24497991967871	248	48	98	4	4	248	1511561	1511315	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	310	167	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22441063	22441063	PRJNA782551_P_NODE_22858_length_243_cov_0.905882_g22736_i0	PRJNA782551	22858	243	0.905882	2.20129326	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	85.9	1.4e-18	NR	GJG89546.1	2839016	g22736	i0	84.8	0.567901234567901	46	7	56.8	0	1	138	43	88	GJG89546.1 IS6 family transposase [Gemmatimonadetes bacterium T265]	diamond	138	85.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
27315977	27315977	PRJNA782551_P_NODE_21103_length_245_cov_0.895349_g20981_i0	PRJNA782551	21103	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	42.4	0.0465	NR	MEO5904102.1	2026741	g20981	i0	38.9	0.869387755102041	36	22	44.1	0	149	42	125	160	MEO5904102.1 cytochrome b/b6 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	213	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27558966	27558966	PRJNA782551_P_NODE_22964_length_243_cov_0.905882_g22842_i0	PRJNA782551	22964	243	0.905882	2.20129326	Roseisolibacter agri	2014610	Bacteria	Bacteria	150	4.42e-40	NR	WP_284349376.1	2014610	g22842	i0	86.3	0.987654320987654	80	11	98.8	0	3	242	142	221	WP_284349376.1 ABC transporter permease [Roseisolibacter agri]	diamond	240	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
31168527	31168527	PRJNA782551_P_NODE_17255_length_250_cov_0.870056_g17133_i0	PRJNA782551	17255	250	0.870056	2.17514	Gemmatirosa	1706036	Bacteria	Bacteria	124	2.44e-34	NR	HEY0777143.1	2510638	g17133	i0	88.1	1.608	67	8	80.4	0	3	203	89	155	HEY0777143.1 hypothetical protein [Gemmatirosa sp.]	diamond	402	124	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
31380973	31380973	PRJNA782551_P_NODE_23876_length_242_cov_0.911243_g23754_i0	PRJNA782551	23876	242	0.911243	2.20520806	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	138	2.42e-37	NR	HSJ14029.1	2910168	g23754	i0	81.3	0.991735537190083	80	15	99.2	0	2	241	187	266	HSJ14029.1 DNA-processing protein DprA [Longimicrobiales bacterium]	diamond	240	138	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32866218	32866218	PRJNA782551_P_NODE_15700_length_251_cov_0.865169_g15578_i0	PRJNA782551	15700	251	0.865169	2.17157419	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	145	3.64e-39	NR	HEY5491728.1	2026741	g15578	i0	81.9	0.99203187250996006	83	15	99.2	0	251	3	22	104	HEY5491728.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	249	145	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;