metadata: contig_metadata: 18 rows where bioproject = "PRJNA643700" and tax

18 rows where bioproject = "PRJNA643700" 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
6262351	6262351	PRJNA643700_P_NODE_289525_length_215_cov_2.192771_g287969_i0	PRJNA643700	289525	215	2.192771	4.71445765	Waddlia	71666	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|297375547\|gb\|CP001928.1\|	716544	g287969	i0	100	0.26046511627907	28	0	13	0	15	42	522886	522859	Waddlia chondrophila WSU 86-1044, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
6996716	6996716	PRJNA643700_P_NODE_292186_length_214_cov_1.260606_g290630_i0	PRJNA643700	292186	214	1.260606	2.69769684	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	318	1.68e-82	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g290630	i0	93.548	157.906542056075	217	8	100	5	1	214	1156012	1156225	Planctomyces sp. SH-PL62, complete genome	blastn	33792	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
8271366	8271366	PRJNA643700_P_NODE_200547_length_278_cov_1.506550_g198991_i0	PRJNA643700	200547	278	1.50655	4.188209	Candidatus Jettenia caeni	247490	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2556874801\|gb\|CP129467.1\|	247490	g198991	i0	100	0.10431654676259	29	0	10	0	55	83	2781608	2781580	MAG: Candidatus Jettenia caeni isolate YC-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Jettenia	Candidatus Jettenia caeni
15921030	15921030	PRJNA643700_P_NODE_312153_length_203_cov_2.246753_g310597_i0	PRJNA643700	312153	203	2.246753	4.56090859	Candidatus Kuenenia stuttgartensis	174633	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1818975054\|gb\|CP049055.1\|	174633	g310597	i0	100	0.551724137931034	28	0	14	0	49	76	3413704	3413677	Candidatus Kuenenia stuttgartiensis strain CSTR1 chromosome, complete genome	blastn	112	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Kuenenia	Candidatus Kuenenia stuttgartensis
21020618	21020618	PRJNA643700_P_NODE_379097_length_172_cov_1.504065_g377541_i0	PRJNA643700	379097	172	1.504065	2.5869918	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	285	1.31e-72	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g377541	i0	96.532	165.831395348837	173	4	100	2	1	172	2002704	2002533	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	28523	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22295222	22295222	PRJNA643700_P_NODE_269658_length_227_cov_1.168539_g268102_i0	PRJNA643700	269658	227	1.168539	2.65258353	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g268102	i0	100	0.127753303964758	29	0	13	0	33	61	4471859	4471887	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27049757	27049757	PRJNA643700_P_NODE_184602_length_293_cov_1.758197_g183046_i0	PRJNA643700	184602	293	1.758197	5.15151721	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	44.7	0.0138	NR	MBL7071077.1	2035772	g183046	i0	42.3	0.532423208191126	52	28	51.2	1	112	261	131	182	MBL7071077.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	156	44.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
27302659	27302659	PRJNA643700_P_NODE_305003_length_207_cov_1.601266_g303447_i0	PRJNA643700	305003	207	1.601266	3.31462062	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	43.5	0.0123	NR	MBN2139066.1	2813034	g303447	i0	43.5	0.666666666666667	46	26	66.7	0	47	184	421	466	MBN2139066.1 gamma-glutamylcyclotransferase [Sedimentisphaerales bacterium]	diamond	138	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
27586873	27586873	PRJNA643700_P_NODE_288744_length_216_cov_1.209581_g287188_i0	PRJNA643700	288744	216	1.209581	2.61269496	Pirellulales bacterium	2715253	Bacteria	Bacteria	43.9	0.0105	NR	HZZ29994.1	2715253	g287188	i0	37.7	0.736111111111111	53	30	69.4	1	7	156	39	91	HZZ29994.1 TolC family protein [Pirellulales bacterium]	diamond	159	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27870840	27870840	PRJNA643700_P_NODE_221385_length_260_cov_2.298578_g219829_i0	PRJNA643700	221385	260	2.298578	5.9763028	Victivallaceae bacterium	2793042	Bacteria	Bacteria	45.4	0.00518	NR	MDD4180908.1	2793042	g219829	i0	42.5	0.461538461538462	40	22	45	1	201	85	32	71	MDD4180908.1 beta-galactosidase trimerization domain-containing protein [Victivallaceae bacterium]	diamond	120	45.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
27902324	27902324	PRJNA643700_P_NODE_412345_length_164_cov_1.356522_g410789_i0	PRJNA643700	412345	164	1.356522	2.22469608	Verrucomicrobia bacterium Tous-C9LFEB	1982333	Bacteria	Bacteria	41.6	0.0334	NR	PAW77838.1	1982333	g410789	i0	39	0.75	41	25	75	0	142	20	467	507	PAW77838.1 MAG: hypothetical protein B9S32_09555 [Verrucomicrobia bacterium Tous-C9LFEB]	diamond	123	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium Tous-C9LFEB
28313071	28313071	PRJNA643700_P_NODE_236886_length_248_cov_15.321608_g235330_i0	PRJNA643700	236886	248	15.321608	37.99758784	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0216	NR	MEK0445437.1	2026799	g235330	i0	38	0.604838709677419	50	31	60.5	0	76	225	398	447	MEK0445437.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	150	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28628934	28628934	PRJNA643700_P_NODE_196427_length_282_cov_1.115880_g194871_i0	PRJNA643700	196427	282	1.11588	3.1467816	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	43.9	0.0198	NR	MBR1965056.1	2053569	g194871	i0	32.3	0.659574468085106	62	42	66	0	51	236	15	76	MBR1965056.1 hypothetical protein [Lentisphaeria bacterium]	diamond	186	43.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
28692070	28692070	PRJNA643700_P_NODE_230787_length_253_cov_1.754902_g229231_i0	PRJNA643700	230787	253	1.754902	4.43990206	Chlamydiales bacterium	2047757	Bacteria	Bacteria	43.1	0.0297	NR	MDR2540118.1	2047757	g229231	i0	40.7	0.640316205533597	54	29	60.5	2	98	250	64	117	MDR2540118.1 NAD(P)-dependent oxidoreductase [Chlamydiales bacterium]	diamond	162	43.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29165701	29165701	PRJNA643700_P_NODE_135009_length_354_cov_1.032787_g133454_i0	PRJNA643700	135009	354	1.032787	3.65606598	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	44.3	0.033	NR	MCA9280103.1	2052180	g133454	i0	36.7	0.508474576271186	60	33	50.8	1	314	135	116	170	MCA9280103.1 UDP-glucose 4-epimerase GalE [Phycisphaerales bacterium]	diamond	180	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29733555	29733555	PRJNA643700_P_NODE_180970_length_297_cov_1.258065_g179414_i0	PRJNA643700	180970	297	1.258065	3.73645305	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0409	NR	RMF76061.1	2026780	g179414	i0	37.7	0.535353535353535	53	22	53.5	1	29	187	12	53	RMF76061.1 MAG: hypothetical protein D6744_12685 [Planctomycetota bacterium]	diamond	159	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30934450	30934450	PRJNA643700_P_NODE_359214_length_181_cov_1.545455_g357658_i0	PRJNA643700	359214	181	1.545455	2.79727355	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42	0.0304	NR	MFM1748863.1	2026799	g357658	i0	38.8	0.812154696132597	49	25	81.2	1	150	4	16	59	MFM1748863.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	147	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31471933	31471933	PRJNA643700_P_NODE_274736_length_224_cov_1.188571_g273180_i0	PRJNA643700	274736	224	1.188571	2.66239904	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0289	NR	MBN1807603.1	2026780	g273180	i0	41.5	0.549107142857143	41	24	54.9	0	139	17	181	221	MBN1807603.1 MFS transporter [Planctomycetota bacterium]	diamond	123	42.7	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);;