metadata: contig_metadata: 18 rows where bioproject = "PRJNA376117", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJNA376117", 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
399987	399987	PRJNA376117_P_NODE_34741_length_250_cov_1.305085_g34439_i0	PRJNA376117	34741	250	1.305085	3.2627125	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	1.19e-94	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g34439	i0	93.75	95.064	240	13	95	2	1	238	1315557	1315318	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	23766	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2950632	2950632	PRJNA376117_P_NODE_37343_length_248_cov_0.880000_g37041_i0	PRJNA376117	37343	248	0.88	2.1824	uncultured verrucomicrobium HF0070_15G23	723594	Bacteria	Bacteria	93.5	1.32e-14	NTclustered	gi\|297170473\|gb\|GU567957.1\|	723594	g37041	i0	77.64	5.33870967741935	161	31	64	4	33	190	16163	16005	Uncultured verrucomicrobium HF0070_15G23 genomic sequence	blastn	1324	93.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured verrucomicrobium HF0070_15G23
8052863	8052863	PRJNA376117_P_NODE_10187_length_421_cov_2.436782_g9885_i0	PRJNA376117	10187	421	2.436782	10.25885222	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	617	3.19e-172	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g9885	i0	93.128	79.5914489311164	422	27	100	2	1	421	5152796	5152376	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33508	617	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8052900	8052900	PRJNA376117_P_NODE_13187_length_375_cov_1.374172_g12885_i0	PRJNA376117	13187	375	1.374172	5.153145	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	181	1.03e-51	NR	RYD60109.1	2026800	g12885	i0	74.4	2	125	32	100	0	375	1	137	261	RYD60109.1 MAG: hypothetical protein EOP83_20225 [Verrucomicrobiaceae bacterium]	diamond	750	181	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
19526016	19526016	PRJNA376117_P_NODE_6376_length_532_cov_1.941176_g6076_i0	PRJNA376117	6376	532	1.941176	10.32705632	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	833	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g6076	i0	94.925	178.146616541353	532	27	100	0	1	532	5153565	5154096	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	94774	833	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20199752	20199752	PRJNA376117_P_NODE_24736_length_283_cov_2.052381_g24434_i0	PRJNA376117	24736	283	2.052381	5.80823823	Verrucomicrobiota	74201	Bacteria	Bacteria	451	2.1999999999999995e-122	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g24434	i0	95.406	120.049469964664	283	13	100	0	1	283	5154271	5154553	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33974	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20801337	20801337	PRJNA376117_P_NODE_27977_length_272_cov_1.547739_g27675_i0	PRJNA376117	27977	272	1.547739	4.20985008	Akkermansia muciniphila	239935	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g27675	i0	100	2.23897058823529	29	0	11	0	221	249	1454019	1453991	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	609	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
22076429	22076429	PRJNA376117_P_NODE_31778_length_258_cov_1.664865_g31476_i0	PRJNA376117	31778	258	1.664865	4.2953517	Horticoccus luteus	2862869	Bacteria	Bacteria	111	3.82e-20	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g31476	i0	86.869	3.46124031007752	99	13	38	0	159	257	1507126	1507028	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	893	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
23351661	23351661	PRJNA376117_P_NODE_15499_length_348_cov_2.716364_g15197_i0	PRJNA376117	15499	348	2.716364	9.45294672	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	462	1.2799999999999998e-125	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g15197	i0	90.988	82.0632183908046	344	30	99	1	6	348	1316202	1315859	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	28558	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23352123	23352123	PRJNA376117_P_NODE_5659_length_570_cov_1.849095_g5361_i0	PRJNA376117	5659	570	1.849095	10.5398415	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	863	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g5361	i0	93.913	211.438596491228	575	29	100	6	1	570	1315284	1315857	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	120520	863	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26870837	26870837	PRJNA376117_P_NODE_28101_length_272_cov_1.140704_g27799_i0	PRJNA376117	28101	272	1.140704	3.10271488	Bacteria	2	Bacteria	Bacteria	45.4	0.00569	NR	MDP4643832.1	2026772	g27799	i0	39.7	3.19852941176471	58	35	64	0	233	60	2	59	MDP4643832.1 glycosyltransferase [Opitutales bacterium]	diamond	870	45.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
28117042	28117042	PRJNA376117_P_NODE_27985_length_272_cov_1.542714_g27683_i0	PRJNA376117	27985	272	1.542714	4.19618208	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	58.9	1.07e-7	NR	HUA62969.1	2499141	g27683	i0	43.6	0.860294117647059	78	37	86	2	255	22	773	843	HUA62969.1 family 78 glycoside hydrolase catalytic domain [Verrucomicrobiia bacterium]	diamond	234	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28622477	28622477	PRJNA376117_P_NODE_17787_length_328_cov_0.905882_g17485_i0	PRJNA376117	17787	328	0.905882	2.97129296	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	65.5	4.71e-10	NR	RYD62543.1	2026800	g17485	i0	61.4	0.402439024390244	44	17	40.2	0	194	325	1	44	RYD62543.1 MAG: hypothetical protein EOP83_14325 [Verrucomicrobiaceae bacterium]	diamond	132	65.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30517240	30517240	PRJNA376117_P_NODE_8333_length_464_cov_2.529412_g8031_i0	PRJNA376117	8333	464	2.529412	11.73647168	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	59.3	4.91e-8	NR	MDA0321252.1	2026799	g8031	i0	56.9	0.65948275862069	51	22	33	0	463	311	72	122	MDA0321252.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	306	59.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31387771	31387771	PRJNA376117_P_NODE_29036_length_268_cov_2.087179_g28734_i0	PRJNA376117	29036	268	2.087179	5.59363972	Bacteria	2	Bacteria	Bacteria	69.3	2.23e-11	NR	MEI6074512.1	2026799	g28734	i0	58.5	2.21641791044776	53	22	59.3	0	267	109	63	115	MEI6074512.1 kelch repeat-containing protein [Verrucomicrobiota bacterium]	diamond	594	69.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32129884	32129884	PRJNA376117_P_NODE_39378_length_246_cov_0.890173_g39076_i0	PRJNA376117	39378	246	0.890173	2.18982558	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	53.1	1.32e-6	NR	RYD61498.1	2026800	g39076	i0	55.6	0.548780487804878	45	20	54.9	0	23	157	63	107	RYD61498.1 MAG: hypothetical protein EOP83_16875, partial [Verrucomicrobiaceae bacterium]	diamond	135	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32256618	32256618	PRJNA376117_P_NODE_29058_length_268_cov_1.815385_g28756_i0	PRJNA376117	29058	268	1.815385	4.8652318	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	126	1.01e-31	NR	RYD60109.1	2026800	g28756	i0	76.5	1.77985074626866	81	19	90.7	0	267	25	5	85	RYD60109.1 MAG: hypothetical protein EOP83_20225 [Verrucomicrobiaceae bacterium]	diamond	477	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32400073	32400073	PRJNA376117_P_NODE_41699_length_244_cov_0.894737_g41397_i0	PRJNA376117	41699	244	0.894737	2.18315828	Pseudomonadati	3379134	Bacteria	Bacteria	122	6.19e-34	NR	MFP4542229.1	2026772	g41397	i0	73.8	2.95081967213115	80	21	98.4	0	3	242	17	96	MFP4542229.1 VTT domain-containing protein [Opitutales bacterium]	diamond	720	123	0.991869918699187	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales 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);;