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

12 rows where bioproject = "PRJNA1186363", 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
319684	319684	PRJNA1186363_P_NODE_10081_length_653_cov_1.068966_g9204_i0	PRJNA1186363	10081	653	1.068966	6.98034798	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g9204	i0	100	0.973966309341501	31	0	5	0	351	381	1928298	1928268	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	636	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
319863	319863	PRJNA1186363_P_NODE_3561_length_1099_cov_3.621832_g3038_i0	PRJNA1186363	3561	1099	3.621832	39.80393368	Stieleria neptunia	2527979	Bacteria	Bacteria	56.5	0.009	NTclustered	gi\|1712721777\|gb\|CP037423.1\|	2527979	g3038	i0	100	0.0272975432211101	30	0	3	0	719	748	10851789	10851760	Stieleria neptunia strain Enr13 chromosome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria neptunia
9247749	9247749	PRJNA1186363_P_NODE_43928_length_242_cov_0.923077_g43040_i0	PRJNA1186363	43928	242	0.923077	2.23384634	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g43040	i0	100	0.582644628099174	29	0	12	0	202	230	2534415	2534443	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	141	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
16896867	16896867	PRJNA1186363_P_NODE_26434_length_349_cov_1.130435_g25546_i0	PRJNA1186363	26434	349	1.130435	3.94521815	Bacteria	2	Bacteria	Bacteria	106	2.22e-24	NR	MBY0230280.1	2052164	g25546	i0	48.3	2.810888252149	116	59	99.7	1	348	1	274	388	MBY0230280.1 serpin family protein [Gemmataceae bacterium]	diamond	981	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29251045	29251045	PRJNA1186363_P_NODE_22389_length_393_cov_0.878125_g21501_i0	PRJNA1186363	22389	393	0.878125	3.45103125	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	65.5	4.04e-10	NR	HIB69548.1	2052180	g21501	i0	51.9	0.412213740458015	54	26	41.2	0	1	162	8	61	HIB69548.1 hypothetical protein [Phycisphaerales bacterium]	diamond	162	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30122847	30122847	PRJNA1186363_P_NODE_42452_length_245_cov_0.906977_g41564_i0	PRJNA1186363	42452	245	0.906977	2.22209365	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	1.52e-5	NR	HKB05582.1	2052164	g41564	i0	44.3	3.55102040816327	70	35	83.3	3	209	6	93	160	HKB05582.1 hypothetical protein [Gemmataceae bacterium]	diamond	870	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30154310	30154310	PRJNA1186363_P_NODE_43312_length_243_cov_0.917647_g42424_i0	PRJNA1186363	43312	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	129	2.27e-33	NR	KPL25334.1	1703410	g42424	i0	75.3	16	81	20	100	0	1	243	285	365	KPL25334.1 MAG: 6-phosphogluconate dehydrogenase [Phycisphaerae bacterium SM1_79]	diamond	3888	130	0.992307692307692	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium SM1_79
30546247	30546247	PRJNA1186363_P_NODE_38613_length_253_cov_0.866667_g37725_i0	PRJNA1186363	38613	253	0.866667	2.19266751	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	55.5	1.38e-6	NR	MFP6764498.1	2026779	g37725	i0	44.7	0.901185770750988	76	35	88.9	2	9	233	189	258	MFP6764498.1 Calx-beta domain-containing protein [Planctomycetaceae bacterium]	diamond	228	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30830492	30830492	PRJNA1186363_P_NODE_17294_length_466_cov_1.353690_g16407_i0	PRJNA1186363	17294	466	1.35369	6.3081954	Candidatus Scalindua sp.	2268189	Bacteria	Bacteria	69.7	8.23e-11	NR	MBT3880675.1	2268189	g16407	i0	53.7	0.347639484978541	54	25	34.8	0	2	163	241	294	MBT3880675.1 dihydrodipicolinate synthase family protein [Candidatus Scalindua sp.]	diamond	162	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sp.
31052058	31052058	PRJNA1186363_P_NODE_41055_length_248_cov_0.891429_g40167_i0	PRJNA1186363	41055	248	0.891429	2.21074392	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	150	5.93e-43	NR	MCC6581972.1	2026777	g40167	i0	81.7	0.991935483870968	82	15	99.2	0	2	247	149	230	MCC6581972.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	246	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31431070	31431070	PRJNA1186363_P_NODE_24516_length_369_cov_1.054054_g23628_i0	PRJNA1186363	24516	369	1.054054	3.88945926	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.1	0.0248	NR	MCH8967560.1	2026780	g23628	i0	40.5	1.61788617886179	79	36	56.1	5	4	210	642	719	MCH8967560.1 FG-GAP repeat protein [Planctomycetota bacterium]	diamond	597	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32348816	32348816	PRJNA1186363_P_NODE_28979_length_325_cov_1.912698_g28091_i0	PRJNA1186363	28979	325	1.912698	6.2162685	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.1	1.03e-6	NR	MEY4774332.1	2026780	g28091	i0	34.4	0.886153846153846	96	55	88.6	2	31	318	1	88	MEY4774332.1 hypothetical protein [Planctomycetota bacterium]	diamond	288	55.1	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);;