metadata: contig_metadata: 14 rows where bioproject = "PRJNA454503", tax_clade = "PVC group" and tax

14 rows where bioproject = "PRJNA454503", 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
6819723	6819723	PRJNA454503_P_NODE_14106_length_306_cov_1.053061_g13777_i0	PRJNA454503	14106	306	1.053061	3.22236666	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	473	5.139999999999999e-129	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g13777	i0	96.516	265.493464052288	287	8	94	2	1	287	1768	1484	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	81241	473	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
8095894	8095894	PRJNA454503_P_NODE_69447_length_207_cov_0.890411_g69118_i0	PRJNA454503	69447	207	0.890411	1.84315077	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g69118	i0	100	0.144927536231884	30	0	14	0	110	139	1644999	1644970	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8746536	8746536	PRJNA454503_P_NODE_18747_length_275_cov_1.037383_g18418_i0	PRJNA454503	18747	275	1.037383	2.85280325	Verrucomicrobiaceae	203557	Bacteria	Bacteria	436	5.969999999999999e-118	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g18418	i0	95.588	260.189090909091	272	12	99	0	4	275	2182	2453	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	71552	436	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
13196508	13196508	PRJNA454503_P_NODE_8171_length_392_cov_1.178248_g7842_i0	PRJNA454503	8171	392	1.178248	4.61873216	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	481	4.03e-131	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g7842	i0	88.974	237.163265306122	390	42	99	1	1	390	1042	1430	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	92968	481	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
16396489	16396489	PRJNA454503_P_NODE_87333_length_199_cov_2.391304_g87004_i0	PRJNA454503	87333	199	2.391304	4.75869496	Luteolibacter flavescens	1859460	Bacteria	Bacteria	117	1.7499999999999998e-30	NR	WP_264503452.1	1859460	g87004	i0	87.9	2.98492462311558	66	8	99.5	0	1	198	4	69	WP_264503452.1 ABC transporter ATP-binding protein [Luteolibacter flavescens]	diamond	594	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter flavescens
18945123	18945123	PRJNA454503_P_NODE_30275_length_239_cov_1.460674_g29946_i0	PRJNA454503	30275	239	1.460674	3.49101086	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	126	5.64e-35	NR	MEO6738746.1	2811408	g29946	i0	70.9	0.99163179916318	79	23	99.2	0	239	3	5	83	MEO6738746.1 thioredoxin-dependent thiol peroxidase [Chthoniobacteraceae bacterium]	diamond	237	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
29254834	29254834	PRJNA454503_P_NODE_67829_length_207_cov_0.890411_g67500_i0	PRJNA454503	67829	207	0.890411	1.84315077	Luteolibacter arcticus	1581411	Bacteria	Bacteria	53.5	3.18e-6	NR	WP_264486249.1	1581411	g67500	i0	78.8	1.94202898550725	66	14	95.7	0	8	205	53	118	WP_264486249.1 carbohydrate-binding domain-containing protein [Luteolibacter arcticus]	diamond	402	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter arcticus
29539134	29539134	PRJNA454503_P_NODE_29370_length_240_cov_1.452514_g29041_i0	PRJNA454503	29370	240	1.452514	3.4860336	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	112	1.02e-26	NR	HSI85345.1	2720631	g29041	i0	61.5	1.95	78	30	97.5	0	239	6	281	358	HSI85345.1 hypothetical protein [Candidatus Methylacidiphilales bacterium]	diamond	468	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
30360983	30360983	PRJNA454503_P_NODE_75412_length_205_cov_0.902778_g75083_i0	PRJNA454503	75412	205	0.902778	1.8506949	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	113	2.56e-27	NR	MEI6818877.1	2026799	g75083	i0	77.9	1.99024390243902	68	15	99.5	0	1	204	580	647	MEI6818877.1 erythromycin esterase family protein [Verrucomicrobiota bacterium]	diamond	408	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30929254	30929254	PRJNA454503_P_NODE_68094_length_207_cov_0.890411_g67765_i0	PRJNA454503	68094	207	0.890411	1.84315077	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	84.7	3.85e-17	NR	MCB1065583.1	2499141	g67765	i0	57.4	0.985507246376812	68	29	98.6	0	204	1	532	599	MCB1065583.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	204	84.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31071946	31071946	PRJNA454503_P_NODE_39815_length_227_cov_1.566265_g39486_i0	PRJNA454503	39815	227	1.566265	3.55542155	Verrucomicrobiales	48461	Bacteria	Bacteria	70.1	6.64e-12	NR	MES2438382.1	2026799	g39486	i0	75.5	4.61233480176211	49	12	64.8	0	151	5	2	50	MES2438382.1 MATE family efflux transporter [Verrucomicrobiota bacterium]	diamond	1047	70.5	0.994326241134752	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31656206	31656206	PRJNA454503_P_NODE_71837_length_206_cov_0.896552_g71508_i0	PRJNA454503	71837	206	0.896552	1.84689712	Chthoniobacter sp.	2510640	Bacteria	Bacteria	119	7.949999999999998e-30	NR	MDR3405335.1	2510640	g71508	i0	80.9	0.990291262135922	68	13	99	0	205	2	310	377	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	204	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
32004423	32004423	PRJNA454503_P_NODE_81898_length_203_cov_0.915493_g81569_i0	PRJNA454503	81898	203	0.915493	1.85845079	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.3	0.00635	NR	HUK81713.1	2499141	g81569	i0	30.6	0.916256157635468	62	42	91.6	1	196	11	246	306	HUK81713.1 isoamylase [Verrucomicrobiia bacterium]	diamond	186	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32857212	32857212	PRJNA454503_P_NODE_26120_length_246_cov_1.589189_g25791_i0	PRJNA454503	26120	246	1.589189	3.90940494	Luteolibacter algae	454151	Bacteria	Bacteria	111	2.15e-26	NR	WP_386817714.1	454151	g25791	i0	64.5	1.85365853658537	76	27	92.7	0	229	2	391	466	WP_386817714.1 site-specific DNA-methyltransferase [Luteolibacter algae]	diamond	456	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter algae

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);;