metadata: contig_metadata: 11 rows where bioproject = "PRJNA446034" and tax

11 rows where bioproject = "PRJNA446034" 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
18943474	18943474	PRJNA446034_S_NODE_74575_length_167_cov_1.638462_g74538_i0	PRJNA446034	74575	167	1.638462	2.73623154	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	89	6.89e-19	NR	MDA1273307.1	2026799	g74538	i0	81.8	0.988023952095808	55	10	98.8	0	165	1	366	420	MDA1273307.1 DUF1549 domain-containing protein [Verrucomicrobiota bacterium]	diamond	165	89	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27044434	27044434	PRJNA446034_S_NODE_45222_length_188_cov_1.695364_g45185_i0	PRJNA446034	45222	188	1.695364	3.18728432	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	73.6	2.4e-13	NR	MES2470011.1	2026799	g45185	i0	87.5	0.638297872340426	40	5	63.8	0	176	57	458	497	MES2470011.1 sigma-70 family RNA polymerase sigma factor [Verrucomicrobiota bacterium]	diamond	120	73.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27107434	27107434	PRJNA446034_S_NODE_113702_length_150_cov_7.672566_g113665_i0	PRJNA446034	113702	150	7.672566	11.508849	Candidatus Brocadiales bacterium	2760054	Bacteria	Bacteria	50.1	2.04e-5	NR	MBC8555558.1	2760054	g113665	i0	51	0.98	49	24	98	0	147	1	1	49	MBC8555558.1 hypothetical protein [Candidatus Brocadiales bacterium]	diamond	147	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales			Candidatus Brocadiales bacterium
28307830	28307830	PRJNA446034_S_NODE_54086_length_180_cov_3.433566_g54049_i0	PRJNA446034	54086	180	3.433566	6.1804188	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	67.4	3.05e-11	NR	MES2983521.1	2026799	g54049	i0	69	0.7	42	13	70	0	54	179	1	42	MES2983521.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	126	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29428898	29428898	PRJNA446034_S_NODE_69269_length_170_cov_1.654135_g69232_i0	PRJNA446034	69269	170	1.654135	2.8120295	Roseimaritima	1579506	Bacteria	Bacteria	42.4	0.0195	NR	WP_068140707.1	980254	g69232	i0	48.6	1.23529411764706	35	18	61.8	0	6	110	992	1026	WP_068140707.1 S1 RNA-binding domain-containing protein [Roseimaritima ulvae]	diamond	210	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
29791568	29791568	PRJNA446034_S_NODE_91991_length_158_cov_5.917355_g91954_i0	PRJNA446034	91991	158	5.917355	9.3494209	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0212	NR	MDP6761505.1	2026780	g91954	i0	47.7	1.59493670886076	44	22	81.6	1	22	150	100	143	MDP6761505.1 UDP-2,3-diacylglucosamine diphosphatase [Planctomycetota bacterium]	diamond	252	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30044357	30044357	PRJNA446034_S_NODE_70551_length_169_cov_2.825758_g70514_i0	PRJNA446034	70551	169	2.825758	4.77553102	Chlamydia psittaci	83554	Bacteria	Bacteria	53.5	8.4e-8	NR	EPP28881.1	1112246	g70514	i0	61	0.727810650887574	41	16	72.8	0	126	4	16	56	EPP28881.1 hypothetical protein CP082626L3_1682, partial [Chlamydia psittaci 08-2626_L3]	diamond	123	53.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
30345616	30345616	PRJNA446034_S_NODE_43172_length_190_cov_1.882353_g43135_i0	PRJNA446034	43172	190	1.882353	3.5764707	Anatilimnocola	2807414	Bacteria	Bacteria	68.6	1.92e-12	NR	MBI2477508.1	2052181	g43135	i0	68.2	6.25263157894737	44	14	69.5	0	190	59	131	174	MBI2477508.1 RNA polymerase sigma factor [Planctomycetia bacterium]	diamond	1188	68.9	0.995645863570392	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30992397	30992397	PRJNA446034_S_NODE_37834_length_196_cov_1.352201_g37797_i0	PRJNA446034	37834	196	1.352201	2.65031396	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	77	1.66e-14	NR	MBQ1456580.1	2691551	g37797	i0	54.8	0.948979591836735	62	28	94.9	0	4	189	41	102	MBQ1456580.1 DNA adenine methylase [Thermoguttaceae bacterium]	diamond	186	77	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
31940803	31940803	PRJNA446034_S_NODE_88737_length_160_cov_1.869919_g88700_i0	PRJNA446034	88737	160	1.869919	2.9918704	Prosthecobacter sp.	1965333	Bacteria	Bacteria	67	3.74e-12	NR	WP_300195712.1	1965333	g88700	i0	69.4	1.8375	49	15	91.9	0	13	159	1	49	WP_300195712.1 hypothetical protein [Prosthecobacter sp.]	diamond	294	67	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32162605	32162605	PRJNA446034_S_NODE_47018_length_186_cov_3.241611_g46981_i0	PRJNA446034	47018	186	3.241611	6.02939646	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0333	NR	MEL7089525.1	2026780	g46981	i0	41.7	0.774193548387097	48	26	74.2	1	7	144	68	115	MEL7089525.1 DNA-processing protein DprA [Planctomycetota bacterium]	diamond	144	42	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);;