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

8 rows where bioproject = "PRJNA274362", 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
5474199	5474199	PRJNA274362_S_NODE_3585_length_437_cov_1.729381_g3465_i0	PRJNA274362	3585	437	1.729381	7.55739497	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	403	1.0099999999999999e-107	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g3465	i0	83.916	314.851258581236	429	61	97	8	14	437	27396	26971	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	137590	403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6748156	6748156	PRJNA274362_S_NODE_1886_length_586_cov_1.897579_g1777_i0	PRJNA274362	1886	586	1.897579	11.11981294	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	564	6.019999999999998e-156	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g1777	i0	86.398	172.081911262799	522	64	89	7	68	586	16603	16086	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	100840	564	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10574654	10574654	PRJNA274362_S_NODE_27989_length_179_cov_1.200000_g27869_i0	PRJNA274362	27989	179	1.2	2.148	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	243	8.379999999999999e-60	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g27869	i0	91.16	13.0502793296089	181	13	100	3	1	179	1316260	1316439	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	2336	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14399727	14399727	PRJNA274362_S_NODE_32192_length_169_cov_0.866667_g32072_i0	PRJNA274362	32192	169	0.866667	1.46466723	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	250	4.66e-62	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g32072	i0	93.491	240.692307692308	169	9	100	2	1	169	3831306	3831472	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	40677	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18221999	18221999	PRJNA274362_S_NODE_11215_length_262_cov_2.835681_g11095_i0	PRJNA274362	11215	262	2.835681	7.42948422	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	370	5.81e-98	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g11095	i0	94.915	284.248091603053	236	12	90	0	1	236	17789	17554	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	74473	370	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
24010548	24010548	PRJNA274362_S_NODE_3579_length_437_cov_2.131443_g3459_i0	PRJNA274362	3579	437	2.131443	9.31440591	Chthoniobacter	295577	Bacteria	Bacteria	584	3.3699999999999986e-162	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g3459	i0	91.055	150.398169336384	436	34	99	5	1	434	15614	16046	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	65724	584	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
28084674	28084674	PRJNA274362_S_NODE_23285_length_194_cov_0.882759_g23165_i0	PRJNA274362	23285	194	0.882759	1.71255246	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.8	0.00152	NR	PYJ00909.1	2026799	g23165	i0	54.1	2.33505154639175	37	16	55.7	1	176	69	258	294	PYJ00909.1 MAG: alpha/beta hydrolase [Verrucomicrobiota bacterium]	diamond	453	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32540424	32540424	PRJNA274362_S_NODE_23079_length_194_cov_1.765517_g22959_i0	PRJNA274362	23079	194	1.765517	3.42510298	Limisphaera ngatamarikiensis	1324935	Bacteria	Bacteria	97.4	2.32e-22	NR	WP_165108057.1	1324935	g22959	i0	74.6	3.92783505154639	63	16	97.4	0	192	4	12	74	WP_165108057.1 malate dehydrogenase [Limisphaera ngatamarikiensis]	diamond	762	97.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Limisphaeraceae	Limisphaera	Limisphaera ngatamarikiensis

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