metadata: contig_metadata: 7 rows where bioproject = "PRJNA1253303", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA1253303", 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
359348	359348	PRJNA1253303_P_NODE_4941_length_253_cov_0.866667_g4919_i0	PRJNA1253303	4941	253	0.866667	2.19266751	Singulisphaera sp.	1906241	Bacteria	Bacteria	154	4.87e-43	NR	MEJ7639405.1	1906241	g4919	i0	97.6	0.984189723320158	83	2	98.4	0	3	251	118	200	MEJ7639405.1 serine/threonine-protein kinase [Singulisphaera sp.]	diamond	249	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp.
6737223	6737223	PRJNA1253303_P_NODE_6246_length_249_cov_0.886364_g6224_i0	PRJNA1253303	6246	249	0.886364	2.20704636	Phycisphaerae	666505	Bacteria	Bacteria	123	1.05e-31	NR	MDB5319606.1	2052180	g6224	i0	76.3	2.91566265060241	80	19	96.4	0	243	4	197	276	MDB5319606.1 Beta-hexosaminidase [Phycisphaerales bacterium]	diamond	726	124	0.991935483870968	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
6737269	6737269	PRJNA1253303_P_NODE_8186_length_243_cov_0.917647_g8164_i0	PRJNA1253303	8186	243	0.917647	2.22988221	Aquisphaera giovannonii	406548	Bacteria	Bacteria	261	3.34e-65	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g8164	i0	86.066	82.5390946502058	244	32	100	2	1	243	3440678	3440436	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	20057	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
24585773	24585773	PRJNA1253303_P_NODE_5660_length_251_cov_0.876404_g5638_i0	PRJNA1253303	5660	251	0.876404	2.19977404	Humisphaera borealis	2807512	Bacteria	Bacteria	172	1.67e-38	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g5638	i0	79.92	1.53386454183267	249	39	96	9	7	248	3783164	3783408	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	385	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
26693874	26693874	PRJNA1253303_P_NODE_1101_length_467_cov_0.791878_g1079_i0	PRJNA1253303	1101	467	0.791878	3.69807026	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	124	1.45e-29	NR	HMN42288.1	2052180	g1079	i0	53.8	1.36188436830835	106	49	68.1	0	466	149	1351	1456	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	636	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31496107	31496107	PRJNA1253303_P_NODE_6036_length_250_cov_0.881356_g6014_i0	PRJNA1253303	6036	250	0.881356	2.20339	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	134	1.2499999999999999e-34	NR	MDB5322919.1	2052180	g6014	i0	75.9	3.912	83	16	99.6	1	1	249	322	400	MDB5322919.1 S-methyl-5-thioadenosine phosphorylase [Phycisphaerales bacterium]	diamond	978	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32571779	32571779	PRJNA1253303_P_NODE_8339_length_242_cov_0.923077_g8317_i0	PRJNA1253303	8339	242	0.923077	2.23384634	Gemmataceae bacterium	2052164	Bacteria	Bacteria	119	3.84e-30	NR	HKI31433.1	2052164	g8317	i0	67.1	1.95867768595041	79	26	97.9	0	238	2	59	137	HKI31433.1 glycosyltransferase family 4 protein [Gemmataceae bacterium]	diamond	474	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;