metadata: contig_metadata: 15 rows where bioproject = "PRJNA675331" and tax

15 rows where bioproject = "PRJNA675331" 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
4475790	4475790	PRJNA675331_P_NODE_3544_length_498_cov_1.232941_g3373_i0	PRJNA675331	3544	498	1.232941	6.14004618	Aureliella sp.	2795609	Bacteria	Bacteria	455	3.1700000000000005e-123	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g3373	i0	83.399	214.574297188755	506	69	100	12	1	498	5640175	5640673	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	106858	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
6272478	6272478	PRJNA675331_P_NODE_23885_length_241_cov_0.916667_g23713_i0	PRJNA675331	23885	241	0.916667	2.20916747	Singulisphaera	466152	Bacteria	Bacteria	296	9.08e-76	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g23713	i0	90.043	181.178423236515	231	19	95	4	12	241	916	689	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	43664	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
8301078	8301078	PRJNA675331_P_NODE_15667_length_267_cov_1.190722_g15495_i0	PRJNA675331	15667	267	1.190722	3.17922774	Opitutaceae bacterium	2006848	Bacteria	Bacteria	73.6	7.3e-13	NR	MFA5264893.1	2006848	g15495	i0	52.8	1	89	31	100	4	267	1	261	338	MFA5264893.1 M4 family metallopeptidase [Opitutaceae bacterium]	diamond	267	73.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
8301118	8301118	PRJNA675331_P_NODE_23907_length_241_cov_0.916667_g23735_i0	PRJNA675331	23907	241	0.916667	2.20916747	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	322	1.5e-83	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g23735	i0	92.511	129.203319502075	227	14	93	3	1	225	4421026	4421251	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	31138	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
8301144	8301144	PRJNA675331_P_NODE_7887_length_348_cov_1.120000_g7715_i0	PRJNA675331	7887	348	1.12	3.8976	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	429	1.3e-115	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g7715	i0	89.504	110.57183908046	343	31	98	4	1	341	1844352	1844691	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	38479	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
13401879	13401879	PRJNA675331_P_NODE_7751_length_350_cov_1.357401_g7579_i0	PRJNA675331	7751	350	1.357401	4.7509035	planctomycete str. 449	79870	Bacteria	Bacteria	544	4.4699999999999996e-150	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g7579	i0	95.087	401.06	346	15	99	2	5	350	349	6	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	140371	544	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
15950446	15950446	PRJNA675331_P_NODE_11033_length_303_cov_0.934783_g10861_i0	PRJNA675331	11033	303	0.934783	2.83239249	planctomycete str. 449	79870	Bacteria	Bacteria	532	8.269999999999998e-147	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g10861	i0	98.35	137.244224422442	303	5	100	0	1	303	1051	749	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	41585	532	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
21050339	21050339	PRJNA675331_P_NODE_917_length_933_cov_1.281395_g785_i0	PRJNA675331	917	933	1.281395	11.955415350000001	Fontisphaera persica	2974023	Bacteria	Bacteria	976	0	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g785	i0	85.638	219.992497320472	940	122	99	13	3	933	3861198	3862133	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	205253	976	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
27081931	27081931	PRJNA675331_P_NODE_13542_length_279_cov_0.878641_g13370_i0	PRJNA675331	13542	279	0.878641	2.45140839	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	51.2	1.88e-5	NR	MFK7883494.1	2052180	g13370	i0	44.6	0.602150537634409	56	29	60.2	1	176	9	86	139	MFK7883494.1 CBS domain-containing protein [Phycisphaerales bacterium]	diamond	168	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27346782	27346782	PRJNA675331_P_NODE_5763_length_400_cov_0.929664_g5591_i0	PRJNA675331	5763	400	0.929664	3.718656	Bacteria	2	Bacteria	Bacteria	49.3	0.00109	NR	MCU0708535.1	117	g5591	i0	35.6	1.53	104	55	70.5	5	8	289	66	167	MCU0708535.1 hypothetical protein [Pirellula sp.]	diamond	612	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27492777	27492777	PRJNA675331_P_NODE_19263_length_249_cov_0.875000_g19091_i0	PRJNA675331	19263	249	0.875	2.17875	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	44.7	0.00812	NR	MDX1967755.1	2026779	g19091	i0	39.4	3.74698795180723	71	41	83.1	2	21	227	228	298	MDX1967755.1 protein kinase [Planctomycetaceae bacterium]	diamond	933	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27714163	27714163	PRJNA675331_P_NODE_11404_length_298_cov_2.026667_g11232_i0	PRJNA675331	11404	298	2.026667	6.03946766	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.5	5.76e-6	NR	MBX3465197.1	2026780	g11232	i0	45.5	0.553691275167785	55	28	55.4	1	94	258	38	90	MBX3465197.1 hypothetical protein [Planctomycetota bacterium]	diamond	165	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28092589	28092589	PRJNA675331_P_NODE_17065_length_257_cov_1.434783_g16893_i0	PRJNA675331	17065	257	1.434783	3.68739231	Chlamydia sp. 32-24	1895742	Bacteria	Bacteria	62.4	4.25e-9	NR	OJU80447.1	1895742	g16893	i0	37.6	3.01167315175097	85	47	99.2	1	257	3	161	239	OJU80447.1 MAG: lipase [Chlamydia sp. 32-24]	diamond	774	62.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp. 32-24
30030629	30030629	PRJNA675331_P_NODE_19951_length_248_cov_0.880000_g19779_i0	PRJNA675331	19951	248	0.88	2.1824	PVC group	1783257	Bacteria	Bacteria	98.6	1.29e-22	NR	MBA3684686.1	2026780	g19779	i0	50.6	14.7459677419355	81	38	98	1	243	1	18	96	MBA3684686.1 ribonuclease Z [Planctomycetota bacterium]	diamond	3657	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31218988	31218988	PRJNA675331_P_NODE_20055_length_248_cov_0.880000_g19883_i0	PRJNA675331	20055	248	0.88	2.1824	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	67	1.74e-11	NR	MBY0309153.1	2052180	g19883	i0	60.9	0.556451612903226	46	18	55.6	0	160	23	1	46	MBY0309153.1 hypothetical protein [Phycisphaerales bacterium]	diamond	138	67	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);;