metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax

30 rows where analysis = "diamond", bioproject = "PRJNA493828" 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
3657687	3657687	PRJNA493828_P_NODE_28363_length_260_cov_2.860963_g27944_i0	PRJNA493828	28363	260	2.860963	7.4385038	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	71.2	4.2e-12	NR	MFN0133670.1	2052180	g27944	i0	48.8	0.992307692307692	86	43	98.1	1	4	258	323	408	MFN0133670.1 SpoIIE family protein phosphatase [Phycisphaerales bacterium]	diamond	258	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
8127986	8127986	PRJNA493828_P_NODE_46107_length_210_cov_5.262774_g45688_i0	PRJNA493828	46107	210	5.262774	11.0518254	Urbifossiella	2807415	Bacteria	Bacteria	79	2.07e-16	NR	HEY2909706.1	2052164	g45688	i0	64.6	2.71428571428571	65	23	92.9	0	203	9	98	162	HEY2909706.1 hypothetical protein [Gemmataceae bacterium]	diamond	570	79.3	0.996216897856242	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
13228761	13228761	PRJNA493828_P_NODE_44411_length_224_cov_5.258278_g43992_i0	PRJNA493828	44411	224	5.258278	11.77854272	Gemmataceae bacterium	2052164	Bacteria	Bacteria	132	2.69e-36	NR	MFO0844799.1	2052164	g43992	i0	94.6	0.991071428571429	74	4	99.1	0	222	1	13	86	MFO0844799.1 tetratricopeptide repeat protein [Gemmataceae bacterium]	diamond	222	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
17052221	17052221	PRJNA493828_P_NODE_42854_length_230_cov_3.019108_g42435_i0	PRJNA493828	42854	230	3.019108	6.9439484	Urbifossiella sp.	2807431	Bacteria	Bacteria	77.4	4.43e-15	NR	HEX4609202.1	2807431	g42435	i0	52.1	0.952173913043478	73	35	95.2	0	12	230	53	125	HEX4609202.1 hypothetical protein [Urbifossiella sp.]	diamond	219	77.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella sp.
26665125	26665125	PRJNA493828_P_NODE_26001_length_267_cov_3.510309_g25582_i0	PRJNA493828	26001	267	3.510309	9.37252503	Planctomycetota bacterium	2026780	Bacteria	Bacteria	117	2.19e-28	NR	MBL8751246.1	2026780	g25582	i0	67	0.98876404494382	88	29	98.9	0	2	265	233	320	MBL8751246.1 response regulator [Planctomycetota bacterium]	diamond	264	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27361593	27361593	PRJNA493828_P_NODE_26343_length_266_cov_2.658031_g25924_i0	PRJNA493828	26343	266	2.658031	7.07036246	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	94	4.7e-20	NR	HET6572392.1	1914235	g25924	i0	62.2	0.834586466165414	74	28	83.5	0	224	3	220	293	HET6572392.1 M28 family peptidase [Fimbriiglobus sp.]	diamond	222	94	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
27709148	27709148	PRJNA493828_P_NODE_30684_length_254_cov_2.386740_g30265_i0	PRJNA493828	30684	254	2.38674	6.0623196	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.00731	NR	MCP4258478.1	2026780	g30265	i0	48.9	0.531496062992126	45	23	53.1	0	1	135	19	63	MCP4258478.1 hypothetical protein [Planctomycetota bacterium]	diamond	135	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28561325	28561325	PRJNA493828_P_NODE_38807_length_242_cov_0.911243_g38388_i0	PRJNA493828	38807	242	0.911243	2.20520806	Singulisphaera sp. GP187	1882752	Bacteria	Bacteria	98.2	3.82e-22	NR	WP_074307176.1	1882752	g38388	i0	90.9	1.36363636363636	55	5	68.2	0	181	17	1	55	WP_074307176.1 type IV pilus twitching motility protein PilT [Singulisphaera sp. GP187]	diamond	330	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. GP187
28923956	28923956	PRJNA493828_P_NODE_19168_length_290_cov_4.811060_g18749_i0	PRJNA493828	19168	290	4.81106	13.952074	Bacteria	2	Bacteria	Bacteria	176	2.76e-49	NR	PHX62732.1	2026779	g18749	i0	92.7	3.97241379310345	96	7	99.3	0	3	290	189	284	PHX62732.1 MAG: hypothetical protein CK551_09655, partial [Planctomycetaceae bacterium]	diamond	1152	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29382162	29382162	PRJNA493828_P_NODE_47549_length_202_cov_4.201550_g47130_i0	PRJNA493828	47549	202	4.20155	8.487131	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	90.9	2.43e-19	NR	MDB5339053.1	2026779	g47130	i0	58.2	0.995049504950495	67	28	99.5	0	2	202	495	561	MDB5339053.1 Beta-galactosidase trimerization domain protein [Planctomycetaceae bacterium]	diamond	201	90.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29571439	29571439	PRJNA493828_P_NODE_24890_length_271_cov_1.510101_g24471_i0	PRJNA493828	24890	271	1.510101	4.09237371	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	60.1	2.25e-8	NR	MCC6509522.1	2699754	g24471	i0	56.3	1.02952029520295	48	21	53.1	0	269	126	193	240	MCC6509522.1 hypothetical protein [Pirellulaceae bacterium]	diamond	279	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29729181	29729181	PRJNA493828_P_NODE_32650_length_250_cov_1.406780_g32231_i0	PRJNA493828	32650	250	1.40678	3.51695	Bythopirellula sp.	2964542	Bacteria	Bacteria	63.9	2.11e-10	NR	MDZ4655946.1	2964542	g32231	i0	64	0.6	50	18	60	0	150	1	1	50	MDZ4655946.1 hypothetical protein [Bythopirellula sp.]	diamond	150	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula sp.
29823971	29823971	PRJNA493828_P_NODE_18571_length_293_cov_2.395455_g18152_i0	PRJNA493828	18571	293	2.395455	7.01868315	Planctomycetota bacterium	2026780	Bacteria	Bacteria	67	1.96e-10	NR	MEM1013280.1	2026780	g18152	i0	35.2	1.27986348122867	125	48	94.2	3	5	280	485	609	MEM1013280.1 hypothetical protein [Planctomycetota bacterium]	diamond	375	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29823977	29823977	PRJNA493828_P_NODE_25691_length_268_cov_2.830769_g25272_i0	PRJNA493828	25691	268	2.830769	7.58646092	Planctomycetota bacterium	2026780	Bacteria	Bacteria	69.7	1.59e-11	NR	MFM1873054.1	2026780	g25272	i0	59.3	0.66044776119403	59	24	66	0	177	1	5	63	MFM1873054.1 hypothetical protein [Planctomycetota bacterium]	diamond	177	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30139699	30139699	PRJNA493828_P_NODE_18992_length_291_cov_2.949541_g18573_i0	PRJNA493828	18992	291	2.949541	8.58316431	Planctomycetota bacterium	2026780	Bacteria	Bacteria	142	5.019999999999999e-37	NR	MFO0946014.1	2026780	g18573	i0	65.1	1.09278350515464	106	27	99	1	289	2	200	305	MFO0946014.1 LamG domain-containing protein [Planctomycetota bacterium]	diamond	318	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30234846	30234846	PRJNA493828_P_NODE_31092_length_253_cov_1.994444_g30673_i0	PRJNA493828	31092	253	1.994444	5.04594332	Planctomycetota bacterium	2026780	Bacteria	Bacteria	167	2.06e-49	NR	MCI0333272.1	2026780	g30673	i0	89.3	1.99209486166008	84	9	99.6	0	252	1	175	258	MCI0333272.1 N-acetylglucosamine-6-phosphate deacetylase [Planctomycetota bacterium]	diamond	504	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30266789	30266789	PRJNA493828_P_NODE_26212_length_267_cov_1.257732_g25793_i0	PRJNA493828	26212	267	1.257732	3.35814444	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	117	3.0299999999999998e-31	NR	HIB69554.1	2052180	g25793	i0	73.1	0.876404494382023	78	21	87.6	0	19	252	1	78	HIB69554.1 hypothetical protein [Phycisphaerales bacterium]	diamond	234	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30550715	30550715	PRJNA493828_P_NODE_15993_length_310_cov_2.565401_g15574_i0	PRJNA493828	15993	310	2.565401	7.9527431	Planctomycetia bacterium	2052181	Bacteria	Bacteria	97.1	6.9300000000000008e-21	NR	MBL8795186.1	2052181	g15574	i0	40.3	1.24838709677419	129	51	99.7	2	1	309	469	597	MBL8795186.1 single-stranded-DNA-specific exonuclease RecJ [Planctomycetia bacterium]	diamond	387	97.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30550719	30550719	PRJNA493828_P_NODE_25633_length_268_cov_4.497436_g25214_i0	PRJNA493828	25633	268	4.497436	12.05312848	Sedimentisphaeraceae bacterium JB056	3342865	Bacteria	Bacteria	55.1	4.96e-7	NR	MFI4910641.1	3342865	g25214	i0	50	2.76492537313433	52	25	57.1	1	262	110	96	147	MFI4910641.1 Hsp20/alpha crystallin family protein [Sedimentisphaeraceae bacterium JB056]	diamond	741	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Sedimentisphaeraceae		Sedimentisphaeraceae bacterium JB056
30898492	30898492	PRJNA493828_P_NODE_19054_length_291_cov_2.032110_g18635_i0	PRJNA493828	19054	291	2.03211	5.9134401	Planctomycetota bacterium	2026780	Bacteria	Bacteria	89.4	9.71e-19	NR	MBL8727238.1	2026780	g18635	i0	95.7	1.45360824742268	47	2	48.5	0	290	150	290	336	MBL8727238.1 radical SAM protein [Planctomycetota bacterium]	diamond	423	89.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30961646	30961646	PRJNA493828_P_NODE_47294_length_203_cov_4.992308_g46875_i0	PRJNA493828	47294	203	4.992308	10.13438524	Gemmataceae bacterium	2052164	Bacteria	Bacteria	114	1.84e-27	NR	MBX9627731.1	2052164	g46875	i0	89.4	3.90147783251232	66	7	97.5	0	2	199	533	598	MBX9627731.1 flagellar biosynthesis protein FlhA [Gemmataceae bacterium]	diamond	792	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31056671	31056671	PRJNA493828_P_NODE_47515_length_202_cov_4.527132_g47096_i0	PRJNA493828	47515	202	4.527132	9.14480664	Planctomycetota bacterium	2026780	Bacteria	Bacteria	119	1.91e-29	NR	HEX6812359.1	2026780	g47096	i0	84.8	0.98019801980198	66	10	98	0	3	200	91	156	HEX6812359.1 hypothetical protein [Planctomycetota bacterium]	diamond	198	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31087929	31087929	PRJNA493828_P_NODE_30375_length_255_cov_1.862637_g29956_i0	PRJNA493828	30375	255	1.862637	4.74972435	Planctomycetota bacterium	2026780	Bacteria	Bacteria	148	2.39e-41	NR	MEI7686785.1	2026780	g29956	i0	73.8	0.988235294117647	84	22	98.8	0	3	254	38	121	MEI7686785.1 HD domain-containing protein [Planctomycetota bacterium]	diamond	252	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31213875	31213875	PRJNA493828_P_NODE_21435_length_282_cov_2.803828_g21016_i0	PRJNA493828	21435	282	2.803828	7.90679496	Gemmataceae bacterium	2052164	Bacteria	Bacteria	171	4.02e-47	NR	MFO0849116.1	2052164	g21016	i0	91.6	0.882978723404255	83	7	88.3	0	282	34	830	912	MFO0849116.1 DUF2461 family protein [Gemmataceae bacterium]	diamond	249	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31245914	31245914	PRJNA493828_P_NODE_33075_length_249_cov_4.056818_g32656_i0	PRJNA493828	33075	249	4.056818	10.10147682	Lacipirellula parvula	2650471	Bacteria	Bacteria	132	2.29e-35	NR	WP_152100944.1	2650471	g32656	i0	71.3	0.963855421686747	80	23	96.4	0	249	10	203	282	WP_152100944.1 PEP-CTERM sorting domain-containing protein [Lacipirellula parvula]	diamond	240	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
31656958	31656958	PRJNA493828_P_NODE_21777_length_281_cov_2.052885_g21358_i0	PRJNA493828	21777	281	2.052885	5.76860685	Planctomycetota bacterium	2026780	Bacteria	Bacteria	103	1.5799999999999998e-23	NR	MCA8963674.1	2026780	g21358	i0	50.4	2.66903914590747	125	28	97.2	1	2	274	57	181	MCA8963674.1 DJ-1/PfpI family protein [Planctomycetota bacterium]	diamond	750	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31656966	31656966	PRJNA493828_P_NODE_40037_length_240_cov_4.035928_g39618_i0	PRJNA493828	40037	240	4.035928	9.6862272	Pirellulales bacterium	2715253	Bacteria	Bacteria	114	1.32e-27	NR	MCC7085790.1	2715253	g39618	i0	88.7	0.775	62	7	77.5	0	1	186	510	571	MCC7085790.1 Rne/Rng family ribonuclease [Pirellulales bacterium]	diamond	186	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32100015	32100015	PRJNA493828_P_NODE_35398_length_246_cov_3.156069_g34979_i0	PRJNA493828	35398	246	3.156069	7.76392974	Planctomycetota bacterium	2026780	Bacteria	Bacteria	141	3.03e-37	NR	MFN6145025.1	2026780	g34979	i0	82.9	3	82	14	100	0	1	246	420	501	MFN6145025.1 cytochrome c3 family protein [Planctomycetota bacterium]	diamond	738	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32195005	32195005	PRJNA493828_P_NODE_28038_length_261_cov_2.845745_g27619_i0	PRJNA493828	28038	261	2.845745	7.42739445	Planctomycetota bacterium	2026780	Bacteria	Bacteria	103	1.37e-23	NR	MDX2116388.1	2026780	g27619	i0	55.3	0.977011494252874	85	38	97.7	0	259	5	816	900	MDX2116388.1 dockerin type I domain-containing protein [Planctomycetota bacterium]	diamond	255	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32511683	32511683	PRJNA493828_P_NODE_26379_length_266_cov_2.279793_g25960_i0	PRJNA493828	26379	266	2.279793	6.06424938	Planctomycetota bacterium	2026780	Bacteria	Bacteria	118	7.86e-30	NR	MCU0867232.1	2026780	g25960	i0	69	1.96240601503759	87	27	98.1	0	5	265	217	303	MCU0867232.1 hypothetical protein [Planctomycetota bacterium]	diamond	522	118	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);;