metadata: contig_metadata: 21 rows where bioproject = "PRJNA800053", tax_clade = "PVC group" and tax

21 rows where bioproject = "PRJNA800053", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

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
3347199	3347199	PRJNA800053_P_NODE_14103_length_272_cov_1.070352_g13939_i0	PRJNA800053	14103	272	1.070352	2.91135744	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	307	4.8200000000000006e-79	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g13939	i0	87.361	219.202205882353	269	32	99	2	1	269	913079	913345	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	59623	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8873035	8873035	PRJNA800053_P_NODE_14167_length_271_cov_1.555556_g14003_i0	PRJNA800053	14167	271	1.555556	4.21555676	Opitutaceae bacterium	2006848	Bacteria	Bacteria	96.3	1.4e-21	NR	MBC8010549.1	2006848	g14003	i0	97.9	0.531365313653137	48	1	53.1	0	269	126	268	315	MBC8010549.1 phosphatase [Opitutaceae bacterium]	diamond	144	96.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
25022828	25022828	PRJNA800053_P_NODE_21160_length_245_cov_0.895349_g20996_i0	PRJNA800053	21160	245	0.895349	2.19360505	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	263	9.38e-66	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g20996	i0	86.122	2.43265306122449	245	32	99	2	2	245	1012623	1012866	Luteolibacter sp. Populi chromosome, complete genome	blastn	596	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
26832589	26832589	PRJNA800053_P_NODE_16281_length_257_cov_1.663043_g16117_i0	PRJNA800053	16281	257	1.663043	4.27402051	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	108	7.079999999999999e-28	NR	MES2597201.1	2026799	g16117	i0	60.7	1.9727626459144	84	33	98.1	0	3	254	59	142	MES2597201.1 CHAP domain-containing protein [Verrucomicrobiota bacterium]	diamond	507	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26864528	26864528	PRJNA800053_P_NODE_12821_length_281_cov_1.197115_g12657_i0	PRJNA800053	12821	281	1.197115	3.36389315	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	64.7	8.9e-10	NR	MEO7933197.1	2201154	g12657	i0	48.8	0.875444839857651	82	42	87.5	0	12	257	53	134	MEO7933197.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	246	64.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
26927499	26927499	PRJNA800053_P_NODE_23482_length_241_cov_1.678571_g23318_i0	PRJNA800053	23482	241	1.678571	4.04535611	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	132	7.489999999999999e-37	NR	MDB6136024.1	2026801	g23318	i0	74.4	5.78838174273859	78	20	97.1	0	6	239	65	142	MDB6136024.1 ErfK/YbiS/YcfS/YnhG family protein [Verrucomicrobiales bacterium]	diamond	1395	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27370460	27370460	PRJNA800053_P_NODE_12803_length_281_cov_1.302885_g12639_i0	PRJNA800053	12803	281	1.302885	3.66110685	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	77.8	2.59e-15	NR	HEY4281466.1	2201154	g12639	i0	56	0.896797153024911	84	31	83.3	3	2	235	86	169	HEY4281466.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	252	77.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27591390	27591390	PRJNA800053_P_NODE_22344_length_243_cov_0.905882_g22180_i0	PRJNA800053	22344	243	0.905882	2.20129326	Opitutaceae bacterium	2006848	Bacteria	Bacteria	47.8	5.52e-5	NR	MDP3072361.1	2006848	g22180	i0	76.9	0.320987654320988	26	6	32.1	0	240	163	43	68	MDP3072361.1 helix-turn-helix domain-containing protein [Opitutaceae bacterium]	diamond	78	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28664756	28664756	PRJNA800053_P_NODE_18247_length_250_cov_0.870056_g18083_i0	PRJNA800053	18247	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	80.1	1.36e-17	NR	MBM3877705.1	2026799	g18083	i0	62.3	0.636	53	20	63.6	0	86	244	3	55	MBM3877705.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	159	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28989640	28989640	PRJNA800053_P_NODE_17928_length_250_cov_1.242938_g17764_i0	PRJNA800053	17928	250	1.242938	3.107345	root	1	Root_unresolved	Root_unresolved	53.5	6.05e-6	NR	HEU5080702.1	2006848	g17764	i0	61	1.272	41	16	49.2	0	3	125	402	442	HEU5080702.1 hypothetical protein [Opitutaceae bacterium]	diamond	318	53.9	0.992578849721707	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29264407	29264407	PRJNA800053_P_NODE_19529_length_248_cov_0.880000_g19365_i0	PRJNA800053	19529	248	0.88	2.1824	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	67	1.53e-12	NR	MDQ5978806.1	2026799	g19365	i0	55.9	0.82258064516129	68	30	82.3	0	211	8	1	68	MDQ5978806.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	204	67	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29485361	29485361	PRJNA800053_P_NODE_20870_length_245_cov_2.343023_g20706_i0	PRJNA800053	20870	245	2.343023	5.74040635	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	53.1	7.76e-6	NR	MCX8510204.1	2811408	g20706	i0	35	0.979591836734694	80	46	98	3	3	242	158	231	MCX8510204.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	240	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
29674722	29674722	PRJNA800053_P_NODE_17130_length_252_cov_1.351955_g16966_i0	PRJNA800053	17130	252	1.351955	3.4069266	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	65.9	3e-11	NR	HRI13986.1	2026799	g16966	i0	45.1	1.95238095238095	82	45	97.6	0	2	247	33	114	HRI13986.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	492	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30685838	30685838	PRJNA800053_P_NODE_18933_length_249_cov_0.875000_g18769_i0	PRJNA800053	18933	249	0.875	2.17875	Prosthecobacter sp.	1965333	Bacteria	Bacteria	107	2.86e-25	NR	MDP1591951.1	1965333	g18769	i0	63.4	0.987951807228916	82	30	98.8	0	3	248	243	324	MDP1591951.1 tRNA lysidine(34) synthetase TilS [Prosthecobacter sp.]	diamond	246	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30875547	30875547	PRJNA800053_P_NODE_20154_length_247_cov_0.885057_g19990_i0	PRJNA800053	20154	247	0.885057	2.18609079	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	83.6	4.44e-17	NR	HWL54283.1	2811408	g19990	i0	52.7	0.898785425101215	74	35	89.9	0	17	238	82	155	HWL54283.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	222	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
31010825	31010825	PRJNA800053_P_NODE_12654_length_282_cov_1.440191_g12490_i0	PRJNA800053	12654	282	1.440191	4.06133862	Pseudomonadati	3379134	Bacteria	Bacteria	115	1.2e-28	NR	WP_395735065.1	1965333	g12490	i0	56	1.93617021276596	91	40	96.8	0	275	3	107	197	WP_395735065.1 integron integrase [Prosthecobacter sp.]	diamond	546	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31136981	31136981	PRJNA800053_P_NODE_20695_length_246_cov_0.890173_g20531_i0	PRJNA800053	20695	246	0.890173	2.18982558	PVC group	1783257	Bacteria	Bacteria	73.2	7.34e-13	NR	MFO1514118.1	2026799	g20531	i0	57.1	2.64634146341463	70	29	84.1	1	220	14	839	908	MFO1514118.1 DUF1349 domain-containing protein [Verrucomicrobiota bacterium]	diamond	651	73.9	0.990527740189445	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31665825	31665825	PRJNA800053_P_NODE_22877_length_242_cov_1.479290_g22713_i0	PRJNA800053	22877	242	1.47929	3.5798818	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	73.2	2.25e-13	NR	MBI2948829.1	2026799	g22713	i0	85	0.991735537190083	40	6	49.6	0	239	120	158	197	MBI2948829.1 sigma-70 family RNA polymerase sigma factor [Verrucomicrobiota bacterium]	diamond	240	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31982162	31982162	PRJNA800053_P_NODE_12918_length_280_cov_1.705314_g12754_i0	PRJNA800053	12918	280	1.705314	4.7748792	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	89.4	6.37e-19	NR	MBA3761753.1	2201154	g12754	i0	55.7	0.942857142857143	88	37	93.2	2	13	273	113	199	MBA3761753.1 metallophosphoesterase [Chthoniobacterales bacterium]	diamond	264	89.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32371099	32371099	PRJNA800053_P_NODE_18439_length_249_cov_1.732955_g18275_i0	PRJNA800053	18439	249	1.732955	4.31505795	Bacteria	2	Bacteria	Bacteria	101	7.6e-23	NR	PAW63515.1	1982332	g18275	i0	63.2	1.83132530120482	76	27	91.6	1	6	233	425	499	PAW63515.1 MAG: kinase [Verrucomicrobiia bacterium Tous-C4TDCM]	diamond	456	102	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium Tous-C4TDCM
32677588	32677588	PRJNA800053_P_NODE_13380_length_277_cov_1.269608_g13216_i0	PRJNA800053	13380	277	1.269608	3.51681416	Luteolibacter sp.	1962973	Bacteria	Bacteria	57.4	4.08e-7	NR	MFT3992457.1	1962973	g13216	i0	42	1.70036101083032	81	41	81.2	3	231	7	572	652	MFT3992457.1 hypothetical protein [Luteolibacter sp.]	diamond	471	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.

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