metadata: contig_metadata: 14 rows where bioproject = "PRJNA473201" and tax

14 rows where bioproject = "PRJNA473201" 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
5548126	5548126	PRJNA473201_P_NODE_76945_length_245_cov_0.895349_g76203_i0	PRJNA473201	76945	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	82.4	2.03e-17	NR	NIP23489.1	2026778	g76203	i0	53.8	3.79591836734694	78	35	94.3	1	239	9	1	78	NIP23489.1 RNA 2'-phosphotransferase [Phycisphaerae bacterium]	diamond	930	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
19570412	19570412	PRJNA473201_P_NODE_85256_length_241_cov_0.916667_g84514_i0	PRJNA473201	85256	241	0.916667	2.20916747	Saltatorellus ferox	2528018	Bacteria	Bacteria	145	3.48e-30	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g84514	i0	80.423	58.3858921161826	189	37	78	0	31	219	3604364	3604176	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	14071	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
26807631	26807631	PRJNA473201_P_NODE_52821_length_285_cov_1.165094_g52079_i0	PRJNA473201	52821	285	1.165094	3.3205179	Bacteria	2	Bacteria	Bacteria	56.6	5.7e-7	NR	MFT5328049.1	2026779	g52079	i0	37.2	3.57894736842105	94	54	98.9	2	3	284	70	158	MFT5328049.1 carbonic anhydrase [Planctomycetaceae bacterium]	diamond	1020	56.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27486990	27486990	PRJNA473201_P_NODE_76043_length_246_cov_0.890173_g75301_i0	PRJNA473201	76043	246	0.890173	2.18982558	Planctomycetales bacterium	2053591	Bacteria	Bacteria	47.4	7.82e-4	NR	MCA9139358.1	2053591	g75301	i0	39.2	0.902439024390244	74	26	79.3	2	241	47	29	92	MCA9139358.1 hypothetical protein [Planctomycetales bacterium]	diamond	222	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
27613419	27613419	PRJNA473201_P_NODE_78024_length_245_cov_0.895349_g77282_i0	PRJNA473201	78024	245	0.895349	2.19360505	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0385	NR	MEI8380909.1	2026780	g77282	i0	45.9	0.453061224489796	37	20	45.3	0	157	47	436	472	MEI8380909.1 glycosyltransferase family 9 protein [Planctomycetota bacterium]	diamond	111	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28970993	28970993	PRJNA473201_P_NODE_49848_length_292_cov_1.726027_g49106_i0	PRJNA473201	49848	292	1.726027	5.03999884	Zavarzinella formosa	360055	Bacteria	Bacteria	47.4	0.00167	NR	WP_020468205.1	360055	g49106	i0	37	1.02739726027397	100	43	88.4	3	291	34	1753	1846	WP_020468205.1 beta strand repeat-containing protein [Zavarzinella formosa]	diamond	300	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella formosa
29065795	29065795	PRJNA473201_P_NODE_10728_length_617_cov_2.566176_g9995_i0	PRJNA473201	10728	617	2.566176	15.83330592	Planctomycetota bacterium	2026780	Bacteria	Bacteria	84	7.97e-15	NR	MSR63205.1	2026780	g9995	i0	47.7	0.427876823338736	88	40	42.8	2	140	403	342	423	MSR63205.1 HYR domain-containing protein [Planctomycetota bacterium]	diamond	264	84	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30424123	30424123	PRJNA473201_P_NODE_80213_length_244_cov_0.900585_g79471_i0	PRJNA473201	80213	244	0.900585	2.1974274	Planctomycetia bacterium	2052181	Bacteria	Bacteria	43.1	0.0167	NR	NCY03362.1	2052181	g79471	i0	43.1	0.713114754098361	58	28	65.2	1	61	219	55	112	NCY03362.1 hypothetical protein [Planctomycetia bacterium]	diamond	174	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30644725	30644725	PRJNA473201_P_NODE_81053_length_243_cov_0.905882_g80311_i0	PRJNA473201	81053	243	0.905882	2.20129326	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	137	1.72e-36	NR	MFA6044981.1	2052180	g80311	i0	75.9	0.975308641975309	79	19	97.5	0	7	243	284	362	MFA6044981.1 hypothetical protein [Phycisphaerales bacterium]	diamond	237	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30661043	30661043	PRJNA473201_P_NODE_16613_length_488_cov_7.455422_g15871_i0	PRJNA473201	16613	488	7.455422	36.38245936	Candidatus Bathyanammoxibius	2983802	Bacteria	Bacteria	66.2	1.36e-9	NR	MEK7449764.1	2026780	g15871	i0	59.2	10.2356557377049	49	20	30.1	0	245	99	173	221	MEK7449764.1 c-type cytochrome biogenesis protein CcsB [Planctomycetota bacterium]	diamond	4995	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31561724	31561724	PRJNA473201_P_NODE_65316_length_252_cov_1.614525_g64574_i0	PRJNA473201	65316	252	1.614525	4.068603	Pirellulales bacterium	2715253	Bacteria	Bacteria	71.6	2.92e-12	NR	HWB08540.1	2715253	g64574	i0	52.4	4.98809523809524	84	37	100	2	252	1	1247	1327	HWB08540.1 immunoglobulin domain-containing protein [Pirellulales bacterium]	diamond	1257	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32447622	32447622	PRJNA473201_P_NODE_81999_length_243_cov_0.905882_g81257_i0	PRJNA473201	81999	243	0.905882	2.20129326	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0206	NR	MEY3458332.1	2026780	g81257	i0	50	0.617283950617284	50	18	61.7	1	71	220	51	93	MEY3458332.1 hypothetical protein [Planctomycetota bacterium]	diamond	150	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32762783	32762783	PRJNA473201_P_NODE_54560_length_280_cov_21.932367_g53818_i0	PRJNA473201	54560	280	21.932367	61.4106276	Rhodopirellula bahusiensis	2014065	Bacteria	Bacteria	45.4	0.0034	NR	MEP4684613.1	2014065	g53818	i0	48.8	0.439285714285714	41	21	43.9	0	72	194	110	150	MEP4684613.1 hypothetical protein [Rhodopirellula bahusiensis]	diamond	123	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula bahusiensis
32857255	32857255	PRJNA473201_P_NODE_76460_length_246_cov_0.890173_g75718_i0	PRJNA473201	76460	246	0.890173	2.18982558	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	77.4	8.24e-16	NR	QNN24803.1	2723666	g75718	i0	65.5	2.25609756097561	55	19	67.1	0	184	20	62	116	QNN24803.1 MGMT family protein [Planctomycetales bacterium ZRK34]	diamond	555	77.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34

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);;