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

30 rows where analysis = "diamond", bioproject = "PRJNA656952" and tax_clade = "PVC group"

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
622398	622398	PRJNA656952_P_NODE_35221_length_248_cov_0.880000_g35034_i0	PRJNA656952	35221	248	0.88	2.1824	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	167	8.47e-46	NR	HLO41002.1	2052180	g35034	i0	92.7	0.991935483870968	82	6	99.2	0	248	3	290	371	HLO41002.1 PSD1 and planctomycete cytochrome C domain-containing protein [Phycisphaerales bacterium]	diamond	246	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
622532	622532	PRJNA656952_P_NODE_41441_length_243_cov_0.905882_g41254_i0	PRJNA656952	41441	243	0.905882	2.20129326	Terrimicrobium sacchariphilum	690879	Bacteria	Bacteria	162	4.82e-45	NR	WP_075077892.1	690879	g41254	i0	93.8	3	81	5	100	0	1	243	225	305	WP_075077892.1 biosynthetic-type acetolactate synthase large subunit [Terrimicrobium sacchariphilum]	diamond	729	162	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
1160010	1160010	PRJNA656952_P_NODE_24761_length_279_cov_1.495146_g24574_i0	PRJNA656952	24761	279	1.495146	4.17145734	Gemmataceae bacterium	2052164	Bacteria	Bacteria	121	9.829999999999999e-30	NR	HTK74860.1	2052164	g24574	i0	64.4	0.967741935483871	90	32	96.8	0	277	8	336	425	HTK74860.1 hypothetical protein [Gemmataceae bacterium]	diamond	270	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
3711876	3711876	PRJNA656952_P_NODE_31683_length_251_cov_0.865169_g31496_i0	PRJNA656952	31683	251	0.865169	2.17157419	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	167	2.39e-50	NR	HLO40943.1	2052180	g31496	i0	95.2	0.99203187250996006	83	4	99.2	0	250	2	41	123	HLO40943.1 carboxyl transferase domain-containing protein [Phycisphaerales bacterium]	diamond	249	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
14651328	14651328	PRJNA656952_P_NODE_33112_length_250_cov_0.870056_g32925_i0	PRJNA656952	33112	250	0.870056	2.17514	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	125	7.61e-33	NR	MEQ1861824.1	2811408	g32925	i0	77.8	2.916	81	18	97.2	0	245	3	122	202	MEQ1861824.1 FtsH protease activity modulator HflK [Chthoniobacteraceae bacterium]	diamond	729	125	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
18474702	18474702	PRJNA656952_P_NODE_35115_length_248_cov_0.880000_g34928_i0	PRJNA656952	35115	248	0.88	2.1824	Gemmata massiliana	1210884	Bacteria	Bacteria	132	1.6e-37	NR	WP_162667600.1	1210884	g34928	i0	75.6	0.991935483870968	82	20	99.2	0	3	248	28	109	WP_162667600.1 response regulator [Gemmata massiliana]	diamond	246	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
26638074	26638074	PRJNA656952_P_NODE_25481_length_276_cov_1.305419_g25294_i0	PRJNA656952	25481	276	1.305419	3.60295644	Opitutaceae bacterium	2006848	Bacteria	Bacteria	186	7.04e-53	NR	HEY1108459.1	2006848	g25294	i0	96.7	2.96739130434783	91	3	98.9	0	274	2	75	165	HEY1108459.1 endonuclease/exonuclease/phosphatase family protein [Opitutaceae bacterium]	diamond	819	186	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
26732774	26732774	PRJNA656952_P_NODE_36301_length_247_cov_0.885057_g36114_i0	PRJNA656952	36301	247	0.885057	2.18609079	Humisphaera sp.	2807514	Bacteria	Bacteria	78.2	3.09e-15	NR	MEA2734762.1	2807514	g36114	i0	45.9	0.898785425101215	74	33	89.9	1	3	224	189	255	MEA2734762.1 hypothetical protein [Humisphaera sp.]	diamond	222	78.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera sp.
26796550	26796550	PRJNA656952_P_NODE_31881_length_251_cov_0.865169_g31694_i0	PRJNA656952	31881	251	0.865169	2.17157419	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	122	2.73e-32	NR	GDX99692.1	2026778	g31694	i0	72.3	0.99203187250996006	83	23	99.2	0	250	2	35	117	GDX99692.1 hypothetical protein LBMAG48_20960 [Phycisphaerae bacterium]	diamond	249	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
26923183	26923183	PRJNA656952_P_NODE_20582_length_301_cov_1.057018_g20395_i0	PRJNA656952	20582	301	1.057018	3.18162418	Puniceicoccales bacterium	2478473	Bacteria	Bacteria	44.7	0.0149	NR	MDR2845148.1	2478473	g20395	i0	42.9	0.558139534883721	56	30	53.8	1	165	4	56	111	MDR2845148.1 ComEC/Rec2 family competence protein [Puniceicoccales bacterium]	diamond	168	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales			Puniceicoccales bacterium
27144118	27144118	PRJNA656952_P_NODE_42642_length_242_cov_0.911243_g42455_i0	PRJNA656952	42642	242	0.911243	2.20520806	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	103	9.53e-27	NR	MDB5333575.1	2052180	g42455	i0	69.4	0.892561983471074	72	19	89.3	1	217	2	1	69	MDB5333575.1 hypothetical protein [Phycisphaerales bacterium]	diamond	216	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27314997	27314997	PRJNA656952_P_NODE_44063_length_241_cov_0.916667_g43876_i0	PRJNA656952	44063	241	0.916667	2.20916747	Opitutaceae	134623	Bacteria	Bacteria	120	9.86e-30	NR	MBA4137518.1	1913982	g43876	i0	76.3	2.98755186721992	80	19	99.6	0	240	1	217	296	MBA4137518.1 anion transporter [Opitutus sp.]	diamond	720	121	0.991735537190083	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
27492205	27492205	PRJNA656952_P_NODE_38723_length_245_cov_0.895349_g38536_i0	PRJNA656952	38723	245	0.895349	2.19360505	Luteolibacter sp. SL25	1962973	Bacteria	Bacteria	87	3.16e-18	NR	WP_267674313.1	2995170	g38536	i0	93	0.52653061224489806	43	3	52.7	0	116	244	111	153	WP_267674313.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Luteolibacter sp. SL250]	diamond	129	87	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
27744985	27744985	PRJNA656952_P_NODE_32644_length_250_cov_0.870056_g32457_i0	PRJNA656952	32644	250	0.870056	2.17514	Pirellula sp.	117	Bacteria	Bacteria	142	4.92e-37	NR	MBA4106471.1	117	g32457	i0	96.3	0.984	82	3	98.4	0	248	3	460	541	MBA4106471.1 hybrid sensor histidine kinase/response regulator [Pirellula sp.]	diamond	246	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
29304032	29304032	PRJNA656952_P_NODE_42869_length_242_cov_0.911243_g42682_i0	PRJNA656952	42869	242	0.911243	2.20520806	Candidatus Didemnitutus	2055839	Bacteria	Bacteria	129	3.05e-34	NR	MEI6108204.1	2026771	g42682	i0	72.5	6.94214876033058	80	22	99.2	0	2	241	203	282	MEI6108204.1 N-acetylmuramoyl-L-alanine amidase [Opitutia bacterium]	diamond	1680	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
29323297	29323297	PRJNA656952_P_NODE_40949_length_243_cov_0.905882_g40762_i0	PRJNA656952	40949	243	0.905882	2.20129326	Prosthecobacter sp.	1965333	Bacteria	Bacteria	67.8	1.35e-12	NR	HEY1081890.1	1965333	g40762	i0	91.2	0.419753086419753	34	3	42	0	237	136	49	82	HEY1081890.1 hypothetical protein [Prosthecobacter sp.]	diamond	102	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
29670372	29670372	PRJNA656952_P_NODE_31950_length_251_cov_0.865169_g31763_i0	PRJNA656952	31950	251	0.865169	2.17157419	Luteolibacter sp. SL25	1962973	Bacteria	Bacteria	154	1.38e-41	NR	WP_267670606.1	2995170	g31763	i0	85.5	0.99203187250996006	83	12	99.2	0	2	250	60	142	WP_267670606.1 FG-GAP repeat domain-containing protein [Luteolibacter sp. SL250]	diamond	249	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
30649818	30649818	PRJNA656952_P_NODE_26913_length_270_cov_0.903553_g26726_i0	PRJNA656952	26913	270	0.903553	2.4395931	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.0378	NR	MBJ76935.1	2026780	g26726	i0	41.5	0.588888888888889	53	31	58.9	0	111	269	659	711	MBJ76935.1 hypothetical protein [Planctomycetota bacterium]	diamond	159	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30681423	30681423	PRJNA656952_P_NODE_39253_length_245_cov_0.895349_g39066_i0	PRJNA656952	39253	245	0.895349	2.19360505	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	164	1.8999999999999998e-47	NR	HLP85146.1	2052180	g39066	i0	95.1	0.991836734693878	81	4	99.2	0	3	245	103	183	HLP85146.1 hypothetical protein [Phycisphaerales bacterium]	diamond	243	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30744867	30744867	PRJNA656952_P_NODE_37634_length_246_cov_0.890173_g37447_i0	PRJNA656952	37634	246	0.890173	2.18982558	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	124	1.08e-31	NR	MDX1967521.1	2026779	g37447	i0	98.5	2.48780487804878	68	1	82.9	0	245	42	330	397	MDX1967521.1 phosphoglycerate kinase [Planctomycetaceae bacterium]	diamond	612	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30776528	30776528	PRJNA656952_P_NODE_22394_length_290_cov_1.419355_g22207_i0	PRJNA656952	22394	290	1.419355	4.1161295	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	47.4	9.44e-4	NR	MDD5704343.1	2212473	g22207	i0	35.6	0.9	87	55	90	1	261	1	7	92	MDD5704343.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	261	47.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
30776530	30776530	PRJNA656952_P_NODE_33254_length_250_cov_0.870056_g33067_i0	PRJNA656952	33254	250	0.870056	2.17514	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	135	1.19e-37	NR	MEQ1858400.1	2811408	g33067	i0	84.1	0.984	82	13	98.4	0	248	3	116	197	MEQ1858400.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	246	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
30808047	30808047	PRJNA656952_P_NODE_41794_length_243_cov_0.905882_g41607_i0	PRJNA656952	41794	243	0.905882	2.20129326	Prosthecobacter sp.	1965333	Bacteria	Bacteria	132	1.06e-36	NR	HEY1048628.1	1965333	g41607	i0	100	0.790123456790123	64	0	79	0	51	242	1	64	HEY1048628.1 tRNA adenosine(34) deaminase TadA [Prosthecobacter sp.]	diamond	192	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30934519	30934519	PRJNA656952_P_NODE_35374_length_248_cov_0.880000_g35187_i0	PRJNA656952	35374	248	0.88	2.1824	Prosthecobacter sp.	1965333	Bacteria	Bacteria	157	1.47e-42	NR	HEY1080616.1	1965333	g35187	i0	90.2	0.991935483870968	82	8	99.2	0	1	246	447	528	HEY1080616.1 DUF1553 domain-containing protein [Prosthecobacter sp.]	diamond	246	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31503611	31503611	PRJNA656952_P_NODE_37336_length_246_cov_0.890173_g37149_i0	PRJNA656952	37336	246	0.890173	2.18982558	Chlamydia psittaci	83554	Bacteria	Bacteria	84.7	1.45e-19	NR	EPP29557.1	1112246	g37149	i0	98.6	1.29268292682927	69	1	84.1	0	40	246	1	69	EPP29557.1 putative membrane protein [Chlamydia psittaci 08-2626_L3]	diamond	318	84.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
31693184	31693184	PRJNA656952_P_NODE_36397_length_247_cov_0.885057_g36210_i0	PRJNA656952	36397	247	0.885057	2.18609079	Opitutus sp.	1913982	Bacteria	Bacteria	104	2.7e-26	NR	MBA4138563.1	1913982	g36210	i0	65.1	1.0080971659919	83	27	98.4	1	3	245	34	116	MBA4138563.1 hypothetical protein [Opitutus sp.]	diamond	249	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
31787935	31787935	PRJNA656952_P_NODE_31617_length_251_cov_0.865169_g31430_i0	PRJNA656952	31617	251	0.865169	2.17157419	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	147	3.57e-39	NR	MBI5800124.1	2026799	g31430	i0	91.6	0.99203187250996006	83	7	99.2	0	2	250	60	142	MBI5800124.1 tetratricopeptide repeat-containing sensor histidine kinase [Verrucomicrobiota bacterium]	diamond	249	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32041277	32041277	PRJNA656952_P_NODE_33118_length_250_cov_0.870056_g32931_i0	PRJNA656952	33118	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	119	3.67e-29	NR	MFH1499404.1	2026799	g32931	i0	71.1	0.996	83	24	99.6	0	1	249	411	493	MFH1499404.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	249	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32136245	32136245	PRJNA656952_P_NODE_33998_length_249_cov_0.875000_g33811_i0	PRJNA656952	33998	249	0.875	2.17875	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	85.1	3.36e-17	NR	HLP84061.1	2052180	g33811	i0	51.4	0.843373493975904	70	34	84.3	0	37	246	173	242	HLP84061.1 hypothetical protein [Phycisphaerales bacterium]	diamond	210	85.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32560023	32560023	PRJNA656952_P_NODE_42979_length_242_cov_0.911243_g42792_i0	PRJNA656952	42979	242	0.911243	2.20520806	Gemmata	113	Bacteria	Bacteria	87.4	4.64e-19	NR	MBM3982944.1	2026780	g42792	i0	58.3	6.47107438016529	84	31	99.2	1	241	2	134	217	MBM3982944.1 sigma-70 family RNA polymerase sigma factor [Planctomycetota bacterium]	diamond	1566	87.4	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);;