metadata: contig_metadata: 16 rows where bioproject = "PRJEB39269", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJEB39269", 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
3883167	3883167	PRJEB39269_P_NODE_12124_length_402_cov_1.206612_g11719_i0	PRJEB39269	12124	402	1.206612	4.85058024	Bacteria	2	Bacteria	Bacteria	154	6.26e-44	NR	HEX9785044.1	2006848	g11719	i0	73.2	2.8955223880597	97	25	72.4	1	401	111	169	264	HEX9785044.1 DUF1080 domain-containing protein [Opitutaceae bacterium]	diamond	1164	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
3883184	3883184	PRJEB39269_P_NODE_48184_length_197_cov_4.537975_g47779_i0	PRJEB39269	48184	197	4.537975	8.93981075	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	244	2.62e-60	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g47779	i0	89.109	364.142131979695	202	14	100	8	1	197	3893718	3893520	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	71736	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5159374	5159374	PRJEB39269_P_NODE_26205_length_272_cov_2.828326_g25800_i0	PRJEB39269	26205	272	2.828326	7.69304672	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	472	1.62e-128	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g25800	i0	98.864	103.330882352941	264	3	97	0	7	270	2497158	2497421	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	28106	472	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
6435273	6435273	PRJEB39269_P_NODE_58286_length_180_cov_5.007092_g57881_i0	PRJEB39269	58286	180	5.007092	9.0127656	Chthoniobacter flavus	191863	Bacteria	Bacteria	302	1.37e-77	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g57881	i0	97.714	230.138888888889	175	4	97	0	4	178	2090	1916	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	41425	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
7709420	7709420	PRJEB39269_P_NODE_20727_length_308_cov_2.185874_g20322_i0	PRJEB39269	20727	308	2.185874	6.73249192	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	375	1.5e-99	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g20322	i0	88.71	241.853896103896	310	31	100	3	1	308	2036	2343	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	74491	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
9917425	9917425	PRJEB39269_P_NODE_55688_length_184_cov_2.262069_g55283_i0	PRJEB39269	55688	184	2.262069	4.16220696	Verrucomicrobiota	74201	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g55283	i0	100	45.7065217391304	184	0	100	0	1	184	3347	3164	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	8410	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
15359289	15359289	PRJEB39269_P_NODE_90493_length_151_cov_1.044643_g90088_i0	PRJEB39269	90493	151	1.044643	1.57741093	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	222	8.879999999999998e-54	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g90088	i0	95.035	41.0529801324503	141	7	93	0	11	151	2577522	2577382	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	6199	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
16633912	16633912	PRJEB39269_P_NODE_51354_length_191_cov_6.743421_g50949_i0	PRJEB39269	51354	191	6.743421	12.87993411	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	281	1.92e-71	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g50949	i0	93.194	39.8429319371728	191	13	100	0	1	191	2557675	2557485	Lacunisphaera limnophila strain IG16b, complete genome	blastn	7610	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
16633923	16633923	PRJEB39269_P_NODE_64654_length_172_cov_1.518797_g64249_i0	PRJEB39269	64654	172	1.518797	2.61233084	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	213	6.25e-51	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g64249	i0	94.891	12.3720930232558	137	6	79	1	32	167	3832125	3832261	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	2128	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16633937	16633937	PRJEB39269_P_NODE_74934_length_163_cov_1.112903_g74529_i0	PRJEB39269	74934	163	1.112903	1.81403189	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	274	2.66e-69	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g74529	i0	96.933	158.104294478528	163	5	100	0	1	163	3412685	3412523	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	25771	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
21391374	21391374	PRJEB39269_P_NODE_88957_length_152_cov_1.088496_g88552_i0	PRJEB39269	88957	152	1.088496	1.65451392	Verrucomicrobiales	48461	Bacteria	Bacteria	158	2.56e-34	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g88552	i0	89.516	14.3355263157895	124	13	82	0	11	134	3412204	3412327	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	2179	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
26748016	26748016	PRJEB39269_P_NODE_41141_length_214_cov_1.657143_g40736_i0	PRJEB39269	41141	214	1.657143	3.54628602	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	94.7	1.28e-20	NR	HET9374130.1	2201154	g40736	i0	58	0.967289719626168	69	29	96.7	0	208	2	155	223	HET9374130.1 two-component regulator propeller domain-containing protein [Chthoniobacterales bacterium]	diamond	207	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27570440	27570440	PRJEB39269_P_NODE_87124_length_153_cov_1.649123_g86719_i0	PRJEB39269	87124	153	1.649123	2.52315819	Opitutaceae bacterium	2006848	Bacteria	Bacteria	43.1	0.00794	NR	HEX9783952.1	2006848	g86719	i0	48.9	0.882352941176471	45	23	88.2	0	8	142	704	748	HEX9783952.1 TonB-dependent receptor [Opitutaceae bacterium]	diamond	135	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27879651	27879651	PRJEB39269_P_NODE_49165_length_196_cov_1.044586_g48760_i0	PRJEB39269	49165	196	1.044586	2.04738856	Bacteria	2	Bacteria	Bacteria	122	2.9499999999999997e-32	NR	MBV8413705.1	2026799	g48760	i0	84.6	3.97959183673469	65	10	99.5	0	1	195	169	233	MBV8413705.1 5-deoxy-glucuronate isomerase [Verrucomicrobiota bacterium]	diamond	780	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28549479	28549479	PRJEB39269_P_NODE_82147_length_157_cov_1.525424_g81742_i0	PRJEB39269	82147	157	1.525424	2.39491568	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	86.3	5.35e-18	NR	HEV3098604.1	2665650	g81742	i0	80.4	0.974522292993631	51	10	97.5	0	1	153	777	827	HEV3098604.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Udaeobacter sp.]	diamond	153	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
29622334	29622334	PRJEB39269_P_NODE_68710_length_169_cov_2.784615_g68305_i0	PRJEB39269	68710	169	2.784615	4.70599935	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	80.1	8.94e-16	NR	MBI5691970.1	2026799	g68305	i0	74.1	1.02958579881657	58	12	97.6	1	3	167	15	72	MBI5691970.1 NADP-dependent isocitrate dehydrogenase [Verrucomicrobiota bacterium]	diamond	174	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;