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

8 rows where bioproject = "PRJNA1218816", 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
4160575	4160575	PRJNA1218816_P_NODE_60044_length_244_cov_0.900585_g59611_i0	PRJNA1218816	60044	244	0.900585	2.1974274	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	134	1.63e-38	NR	RYD67074.1	2026800	g59611	i0	88.5	0.959016393442623	78	8	95.9	1	5	238	15	91	RYD67074.1 MAG: J domain-containing protein, partial [Verrucomicrobiaceae bacterium]	diamond	234	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
9974361	9974361	PRJNA1218816_P_NODE_52588_length_255_cov_1.148352_g52155_i0	PRJNA1218816	52588	255	1.148352	2.9282976	Bacteria	2	Bacteria	Bacteria	322	1.6e-83	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g52155	i0	89.764	152.670588235294	254	22	99	3	1	253	3921429	3921679	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	38931	324	0.993827160493827	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10537383	10537383	PRJNA1218816_P_NODE_56389_length_248_cov_0.880000_g55956_i0	PRJNA1218816	56389	248	0.88	2.1824	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	159	1.28e-34	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g55956	i0	78.431	36.4072580645161	255	47	100	8	1	248	2749712	2749459	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	9029	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14362609	14362609	PRJNA1218816_P_NODE_63112_length_241_cov_0.916667_g62679_i0	PRJNA1218816	63112	241	0.916667	2.20916747	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	411	3.109999999999999e-110	NTclustered	gi\|403081880\|gb\|JX240789.1\|	156588	g62679	i0	97.51	99.8921161825726	241	5	100	1	1	241	1426	1187	Uncultured Verrucomicrobia bacterium clone MLS125 16S ribosomal RNA gene, partial sequence	blastn	24074	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22723210	22723210	PRJNA1218816_P_NODE_59558_length_245_cov_0.895349_g59125_i0	PRJNA1218816	59558	245	0.895349	2.19360505	Coraliomargarita	442430	Bacteria	Bacteria	191	4.49e-44	NTclustered	gi\|470486190\|ref\|NR_076741.1\|	395922	g59125	i0	81.048	166.216326530612	248	40	100	6	1	245	1714	1471	Coraliomargarita akajimensis strain 04OKA010-24 23S ribosomal RNA gene, complete sequence	blastn	40723	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita akajimensis
27420606	27420606	PRJNA1218816_P_NODE_53443_length_252_cov_0.821229_g53010_i0	PRJNA1218816	53443	252	0.821229	2.06949708	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0407	NR	MEI6341235.1	2026799	g53010	i0	35.5	0.904761904761905	76	40	79.8	2	42	242	84	159	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	228	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28102030	28102030	PRJNA1218816_P_NODE_54725_length_250_cov_0.870056_g54292_i0	PRJNA1218816	54725	250	0.870056	2.17514	Prosthecobacter	48463	Bacteria	Bacteria	154	5.79e-42	NR	WP_184341396.1	48466	g54292	i0	90.4	10.956	83	8	99.6	0	2	250	394	476	WP_184341396.1 M3 family oligoendopeptidase [Prosthecobacter vanneervenii]	diamond	2739	155	0.993548387096774	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
30660209	30660209	PRJNA1218816_P_NODE_56913_length_248_cov_0.880000_g56480_i0	PRJNA1218816	56913	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	89.4	1.56e-18	NR	RYD84082.1	2026800	g56480	i0	55.6	1.94758064516129	81	34	98	1	6	248	328	406	RYD84082.1 MAG: hypothetical protein EOP84_06490, partial [Verrucomicrobiaceae bacterium]	diamond	483	90.1	0.992230854605993	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;