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

8 rows where bioproject = "PRJNA800053", 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
14824575	14824575	PRJNA800053_P_NODE_16792_length_254_cov_1.436464_g16628_i0	PRJNA800053	16792	254	1.436464	3.64861856	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	388	1.5499999999999998e-103	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g16628	i0	98.198	138.157480314961	222	4	87	0	4	225	421773	421994	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	35092	388	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18647757	18647757	PRJNA800053_P_NODE_8655_length_326_cov_1.434783_g8491_i0	PRJNA800053	8655	326	1.434783	4.67739258	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	320	7.61e-83	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g8491	i0	84.923	66.4355828220859	325	39	98	9	4	322	3042327	3042647	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	21658	320	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
19923005	19923005	PRJNA800053_P_NODE_1836_length_619_cov_1.703297_g1682_i0	PRJNA800053	1836	619	1.703297	10.54340843	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	470	1.43e-127	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g1682	i0	85.683	78.9386106623586	461	49	98	15	3	456	420876	421326	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	48863	470	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27843599	27843599	PRJNA800053_P_NODE_24864_length_227_cov_2.792208_g24700_i0	PRJNA800053	24864	227	2.792208	6.33831216	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	62.4	3e-9	NR	GIT52433.1	2026742	g24700	i0	54.5	0.726872246696035	55	25	72.7	0	59	223	1	55	GIT52433.1 MAG: hypothetical protein Ct9H300mP15_26460 [Gemmatimonadota bacterium]	diamond	165	62.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28917058	28917058	PRJNA800053_P_NODE_22368_length_243_cov_0.905882_g22204_i0	PRJNA800053	22368	243	0.905882	2.20129326	Gemmatirosa sp.	2510638	Bacteria	Bacteria	65.5	1.25e-10	NR	HZF67357.1	2510638	g22204	i0	68.8	0.592592592592593	48	11	54.3	1	243	112	174	221	HZF67357.1 transcriptional repressor LexA [Gemmatirosa sp.]	diamond	144	65.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
29012334	29012334	PRJNA800053_P_NODE_18508_length_249_cov_1.329545_g18344_i0	PRJNA800053	18508	249	1.329545	3.31056705	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	125	1.11e-32	NR	MBK8249223.1	2026742	g18344	i0	75.3	0.975903614457831	81	20	97.6	0	244	2	7	87	MBK8249223.1 D-glycerate dehydrogenase [Gemmatimonadota bacterium]	diamond	243	125	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31263740	31263740	PRJNA800053_P_NODE_21415_length_245_cov_0.895349_g21251_i0	PRJNA800053	21415	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	115	8.16e-28	NR	MCC6244825.1	2026741	g21251	i0	70.9	1.9469387755102	79	23	96.7	0	244	8	367	445	MCC6244825.1 response regulator [Gemmatimonadaceae bacterium]	diamond	477	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32907047	32907047	PRJNA800053_P_NODE_12060_length_287_cov_1.126168_g11896_i0	PRJNA800053	12060	287	1.126168	3.23210216	Pseudomonadati	3379134	Bacteria	Bacteria	95.5	3.96e-22	NR	WP_291163363.1	1946568	g11896	i0	55.3	4.39024390243902	85	35	88.9	1	270	16	113	194	WP_291163363.1 hypothetical protein [Gemmatimonas sp. UBA7669]	diamond	1260	96.3	0.991692627206646	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. UBA7669

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