metadata: contig_metadata: 26 rows where bioproject = "PRJNA811237", tax_clade = "PVC group" and tax

26 rows where bioproject = "PRJNA811237", 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
2084499	2084499	PRJNA811237_S_NODE_27622_length_167_cov_0.864407_g27382_i0	PRJNA811237	27622	167	0.864407	1.44355969	Terrimicrobium	1649503	Bacteria	Bacteria	70.5	2.18e-12	NR	WP_075080344.1	690879	g27382	i0	66.7	3.44910179640719	48	16	86.2	0	145	2	609	656	WP_075080344.1 glycoside hydrolase family 9 protein [Terrimicrobium sacchariphilum]	diamond	576	70.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
2499071	2499071	PRJNA811237_S_NODE_15002_length_210_cov_0.950311_g14762_i0	PRJNA811237	15002	210	0.950311	1.9956531	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	109	8.680000000000001e-26	NR	MDX2110087.1	2026799	g14762	i0	79.7	6.94285714285714	69	14	98.6	0	207	1	371	439	MDX2110087.1 transketolase [Verrucomicrobiota bacterium]	diamond	1458	109	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26610887	26610887	PRJNA811237_S_NODE_561_length_908_cov_2.703143_g387_i0	PRJNA811237	561	908	2.703143	24.54453844	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	175	1.78e-46	NR	HYG84357.1	2499141	g387	i0	54.5	0.631057268722467	191	81	61.8	4	35	595	90	278	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	573	175	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26927666	26927666	PRJNA811237_S_NODE_13762_length_216_cov_1.934132_g13522_i0	PRJNA811237	13762	216	1.934132	4.17772512	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	60.5	1.42e-8	NR	MBP7951221.1	2026801	g13522	i0	41.7	2.44444444444444	60	35	83.3	0	212	33	409	468	MBP7951221.1 UTP--glucose-1-phosphate uridylyltransferase [Verrucomicrobiales bacterium]	diamond	528	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28380690	28380690	PRJNA811237_S_NODE_4386_length_346_cov_1.101010_g4146_i0	PRJNA811237	4386	346	1.10101	3.8094946	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	87.8	8.44e-18	NR	MCU0750558.1	2562705	g4146	i0	69.8	2.17630057803468	63	19	54.6	0	3	191	293	355	MCU0750558.1 alkene reductase [Akkermansiaceae bacterium]	diamond	753	87.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
28475478	28475478	PRJNA811237_S_NODE_9486_length_248_cov_1.537688_g9246_i0	PRJNA811237	9486	248	1.537688	3.81346624	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	57.8	1.98e-7	NR	HYG84357.1	2499141	g9246	i0	44.9	0.834677419354839	69	38	83.5	0	223	17	194	262	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	207	57.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28507074	28507074	PRJNA811237_S_NODE_4147_length_357_cov_1.788961_g3907_i0	PRJNA811237	4147	357	1.788961	6.38659077	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	80.1	1.1e-14	NR	HYG84357.1	2499141	g3907	i0	39.8	1.89915966386555	113	66	93.3	1	1	333	412	524	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	678	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28728053	28728053	PRJNA811237_S_NODE_36147_length_158_cov_2.165138_g35907_i0	PRJNA811237	36147	158	2.165138	3.42091804	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	51.2	8.67e-7	NR	MBV8376154.1	2026799	g35907	i0	55.6	1.5379746835443	45	20	85.4	0	136	2	4	48	MBV8376154.1 PUR family DNA/RNA-binding protein [Verrucomicrobiota bacterium]	diamond	243	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29233346	29233346	PRJNA811237_S_NODE_6769_length_285_cov_1.652542_g6529_i0	PRJNA811237	6769	285	1.652542	4.7097447	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	68.9	3.67e-11	NR	HYG84357.1	2499141	g6529	i0	46.3	1.68421052631579	80	43	84.2	0	251	12	338	417	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	480	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29264603	29264603	PRJNA811237_S_NODE_29169_length_166_cov_0.871795_g28929_i0	PRJNA811237	29169	166	0.871795	1.4471797	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	48.1	1.64e-4	NR	HUA58568.1	2499141	g28929	i0	41.2	4.2289156626506	51	29	90.4	1	4	153	6	56	HUA58568.1 dTDP-4-amino-4,6-dideoxygalactose transaminase [Verrucomicrobiia bacterium]	diamond	702	48.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29273400	29273400	PRJNA811237_S_NODE_8569_length_258_cov_1.602871_g8329_i0	PRJNA811237	8569	258	1.602871	4.13540718	Bacteria	2	Bacteria	Bacteria	50.1	1.15e-4	NR	MEL0117385.1	2026771	g8329	i0	31.3	4.84883720930233	83	55	96.5	1	253	5	392	472	MEL0117385.1 hypothetical protein [Opitutia bacterium]	diamond	1251	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
29422428	29422428	PRJNA811237_S_NODE_14389_length_213_cov_1.079268_g14149_i0	PRJNA811237	14389	213	1.079268	2.29884084	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	45.1	0.0038	NR	HYG84357.1	2499141	g14149	i0	43.9	0.802816901408451	57	32	80.3	0	209	39	435	491	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	171	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29453852	29453852	PRJNA811237_S_NODE_29450_length_166_cov_0.871795_g29210_i0	PRJNA811237	29450	166	0.871795	1.4471797	Akkermansia sp.	1872421	Bacteria	Bacteria	47.4	2.99e-4	NR	MDO4411406.1	1872421	g29210	i0	51.9	0.975903614457831	54	26	97.6	0	164	3	531	584	MDO4411406.1 DNA topoisomerase 3 [Akkermansia sp.]	diamond	162	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
29548725	29548725	PRJNA811237_S_NODE_12610_length_223_cov_1.465517_g12370_i0	PRJNA811237	12610	223	1.465517	3.26810291	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	92.8	2.04e-20	NR	RYD65414.1	2026800	g12370	i0	67.1	0.982062780269058	73	22	98.2	1	222	4	169	239	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	219	92.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30307510	30307510	PRJNA811237_S_NODE_20272_length_188_cov_1.618705_g20032_i0	PRJNA811237	20272	188	1.618705	3.0431654	Opitutia bacterium	2026771	Bacteria	Bacteria	63.5	8.12e-10	NR	MBI2513926.1	2026771	g20032	i0	53.7	1.83510638297872	54	25	86.2	0	162	1	9	62	MBI2513926.1 YHYH protein [Opitutia bacterium]	diamond	345	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
30654451	30654451	PRJNA811237_S_NODE_35153_length_161_cov_0.910714_g34913_i0	PRJNA811237	35153	161	0.910714	1.46624954	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	65.9	8.5e-11	NR	MEY2545004.1	2026799	g34913	i0	63.5	2.90683229813665	52	19	96.9	0	161	6	735	786	MEY2545004.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	468	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31074201	31074201	PRJNA811237_S_NODE_9055_length_253_cov_1.495098_g8815_i0	PRJNA811237	9055	253	1.495098	3.78259794	Verrucomicrobiota	74201	Bacteria	Bacteria	68.2	3.5e-11	NR	MDE1170842.1	72225	g8815	i0	54.7	4.80237154150198	64	28	75.9	1	62	253	7	69	MDE1170842.1 2-enoyl thioester reductase domain-containing protein [Verrucomicrobium sp.]	diamond	1215	68.6	0.994169096209913	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp.
31159704	31159704	PRJNA811237_S_NODE_26275_length_170_cov_1.223140_g26035_i0	PRJNA811237	26275	170	1.22314	2.079338	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	46.6	6.05e-4	NR	HYV20656.1	2499141	g26035	i0	51.2	0.723529411764706	41	16	68.8	2	49	165	118	156	HYV20656.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	123	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31602969	31602969	PRJNA811237_S_NODE_32416_length_163_cov_1.166667_g32176_i0	PRJNA811237	32416	163	1.166667	1.90166721	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	41.6	0.03	NR	MBJ7392643.1	2201154	g32176	i0	40.4	0.957055214723926	52	27	93.9	2	9	161	10	58	MBJ7392643.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	156	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31855813	31855813	PRJNA811237_S_NODE_19537_length_191_cov_1.077465_g19297_i0	PRJNA811237	19537	191	1.077465	2.05795815	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	67.8	2.7e-11	NR	HZC36900.1	2201154	g19297	i0	58.1	6.87958115183246	62	26	97.4	0	3	188	86	147	HZC36900.1 sugar porter family MFS transporter [Chthoniobacterales bacterium]	diamond	1314	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31887456	31887456	PRJNA811237_S_NODE_5177_length_320_cov_1.059041_g4937_i0	PRJNA811237	5177	320	1.059041	3.3889312	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	63.5	4.7e-9	NR	MEY4916642.1	2026799	g4937	i0	45.6	0.740625	79	39	73.1	3	17	250	692	767	MEY4916642.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	237	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32393825	32393825	PRJNA811237_S_NODE_26799_length_168_cov_1.924370_g26559_i0	PRJNA811237	26799	168	1.92437	3.2329416	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	41.6	0.0327	NR	NNC90263.1	2562705	g26559	i0	44	1.78571428571429	50	27	87.5	1	15	161	154	203	NNC90263.1 TolC family protein [Akkermansiaceae bacterium]	diamond	300	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32709382	32709382	PRJNA811237_S_NODE_11780_length_228_cov_3.217877_g11540_i0	PRJNA811237	11780	228	3.217877	7.33675956	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	130	9.06e-35	NR	RYD65414.1	2026800	g11540	i0	77.3	0.986842105263158	75	17	98.7	0	3	227	237	311	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	225	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32741106	32741106	PRJNA811237_S_NODE_28260_length_167_cov_0.864407_g28020_i0	PRJNA811237	28260	167	0.864407	1.44355969	Luteolibacter sp.	1962973	Bacteria	Bacteria	50.1	3.42e-5	NR	MEO5715941.1	1962973	g28020	i0	46.2	1.83233532934132	52	28	93.4	0	157	2	88	139	MEO5715941.1 MFS transporter [Luteolibacter sp.]	diamond	306	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
32866854	32866854	PRJNA811237_S_NODE_17500_length_199_cov_1.140000_g17260_i0	PRJNA811237	17500	199	1.14	2.2686	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	42.7	0.0202	NR	MFL6529243.1	2201154	g17260	i0	36.4	1.32663316582915	44	28	66.3	0	3	134	192	235	MFL6529243.1 chromate efflux transporter [Chthoniobacterales bacterium]	diamond	264	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32898251	32898251	PRJNA811237_S_NODE_6720_length_286_cov_1.468354_g6480_i0	PRJNA811237	6720	286	1.468354	4.19949244	Opitutia bacterium	2026771	Bacteria	Bacteria	56.2	1.05e-6	NR	MBT3540390.1	2026771	g6480	i0	28.7	3.9965034965035	94	65	98.6	1	3	284	283	374	MBT3540390.1 hypothetical protein [Opitutia bacterium]	diamond	1143	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia 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);;