metadata: contig_metadata: 27 rows where bioproject = "PRJNA1249042" and tax

27 rows where bioproject = "PRJNA1249042" and tax_clade = "PVC group"

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
354576	354576	PRJNA1249042_S_NODE_67321_length_190_cov_2.238095_g67107_i0	PRJNA1249042	67321	190	2.238095	4.2523805	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	279	6.88e-71	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g67107	i0	93.194	238.415789473684	191	11	100	2	1	190	2002496	2002685	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	45299	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11255500	11255500	PRJNA1249042_S_NODE_15389_length_280_cov_1.987342_g15175_i0	PRJNA1249042	15389	280	1.987342	5.5645576	Botrimarina	2795782	Bacteria	Bacteria	484	2.15e-132	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g15175	i0	97.857	310.957142857143	280	6	100	0	1	280	4247467	4247188	Planctomycetes bacterium K2D chromosome, complete genome	blastn	87068	484	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
13108334	13108334	PRJNA1249042_S_NODE_37731_length_227_cov_3.994565_g37517_i0	PRJNA1249042	37731	227	3.994565	9.06766255	Humisphaera borealis	2807512	Bacteria	Bacteria	231	2.4199999999999997e-56	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g37517	i0	85.526	50.4229074889868	228	26	99	7	4	227	5063116	5062892	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	11446	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13108786	13108786	PRJNA1249042_S_NODE_96251_length_164_cov_1.942149_g96037_i0	PRJNA1249042	96251	164	1.942149	3.18512436	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	191	2.78e-44	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g96037	i0	88.535	10.4146341463415	157	18	96	0	8	164	7956693	7956849	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	1708	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
16931904	16931904	PRJNA1249042_S_NODE_62774_length_195_cov_1.585526_g62560_i0	PRJNA1249042	62774	195	1.585526	3.0917757	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g62560	i0	100	0.143589743589744	28	0	14	0	93	120	914390	914417	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
17629993	17629993	PRJNA1249042_S_NODE_42534_length_220_cov_2.322034_g42320_i0	PRJNA1249042	42534	220	2.322034	5.1084748	Akkermansia	239934	Bacteria	Bacteria	213	8.44e-51	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g42320	i0	84.234	298.690909090909	222	31	100	4	1	220	139100	139319	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	65712	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
18206014	18206014	PRJNA1249042_S_NODE_18515_length_269_cov_1.840708_g18301_i0	PRJNA1249042	18515	269	1.840708	4.95150452	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	481	2.65e-131	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g18301	i0	98.885	146.226765799256	269	3	100	0	1	269	5171549	5171817	Lacipirellula limnantheis strain I41 chromosome	blastn	39335	481	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
24580498	24580498	PRJNA1249042_S_NODE_101920_length_160_cov_1.598291_g101706_i0	PRJNA1249042	101920	160	1.598291	2.5572656	Opitutia bacterium KCR 482	3034326	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|2707273910\|gb\|CP149973.1\|	3034326	g101706	i0	99.375	1	160	1	100	0	1	160	2274798	2274957	Opitutia bacterium KCR 482 chromosome, complete genome	blastn	160	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium KCR 482
24580832	24580832	PRJNA1249042_S_NODE_39180_length_225_cov_2.582418_g38966_i0	PRJNA1249042	39180	225	2.582418	5.8104405	Limnoglobus roseus	2598579	Bacteria	Bacteria	372	1.35e-98	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g38966	i0	96.444	41.1822222222222	225	8	100	0	1	225	2956669	2956893	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	9266	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
26693724	26693724	PRJNA1249042_S_NODE_61621_length_196_cov_2.437908_g61407_i0	PRJNA1249042	61621	196	2.437908	4.77829968	Candidatus Brocadia sp.	2172549	Bacteria	Bacteria	43.5	0.0109	NR	MCC7211201.1	2172549	g61407	i0	34	0.719387755102041	47	31	71.9	0	40	180	128	174	MCC7211201.1 ammonium transporter [Candidatus Brocadia sp.]	diamond	141	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Brocadia	Candidatus Brocadia sp.
27326556	27326556	PRJNA1249042_S_NODE_13763_length_287_cov_2.118852_g13549_i0	PRJNA1249042	13763	287	2.118852	6.08110524	Puniceicoccus vermicola	388746	Bacteria	Bacteria	42	0.021	NR	WP_185691218.1	388746	g13549	i0	31.9	0.721254355400697	69	45	70	1	265	65	4	72	WP_185691218.1 hypothetical protein [Puniceicoccus vermicola]	diamond	207	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Puniceicoccaceae	Puniceicoccus	Puniceicoccus vermicola
27547576	27547576	PRJNA1249042_S_NODE_20884_length_262_cov_1.652968_g20670_i0	PRJNA1249042	20884	262	1.652968	4.33077616	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	80.1	6.51e-17	NR	MBI3320003.1	2035772	g20670	i0	69.8	0.721374045801527	63	19	72.1	0	74	262	1	63	MBI3320003.1 MFS transporter [Candidatus Omnitrophota bacterium]	diamond	189	80.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
27705855	27705855	PRJNA1249042_S_NODE_86484_length_172_cov_2.131783_g86270_i0	PRJNA1249042	86484	172	2.131783	3.66666676	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	41.6	0.0363	NR	MBE2204806.1	2201154	g86270	i0	37.5	0.837209302325581	48	30	83.7	0	3	146	57	104	MBE2204806.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	144	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28021377	28021377	PRJNA1249042_S_NODE_64245_length_193_cov_2.833333_g64031_i0	PRJNA1249042	64245	193	2.833333	5.46833269	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0474	NR	MBI4554536.1	2026780	g64031	i0	42.2	0.699481865284974	45	25	69.9	1	21	155	261	304	MBI4554536.1 DUF362 domain-containing protein [Planctomycetota bacterium]	diamond	135	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28305346	28305346	PRJNA1249042_S_NODE_30486_length_240_cov_2.862944_g30272_i0	PRJNA1249042	30486	240	2.862944	6.8710656	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	44.7	0.00732	NR	NQV04333.1	2035772	g30272	i0	34.4	0.8	64	37	73.8	3	188	12	260	323	NQV04333.1 primosomal protein N' [Candidatus Omnitrophota bacterium]	diamond	192	44.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
28368404	28368404	PRJNA1249042_S_NODE_30106_length_241_cov_2.444444_g29892_i0	PRJNA1249042	30106	241	2.444444	5.89111004	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	40.8	0.021	NR	MDB6030368.1	2026801	g29892	i0	44	0.622406639004149	50	28	62.2	0	31	180	8	57	MDB6030368.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	150	40.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28968511	28968511	PRJNA1249042_S_NODE_12668_length_292_cov_2.377510_g12454_i0	PRJNA1249042	12668	292	2.37751	6.9423292	Opitutaceae bacterium	2006848	Bacteria	Bacteria	44.7	0.0146	NR	HZZ57448.1	2006848	g12454	i0	46.5	0.441780821917808	43	23	44.2	0	286	158	200	242	HZZ57448.1 chemotaxis protein CheB [Opitutaceae bacterium]	diamond	129	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29094860	29094860	PRJNA1249042_S_NODE_93128_length_166_cov_4.577236_g92914_i0	PRJNA1249042	93128	166	4.577236	7.59821176	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	43.1	0.00968	NR	MCG8432288.1	2035772	g92914	i0	62.1	0.524096385542169	29	11	52.4	0	13	99	187	215	MCG8432288.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Omnitrophota bacterium]	diamond	87	43.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29347402	29347402	PRJNA1249042_S_NODE_104909_length_158_cov_1.226087_g104695_i0	PRJNA1249042	104909	158	1.226087	1.93721746	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.2	0.0417	NR	MDM8009316.1	2026778	g104695	i0	40.9	0.835443037974684	44	26	83.5	0	147	16	307	350	MDM8009316.1 hypothetical protein [Phycisphaerae bacterium]	diamond	132	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29347404	29347404	PRJNA1249042_S_NODE_114269_length_152_cov_0.880734_g114055_i0	PRJNA1249042	114269	152	0.880734	1.33871568	Opitutales bacterium	2026772	Bacteria	Bacteria	42.7	0.0107	NR	MDP4644994.1	2026772	g114055	i0	37.3	1.00657894736842	51	28	92.8	1	10	150	213	263	MDP4644994.1 glycosyltransferase [Opitutales bacterium]	diamond	153	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
29441781	29441781	PRJNA1249042_S_NODE_38370_length_226_cov_3.852459_g38156_i0	PRJNA1249042	38370	226	3.852459	8.70655734	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	73.2	1.83e-13	NR	MBS7286896.1	2212473	g38156	i0	50	0.929203539823009	70	35	92.9	0	217	8	183	252	MBS7286896.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	210	73.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31210597	31210597	PRJNA1249042_S_NODE_8295_length_324_cov_1.967972_g8081_i0	PRJNA1249042	8295	324	1.967972	6.3762292800000004	Chlamydia trachomatis	813	Bacteria	Bacteria	43.9	0.00958	NR	CRH75139.1	813	g8081	i0	44.3	0.564814814814815	61	34	56.5	0	64	246	54	114	CRH75139.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	183	43.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
31260779	31260779	PRJNA1249042_S_NODE_50495_length_209_cov_2.638554_g50281_i0	PRJNA1249042	50495	209	2.638554	5.51457786	Bacteria	2	Bacteria	Bacteria	42.7	0.0227	NR	MFP6763499.1	2026779	g50281	i0	56.3	1.39234449760766	32	14	45.9	0	197	102	140	171	MFP6763499.1 enoyl-CoA hydratase-related protein [Planctomycetaceae bacterium]	diamond	291	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31495937	31495937	PRJNA1249042_S_NODE_4956_length_391_cov_2.589080_g4742_i0	PRJNA1249042	4956	391	2.58908	10.1233028	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	49.3	8.14e-4	NR	MCG8432288.1	2035772	g4742	i0	43.8	0.368286445012788	48	26	36.8	1	239	96	183	229	MCG8432288.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Omnitrophota bacterium]	diamond	144	49.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32001876	32001876	PRJNA1249042_S_NODE_72738_length_185_cov_0.992958_g72524_i0	PRJNA1249042	72738	185	0.992958	1.8369723	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0305	NR	NQU50444.1	2026780	g72524	i0	45.5	0.535135135135135	33	17	53.5	1	5	103	79	110	NQU50444.1 hydrogenase maturation nickel metallochaperone HypA [Planctomycetota bacterium]	diamond	99	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32508362	32508362	PRJNA1249042_S_NODE_13739_length_287_cov_2.336066_g13525_i0	PRJNA1249042	13739	287	2.336066	6.70450942	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	130	1.71e-33	NR	MEX2670747.1	2026777	g13525	i0	64.5	0.97212543554007	93	32	96.2	1	7	282	81	173	MEX2670747.1 alkaline phosphatase family protein [Phycisphaeraceae bacterium]	diamond	279	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
32540010	32540010	PRJNA1249042_S_NODE_96339_length_164_cov_1.818182_g96125_i0	PRJNA1249042	96339	164	1.818182	2.98181848	Planctomycetota bacterium	2026780	Bacteria	Bacteria	40	0.0433	NR	MBM4009035.1	2026780	g96125	i0	51.5	0.603658536585366	33	16	60.4	0	64	162	75	107	MBM4009035.1 glycosyltransferase [Planctomycetota bacterium]	diamond	99	40	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;