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

17 rows where bioproject = "PRJNA438572", 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
1090915	1090915	PRJNA438572_P_NODE_10121_length_322_cov_2.016064_g10002_i0	PRJNA438572	10121	322	2.016064	6.49172608	Verrucomicrobiota	74201	Bacteria	Bacteria	507	5.37e-139	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g10002	i0	95.062	35.7763975155279	324	12	100	3	1	322	5153022	5153343	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	11520	512	0.990234375	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1709769	1709769	PRJNA438572_P_NODE_12642_length_290_cov_1.437788_g12523_i0	PRJNA438572	12642	290	1.437788	4.1695852	Horticoccus luteus	2862869	Bacteria	Bacteria	464	2.9099999999999993e-126	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g12523	i0	95.517	221.68275862069	290	13	100	0	1	290	541268	541557	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	64288	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
8088129	8088129	PRJNA438572_P_NODE_14667_length_272_cov_1.070352_g14548_i0	PRJNA438572	14667	272	1.070352	2.91135744	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	60.2	1.49e-4	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g14548	i0	100	0.117647058823529	32	0	12	0	138	169	3648388	3648419	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	32	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
13188878	13188878	PRJNA438572_P_NODE_791_length_1009_cov_1.526709_g720_i0	PRJNA438572	791	1009	1.526709	15.40449381	Chthoniobacter sp.	2510640	Bacteria	Bacteria	612	4.389999999999999e-218	NR	MDR3405335.1	2510640	g720	i0	87.2	0.99603567888999	335	43	99.6	0	3	1007	114	448	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	1005	612	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
24661177	24661177	PRJNA438572_P_NODE_14520_length_273_cov_1.525000_g14401_i0	PRJNA438572	14520	273	1.525	4.16325	Prosthecobacter	48463	Bacteria	Bacteria	181	1.65e-51	NR	WP_395735938.1	1965333	g14401	i0	88.9	2.96703296703297	90	10	98.9	0	271	2	367	456	WP_395735938.1 type VI secretion system Vgr family protein [Prosthecobacter sp.]	diamond	810	181	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
26632804	26632804	PRJNA438572_P_NODE_1481_length_782_cov_3.152327_g1379_i0	PRJNA438572	1481	782	3.152327	24.65119714	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	68.2	1.18e-9	NR	MEO5753320.1	2201154	g1379	i0	33.8	1.03964194373402	145	88	55.2	4	756	325	83	220	MEO5753320.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	813	68.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
26822968	26822968	PRJNA438572_P_NODE_12981_length_287_cov_1.294393_g12862_i0	PRJNA438572	12981	287	1.294393	3.71490791	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	85.9	3.06e-17	NR	MCX6908820.1	2026799	g12862	i0	50.5	0.993031358885017	95	46	99.3	1	286	2	25	118	MCX6908820.1 glycosidase [Verrucomicrobiota bacterium]	diamond	285	85.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26997220	26997220	PRJNA438572_P_NODE_21642_length_246_cov_0.901734_g21523_i0	PRJNA438572	21642	246	0.901734	2.21826564	Bacteria	2	Bacteria	Bacteria	77.4	2.53e-14	NR	HOW66288.1	2026799	g21523	i0	46.3	3.03658536585366	82	40	100	1	246	1	1898	1975	HOW66288.1 S8 family serine peptidase [Verrucomicrobiota bacterium]	diamond	747	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27107410	27107410	PRJNA438572_P_NODE_18162_length_251_cov_0.876404_g18043_i0	PRJNA438572	18162	251	0.876404	2.19977404	Opitutia bacterium	2026771	Bacteria	Bacteria	50.4	7.84e-5	NR	MBP52139.1	2026771	g18043	i0	28.9	0.99203187250996006	83	57	99.2	1	250	2	481	561	MBP52139.1 hypothetical protein [Opitutia bacterium]	diamond	249	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
28149979	28149979	PRJNA438572_P_NODE_18625_length_250_cov_1.762712_g18506_i0	PRJNA438572	18625	250	1.762712	4.40678	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	67.4	7.69e-11	NR	MCW5552011.1	2499141	g18506	i0	40.2	1.86	82	49	98.4	0	248	3	219	300	MCW5552011.1 serpin family protein [Verrucomicrobiia bacterium]	diamond	465	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30186968	30186968	PRJNA438572_P_NODE_19612_length_249_cov_0.886364_g19493_i0	PRJNA438572	19612	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	106	1.36e-24	NR	MFM1850494.1	2026799	g19493	i0	63.5	5.40963855421687	74	27	89.2	0	25	246	215	288	MFM1850494.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1347	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30265850	30265850	PRJNA438572_P_NODE_1132_length_875_cov_2.639651_g1041_i0	PRJNA438572	1132	875	2.639651	23.09694625	Luteolibacter sp.	1962973	Bacteria	Bacteria	59.7	6.26e-6	NR	WP_348214599.1	1962973	g1041	i0	27.2	0.706285714285714	206	126	67.9	10	616	23	318	507	WP_348214599.1 RICIN domain-containing protein [Luteolibacter sp.]	diamond	618	59.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
31893943	31893943	PRJNA438572_P_NODE_8097_length_357_cov_1.866197_g7978_i0	PRJNA438572	8097	357	1.866197	6.66232329	Bacteria	2	Bacteria	Bacteria	53.1	2.26e-5	NR	MCL4790395.1	2026799	g7978	i0	29.6	1.26890756302521	98	65	80.7	2	291	4	24	119	MCL4790395.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	453	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32099103	32099103	PRJNA438572_P_NODE_22058_length_245_cov_0.906977_g21939_i0	PRJNA438572	22058	245	0.906977	2.22209365	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	64.3	8.74e-10	NR	HEX2748794.1	2026801	g21939	i0	51.6	0.783673469387755	64	27	73.5	2	240	61	315	378	HEX2748794.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	192	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32542358	32542358	PRJNA438572_P_NODE_15059_length_268_cov_1.451282_g14940_i0	PRJNA438572	15059	268	1.451282	3.88943576	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	67	1.46e-10	NR	MES2467641.1	2026799	g14940	i0	55.1	0.996268656716418	89	40	99.6	0	2	268	381	469	MES2467641.1 LptA/OstA family protein [Verrucomicrobiota bacterium]	diamond	267	67	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32699556	32699556	PRJNA438572_P_NODE_14640_length_272_cov_1.301508_g14521_i0	PRJNA438572	14640	272	1.301508	3.54010176	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	44.3	0.0119	NR	HEX8280769.1	2201154	g14521	i0	34.8	1.48897058823529	66	42	71.7	1	48	242	157	222	HEX8280769.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	405	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32888435	32888435	PRJNA438572_P_NODE_22020_length_245_cov_0.906977_g21901_i0	PRJNA438572	22020	245	0.906977	2.22209365	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	57	3.59e-7	NR	MCP5516395.1	2026801	g21901	i0	44.3	0.857142857142857	70	36	85.7	1	240	31	583	649	MCP5516395.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	210	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;