metadata: contig_metadata: 14 rows where bioproject = "PRJEB50332", tax_clade = "PVC group" and tax

14 rows where bioproject = "PRJEB50332", 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
7771877	7771877	PRJEB50332_P_NODE_4347_length_287_cov_1.548673_g4265_i0	PRJEB50332	4347	287	1.548673	4.44469151	Humisphaera borealis	2807512	Bacteria	Bacteria	427	3.7699999999999997e-115	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g4265	i0	94.585	480.81881533101	277	13	97	1	1	277	5063276	5063550	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	137995	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
9046693	9046693	PRJEB50332_P_NODE_3208_length_324_cov_1.114068_g3126_i0	PRJEB50332	3208	324	1.114068	3.60958032	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	364	3.439999999999999e-96	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g3126	i0	87.195	44.7746913580247	328	32	100	8	1	324	1600613	1600292	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	14507	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
9046731	9046731	PRJEB50332_P_NODE_6648_length_244_cov_1.808743_g6566_i0	PRJEB50332	6648	244	1.808743	4.41333292	Urbifossiella limnaea	2528023	Bacteria	Bacteria	318	1.9699999999999998e-82	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6566	i0	93.088	3.86065573770492	217	15	89	0	6	222	5053910	5054126	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	942	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
14147821	14147821	PRJEB50332_P_NODE_6152_length_251_cov_2.421053_g6070_i0	PRJEB50332	6152	251	2.421053	6.07684303	Pseudomonadati	3379134	Bacteria	Bacteria	142	5.24e-38	NR	MEM6474261.1	2026780	g6070	i0	84.3	84.2868525896414	83	13	99.2	0	3	251	158	240	MEM6474261.1 F0F1 ATP synthase subunit beta [Planctomycetota bacterium]	diamond	21156	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
17971098	17971098	PRJEB50332_P_NODE_9835_length_225_cov_1.585366_g9753_i0	PRJEB50332	9835	225	1.585366	3.5670735	Lacipirellula parvula	2650471	Bacteria	Bacteria	302	1.8e-77	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g9753	i0	91.031	0.991111111111111	223	20	99	0	1	223	3022423	3022201	Lacipirellula parvula PX69 DNA, complete genome	blastn	223	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
18842829	18842829	PRJEB50332_P_NODE_14095_length_208_cov_1.421769_g14013_i0	PRJEB50332	14095	208	1.421769	2.95727952	Gemmatales bacterium	2838789	Bacteria	Bacteria	138	6.41e-36	NR	HMP57769.1	2838789	g14013	i0	97.1	0.995192307692308	69	2	99.5	0	1	207	448	516	HMP57769.1 DEAD/DEAH box helicase family protein [Gemmatales bacterium]	diamond	207	138	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
27760427	27760427	PRJEB50332_P_NODE_12224_length_212_cov_1.708609_g12142_i0	PRJEB50332	12224	212	1.708609	3.62225108	Planctomicrobium piriforme	1576369	Bacteria	Bacteria	141	2.3899999999999997e-37	NR	WP_092054853.1	1576369	g12142	i0	94.3	1.9811320754717	70	4	99.1	0	1	210	350	419	WP_092054853.1 M3 family oligoendopeptidase [Planctomicrobium piriforme]	diamond	420	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomicrobium	Planctomicrobium piriforme
28448211	28448211	PRJEB50332_P_NODE_17106_length_203_cov_0.915493_g17024_i0	PRJEB50332	17106	203	0.915493	1.85845079	Bacteria	2	Bacteria	Bacteria	91.7	1.29e-19	NR	WP_157732010.1	1331910	g17024	i0	65.7	18.679802955665	67	23	99	0	203	3	500	566	WP_157732010.1 apolipoprotein N-acyltransferase [Thermogutta terrifontis]	diamond	3792	92.4	0.992424242424242	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae	Thermogutta	Thermogutta terrifontis
31038178	31038178	PRJEB50332_P_NODE_2075_length_389_cov_12.222561_g1994_i0	PRJEB50332	2075	389	12.222561	47.54576229	Planctomycetota	203682	Bacteria	Bacteria	97.4	1.11e-20	NR	NUM34221.1	2517210	g1994	i0	49.1	2.62210796915167	112	47	81.7	5	5	322	396	503	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	1020	97.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
31044951	31044951	PRJEB50332_P_NODE_8995_length_230_cov_1.532544_g8913_i0	PRJEB50332	8995	230	1.532544	3.5248512	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	127	7.07e-32	NR	HYO10799.1	2876886	g8913	i0	81.6	0.991304347826087	76	14	99.1	0	3	230	355	430	HYO10799.1 DNA gyrase subunit A [Tepidisphaeraceae bacterium]	diamond	228	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31448953	31448953	PRJEB50332_P_NODE_2476_length_361_cov_1.300000_g2394_i0	PRJEB50332	2476	361	1.3	4.693	Pseudomonadati	3379134	Bacteria	Bacteria	148	2.21e-41	NR	MDX1565183.1	2026777	g2394	i0	61.1	17.9168975069252	113	44	93.9	0	350	12	9	121	MDX1565183.1 aldolase/citrate lyase family protein [Phycisphaeraceae bacterium]	diamond	6468	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31487448	31487448	PRJEB50332_P_NODE_13496_length_209_cov_1.756757_g13414_i0	PRJEB50332	13496	209	1.756757	3.67162213	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	69.7	2.61e-13	NR	MBN1941883.1	2026778	g13414	i0	47.8	1.92344497607656	67	35	96.2	0	9	209	14	80	MBN1941883.1 STAS/SEC14 domain-containing protein [Phycisphaerae bacterium]	diamond	402	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32278331	32278331	PRJEB50332_P_NODE_3419_length_315_cov_1.228346_g3337_i0	PRJEB50332	3419	315	1.228346	3.8692899	Gemmataceae bacterium	2052164	Bacteria	Bacteria	74.7	8.3e-15	NR	MCI0458813.1	2052164	g3337	i0	49.3	3.1047619047619	67	34	63.8	0	4	204	29	95	MCI0458813.1 hypothetical protein [Gemmataceae bacterium]	diamond	978	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32563147	32563147	PRJEB50332_P_NODE_12559_length_211_cov_0.866667_g12477_i0	PRJEB50332	12559	211	0.866667	1.82866737	Planctomycetia bacterium	2052181	Bacteria	Bacteria	60.5	5.25e-9	NR	MCI0700422.1	2052181	g12477	i0	70.5	0.625592417061611	44	13	62.6	0	132	1	98	141	MCI0700422.1 SHOCT domain-containing protein [Planctomycetia bacterium]	diamond	132	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;