metadata: contig_metadata: 22 rows where bioproject = "PRJNA976345", tax_clade = "PVC group" and tax

22 rows where bioproject = "PRJNA976345", 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
3498459	3498459	PRJNA976345_P_NODE_138723_length_171_cov_2.051471_g137115_i0	PRJNA976345	138723	171	2.051471	3.50801541	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	228	2.219999999999999e-55	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g137115	i0	91.071	288.701754385965	168	15	98	0	4	171	27443	27276	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	49368	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
3498560	3498560	PRJNA976345_P_NODE_153323_length_165_cov_1.415385_g151715_i0	PRJNA976345	153323	165	1.415385	2.33538525	Pedosphaera parvula	1032527	Bacteria	Bacteria	243	7.63e-60	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g151715	i0	94.839	13.8909090909091	155	8	94	0	1	155	1310	1464	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	2292	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
7326735	7326735	PRJNA976345_P_NODE_8446_length_608_cov_2.204188_g6985_i0	PRJNA976345	8446	608	2.204188	13.40146304	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	360	1.4300000000000002e-122	NR	HET6406473.1	2811408	g6985	i0	87.5	4.97368421052632	200	25	98.7	0	1	600	156	355	HET6406473.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	3024	360	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
8601757	8601757	PRJNA976345_P_NODE_77867_length_208_cov_1.595376_g76259_i0	PRJNA976345	77867	208	1.595376	3.31838208	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	307	3.52e-79	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g76259	i0	93.269	247.432692307692	208	14	100	0	1	208	16032	15825	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	51466	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18800103	18800103	PRJNA976345_P_NODE_26855_length_325_cov_2.379310_g25252_i0	PRJNA976345	26855	325	2.37931	7.7327575	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	412	1.2199999999999999e-110	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g25252	i0	89.571	244.270769230769	326	33	100	1	1	325	735850	736175	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	79388	412	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25493653	25493653	PRJNA976345_P_NODE_18040_length_397_cov_2.375691_g16446_i0	PRJNA976345	18040	397	2.375691	9.43149327	Prosthecobacter sp.	1965333	Bacteria	Bacteria	231	1.94e-69	NR	WP_300931952.1	1965333	g16446	i0	94.5	0.959697732997481	127	7	96	0	382	2	1	127	WP_300931952.1 polyphosphate kinase 1 [Prosthecobacter sp.]	diamond	381	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
26740688	26740688	PRJNA976345_P_NODE_107341_length_185_cov_1.593333_g105733_i0	PRJNA976345	107341	185	1.593333	2.94766605	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	54.3	1.05e-6	NR	HEV2045486.1	2201154	g105733	i0	65.6	2.61081081081081	32	11	51.9	0	5	100	208	239	HEV2045486.1 DUF1326 domain-containing protein [Chthoniobacterales bacterium]	diamond	483	54.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
26905737	26905737	PRJNA976345_P_NODE_121961_length_178_cov_2.335664_g120353_i0	PRJNA976345	121961	178	2.335664	4.15748192	Terrimicrobium	1649503	Bacteria	Bacteria	53.5	2.31e-6	NR	HEY5770543.1	1965319	g120353	i0	100	2.52808988764045	25	0	42.1	0	2	76	111	135	HEY5770543.1 hypothetical protein [Terrimicrobium sp.]	diamond	450	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
27721500	27721500	PRJNA976345_P_NODE_164564_length_161_cov_0.944444_g162956_i0	PRJNA976345	164564	161	0.944444	1.52055484	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	97.1	4.19e-22	NR	HXK07799.1	2499141	g162956	i0	96.2	1.97515527950311	53	2	98.8	0	2	160	263	315	HXK07799.1 acetate/propionate family kinase [Verrucomicrobiia bacterium]	diamond	318	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28320876	28320876	PRJNA976345_P_NODE_117406_length_179_cov_2.020833_g115798_i0	PRJNA976345	117406	179	2.020833	3.61729107	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	62.8	6.86e-10	NR	MAH74865.1	2026801	g115798	i0	49.2	1.89385474860335	63	25	93.9	1	11	178	6	68	MAH74865.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	339	62.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28643069	28643069	PRJNA976345_P_NODE_148567_length_167_cov_1.446970_g146959_i0	PRJNA976345	148567	167	1.44697	2.4164399	Bacteria	2	Bacteria	Bacteria	55.1	5.91e-7	NR	NDB96443.1	2026799	g146959	i0	62.5	1.70658682634731	48	18	86.2	0	18	161	70	117	NDB96443.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	285	55.5	0.992792792792793	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29205229	29205229	PRJNA976345_P_NODE_58149_length_232_cov_2.680203_g56541_i0	PRJNA976345	58149	232	2.680203	6.21807096	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	83.2	1.79e-16	NR	NNC88090.1	2562705	g56541	i0	54.3	0.905172413793103	70	32	90.5	0	218	9	352	421	NNC88090.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	210	83.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
29646662	29646662	PRJNA976345_P_NODE_35630_length_286_cov_1.856574_g34023_i0	PRJNA976345	35630	286	1.856574	5.30980164	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	94.4	3.76e-20	NR	HXK04612.1	2499141	g34023	i0	50	1.02797202797203	98	45	98.6	1	283	2	336	433	HXK04612.1 sigma-54 dependent transcriptional regulator [Verrucomicrobiia bacterium]	diamond	294	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29836479	29836479	PRJNA976345_P_NODE_89291_length_198_cov_1.226994_g87683_i0	PRJNA976345	89291	198	1.226994	2.42944812	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	120	1.4e-33	NR	HXK02775.1	2499141	g87683	i0	78.8	1	66	14	100	0	1	198	42	107	HXK02775.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	198	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29906063	29906063	PRJNA976345_P_NODE_10051_length_547_cov_1.228516_g8538_i0	PRJNA976345	10051	547	1.228516	6.71998252	Pseudomonadati	3379134	Bacteria	Bacteria	308	3.18e-98	NR	MBV8100356.1	2026799	g8538	i0	88.4	1.97440585009141	181	21	99.3	0	1	543	407	587	MBV8100356.1 recombinase family protein [Verrucomicrobiota bacterium]	diamond	1080	308	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30879038	30879038	PRJNA976345_P_NODE_121014_length_178_cov_2.461538_g119406_i0	PRJNA976345	121014	178	2.461538	4.38153764	Opitutaceae bacterium	2006848	Bacteria	Bacteria	73.6	1.62e-13	NR	HND61291.1	2006848	g119406	i0	54.3	1.36516853932584	81	14	97.8	1	1	174	224	304	HND61291.1 N-acetylneuraminate synthase family protein [Opitutaceae bacterium]	diamond	243	73.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30917128	30917128	PRJNA976345_P_NODE_42354_length_265_cov_2.330435_g40746_i0	PRJNA976345	42354	265	2.330435	6.17565275	Bacteria	2	Bacteria	Bacteria	61.2	1.44e-8	NR	MDB6039876.1	2026801	g40746	i0	71.8	1.33584905660377	39	11	44.2	0	6	122	446	484	MDB6039876.1 cotH [Verrucomicrobiales bacterium]	diamond	354	61.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31100118	31100118	PRJNA976345_P_NODE_121935_length_178_cov_2.342657_g120327_i0	PRJNA976345	121935	178	2.342657	4.16992946	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	51.6	1.16e-5	NR	MBI5691046.1	2026799	g120327	i0	88	2.94943820224719	25	3	42.1	0	104	178	272	296	MBI5691046.1 HlyC/CorC family transporter [Verrucomicrobiota bacterium]	diamond	525	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31954099	31954099	PRJNA976345_P_NODE_167357_length_160_cov_0.960000_g165749_i0	PRJNA976345	167357	160	0.96	1.536	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	40	0.041	NR	HUF61096.1	2026801	g165749	i0	37.8	0.84375	45	24	84.4	1	159	25	64	104	HUF61096.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	135	40	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32017443	32017443	PRJNA976345_P_NODE_132958_length_174_cov_1.553957_g131350_i0	PRJNA976345	132958	174	1.553957	2.70388518	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	58.9	2.81e-8	NR	MBK27357.1	2026801	g131350	i0	46.3	2.82758620689655	54	29	93.1	0	172	11	252	305	MBK27357.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	492	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32175890	32175890	PRJNA976345_P_NODE_124138_length_178_cov_1.958042_g122530_i0	PRJNA976345	124138	178	1.958042	3.48531476	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	67.4	5.48e-13	NR	RYD46562.1	2026800	g122530	i0	90	0.50561797752809	30	3	50.6	0	89	178	1	30	RYD46562.1 MAG: zinc ribbon domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	90	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32182015	32182015	PRJNA976345_P_NODE_112798_length_182_cov_1.190476_g111190_i0	PRJNA976345	112798	182	1.190476	2.16666632	Pseudomonadati	3379134	Bacteria	Bacteria	113	1.01e-27	NR	MCX6910901.1	2026799	g111190	i0	85	2.96703296703297	60	9	98.9	0	2	181	21	80	MCX6910901.1 transposase [Verrucomicrobiota bacterium]	diamond	540	114	0.991228070175439	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);;