metadata: contig_metadata: 23 rows where bioproject = "PRJNA407886", tax_clade = "PVC group" and tax

23 rows where bioproject = "PRJNA407886", 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
1692984	1692984	PRJNA407886_P_NODE_78402_length_244_cov_0.900585_g76708_i0	PRJNA407886	78402	244	0.900585	2.1974274	Bremerella sp. TYQ1	3119568	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2101355205\|gb\|CP083740.1\|	3119568	g76708	i0	100	0.114754098360656	28	0	11	0	70	97	4409419	4409392	Bremerella sp. TYQ1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. TYQ1
9345938	9345938	PRJNA407886_P_NODE_61888_length_269_cov_1.882653_g60194_i0	PRJNA407886	61888	269	1.882653	5.06433657	Planctomycetota	203682	Bacteria	Bacteria	129	5.64e-33	NR	WP_145099505.1	2528021	g60194	i0	65.9	7.87360594795539	88	30	98.1	0	267	4	409	496	WP_145099505.1 phosphoenolpyruvate carboxykinase (ATP) [Anatilimnocola aggregata]	diamond	2118	130	0.992307692307692	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
10010224	10010224	PRJNA407886_P_NODE_39508_length_349_cov_1.666667_g37814_i0	PRJNA407886	39508	349	1.666667	5.81666783	PVC group	1783257	Bacteria	Bacteria	157	1.0399999999999997e-42	NR	MBM4038248.1	2026780	g37814	i0	65.8	4.84813753581662	114	39	98	0	8	349	177	290	MBM4038248.1 hydroxylamine reductase [Planctomycetota bacterium]	diamond	1692	157	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
19543085	19543085	PRJNA407886_P_NODE_37096_length_363_cov_1.544828_g35402_i0	PRJNA407886	37096	363	1.544828	5.60772564	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	392	1.7899999999999994e-104	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g35402	i0	86.798	64.3085399449036	356	41	98	6	1	355	1831195	1831545	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	23344	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
19543919	19543919	PRJNA407886_P_NODE_78716_length_243_cov_1.617647_g77022_i0	PRJNA407886	78716	243	1.617647	3.93088221	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	388	1.47e-103	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g77022	i0	95.851	60.9753086419753	241	9	99	1	1	241	1831841	1832080	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	14817	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
22093493	22093493	PRJNA407886_P_NODE_24978_length_479_cov_3.012315_g23287_i0	PRJNA407886	24978	479	3.012315	14.42898885	Aureliella helgolandensis	2527968	Bacteria	Bacteria	62.1	7.75e-5	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g23287	i0	89.796	14.713987473904	49	3	10	2	394	441	1752856	1752903	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	7048	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
22093833	22093833	PRJNA407886_P_NODE_41698_length_338_cov_1.147170_g40004_i0	PRJNA407886	41698	338	1.14717	3.8774346	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	166	2.32e-46	NR	MEX2218370.1	2052180	g40004	i0	75.9	5.77810650887574	108	26	95.9	0	15	338	241	348	MEX2218370.1 isocitrate/isopropylmalate family dehydrogenase [Phycisphaerales bacterium]	diamond	1953	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26980521	26980521	PRJNA407886_P_NODE_57942_length_280_cov_1.405797_g56248_i0	PRJNA407886	57942	280	1.405797	3.9362316	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	69.3	6.31e-12	NR	HTI52094.1	2026779	g56248	i0	37.8	2.91428571428571	90	56	96.4	0	276	7	107	196	HTI52094.1 50S ribosomal protein L4 [Planctomycetaceae bacterium]	diamond	816	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26980527	26980527	PRJNA407886_P_NODE_65202_length_261_cov_1.579787_g63508_i0	PRJNA407886	65202	261	1.579787	4.12324407	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	110	6.57e-29	NR	MBE2293297.1	2052180	g63508	i0	70.1	4.49425287356322	77	23	88.5	0	29	259	3	79	MBE2293297.1 group 1 truncated hemoglobin [Phycisphaerales bacterium]	diamond	1173	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27170105	27170105	PRJNA407886_P_NODE_70382_length_250_cov_3.073446_g68688_i0	PRJNA407886	70382	250	3.073446	7.683615	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.6	3.24e-11	NR	MFM2095940.1	2026780	g68688	i0	43.8	3.828	80	45	96	0	249	10	58	137	MFM2095940.1 hypothetical protein [Planctomycetota bacterium]	diamond	957	68.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27328502	27328502	PRJNA407886_P_NODE_65663_length_260_cov_1.491979_g63969_i0	PRJNA407886	65663	260	1.491979	3.8791454	Planctomycetota bacterium	2026780	Bacteria	Bacteria	92	2.11e-19	NR	MBN8597640.1	2026780	g63969	i0	60.5	2.85	81	32	93.5	0	260	18	594	674	MBN8597640.1 alanine--tRNA ligase [Planctomycetota bacterium]	diamond	741	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27580959	27580959	PRJNA407886_P_NODE_78524_length_243_cov_2.617647_g76830_i0	PRJNA407886	78524	243	2.617647	6.36088221	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0192	NR	MBN1420393.1	2026780	g76830	i0	41.7	0.888888888888889	72	39	85.2	1	32	238	184	255	MBN1420393.1 O-antigen ligase family protein [Planctomycetota bacterium]	diamond	216	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27928364	27928364	PRJNA407886_P_NODE_78165_length_244_cov_0.900585_g76471_i0	PRJNA407886	78165	244	0.900585	2.1974274	Gemmataceae bacterium	2052164	Bacteria	Bacteria	46.2	0.00126	NR	MCS7272507.1	2052164	g76471	i0	41.3	1.84426229508197	75	35	88.5	2	24	239	51	119	MCS7272507.1 hypothetical protein [Gemmataceae bacterium]	diamond	450	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28054552	28054552	PRJNA407886_P_NODE_79445_length_243_cov_0.905882_g77751_i0	PRJNA407886	79445	243	0.905882	2.20129326	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	50.8	5.24e-5	NR	HMN96102.1	2052180	g77751	i0	40	0.802469135802469	65	38	79	1	9	200	1070	1134	HMN96102.1 protein kinase [Phycisphaerales bacterium]	diamond	195	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28370322	28370322	PRJNA407886_P_NODE_61666_length_270_cov_1.390863_g59972_i0	PRJNA407886	61666	270	1.390863	3.7553301	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0199	NR	MFM7844258.1	2026780	g59972	i0	47.4	0.422222222222222	38	16	42.2	1	136	249	41	74	MFM7844258.1 prepilin peptidase [Planctomycetota bacterium]	diamond	114	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28875523	28875523	PRJNA407886_P_NODE_27308_length_447_cov_1.302139_g25615_i0	PRJNA407886	27308	447	1.302139	5.82056133	Pirellula sp.	117	Bacteria	Bacteria	73.2	7.65e-12	NR	MFM7931657.1	117	g25615	i0	41.3	2.53691275167785	126	69	83.2	3	415	44	14	136	MFM7931657.1 SdrD B-like domain-containing protein [Pirellula sp.]	diamond	1134	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
30660877	30660877	PRJNA407886_P_NODE_57993_length_280_cov_1.212560_g56299_i0	PRJNA407886	57993	280	1.21256	3.395168	Bacteria	2	Bacteria	Bacteria	55.8	1.5e-6	NR	HLX63125.1	2026780	g56299	i0	35.1	4.66071428571429	94	60	99.6	1	280	2	647	740	HLX63125.1 hypothetical protein [Planctomycetota bacterium]	diamond	1305	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30897192	30897192	PRJNA407886_P_NODE_81054_length_241_cov_1.821429_g79360_i0	PRJNA407886	81054	241	1.821429	4.38964389	Pirellulales bacterium	2715253	Bacteria	Bacteria	67	1.05e-10	NR	HEX7376146.1	2715253	g79360	i0	50	5.66390041493776	74	36	90.9	1	226	8	1022	1095	HEX7376146.1 Ig-like domain-containing protein [Pirellulales bacterium]	diamond	1365	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31292809	31292809	PRJNA407886_P_NODE_64215_length_263_cov_2.178947_g62521_i0	PRJNA407886	64215	263	2.178947	5.73063061	Bacteria	2	Bacteria	Bacteria	135	1.6399999999999999e-34	NR	MEP3480275.1	1936112	g62521	i0	77	52.5969581749049	87	20	99.2	0	262	2	566	652	MEP3480275.1 aminomethyl-transferring glycine dehydrogenase [Fuerstiella sp.]	diamond	13833	136	0.992647058823529	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
31940262	31940262	PRJNA407886_P_NODE_29457_length_423_cov_2.182857_g27764_i0	PRJNA407886	29457	423	2.182857	9.23348511	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	189	2.27e-56	NR	MBQ4142302.1	2691551	g27764	i0	78.6	16.6808510638298	112	24	79.4	0	86	421	92	203	MBQ4142302.1 phosphoenolpyruvate carboxykinase (ATP) [Thermoguttaceae bacterium]	diamond	7056	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
32035347	32035347	PRJNA407886_P_NODE_19578_length_580_cov_2.400394_g17897_i0	PRJNA407886	19578	580	2.400394	13.9222852	Fuerstiella sp.	1936112	Bacteria	Bacteria	48.1	0.01	NR	MCP4506807.1	1936112	g17897	i0	33.6	2.03275862068966	131	78	64.1	4	377	6	386	514	MCP4506807.1 hypothetical protein [Fuerstiella sp.]	diamond	1179	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
32066906	32066906	PRJNA407886_P_NODE_35858_length_371_cov_2.154362_g34164_i0	PRJNA407886	35858	371	2.154362	7.99268302	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	52	9.45e-5	NR	MFN0136844.1	2026778	g34164	i0	45.3	0.857142857142857	106	44	80.9	6	1	300	1160	1257	MFN0136844.1 choice-of-anchor tandem repeat NxxGxxAF-containing protein [Phycisphaerae bacterium]	diamond	318	52	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32904628	32904628	PRJNA407886_P_NODE_38240_length_356_cov_1.590106_g36546_i0	PRJNA407886	38240	356	1.590106	5.66077736	root	1	Root_unresolved	Root_unresolved	97.1	1.02e-20	NR	NUM34221.1	2517210	g36546	i0	45.9	1.82022471910112	111	55	89.3	2	318	1	388	498	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	648	97.8	0.992842535787321	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia 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);;