metadata: contig_metadata: 11 rows where bioproject = "PRJNA312107", tax_clade = "FCB group" and tax

11 rows where bioproject = "PRJNA312107", 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
377581	377581	PRJNA312107_P_NODE_22001_length_166_cov_0.888889_g21835_i0	PRJNA312107	22001	166	0.888889	1.47555574	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	122	1.0399999999999997e-23	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g21835	i0	80.723	3.00602409638554	166	24	98	7	2	163	4991492	4991653	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	499	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
11856206	11856206	PRJNA312107_P_NODE_17930_length_172_cov_1.325203_g17764_i0	PRJNA312107	17930	172	1.325203	2.27934916	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	119	1.4000000000000002e-22	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g17764	i0	79.775	2.44767441860465	178	24	100	7	1	172	3055506	3055335	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	421	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16954911	16954911	PRJNA312107_P_NODE_17214_length_176_cov_1.307087_g17048_i0	PRJNA312107	17214	176	1.307087	2.30047312	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	211	2.31e-50	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g17048	i0	89.759	105.198863636364	166	16	94	1	12	176	232902	233067	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	18515	211	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
22054152	22054152	PRJNA312107_P_NODE_22878_length_165_cov_0.896552_g22712_i0	PRJNA312107	22878	165	0.896552	1.4793108	Gemmatimonadetes bacterium 13_2_2	1805203	Bacteria	Bacteria	102	2.8199999999999994e-24	NR	OLB66937.1	1805203	g22712	i0	90.9	5	55	5	100	0	1	165	169	223	OLB66937.1 MAG: 6-phosphofructokinase [Gemmatimonadetes bacterium 13_2_20CM_2_66_5]	diamond	825	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium 13_2_20CM_2_66_5
24603642	24603642	PRJNA312107_P_NODE_20600_length_167_cov_0.881356_g20434_i0	PRJNA312107	20600	167	0.881356	1.47186452	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	117	4.900000000000001e-22	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g20434	i0	80.769	15.8562874251497	156	24	92	5	12	164	714017	714169	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	2648	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
29916454	29916454	PRJNA312107_P_NODE_20691_length_167_cov_0.881356_g20525_i0	PRJNA312107	20691	167	0.881356	1.47186452	Gemmatimonas sp.	1962908	Bacteria	Bacteria	106	1.04e-25	NR	MEQ1694159.1	1962908	g20525	i0	92.7	1.97604790419162	55	4	98.8	0	165	1	37	91	MEQ1694159.1 TonB-dependent receptor [Gemmatimonas sp.]	diamond	330	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
31054007	31054007	PRJNA312107_P_NODE_19015_length_169_cov_0.866667_g18849_i0	PRJNA312107	19015	169	0.866667	1.46466723	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	99	1.99e-22	NR	MBK6842207.1	2026742	g18849	i0	87.5	4.97041420118343	56	7	99.4	0	1	168	105	160	MBK6842207.1 methylmalonyl-CoA mutase [Gemmatimonadota bacterium]	diamond	840	99	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31496576	31496576	PRJNA312107_P_NODE_21596_length_166_cov_0.888889_g21430_i0	PRJNA312107	21596	166	0.888889	1.47555574	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	87.8	5.57e-21	NR	HET7111693.1	2448054	g21430	i0	73.6	1.91566265060241	53	14	95.8	0	159	1	1	53	HET7111693.1 DUF4031 domain-containing protein [Gemmatimonadales bacterium]	diamond	318	87.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31925084	31925084	PRJNA312107_P_NODE_26117_length_162_cov_0.920354_g25951_i0	PRJNA312107	26117	162	0.920354	1.49097348	Longimicrobium	1804994	Bacteria	Bacteria	39.7	0.0454	NR	WP_170039056.1	1639882	g25951	i0	40.8	2.72222222222222	49	27	87	1	6	146	27	75	WP_170039056.1 hypothetical protein [Longimicrobium terrae]	diamond	441	39.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium terrae
32413913	32413913	PRJNA312107_P_NODE_24879_length_163_cov_0.912281_g24713_i0	PRJNA312107	24879	163	0.912281	1.48701803	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	48.5	9.08e-6	NR	MEZ0334830.1	2448054	g24713	i0	68.8	0.588957055214724	32	10	58.9	0	96	1	1	32	MEZ0334830.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	96	48.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32746925	32746925	PRJNA312107_P_NODE_19600_length_168_cov_0.873950_g19434_i0	PRJNA312107	19600	168	0.87395	1.468236	Pseudomonadati	3379134	Bacteria	Bacteria	68.9	1.48e-12	NR	HKV76175.1	2448054	g19434	i0	66.1	3.58928571428571	56	17	96.4	1	2	163	4	59	HKV76175.1 ECF-type sigma factor [Gemmatimonadales bacterium]	diamond	603	69.3	0.994227994227994	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;