metadata: contig_metadata: 19 rows where bioproject = "PRJEB14803", tax_clade = "FCB group" and tax

19 rows where bioproject = "PRJEB14803", 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
9913986	9913986	PRJEB14803_P_NODE_42328_length_160_cov_1.280000_g41862_i0	PRJEB14803	42328	160	1.28	2.048	FCB group	1783270	Bacteria	Bacteria	73.1	1.02e-8	NTclustered	gi\|2108325062\|gb\|CP070666.1\|	2026742	g41862	i0	93.878	28.8875	49	2	31	1	44	92	3596955	3597002	MAG: Gemmatimonadetes bacterium isolate bin75 chromosome	blastn	4622	73.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27380966	27380966	PRJEB14803_P_NODE_28763_length_203_cov_1.886905_g28297_i0	PRJEB14803	28763	203	1.886905	3.83041715	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.7	0.0226	NR	PYP13734.1	2026742	g28297	i0	46.2	0.576354679802956	39	21	57.6	0	9	125	733	771	PYP13734.1 MAG: hypothetical protein DMD54_15850, partial [Gemmatimonadota bacterium]	diamond	117	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27601997	27601997	PRJEB14803_P_NODE_2784_length_860_cov_11.853333_g2476_i0	PRJEB14803	2784	860	11.853333	101.9386638	Longimicrobium sp.	2029185	Bacteria	Bacteria	121	3.09e-29	NR	HEX2080112.1	2029185	g2476	i0	36.8	3.71511627906977	220	121	75	8	771	127	2	208	HEX2080112.1 hypothetical protein [Longimicrobium sp.]	diamond	3195	121	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28043840	28043840	PRJEB14803_P_NODE_23825_length_230_cov_1.830769_g23359_i0	PRJEB14803	23825	230	1.830769	4.2107687	Candidatus Palauibacterales bacterium	2994973	Bacteria	Bacteria	44.3	0.00804	NR	MDP2496468.1	2994973	g23359	i0	33.3	0.860869565217391	66	42	86.1	1	217	20	148	211	MDP2496468.1 Nif3-like dinuclear metal center hexameric protein [Candidatus Palauibacterales bacterium]	diamond	198	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Candidatus Palauibacterales			Candidatus Palauibacterales bacterium
28643937	28643937	PRJEB14803_P_NODE_35187_length_179_cov_1.666667_g34721_i0	PRJEB14803	35187	179	1.666667	2.98333393	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	41.6	0.041	NR	MFL5562436.1	2026741	g34721	i0	44.4	0.905027932960894	54	29	90.5	1	169	8	560	612	MFL5562436.1 ABC transporter ATP-binding protein [Gemmatimonadaceae bacterium]	diamond	162	41.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28675446	28675446	PRJEB14803_P_NODE_16927_length_289_cov_1.842520_g16461_i0	PRJEB14803	16927	289	1.84252	5.3248828	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	68.2	7.43e-11	NR	NNE08319.1	2026742	g16461	i0	39	2.54325259515571	82	42	85.1	2	267	22	261	334	NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium]	diamond	735	68.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29149360	29149360	PRJEB14803_P_NODE_47409_length_150_cov_1.391304_g46943_i0	PRJEB14803	47409	150	1.391304	2.086956	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	53.1	8.93e-7	NR	MFL5565426.1	2026741	g46943	i0	43.5	1.9	46	26	92	0	143	6	9	54	MFL5565426.1 D-hexose-6-phosphate mutarotase [Gemmatimonadaceae bacterium]	diamond	285	53.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29275039	29275039	PRJEB14803_P_NODE_13209_length_340_cov_1.495082_g12744_i0	PRJEB14803	13209	340	1.495082	5.0832788	Gemmatimonas sp.	1962908	Bacteria	Bacteria	56.2	2.69e-7	NR	WP_411282468.1	1962908	g12744	i0	52.7	0.485294117647059	55	26	48.5	0	138	302	4	58	WP_411282468.1 YccF domain-containing protein [Gemmatimonas sp.]	diamond	165	56.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
29363683	29363683	PRJEB14803_P_NODE_2309_length_945_cov_3.400000_g2030_i0	PRJEB14803	2309	945	3.4	32.13	root	1	Root_unresolved	Root_unresolved	208	1.82e-62	NR	MDH4352086.1	2026742	g2030	i0	51.7	2.94603174603175	230	103	73	5	823	134	23	244	MDH4352086.1 SDR family oxidoreductase [Gemmatimonadota bacterium]	diamond	2784	208	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29395182	29395182	PRJEB14803_P_NODE_5009_length_622_cov_3.454855_g4609_i0	PRJEB14803	5009	622	3.454855	21.4891981	Bacteria	2	Bacteria	Bacteria	129	1.46e-34	NR	HET9332701.1	2026742	g4609	i0	49.6	2.86012861736334	123	60	59.3	1	453	85	2	122	HET9332701.1 rhodanese-like domain-containing protein [Gemmatimonadota bacterium]	diamond	1779	129	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30665014	30665014	PRJEB14803_P_NODE_26613_length_214_cov_1.189944_g26147_i0	PRJEB14803	26613	214	1.189944	2.54648016	uncultured Gemmatimonadota bacterium	203437	Bacteria	Bacteria	40.8	0.042	NR	CAA9311409.1	203437	g26147	i0	42	0.967289719626168	69	30	85.5	2	7	189	22	88	CAA9311409.1 MAG: hypothetical protein AVDCRST_MAG68-1242, partial [uncultured Gemmatimonadota bacterium]	diamond	207	40.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
30665032	30665032	PRJEB14803_P_NODE_37753_length_171_cov_2.058824_g37287_i0	PRJEB14803	37753	171	2.058824	3.52058904	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.5	0.00739	NR	TVP75733.1	2448054	g37287	i0	47.5	1.03508771929825	59	24	94.7	3	2	163	177	233	TVP75733.1 MAG: D-2-hydroxyacid dehydrogenase [Gemmatimonadales bacterium]	diamond	177	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31929600	31929600	PRJEB14803_P_NODE_33117_length_186_cov_1.344371_g32651_i0	PRJEB14803	33117	186	1.344371	2.50053006	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	52	9.36e-6	NR	MDA0313235.1	2026742	g32651	i0	45	0.967741935483871	60	33	96.8	0	182	3	630	689	MDA0313235.1 acyl-CoA dehydrogenase [Gemmatimonadota bacterium]	diamond	180	52	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32303241	32303241	PRJEB14803_P_NODE_31119_length_193_cov_1.848101_g30653_i0	PRJEB14803	31119	193	1.848101	3.56683493	Bacteria	2	Bacteria	Bacteria	85.9	2.77e-19	NR	MFL5608402.1	2026741	g30653	i0	63.5	7.83419689119171	63	23	97.9	0	3	191	76	138	MFL5608402.1 GNAT family N-acetyltransferase [Gemmatimonadaceae bacterium]	diamond	1512	86.7	0.990772779700115	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32562715	32562715	PRJEB14803_P_NODE_21479_length_247_cov_1.500000_g21013_i0	PRJEB14803	21479	247	1.5	3.705	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	98.2	7.290000000000001e-22	NR	HKW46647.1	2026741	g21013	i0	61	0.995951417004049	82	32	99.6	0	1	246	14	95	HKW46647.1 ammonium transporter [Gemmatimonadaceae bacterium]	diamond	246	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32587777	32587777	PRJEB14803_P_NODE_39519_length_167_cov_0.909091_g39053_i0	PRJEB14803	39519	167	0.909091	1.51818197	Pseudomonadati	3379134	Bacteria	Bacteria	53.5	2.03e-6	NR	MEN8144892.1	2026742	g39053	i0	62.8	3.05389221556886	43	16	77.2	0	165	37	221	263	MEN8144892.1 bacillithiol system redox-active protein YtxJ [Gemmatimonadota bacterium]	diamond	510	53.9	0.992578849721707	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32594046	32594046	PRJEB14803_P_NODE_10300_length_400_cov_2.410959_g9835_i0	PRJEB14803	10300	400	2.410959	9.643836	Longimicrobium sp.	2029185	Bacteria	Bacteria	67.8	1.03e-10	NR	HEX2209649.1	2029185	g9835	i0	33.6	1.9875	134	75	98.3	2	398	6	44	166	HEX2209649.1 hypothetical protein [Longimicrobium sp.]	diamond	795	67.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32594070	32594070	PRJEB14803_P_NODE_21040_length_250_cov_1.772093_g20574_i0	PRJEB14803	21040	250	1.772093	4.4302325	Longimicrobium sp.	2029185	Bacteria	Bacteria	42.7	0.04	NR	HEX6369166.1	2029185	g20574	i0	39.2	0.612	51	31	61.2	0	219	67	102	152	HEX6369166.1 hypothetical protein [Longimicrobium sp.]	diamond	153	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32656621	32656621	PRJEB14803_P_NODE_44940_length_155_cov_1.000000_g44474_i0	PRJEB14803	44940	155	1	1.55	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	61.2	1.19e-9	NR	HEY0671806.1	2910168	g44474	i0	52.9	1.74193548387097	51	24	98.7	0	2	154	64	114	HEY0671806.1 6-bladed beta-propeller [Longimicrobiales bacterium]	diamond	270	61.2	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);;