metadata: contig_metadata: 17 rows where bioproject = "PRJNA752572", tax_clade = "PVC group" and tax

17 rows where bioproject = "PRJNA752572", 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
14757510	14757510	PRJNA752572_P_NODE_242372_length_171_cov_0.970588_g241865_i0	PRJNA752572	242372	171	0.970588	1.65970548	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	182	1.75e-41	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g241865	i0	90.58	7.80701754385965	138	12	81	1	16	153	2162687	2162551	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	1335	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
26957781	26957781	PRJNA752572_P_NODE_4342_length_1120_cov_3.436866_g4131_i0	PRJNA752572	4342	1120	3.436866	38.4928992	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	195	4.84e-53	NR	HYG84357.1	2499141	g4131	i0	44.9	0.728571428571429	272	144	72.1	4	915	109	19	287	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	816	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27463799	27463799	PRJNA752572_P_NODE_174463_length_202_cov_1.700599_g173956_i0	PRJNA752572	174463	202	1.700599	3.43520998	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	46.6	9.6e-4	NR	HYG84357.1	2499141	g173956	i0	40.3	1.99009900990099	67	40	99.5	0	1	201	360	426	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	402	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27600028	27600028	PRJNA752572_P_NODE_251684_length_168_cov_1.496241_g251177_i0	PRJNA752572	251684	168	1.496241	2.51368488	Bacteria	2	Bacteria	Bacteria	65.9	9.63e-11	NR	MEM8954453.1	2026799	g251177	i0	53.6	2.96428571428571	56	26	100	0	1	168	99	154	MEM8954453.1 SIS domain-containing protein [Verrucomicrobiota bacterium]	diamond	498	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27621700	27621700	PRJNA752572_P_NODE_45404_length_406_cov_1.787062_g44899_i0	PRJNA752572	45404	406	1.787062	7.25547172	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	123	3.57e-32	NR	MFL6530683.1	2201154	g44899	i0	47.2	9.18472906403941	127	67	93.8	0	403	23	83	209	MFL6530683.1 2-oxoglutarate dehydrogenase E1 component [Chthoniobacterales bacterium]	diamond	3729	123	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28189647	28189647	PRJNA752572_P_NODE_30206_length_496_cov_3.353579_g29720_i0	PRJNA752572	30206	496	3.353579	16.63375184	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	175	2.25e-48	NR	HYG84357.1	2499141	g29720	i0	66.7	1.63911290322581	141	46	85.3	1	488	66	388	527	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	813	175	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28632133	28632133	PRJNA752572_P_NODE_34947_length_462_cov_4.229508_g34451_i0	PRJNA752572	34947	462	4.229508	19.54032696	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	70.9	4.65e-11	NR	HEX2748794.1	2026801	g34451	i0	44	2.46103896103896	109	53	66.9	4	377	69	271	377	HEX2748794.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	1137	70.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28663580	28663580	PRJNA752572_P_NODE_55307_length_368_cov_1.420420_g54800_i0	PRJNA752572	55307	368	1.42042	5.2271456	Opitutia bacterium	2026771	Bacteria	Bacteria	62	2.59e-8	NR	HAE11661.1	2026771	g54800	i0	32	4.09239130434783	128	69	97.8	4	8	367	155	272	HAE11661.1 hypothetical protein [Opitutia bacterium]	diamond	1506	62	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
29137366	29137366	PRJNA752572_P_NODE_237289_length_172_cov_1.474453_g236782_i0	PRJNA752572	237289	172	1.474453	2.53605916	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	55.5	4.49e-7	NR	HYG84357.1	2499141	g236782	i0	48.2	0.976744186046512	56	28	97.7	1	170	3	126	180	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	168	55.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30210611	30210611	PRJNA752572_P_NODE_223172_length_177_cov_2.225352_g222665_i0	PRJNA752572	223172	177	2.225352	3.93887304	Opitutaceae bacterium	2006848	Bacteria	Bacteria	66.6	3.01e-11	NR	MBE2212973.1	2006848	g222665	i0	63.4	2.08474576271186	41	15	69.5	0	2	124	21	61	MBE2212973.1 thioredoxin [Opitutaceae bacterium]	diamond	369	66.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30432424	30432424	PRJNA752572_P_NODE_276233_length_162_cov_1.181102_g275726_i0	PRJNA752572	276233	162	1.181102	1.91338524	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	77.8	2.52e-16	NR	MAH13224.1	2026799	g275726	i0	68.8	0.888888888888889	48	15	88.9	0	9	152	113	160	MAH13224.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	144	77.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30748018	30748018	PRJNA752572_P_NODE_94014_length_279_cov_1.963115_g93507_i0	PRJNA752572	94014	279	1.963115	5.47709085	Pedosphaera sp.	2024890	Bacteria	Bacteria	96.3	8.75e-21	NR	MDB6123053.1	2024890	g93507	i0	66.7	13.1505376344086	72	21	77.4	1	218	3	345	413	MDB6123053.1 glycine dehydrogenase [Pedosphaera sp.]	diamond	3669	96.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
31253516	31253516	PRJNA752572_P_NODE_137895_length_228_cov_1.839378_g137388_i0	PRJNA752572	137895	228	1.839378	4.19378184	Opitutales bacterium	2026772	Bacteria	Bacteria	55.1	1.39e-6	NR	MDG2170390.1	2026772	g137388	i0	44.4	1.89473684210526	72	34	88.2	2	1	201	299	369	MDG2170390.1 hypothetical protein [Opitutales bacterium]	diamond	432	55.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
31411760	31411760	PRJNA752572_P_NODE_89576_length_286_cov_2.637450_g89069_i0	PRJNA752572	89576	286	2.63745	7.543107	Opitutaceae bacterium	2006848	Bacteria	Bacteria	50.8	8.49e-5	NR	MEJ6601053.1	2006848	g89069	i0	38.5	0.954545454545455	91	48	91.3	3	274	14	144	230	MEJ6601053.1 sulfite reductase subunit alpha [Opitutaceae bacterium]	diamond	273	50.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32519237	32519237	PRJNA752572_P_NODE_258479_length_166_cov_2.129771_g257972_i0	PRJNA752572	258479	166	2.129771	3.53541986	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	42	0.0256	NR	MBL9136815.1	2026801	g257972	i0	37	0.975903614457831	54	34	97.6	0	2	163	1577	1630	MBL9136815.1 S8 family serine peptidase [Verrucomicrobiales bacterium]	diamond	162	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32550916	32550916	PRJNA752572_P_NODE_278499_length_161_cov_2.103175_g277992_i0	PRJNA752572	278499	161	2.103175	3.38611175	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	57.8	4.06e-8	NR	MEY4482797.1	2026799	g277992	i0	60.8	8.49689440993789	51	14	95	2	155	3	25	69	MEY4482797.1 ADP-forming succinate--CoA ligase subunit beta [Verrucomicrobiota bacterium]	diamond	1368	57.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32582336	32582336	PRJNA752572_P_NODE_276739_length_162_cov_1.039370_g276232_i0	PRJNA752572	276739	162	1.03937	1.6837794	Prosthecobacter sp.	1965333	Bacteria	Bacteria	110	1.53e-27	NR	WP_397379307.1	1965333	g276232	i0	92.5	0.981481481481482	53	4	98.1	0	2	160	116	168	WP_397379307.1 phosphotransferase family protein [Prosthecobacter sp.]	diamond	159	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter 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);;