metadata: contig_metadata: 16 rows where bioproject = "PRJEB83711", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJEB83711", 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
144604	144604	PRJEB83711_P_NODE_71201_length_246_cov_0.901734_g70935_i0	PRJEB83711	71201	246	0.901734	2.21826564	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	207	4.48e-49	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g70935	i0	82.114	1	246	40	99	4	1	244	3080445	3080688	Luteolibacter sp. SL250 chromosome	blastn	246	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
2694502	2694502	PRJEB83711_P_NODE_58483_length_253_cov_0.866667_g58217_i0	PRJEB83711	58483	253	0.866667	2.19266751	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	157	1.47e-46	NR	HSY88496.1	2499141	g58217	i0	92.8	2.95256916996047	83	6	98.4	0	3	251	34	116	HSY88496.1 zinc-binding dehydrogenase [Verrucomicrobiia bacterium]	diamond	747	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
11623193	11623193	PRJEB83711_P_NODE_71570_length_246_cov_0.895954_g71304_i0	PRJEB83711	71570	246	0.895954	2.20404684	Prosthecobacter sp.	1965333	Bacteria	Bacteria	175	6.04e-51	NR	MBV6501246.1	1965333	g71304	i0	100	0.98780487804878	81	0	98.8	0	244	2	116	196	MBV6501246.1 UDP-N-acetylmuramate--L-alanyl-gamma-D-glutamyl-meso-2,6-diaminoheptandioate ligase [Prosthecobacter sp.]	diamond	243	175	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
14173221	14173221	PRJEB83711_P_NODE_73232_length_245_cov_0.906977_g72966_i0	PRJEB83711	73232	245	0.906977	2.22209365	Limisphaerales bacterium	2052186	Bacteria	Bacteria	110	2.8e-26	NR	KAF0179810.1	2052186	g72966	i0	96.2	0.636734693877551	52	2	63.7	0	158	3	398	449	KAF0179810.1 MAG: hypothetical protein FD161_1152 [Limisphaerales bacterium]	diamond	156	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
26781264	26781264	PRJEB83711_P_NODE_50541_length_266_cov_1.284974_g50275_i0	PRJEB83711	50541	266	1.284974	3.41803084	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	80.5	5.65e-18	NR	MBL9152605.1	2026801	g50275	i0	81.8	0.496240601503759	44	8	49.6	0	265	134	7	50	MBL9152605.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	132	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27666384	27666384	PRJEB83711_P_NODE_68284_length_247_cov_1.413793_g68018_i0	PRJEB83711	68284	247	1.413793	3.49206871	Opitutia bacterium	2026771	Bacteria	Bacteria	53.1	8.12e-6	NR	MFN7339902.1	2026771	g68018	i0	63.6	1.06882591093117	44	14	53.4	1	247	116	335	376	MFN7339902.1 methyltransferase domain-containing protein [Opitutia bacterium]	diamond	264	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
28045036	28045036	PRJEB83711_P_NODE_65785_length_249_cov_0.886364_g65519_i0	PRJEB83711	65785	249	0.886364	2.20704636	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	72	1.92e-12	NR	MBE7496752.1	2026800	g65519	i0	100	0.397590361445783	33	0	39.8	0	247	149	616	648	MBE7496752.1 DUF4838 domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	99	72	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28645107	28645107	PRJEB83711_P_NODE_65927_length_249_cov_0.886364_g65661_i0	PRJEB83711	65927	249	0.886364	2.20704636	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	114	1.9100000000000003e-27	NR	MEQ1859188.1	2811408	g65661	i0	76.2	1.01204819277108	84	18	98.8	2	247	2	480	563	MEQ1859188.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	252	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
29244910	29244910	PRJEB83711_P_NODE_40429_length_288_cov_1.241860_g40163_i0	PRJEB83711	40429	288	1.24186	3.5765568	Opitutus sp.	1913982	Bacteria	Bacteria	44.3	0.0168	NR	MCR6655498.1	1913982	g40163	i0	35.6	0.760416666666667	73	44	76	1	69	287	159	228	MCR6655498.1 MlaD family protein [Opitutus sp.]	diamond	219	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
29307973	29307973	PRJEB83711_P_NODE_77869_length_242_cov_1.757396_g77603_i0	PRJEB83711	77869	242	1.757396	4.25289832	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	88.2	1.16e-20	NR	MBI3848897.1	2026799	g77603	i0	64.1	1.58677685950413	64	23	79.3	0	192	1	1	64	MBI3848897.1 type II toxin-antitoxin system RelE/ParE family toxin [Verrucomicrobiota bacterium]	diamond	384	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29623277	29623277	PRJEB83711_P_NODE_64890_length_249_cov_0.886364_g64624_i0	PRJEB83711	64890	249	0.886364	2.20704636	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	107	7.89e-27	NR	WP_069961306.1	1838286	g64624	i0	69.5	3.95180722891566	82	25	98.8	0	246	1	111	192	WP_069961306.1 glycerophosphodiester phosphodiesterase [Lacunisphaera limnophila]	diamond	984	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
30192238	30192238	PRJEB83711_P_NODE_52012_length_263_cov_1.357895_g51746_i0	PRJEB83711	52012	263	1.357895	3.57126385	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	58.9	7.58e-8	NR	MBK8035964.1	2026800	g51746	i0	61.4	0.501901140684411	44	17	50.2	0	145	14	1	44	MBK8035964.1 transposase [Verrucomicrobiaceae bacterium]	diamond	132	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30761139	30761139	PRJEB83711_P_NODE_65674_length_249_cov_0.886364_g65408_i0	PRJEB83711	65674	249	0.886364	2.20704636	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	44.7	0.00318	NR	WP_009963814.1	2736	g65408	i0	36.7	1.18072289156627	49	31	59	0	201	55	44	92	WP_009963814.1 hypothetical protein [Verrucomicrobium spinosum]	diamond	294	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
31108431	31108431	PRJEB83711_P_NODE_56315_length_255_cov_1.373626_g56049_i0	PRJEB83711	56315	255	1.373626	3.5027463	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	92.8	4.21e-20	NR	HEV8543776.1	2499141	g56049	i0	93.3	1.04705882352941	45	3	52.9	0	3	137	321	365	HEV8543776.1 peptide chain release factor 2 [Verrucomicrobiia bacterium]	diamond	267	92.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31456520	31456520	PRJEB83711_P_NODE_62776_length_250_cov_1.378531_g62510_i0	PRJEB83711	62776	250	1.378531	3.4463275	Luteolibacter sp.	1962973	Bacteria	Bacteria	92.4	1.19e-19	NR	HEY8961502.1	1962973	g62510	i0	61.4	1.992	83	32	99.6	0	2	250	24	106	HEY8961502.1 phospho-sugar mutase [Luteolibacter sp.]	diamond	498	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
31614534	31614534	PRJEB83711_P_NODE_62656_length_250_cov_1.598870_g62390_i0	PRJEB83711	62656	250	1.59887	3.997175	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42.7	0.0287	NR	HVY72115.1	2499141	g62390	i0	35.4	0.576	48	31	57.6	0	35	178	27	74	HVY72115.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	144	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;