metadata: contig_metadata: 19 rows where bioproject = "PRJNA526367", tax_clade = "FCB group" and tax

19 rows where bioproject = "PRJNA526367", 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
4322704	4322704	PRJNA526367_P_NODE_23704_length_324_cov_2.123636_g23495_i0	PRJNA526367	23704	324	2.123636	6.88058064	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	132	3.8e-26	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g23495	i0	98.649	19.4413580246914	74	1	23	0	27	100	2157487	2157560	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	6299	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
6873859	6873859	PRJNA526367_P_NODE_49806_length_167_cov_6.152542_g49596_i0	PRJNA526367	49806	167	6.152542	10.27474514	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	180	6.16e-41	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g49596	i0	87.421	0.952095808383233	159	16	94	3	8	164	4680175	4680331	Gemmatimonas phototrophica strain AP64, complete genome	blastn	159	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
13867322	13867322	PRJNA526367_P_NODE_22431_length_324_cov_2.232727_g22222_i0	PRJNA526367	22431	324	2.232727	7.23403548	Gemmatimonas	173479	Bacteria	Bacteria	185	2.88e-42	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g22222	i0	100	68.0246913580247	100	0	60	0	1	100	2480	2381	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	22040	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
13867540	13867540	PRJNA526367_P_NODE_35891_length_190_cov_5.354610_g35681_i0	PRJNA526367	35891	190	5.35461	10.173759	Gemmatimonas	173479	Bacteria	Bacteria	217	5.469999999999999e-52	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g35681	i0	88.764	8.74210526315789	178	18	93	2	1	177	1319	1495	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	1661	217	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
14524720	14524720	PRJNA526367_P_NODE_22272_length_324_cov_2.247273_g22063_i0	PRJNA526367	22272	324	2.247273	7.28116452	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	117	1.06e-21	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g22063	i0	89.362	0.867283950617284	94	8	29	2	227	319	3045172	3045264	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	281	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15798727	15798727	PRJNA526367_P_NODE_43533_length_177_cov_2.085938_g43323_i0	PRJNA526367	43533	177	2.085938	3.69211026	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	230	6.439999999999999e-56	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g43323	i0	90.751	11.9717514124294	173	15	97	1	6	177	6466279	6466107	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2119	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16416436	16416436	PRJNA526367_P_NODE_34353_length_207_cov_5.911392_g34143_i0	PRJNA526367	34353	207	5.911392	12.23658144	Gemmatimonas	173479	Bacteria	Bacteria	147	8.08e-31	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g34143	i0	79.902	4.71497584541063	204	38	98	3	1	202	400	198	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	976	147	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
17073063	17073063	PRJNA526367_P_NODE_23094_length_324_cov_2.174545_g22885_i0	PRJNA526367	23094	324	2.174545	7.0455258	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	58.2	3.52e-7	NR	MBT3344698.1	2026742	g22885	i0	75.8	0.305555555555556	33	8	30.6	0	322	224	85	117	MBT3344698.1 SDR family oxidoreductase [Gemmatimonadota bacterium]	diamond	99	58.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
18965203	18965203	PRJNA526367_P_NODE_29855_length_324_cov_1.483636_g29646_i0	PRJNA526367	29855	324	1.483636	4.80698064	Gemmatimonas	173479	Bacteria	Bacteria	165	3.75e-36	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g29646	i0	96.939	8	98	3	30	0	227	324	389	486	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	2592	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
27330375	27330375	PRJNA526367_P_NODE_62683_length_154_cov_8.142857_g62473_i0	PRJNA526367	62683	154	8.142857	12.53999978	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	79.3	6.07e-16	NR	MET0399473.1	3047548	g62473	i0	75	7.48051948051948	48	12	93.5	0	3	146	184	231	MET0399473.1 helix-turn-helix domain-containing GNAT family N-acetyltransferase [Longimicrobiaceae bacterium]	diamond	1152	79.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
28087934	28087934	PRJNA526367_P_NODE_46085_length_173_cov_1.645161_g45875_i0	PRJNA526367	46085	173	1.645161	2.84612853	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	65.1	1.15e-11	NR	MEO7713320.1	2026741	g45875	i0	55.4	0.971098265895954	56	25	97.1	0	3	170	54	109	MEO7713320.1 response regulator [Gemmatimonadaceae bacterium]	diamond	168	65.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28530257	28530257	PRJNA526367_P_NODE_38267_length_186_cov_2.554745_g38057_i0	PRJNA526367	38267	186	2.554745	4.7518257	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	105	3.15e-26	NR	HEY4659610.1	2026741	g38057	i0	84.7	0.951612903225806	59	9	95.2	0	178	2	110	168	HEY4659610.1 NAD-dependent epimerase/dehydratase family protein [Gemmatimonadaceae bacterium]	diamond	177	105	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28814000	28814000	PRJNA526367_P_NODE_21768_length_324_cov_2.290909_g21559_i0	PRJNA526367	21768	324	2.290909	7.42254516	Gemmatimonas sp. UBA7669	1946568	Bacteria	Bacteria	65.5	6.52e-10	NR	WP_291161354.1	1946568	g21559	i0	90.9	0.305555555555556	33	3	30.6	0	225	323	56	88	WP_291161354.1 alpha/beta hydrolase [Gemmatimonas sp. UBA7669]	diamond	99	65.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. UBA7669
29193357	29193357	PRJNA526367_P_NODE_45289_length_174_cov_3.664000_g45079_i0	PRJNA526367	45289	174	3.664	6.37536	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	90.9	1.14e-21	NR	HZJ01742.1	2026741	g45079	i0	81.8	1.89655172413793	55	10	94.8	0	7	171	1	55	HZJ01742.1 DUF2203 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	330	90.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29240028	29240028	PRJNA526367_P_NODE_27789_length_324_cov_1.774545_g27580_i0	PRJNA526367	27789	324	1.774545	5.7495258	Bacteria	2	Bacteria	Bacteria	62	1.65e-8	NR	MDZ7630646.1	2026741	g27580	i0	96.8	1.14814814814815	31	1	28.7	0	318	226	480	510	MDZ7630646.1 chemotaxis protein CheA [Gemmatimonadaceae bacterium]	diamond	372	62	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29460674	29460674	PRJNA526367_P_NODE_53730_length_164_cov_3.547826_g53520_i0	PRJNA526367	53730	164	3.547826	5.81843464	Bacteria	2	Bacteria	Bacteria	89.4	6.180000000000001e-21	NR	HMF86459.1	2026741	g53520	i0	86	1.82926829268293	50	7	91.5	0	155	6	9	58	HMF86459.1 JAB domain-containing protein [Gemmatimonadaceae bacterium]	diamond	300	89.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29618490	29618490	PRJNA526367_P_NODE_61550_length_156_cov_4.345794_g61340_i0	PRJNA526367	61550	156	4.345794	6.77943864	Bacteria	2	Bacteria	Bacteria	90.1	2.27e-19	NR	HWP69844.1	2026741	g61340	i0	93.9	48.1730769230769	49	3	94.2	0	155	9	562	610	HWP69844.1 ABC transporter ATP-binding protein [Gemmatimonadaceae bacterium]	diamond	7515	90.9	0.991199119911991	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30393800	30393800	PRJNA526367_P_NODE_42053_length_179_cov_5.007692_g41843_i0	PRJNA526367	42053	179	5.007692	8.96376868	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	63.5	3.44e-11	NR	MBK6308349.1	2026742	g41843	i0	100	0.50279329608938494	30	0	50.3	0	89	178	1	30	MBK6308349.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	90	63.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32464000	32464000	PRJNA526367_P_NODE_48559_length_169_cov_4.483333_g48349_i0	PRJNA526367	48559	169	4.483333	7.57683277	Pseudomonadati	3379134	Bacteria	Bacteria	77	1.14e-14	NR	WP_025413243.1	861299	g48349	i0	84.6	9.51479289940828	52	8	92.3	0	13	168	423	474	WP_025413243.1 efflux RND transporter permease subunit [Gemmatirosa kalamazoonensis]	diamond	1608	77	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis

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