metadata: contig_metadata: 12 rows where bioproject = "PRJNA751877", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA751877", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
726443	726443	PRJNA751877_P_NODE_26941_length_245_cov_0.895349_g26819_i0	PRJNA751877	26941	245	0.895349	2.19360505	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	224	4.43e-54	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g26819	i0	83.197	11.8775510204082	244	41	99	0	2	245	6246643	6246400	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	2910	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2002144	2002144	PRJNA751877_P_NODE_10962_length_336_cov_2.144487_g10840_i0	PRJNA751877	10962	336	2.144487	7.20547632	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	604	1.9399999999999992e-168	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g10840	i0	99.107	171.071428571429	336	3	100	0	1	336	267608	267943	Tautonia plasticadhaerens strain ElP chromosome	blastn	57480	604	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
5830152	5830152	PRJNA751877_P_NODE_365_length_1120_cov_2.945559_g280_i0	PRJNA751877	365	1120	2.945559	32.9902608	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	2002	0	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g280	i0	98.929	240.295535714286	1120	12	100	0	1	1120	266593	265474	Tautonia plasticadhaerens strain ElP chromosome	blastn	269131	2002	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
16029045	16029045	PRJNA751877_P_NODE_23873_length_249_cov_0.875000_g23751_i0	PRJNA751877	23873	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	69.7	2.35e-13	NR	MDB5349418.1	2026780	g23751	i0	77.3	0.530120481927711	44	10	53	0	115	246	2	45	MDB5349418.1 acyP [Planctomycetota bacterium]	diamond	132	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
18578259	18578259	PRJNA751877_P_NODE_3575_length_485_cov_1.881068_g3453_i0	PRJNA751877	3575	485	1.881068	9.1231798	Limnoglobus roseus	2598579	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g3453	i0	100	0.0639175257731959	31	0	6	0	395	425	7374488	7374518	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
22403799	22403799	PRJNA751877_P_NODE_25238_length_247_cov_1.419540_g25116_i0	PRJNA751877	25238	247	1.41954	3.5062638	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	313	9.28e-81	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g25116	i0	90.041	0.975708502024291	241	24	98	0	2	242	6472399	6472639	Planctomyces sp. SH-PL62, complete genome	blastn	241	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
24152020	24152020	PRJNA751877_P_NODE_5399_length_424_cov_1.754986_g5277_i0	PRJNA751877	5399	424	1.754986	7.44114064	Engelhardtia	139931	Bacteria	Bacteria	58.4	8.78e-4	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g5277	i0	92.5	0.188679245283019	40	3	9	0	278	317	5427271	5427310	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	80	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
31126663	31126663	PRJNA751877_P_NODE_22535_length_251_cov_0.865169_g22413_i0	PRJNA751877	22535	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	111	5.74e-28	NR	HYF48200.1	2026780	g22413	i0	58	1.87649402390438	81	34	96.8	0	3	245	162	242	HYF48200.1 phytanoyl-CoA dioxygenase family protein [Planctomycetota bacterium]	diamond	471	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31579847	31579847	PRJNA751877_P_NODE_25496_length_247_cov_0.885057_g25374_i0	PRJNA751877	25496	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	42.4	0.0175	NR	WP_162669483.1	1210884	g25374	i0	44.2	1.84615384615385	43	24	52.2	0	2	130	69	111	WP_162669483.1 hypothetical protein [Gemmata massiliana]	diamond	456	42.7	0.992974238875878	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
31854358	31854358	PRJNA751877_P_NODE_17777_length_279_cov_1.495146_g17655_i0	PRJNA751877	17777	279	1.495146	4.17145734	Gemmataceae bacterium	2052164	Bacteria	Bacteria	118	1.93e-29	NR	MFQ3648825.1	2052164	g17655	i0	63.4	1	93	33	98.9	1	277	2	255	347	MFQ3648825.1 ROK family transcriptional regulator [Gemmataceae bacterium]	diamond	279	118	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32329369	32329369	PRJNA751877_P_NODE_21279_length_257_cov_1.255435_g21157_i0	PRJNA751877	21279	257	1.255435	3.22646795	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	187	1.8299999999999994e-55	NR	HCP12131.1	2026779	g21157	i0	100	0.992217898832685	85	0	99.2	0	2	256	145	229	HCP12131.1 membrane-bound O-acyltransferase family protein [Planctomycetaceae bacterium]	diamond	255	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32392322	32392322	PRJNA751877_P_NODE_17739_length_280_cov_1.000000_g17617_i0	PRJNA751877	17739	280	1	2.8	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	44.7	0.0112	NR	HQX51038.1	2026779	g17617	i0	36.1	0.771428571428571	72	45	77.1	1	242	27	64	134	HQX51038.1 branched-chain amino acid ABC transporter permease [Planctomycetaceae bacterium]	diamond	216	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;