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

8 rows where bioproject = "PRJNA689790", 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
4496745	4496745	PRJNA689790_S_NODE_12624_length_168_cov_2.969466_g12509_i0	PRJNA689790	12624	168	2.969466	4.98870288	Methylacidimicrobium sp. AP8	2730359	Bacteria	Bacteria	74.3	9.63e-14	NR	WP_202214564.1	2730359	g12509	i0	66.7	0.964285714285714	54	18	96.4	0	6	167	416	469	WP_202214564.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Methylacidimicrobium sp. AP8]	diamond	162	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. AP8
9597288	9597288	PRJNA689790_S_NODE_4988_length_270_cov_21.502146_g4873_i0	PRJNA689790	4988	270	21.502146	58.0557942	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g4873	i0	96.97	0.122222222222222	33	0	12	1	141	173	1708785	1708754	Luteolibacter sp. Populi chromosome, complete genome	blastn	33	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
16480978	16480978	PRJNA689790_S_NODE_2453_length_410_cov_3.329759_g2338_i0	PRJNA689790	2453	410	3.329759	13.6520119	Verrucomicrobiota	74201	Bacteria	Bacteria	490	7.04e-134	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g2338	i0	88.452	134.521951219512	407	46	99	1	3	409	2407	2002	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	55154	492	0.995934959349594	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
26892715	26892715	PRJNA689790_S_NODE_6681_length_230_cov_2.616580_g6566_i0	PRJNA689790	6681	230	2.61658	6.018134	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	88.2	2.17e-18	NR	MBE2180553.1	2201154	g6566	i0	61.3	1.86521739130435	75	24	97.8	1	2	226	28	97	MBE2180553.1 phosphoglycerate kinase [Chthoniobacterales bacterium]	diamond	429	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29924479	29924479	PRJNA689790_S_NODE_12371_length_170_cov_1.443609_g12256_i0	PRJNA689790	12371	170	1.443609	2.4541353	Opitutia bacterium	2026771	Bacteria	Bacteria	41.2	0.0493	NR	NDH15519.1	2026771	g12256	i0	41	0.688235294117647	39	23	68.8	0	27	143	91	129	NDH15519.1 tandem-95 repeat protein [Opitutia bacterium]	diamond	117	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
30335517	30335517	PRJNA689790_S_NODE_4892_length_273_cov_2.487288_g4777_i0	PRJNA689790	4892	273	2.487288	6.79029624	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	65.1	7.36e-10	NR	HSZ79770.1	2201154	g4777	i0	37.9	1.87912087912088	87	47	95.6	2	1	261	366	445	HSZ79770.1 serine hydrolase [Chthoniobacterales bacterium]	diamond	513	65.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31820601	31820601	PRJNA689790_S_NODE_11417_length_176_cov_1.625899_g11302_i0	PRJNA689790	11417	176	1.625899	2.86158224	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	53.5	2.32e-6	NR	MCF7674873.1	2562705	g11302	i0	53.4	4.02272727272727	58	20	97.2	2	1	171	351	402	MCF7674873.1 sulfatase [Akkermansiaceae bacterium]	diamond	708	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32022131	32022131	PRJNA689790_S_NODE_12298_length_170_cov_2.345865_g12183_i0	PRJNA689790	12298	170	2.345865	3.9879705	Bacteria	2	Bacteria	Bacteria	60.1	1.06e-8	NR	HIL70227.1	2026799	g12183	i0	42.9	1.97647058823529	56	31	98.8	1	170	3	1045	1099	HIL70227.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	336	60.1	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);;