metadata: contig_metadata: 18 rows where bioproject = "PRJNA792582", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJNA792582", 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
7155160	7155160	PRJNA792582_P_NODE_13406_length_467_cov_2.672589_g12594_i0	PRJNA792582	13406	467	2.672589	12.48099063	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	361	6.639999999999999e-95	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g12594	i0	80.932	79.6745182012848	472	76	100	13	1	467	2162787	2162325	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	37208	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
15243725	15243725	PRJNA792582_P_NODE_26812_length_333_cov_3.900000_g25998_i0	PRJNA792582	26812	333	3.9	12.987	Luteolibacter	518753	Bacteria	Bacteria	219	2.9199999999999993e-52	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g25998	i0	81.784	155.354354354354	269	41	80	7	1	265	2216378	2216642	Luteolibacter sp. LG18 DNA, complete genome	blastn	51733	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
18628706	18628706	PRJNA792582_P_NODE_52335_length_248_cov_1.760000_g51521_i0	PRJNA792582	52335	248	1.76	4.3648	Opitutales bacterium	2026772	Bacteria	Bacteria	202	2.0999999999999998e-47	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g51521	i0	83.122	266.568548387097	237	24	91	14	4	228	1410556	1410324	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	66109	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
23729817	23729817	PRJNA792582_P_NODE_34419_length_293_cov_2.063636_g33605_i0	PRJNA792582	34419	293	2.063636	6.04645348	Haloferula helveola	490095	Bacteria	Bacteria	82.4	3.47e-11	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g33605	i0	87.5	0.989761092150171	72	7	25	2	140	211	505902	505833	Haloferula helveola CN-1 DNA, complete genome	blastn	290	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
23729867	23729867	PRJNA792582_P_NODE_39079_length_280_cov_1.487923_g38265_i0	PRJNA792582	39079	280	1.487923	4.1661844	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	451	2.18e-122	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g38265	i0	95.714	223.510714285714	280	12	100	0	1	280	1298	1019	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	62583	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
24167173	24167173	PRJNA792582_P_NODE_54619_length_246_cov_0.890173_g53805_i0	PRJNA792582	54619	246	0.890173	2.18982558	Verrucomicrobiales	48461	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g53805	i0	81.569	251.731707317073	255	31	100	14	1	246	3411479	3411726	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	61926	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
25003461	25003461	PRJNA792582_P_NODE_39860_length_278_cov_1.468293_g39046_i0	PRJNA792582	39860	278	1.468293	4.08185454	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	322	1.77e-83	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g39046	i0	88.087	65.4676258992806	277	26	99	6	5	278	277731	277459	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	18200	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
25442090	25442090	PRJNA792582_P_NODE_33040_length_300_cov_1.339207_g32226_i0	PRJNA792582	33040	300	1.339207	4.017621	Opitutaceae	134623	Bacteria	Bacteria	422	1.85e-113	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g32226	i0	92.027	95.2166666666667	301	23	100	1	1	300	2557194	2557494	Lacunisphaera limnophila strain IG16b, complete genome	blastn	28565	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
26642193	26642193	PRJNA792582_P_NODE_47501_length_257_cov_1.467391_g46687_i0	PRJNA792582	47501	257	1.467391	3.77119487	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0445	NR	MBI5692837.1	2026799	g46687	i0	46.5	0.501945525291829	43	20	46.7	1	132	13	229	271	MBI5692837.1 PQQ-binding-like beta-propeller repeat protein [Verrucomicrobiota bacterium]	diamond	129	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28768221	28768221	PRJNA792582_P_NODE_52967_length_248_cov_0.880000_g52153_i0	PRJNA792582	52967	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	46.2	5.57e-4	NR	MBS0628080.1	2026799	g52153	i0	80.8	1.25806451612903	26	5	31.5	0	245	168	85	110	MBS0628080.1 30S ribosomal protein S6 [Verrucomicrobiota bacterium]	diamond	312	46.6	0.991416309012876	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29012051	29012051	PRJNA792582_P_NODE_55468_length_245_cov_0.895349_g54654_i0	PRJNA792582	55468	245	0.895349	2.19360505	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	45.1	0.00563	NR	MDD5198439.1	2832348	g54654	i0	35.6	0.893877551020408	73	42	89.4	2	224	6	264	331	MDD5198439.1 NADH-quinone oxidoreductase subunit H [Terrimicrobiaceae bacterium]	diamond	219	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
29327356	29327356	PRJNA792582_P_NODE_47349_length_257_cov_2.288043_g46535_i0	PRJNA792582	47349	257	2.288043	5.88027051	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	120	1.2699999999999998e-31	NR	HEY4758684.1	2201154	g46535	i0	70.6	1.98443579766537	85	22	95.7	1	254	9	51	135	HEY4758684.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	510	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30053616	30053616	PRJNA792582_P_NODE_44851_length_264_cov_3.068063_g44037_i0	PRJNA792582	44851	264	3.068063	8.09968632	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	150	2.5499999999999994e-42	NR	MBL9168847.1	2026801	g44037	i0	80.5	0.988636363636364	87	17	98.9	0	264	4	167	253	MBL9168847.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	261	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30780457	30780457	PRJNA792582_P_NODE_54414_length_246_cov_1.231214_g53600_i0	PRJNA792582	54414	246	1.231214	3.02878644	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0381	NR	MEI6341235.1	2026799	g53600	i0	36	0.914634146341463	75	39	80.5	2	5	202	84	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	225	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30884420	30884420	PRJNA792582_P_NODE_32134_length_305_cov_1.327586_g31320_i0	PRJNA792582	32134	305	1.327586	4.0491373	Pseudomonadati	3379134	Bacteria	Bacteria	77.4	5.17e-14	NR	MBP7949329.1	2026801	g31320	i0	40	2.97049180327869	100	54	98.4	2	301	2	199	292	MBP7949329.1 peptidase M66 [Verrucomicrobiales bacterium]	diamond	906	77.8	0.994858611825193	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31507674	31507674	PRJNA792582_P_NODE_49196_length_252_cov_1.458101_g48382_i0	PRJNA792582	49196	252	1.458101	3.67441452	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0395	NR	MEO0797149.1	2026799	g48382	i0	40	0.773809523809524	65	37	76.2	2	32	223	289	352	MEO0797149.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	195	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32076917	32076917	PRJNA792582_P_NODE_40858_length_275_cov_2.049505_g40044_i0	PRJNA792582	40858	275	2.049505	5.63613875	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	93.2	1.51e-20	NR	MBS0585478.1	2026799	g40044	i0	50.6	0.949090909090909	87	43	94.9	0	2	262	47	133	MBS0585478.1 deoxyribonuclease IV [Verrucomicrobiota bacterium]	diamond	261	93.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32393340	32393340	PRJNA792582_P_NODE_35419_length_290_cov_1.152074_g34605_i0	PRJNA792582	35419	290	1.152074	3.3410146	Methylacidimicrobium cyclopophantes	1041766	Bacteria	Bacteria	44.7	0.0133	NR	WP_142524394.1	1041766	g34605	i0	43.8	0.496551724137931	48	23	49.7	1	164	21	33	76	WP_142524394.1 ABC transporter permease, partial [Methylacidimicrobium cyclopophantes]	diamond	144	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium cyclopophantes

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