metadata: contig_metadata: 20 rows where bioproject = "PRJNA688414", tax_clade = "PVC group" and tax

20 rows where bioproject = "PRJNA688414", 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
4495015	4495015	PRJNA688414_P_NODE_8244_length_242_cov_0.923077_g8210_i0	PRJNA688414	8244	242	0.923077	2.23384634	Gemmataceae bacterium	2052164	Bacteria	Bacteria	102	4.36e-24	NR	HZY90660.1	2052164	g8210	i0	60	3.95454545454545	80	32	99.2	0	242	3	196	275	HZY90660.1 hypothetical protein [Gemmataceae bacterium]	diamond	957	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
13420990	13420990	PRJNA688414_P_NODE_8151_length_243_cov_0.917647_g8117_i0	PRJNA688414	8151	243	0.917647	2.22988221	Planctomycetota bacterium	2026780	Bacteria	Bacteria	94.7	1.37e-23	NR	MEI7687657.1	2026780	g8117	i0	72.9	0.728395061728395	59	16	72.8	0	243	67	6	64	MEI7687657.1 hypothetical protein [Planctomycetota bacterium]	diamond	177	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
19793977	19793977	PRJNA688414_P_NODE_7696_length_245_cov_0.906977_g7662_i0	PRJNA688414	7696	245	0.906977	2.22209365	Singulisphaera acidiphila	466153	Bacteria	Bacteria	84.2	7.84e-12	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g7662	i0	89.394	0.269387755102041	66	7	27	0	58	123	9502867	9502802	Singulisphaera acidiphila DSM 18658, complete genome	blastn	66	84.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
23619895	23619895	PRJNA688414_P_NODE_8339_length_242_cov_0.923077_g8305_i0	PRJNA688414	8339	242	0.923077	2.23384634	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	161	7.22e-46	NR	MDB5338058.1	2026779	g8305	i0	91.3	0.991735537190083	80	7	99.2	0	2	241	38	117	MDB5338058.1 glucose-phosphate adenylyltransferase [Planctomycetaceae bacterium]	diamond	240	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26892613	26892613	PRJNA688414_P_NODE_6161_length_252_cov_0.871508_g6127_i0	PRJNA688414	6161	252	0.871508	2.19620016	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0156	NR	MFV1959459.1	2026780	g6127	i0	39.3	0.726190476190476	61	28	61.9	1	250	95	9	69	MFV1959459.1 hypothetical protein [Planctomycetota bacterium]	diamond	183	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27050705	27050705	PRJNA688414_P_NODE_6422_length_251_cov_0.876404_g6388_i0	PRJNA688414	6422	251	0.876404	2.19977404	Planctomycetota bacterium	2026780	Bacteria	Bacteria	67	9.83e-12	NR	HZN40169.1	2026780	g6388	i0	42.5	2.84462151394422	87	46	99.2	1	251	3	57	143	HZN40169.1 hypothetical protein [Planctomycetota bacterium]	diamond	714	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27113657	27113657	PRJNA688414_P_NODE_6782_length_249_cov_0.886364_g6748_i0	PRJNA688414	6782	249	0.886364	2.20704636	Gemmataceae bacterium	2052164	Bacteria	Bacteria	48.1	3.52e-4	NR	HEY7425662.1	2052164	g6748	i0	41.2	1.91566265060241	85	40	90.4	4	238	14	128	212	HEY7425662.1 hypothetical protein [Gemmataceae bacterium]	diamond	477	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27966567	27966567	PRJNA688414_P_NODE_7045_length_248_cov_0.891429_g7011_i0	PRJNA688414	7045	248	0.891429	2.21074392	Planctomycetales bacterium	2053591	Bacteria	Bacteria	100	2.55e-22	NR	MBI5757139.1	2053591	g7011	i0	83.6	0.737903225806452	61	10	73.8	0	183	1	1	61	MBI5757139.1 methyl-accepting chemotaxis protein [Planctomycetales bacterium]	diamond	183	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
28061281	28061281	PRJNA688414_P_NODE_8045_length_243_cov_0.917647_g8011_i0	PRJNA688414	8045	243	0.917647	2.22988221	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	128	2.07e-35	NR	HMB07825.1	2691532	g8011	i0	90.9	0.814814814814815	66	6	81.5	0	200	3	1	66	HMB07825.1 FHA domain-containing protein [Isosphaeraceae bacterium]	diamond	198	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28124561	28124561	PRJNA688414_P_NODE_7185_length_247_cov_0.896552_g7151_i0	PRJNA688414	7185	247	0.896552	2.21448344	Planctomycetota bacterium	2026780	Bacteria	Bacteria	91.7	2.33e-19	NR	HYG77527.1	2026780	g7151	i0	46.9	1.16599190283401	96	36	98.4	1	245	3	323	418	HYG77527.1 redoxin domain-containing protein [Planctomycetota bacterium]	diamond	288	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28862133	28862133	PRJNA688414_P_NODE_7768_length_245_cov_0.877907_g7734_i0	PRJNA688414	7768	245	0.877907	2.15087215	Planctomycetia	203683	Bacteria	Bacteria	118	1.11e-28	NR	MBC7817684.1	2026779	g7734	i0	66.3	4.88571428571429	80	27	98	0	240	1	503	582	MBC7817684.1 DUF1549 domain-containing protein [Planctomycetaceae bacterium]	diamond	1197	119	0.991596638655462	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28882197	28882197	PRJNA688414_P_NODE_6848_length_249_cov_0.886364_g6814_i0	PRJNA688414	6848	249	0.886364	2.20704636	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	99	6.5e-22	NR	GIW87159.1	2691532	g6814	i0	55.4	1	83	37	100	0	249	1	161	243	GIW87159.1 MAG: glucose dehydrogenase [Isosphaeraceae bacterium]	diamond	249	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28882199	28882199	PRJNA688414_P_NODE_7508_length_246_cov_0.901734_g7474_i0	PRJNA688414	7508	246	0.901734	2.21826564	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	73.6	5.45e-13	NR	NND97431.1	2699754	g7474	i0	50.6	0.963414634146341	79	35	96.3	1	238	2	343	417	NND97431.1 cadherin-like domain-containing protein [Pirellulaceae bacterium]	diamond	237	73.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29418917	29418917	PRJNA688414_P_NODE_7529_length_246_cov_0.901734_g7495_i0	PRJNA688414	7529	246	0.901734	2.21826564	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	166	5.829999999999999e-46	NR	HJQ81629.1	2691534	g7495	i0	98.8	0.98780487804878	81	1	98.8	0	3	245	609	689	HJQ81629.1 HDIG domain-containing protein [Lacipirellulaceae bacterium]	diamond	243	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
29671270	29671270	PRJNA688414_P_NODE_8350_length_242_cov_0.923077_g8316_i0	PRJNA688414	8350	242	0.923077	2.23384634	Pirellulales bacterium	2715253	Bacteria	Bacteria	61.2	1.1e-8	NR	HJT32413.1	2715253	g8316	i0	47.5	0.991735537190083	80	33	89.3	4	237	22	489	567	HJT32413.1 cytochrome c3 family protein [Pirellulales bacterium]	diamond	240	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29924389	29924389	PRJNA688414_P_NODE_6031_length_253_cov_0.866667_g5997_i0	PRJNA688414	6031	253	0.866667	2.19266751	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	125	2.68e-33	NR	MFM9995621.1	2052180	g5997	i0	71.1	0.984189723320158	83	24	98.4	0	251	3	162	244	MFM9995621.1 sugar phosphate isomerase/epimerase family protein [Phycisphaerales bacterium]	diamond	249	125	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30113749	30113749	PRJNA688414_P_NODE_7392_length_246_cov_0.901734_g7358_i0	PRJNA688414	7392	246	0.901734	2.21826564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	86.7	5.34e-19	NR	HVQ25817.1	2026780	g7358	i0	66.2	0.792682926829268	65	22	79.3	0	239	45	125	189	HVQ25817.1 hypothetical protein [Planctomycetota bacterium]	diamond	195	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30430168	30430168	PRJNA688414_P_NODE_7833_length_244_cov_0.912281_g7799_i0	PRJNA688414	7833	244	0.912281	2.22596564	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	113	4.660000000000001e-27	NR	HEV2296258.1	2876886	g7799	i0	67.9	0.995901639344262	81	26	99.6	0	244	2	710	790	HEV2296258.1 TAT-variant-translocated molybdopterin oxidoreductase [Tepidisphaeraceae bacterium]	diamond	243	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30714104	30714104	PRJNA688414_P_NODE_8034_length_243_cov_0.917647_g8000_i0	PRJNA688414	8034	243	0.917647	2.22988221	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	152	5.93e-43	NR	HEV2293130.1	2876886	g8000	i0	88.8	5.92592592592593	80	9	98.8	0	241	2	228	307	HEV2293130.1 aminopeptidase [Tepidisphaeraceae bacterium]	diamond	1440	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31820524	31820524	PRJNA688414_P_NODE_6357_length_251_cov_0.876404_g6323_i0	PRJNA688414	6357	251	0.876404	2.19977404	Planctomycetota bacterium	2026780	Bacteria	Bacteria	86.3	5.18e-19	NR	HVR75145.1	2026780	g6323	i0	70	0.717131474103586	60	18	71.7	0	67	246	1	60	HVR75145.1 molybdenum cofactor biosynthesis protein B [Planctomycetota bacterium]	diamond	180	86.3	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);;