metadata: contig_metadata: 17 rows where bioproject = "PRJNA680334", tax_clade = "PVC group" and tax

17 rows where bioproject = "PRJNA680334", 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
3721141	3721141	PRJNA680334_S_NODE_82443_length_163_cov_4.753846_g81957_i0	PRJNA680334	82443	163	4.753846	7.74876898	Verrucomicrobium	2735	Bacteria	Bacteria	200	4.589999999999999e-47	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g81957	i0	89.441	168.39263803681	161	14	98	2	1	159	347	506	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	27448	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
7027911	7027911	PRJNA680334_S_NODE_15246_length_276_cov_8.242798_g14760_i0	PRJNA680334	15246	276	8.242798	22.75012248	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	196	1.11e-45	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g14760	i0	80.135	1.07608695652174	297	31	99	18	1	273	1818519	1818811	Luteolibacter sp. SL250 chromosome	blastn	297	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
8303756	8303756	PRJNA680334_S_NODE_84007_length_162_cov_4.775194_g83521_i0	PRJNA680334	84007	162	4.775194	7.73581428	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	220	3.49e-53	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g83521	i0	91.772	278.530864197531	158	13	98	0	5	162	2190	2347	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	45122	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
17227585	17227585	PRJNA680334_S_NODE_30554_length_223_cov_6.284211_g30068_i0	PRJNA680334	30554	223	6.284211	14.01379053	Luteolibacter sp.	1962973	Bacteria	Bacteria	351	1.74e-92	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g30068	i0	95.853	199.856502242152	217	9	97	0	7	223	1009882	1010098	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	44568	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
18501351	18501351	PRJNA680334_S_NODE_10115_length_313_cov_7.096429_g9629_i0	PRJNA680334	10115	313	7.096429	22.21182277	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	217	9.81e-52	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g9629	i0	80	47.3546325878594	320	42	97	19	1	305	5627106	5627418	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	14822	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
19776154	19776154	PRJNA680334_S_NODE_16676_length_269_cov_3.169492_g16190_i0	PRJNA680334	16676	269	3.169492	8.52593348	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	268	2.2499999999999994e-67	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g16190	i0	84.982	285.650557620818	273	32	100	7	1	269	1346	1079	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	76840	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
27366716	27366716	PRJNA680334_S_NODE_94603_length_156_cov_3.642276_g94117_i0	PRJNA680334	94603	156	3.642276	5.68195056	Prosthecobacter sp.	1965333	Bacteria	Bacteria	48.9	2.64e-5	NR	HEY1052478.1	1965333	g94117	i0	91.7	0.461538461538462	24	2	46.2	0	154	83	122	145	HEY1052478.1 hypothetical protein [Prosthecobacter sp.]	diamond	72	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
27934846	27934846	PRJNA680334_S_NODE_47805_length_194_cov_5.894410_g47319_i0	PRJNA680334	47805	194	5.89441	11.4351554	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	41.6	0.0238	NR	MFT5409024.1	2026801	g47319	i0	37.5	0.865979381443299	56	35	86.6	0	15	182	16	71	MFT5409024.1 Fe-S-cluster containining protein [Verrucomicrobiales bacterium]	diamond	168	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28124293	28124293	PRJNA680334_S_NODE_81265_length_164_cov_2.946565_g80779_i0	PRJNA680334	81265	164	2.946565	4.8323666	Akkermansia sp.	1872421	Bacteria	Bacteria	51.6	2.89e-6	NR	MBQ3143436.1	1872421	g80779	i0	49.1	0.969512195121951	53	23	89.6	1	17	163	65	117	MBQ3143436.1 hypothetical protein [Akkermansia sp.]	diamond	159	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
29797512	29797512	PRJNA680334_S_NODE_52211_length_189_cov_3.967949_g51725_i0	PRJNA680334	52211	189	3.967949	7.49942361	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	43.1	0.0136	NR	HAL05353.1	2026801	g51725	i0	38.5	3.3015873015873	52	24	71.4	2	55	189	4	54	HAL05353.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	624	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30176656	30176656	PRJNA680334_S_NODE_71432_length_171_cov_3.152174_g70946_i0	PRJNA680334	71432	171	3.152174	5.39021754	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	50.4	2.67e-5	NR	HEU5069142.1	2499141	g70946	i0	60	1.19298245614035	35	14	61.4	0	37	141	282	316	HEU5069142.1 bile acid:sodium symporter family protein [Verrucomicrobiia bacterium]	diamond	204	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30429875	30429875	PRJNA680334_S_NODE_18673_length_260_cov_2.488987_g18187_i0	PRJNA680334	18673	260	2.488987	6.4713662	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	109	1.29e-25	NR	WP_146854010.1	748831	g18187	i0	68.7	0.957692307692308	83	26	95.8	0	1	249	993	1075	WP_146854010.1 FtsX-like permease family protein [Brevifollis gellanilyticus]	diamond	249	109	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
30587341	30587341	PRJNA680334_S_NODE_82173_length_163_cov_9.253846_g81687_i0	PRJNA680334	82173	163	9.253846	15.08376898	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	80.9	2.06e-16	NR	MBA3834005.1	2201154	g81687	i0	82.2	0.828220858895706	45	8	82.8	0	1	135	272	316	MBA3834005.1 IS481 family transposase [Chthoniobacterales bacterium]	diamond	135	80.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31187466	31187466	PRJNA680334_S_NODE_23235_length_243_cov_2.619048_g22749_i0	PRJNA680334	23235	243	2.619048	6.36428664	Terrimicrobium sacchariphilum	690879	Bacteria	Bacteria	43.9	0.0142	NR	WP_075080473.1	690879	g22749	i0	52.1	0.592592592592593	48	23	59.3	0	144	1	6	53	WP_075080473.1 hypothetical protein [Terrimicrobium sacchariphilum]	diamond	144	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
31377695	31377695	PRJNA680334_S_NODE_67836_length_174_cov_2.758865_g67350_i0	PRJNA680334	67836	174	2.758865	4.8004251	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	57.4	9.75e-9	NR	HEY2680206.1	2665650	g67350	i0	93.3	3.06896551724138	30	2	51.7	0	2	91	62	91	HEY2680206.1 biotin/lipoyl-containing protein [Candidatus Udaeobacter sp.]	diamond	534	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
31599152	31599152	PRJNA680334_S_NODE_93016_length_157_cov_2.967742_g92530_i0	PRJNA680334	93016	157	2.967742	4.65935494	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	94	2.1e-21	NR	HEX7516570.1	2201154	g92530	i0	84.6	1.96815286624204	52	8	99.4	0	157	2	90	141	HEX7516570.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	309	94	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32611173	32611173	PRJNA680334_S_NODE_76040_length_168_cov_1.555556_g75554_i0	PRJNA680334	76040	168	1.555556	2.61333408	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	91.7	6.55e-20	NR	HXT84495.1	2499141	g75554	i0	93.5	0.821428571428571	46	3	82.1	0	31	168	86	131	HXT84495.1 phosphopantothenoylcysteine decarboxylase [Verrucomicrobiia bacterium]	diamond	138	91.7	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);;