metadata: contig_metadata: 8 rows where bioproject = "PRJEB17675", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJEB17675", 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
2571497	2571497	PRJEB17675_P_NODE_10303_length_271_cov_1.411017_g9999_i0	PRJEB17675	10303	271	1.411017	3.82385607	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	110	5.39e-27	NR	RYD65414.1	2026800	g9999	i0	69.6	0.763837638376384	69	20	76.4	1	269	63	267	334	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	207	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27121226	27121226	PRJEB17675_P_NODE_15682_length_203_cov_2.839286_g15378_i0	PRJEB17675	15682	203	2.839286	5.76375058	Candidatus Udaeobacter	1921511	Bacteria	Bacteria	56.2	1.92e-7	NR	PYK11899.1	2026799	g15378	i0	40.3	3.96059113300493	67	33	90.1	2	185	3	2	67	PYK11899.1 MAG: porin [Verrucomicrobiota bacterium]	diamond	804	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27722160	27722160	PRJEB17675_P_NODE_22164_length_163_cov_1.242188_g21860_i0	PRJEB17675	22164	163	1.242188	2.02476644	Pseudomonadati	3379134	Bacteria	Bacteria	94.4	6.52e-21	NR	WP_353567781.1	490096	g21860	i0	94.2	57.4601226993865	52	3	95.7	0	161	6	222	273	WP_353567781.1 UDP-glucose 6-dehydrogenase [Haloferula sargassicola]	diamond	9366	95.1	0.992639327024185	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sargassicola
28359503	28359503	PRJEB17675_P_NODE_326_length_1469_cov_2.628312_g266_i0	PRJEB17675	326	1469	2.628312	38.60990328	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	388	1.2599999999999998e-125	NR	HYG84357.1	2499141	g266	i0	49.6	0.988427501701838	484	216	93.5	8	1451	78	71	552	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	1452	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30033262	30033262	PRJEB17675_P_NODE_1071_length_929_cov_3.368009_g912_i0	PRJEB17675	1071	929	3.368009	31.28880361	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	59.3	2.7e-6	NR	HEX3818319.1	2201154	g912	i0	37.5	0.361679224973089	112	60	35.2	5	920	594	118	222	HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	336	59.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31290533	31290533	PRJEB17675_P_NODE_13855_length_221_cov_2.580645_g13551_i0	PRJEB17675	13855	221	2.580645	5.70322545	root	1	Root_unresolved	Root_unresolved	44.3	0.00789	NR	MBT3540390.1	2026771	g13551	i0	31.9	1.85972850678733	69	45	93.7	1	1	207	279	345	MBT3540390.1 hypothetical protein [Opitutia bacterium]	diamond	411	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
31543784	31543784	PRJEB17675_P_NODE_25296_length_151_cov_0.939655_g24992_i0	PRJEB17675	25296	151	0.939655	1.41887905	Pseudomonadati	3379134	Bacteria	Bacteria	46.2	5.69e-4	NR	MBN9692122.1	2026799	g24992	i0	51.1	3.51655629139073	47	20	93.4	1	149	9	95	138	MBN9692122.1 fibro-slime domain-containing protein [Verrucomicrobiota bacterium]	diamond	531	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32024683	32024683	PRJEB17675_P_NODE_398_length_1372_cov_13.706058_g322_i0	PRJEB17675	398	1372	13.706058	188.04711576	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	81.6	1.16e-13	NR	MEO5753320.1	2201154	g322	i0	33.3	0.432944606413994	198	106	40	7	1302	754	34	220	MEO5753320.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	594	81.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales 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);;