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

26 rows where bioproject = "PRJNA564013", 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
1824313	1824313	PRJNA564013_P_NODE_19982_length_822_cov_11.109067_g17726_i0	PRJNA564013	19982	822	11.109067	91.31653074	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	244	6.35e-78	NR	HEU4631842.1	2026741	g17726	i0	70.7	0.660583941605839	181	49	66.1	1	590	48	1	177	HEU4631842.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	543	244	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
3102777	3102777	PRJNA564013_P_NODE_362163_length_190_cov_3.116279_g359311_i0	PRJNA564013	362163	190	3.116279	5.9209301	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	265	1.93e-66	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g359311	i0	94.706	558.68947368421	170	9	89	0	1	170	8175967	8176136	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	106151	265	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4375823	4375823	PRJNA564013_P_NODE_181644_length_323_cov_6.190840_g178794_i0	PRJNA564013	181644	323	6.19084	19.9964132	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	159	1.6999999999999998e-44	NR	HSE46684.1	2448054	g178794	i0	91.6	0.882352941176471	95	8	88.2	0	6	290	312	406	HSE46684.1 MFS transporter [Gemmatimonadales bacterium]	diamond	285	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
10756770	10756770	PRJNA564013_P_NODE_54269_length_540_cov_2.649269_g51499_i0	PRJNA564013	54269	540	2.649269	14.3060526	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	749	0	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g51499	i0	93.491	162.457407407407	507	28	94	5	17	521	3431719	3431216	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	87727	749	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12611757	12611757	PRJNA564013_P_NODE_342250_length_203_cov_1.781690_g339398_i0	PRJNA564013	342250	203	1.78169	3.6168307	Bacteria	2	Bacteria	Bacteria	82.4	2.26e-11	NTclustered	gi\|2518551241\|emb\|OX638340.1\|	203437	g339398	i0	85.714	223.25615763546801	77	11	38	0	14	90	2533020	2533096	MAG: uncultured Gemmatimonadota bacterium isolate 6ed59a95-0d5b-4630-9937-108f2708d2fb genome assembly, chromosome: 1	blastn	45321	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
13887254	13887254	PRJNA564013_P_NODE_95631_length_418_cov_2.120448_g92798_i0	PRJNA564013	95631	418	2.120448	8.86347264	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	239	2.25e-76	NR	MEZ4589495.1	2448054	g92798	i0	78	2.84210526315789	132	29	94.7	0	2	397	177	308	MEZ4589495.1 CocE/NonD family hydrolase [Gemmatimonadales bacterium]	diamond	1188	239	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
14581069	14581069	PRJNA564013_P_NODE_44692_length_585_cov_6.452290_g41957_i0	PRJNA564013	44692	585	6.45229	37.7458965	Longimicrobium	1804994	Bacteria	Bacteria	116	2.41e-26	NR	HVH13951.1	2029185	g41957	i0	93.5	0.953846153846154	62	4	31.8	0	319	504	577	638	HVH13951.1 amino acid adenylation domain-containing protein [Longimicrobium sp.]	diamond	558	116	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
17126429	17126429	PRJNA564013_P_NODE_19594_length_828_cov_7.655802_g17354_i0	PRJNA564013	19594	828	7.655802	63.39004056	Pseudomonadati	3379134	Bacteria	Bacteria	254	1.28e-81	NR	MBK6306601.1	2026742	g17354	i0	62	5.19202898550725	192	73	69.6	0	808	233	2	193	MBK6306601.1 peptide-methionine (S)-S-oxide reductase MsrA [Gemmatimonadota bacterium]	diamond	4299	256	0.9921875	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
20952493	20952493	PRJNA564013_P_NODE_289337_length_232_cov_3.853801_g286485_i0	PRJNA564013	289337	232	3.853801	8.94081832	Longimicrobium terrae	1639882	Bacteria	Bacteria	125	8.78e-34	NR	WP_170034412.1	1639882	g286485	i0	96.9	1.6551724137931	64	2	82.8	0	20	211	14	77	WP_170034412.1 MerR family transcriptional regulator [Longimicrobium terrae]	diamond	384	125	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium terrae
22230167	22230167	PRJNA564013_P_NODE_90158_length_428_cov_52.801090_g87325_i0	PRJNA564013	90158	428	52.80109	225.9886652	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	229	1.21e-70	NR	MDO8501760.1	2026741	g87325	i0	82.4	2.67056074766355	125	22	87.6	0	402	28	107	231	MDO8501760.1 FAD-dependent oxidoreductase [Gemmatimonadaceae bacterium]	diamond	1143	229	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
24778106	24778106	PRJNA564013_P_NODE_362400_length_190_cov_2.589147_g359548_i0	PRJNA564013	362400	190	2.589147	4.9193793	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	206	1.1799999999999999e-48	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g359548	i0	87.931	2.09473684210526	174	21	92	0	5	178	3887578	3887405	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	398	206	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
27300577	27300577	PRJNA564013_P_NODE_66463_length_494_cov_2.491917_g63658_i0	PRJNA564013	66463	494	2.491917	12.31006998	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	138	7.75e-36	NR	MBC8088703.1	2026741	g63658	i0	70	0.728744939271255	120	36	72.9	0	386	27	1	120	MBC8088703.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	360	138	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27679782	27679782	PRJNA564013_P_NODE_11024_length_1053_cov_3.899194_g9291_i0	PRJNA564013	11024	1053	3.899194	41.05851282	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	270	4.9200000000000005e-79	NR	MDQ3673060.1	2026742	g9291	i0	44.9	0.997150997150997	350	175	98.9	4	11	1051	356	690	MDQ3673060.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Gemmatimonadota bacterium]	diamond	1050	270	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27963648	27963648	PRJNA564013_P_NODE_293125_length_230_cov_1.538462_g290273_i0	PRJNA564013	293125	230	1.538462	3.5384626	Gemmatirosa sp.	2510638	Bacteria	Bacteria	46.2	0.00187	NR	HZF66445.1	2510638	g290273	i0	46.9	0.639130434782609	49	26	63.9	0	176	30	341	389	HZF66445.1 hypothetical protein [Gemmatirosa sp.]	diamond	147	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
28752961	28752961	PRJNA564013_P_NODE_190567_length_315_cov_3.192913_g187716_i0	PRJNA564013	190567	315	3.192913	10.05767595	Longimicrobium sp.	2029185	Bacteria	Bacteria	46.2	0.00523	NR	HEY0153175.1	2029185	g187716	i0	51.1	1.28571428571429	45	22	42.9	0	160	294	9	53	HEY0153175.1 HEAT repeat domain-containing protein [Longimicrobium sp.]	diamond	405	46.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30079083	30079083	PRJNA564013_P_NODE_116792_length_386_cov_11.400000_g113948_i0	PRJNA564013	116792	386	11.4	44.004	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	196	2.4399999999999995e-55	NR	PYP78694.1	2026742	g113948	i0	80	1.80310880829016	115	23	89.4	0	25	369	1118	1232	PYP78694.1 MAG: hypothetical protein DMD35_10685 [Gemmatimonadota bacterium]	diamond	696	196	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30142056	30142056	PRJNA564013_P_NODE_253132_length_259_cov_1.257576_g250280_i0	PRJNA564013	253132	259	1.257576	3.25712184	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	119	3.59e-29	NR	MEO5567407.1	2026741	g250280	i0	73.1	1.80694980694981	78	21	90.3	0	3	236	536	613	MEO5567407.1 4-alpha-glucanotransferase [Gemmatimonadaceae bacterium]	diamond	468	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30647746	30647746	PRJNA564013_P_NODE_97693_length_414_cov_3.592068_g94859_i0	PRJNA564013	97693	414	3.592068	14.87116152	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	61.2	4.07e-9	NR	HKH91014.1	2026741	g94859	i0	50.8	0.471014492753623	65	31	47.1	1	390	196	25	88	HKH91014.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	195	61.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30679346	30679346	PRJNA564013_P_NODE_114813_length_389_cov_3.417683_g111969_i0	PRJNA564013	114813	389	3.417683	13.29478687	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	89.4	9.16e-18	NR	HET7427427.1	2448054	g111969	i0	58.6	0.539845758354756	70	29	54	0	381	172	533	602	HET7427427.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	210	89.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31153113	31153113	PRJNA564013_P_NODE_258215_length_254_cov_45.253886_g255363_i0	PRJNA564013	258215	254	45.253886	114.94487044	Longimicrobium terrae	1639882	Bacteria	Bacteria	139	4.31e-36	NR	WP_170036651.1	1639882	g255363	i0	94.4	0.850393700787402	72	4	85	0	24	239	64	135	WP_170036651.1 CDC48 family AAA ATPase [Longimicrobium terrae]	diamond	216	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium terrae
31691091	31691091	PRJNA564013_P_NODE_250257_length_261_cov_3.070000_g247405_i0	PRJNA564013	250257	261	3.07	8.0127	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	45.4	0.00492	NR	MDP9176975.1	2026742	g247405	i0	48.8	0.942528735632184	41	20	47.1	1	251	129	225	264	MDP9176975.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	246	45.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31691096	31691096	PRJNA564013_P_NODE_272457_length_244_cov_2.491803_g269605_i0	PRJNA564013	272457	244	2.491803	6.07999932	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	63.9	1.23e-9	NR	MDX1395788.1	2026742	g269605	i0	51.6	0.786885245901639	64	30	77.5	1	215	27	397	460	MDX1395788.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	192	63.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32039144	32039144	PRJNA564013_P_NODE_118818_length_384_cov_4.464396_g115974_i0	PRJNA564013	118818	384	4.464396	17.14328064	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	76.6	2.39e-13	NR	MEJ7810594.1	2026741	g115974	i0	71.2	0.7890625	52	14	39.8	1	384	232	444	495	MEJ7810594.1 coniferyl aldehyde dehydrogenase [Gemmatimonadaceae bacterium]	diamond	303	76.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32039189	32039189	PRJNA564013_P_NODE_345218_length_202_cov_0.921986_g342366_i0	PRJNA564013	345218	202	0.921986	1.86241172	Longimicrobium sp.	2029185	Bacteria	Bacteria	126	6.01e-33	NR	HST58994.1	2029185	g342366	i0	88.1	1.99009900990099	67	8	99.5	0	2	202	316	382	HST58994.1 beta-propeller domain-containing protein [Longimicrobium sp.]	diamond	402	126	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32355747	32355747	PRJNA564013_P_NODE_104419_length_403_cov_4.888889_g101583_i0	PRJNA564013	104419	403	4.888889	19.70222267	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	55.5	3.3e-6	NR	NIW36439.1	2026742	g101583	i0	35.7	0.62531017369727	84	51	61.8	2	344	96	1	82	NIW36439.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	252	55.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32765823	32765823	PRJNA564013_P_NODE_300860_length_225_cov_1.554878_g298008_i0	PRJNA564013	300860	225	1.554878	3.4984755	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	48.1	3.52e-4	NR	MDQ3520819.1	2026742	g298008	i0	45.6	0.76	57	24	66.7	1	20	169	37	93	MDQ3520819.1 zinc ribbon domain-containing protein [Gemmatimonadota bacterium]	diamond	171	48.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;