metadata: contig_metadata: 17 rows where bioproject = "PRJNA1126661", tax_clade = "FCB group" and tax

17 rows where bioproject = "PRJNA1126661", 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
2833018	2833018	PRJNA1126661_P_NODE_33363_length_301_cov_9.771930_g32834_i0	PRJNA1126661	33363	301	9.77193	29.4135093	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	80.1	5.36e-15	NR	HEX6048367.1	2026741	g32834	i0	80.9	0.46843853820598	47	9	46.8	0	142	2	1	47	HEX6048367.1 FAD-dependent oxidoreductase [Gemmatimonadaceae bacterium]	diamond	141	80.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
7935210	7935210	PRJNA1126661_P_NODE_21967_length_326_cov_3.596838_g21438_i0	PRJNA1126661	21967	326	3.596838	11.72569188	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	132	3.83e-26	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g21438	i0	84.962	6.68098159509202	133	16	40	4	1	131	150200	150070	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	2178	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10486240	10486240	PRJNA1126661_P_NODE_65669_length_264_cov_4.345550_g65139_i0	PRJNA1126661	65669	264	4.34555	11.472252	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	119	4.11e-29	NR	MFL5620983.1	2026741	g65139	i0	72.1	0.977272727272727	86	24	97.7	0	263	6	84	169	MFL5620983.1 ADOP family duplicated permease [Gemmatimonadaceae bacterium]	diamond	258	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
11234373	11234373	PRJNA1126661_P_NODE_45689_length_299_cov_5.933628_g45160_i0	PRJNA1126661	45689	299	5.933628	17.74154772	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	96.7	4.64e-21	NR	HEX7942347.1	2026741	g45160	i0	91.8	1.97658862876254	49	4	49.2	0	152	298	162	210	HEX7942347.1 amidohydrolase family protein [Gemmatimonadaceae bacterium]	diamond	591	96.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
15585452	15585452	PRJNA1126661_P_NODE_47273_length_298_cov_5.257778_g46744_i0	PRJNA1126661	47273	298	5.257778	15.66817844	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	74.3	2.91e-13	NR	HWV58261.1	2910168	g46744	i0	80.9	0.473154362416107	47	9	47.3	0	1	141	127	173	HWV58261.1 NADP-dependent oxidoreductase [Longimicrobiales bacterium]	diamond	141	74.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
18134638	18134638	PRJNA1126661_P_NODE_84495_length_209_cov_4.588235_g83965_i0	PRJNA1126661	84495	209	4.588235	9.58941115	Longimicrobium sp.	2029185	Bacteria	Bacteria	115	8.16e-28	NR	HYH81956.1	2029185	g83965	i0	76.8	0.990430622009569	69	16	99	0	207	1	2805	2873	HYH81956.1 amino acid adenylation domain-containing protein [Longimicrobium sp.]	diamond	207	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
20157217	20157217	PRJNA1126661_P_NODE_20636_length_326_cov_3.818182_g20107_i0	PRJNA1126661	20636	326	3.818182	12.44727332	Gemmatimonas sp. UBA7669	1946568	Bacteria	Bacteria	111	3.73e-29	NR	WP_291160863.1	1946568	g20107	i0	100	0.460122699386503	50	0	46	0	1	150	26	75	WP_291160863.1 6-carboxytetrahydropterin synthase QueD [Gemmatimonas sp. UBA7669]	diamond	150	111	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. UBA7669
21959175	21959175	PRJNA1126661_P_NODE_35458_length_301_cov_5.899123_g34929_i0	PRJNA1126661	35458	301	5.899123	17.75636023	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	117	9.79e-22	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g34929	i0	84.615	26.0066445182724	117	18	39	0	31	147	4861305	4861421	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	7828	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24508239	24508239	PRJNA1126661_P_NODE_25500_length_326_cov_3.114625_g24971_i0	PRJNA1126661	25500	326	3.114625	10.1536775	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	82.4	4.7e-17	NR	HEX9055690.1	2448054	g24971	i0	78	0.920245398773006	50	11	46	0	150	1	13	62	HEX9055690.1 lipocalin family protein [Gemmatimonadales bacterium]	diamond	300	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26880658	26880658	PRJNA1126661_P_NODE_7581_length_326_cov_12.075099_g7052_i0	PRJNA1126661	7581	326	12.075099	39.36482274	Gemmatimonas sp.	1962908	Bacteria	Bacteria	53.9	1.19e-5	NR	MCO4098246.1	1962908	g7052	i0	58.3	2.19938650306748	48	16	43.3	2	186	326	24	68	MCO4098246.1 class I SAM-dependent DNA methyltransferase [Gemmatimonas sp.]	diamond	717	53.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
28933560	28933560	PRJNA1126661_P_NODE_19068_length_326_cov_4.090909_g18539_i0	PRJNA1126661	19068	326	4.090909	13.33636334	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	47.4	7.62e-4	NR	HWJ21061.1	2026741	g18539	i0	90	0.184049079754601	20	2	18.4	0	1	60	96	115	HWJ21061.1 HNH endonuclease [Gemmatimonadaceae bacterium]	diamond	60	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29028547	29028547	PRJNA1126661_P_NODE_70048_length_253_cov_2.288889_g69518_i0	PRJNA1126661	70048	253	2.288889	5.79088917	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	43.1	0.03	NR	HEY7234229.1	2026741	g69518	i0	33.3	0.99604743083004	84	46	87.7	2	19	240	140	223	HEY7234229.1 PQQ-binding-like beta-propeller repeat protein [Gemmatimonadaceae bacterium]	diamond	252	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29438315	29438315	PRJNA1126661_P_NODE_17650_length_326_cov_4.383399_g17121_i0	PRJNA1126661	17650	326	4.383399	14.28988074	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	85.1	8.18e-17	NR	MFL5381238.1	3047548	g17121	i0	41.3	2.25460122699387	121	43	85.6	2	326	48	69	189	MFL5381238.1 reverse transcriptase family protein [Longimicrobiaceae bacterium]	diamond	735	85.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
29659298	29659298	PRJNA1126661_P_NODE_24390_length_326_cov_3.292490_g23861_i0	PRJNA1126661	24390	326	3.29249	10.7335174	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	63.5	1.58e-10	NR	MBK8246349.1	2026742	g23861	i0	79.4	0.312883435582822	34	7	31.3	0	133	32	62	95	MBK8246349.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	102	63.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30765435	30765435	PRJNA1126661_P_NODE_70534_length_252_cov_0.871508_g70004_i0	PRJNA1126661	70534	252	0.871508	2.19620016	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.9	0.0159	NR	HUP01797.1	2026742	g70004	i0	61.5	1.11904761904762	39	12	42.9	1	144	251	6	44	HUP01797.1 electron transfer flavoprotein-ubiquinone oxidoreductase [Gemmatimonadota bacterium]	diamond	282	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30849265	30849265	PRJNA1126661_P_NODE_11854_length_326_cov_6.221344_g11325_i0	PRJNA1126661	11854	326	6.221344	20.28158144	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	2.35e-20	NR	MDQ3081507.1	2026742	g11325	i0	77.6	1.35276073619632	49	11	45.1	0	326	180	202	250	MDQ3081507.1 ribonuclease J [Gemmatimonadota bacterium]	diamond	441	94.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31112765	31112765	PRJNA1126661_P_NODE_46275_length_299_cov_3.446903_g45746_i0	PRJNA1126661	46275	299	3.446903	10.30623997	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	73.6	8.29e-14	NR	HWP36559.1	2448054	g45746	i0	72.9	0.963210702341137	48	13	48.2	0	299	156	123	170	HWP36559.1 GNAT family protein [Gemmatimonadales bacterium]	diamond	288	73.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;