metadata: contig_metadata: 7 rows where bioproject = "PRJNA345071", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA345071", 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_species
2943962	2943962	PRJNA345071_P_NODE_2523_length_367_cov_1.326531_g2483_i0	PRJNA345071	2523	367	1.326531	4.86836877	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	162	5.67e-46	NR	MBL9145181.1	2026800	g2483	i0	66.4	3.85013623978202	119	40	97.3	0	358	2	219	337	MBL9145181.1 alkene reductase [Verrucomicrobiaceae bacterium]	diamond	1413	162	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
29506203	29506203	PRJNA345071_P_NODE_4670_length_296_cov_1.399103_g4630_i0	PRJNA345071	4670	296	1.399103	4.14134488	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.8	0.00537	NR	MCD8535897.1	2026799	g4630	i0	37.8	2.56418918918919	74	42	74	3	292	74	143	213	MCD8535897.1 inorganic phosphate transporter [Verrucomicrobiota bacterium]	diamond	759	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
30565541	30565541	PRJNA345071_P_NODE_9573_length_246_cov_0.901734_g9533_i0	PRJNA345071	9573	246	0.901734	2.21826564	PVC group	1783257	Bacteria	Bacteria	129	2.77e-35	NR	MEY4690911.1	2026799	g9533	i0	78.5	9.86585365853658	79	17	96.3	0	243	7	12	90	MEY4690911.1 protein chain initiation factor [Verrucomicrobiota bacterium]	diamond	2427	130	0.992307692307692	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
30864538	30864538	PRJNA345071_P_NODE_2014_length_399_cov_2.969325_g1974_i0	PRJNA345071	2014	399	2.969325	11.84760675	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	110	1.3800000000000002e-27	NR	MBE2204437.1	2201154	g1974	i0	48.3	0.87218045112781994	116	48	82	2	397	71	52	162	MBE2204437.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	348	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales		Chthoniobacterales bacterium
30864541	30864541	PRJNA345071_P_NODE_8434_length_250_cov_0.881356_g8394_i0	PRJNA345071	8434	250	0.881356	2.20339	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	159	1.12e-45	NR	MDB6032081.1	2026801	g8394	i0	84.3	0.996	83	13	99.6	0	249	1	262	344	MDB6032081.1 prepilin-type N-terminal cleavage/methylation domain [Verrucomicrobiales bacterium]	diamond	249	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales		Verrucomicrobiales bacterium
31781366	31781366	PRJNA345071_P_NODE_2957_length_347_cov_1.562044_g2917_i0	PRJNA345071	2957	347	1.562044	5.42029268	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	135	5.15e-35	NR	HEY5895444.1	2201154	g2917	i0	56.4	5.67146974063401	110	48	95.1	0	347	18	300	409	HEY5895444.1 aldehyde dehydrogenase family protein [Chthoniobacterales bacterium]	diamond	1968	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales		Chthoniobacterales bacterium
31813168	31813168	PRJNA345071_P_NODE_4737_length_295_cov_1.405405_g4697_i0	PRJNA345071	4737	295	1.405405	4.14594475	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	43.5	0.0138	NR	MDF1850130.1	2026801	g4697	i0	37	0.935593220338983	92	47	93.6	2	15	290	19	99	MDF1850130.1 EF-hand domain-containing protein [Verrucomicrobiales bacterium]	diamond	276	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales		Verrucomicrobiales 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);;