metadata: contig_metadata: 12 rows where bioproject = "PRJEB39643", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJEB39643", 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
3883395	3883395	PRJEB39643_P_NODE_116704_length_253_cov_4.477778_g116511_i0	PRJEB39643	116704	253	4.477778	11.32877834	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	119	1.83e-30	NR	RYD65414.1	2026800	g116511	i0	82.5	0.74703557312253	63	11	74.7	0	65	253	271	333	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	189	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
22666438	22666438	PRJEB39643_P_NODE_71898_length_275_cov_1.524752_g71705_i0	PRJEB39643	71898	275	1.524752	4.193068	root	1	Root_unresolved	Root_unresolved	52.8	0.025	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g71705	i0	100	0.203636363636364	28	0	10	0	1	28	5267480	5267507	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
23010374	23010374	PRJEB39643_P_NODE_74519_length_273_cov_1.540000_g74326_i0	PRJEB39643	74519	273	1.54	4.2042	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	329	1.0299999999999998e-85	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g74326	i0	89.313	50.0586080586081	262	28	96	0	9	270	4710421	4710682	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	13666	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
27658823	27658823	PRJEB39643_P_NODE_53844_length_284_cov_1.459716_g53651_i0	PRJEB39643	53844	284	1.459716	4.14559344	Pseudomonadati	3379134	Bacteria	Bacteria	55.5	2.07e-6	NR	WP_353566547.1	490096	g53651	i0	82.1	1.44718309859155	28	5	29.6	0	279	196	836	863	WP_353566547.1 glutaminase family protein [Haloferula sargassicola]	diamond	411	55.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sargassicola
28264968	28264968	PRJEB39643_P_NODE_153166_length_234_cov_2.434783_g152973_i0	PRJEB39643	153166	234	2.434783	5.69739222	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	113	2.28e-28	NR	HCN30525.1	2026801	g152973	i0	74	4.93589743589744	77	20	98.7	0	232	2	209	285	HCN30525.1 alkene reductase [Verrucomicrobiales bacterium]	diamond	1155	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28296625	28296625	PRJEB39643_P_NODE_39246_length_299_cov_4.106195_g39053_i0	PRJEB39643	39246	299	4.106195	12.27752305	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	43.9	0.021	NR	HWL52937.1	2811408	g39053	i0	45.6	0.57190635451505	57	30	56.2	1	102	269	157	213	HWL52937.1 PEP-CTERM sorting domain-containing protein [Chthoniobacteraceae bacterium]	diamond	171	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
28707290	28707290	PRJEB39643_P_NODE_151507_length_239_cov_2.566265_g151314_i0	PRJEB39643	151507	239	2.566265	6.13337335	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	97.1	2.69e-21	NR	RYD77759.1	2026800	g151314	i0	66.7	0.97907949790795	78	25	96.7	1	7	237	165	242	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	234	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29812167	29812167	PRJEB39643_P_NODE_68291_length_276_cov_2.275862_g68098_i0	PRJEB39643	68291	276	2.275862	6.28137912	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	125	1.1999999999999999e-32	NR	RYD81270.1	2026800	g68098	i0	66.7	0.880434782608696	81	27	88	0	274	32	214	294	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	243	125	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30475893	30475893	PRJEB39643_P_NODE_76213_length_272_cov_3.005025_g76020_i0	PRJEB39643	76213	272	3.005025	8.173668	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.3	0.0159	NR	MBI5386505.1	2026799	g76020	i0	41.9	1.58823529411765	74	24	81.6	3	51	272	1774	1828	MBI5386505.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	432	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31297317	31297317	PRJEB39643_P_NODE_66175_length_278_cov_1.424390_g65982_i0	PRJEB39643	66175	278	1.42439	3.9598042	Spartobacteria bacterium	2052183	Bacteria	Bacteria	45.8	0.00468	NR	MFM8982733.1	2052183	g65982	i0	35.6	0.787769784172662	73	32	69.1	3	192	1	65	131	MFM8982733.1 alpha-galactosidase [Spartobacteria bacterium]	diamond	219	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium
31392381	31392381	PRJEB39643_P_NODE_148356_length_241_cov_2.750000_g148163_i0	PRJEB39643	148356	241	2.75	6.6275	Verrucomicrobiaceae bacterium NT6N	2979115	Bacteria	Bacteria	106	2.15e-25	NR	BDS05028.1	2979115	g148163	i0	63.3	3.93360995850622	79	29	98.3	0	239	3	203	281	BDS05028.1 alcohol dehydrogenase [Verrucomicrobiaceae bacterium NT6N]	diamond	948	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Oceaniferula	Oceaniferula spumae
31701885	31701885	PRJEB39643_P_NODE_159757_length_202_cov_4.651163_g159563_i0	PRJEB39643	159757	202	4.651163	9.39534926	Oleiharenicola	2100741	Bacteria	Bacteria	45.8	0.00178	NR	MBI5800098.1	2026799	g159563	i0	42.4	1.81188118811881	59	21	87.6	1	190	14	54	99	MBI5800098.1 esterase family protein [Verrucomicrobiota bacterium]	diamond	366	46.2	0.991341991341991	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);;