metadata: contig_metadata: 20 rows where bioproject = "PRJNA944150", tax_clade = "PVC group" and tax

20 rows where bioproject = "PRJNA944150", 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
3474331	3474331	PRJNA944150_P_NODE_24003_length_188_cov_2.172662_g23752_i0	PRJNA944150	24003	188	2.172662	4.08460456	Terrimicrobium sacchariphilum	690879	Bacteria	Bacteria	136	4.47e-36	NR	WP_075081381.1	690879	g23752	i0	100	0.98936170212766	62	0	98.9	0	188	3	258	319	WP_075081381.1 malate dehydrogenase (quinone) [Terrimicrobium sacchariphilum]	diamond	186	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
7301577	7301577	PRJNA944150_P_NODE_19986_length_199_cov_2.806667_g19735_i0	PRJNA944150	19986	199	2.806667	5.58526733	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	126	1e-24	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g19735	i0	88.462	1.60301507537688	104	12	52	0	1	104	1273807	1273704	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	319	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
9851580	9851580	PRJNA944150_P_NODE_23728_length_189_cov_1.228571_g23477_i0	PRJNA944150	23728	189	1.228571	2.32199919	Congregicoccus parvus	3081749	Bacteria	Bacteria	322	1.12e-83	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g23477	i0	97.354	1	189	5	100	0	1	189	2913107	2913295	Opitutales bacterium ASA1 DNA, complete genome	blastn	189	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
27436345	27436345	PRJNA944150_P_NODE_38263_length_165_cov_2.293103_g38012_i0	PRJNA944150	38263	165	2.293103	3.78361995	Haloferula sp. BvORR	2497595	Bacteria	Bacteria	48.9	3.64e-5	NR	WP_265594552.1	1396141	g38012	i0	51.2	0.781818181818182	43	21	78.2	0	164	36	52	94	WP_265594552.1 hypothetical protein [Haloferula sp. BvORR071]	diamond	129	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sp. BvORR071
27727472	27727472	PRJNA944150_P_NODE_12844_length_238_cov_2.354497_g12593_i0	PRJNA944150	12844	238	2.354497	5.60370286	Pseudomonadati	3379134	Bacteria	Bacteria	80.9	1.33e-15	NR	MCD6338552.1	2026799	g12593	i0	59	6.84453781512605	61	25	76.9	0	56	238	1	61	MCD6338552.1 efflux RND transporter permease subunit [Verrucomicrobiota bacterium]	diamond	1629	81.3	0.995079950799508	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27783612	27783612	PRJNA944150_P_NODE_46004_length_159_cov_2.700000_g45753_i0	PRJNA944150	46004	159	2.7	4.293	Opitutaceae bacterium	2006848	Bacteria	Bacteria	42.7	0.00197	NR	HXA79716.1	2006848	g45753	i0	60	1.11320754716981	30	12	56.6	0	4	93	46	75	HXA79716.1 hypothetical protein [Opitutaceae bacterium]	diamond	177	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27815220	27815220	PRJNA944150_P_NODE_28544_length_180_cov_1.549618_g28293_i0	PRJNA944150	28544	180	1.549618	2.7893124	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	63.5	7.18e-10	NR	AHF90022.1	794903	g28293	i0	56.9	0.966666666666667	58	25	96.7	0	5	178	233	290	AHF90022.1 9-O-acetylesterase [Opitutaceae bacterium TAV5]	diamond	174	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
27941373	27941373	PRJNA944150_P_NODE_16665_length_210_cov_3.881988_g16414_i0	PRJNA944150	16665	210	3.881988	8.1521748	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	61.6	5.14e-9	NR	MBI1842108.1	2026799	g16414	i0	93.9	0.471428571428571	33	2	47.1	0	2	100	406	438	MBI1842108.1 PQQ-binding-like beta-propeller repeat protein [Verrucomicrobiota bacterium]	diamond	99	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28193701	28193701	PRJNA944150_P_NODE_23766_length_189_cov_1.107143_g23515_i0	PRJNA944150	23766	189	1.107143	2.09250027	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	50.8	1.12e-5	NR	MBG89594.1	2026801	g23515	i0	45.2	0.984126984126984	62	32	95.2	1	188	9	44	105	MBG89594.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	186	50.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28415031	28415031	PRJNA944150_P_NODE_17426_length_210_cov_2.521739_g17175_i0	PRJNA944150	17426	210	2.521739	5.2956519	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.8	4.18e-4	NR	HOX59961.1	2026799	g17175	i0	76.9	1.7	26	6	37.1	0	2	79	2192	2217	HOX59961.1 LamG domain-containing protein [Verrucomicrobiota bacterium]	diamond	357	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28604374	28604374	PRJNA944150_P_NODE_22607_length_191_cov_2.154930_g22356_i0	PRJNA944150	22607	191	2.15493	4.1159163	Opitutaceae bacterium	2006848	Bacteria	Bacteria	88.2	1.81e-18	NR	HEY0944741.1	2006848	g22356	i0	75.8	0.973821989528796	62	15	97.4	0	1	186	442	503	HEY0944741.1 hypothetical protein [Opitutaceae bacterium]	diamond	186	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28762124	28762124	PRJNA944150_P_NODE_46807_length_156_cov_2.925234_g46556_i0	PRJNA944150	46807	156	2.925234	4.56336504	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	81.6	8.13e-19	NR	MFM2212452.1	2026799	g46556	i0	97.7	0.846153846153846	44	1	84.6	0	24	155	1	44	MFM2212452.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	132	81.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30878331	30878331	PRJNA944150_P_NODE_25674_length_185_cov_2.176471_g25423_i0	PRJNA944150	25674	185	2.176471	4.02647135	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	77	1.04e-14	NR	AHF89500.1	794903	g25423	i0	69.6	1.57297297297297	56	8	76.2	1	1	141	311	366	AHF89500.1 LacI family transcriptional regulator [Opitutaceae bacterium TAV5]	diamond	291	77	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
31004795	31004795	PRJNA944150_P_NODE_22614_length_191_cov_2.077465_g22363_i0	PRJNA944150	22614	191	2.077465	3.96795815	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	123	6.85e-32	NR	RYD64978.1	2026800	g22363	i0	95.2	0.989528795811518	63	3	99	0	2	190	43	105	RYD64978.1 MAG: hypothetical protein EOP83_08435 [Verrucomicrobiaceae bacterium]	diamond	189	123	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31036643	31036643	PRJNA944150_P_NODE_34495_length_169_cov_1.408333_g34244_i0	PRJNA944150	34495	169	1.408333	2.38008277	Terrimicrobium sacchariphilum	690879	Bacteria	Bacteria	91.3	1.14e-20	NR	WP_075077423.1	690879	g34244	i0	78.6	0.994082840236686	56	12	99.4	0	169	2	158	213	WP_075077423.1 menaquinone biosynthetic enzyme MqnA/MqnD family protein [Terrimicrobium sacchariphilum]	diamond	168	91.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
31700400	31700400	PRJNA944150_P_NODE_31297_length_175_cov_1.142857_g31046_i0	PRJNA944150	31297	175	1.142857	1.99999975	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99.8	1.23e-22	NR	MBN8709118.1	2026799	g31046	i0	87.7	0.977142857142857	57	7	97.7	0	173	3	411	467	MBN8709118.1 MFS transporter [Verrucomicrobiota bacterium]	diamond	171	99.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31763615	31763615	PRJNA944150_P_NODE_26157_length_184_cov_2.844444_g25906_i0	PRJNA944150	26157	184	2.844444	5.23377696	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	47.8	2.83e-4	NR	HET6407744.1	2811408	g25906	i0	47.7	0.717391304347826	44	23	71.7	0	3	134	33	76	HET6407744.1 DEAD/DEAH box helicase [Chthoniobacteraceae bacterium]	diamond	132	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
32048395	32048395	PRJNA944150_P_NODE_26038_length_185_cov_1.029412_g25787_i0	PRJNA944150	26038	185	1.029412	1.9044122	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.3	0.00496	NR	MDA0325431.1	2026799	g25787	i0	34.5	3.58378378378378	55	36	89.2	0	6	170	391	445	MDA0325431.1 DNA gyrase subunit A [Verrucomicrobiota bacterium]	diamond	663	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32048402	32048402	PRJNA944150_P_NODE_43058_length_162_cov_1.398230_g42807_i0	PRJNA944150	43058	162	1.39823	2.2651326	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	82.4	1.26e-16	NR	WP_069961708.1	1838286	g42807	i0	71.7	0.981481481481482	53	15	98.1	0	161	3	77	129	WP_069961708.1 DUF7305 domain-containing protein [Lacunisphaera limnophila]	diamond	159	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
32837973	32837973	PRJNA944150_P_NODE_29780_length_177_cov_4.500000_g29529_i0	PRJNA944150	29780	177	4.5	7.965	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	89.4	4.5e-19	NR	MEI6338174.1	2026799	g29529	i0	82.5	3.86440677966102	57	10	96.6	0	176	6	335	391	MEI6338174.1 ABC transporter permease [Verrucomicrobiota bacterium]	diamond	684	89.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;