metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA638138" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA638138" 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
3160444	3160444	PRJNA638138_P_NODE_33223_length_242_cov_0.911243_g33008_i0	PRJNA638138	33223	242	0.911243	2.20520806	Lacipirellula sp.	2691419	Bacteria	Bacteria	164	8.799999999999998e-48	NR	HEX6963572.1	2691419	g33008	i0	100	0.991735537190083	80	0	99.2	0	3	242	170	249	HEX6963572.1 beta-ketoacyl-ACP synthase III [Lacipirellula sp.]	diamond	240	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula sp.
4437052	4437052	PRJNA638138_P_NODE_20144_length_251_cov_0.865169_g19929_i0	PRJNA638138	20144	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	137	1.06e-38	NR	MBL8729275.1	2026780	g19929	i0	81.9	5.95219123505976	83	15	99.2	0	250	2	47	129	MBL8729275.1 sigma-70 family RNA polymerase sigma factor [Planctomycetota bacterium]	diamond	1494	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26605977	26605977	PRJNA638138_P_NODE_30941_length_244_cov_0.900585_g30726_i0	PRJNA638138	30941	244	0.900585	2.1974274	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	96.3	2.28e-21	NR	HEV7279911.1	2699754	g30726	i0	86.2	0.799180327868853	65	7	78.7	2	2	193	119	182	HEV7279911.1 helix-turn-helix domain-containing protein [Pirellulaceae bacterium]	diamond	195	96.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
26732465	26732465	PRJNA638138_P_NODE_26261_length_247_cov_0.885057_g26046_i0	PRJNA638138	26261	247	0.885057	2.18609079	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	132	7.87e-34	NR	MEA2708358.1	2052180	g26046	i0	75	0.97165991902834	80	20	97.2	0	242	3	512	591	MEA2708358.1 hypothetical protein [Phycisphaerales bacterium]	diamond	240	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26827977	26827977	PRJNA638138_P_NODE_19521_length_251_cov_0.865169_g19306_i0	PRJNA638138	19521	251	0.865169	2.17157419	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	62.4	2.68e-9	NR	HTN77743.1	2699754	g19306	i0	42.4	1.01593625498008	85	41	92	3	240	10	125	209	HTN77743.1 PDZ domain-containing protein [Pirellulaceae bacterium]	diamond	255	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27334046	27334046	PRJNA638138_P_NODE_32803_length_243_cov_0.905882_g32588_i0	PRJNA638138	32803	243	0.905882	2.20129326	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	50.8	5.07e-5	NR	HEY7117261.1	2876886	g32588	i0	61.9	1	42	16	51.9	0	238	113	271	312	HEY7117261.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	243	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27397221	27397221	PRJNA638138_P_NODE_18523_length_255_cov_1.461538_g18308_i0	PRJNA638138	18523	255	1.461538	3.7269219	Planctomycetota bacterium	2026780	Bacteria	Bacteria	104	6.71e-24	NR	MBL8754035.1	2026780	g18308	i0	79.4	0.8	68	14	80	0	4	207	500	567	MBL8754035.1 HEAT repeat domain-containing protein [Planctomycetota bacterium]	diamond	204	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27713218	27713218	PRJNA638138_P_NODE_32604_length_243_cov_0.905882_g32389_i0	PRJNA638138	32604	243	0.905882	2.20129326	Planctomycetota bacterium	2026780	Bacteria	Bacteria	73.6	2.92e-13	NR	MBL8756658.1	2026780	g32389	i0	51.9	0.975308641975309	79	38	97.5	0	239	3	39	117	MBL8756658.1 hypothetical protein [Planctomycetota bacterium]	diamond	237	73.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27870575	27870575	PRJNA638138_P_NODE_14905_length_283_cov_1.242857_g14690_i0	PRJNA638138	14905	283	1.242857	3.51728531	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.8	7.29e-6	NR	MBV8487263.1	2026779	g14690	i0	64.7	0.360424028268551	34	12	36	0	277	176	50	83	MBV8487263.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	102	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28091655	28091655	PRJNA638138_P_NODE_22725_length_249_cov_0.875000_g22510_i0	PRJNA638138	22725	249	0.875	2.17875	Pirellulales bacterium	2715253	Bacteria	Bacteria	137	4.29e-38	NR	MEX2170740.1	2715253	g22510	i0	81.5	1.95180722891566	81	15	97.6	0	3	245	64	144	MEX2170740.1 helix-turn-helix domain-containing protein [Pirellulales bacterium]	diamond	486	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
28261867	28261867	PRJNA638138_P_NODE_31386_length_243_cov_1.452941_g31171_i0	PRJNA638138	31386	243	1.452941	3.53064663	Polystyrenella	2795774	Bacteria	Bacteria	149	9.18e-40	NR	MCA9039268.1	2026779	g31171	i0	81.3	3.95061728395062	80	15	98.8	0	242	3	291	370	MCA9039268.1 c-type cytochrome [Planctomycetaceae bacterium]	diamond	960	150	0.993333333333333	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28533930	28533930	PRJNA638138_P_NODE_21727_length_250_cov_0.870056_g21512_i0	PRJNA638138	21727	250	0.870056	2.17514	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.4	1.65e-5	NR	MCY2984533.1	2026780	g21512	i0	50	0.624	52	24	62.4	1	1	156	648	697	MCY2984533.1 excinuclease ABC subunit UvrB [Planctomycetota bacterium]	diamond	156	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28546470	28546470	PRJNA638138_P_NODE_36107_length_241_cov_0.880952_g35892_i0	PRJNA638138	36107	241	0.880952	2.12309432	PVC group	1783257	Bacteria	Bacteria	43.1	0.0274	NR	MBX3437484.1	2026779	g35892	i0	34.6	1.44398340248963	52	30	64.7	1	223	68	726	773	MBX3437484.1 PQQ-binding-like beta-propeller repeat protein [Planctomycetaceae bacterium]	diamond	348	43.5	0.990804597701149	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29303933	29303933	PRJNA638138_P_NODE_34429_length_242_cov_0.911243_g34214_i0	PRJNA638138	34429	242	0.911243	2.20520806	Planctomycetia	203683	Bacteria	Bacteria	110	3.95e-26	NR	MFO0960451.1	2691532	g34214	i0	66.3	1.98347107438017	80	25	99.2	1	3	242	798	875	MFO0960451.1 type ISP restriction/modification enzyme [Isosphaeraceae bacterium]	diamond	480	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29386374	29386374	PRJNA638138_P_NODE_32949_length_243_cov_0.858824_g32734_i0	PRJNA638138	32949	243	0.858824	2.08694232	Planctomycetota bacterium	2026780	Bacteria	Bacteria	99.4	1.66e-22	NR	MBX3468890.1	2026780	g32734	i0	67.5	0.987654320987654	80	24	98.8	1	241	2	215	292	MBX3468890.1 methyltransferase [Planctomycetota bacterium]	diamond	240	99.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29417688	29417688	PRJNA638138_P_NODE_25089_length_248_cov_0.880000_g24874_i0	PRJNA638138	25089	248	0.88	2.1824	Caulifigura sp.	2795792	Bacteria	Bacteria	163	3.44e-46	NR	HVJ86587.1	2795792	g24874	i0	93.9	0.991935483870968	82	5	99.2	0	1	246	196	277	HVJ86587.1 MFS transporter [Caulifigura sp.]	diamond	246	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura sp.
29796550	29796550	PRJNA638138_P_NODE_19971_length_251_cov_0.865169_g19756_i0	PRJNA638138	19971	251	0.865169	2.17157419	Posidoniimonas corsicana	1938618	Bacteria	Bacteria	85.5	3.67e-17	NR	WP_146568198.1	1938618	g19756	i0	64.9	1.33864541832669	57	20	68.1	0	1	171	671	727	WP_146568198.1 DNA helicase RecQ [Posidoniimonas corsicana]	diamond	336	85.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Posidoniimonas	Posidoniimonas corsicana
30112497	30112497	PRJNA638138_P_NODE_15952_length_275_cov_0.990099_g15737_i0	PRJNA638138	15952	275	0.990099	2.72277225	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.1	0.0384	NR	HBB75859.1	2026779	g15737	i0	42.6	0.665454545454545	61	34	65.5	1	204	25	12	72	HBB75859.1 NupC/NupG family nucleoside CNT transporter [Planctomycetaceae bacterium]	diamond	183	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30112498	30112498	PRJNA638138_P_NODE_16652_length_269_cov_1.566327_g16437_i0	PRJNA638138	16652	269	1.566327	4.21341963	Planctomycetota bacterium	2026780	Bacteria	Bacteria	67	8.04e-11	NR	HYE04044.1	2026780	g16437	i0	38.6	0.981412639405205	88	53	97	1	266	6	59	146	HYE04044.1 CPBP family intramembrane glutamic endopeptidase [Planctomycetota bacterium]	diamond	264	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30238962	30238962	PRJNA638138_P_NODE_32352_length_243_cov_0.905882_g32137_i0	PRJNA638138	32352	243	0.905882	2.20129326	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	79	3.85e-15	NR	MCC7144838.1	2026777	g32137	i0	48.8	0.987654320987654	80	40	98.8	1	1	240	30	108	MCC7144838.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	240	79	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
30681090	30681090	PRJNA638138_P_NODE_32613_length_243_cov_0.905882_g32398_i0	PRJNA638138	32613	243	0.905882	2.20129326	Botrimarina mediterranea	2528022	Bacteria	Bacteria	112	3.72e-28	NR	WP_145114283.1	2528022	g32398	i0	83.8	0.987654320987654	80	13	98.8	0	2	241	123	202	WP_145114283.1 ion transporter [Botrimarina mediterranea]	diamond	240	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Botrimarina	Botrimarina mediterranea
30883287	30883287	PRJNA638138_P_NODE_24954_length_248_cov_0.880000_g24739_i0	PRJNA638138	24954	248	0.88	2.1824	Caulifigura	2795778	Bacteria	Bacteria	85.1	3.23e-17	NR	WP_145034113.1	2527983	g24739	i0	92.9	1.01612903225806	42	3	50.8	0	3	128	352	393	WP_145034113.1 bifunctional glutamate N-acetyltransferase/amino-acid acetyltransferase ArgJ [Caulifigura coniformis]	diamond	252	85.9	0.990686845168801	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
31787597	31787597	PRJNA638138_P_NODE_19917_length_251_cov_0.865169_g19702_i0	PRJNA638138	19917	251	0.865169	2.17157419	Planctomycetia bacterium	2052181	Bacteria	Bacteria	119	8.619999999999999e-31	NR	MFM8980234.1	2052181	g19702	i0	67.5	2.97609561752988	83	27	99.2	0	1	249	51	133	MFM8980234.1 arginyltransferase [Planctomycetia bacterium]	diamond	747	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
32167656	32167656	PRJNA638138_P_NODE_21418_length_250_cov_0.870056_g21203_i0	PRJNA638138	21418	250	0.870056	2.17514	Planctomycetes bacterium RBG_13_6	2026780	Bacteria	Bacteria	42.4	0.0492	NR	OHB67037.1	1801963	g21203	i0	46.6	0.696	58	22	68.4	5	75	245	176	225	OHB67037.1 MAG: hypothetical protein A2Y76_00495 [Planctomycetes bacterium RBG_13_60_9]	diamond	174	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium RBG_13_60_9
32420655	32420655	PRJNA638138_P_NODE_26359_length_247_cov_0.885057_g26144_i0	PRJNA638138	26359	247	0.885057	2.18609079	Botrimarina mediterranea	2528022	Bacteria	Bacteria	43.9	0.0143	NR	WP_145112953.1	2528022	g26144	i0	55.6	0.437246963562753	36	16	43.7	0	3	110	105	140	WP_145112953.1 hypothetical protein [Botrimarina mediterranea]	diamond	108	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Botrimarina	Botrimarina mediterranea
32736328	32736328	PRJNA638138_P_NODE_29400_length_245_cov_0.895349_g29185_i0	PRJNA638138	29400	245	0.895349	2.19360505	Lacipirellula parvula	2650471	Bacteria	Bacteria	133	2.82e-34	NR	BBO35257.1	2650471	g29185	i0	81.3	1.83673469387755	75	14	91.8	0	2	226	497	571	BBO35257.1 hypothetical protein PLANPX_4869 [Lacipirellula parvula]	diamond	450	133	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula

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