metadata: contig_metadata: 16 rows where bioproject = "PRJNA942359", tax_clade = "FCB group" and tax

16 rows where bioproject = "PRJNA942359", 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
6026277	6026277	PRJNA942359_P_NODE_6825_length_325_cov_2.678571_g6710_i0	PRJNA942359	6825	325	2.678571	8.70535575	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	379	1.23e-100	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g6710	i0	87.842	12.7076923076923	329	32	100	6	1	325	3043619	3043943	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	4130	379	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8911718	8911718	PRJNA942359_P_NODE_8687_length_294_cov_1.972851_g8572_i0	PRJNA942359	8687	294	1.972851	5.80018194	Gemmatimonas	173479	Bacteria	Bacteria	403	6.5399999999999995e-108	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g8572	i0	91.554	116.462585034014	296	19	100	5	1	294	835	544	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	34240	403	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
9851092	9851092	PRJNA942359_P_NODE_4748_length_377_cov_1.812500_g4633_i0	PRJNA942359	4748	377	1.8125	6.833125	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	366	1.1299999999999996e-96	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g4633	i0	84.474	98.5358090185676	380	49	99	10	1	376	1101539	1101912	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	37148	366	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
12402149	12402149	PRJNA942359_P_NODE_1990_length_554_cov_1.866944_g1876_i0	PRJNA942359	1990	554	1.866944	10.34286976	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	697	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g1876	i0	89.483	91.5018050541516	561	45	100	14	1	554	3043714	3043161	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	50692	697	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16225979	16225979	PRJNA942359_P_NODE_2573_length_489_cov_7.175481_g2459_i0	PRJNA942359	2573	489	7.1754810000000004	35.08810209	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	601	3.78e-167	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g2459	i0	88.956	67.2167689161554	498	39	100	15	1	489	3042810	3042320	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	32869	601	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
17501200	17501200	PRJNA942359_P_NODE_19614_length_243_cov_0.917647_g19499_i0	PRJNA942359	19614	243	0.917647	2.22988221	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	137	5.14e-36	NR	MEO5567146.1	2026741	g19499	i0	86.3	0.987654320987654	80	11	98.8	0	242	3	241	320	MEO5567146.1 endopeptidase La [Gemmatimonadaceae bacterium]	diamond	240	137	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
18774631	18774631	PRJNA942359_P_NODE_1335_length_669_cov_3.776846_g1227_i0	PRJNA942359	1335	669	3.776846	25.26709974	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	1053	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g1227	i0	95.089	140.919282511211	672	28	100	5	1	669	3042853	3043522	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	94275	1053	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
26930350	26930350	PRJNA942359_P_NODE_11002_length_270_cov_1.893401_g10887_i0	PRJNA942359	11002	270	1.893401	5.1121827	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	122	5.99e-33	NR	MES3034888.1	2026742	g10887	i0	96.7	0.666666666666667	60	2	66.7	0	1	180	111	170	MES3034888.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Gemmatimonadota bacterium]	diamond	180	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27530799	27530799	PRJNA942359_P_NODE_16683_length_247_cov_0.896552_g16568_i0	PRJNA942359	16683	247	0.896552	2.21448344	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	123	2.03e-30	NR	HEV2086599.1	2448054	g16568	i0	82.9	3.98380566801619	82	14	99.6	0	247	2	195	276	HEV2086599.1 FtsX-like permease family protein [Gemmatimonadales bacterium]	diamond	984	123	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29621046	29621046	PRJNA942359_P_NODE_15430_length_249_cov_0.886364_g15315_i0	PRJNA942359	15430	249	0.886364	2.20704636	FCB group	1783270	Bacteria	Bacteria	43.1	0.0219	NR	MEO5510353.1	2910168	g15315	i0	54.1	2.75903614457831	37	17	44.6	0	190	80	3	39	MEO5510353.1 PH domain-containing protein [Longimicrobiales bacterium]	diamond	687	43.5	0.990804597701149	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
29772382	29772382	PRJNA942359_P_NODE_12991_length_253_cov_0.866667_g12876_i0	PRJNA942359	12991	253	0.866667	2.19266751	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	136	7e-38	NR	HKH93282.1	2026741	g12876	i0	73.8	0.99604743083004	84	22	99.6	0	1	252	81	164	HKH93282.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	252	136	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30278385	30278385	PRJNA942359_P_NODE_17832_length_246_cov_0.901734_g17717_i0	PRJNA942359	17832	246	0.901734	2.21826564	Longimicrobium sp.	2029185	Bacteria	Bacteria	96.7	3.69e-21	NR	HYW13097.1	2029185	g17717	i0	88.2	0.829268292682927	68	7	81.7	1	46	246	1	68	HYW13097.1 glycoside hydrolase family 28 protein [Longimicrobium sp.]	diamond	204	96.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30941709	30941709	PRJNA942359_P_NODE_16134_length_248_cov_0.891429_g16019_i0	PRJNA942359	16134	248	0.891429	2.21074392	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	135	1.1e-35	NR	MFN2564625.1	2026741	g16019	i0	86.6	1.99596774193548	82	11	99.2	0	247	2	254	335	MFN2564625.1 carboxypeptidase regulatory-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	495	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32301841	32301841	PRJNA942359_P_NODE_19239_length_243_cov_0.917647_g19124_i0	PRJNA942359	19239	243	0.917647	2.22988221	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	115	9.36e-28	NR	HEV8362660.1	2026741	g19124	i0	80	0.987654320987654	80	16	98.8	0	3	242	704	783	HEV8362660.1 ADOP family duplicated permease [Gemmatimonadaceae bacterium]	diamond	240	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32459813	32459813	PRJNA942359_P_NODE_18239_length_245_cov_0.906977_g18124_i0	PRJNA942359	18239	245	0.906977	2.22209365	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	104	3.5399999999999995e-24	NR	HEY7529092.1	2026742	g18124	i0	67.9	2.97551020408163	81	26	99.2	0	243	1	106	186	HEY7529092.1 DASS family sodium-coupled anion symporter [Gemmatimonadota bacterium]	diamond	729	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32624302	32624302	PRJNA942359_P_NODE_19940_length_242_cov_0.923077_g19825_i0	PRJNA942359	19940	242	0.923077	2.23384634	Roseisolibacter	2093335	Bacteria	Bacteria	65.9	6.88e-12	NR	WP_284350720.1	2014610	g19825	i0	76.2	1.62396694214876	42	10	52.1	0	238	113	2	43	WP_284350720.1 hypothetical protein [Roseisolibacter agri]	diamond	393	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter agri

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