metadata: contig_metadata: 14 rows where bioproject = "PRJNA849646", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA849646", 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
4666876	4666876	PRJNA849646_P_NODE_4744_length_310_cov_3.438819_g4626_i0	PRJNA849646	4744	310	3.438819	10.6603389	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	85.5	7.32e-17	NR	HKG95214.1	2026741	g4626	i0	81.3	0.464516129032258	48	9	46.5	0	308	165	265	312	HKG95214.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium]	diamond	144	85.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
17416475	17416475	PRJNA849646_P_NODE_28994_length_251_cov_2.073034_g28876_i0	PRJNA849646	28994	251	2.073034	5.20331534	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	163	1.01e-35	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g28876	i0	78.571	1.00398406374502	252	50	99	4	1	250	1459317	1459566	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	252	163	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17416493	17416493	PRJNA849646_P_NODE_30534_length_250_cov_0.870056_g30416_i0	PRJNA849646	30534	250	0.870056	2.17514	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	351	1.99e-92	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g30416	i0	92	98.988	250	20	100	0	1	250	4458507	4458258	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	24747	351	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
19964507	19964507	PRJNA849646_P_NODE_14196_length_279_cov_2.781553_g14078_i0	PRJNA849646	14196	279	2.781553	7.76053287	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	339	1.7599999999999998e-88	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g14078	i0	89.051	11.2329749103943	274	28	98	2	1	273	3488306	3488578	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	3134	339	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
21240171	21240171	PRJNA849646_P_NODE_18817_length_270_cov_3.406091_g18699_i0	PRJNA849646	18817	270	3.406091	9.1964457	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	311	3.7e-80	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g18699	i0	87.546	29.2555555555556	273	29	100	5	1	270	782769	783039	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	7899	311	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
22514835	22514835	PRJNA849646_P_NODE_14578_length_279_cov_1.339806_g14460_i0	PRJNA849646	14578	279	1.339806	3.73805874	Roseisolibacter sp. H3M3-2	3031323	Bacteria	Bacteria	166	3.619999999999999e-48	NR	WP_275836742.1	3031323	g14460	i0	92.5	1	93	7	100	0	1	279	153	245	WP_275836742.1 phosphate ABC transporter substrate-binding protein PstS, partial [Roseisolibacter sp. H3M3-2]	diamond	279	166	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter sp. H3M3-2
26865332	26865332	PRJNA849646_P_NODE_18821_length_270_cov_3.304569_g18703_i0	PRJNA849646	18821	270	3.304569	8.9223363	Gemmatirosa sp.	2510638	Bacteria	Bacteria	67	1.12e-10	NR	MBV9880697.1	2510638	g18703	i0	50	1	90	40	98.9	3	1	267	158	243	MBV9880697.1 universal stress protein [Gemmatirosa sp.]	diamond	270	67	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
27979158	27979158	PRJNA849646_P_NODE_14145_length_279_cov_3.820388_g14027_i0	PRJNA849646	14145	279	3.820388	10.65888252	Gemmatirosa	1706036	Bacteria	Bacteria	87.8	2.27e-18	NR	WP_025411612.1	861299	g14027	i0	84.9	1.13978494623656	53	8	57	0	120	278	6	58	WP_025411612.1 histidine kinase dimerization/phospho-acceptor domain-containing protein [Gemmatirosa kalamazoonensis]	diamond	318	87.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
28286406	28286406	PRJNA849646_P_NODE_36706_length_243_cov_0.905882_g36588_i0	PRJNA849646	36706	243	0.905882	2.20129326	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	167	3.62e-47	NR	HET9727723.1	2448054	g36588	i0	97.5	1.96296296296296	79	2	97.5	0	241	5	256	334	HET9727723.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Gemmatimonadales bacterium]	diamond	477	167	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29454471	29454471	PRJNA849646_P_NODE_16090_length_276_cov_1.344828_g15972_i0	PRJNA849646	16090	276	1.344828	3.71172528	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	119	1.34e-30	NR	HEY0971603.1	2448054	g15972	i0	68.2	2.72826086956522	85	27	92.4	0	255	1	127	211	HEY0971603.1 TIGR01777 family oxidoreductase [Gemmatimonadales bacterium]	diamond	753	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30023517	30023517	PRJNA849646_P_NODE_41411_length_229_cov_2.884615_g41293_i0	PRJNA849646	41411	229	2.884615	6.60576835	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	116	4.46e-29	NR	HUQ19331.1	2026741	g41293	i0	78.1	2.882096069869	73	16	95.6	0	10	228	298	370	HUQ19331.1 MFS transporter [Gemmatimonadaceae bacterium]	diamond	660	116	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30813152	30813152	PRJNA849646_P_NODE_26634_length_255_cov_8.714286_g26516_i0	PRJNA849646	26634	255	8.714286	22.2214293	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.1	0.0282	NR	MEO7965368.1	2026741	g26516	i0	46.2	0.611764705882353	52	28	61.2	0	255	100	194	245	MEO7965368.1 DotU family type IV/VI secretion system protein [Gemmatimonadaceae bacterium]	diamond	156	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30853056	30853056	PRJNA849646_P_NODE_26294_length_256_cov_2.377049_g26176_i0	PRJNA849646	26294	256	2.377049	6.08524544	Pseudomonadati	3379134	Bacteria	Bacteria	47.4	9.64e-4	NR	MFL5580492.1	2026741	g26176	i0	58.3	1.76953125	36	15	42.2	0	110	3	10	45	MFL5580492.1 acyltransferase family protein [Gemmatimonadaceae bacterium]	diamond	453	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32521284	32521284	PRJNA849646_P_NODE_15819_length_276_cov_2.103448_g15701_i0	PRJNA849646	15819	276	2.103448	5.80551648	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	117	1.77e-29	NR	GJG87985.1	2839016	g15701	i0	65.6	0.978260869565217	90	31	97.8	0	7	276	39	128	GJG87985.1 membrane protein [Gemmatimonadetes bacterium T265]	diamond	270	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265

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