metadata: contig_metadata: 18 rows where bioproject = "PRJNA752572", tax_phylum = "Planctomycetota" and tax

18 rows where bioproject = "PRJNA752572", tax_phylum = "Planctomycetota" and tax_superkingdom = "Bacteria"

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
728571	728571	PRJNA752572_P_NODE_18401_length_627_cov_1.976351_g17969_i0	PRJNA752572	18401	627	1.976351	12.39172077	Blastopirellula marina	124	Bacteria	Bacteria	173	2.0799999999999998e-46	NR	WP_105338133.1	124	g17969	i0	50	2.61244019138756	182	85	84.7	2	602	72	95	275	WP_105338133.1 peroxidase family protein [Blastopirellula marina]	diamond	1638	173	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
18580442	18580442	PRJNA752572_P_NODE_81135_length_301_cov_6.135338_g80628_i0	PRJNA752572	81135	301	6.135338	18.46736738	Bacteria	2	Bacteria	Bacteria	99.4	1.81e-23	NR	MBU6237403.1	2026780	g80628	i0	51.5	2.73089700996678	99	44	95.7	2	12	299	9	106	MBU6237403.1 peptidylprolyl isomerase [Planctomycetota bacterium]	diamond	822	99.8	0.995991983967936	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
23681614	23681614	PRJNA752572_P_NODE_80899_length_302_cov_2.089888_g80392_i0	PRJNA752572	80899	302	2.089888	6.31146176	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	91.7	4.94e-19	NR	QDT69730.1	2527998	g80392	i0	46.9	0.973509933774834	98	52	97.4	0	294	1	424	521	QDT69730.1 peroxidase [Planctomycetes bacterium MalM25]	diamond	294	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
26863368	26863368	PRJNA752572_P_NODE_238181_length_172_cov_1.160584_g237674_i0	PRJNA752572	238181	172	1.160584	1.99620448	Planctomycetota bacterium	2026780	Bacteria	Bacteria	99	1.86e-22	NR	MEM7227367.1	2026780	g237674	i0	82.1	8.7906976744186	56	10	97.7	0	3	170	209	264	MEM7227367.1 MmgE/PrpD family protein [Planctomycetota bacterium]	diamond	1512	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27052938	27052938	PRJNA752572_P_NODE_103602_length_265_cov_2.286957_g103095_i0	PRJNA752572	103602	265	2.286957	6.06043605	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	43.5	0.0255	NR	MDZ4852247.1	2699754	g103095	i0	35.7	1.63018867924528	70	42	79.2	1	28	237	251	317	MDZ4852247.1 DUF1559 domain-containing protein [Pirellulaceae bacterium]	diamond	432	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27189003	27189003	PRJNA752572_P_NODE_231982_length_174_cov_1.179856_g231475_i0	PRJNA752572	231982	174	1.179856	2.05294944	Bacteria	2	Bacteria	Bacteria	47	3.87e-4	NR	MBN8643716.1	2026780	g231475	i0	40.8	2.58620689655172	49	29	84.5	0	155	9	3	51	MBN8643716.1 aquaporin [Planctomycetota bacterium]	diamond	450	47.4	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27274152	27274152	PRJNA752572_P_NODE_214223_length_181_cov_2.191781_g213716_i0	PRJNA752572	214223	181	2.191781	3.96712361	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	47	5.23e-4	NR	NUM34221.1	2517210	g213716	i0	40.7	0.895027624309392	54	32	89.5	0	13	174	392	445	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	162	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
27653269	27653269	PRJNA752572_P_NODE_133044_length_232_cov_2.812183_g132537_i0	PRJNA752572	133044	232	2.812183	6.52426456	Gemmataceae bacterium	2052164	Bacteria	Bacteria	90.5	4.77e-19	NR	MFO0935315.1	2052164	g132537	i0	69	2.92241379310345	58	18	75	0	54	227	338	395	MFO0935315.1 glucosamine-6-phosphate deaminase [Gemmataceae bacterium]	diamond	678	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28484003	28484003	PRJNA752572_P_NODE_285946_length_152_cov_2.478632_g285439_i0	PRJNA752572	285946	152	2.478632	3.76752064	Bacteria	2	Bacteria	Bacteria	43.1	0.00787	NR	MDB5351554.1	2026780	g285439	i0	44.9	6.35526315789474	49	27	96.7	0	148	2	89	137	MDB5351554.1 hypothetical protein [Planctomycetota bacterium]	diamond	966	43.5	0.990804597701149	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28547311	28547311	PRJNA752572_P_NODE_217967_length_180_cov_1.027586_g217460_i0	PRJNA752572	217967	180	1.027586	1.8496548	Bacteria	2	Bacteria	Bacteria	44.3	0.0048	NR	MSR60211.1	2026779	g217460	i0	44.8	9.85	58	19	96.7	1	1	174	195	239	MSR60211.1 hydantoinase [Planctomycetaceae bacterium]	diamond	1773	44.7	0.991051454138702	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28758141	28758141	PRJNA752572_P_NODE_167107_length_207_cov_1.069767_g166600_i0	PRJNA752572	167107	207	1.069767	2.21441769	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.1	0.0106	NR	MFO0782636.1	2052180	g166600	i0	43.5	0.666666666666667	46	23	66.7	1	10	147	64	106	MFO0782636.1 hypothetical protein [Phycisphaerales bacterium]	diamond	138	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28768015	28768015	PRJNA752572_P_NODE_124247_length_241_cov_1.553398_g123740_i0	PRJNA752572	124247	241	1.553398	3.74368918	Bacteria	2	Bacteria	Bacteria	92	9.12e-21	NR	MEO1372129.1	2026780	g123740	i0	73.4	6.59751037344398	64	17	79.7	0	45	236	6	69	MEO1372129.1 MmgE/PrpD family protein [Planctomycetota bacterium]	diamond	1590	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29895028	29895028	PRJNA752572_P_NODE_57111_length_362_cov_1.128440_g56604_i0	PRJNA752572	57111	362	1.12844	4.0849528	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	100	4.59e-22	NR	NUM34221.1	2517210	g56604	i0	45.9	0.919889502762431	111	55	87.8	2	43	360	392	502	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	333	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
30652995	30652995	PRJNA752572_P_NODE_170853_length_204_cov_2.124260_g170346_i0	PRJNA752572	170853	204	2.12426	4.3334904	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.2	9.26e-12	NR	MFN9718116.1	2026780	g170346	i0	62.2	3.32352941176471	45	17	66.2	0	203	69	187	231	MFN9718116.1 peptide-methionine (S)-S-oxide reductase MsrA [Planctomycetota bacterium]	diamond	678	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30748014	30748014	PRJNA752572_P_NODE_75574_length_313_cov_1.712230_g75067_i0	PRJNA752572	75574	313	1.71223	5.3592799	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	45.4	0.00861	NR	MFP4176727.1	2517210	g75067	i0	37.8	0.70926517571885	74	44	70.9	2	75	296	156	227	MFP4176727.1 signal peptide peptidase SppA [Candidatus Brocadiia bacterium]	diamond	222	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
32117633	32117633	PRJNA752572_P_NODE_56058_length_365_cov_2.851515_g55551_i0	PRJNA752572	56058	365	2.851515	10.40802975	Planctomycetota	203682	Bacteria	Bacteria	97.4	8.3e-21	NR	NUM34221.1	2517210	g55551	i0	49.1	2.79452054794521	112	47	87.1	5	6	323	396	503	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	1020	97.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
32550902	32550902	PRJNA752572_P_NODE_160439_length_211_cov_1.590909_g159932_i0	PRJNA752572	160439	211	1.590909	3.35681799	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.00938	NR	NDG63123.1	2026780	g159932	i0	37.3	2.90047393364929	51	32	72.5	0	6	158	165	215	NDG63123.1 VWA domain-containing protein [Planctomycetota bacterium]	diamond	612	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32834015	32834015	PRJNA752572_P_NODE_257060_length_167_cov_1.000000_g256553_i0	PRJNA752572	257060	167	1	1.67	Gemmataceae bacterium	2052164	Bacteria	Bacteria	99.4	1.53e-22	NR	HVK08790.1	2052164	g256553	i0	83.6	0.988023952095808	55	9	98.8	0	167	3	370	424	HVK08790.1 sigma-70 family RNA polymerase sigma factor [Gemmataceae bacterium]	diamond	165	99.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;