metadata: contig_metadata: 11 rows where bioproject = "PRJNA807347", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA807347", 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
4634679	4634679	PRJNA807347_P_NODE_10284_length_265_cov_1.536458_g10181_i0	PRJNA807347	10284	265	1.536458	4.0716137	Pseudomonadati	3379134	Bacteria	Bacteria	98.2	1.1699999999999997e-23	NR	MEW6306307.1	2026799	g10181	i0	56.6	4.93584905660377	83	36	94	0	3	251	79	161	MEW6306307.1 DoxX family protein [Verrucomicrobiota bacterium]	diamond	1308	98.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
5909677	5909677	PRJNA807347_P_NODE_13505_length_249_cov_0.880682_g13402_i0	PRJNA807347	13505	249	0.880682	2.19289818	Prosthecobacter sp.	1965333	Bacteria	Bacteria	142	1.44e-38	NR	MCA1963998.1	1965333	g13402	i0	77.8	0.975903614457831	81	18	97.6	0	248	6	316	396	MCA1963998.1 DUF1552 domain-containing protein [Prosthecobacter sp.]	diamond	243	142	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
21208598	21208598	PRJNA807347_P_NODE_17757_length_228_cov_2.258065_g17654_i0	PRJNA807347	17757	228	2.258065	5.1483882	Roseibacillus sp. TMED18	1986590	Bacteria	Bacteria	110	3.3300000000000003e-26	NR	RPF84718.1	1986590	g17654	i0	72	1.97368421052632	75	21	98.7	0	228	4	932	1006	RPF84718.1 MAG: DUF1553 domain-containing protein [Roseibacillus sp. TMED18]	diamond	450	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus sp. TMED18
22483199	22483199	PRJNA807347_P_NODE_4478_length_391_cov_1.289308_g4375_i0	PRJNA807347	4478	391	1.289308	5.04119428	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	58.4	8.03e-4	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g4375	i0	100	1.28644501278772	31	0	8	0	230	260	1614428	1614398	Luteolibacter sp. SL250 chromosome	blastn	503	58.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
26610805	26610805	PRJNA807347_P_NODE_16841_length_242_cov_0.923077_g16738_i0	PRJNA807347	16841	242	0.923077	2.23384634	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	70.1	7.96e-12	NR	HEY5041677.1	2499141	g16738	i0	47.3	1.7603305785124	74	38	91.7	1	226	5	101	173	HEY5041677.1 serine hydrolase domain-containing protein [Verrucomicrobiia bacterium]	diamond	426	70.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26746145	26746145	PRJNA807347_P_NODE_16261_length_243_cov_1.511765_g16158_i0	PRJNA807347	16261	243	1.511765	3.67358895	Pseudomonadati	3379134	Bacteria	Bacteria	140	1.16e-37	NR	TVR50058.1	2026784	g16158	i0	77.5	1.97530864197531	80	17	98.8	1	241	2	143	221	TVR50058.1 MAG: sulfatase [Puniceicoccaceae bacterium]	diamond	480	141	0.99290780141844	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Puniceicoccaceae		Puniceicoccaceae bacterium
28538699	28538699	PRJNA807347_P_NODE_16967_length_242_cov_0.923077_g16864_i0	PRJNA807347	16967	242	0.923077	2.23384634	Limisphaerales bacterium	2052186	Bacteria	Bacteria	112	9.86e-28	NR	MFN7138329.1	2052186	g16864	i0	72.2	1.97107438016529	79	22	97.9	0	239	3	65	143	MFN7138329.1 fibronectin type III domain-containing protein [Limisphaerales bacterium]	diamond	477	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
29810191	29810191	PRJNA807347_P_NODE_11571_length_253_cov_1.750000_g11468_i0	PRJNA807347	11571	253	1.75	4.4275	PVC group	1783257	Bacteria	Bacteria	133	5.1999999999999994e-36	NR	NDF17525.1	2026799	g11468	i0	85.5	2.78656126482213	69	10	81.8	0	6	212	94	162	NDF17525.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	705	134	0.992537313432836	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30211965	30211965	PRJNA807347_P_NODE_11032_length_258_cov_1.578378_g10929_i0	PRJNA807347	11032	258	1.578378	4.07221524	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	136	5.979999999999998e-35	NR	MEY4244251.1	2026799	g10929	i0	89.4	0.988372093023256	85	9	98.8	0	2	256	310	394	MEY4244251.1 Multidrug export protein AcrF [Verrucomicrobiota bacterium]	diamond	255	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30591231	30591231	PRJNA807347_P_NODE_15773_length_244_cov_0.912281_g15670_i0	PRJNA807347	15773	244	0.912281	2.22596564	Opitutaceae bacterium	2006848	Bacteria	Bacteria	89.4	2.54e-21	NR	MFM8335803.1	2006848	g15670	i0	95.2	1.54918032786885	42	2	51.6	0	3	128	38	79	MFM8335803.1 DUF4266 domain-containing protein [Opitutaceae bacterium]	diamond	378	89.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32140666	32140666	PRJNA807347_P_NODE_10178_length_266_cov_1.492228_g10075_i0	PRJNA807347	10178	266	1.492228	3.96932648	Opitutaceae bacterium	2006848	Bacteria	Bacteria	112	1.57e-26	NR	MBL9213736.1	2006848	g10075	i0	65.8	1.78195488721805	79	27	89.1	0	264	28	583	661	MBL9213736.1 TonB-dependent receptor plug domain-containing protein [Opitutaceae bacterium]	diamond	474	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;