metadata: contig_metadata: 29 rows where bioproject = "PRJNA792582" and tax

29 rows where bioproject = "PRJNA792582" 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
2052884	2052884	PRJNA792582_P_NODE_36382_length_287_cov_1.794393_g35568_i0	PRJNA792582	36382	287	1.794393	5.14990791	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	316	8.519999999999998e-82	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g35568	i0	87.589	15.6898954703833	282	24	98	3	3	283	35157	35428	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4503	316	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2052933	2052933	PRJNA792582_P_NODE_40262_length_277_cov_1.411765_g39448_i0	PRJNA792582	40262	277	1.411765	3.91058905	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	141	1.4e-36	NR	MBL8995832.1	2026742	g39448	i0	84.8	2.98916967509025	92	14	99.6	0	2	277	285	376	MBL8995832.1 serine hydrolase [Gemmatimonadota bacterium]	diamond	828	141	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
3328242	3328242	PRJNA792582_P_NODE_48103_length_255_cov_1.692308_g47289_i0	PRJNA792582	48103	255	1.692308	4.3153854	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	244	3.56e-60	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g47289	i0	83.984	1.00392156862745	256	39	100	2	1	255	972283	972537	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	256	244	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
4605354	4605354	PRJNA792582_P_NODE_40124_length_277_cov_2.024510_g39310_i0	PRJNA792582	40124	277	2.02451	5.6078927	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	178	4.029999999999999e-40	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g39310	i0	81.013	7.86642599277978	237	34	84	10	34	266	3630999	3631228	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	2179	178	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8430221	8430221	PRJNA792582_P_NODE_48607_length_254_cov_1.243094_g47793_i0	PRJNA792582	48607	254	1.243094	3.15745876	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	307	4.4600000000000006e-79	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g47793	i0	88.845	120.807086614173	251	26	98	2	1	249	1553871	1553621	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	30685	307	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
9705110	9705110	PRJNA792582_P_NODE_19628_length_388_cov_2.704762_g18814_i0	PRJNA792582	19628	388	2.704762	10.49447656	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	331	4.2500000000000004e-86	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g18814	i0	82.443	156.559278350515	393	51	100	10	1	388	422487	422108	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	60745	331	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9705247	9705247	PRJNA792582_P_NODE_37308_length_285_cov_1.254717_g36494_i0	PRJNA792582	37308	285	1.254717	3.57594345	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	322	1.82e-83	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g36494	i0	87.018	9.50877192982456	285	37	100	0	1	285	209813	210097	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	2710	322	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10143917	10143917	PRJNA792582_P_NODE_35488_length_289_cov_3.356481_g34674_i0	PRJNA792582	35488	289	3.356481	9.70023009	Roseisolibacter agri	2014610	Bacteria	Bacteria	97.4	2.8400000000000003e-21	NR	WP_284352341.1	2014610	g34674	i0	93.9	0.508650519031142	49	3	50.9	0	142	288	36	84	WP_284352341.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Roseisolibacter agri]	diamond	147	97.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
10981096	10981096	PRJNA792582_P_NODE_51629_length_249_cov_0.875000_g50815_i0	PRJNA792582	51629	249	0.875	2.17875	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	102	2.79e-25	NR	HEU6450968.1	2026741	g50815	i0	71.2	2.3855421686747	66	19	79.5	0	199	2	1	66	HEU6450968.1 GNAT family protein [Gemmatimonadaceae bacterium]	diamond	594	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
12256630	12256630	PRJNA792582_P_NODE_44970_length_264_cov_1.638743_g44156_i0	PRJNA792582	44970	264	1.638743	4.32628152	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	339	1.65e-88	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g44156	i0	89.773	228.083333333333	264	27	100	0	1	264	174103	174366	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	60214	339	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13530588	13530588	PRJNA792582_P_NODE_37211_length_285_cov_1.452830_g36397_i0	PRJNA792582	37211	285	1.45283	4.1405655	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	226	1.47e-54	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g36397	i0	81.588	0.971929824561404	277	47	96	4	4	278	4375878	4375604	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	277	226	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13530730	13530730	PRJNA792582_P_NODE_49111_length_252_cov_1.720670_g48297_i0	PRJNA792582	49111	252	1.72067	4.3360884	Bacteria	2	Bacteria	Bacteria	112	9.11e-27	NR	MEO7217680.1	2026741	g48297	i0	68.7	6.83333333333333	83	26	98.8	0	251	3	182	264	MEO7217680.1 PBP1A family penicillin-binding protein [Gemmatimonadaceae bacterium]	diamond	1722	112	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
13530860	13530860	PRJNA792582_P_NODE_60031_length_237_cov_2.335366_g59217_i0	PRJNA792582	60031	237	2.335366	5.53481742	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	335	1.8899999999999996e-87	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g59217	i0	93.392	303.586497890295	227	14	96	1	1	227	3044934	3045159	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	71950	335	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14805596	14805596	PRJNA792582_P_NODE_4252_length_794_cov_2.341193_g3570_i0	PRJNA792582	4252	794	2.341193	18.58907242	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	1026	0	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g3570	i0	90.113	90.9861460957179	799	66	100	12	1	794	3486021	3485231	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	72243	1026	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16518474	16518474	PRJNA792582_P_NODE_5393_length_711_cov_1.318182_g4655_i0	PRJNA792582	5393	711	1.318182	9.37227402	Gemmatimonas	173479	Bacteria	Bacteria	1085	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g4655	i0	94.468	116.066104078762	705	37	99	2	1	705	913	1615	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	82523	1085	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
17355337	17355337	PRJNA792582_P_NODE_44654_length_265_cov_1.604167_g43840_i0	PRJNA792582	44654	265	1.604167	4.25104255	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	172	1.59e-50	NR	MBW3570171.1	2026742	g43840	i0	87.5	0.99622641509434	88	11	99.6	0	265	2	167	254	MBW3570171.1 glycosyltransferase [Gemmatimonadota bacterium]	diamond	264	172	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
18628492	18628492	PRJNA792582_P_NODE_35515_length_289_cov_2.560185_g34701_i0	PRJNA792582	35515	289	2.560185	7.39893465	Gemmatirosa sp.	2510638	Bacteria	Bacteria	159	1.06e-45	NR	HZF69154.1	2510638	g34701	i0	80.2	2.98961937716263	96	19	99.7	0	2	289	181	276	HZF69154.1 decarboxylating 6-phosphogluconate dehydrogenase [Gemmatirosa sp.]	diamond	864	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
19903770	19903770	PRJNA792582_P_NODE_38536_length_281_cov_2.961538_g37722_i0	PRJNA792582	38536	281	2.961538	8.32192178	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	305	1.8e-78	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g37722	i0	86.713	50.9003558718861	286	24	99	14	1	280	343477	343754	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	14303	305	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20341855	20341855	PRJNA792582_P_NODE_39496_length_279_cov_1.354369_g38682_i0	PRJNA792582	39496	279	1.354369	3.77868951	Roseisolibacter agri	2014610	Bacteria	Bacteria	105	6.89e-24	NR	WP_284350442.1	2014610	g38682	i0	67.5	0.860215053763441	80	26	86	0	3	242	1164	1243	WP_284350442.1 DUF4175 family protein [Roseisolibacter agri]	diamond	240	105	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
22454208	22454208	PRJNA792582_P_NODE_35698_length_289_cov_1.425926_g34884_i0	PRJNA792582	35698	289	1.425926	4.12092614	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	220	6.93e-53	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g34884	i0	87.565	0.667820069204152	193	20	66	4	97	288	3953670	3953859	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	193	220	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
22893092	22893092	PRJNA792582_P_NODE_41358_length_274_cov_1.512438_g40544_i0	PRJNA792582	41358	274	1.512438	4.14408012	Gemmatirosa	1706036	Bacteria	Bacteria	267	8.26e-67	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g40544	i0	84.871	71.6021897810219	271	33	97	8	1	267	420781	421047	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	19619	267	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26673583	26673583	PRJNA792582_P_NODE_47521_length_257_cov_1.375000_g46707_i0	PRJNA792582	47521	257	1.375	3.53375	Roseisolibacter sp. H3M3-2	3031323	Bacteria	Bacteria	63.5	5.24e-11	NR	WP_275834931.1	3031323	g46707	i0	69.4	1.66926070038911	49	14	57.2	1	64	210	35	82	WP_275834931.1 hypothetical protein [Roseisolibacter sp. H3M3-2]	diamond	429	63.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter sp. H3M3-2
28348630	28348630	PRJNA792582_P_NODE_35906_length_288_cov_2.404651_g35092_i0	PRJNA792582	35906	288	2.404651	6.92539488	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	144	4.85e-41	NR	GJG88456.1	2839016	g35092	i0	77.9	0.989583333333333	95	20	99	1	3	287	77	170	GJG88456.1 hypothetical protein tb265_36370 [Gemmatimonadetes bacterium T265]	diamond	285	144	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
29548269	29548269	PRJNA792582_P_NODE_37170_length_285_cov_1.509434_g36356_i0	PRJNA792582	37170	285	1.509434	4.3018869	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	44.3	0.0178	NR	HXT14879.1	2026741	g36356	i0	40.8	0.515789473684211	49	29	51.6	0	193	47	773	821	HXT14879.1 transcription-repair coupling factor [Gemmatimonadaceae bacterium]	diamond	147	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30275218	30275218	PRJNA792582_P_NODE_35212_length_290_cov_1.917051_g34398_i0	PRJNA792582	35212	290	1.917051	5.5594479	Longimicrobium sp.	2029185	Bacteria	Bacteria	169	6.4e-48	NR	WP_329683937.1	2029185	g34398	i0	85.1	2.95862068965517	94	14	97.2	0	7	288	310	403	WP_329683937.1 hypothetical protein [Longimicrobium sp.]	diamond	858	169	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30338591	30338591	PRJNA792582_P_NODE_47012_length_258_cov_2.264865_g46198_i0	PRJNA792582	47012	258	2.264865	5.8433517	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	118	1.35e-28	NR	WP_158508910.1	861299	g46198	i0	73.3	1	86	23	100	0	1	258	284	369	WP_158508910.1 VWA domain-containing protein [Gemmatirosa kalamazoonensis]	diamond	258	118	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
30527658	30527658	PRJNA792582_P_NODE_44553_length_265_cov_2.255208_g43739_i0	PRJNA792582	44553	265	2.255208	5.9763012	Roseisolibacter agri	2014610	Bacteria	Bacteria	57	4.39e-7	NR	WP_284352059.1	2014610	g43739	i0	78.1	0.362264150943396	32	7	36.2	0	263	168	431	462	WP_284352059.1 hypothetical protein [Roseisolibacter agri]	diamond	96	57	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri
32203498	32203498	PRJNA792582_P_NODE_44258_length_266_cov_1.595855_g43444_i0	PRJNA792582	44258	266	1.595855	4.2449743	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	46.2	0.00128	NR	MCH7532820.1	2026742	g43444	i0	46.4	0.631578947368421	56	19	54.1	2	220	77	103	155	MCH7532820.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	168	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32708954	32708954	PRJNA792582_P_NODE_57460_length_243_cov_0.905882_g56646_i0	PRJNA792582	57460	243	0.905882	2.20129326	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	41.2	0.0209	NR	HEV2733865.1	3047548	g56646	i0	33.9	0.765432098765432	62	32	65.4	1	220	62	2	63	HEV2733865.1 thioredoxin family protein [Longimicrobiaceae bacterium]	diamond	186	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae 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);;