metadata: contig_metadata: 26 rows where bioproject = "PRJNA1196438", tax_clade = "FCB group" and tax

26 rows where bioproject = "PRJNA1196438", 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
323464	323464	PRJNA1196438_P_NODE_66241_length_251_cov_0.876404_g65814_i0	PRJNA1196438	66241	251	0.876404	2.19977404	Gemmatimonas sp.	1962908	Bacteria	Bacteria	125	4.499999999999999e-31	NR	HYW30659.1	1962908	g65814	i0	84.2	4.54183266932271	76	12	90.8	0	1	228	921	996	HYW30659.1 DNA polymerase I [Gemmatimonas sp.]	diamond	1140	125	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
4871348	4871348	PRJNA1196438_P_NODE_27984_length_301_cov_3.859649_g27558_i0	PRJNA1196438	27984	301	3.859649	11.61754349	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	85.9	5.2e-17	NR	GJG87862.1	2839016	g27558	i0	71.7	0.598006644518272	60	17	59.8	0	180	1	10	69	GJG87862.1 hypothetical protein tb265_30430 [Gemmatimonadetes bacterium T265]	diamond	180	85.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
7976389	7976389	PRJNA1196438_P_NODE_35667_length_295_cov_4.891892_g35241_i0	PRJNA1196438	35667	295	4.891892	14.4310814	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	132	1.29e-36	NR	GJG89386.1	2839016	g35241	i0	80.7	0.84406779661017	83	16	84.4	0	249	1	7	89	GJG89386.1 hypothetical protein tb265_45670 [Gemmatimonadetes bacterium T265]	diamond	249	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
12522049	12522049	PRJNA1196438_P_NODE_55650_length_264_cov_4.534031_g55223_i0	PRJNA1196438	55650	264	4.534031	11.96984184	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	112	1.17e-26	NR	GJG85458.1	2839016	g55223	i0	65.5	0.988636363636364	87	30	98.9	0	4	264	819	905	GJG85458.1 hypothetical protein tb265_06390 [Gemmatimonadetes bacterium T265]	diamond	261	112	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
13076527	13076527	PRJNA1196438_P_NODE_20871_length_312_cov_2.912134_g20445_i0	PRJNA1196438	20871	312	2.912134	9.08585808	Gemmatimonadaceae	219687	Bacteria	Bacteria	129	1.6899999999999998e-32	NR	HZF68906.1	2510638	g20445	i0	51	2.82692307692308	147	28	99	1	1	309	34	180	HZF68906.1 ABC transporter ATP-binding protein [Gemmatirosa sp.]	diamond	882	129	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
15626492	15626492	PRJNA1196438_P_NODE_85773_length_212_cov_5.093525_g85345_i0	PRJNA1196438	85773	212	5.093525	10.798273	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	119	1.96e-32	NR	MFL5639168.1	2026741	g85345	i0	80	2.75943396226415	65	13	92	0	204	10	99	163	MFL5639168.1 VOC family protein [Gemmatimonadaceae bacterium]	diamond	585	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
20724363	20724363	PRJNA1196438_P_NODE_34137_length_298_cov_3.342222_g33711_i0	PRJNA1196438	34137	298	3.342222	9.95982156	Gemmatirosa	1706036	Bacteria	Bacteria	52.8	1.21e-5	NR	AHG92911.1	861299	g33711	i0	69	1.67114093959732	42	13	42.3	0	27	152	132	173	AHG92911.1 RNA polymerase sigma factor, sigma-70 family [Gemmatirosa kalamazoonensis]	diamond	498	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24549192	24549192	PRJNA1196438_P_NODE_37140_length_293_cov_2.772727_g36714_i0	PRJNA1196438	37140	293	2.772727	8.12409011	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	189	1.98e-43	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g36714	i0	81.081	2.61774744027304	259	30	88	12	7	263	4160758	4160517	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	767	189	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
28165317	28165317	PRJNA1196438_P_NODE_69305_length_248_cov_0.891429_g68878_i0	PRJNA1196438	69305	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	122	2.2000000000000002e-30	NR	MFL5577601.1	2026741	g68878	i0	81.7	5.02016129032258	82	15	99.2	0	1	246	215	296	MFL5577601.1 phosphoglycerate dehydrogenase [Gemmatimonadaceae bacterium]	diamond	1245	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28386260	28386260	PRJNA1196438_P_NODE_47566_length_277_cov_1.529412_g47139_i0	PRJNA1196438	47566	277	1.529412	4.23647124	Gemmatirosa	1706036	Bacteria	Bacteria	102	6.9e-25	NR	WP_025411590.1	861299	g47139	i0	72.7	1.65703971119134	77	20	82.3	1	3	230	124	200	WP_025411590.1 Holliday junction branch migration protein RuvA [Gemmatirosa kalamazoonensis]	diamond	459	103	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
29175819	29175819	PRJNA1196438_P_NODE_49469_length_274_cov_1.552239_g49042_i0	PRJNA1196438	49469	274	1.552239	4.25313486	Gemmatimonas	173479	Bacteria	Bacteria	129	3.14e-34	NR	HYW33347.1	1962908	g49042	i0	84.3	1.94890510948905	89	14	97.4	0	1	267	20	108	HYW33347.1 iron ABC transporter permease [Gemmatimonas sp.]	diamond	534	130	0.992307692307692	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
29251249	29251249	PRJNA1196438_P_NODE_76809_length_241_cov_2.380952_g76382_i0	PRJNA1196438	76809	241	2.380952	5.73809432	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	53.1	7.64e-6	NR	MCX5760627.1	2026742	g76382	i0	81.5	1.0207468879668	27	5	33.6	0	240	160	405	431	MCX5760627.1 DUF1501 domain-containing protein [Gemmatimonadota bacterium]	diamond	246	53.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29567063	29567063	PRJNA1196438_P_NODE_67070_length_250_cov_1.310734_g66643_i0	PRJNA1196438	67070	250	1.310734	3.276835	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	155	5.41e-44	NR	GJG88564.1	2839016	g66643	i0	90.4	0.996	83	8	99.6	0	250	2	149	231	GJG88564.1 tRNA-dihydrouridine synthase [Gemmatimonadetes bacterium T265]	diamond	249	155	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
29712043	29712043	PRJNA1196438_P_NODE_57650_length_261_cov_3.712766_g57223_i0	PRJNA1196438	57650	261	3.712766	9.69031926	Gemmatirosa	1706036	Bacteria	Bacteria	143	5.1e-42	NR	HEY0779442.1	2510638	g57223	i0	90.7	1.72413793103448	75	7	86.2	0	260	36	58	132	HEY0779442.1 1,2-phenylacetyl-CoA epoxidase subunit PaaB [Gemmatirosa sp.]	diamond	450	144	0.993055555555556	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
29946243	29946243	PRJNA1196438_P_NODE_81791_length_230_cov_2.764331_g81364_i0	PRJNA1196438	81791	230	2.764331	6.3579613	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	86.3	3.75e-19	NR	GJG85592.1	2839016	g81364	i0	69.7	0.991304347826087	76	18	99.1	2	3	230	68	138	GJG85592.1 hypothetical protein tb265_07730 [Gemmatimonadetes bacterium T265]	diamond	228	86.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
30514816	30514816	PRJNA1196438_P_NODE_59653_length_258_cov_5.491892_g59226_i0	PRJNA1196438	59653	258	5.491892	14.16908136	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	104	7.1e-24	NR	WP_148306308.1	861299	g59226	i0	68.3	0.953488372093023	82	26	95.3	0	251	6	1301	1382	WP_148306308.1 diguanylate cyclase [Gemmatirosa kalamazoonensis]	diamond	246	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
30577755	30577755	PRJNA1196438_P_NODE_40033_length_289_cov_1.328704_g39606_i0	PRJNA1196438	40033	289	1.328704	3.83995456	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	166	2.67e-50	NR	GJG87507.1	2839016	g39606	i0	83	1.93079584775087	94	14	95.5	1	12	287	8	101	GJG87507.1 hypothetical protein tb265_26880 [Gemmatimonadetes bacterium T265]	diamond	558	166	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
30609456	30609456	PRJNA1196438_P_NODE_50953_length_271_cov_4.565657_g50526_i0	PRJNA1196438	50953	271	4.565657	12.37293047	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	129	1.37e-34	NR	HEV2146165.1	3047548	g50526	i0	80.2	1.90405904059041	86	17	95.2	0	260	3	2	87	HEV2146165.1 oxygenase MpaB family protein [Longimicrobiaceae bacterium]	diamond	516	129	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
30691678	30691678	PRJNA1196438_P_NODE_57273_length_262_cov_2.111111_g56846_i0	PRJNA1196438	57273	262	2.111111	5.53111082	FCB group	1783270	Bacteria	Bacteria	99.4	3.4099999999999995e-23	NR	HEU4525838.1	2448054	g56846	i0	83.3	3.72137404580153	54	9	61.8	0	261	100	206	259	HEU4525838.1 IS630 family transposase [Gemmatimonadales bacterium]	diamond	975	99.8	0.995991983967936	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30704345	30704345	PRJNA1196438_P_NODE_59674_length_258_cov_4.232432_g59247_i0	PRJNA1196438	59674	258	4.232432	10.91967456	Gemmatirosa sp.	2510638	Bacteria	Bacteria	92.4	2.13e-20	NR	MBV9880757.1	2510638	g59247	i0	62.3	1.7906976744186	77	27	89.5	1	26	256	18	92	MBV9880757.1 hypothetical protein [Gemmatirosa sp.]	diamond	462	92.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
30957314	30957314	PRJNA1196438_P_NODE_14114_length_312_cov_4.682008_g13688_i0	PRJNA1196438	14114	312	4.682008	14.60786496	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	71.6	5.8e-12	NR	PYP81637.1	2026742	g13688	i0	68.9	0.855769230769231	45	14	43.3	0	3	137	293	337	PYP81637.1 MAG: glyoxalase [Gemmatimonadota bacterium]	diamond	267	71.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31052190	31052190	PRJNA1196438_P_NODE_14435_length_312_cov_4.481172_g14009_i0	PRJNA1196438	14435	312	4.481172	13.98125664	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	47	2.67e-4	NR	GJG85218.1	2839016	g14009	i0	69	0.278846153846154	29	9	27.9	0	151	65	51	79	GJG85218.1 multidrug transporter MatE [Gemmatimonadetes bacterium T265]	diamond	87	47	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
31146293	31146293	PRJNA1196438_P_NODE_43455_length_283_cov_3.157143_g43028_i0	PRJNA1196438	43455	283	3.157143	8.93471469	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	108	3.08e-26	NR	GJG86154.1	2839016	g43028	i0	63.7	3	91	17	96.5	2	2	274	214	288	GJG86154.1 hypothetical protein tb265_13350 [Gemmatimonadetes bacterium T265]	diamond	849	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
31399906	31399906	PRJNA1196438_P_NODE_76896_length_240_cov_5.341317_g76469_i0	PRJNA1196438	76896	240	5.341317	12.8191608	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.4	6.57e-5	NR	HJR53196.1	2026742	g76469	i0	41.8	0.8375	67	31	82.5	2	239	42	97	156	HJR53196.1 copper resistance protein CopC [Gemmatimonadota bacterium]	diamond	201	50.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32380498	32380498	PRJNA1196438_P_NODE_42839_length_284_cov_3.213270_g42412_i0	PRJNA1196438	42839	284	3.21327	9.1256868	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	137	1.4e-36	NR	GJG86511.1	2839016	g42412	i0	81.9	0.992957746478873	94	17	99.3	0	284	3	135	228	GJG86511.1 C4-dicarboxylate transport protein [Gemmatimonadetes bacterium T265]	diamond	282	137	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
32475503	32475503	PRJNA1196438_P_NODE_29719_length_301_cov_3.052632_g29293_i0	PRJNA1196438	29719	301	3.052632	9.18842232	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	83.6	2.48e-16	NR	HET9985895.1	2910168	g29293	i0	67.3	0.488372093023256	49	16	48.8	0	297	151	164	212	HET9985895.1 phosphatase PAP2 family protein [Longimicrobiales bacterium]	diamond	147	83.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales 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);;