metadata: contig_metadata: 9 rows where bioproject = "PRJNA909412", tax_clade = "PVC group" and tax

9 rows where bioproject = "PRJNA909412", 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
3441497	3441497	PRJNA909412_P_NODE_1863_length_399_cov_2.166667_g1723_i0	PRJNA909412	1863	399	2.166667	8.64500133	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	636	8.299999999999999e-178	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1723	i0	95.489	163.611528822055	399	16	100	1	1	399	1808	1412	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	65281	636	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
5993871	5993871	PRJNA909412_P_NODE_1185_length_515_cov_2.941176_g1048_i0	PRJNA909412	1185	515	2.941176	15.1470564	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	523	8.889999999999997e-144	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1048	i0	89.951	240.594174757282	408	37	79	3	2	408	1384	980	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	123906	523	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
5993947	5993947	PRJNA909412_P_NODE_3785_length_270_cov_1.909091_g3644_i0	PRJNA909412	3785	270	1.909091	5.1545457	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	455	1.6100000000000002e-123	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3644	i0	97.037	84.9037037037037	270	8	100	0	1	270	5153588	5153319	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	22924	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16193475	16193475	PRJNA909412_P_NODE_1853_length_400_cov_2.445983_g1713_i0	PRJNA909412	1853	400	2.445983	9.783932	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	662	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1713	i0	96.725	160.4025	397	13	99	0	4	400	653	257	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	64161	662	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
17468997	17468997	PRJNA909412_P_NODE_6194_length_211_cov_0.953488_g6053_i0	PRJNA909412	6194	211	0.953488	2.01185968	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	379	7.489999999999999e-101	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g6053	i0	99.052	119.284360189573	211	2	100	0	1	211	664	874	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	25169	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
19100684	19100684	PRJNA909412_P_NODE_11135_length_171_cov_3.272727_g10994_i0	PRJNA909412	11135	171	3.272727	5.59636317	Prosthecobacter	48463	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|219846433\|ref\|NR_026024.1\|	48464	g10994	i0	100	100.005847953216	171	0	100	0	1	171	1230	1060	Prosthecobacter fusiformis strain FC4 16S ribosomal RNA, partial sequence	blastn	17101	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
20375526	20375526	PRJNA909412_P_NODE_6776_length_202_cov_2.355828_g6635_i0	PRJNA909412	6776	202	2.355828	4.75877256	Bacteria	2	Bacteria	Bacteria	122	2.75e-30	NR	MBT8037638.1	2499141	g6635	i0	80.6	9.93564356435644	67	13	99.5	0	2	202	624	690	MBT8037638.1 aminomethyl-transferring glycine dehydrogenase [Verrucomicrobiia bacterium]	diamond	2007	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28571882	28571882	PRJNA909412_P_NODE_16767_length_151_cov_2.482143_g16626_i0	PRJNA909412	16767	151	2.482143	3.74803593	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	67.8	1.12e-11	NR	MEP6809396.1	2201154	g16626	i0	61.7	0.933774834437086	47	18	93.4	0	142	2	119	165	MEP6809396.1 arginine deiminase-related protein [Chthoniobacterales bacterium]	diamond	141	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29298169	29298169	PRJNA909412_P_NODE_11949_length_165_cov_1.936508_g11808_i0	PRJNA909412	11949	165	1.936508	3.1952382	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	82.8	7.49e-17	NR	MCB1120004.1	2499141	g11808	i0	82	2.72727272727273	50	9	90.9	0	3	152	125	174	MCB1120004.1 bifunctional folylpolyglutamate synthase/dihydrofolate synthase [Verrucomicrobiia bacterium]	diamond	450	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;