metadata: contig_metadata: 21 rows where bioproject = "PRJNA404067", tax_clade = "FCB group" and tax

21 rows where bioproject = "PRJNA404067", 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
1689551	1689551	PRJNA404067_P_NODE_33322_length_206_cov_2.675862_g32935_i0	PRJNA404067	33322	206	2.675862	5.51227572	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	300	5.82e-77	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g32935	i0	92.788	114.543689320388	208	13	100	2	1	206	421491	421698	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	23596	300	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9342781	9342781	PRJNA404067_P_NODE_27848_length_216_cov_1.329032_g27461_i0	PRJNA404067	27848	216	1.329032	2.87070912	Bacteria	2	Bacteria	Bacteria	124	1.94e-32	NR	HKY97522.1	2026741	g27461	i0	85.9	5.91666666666667	71	10	98.6	0	3	215	158	228	HKY97522.1 polyprenyl synthetase family protein [Gemmatimonadaceae bacterium]	diamond	1278	124	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
14443392	14443392	PRJNA404067_P_NODE_16912_length_253_cov_0.953125_g16525_i0	PRJNA404067	16912	253	0.953125	2.41140625	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	318	2.05e-82	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g16525	i0	89.328	81.1185770750988	253	27	100	0	1	253	1103221	1102969	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	20523	318	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
15717446	15717446	PRJNA404067_P_NODE_35253_length_204_cov_1.405594_g34866_i0	PRJNA404067	35253	204	1.405594	2.86741176	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	87.9	4.88e-13	NTclustered	gi\|2107901501\|gb\|CP070815.1\|	2026742	g34866	i0	96.226	7.77941176470588	53	2	26	0	151	203	4018572	4018520	MAG: Gemmatimonadetes bacterium isolate bin118 chromosome	blastn	1587	87.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
25307374	25307374	PRJNA404067_P_NODE_18720_length_241_cov_1.894444_g18333_i0	PRJNA404067	18720	241	1.894444	4.56561004	Gemmatimonadaceae	219687	Bacteria	Bacteria	171	5.74e-38	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g18333	i0	83.516	76.896265560166	182	30	76	0	51	232	748472	748653	Gemmatimonas phototrophica strain AP64, complete genome	blastn	18532	172	0.994186046511628	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
26632272	26632272	PRJNA404067_P_NODE_12901_length_292_cov_0.965368_g12514_i0	PRJNA404067	12901	292	0.965368	2.81887456	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	52	1.17e-5	NR	HEY4219126.1	2026741	g12514	i0	32.6	0.945205479452055	92	61	94.5	1	276	1	57	147	HEY4219126.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	276	52	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26948794	26948794	PRJNA404067_P_NODE_31762_length_208_cov_1.632653_g31375_i0	PRJNA404067	31762	208	1.632653	3.39591824	Gemmatimonas sp.	1962908	Bacteria	Bacteria	55.5	1.38e-7	NR	WP_353265836.1	1962908	g31375	i0	57.4	0.677884615384615	47	15	67.8	1	60	200	1	42	WP_353265836.1 hypothetical protein [Gemmatimonas sp.]	diamond	141	55.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
26948798	26948798	PRJNA404067_P_NODE_38822_length_201_cov_0.914286_g38435_i0	PRJNA404067	38822	201	0.914286	1.83771486	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	53.1	4.71e-6	NR	HMA19240.1	2026741	g38435	i0	53.1	0.955223880597015	64	21	82.1	3	198	34	779	842	HMA19240.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium]	diamond	192	53.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27075417	27075417	PRJNA404067_P_NODE_31282_length_209_cov_0.864865_g30895_i0	PRJNA404067	31282	209	0.864865	1.80756785	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	80.9	1.32e-16	NR	HEV8214326.1	2026741	g30895	i0	57.4	0.875598086124402	61	26	87.6	0	26	208	111	171	HEV8214326.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	183	80.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27580874	27580874	PRJNA404067_P_NODE_34744_length_205_cov_0.888889_g34357_i0	PRJNA404067	34744	205	0.888889	1.82222245	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.9	0.00618	NR	MEX2153367.1	2026741	g34357	i0	50	0.64390243902439	44	22	64.4	0	203	72	146	189	MEX2153367.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	132	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28370251	28370251	PRJNA404067_P_NODE_27886_length_216_cov_1.277419_g27499_i0	PRJNA404067	27886	216	1.277419	2.75922504	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	125	1.61e-32	NR	MCC6319746.1	2026741	g27499	i0	87.5	1	72	9	100	0	216	1	275	346	MCC6319746.1 tetratricopeptide repeat protein [Gemmatimonadaceae bacterium]	diamond	216	125	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28433518	28433518	PRJNA404067_P_NODE_31066_length_209_cov_1.391892_g30679_i0	PRJNA404067	31066	209	1.391892	2.90905428	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	135	1.29e-36	NR	HKH94524.1	2026741	g30679	i0	100	10.7942583732057	69	0	99	0	208	2	279	347	HKH94524.1 replication-associated recombination protein A [Gemmatimonadaceae bacterium]	diamond	2256	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28623031	28623031	PRJNA404067_P_NODE_26847_length_218_cov_1.522293_g26460_i0	PRJNA404067	26847	218	1.522293	3.31859874	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	74.7	8.69e-14	NR	HEU4748145.1	2026741	g26460	i0	75	1.45871559633028	52	13	71.6	0	11	166	270	321	HEU4748145.1 selenide, water dikinase SelD [Gemmatimonadaceae bacterium]	diamond	318	74.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29128318	29128318	PRJNA404067_P_NODE_28749_length_214_cov_1.150327_g28362_i0	PRJNA404067	28749	214	1.150327	2.46169978	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	83.6	7.05e-17	NR	MBW3630324.1	2026742	g28362	i0	63.3	0.841121495327103	60	22	84.1	0	180	1	2	61	MBW3630324.1 amidohydrolase family protein [Gemmatimonadota bacterium]	diamond	180	83.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29506869	29506869	PRJNA404067_P_NODE_14530_length_272_cov_2.469194_g14143_i0	PRJNA404067	14530	272	2.469194	6.71620768	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	98.2	1.4599999999999995e-23	NR	MDP3908887.1	2448054	g14143	i0	52.3	0.970588235294118	88	41	97.1	1	2	265	73	159	MDP3908887.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	264	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29822486	29822486	PRJNA404067_P_NODE_35591_length_204_cov_0.895105_g35204_i0	PRJNA404067	35591	204	0.895105	1.8260142	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	135	3.18e-36	NR	MBC7898251.1	2026741	g35204	i0	94	2.95588235294118	67	4	98.5	0	203	3	103	169	MBC7898251.1 deoxyhypusine synthase [Gemmatimonadaceae bacterium]	diamond	603	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30043757	30043757	PRJNA404067_P_NODE_23511_length_227_cov_0.951807_g23124_i0	PRJNA404067	23511	227	0.951807	2.16060189	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	56.6	3.78e-7	NR	MFL5481140.1	2026741	g23124	i0	58.1	3.03964757709251	43	18	56.8	0	9	137	394	436	MFL5481140.1 SGNH/GDSL hydrolase family protein [Gemmatimonadaceae bacterium]	diamond	690	56.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30060382	30060382	PRJNA404067_P_NODE_32951_length_207_cov_0.876712_g32564_i0	PRJNA404067	32951	207	0.876712	1.81479384	Longimicrobium	1804994	Bacteria	Bacteria	59.7	2.35e-8	NR	MDQ2667180.1	2026742	g32564	i0	58.2	2.65217391304348	55	23	79.7	0	38	202	64	118	MDQ2667180.1 HD domain-containing protein [Gemmatimonadota bacterium]	diamond	549	59.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30486227	30486227	PRJNA404067_P_NODE_31073_length_209_cov_1.391892_g30686_i0	PRJNA404067	31073	209	1.391892	2.90905428	Longimicrobium sp.	2029185	Bacteria	Bacteria	43.5	0.013	NR	HEU0298702.1	2029185	g30686	i0	62.5	1.43540669856459	32	12	45.9	0	207	112	877	908	HEU0298702.1 HAD-IC family P-type ATPase [Longimicrobium sp.]	diamond	300	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30517770	30517770	PRJNA404067_P_NODE_17613_length_248_cov_1.251337_g17226_i0	PRJNA404067	17613	248	1.251337	3.10331576	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	64.7	1.92e-10	NR	NJD10037.1	2026742	g17226	i0	52.2	0.810483870967742	67	31	81	1	246	46	136	201	NJD10037.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	201	64.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30738856	30738856	PRJNA404067_P_NODE_19574_length_238_cov_1.508475_g19187_i0	PRJNA404067	19574	238	1.508475	3.5901705	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	121	9.759999999999999e-32	NR	WP_367885442.1	3062599	g19187	i0	80.5	0.970588235294118	77	15	97.1	0	6	236	97	173	WP_367885442.1 PHP domain-containing protein [Pseudogemmatithrix spongiicola]	diamond	231	121	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola

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