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

10 rows where bioproject = "PRJNA1188114", 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
320077	320077	PRJNA1188114_P_NODE_18541_length_162_cov_0.902655_g18489_i0	PRJNA1188114	18541	162	0.902655	1.4623011	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	169	1.28e-37	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g18489	i0	86.452	14.7469135802469	155	19	95	2	9	162	2107147	2106994	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	2389	169	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1594711	1594711	PRJNA1188114_P_NODE_4642_length_210_cov_2.801242_g4590_i0	PRJNA1188114	4642	210	2.801242	5.8826082	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	62	3.67e-9	NR	GJG85531.1	2839016	g4590	i0	90.6	0.457142857142857	32	3	45.7	0	206	111	177	208	GJG85531.1 type II secretion system protein F [Gemmatimonadetes bacterium T265]	diamond	96	62	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
5423193	5423193	PRJNA1188114_P_NODE_9285_length_178_cov_1.565891_g9233_i0	PRJNA1188114	9285	178	1.565891	2.78728598	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	143	8.689999999999998e-30	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g9233	i0	82.716	0.910112359550562	162	26	90	2	1	161	3794805	3794645	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	162	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
7973226	7973226	PRJNA1188114_P_NODE_12067_length_167_cov_1.330508_g12015_i0	PRJNA1188114	12067	167	1.330508	2.22194836	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	57	5.38e-8	NR	HEX7980228.1	2026741	g12015	i0	53.6	1.0059880239521	56	25	98.8	1	3	167	84	139	HEX7980228.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	168	57	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
14349050	14349050	PRJNA1188114_P_NODE_19312_length_161_cov_0.910714_g19260_i0	PRJNA1188114	19312	161	0.910714	1.46624954	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	121	3.62e-23	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g19260	i0	89.474	1.35403726708075	95	10	59	0	65	159	4901141	4901047	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	218	121	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
18171559	18171559	PRJNA1188114_P_NODE_13095_length_166_cov_1.589744_g13043_i0	PRJNA1188114	13095	166	1.589744	2.63897504	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	104	2.23e-24	NR	HEU5261291.1	2448054	g13043	i0	89.1	0.993975903614458	55	6	99.4	0	165	1	210	264	HEU5261291.1 L-glutamate gamma-semialdehyde dehydrogenase [Gemmatimonadales bacterium]	diamond	165	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29093591	29093591	PRJNA1188114_P_NODE_16868_length_163_cov_0.894737_g16816_i0	PRJNA1188114	16868	163	0.894737	1.45842131	Longimicrobium sp.	2029185	Bacteria	Bacteria	103	4.25e-24	NR	HLM68793.1	2029185	g16816	i0	88.9	0.993865030674847	54	6	99.4	0	163	2	19	72	HLM68793.1 outer membrane beta-barrel family protein [Longimicrobium sp.]	diamond	162	103	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29901967	29901967	PRJNA1188114_P_NODE_18671_length_162_cov_0.902655_g18619_i0	PRJNA1188114	18671	162	0.902655	1.4623011	Gemmatimonadaceae	219687	Bacteria	Bacteria	47.4	2.86e-4	NR	WP_284348512.1	2014610	g18619	i0	55.8	1.92592592592593	52	23	96.3	0	158	3	160	211	WP_284348512.1 EAL domain-containing protein [Roseisolibacter agri]	diamond	312	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
31052081	31052081	PRJNA1188114_P_NODE_15915_length_164_cov_0.886957_g15863_i0	PRJNA1188114	15915	164	0.886957	1.45460948	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	107	1.26e-25	NR	HNV77469.1	2026741	g15863	i0	83.3	7.90243902439024	54	9	98.8	0	162	1	64	117	HNV77469.1 prolyl oligopeptidase family serine peptidase [Gemmatimonadaceae bacterium]	diamond	1296	107	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32632822	32632822	PRJNA1188114_P_NODE_15640_length_164_cov_0.886957_g15588_i0	PRJNA1188114	15640	164	0.886957	1.45460948	Longimicrobium sp.	2029185	Bacteria	Bacteria	109	3.29e-26	NR	HYW11784.1	2029185	g15588	i0	94.4	0.98780487804878	54	3	98.8	0	2	163	868	921	HYW11784.1 alpha-2-macroglobulin family protein [Longimicrobium sp.]	diamond	162	109	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.

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