metadata: contig_metadata: 25 rows where bioproject = "PRJNA1068830", tax_clade = "PVC group" and tax

25 rows where bioproject = "PRJNA1068830", 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
1014311	1014311	PRJNA1068830_P_NODE_71641_length_254_cov_1.464088_g70938_i0	PRJNA1068830	71641	254	1.464088	3.71878352	Akkermansia	239934	Bacteria	Bacteria	246	9.859999999999999e-61	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g70938	i0	100	49.1692913385827	133	0	52	0	1	133	1025891	1026023	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	12489	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
3564602	3564602	PRJNA1068830_P_NODE_21023_length_519_cov_1.553812_g20322_i0	PRJNA1068830	21023	519	1.553812	8.06428428	Bacteria	2	Bacteria	Bacteria	787	0	NTclustered	gi\|60266416\|gb\|AY921870.1\|	156588	g20322	i0	94.038	96.7976878612717	520	29	100	2	1	519	521	3	Uncultured Verrucomicrobia bacterium clone AKYG386 16S ribosomal RNA gene, partial sequence	blastn	50238	787	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4009761	4009761	PRJNA1068830_P_NODE_63944_length_271_cov_1.833333_g63241_i0	PRJNA1068830	63944	271	1.833333	4.96833243	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	254	6.35e-63	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g63241	i0	93.529	64.2029520295203	170	11	63	0	1	170	3990701	3990870	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	17399	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
7835474	7835474	PRJNA1068830_P_NODE_50147_length_309_cov_1.983051_g49444_i0	PRJNA1068830	50147	309	1.983051	6.12762759	Methylacidimicrobium sp. B4	2796139	Bacteria	Bacteria	370	7.01e-98	NTclustered	gi\|1999103383\|gb\|CP066203.1\|	2796139	g49444	i0	88.525	7.03883495145631	305	35	99	0	1	305	125508	125812	Methylacidimicrobium sp. B4 chromosome, complete genome	blastn	2175	370	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. B4
8667459	8667459	PRJNA1068830_P_NODE_59287_length_283_cov_0.928571_g58584_i0	PRJNA1068830	59287	283	0.928571	2.62785593	Akkermansia	239934	Bacteria	Bacteria	507	4.64e-139	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g58584	i0	98.94	94.9540636042403	283	3	100	0	1	283	2393422	2393140	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	26872	507	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
9111187	9111187	PRJNA1068830_P_NODE_7648_length_927_cov_2.555035_g7077_i0	PRJNA1068830	7648	927	2.555035	23.68517445	Pedosphaera parvula	1032527	Bacteria	Bacteria	1061	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g7077	i0	87.42	196.663430420712	938	99	100	18	1	927	1639	710	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	182307	1061	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
10387112	10387112	PRJNA1068830_P_NODE_85269_length_244_cov_0.912281_g84566_i0	PRJNA1068830	85269	244	0.912281	2.22596564	Akkermansia muciniphila	239935	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g84566	i0	93.724	26.8729508196721	239	8	95	2	1	232	1849227	1849465	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	6557	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
15486463	15486463	PRJNA1068830_P_NODE_82653_length_246_cov_0.901734_g81950_i0	PRJNA1068830	82653	246	0.901734	2.21826564	Akkermansia glycaniphila	1679444	Bacteria	Bacteria	82	5.33e-18	NR	OCA02583.1	1679444	g81950	i0	95.3	1.04878048780488	43	2	52.4	0	246	118	71	113	OCA02583.1 transposase [Akkermansia glycaniphila]	diamond	258	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia glycaniphila
15486570	15486570	PRJNA1068830_P_NODE_87153_length_243_cov_0.917647_g86450_i0	PRJNA1068830	87153	243	0.917647	2.22988221	Akkermansia muciniphila	239935	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g86450	i0	99.588	95.4444444444444	243	1	100	0	1	243	1490564	1490322	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	23193	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
16760578	16760578	PRJNA1068830_P_NODE_78634_length_249_cov_0.886364_g77931_i0	PRJNA1068830	78634	249	0.886364	2.20704636	Akkermansia muciniphila	239935	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2623923984\|gb\|CP115935.1\|	239935	g77931	i0	99.598	14	249	1	100	0	1	249	156275	156027	Akkermansia muciniphila strain SDLYAKK8 chromosome, complete genome	blastn	3486	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20584032	20584032	PRJNA1068830_P_NODE_49657_length_311_cov_1.457983_g48954_i0	PRJNA1068830	49657	311	1.457983	4.53432713	Akkermansia muciniphila	239935	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|2051353120\|gb\|CP072035.1\|	239935	g48954	i0	100	38.411575562701	311	0	100	0	1	311	2448027	2448337	Akkermansia muciniphila strain Akk1576 chromosome, complete genome	blastn	11946	575	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20584695	20584695	PRJNA1068830_P_NODE_77057_length_250_cov_0.881356_g76354_i0	PRJNA1068830	77057	250	0.881356	2.20339	Akkermansia muciniphila	239935	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g76354	i0	100	100	250	0	100	0	1	250	1338137	1338386	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	25000	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20584806	20584806	PRJNA1068830_P_NODE_81397_length_247_cov_0.896552_g80694_i0	PRJNA1068830	81397	247	0.896552	2.21448344	Akkermansia muciniphila	239935	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g80694	i0	96.356	40.82995951417	247	9	100	0	1	247	1850486	1850732	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	10085	407	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
23135882	23135882	PRJNA1068830_P_NODE_74059_length_252_cov_0.871508_g73356_i0	PRJNA1068830	74059	252	0.871508	2.19620016	Akkermansia muciniphila	239935	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1510315172\|gb\|CP024736.1\|	239935	g73356	i0	100	99.9880952380952	252	0	100	0	1	252	1509647	1509898	Akkermansia muciniphila strain EB-AMDK-1 chromosome, complete genome	blastn	25197	466	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
23966715	23966715	PRJNA1068830_P_NODE_71919_length_253_cov_2.094444_g71216_i0	PRJNA1068830	71919	253	2.094444	5.29894332	Akkermansia	239934	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g71216	i0	100	94.9604743083004	253	0	100	0	1	253	1768351	1768099	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	24025	468	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
24409602	24409602	PRJNA1068830_P_NODE_78120_length_249_cov_0.886364_g77417_i0	PRJNA1068830	78120	249	0.886364	2.20704636	Akkermansia muciniphila	239935	Bacteria	Bacteria	453	5.29e-123	NTclustered	gi\|2623923984\|gb\|CP115935.1\|	239935	g77417	i0	99.598	8.36144578313253	249	0	100	1	1	249	176065	175818	Akkermansia muciniphila strain SDLYAKK8 chromosome, complete genome	blastn	2082	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
27098914	27098914	PRJNA1068830_P_NODE_78602_length_249_cov_0.886364_g77899_i0	PRJNA1068830	78602	249	0.886364	2.20704636	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	57.4	2.62e-7	NR	MBV9009557.1	2026799	g77899	i0	53.7	2.12048192771084	54	24	65.1	1	2	163	82	134	MBV9009557.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	528	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27541384	27541384	PRJNA1068830_P_NODE_70124_length_257_cov_1.695652_g69421_i0	PRJNA1068830	70124	257	1.695652	4.35782564	Opitutaceae bacterium	2006848	Bacteria	Bacteria	42.7	0.045	NR	HEY1764242.1	2006848	g69421	i0	33.8	0.793774319066148	68	37	70	2	47	226	499	566	HEY1764242.1 right-handed parallel beta-helix repeat-containing protein [Opitutaceae bacterium]	diamond	204	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28101057	28101057	PRJNA1068830_P_NODE_83745_length_245_cov_0.906977_g83042_i0	PRJNA1068830	83745	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	53.5	3.19e-6	NR	MCX6961305.1	2026799	g83042	i0	42.7	6.24489795918367	75	39	86.9	2	7	219	104	178	MCX6961305.1 YbjN domain-containing protein [Verrucomicrobiota bacterium]	diamond	1530	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28606322	28606322	PRJNA1068830_P_NODE_86647_length_243_cov_0.917647_g85944_i0	PRJNA1068830	86647	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	140	5.54e-38	NR	MBI4658269.1	2026799	g85944	i0	77.8	9	81	18	100	0	1	243	288	368	MBI4658269.1 terpene cyclase/mutase family protein [Verrucomicrobiota bacterium]	diamond	2187	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28804005	28804005	PRJNA1068830_P_NODE_83028_length_245_cov_3.627907_g82325_i0	PRJNA1068830	83028	245	3.627907	8.88837215	Verrucomicrobiia bacterium Tous-C3TDCM	1982330	Bacteria	Bacteria	44.3	0.0107	NR	PAW61727.1	1982330	g82325	i0	34.7	0.918367346938776	75	49	91.8	0	2	226	324	398	PAW61727.1 MAG: RIP metalloprotease RseP [Verrucomicrobiia bacterium Tous-C3TDCM]	diamond	225	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium Tous-C3TDCM
31489664	31489664	PRJNA1068830_P_NODE_24696_length_471_cov_1.070352_g23995_i0	PRJNA1068830	24696	471	1.070352	5.04135792	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	163	1.34e-47	NR	MAD23566.1	2026801	g23995	i0	59	0.853503184713376	134	50	82.2	1	402	16	1	134	MAD23566.1 thymidylate synthase (FAD) [Verrucomicrobiales bacterium]	diamond	402	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31837185	31837185	PRJNA1068830_P_NODE_76417_length_250_cov_1.305085_g75714_i0	PRJNA1068830	76417	250	1.305085	3.2627125	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	52.4	1.08e-5	NR	HXT85908.1	2499141	g75714	i0	37.1	0.744	62	38	74.4	1	3	188	167	227	HXT85908.1 lipid-binding SYLF domain-containing protein [Verrucomicrobiia bacterium]	diamond	186	52.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31932132	31932132	PRJNA1068830_P_NODE_25357_length_463_cov_1.748718_g24655_i0	PRJNA1068830	25357	463	1.748718	8.09656434	Methylacidimicrobium sp. B4	2796139	Bacteria	Bacteria	277	3.3499999999999998e-90	NR	WP_206863961.1	2796139	g24655	i0	90.9	1.97624190064795	154	14	99.8	0	462	1	194	347	WP_206863961.1 IS256 family transposase [Methylacidimicrobium sp. B4]	diamond	915	277	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. B4
32090483	32090483	PRJNA1068830_P_NODE_65018_length_269_cov_1.326531_g64315_i0	PRJNA1068830	65018	269	1.326531	3.56836839	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	81.3	9.86e-16	NR	NNE90836.1	2026801	g64315	i0	47.7	1.97397769516729	88	43	98.1	2	264	1	64	148	NNE90836.1 2-aminoethylphosphonate--pyruvate transaminase [Verrucomicrobiales bacterium]	diamond	531	81.3	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);;