metadata: contig_metadata: 20 rows where bioproject = "PRJNA1198392", tax_clade = "PVC group" and tax

20 rows where bioproject = "PRJNA1198392", tax_clade = "PVC group" and tax_superkingdom = "Bacteria"

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
324600	324600	PRJNA1198392_P_NODE_19921_length_244_cov_0.859649_g19780_i0	PRJNA1198392	19921	244	0.859649	2.09754356	Phycisphaerae	666505	Bacteria	Bacteria	76.3	5.85e-14	NR	UCD76450.1	2052180	g19780	i0	84.1	1.63524590163934	44	7	54.1	0	1	132	464	507	UCD76450.1 MAG: sugar ABC transporter ATP-binding protein [Phycisphaerales bacterium]	diamond	399	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
4151589	4151589	PRJNA1198392_P_NODE_21164_length_241_cov_0.916667_g21023_i0	PRJNA1198392	21164	241	0.916667	2.20916747	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	350	6.87e-92	NTclustered	gi\|159234363\|emb\|AM902605.1\|	120965	g21023	i0	92.946	99.5145228215768	241	16	100	1	1	241	1445	1206	Uncultured planctomycete partial 16S rRNA gene, isolate OTU37/APA	blastn	23983	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
11802957	11802957	PRJNA1198392_P_NODE_11770_length_273_cov_3.270000_g11629_i0	PRJNA1198392	11770	273	3.27	8.9271	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	311	3.75e-80	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g11629	i0	87.226	131.608058608059	274	33	100	2	1	273	1156951	1157223	Planctomyces sp. SH-PL62, complete genome	blastn	35929	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
13078063	13078063	PRJNA1198392_P_NODE_12851_length_268_cov_1.579487_g12710_i0	PRJNA1198392	12851	268	1.579487	4.23302516	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	65.5	5.09e-10	NR	HEV2296228.1	2876886	g12710	i0	75.6	0.458955223880597	41	10	45.9	0	267	145	670	710	HEV2296228.1 response regulator [Tepidisphaeraceae bacterium]	diamond	123	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
14353757	14353757	PRJNA1198392_P_NODE_6172_length_326_cov_0.762846_g6031_i0	PRJNA1198392	6172	326	0.762846	2.48687796	Urbifossiella limnaea	2528023	Bacteria	Bacteria	414	3.39e-111	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6031	i0	90.221	208.631901840491	317	31	97	0	10	326	2018501	2018817	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	68014	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
16901811	16901811	PRJNA1198392_P_NODE_21154_length_241_cov_0.916667_g21013_i0	PRJNA1198392	21154	241	0.916667	2.20916747	Humisphaera borealis	2807512	Bacteria	Bacteria	263	9.21e-66	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g21013	i0	87.045	473.394190871369	247	15	96	8	5	235	5065267	5065512	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	114088	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
18176124	18176124	PRJNA1198392_P_NODE_14155_length_260_cov_3.000000_g14014_i0	PRJNA1198392	14155	260	3	7.8	Gemmataceae bacterium	2052164	Bacteria	Bacteria	143	1.37e-29	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g14014	i0	94.624	6.97307692307692	93	4	36	1	56	148	4154584	4154675	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	1813	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26660730	26660730	PRJNA1198392_P_NODE_10961_length_278_cov_1.141463_g10820_i0	PRJNA1198392	10961	278	1.141463	3.17326714	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.6	7.15e-7	NR	RMD62086.1	2026780	g10820	i0	40.3	0.669064748201439	62	37	66.9	0	277	92	366	427	RMD62086.1 MAG: hypothetical protein D6824_07215, partial [Planctomycetota bacterium]	diamond	186	56.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26945866	26945866	PRJNA1198392_P_NODE_9242_length_286_cov_1.272300_g9101_i0	PRJNA1198392	9242	286	1.2723	3.638778	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	48.5	1.52e-4	NR	HEY4951770.1	2499141	g9101	i0	50	0.461538461538462	44	22	46.2	0	90	221	80	123	HEY4951770.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	132	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27376232	27376232	PRJNA1198392_P_NODE_14863_length_256_cov_1.683060_g14722_i0	PRJNA1198392	14863	256	1.68306	4.3086336	Chthoniobacter	295577	Bacteria	Bacteria	122	5.6399999999999995e-30	NR	WP_006977497.1	191863	g14722	i0	75.9	7.828125	83	20	97.3	0	6	254	454	536	WP_006977497.1 ATP-dependent RNA helicase HrpA [Chthoniobacter flavus]	diamond	2004	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
28556990	28556990	PRJNA1198392_P_NODE_12747_length_268_cov_2.656410_g12606_i0	PRJNA1198392	12747	268	2.65641	7.1191788	Limisphaerales bacterium	2052186	Bacteria	Bacteria	53.1	1.15e-5	NR	MFN0067579.1	2052186	g12606	i0	45.3	0.593283582089552	53	29	59.3	0	168	10	600	652	MFN0067579.1 LamG-like jellyroll fold domain-containing protein [Limisphaerales bacterium]	diamond	159	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
28746281	28746281	PRJNA1198392_P_NODE_19067_length_245_cov_0.895349_g18926_i0	PRJNA1198392	19067	245	0.895349	2.19360505	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	152	1.6799999999999994e-42	NR	HMP76488.1	2212473	g18926	i0	93.8	0.991836734693878	81	5	99.2	0	243	1	17	97	HMP76488.1 5-(carboxyamino)imidazole ribonucleotide synthase [Kiritimatiellia bacterium]	diamond	243	152	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
28809108	28809108	PRJNA1198392_P_NODE_18588_length_246_cov_0.890173_g18447_i0	PRJNA1198392	18588	246	0.890173	2.18982558	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	133	1.7999999999999998e-36	NR	RYD81718.1	2026800	g18447	i0	80	1.96341463414634	80	16	97.6	0	3	242	20	99	RYD81718.1 MAG: AI-2E family transporter [Verrucomicrobiaceae bacterium]	diamond	483	133	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29144385	29144385	PRJNA1198392_P_NODE_8269_length_290_cov_1.419355_g8128_i0	PRJNA1198392	8269	290	1.419355	4.1161295	Tautonia	2680020	Bacteria	Bacteria	47	0.00202	NR	WP_390622223.1	2653855	g8128	i0	95.2	0.651724137931034	21	1	21.7	0	1	63	414	434	WP_390622223.1 hypothetical protein [Tautonia marina]	diamond	189	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia marina
29598495	29598495	PRJNA1198392_P_NODE_16170_length_250_cov_1.740113_g16029_i0	PRJNA1198392	16170	250	1.740113	4.3502825	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0159	NR	RME79982.1	2026780	g16029	i0	37.7	0.636	53	33	63.6	0	204	46	455	507	RME79982.1 MAG: hypothetical protein D6785_10785 [Planctomycetota bacterium]	diamond	159	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29914751	29914751	PRJNA1198392_P_NODE_10751_length_279_cov_1.199029_g10610_i0	PRJNA1198392	10751	279	1.199029	3.34529091	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	153	2.3499999999999992e-43	NR	HEV2293406.1	2876886	g10610	i0	76.9	0.978494623655914	91	21	97.8	0	3	275	176	266	HEV2293406.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	273	153	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31052255	31052255	PRJNA1198392_P_NODE_19355_length_244_cov_3.210526_g19214_i0	PRJNA1198392	19355	244	3.210526	7.83368344	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	92.8	7.98e-20	NR	MDB6032852.1	2026801	g19214	i0	50	0.909836065573771	74	37	91	0	3	224	66	139	MDB6032852.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	222	92.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31652586	31652586	PRJNA1198392_P_NODE_16677_length_249_cov_3.284091_g16536_i0	PRJNA1198392	16677	249	3.284091	8.17738659	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	51.6	2.72e-5	NR	HEU4679860.1	2832348	g16536	i0	46	1.24096385542169	50	27	60.2	0	160	11	182	231	HEU4679860.1 hypothetical protein [Terrimicrobiaceae bacterium]	diamond	309	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
31874146	31874146	PRJNA1198392_P_NODE_8597_length_289_cov_1.115741_g8456_i0	PRJNA1198392	8597	289	1.115741	3.22449149	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	45.8	0.00521	NR	HSU69413.1	2876886	g8456	i0	34.7	2.67820069204152	75	47	77.9	1	11	235	50	122	HSU69413.1 FtsX-like permease family protein [Tepidisphaeraceae bacterium]	diamond	774	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32000751	32000751	PRJNA1198392_P_NODE_16578_length_250_cov_0.870056_g16437_i0	PRJNA1198392	16578	250	0.870056	2.17514	Opitutaceae bacterium	2006848	Bacteria	Bacteria	106	3.4999999999999997e-25	NR	MFA5056512.1	2006848	g16437	i0	56.6	0.996	83	36	99.6	0	2	250	207	289	MFA5056512.1 major capsid protein [Opitutaceae bacterium]	diamond	249	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;