metadata: contig_metadata: 8 rows where bioproject = "PRJNA983838", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA983838", 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
7649378	7649378	PRJNA983838_P_NODE_118326_length_242_cov_1.597633_g115959_i0	PRJNA983838	118326	242	1.597633	3.86627186	Planctomycetia	203683	Bacteria	Bacteria	387	5.26e-103	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g115959	i0	95.473	223.268595041322	243	9	100	2	1	242	122392	122633	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	54031	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
12443747	12443747	PRJNA983838_P_NODE_104370_length_253_cov_0.866667_g102003_i0	PRJNA983838	104370	253	0.866667	2.19266751	Gemmataceae bacterium	2052164	Bacteria	Bacteria	172	1.8099999999999994e-48	NR	MBX9626678.1	2052164	g102003	i0	100	0.99604743083004	84	0	99.6	0	1	252	93	176	MBX9626678.1 HDOD domain-containing protein [Gemmataceae bacterium]	diamond	252	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
17543419	17543419	PRJNA983838_P_NODE_66254_length_344_cov_3.324723_g63887_i0	PRJNA983838	66254	344	3.324723	11.43704712	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	387	7.849999999999998e-103	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g63887	i0	87.834	162.607558139535	337	32	96	7	1	329	7050921	7050586	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	55937	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21673701	21673701	PRJNA983838_P_NODE_118937_length_242_cov_0.923077_g116570_i0	PRJNA983838	118937	242	0.923077	2.23384634	Gemmataceae bacterium	2052164	Bacteria	Bacteria	147	4.24e-39	NR	MSR54156.1	2052164	g116570	i0	88.8	2.97520661157025	80	9	99.2	0	240	1	278	357	MSR54156.1 aconitate hydratase AcnA [Gemmataceae bacterium]	diamond	720	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30253784	30253784	PRJNA983838_P_NODE_85772_length_286_cov_2.159624_g83405_i0	PRJNA983838	85772	286	2.159624	6.17652464	Bacteria	2	Bacteria	Bacteria	111	5.880000000000001e-27	NR	MEM6568911.1	2026780	g83405	i0	54.7	14.8216783216783	95	43	99.7	0	285	1	211	305	MEM6568911.1 alkene reductase [Planctomycetota bacterium]	diamond	4239	112	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30753058	30753058	PRJNA983838_P_NODE_48354_length_443_cov_2.532432_g45988_i0	PRJNA983838	48354	443	2.532432	11.21867376	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	120	1.51e-28	NR	MCP4096080.1	2026779	g45988	i0	46.3	0.920993227990971	136	70	90.7	3	442	41	366	500	MCP4096080.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	408	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31005787	31005787	PRJNA983838_P_NODE_95314_length_268_cov_1.405128_g92947_i0	PRJNA983838	95314	268	1.405128	3.76574304	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0193	NR	MBN8643811.1	2026780	g92947	i0	32.3	0.694029850746269	62	40	69.4	1	5	190	283	342	MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium]	diamond	186	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32681392	32681392	PRJNA983838_P_NODE_119460_length_241_cov_2.363095_g117093_i0	PRJNA983838	119460	241	2.363095	5.69505895	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47	0.00111	NR	HMN94906.1	2052180	g117093	i0	41.2	0.634854771784232	51	29	62.2	1	66	215	13	63	HMN94906.1 ABC transporter permease [Phycisphaerales bacterium]	diamond	153	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;