metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax

27 rows where analysis = "diamond", bioproject = "PRJEB83711" 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
2694645	2694645	PRJEB83711_P_NODE_64583_length_249_cov_1.392045_g64317_i0	PRJEB83711	64583	249	1.392045	3.46619205	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	88.6	3.46e-19	NR	HVK18389.1	1914235	g64317	i0	73.1	1.25301204819277	52	14	62.7	0	167	12	3	54	HVK18389.1 DUF6065 family protein [Fimbriiglobus sp.]	diamond	312	88.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
17996107	17996107	PRJEB83711_P_NODE_62695_length_250_cov_1.531073_g62429_i0	PRJEB83711	62695	250	1.531073	3.8276825	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	148	1.53e-39	NR	MBC7817813.1	2026779	g62429	i0	95.1	1.968	82	4	98.4	0	3	248	316	397	MBC7817813.1 sigma 54-interacting transcriptional regulator [Planctomycetaceae bacterium]	diamond	492	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
23096947	23096947	PRJEB83711_P_NODE_80459_length_236_cov_2.742331_g80193_i0	PRJEB83711	80459	236	2.742331	6.47190116	Planctomycetota bacterium	2026780	Bacteria	Bacteria	160	1.42e-43	NR	HEX7902169.1	2026780	g80193	i0	84.6	0.991525423728814	78	12	99.2	0	2	235	344	421	HEX7902169.1 PVC-type heme-binding CxxCH protein [Planctomycetota bacterium]	diamond	234	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27065850	27065850	PRJEB83711_P_NODE_57402_length_253_cov_1.383333_g57136_i0	PRJEB83711	57402	253	1.383333	3.49983249	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	132	9.459999999999999e-34	NR	HZN65819.1	2876886	g57136	i0	76.5	1.00790513833992	85	18	98.4	1	249	1	710	794	HZN65819.1 PQQ-binding-like beta-propeller repeat protein [Tepidisphaeraceae bacterium]	diamond	255	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27128716	27128716	PRJEB83711_P_NODE_58622_length_253_cov_0.866667_g58356_i0	PRJEB83711	58622	253	0.866667	2.19266751	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	143	1.27e-37	NR	MEX2288621.1	2026779	g58356	i0	81	0.99604743083004	84	16	99.6	0	1	252	254	337	MEX2288621.1 Tex family protein [Planctomycetaceae bacterium]	diamond	252	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27160482	27160482	PRJEB83711_P_NODE_41322_length_286_cov_0.910798_g41056_i0	PRJEB83711	41322	286	0.910798	2.60488228	Gemmataceae bacterium	2052164	Bacteria	Bacteria	106	1.2e-24	NR	MEO2091822.1	2052164	g41056	i0	52.6	2.41258741258741	116	34	99.7	3	2	286	283	398	MEO2091822.1 Gfo/Idh/MocA family oxidoreductase [Gemmataceae bacterium]	diamond	690	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27287200	27287200	PRJEB83711_P_NODE_77243_length_243_cov_0.917647_g76977_i0	PRJEB83711	77243	243	0.917647	2.22988221	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	113	1.25e-27	NR	HSU67720.1	2876886	g76977	i0	69.2	0.962962962962963	78	24	96.3	0	2	235	217	294	HSU67720.1 DUF1501 domain-containing protein [Tepidisphaeraceae bacterium]	diamond	234	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27476735	27476735	PRJEB83711_P_NODE_70503_length_246_cov_0.901734_g70237_i0	PRJEB83711	70503	246	0.901734	2.21826564	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	53.1	2.46e-6	NR	MEZ6211741.1	2052180	g70237	i0	86.2	1.08536585365854	29	4	35.4	0	87	1	7	35	MEZ6211741.1 hypothetical protein [Phycisphaerales bacterium]	diamond	267	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27950412	27950412	PRJEB83711_P_NODE_74465_length_244_cov_0.912281_g74199_i0	PRJEB83711	74465	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	70.1	7.51e-12	NR	RLS37057.1	2026780	g74199	i0	45	0.983606557377049	80	44	98.4	0	243	4	116	195	RLS37057.1 MAG: glycine oxidase ThiO [Planctomycetota bacterium]	diamond	240	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28140047	28140047	PRJEB83711_P_NODE_46505_length_274_cov_1.313433_g46239_i0	PRJEB83711	46505	274	1.313433	3.59880642	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.8	0.00422	NR	MCK4960049.1	2026780	g46239	i0	45.2	0.45985401459854	42	23	46	0	4	129	305	346	MCK4960049.1 DUF2184 domain-containing protein [Planctomycetota bacterium]	diamond	126	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28581996	28581996	PRJEB83711_P_NODE_59967_length_252_cov_0.871508_g59701_i0	PRJEB83711	59967	252	0.871508	2.19620016	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	85.1	1.04e-17	NR	MDZ4849558.1	2699754	g59701	i0	72.2	0.642857142857143	54	15	64.3	0	2	163	220	273	MDZ4849558.1 methyltransferase domain-containing protein [Pirellulaceae bacterium]	diamond	162	85.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28763831	28763831	PRJEB83711_P_NODE_69407_length_247_cov_0.896552_g69141_i0	PRJEB83711	69407	247	0.896552	2.21448344	Planctomycetia	203683	Bacteria	Bacteria	82	6.08e-18	NR	MBA4018454.1	117	g69141	i0	50	2.90283400809717	80	39	96	1	246	10	39	118	MBA4018454.1 acyl carrier protein [Pirellula sp.]	diamond	717	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
28771240	28771240	PRJEB83711_P_NODE_72767_length_245_cov_0.906977_g72501_i0	PRJEB83711	72767	245	0.906977	2.22209365	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	112	2.44e-28	NR	HZN69966.1	2876886	g72501	i0	70	0.979591836734694	80	24	98	0	1	240	142	221	HZN69966.1 phosphatase PAP2 family protein [Tepidisphaeraceae bacterium]	diamond	240	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29118853	29118853	PRJEB83711_P_NODE_45449_length_276_cov_1.536946_g45183_i0	PRJEB83711	45449	276	1.536946	4.24197096	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	62.8	4.26e-9	NR	MDB5297458.1	2052180	g45183	i0	83.9	0.33695652173913	31	5	33.7	0	264	172	293	323	MDB5297458.1 hypothetical protein [Phycisphaerales bacterium]	diamond	93	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29434013	29434013	PRJEB83711_P_NODE_55870_length_256_cov_1.196721_g55604_i0	PRJEB83711	55870	256	1.196721	3.06360576	Planctomycetia bacterium	2052181	Bacteria	Bacteria	93.2	1.99e-22	NR	MCI0704660.1	2052181	g55604	i0	75	0.703125	60	15	70.3	0	3	182	45	104	MCI0704660.1 DUF3302 domain-containing protein [Planctomycetia bacterium]	diamond	180	93.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29497461	29497461	PRJEB83711_P_NODE_45650_length_276_cov_1.137931_g45384_i0	PRJEB83711	45650	276	1.137931	3.14068956	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.8	8.78e-7	NR	NDG64821.1	2026780	g45384	i0	38.7	0.815217391304348	75	43	81.5	1	2	226	174	245	NDG64821.1 FAD-dependent thymidylate synthase [Planctomycetota bacterium]	diamond	225	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29521676	29521676	PRJEB83711_P_NODE_42570_length_283_cov_1.085714_g42304_i0	PRJEB83711	42570	283	1.085714	3.07257062	PVC group	1783257	Bacteria	Bacteria	43.5	0.032	NR	MCI0705252.1	2052181	g42304	i0	29.4	2.59717314487632	85	44	75.3	3	19	231	354	436	MCI0705252.1 hypothetical protein [Planctomycetia bacterium]	diamond	735	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
29686627	29686627	PRJEB83711_P_NODE_40090_length_289_cov_1.083333_g39824_i0	PRJEB83711	40090	289	1.083333	3.13083237	Phycisphaera sp.	2030824	Bacteria	Bacteria	43.9	0.0247	NR	MBI1337797.1	2030824	g39824	i0	32.8	0.695501730103806	67	40	69.6	2	81	281	126	187	MBI1337797.1 hypothetical protein [Phycisphaera sp.]	diamond	201	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
29710781	29710781	PRJEB83711_P_NODE_61930_length_251_cov_0.876404_g61664_i0	PRJEB83711	61930	251	0.876404	2.19977404	Aeoliella	2795781	Bacteria	Bacteria	114	3.73e-27	NR	WP_231943665.1	2527972	g61664	i0	61.4	1.9840637450199201	83	32	99.2	0	2	250	882	964	WP_231943665.1 VWA domain-containing protein [Aeoliella mucimassa]	diamond	498	115	0.991304347826087	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
29749787	29749787	PRJEB83711_P_NODE_52031_length_263_cov_1.315789_g51765_i0	PRJEB83711	52031	263	1.315789	3.46052507	Planctomycetota bacterium	2026780	Bacteria	Bacteria	92.8	1.19e-19	NR	HYE05006.1	2026780	g51765	i0	57.1	0.878326996197719	77	30	84.4	1	260	39	804	880	HYE05006.1 Ig-like domain-containing protein [Planctomycetota bacterium]	diamond	231	92.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29876497	29876497	PRJEB83711_P_NODE_40771_length_287_cov_1.443925_g40505_i0	PRJEB83711	40771	287	1.443925	4.14406475	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	127	2.83e-32	NR	HQY89134.1	2876886	g40505	i0	68.8	0.836236933797909	80	25	83.6	0	46	285	10	89	HQY89134.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	240	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30002917	30002917	PRJEB83711_P_NODE_65351_length_249_cov_0.886364_g65085_i0	PRJEB83711	65351	249	0.886364	2.20704636	Planctomycetota bacterium	2026780	Bacteria	Bacteria	84.7	4.9e-17	NR	RLS40201.1	2026780	g65085	i0	64.2	0.807228915662651	67	24	80.7	0	20	220	3	69	RLS40201.1 MAG: ATP-grasp domain-containing protein [Planctomycetota bacterium]	diamond	201	84.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31045730	31045730	PRJEB83711_P_NODE_56215_length_255_cov_1.593407_g55949_i0	PRJEB83711	56215	255	1.593407	4.06318785	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	111	3.0200000000000003e-27	NR	HYO10197.1	2876886	g55949	i0	61.4	0.976470588235294	83	32	97.6	0	255	7	142	224	HYO10197.1 glycosyltransferase family A protein [Tepidisphaeraceae bacterium]	diamond	249	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31227497	31227497	PRJEB83711_P_NODE_45815_length_275_cov_2.306931_g45549_i0	PRJEB83711	45815	275	2.306931	6.34406025	Pseudomonadati	3379134	Bacteria	Bacteria	126	1.7999999999999998e-31	NR	MFI5401704.1	2026780	g45549	i0	62.2	1.95272727272727	90	34	98.2	0	4	273	301	390	MFI5401704.1 UPF0182 family protein [Planctomycetota bacterium]	diamond	537	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31835755	31835755	PRJEB83711_P_NODE_44657_length_278_cov_1.409756_g44391_i0	PRJEB83711	44657	278	1.409756	3.91912168	Phycisphaerales bacterium JB054	3342856	Bacteria	Bacteria	76.3	8.89e-14	NR	MFG0244078.1	3342856	g44391	i0	52.2	0.971223021582734	90	40	97.1	2	9	278	74	160	MFG0244078.1 hypothetical protein [Phycisphaerales bacterium JB054]	diamond	270	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium JB054
31930781	31930781	PRJEB83711_P_NODE_78257_length_242_cov_0.923077_g77991_i0	PRJEB83711	78257	242	0.923077	2.23384634	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	59.3	3.27e-8	NR	MBY0312824.1	2052180	g77991	i0	45.7	1.99586776859504	81	17	99.2	2	242	3	8	62	MBY0312824.1 lipoyl(octanoyl) transferase LipB [Phycisphaerales bacterium]	diamond	483	59.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32721166	32721166	PRJEB83711_P_NODE_63840_length_250_cov_0.881356_g63574_i0	PRJEB83711	63840	250	0.881356	2.20339	Gemmataceae bacterium	2052164	Bacteria	Bacteria	113	8.44e-28	NR	MBX9581558.1	2052164	g63574	i0	65.1	0.996	83	29	99.6	0	249	1	60	142	MBX9581558.1 glycosyltransferase [Gemmataceae bacterium]	diamond	249	113	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);;