metadata: contig_metadata: 29 rows where bioproject = "PRJNA928559", tax_clade = "FCB group" and tax

29 rows where bioproject = "PRJNA928559", 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
1252741	1252741	PRJNA928559_P_NODE_142701_length_296_cov_1.278027_g141132_i0	PRJNA928559	142701	296	1.278027	3.78295992	Gemmatimonas	173479	Bacteria	Bacteria	230	1.1799999999999998e-55	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g141132	i0	84.681	7.49662162162162	235	31	78	4	30	261	135	367	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	2219	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
2179444	2179444	PRJNA928559_P_NODE_48962_length_488_cov_5.930120_g47400_i0	PRJNA928559	48962	488	5.93012	28.9389856	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	187	1.2499999999999997e-42	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g47400	i0	77.581	7.69262295081967	339	56	69	14	40	374	3058954	3059276	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	3754	187	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
3453955	3453955	PRJNA928559_P_NODE_183683_length_256_cov_1.453552_g182114_i0	PRJNA928559	183683	256	1.453552	3.72109312	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g182114	i0	94.444	0.140625	36	2	14	0	83	118	673865	673830	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	36	56.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
5081003	5081003	PRJNA928559_P_NODE_126604_length_316_cov_1.292181_g125035_i0	PRJNA928559	126604	316	1.292181	4.08329196	Gemmatimonas	173479	Bacteria	Bacteria	318	2.64e-82	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g125035	i0	86	20.2784810126582	300	38	94	4	10	307	1528	1231	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	6408	318	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
8905511	8905511	PRJNA928559_P_NODE_143827_length_294_cov_3.457014_g142258_i0	PRJNA928559	143827	294	3.457014	10.16362116	Gemmatimonas	173479	Bacteria	Bacteria	529	1.0299999999999996e-145	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g142258	i0	99.315	132.234693877551	292	2	99	0	1	292	292	1	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	38877	532	0.994360902255639	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
9830429	9830429	PRJNA928559_P_NODE_153068_length_284_cov_3.720379_g151499_i0	PRJNA928559	153068	284	3.720379	10.56587636	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	217	8.79e-52	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g151499	i0	87.634	58.0528169014084	186	23	65	0	1	186	806536	806351	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	16487	217	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
9830756	9830756	PRJNA928559_P_NODE_174348_length_264_cov_1.565445_g172779_i0	PRJNA928559	174348	264	1.565445	4.1327748	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	329	9.95e-86	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g172779	i0	89.434	81.6704545454545	265	22	98	6	3	262	3042305	3042568	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	21561	329	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9830957	9830957	PRJNA928559_P_NODE_188608_length_253_cov_0.866667_g187039_i0	PRJNA928559	188608	253	0.866667	2.19266751	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	176	1.31e-39	NTclustered	gi\|2107901501\|gb\|CP070815.1\|	2026742	g187039	i0	80.579	140.97628458498	242	36	92	7	18	250	1294871	1294632	MAG: Gemmatimonadetes bacterium isolate bin118 chromosome	blastn	35667	176	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
13655755	13655755	PRJNA928559_P_NODE_110971_length_338_cov_5.675472_g109402_i0	PRJNA928559	110971	338	5.675472	19.18309536	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2893358392\|emb\|OZ220683.1\|	2026742	g109402	i0	96.875	0.180473372781065	32	1	9	0	79	110	1905812	1905843	MAG: Gemmatimonadota bacterium isolate c4f6f2ca-7934-440c-833b-e1b430e415c5 genome assembly, chromosome: 1	blastn	61	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
14932306	14932306	PRJNA928559_P_NODE_70612_length_419_cov_1.578035_g69043_i0	PRJNA928559	70612	419	1.578035	6.61196665	Pseudomonadati	3379134	Bacteria	Bacteria	235	9.689999999999999e-69	NR	MES2176899.1	2026742	g69043	i0	78.4	5.97136038186158	139	30	99.5	0	419	3	876	1014	MES2176899.1 M1 family aminopeptidase [Gemmatimonadota bacterium]	diamond	2502	237	0.991561181434599	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
14932668	14932668	PRJNA928559_P_NODE_99352_length_358_cov_1.515789_g97783_i0	PRJNA928559	99352	358	1.515789	5.42652462	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	267	1.11e-66	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g97783	i0	83.562	78.4022346368715	292	41	91	6	28	317	438966	439252	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	28068	267	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16555144	16555144	PRJNA928559_P_NODE_124173_length_319_cov_2.048780_g122604_i0	PRJNA928559	124173	319	2.04878	6.5356082	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	81.6	1.52e-15	NR	MBX3131958.1	2026741	g122604	i0	58.9	0.686520376175549	73	29	67.7	1	315	100	328	400	MBX3131958.1 TCR/Tet family MFS transporter [Gemmatimonadaceae bacterium]	diamond	219	81.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
17480169	17480169	PRJNA928559_P_NODE_11174_length_922_cov_3.071849_g9930_i0	PRJNA928559	11174	922	3.071849	28.32244778	Pseudomonadati	3379134	Bacteria	Bacteria	335	1.48e-100	NR	HYR08117.1	2029185	g9930	i0	60.2	8.93167028199566	299	112	97.3	5	1	897	778	1069	HYR08117.1 amino acid adenylation domain-containing protein [Longimicrobium sp.]	diamond	8235	337	0.99406528189911	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
18754810	18754810	PRJNA928559_P_NODE_194575_length_250_cov_1.254237_g193006_i0	PRJNA928559	194575	250	1.254237	3.1355925	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g193006	i0	86.694	121.444	248	25	98	8	6	250	3042472	3042714	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	30361	268	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
20028748	20028748	PRJNA928559_P_NODE_118516_length_327_cov_2.145669_g116947_i0	PRJNA928559	118516	327	2.145669	7.01633763	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	148	3.81e-31	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g116947	i0	79.018	21.3608562691131	224	41	68	5	1	221	7120889	7120669	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	6985	148	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20029279	20029279	PRJNA928559_P_NODE_156796_length_281_cov_0.865385_g155227_i0	PRJNA928559	156796	281	0.865385	2.43173185	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	298	3.01e-76	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g155227	i0	85.866	98.8896797153025	283	36	100	2	1	281	5908728	5908448	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	27788	298	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27467320	27467320	PRJNA928559_P_NODE_159543_length_278_cov_1.414634_g157974_i0	PRJNA928559	159543	278	1.414634	3.93268252	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.5	0.0299	NR	NJD20385.1	2026742	g157974	i0	31.6	0.820143884892086	76	46	75.5	1	52	261	361	436	NJD20385.1 ATP-dependent helicase HrpB [Gemmatimonadota bacterium]	diamond	228	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28540982	28540982	PRJNA928559_P_NODE_210527_length_243_cov_5.176471_g208958_i0	PRJNA928559	210527	243	5.176471	12.57882453	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.1	0.0266	NR	MFH1571271.1	2026742	g208958	i0	40.8	0.604938271604938	49	21	60.5	1	195	49	130	170	MFH1571271.1 ABC transporter ATP-binding protein [Gemmatimonadota bacterium]	diamond	147	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28698771	28698771	PRJNA928559_P_NODE_142787_length_296_cov_1.049327_g141218_i0	PRJNA928559	142787	296	1.049327	3.10600792	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	53.5	3.48e-6	NR	MBK5098343.1	2026742	g141218	i0	55.6	0.993243243243243	45	20	45.6	0	195	61	109	153	MBK5098343.1 Hsp20/alpha crystallin family protein [Gemmatimonadota bacterium]	diamond	294	53.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29519507	29519507	PRJNA928559_P_NODE_211990_length_243_cov_0.917647_g210421_i0	PRJNA928559	211990	243	0.917647	2.22988221	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	43.1	0.0168	NR	CAA9311382.1	246130	g210421	i0	38.6	0.864197530864197	70	37	85.2	2	224	18	100	164	CAA9311382.1 MAG: Protein YzbB, partial [uncultured Gemmatimonadaceae bacterium]	diamond	210	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
30087896	30087896	PRJNA928559_P_NODE_142712_length_296_cov_1.255605_g141143_i0	PRJNA928559	142712	296	1.255605	3.7165908	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	90.1	1.41e-19	NR	MDQ6612088.1	2026742	g141143	i0	58.6	1.76351351351351	87	33	88.2	2	270	10	5	88	MDQ6612088.1 SDR family oxidoreductase [Gemmatimonadota bacterium]	diamond	522	90.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30467434	30467434	PRJNA928559_P_NODE_114813_length_333_cov_1.276923_g113244_i0	PRJNA928559	114813	333	1.276923	4.25215359	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.1	0.0147	NR	MCU0618242.1	2026741	g113244	i0	45.8	1.2972972972973	48	26	43.2	0	228	85	273	320	MCU0618242.1 PfkB family carbohydrate kinase [Gemmatimonadaceae bacterium]	diamond	432	45.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31257046	31257046	PRJNA928559_P_NODE_152095_length_285_cov_3.679245_g150526_i0	PRJNA928559	152095	285	3.679245	10.48584825	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	56.2	1.07e-6	NR	NIY08148.1	2026742	g150526	i0	45.6	0.6	57	31	60	0	280	110	459	515	NIY08148.1 tetratricopeptide repeat protein [Gemmatimonadota bacterium]	diamond	171	56.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31327455	31327455	PRJNA928559_P_NODE_153855_length_284_cov_1.109005_g152286_i0	PRJNA928559	153855	284	1.109005	3.1495742	FCB group	1783270	Bacteria	Bacteria	47	0.0019	NR	MCC7053221.1	2026741	g152286	i0	35.7	1.72183098591549	84	45	80.3	2	230	3	5	87	MCC7053221.1 vanadium-dependent haloperoxidase [Gemmatimonadaceae bacterium]	diamond	489	47	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31573622	31573622	PRJNA928559_P_NODE_31416_length_585_cov_2.927734_g29886_i0	PRJNA928559	31416	585	2.927734	17.1272439	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	139	2.26e-35	NR	MCU0646502.1	2026741	g29886	i0	45.6	0.82051282051282	160	82	79.5	1	583	119	202	361	MCU0646502.1 metallophosphoesterase [Gemmatimonadaceae bacterium]	diamond	480	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31668154	31668154	PRJNA928559_P_NODE_10717_length_939_cov_25.989607_g9493_i0	PRJNA928559	10717	939	25.989607	244.04240973	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	115	5.79e-26	NR	NIM48047.1	2448054	g9493	i0	30.4	1.04153354632588	326	182	90.1	6	60	905	1	325	NIM48047.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	978	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32079535	32079535	PRJNA928559_P_NODE_28618_length_608_cov_2.988785_g27098_i0	PRJNA928559	28618	608	2.988785	18.1718128	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	238	2.47e-77	NR	MES3035321.1	2026742	g27098	i0	75.5	2.11184210526316	143	35	70.6	0	15	443	1	143	MES3035321.1 DUF1579 family protein [Gemmatimonadota bacterium]	diamond	1284	238	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32333089	32333089	PRJNA928559_P_NODE_59939_length_449_cov_3.377660_g58372_i0	PRJNA928559	59939	449	3.37766	15.1656934	Gemmatimonas sp. UBA7669	1946568	Bacteria	Bacteria	105	2.2699999999999994e-23	NR	WP_291161581.1	1946568	g58372	i0	44.3	0.935412026726058	140	69	90.2	7	407	3	24	159	WP_291161581.1 metallophosphoesterase [Gemmatimonas sp. UBA7669]	diamond	420	105	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. UBA7669
32529943	32529943	PRJNA928559_P_NODE_63099_length_440_cov_1.062670_g61530_i0	PRJNA928559	63099	440	1.06267	4.675748	Pseudomonadati	3379134	Bacteria	Bacteria	192	1.63e-54	NR	MBX3174954.1	2026741	g61530	i0	65.1	1.99090909090909	146	50	99.5	1	2	439	274	418	MBX3174954.1 ATP-binding protein [Gemmatimonadaceae bacterium]	diamond	876	193	0.994818652849741	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;