metadata: contig_metadata: 27 rows where bioproject = "PRJEB50332" and tax

27 rows where bioproject = "PRJEB50332" and tax_clade = "PVC group"

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
119446	119446	PRJEB50332_P_NODE_16541_length_204_cov_0.909091_g16459_i0	PRJEB50332	16541	204	0.909091	1.85454564	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	217	5.959999999999999e-52	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g16459	i0	88.525	9.12745098039216	183	16	88	5	4	183	473	293	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	1862	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
7368787	7368787	PRJEB50332_P_NODE_14886_length_207_cov_0.890411_g14804_i0	PRJEB50332	14886	207	0.890411	1.84315077	Akkermansia	239934	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|2240218473\|gb\|CP097283.1\|	239935	g14804	i0	100	99.7149758454106	207	0	100	0	1	207	874343	874137	Akkermansia muciniphila strain NB2A-8-WC chromosome	blastn	20641	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
7771877	7771877	PRJEB50332_P_NODE_4347_length_287_cov_1.548673_g4265_i0	PRJEB50332	4347	287	1.548673	4.44469151	Humisphaera borealis	2807512	Bacteria	Bacteria	427	3.7699999999999997e-115	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g4265	i0	94.585	480.81881533101	277	13	97	1	1	277	5063276	5063550	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	137995	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
9046693	9046693	PRJEB50332_P_NODE_3208_length_324_cov_1.114068_g3126_i0	PRJEB50332	3208	324	1.114068	3.60958032	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	364	3.439999999999999e-96	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g3126	i0	87.195	44.7746913580247	328	32	100	8	1	324	1600613	1600292	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	14507	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
9046731	9046731	PRJEB50332_P_NODE_6648_length_244_cov_1.808743_g6566_i0	PRJEB50332	6648	244	1.808743	4.41333292	Urbifossiella limnaea	2528023	Bacteria	Bacteria	318	1.9699999999999998e-82	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6566	i0	93.088	3.86065573770492	217	15	89	0	6	222	5053910	5054126	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	942	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
14147821	14147821	PRJEB50332_P_NODE_6152_length_251_cov_2.421053_g6070_i0	PRJEB50332	6152	251	2.421053	6.07684303	Pseudomonadati	3379134	Bacteria	Bacteria	142	5.24e-38	NR	MEM6474261.1	2026780	g6070	i0	84.3	84.2868525896414	83	13	99.2	0	3	251	158	240	MEM6474261.1 F0F1 ATP synthase subunit beta [Planctomycetota bacterium]	diamond	21156	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
17971098	17971098	PRJEB50332_P_NODE_9835_length_225_cov_1.585366_g9753_i0	PRJEB50332	9835	225	1.585366	3.5670735	Lacipirellula parvula	2650471	Bacteria	Bacteria	302	1.8e-77	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g9753	i0	91.031	0.991111111111111	223	20	99	0	1	223	3022423	3022201	Lacipirellula parvula PX69 DNA, complete genome	blastn	223	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
18842829	18842829	PRJEB50332_P_NODE_14095_length_208_cov_1.421769_g14013_i0	PRJEB50332	14095	208	1.421769	2.95727952	Gemmatales bacterium	2838789	Bacteria	Bacteria	138	6.41e-36	NR	HMP57769.1	2838789	g14013	i0	97.1	0.995192307692308	69	2	99.5	0	1	207	448	516	HMP57769.1 DEAD/DEAH box helicase family protein [Gemmatales bacterium]	diamond	207	138	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
20520258	20520258	PRJEB50332_P_NODE_10777_length_220_cov_1.547170_g10695_i0	PRJEB50332	10777	220	1.54717	3.403774	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	366	6.13e-97	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g10695	i0	96.804	34.7909090909091	219	7	99	0	1	219	736117	735899	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	7654	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
27286379	27286379	PRJEB50332_P_NODE_8983_length_230_cov_1.538462_g8901_i0	PRJEB50332	8983	230	1.538462	3.5384626	Chlamydia trachomatis	813	Bacteria	Bacteria	150	3.06e-40	NR	CRH62499.1	813	g8901	i0	100	0.991304347826087	76	0	99.1	0	3	230	72	147	CRH62499.1 PTS system nitrogen regulatory protein IIA [Chlamydia trachomatis]	diamond	228	150	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27760427	27760427	PRJEB50332_P_NODE_12224_length_212_cov_1.708609_g12142_i0	PRJEB50332	12224	212	1.708609	3.62225108	Planctomicrobium piriforme	1576369	Bacteria	Bacteria	141	2.3899999999999997e-37	NR	WP_092054853.1	1576369	g12142	i0	94.3	1.9811320754717	70	4	99.1	0	1	210	350	419	WP_092054853.1 M3 family oligoendopeptidase [Planctomicrobium piriforme]	diamond	420	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomicrobium	Planctomicrobium piriforme
28448211	28448211	PRJEB50332_P_NODE_17106_length_203_cov_0.915493_g17024_i0	PRJEB50332	17106	203	0.915493	1.85845079	Bacteria	2	Bacteria	Bacteria	91.7	1.29e-19	NR	WP_157732010.1	1331910	g17024	i0	65.7	18.679802955665	67	23	99	0	203	3	500	566	WP_157732010.1 apolipoprotein N-acyltransferase [Thermogutta terrifontis]	diamond	3792	92.4	0.992424242424242	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae	Thermogutta	Thermogutta terrifontis
29086378	29086378	PRJEB50332_P_NODE_9548_length_227_cov_1.307229_g9466_i0	PRJEB50332	9548	227	1.307229	2.96740983	Terrimicrobium sp.	1965319	Bacteria	Bacteria	155	1.6e-43	NR	HEY6675541.1	1965319	g9466	i0	92	0.991189427312775	75	6	99.1	0	1	225	250	324	HEY6675541.1 hypothetical protein [Terrimicrobium sp.]	diamond	225	155	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
29244142	29244142	PRJEB50332_P_NODE_15869_length_205_cov_1.354167_g15787_i0	PRJEB50332	15869	205	1.354167	2.77604235	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	80.1	1.48e-15	NR	HYG84357.1	2499141	g15787	i0	64.1	0.936585365853659	64	21	93.7	1	3	194	199	260	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	192	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29275513	29275513	PRJEB50332_P_NODE_1169_length_503_cov_2.416290_g1088_i0	PRJEB50332	1169	503	2.41629	12.1539387	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	58.5	6.62e-7	NR	HEX3818319.1	2201154	g1088	i0	37.3	0.656063618290258	110	59	63.8	5	497	177	120	222	HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	330	58.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29521513	29521513	PRJEB50332_P_NODE_8610_length_232_cov_1.976608_g8528_i0	PRJEB50332	8610	232	1.976608	4.58573056	Prosthecobacter	48463	Bacteria	Bacteria	135	7.98e-36	NR	MDZ4289601.1	1965333	g8528	i0	84	4.84913793103448	75	12	97	0	227	3	40	114	MDZ4289601.1 cytochrome c peroxidase [Prosthecobacter sp.]	diamond	1125	136	0.992647058823529	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
29622513	29622513	PRJEB50332_P_NODE_130_length_1330_cov_3.803783_g98_i0	PRJEB50332	130	1330	3.803783	50.5903139	PVC group bacterium	2056642	Bacteria	Bacteria	58.5	1.01e-6	NR	MCP4648866.1	2056642	g98	i0	40	0.225563909774436	100	60	22.6	0	860	1159	1	100	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	300	58.5	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
30343291	30343291	PRJEB50332_P_NODE_15932_length_205_cov_0.902778_g15850_i0	PRJEB50332	15932	205	0.902778	1.8506949	PVC group	1783257	Bacteria	Bacteria	45.1	0.00352	NR	MCM8823431.1	2035772	g15850	i0	37.5	4.88780487804878	48	30	70.2	0	196	53	506	553	MCM8823431.1 tetratricopeptide repeat protein [Candidatus Omnitrophota bacterium]	diamond	1002	45.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
30918378	30918378	PRJEB50332_P_NODE_11314_length_217_cov_1.666667_g11232_i0	PRJEB50332	11314	217	1.666667	3.61666739	Horticoccus sp. 23ND18S-11	3391832	Bacteria	Bacteria	143	1.64e-38	NR	WP_414662761.1	3391832	g11232	i0	86.1	2.98617511520737	72	10	99.5	0	217	2	233	304	WP_414662761.1 NAD(P)/FAD-dependent oxidoreductase [Horticoccus sp. 23ND18S-11]	diamond	648	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus sp. 23ND18S-11
30981600	30981600	PRJEB50332_P_NODE_18414_length_192_cov_2.465649_g18332_i0	PRJEB50332	18414	192	2.465649	4.73404608	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	64.7	7.99e-12	NR	HJT45844.1	2201154	g18332	i0	52.5	6.703125	59	27	92.2	1	177	1	22	79	HJT45844.1 ATP-grasp domain-containing protein [Chthoniobacterales bacterium]	diamond	1287	64.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31038178	31038178	PRJEB50332_P_NODE_2075_length_389_cov_12.222561_g1994_i0	PRJEB50332	2075	389	12.222561	47.54576229	Planctomycetota	203682	Bacteria	Bacteria	97.4	1.11e-20	NR	NUM34221.1	2517210	g1994	i0	49.1	2.62210796915167	112	47	81.7	5	5	322	396	503	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	1020	97.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
31044951	31044951	PRJEB50332_P_NODE_8995_length_230_cov_1.532544_g8913_i0	PRJEB50332	8995	230	1.532544	3.5248512	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	127	7.07e-32	NR	HYO10799.1	2876886	g8913	i0	81.6	0.991304347826087	76	14	99.1	0	3	230	355	430	HYO10799.1 DNA gyrase subunit A [Tepidisphaeraceae bacterium]	diamond	228	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31448953	31448953	PRJEB50332_P_NODE_2476_length_361_cov_1.300000_g2394_i0	PRJEB50332	2476	361	1.3	4.693	Pseudomonadati	3379134	Bacteria	Bacteria	148	2.21e-41	NR	MDX1565183.1	2026777	g2394	i0	61.1	17.9168975069252	113	44	93.9	0	350	12	9	121	MDX1565183.1 aldolase/citrate lyase family protein [Phycisphaeraceae bacterium]	diamond	6468	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31487448	31487448	PRJEB50332_P_NODE_13496_length_209_cov_1.756757_g13414_i0	PRJEB50332	13496	209	1.756757	3.67162213	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	69.7	2.61e-13	NR	MBN1941883.1	2026778	g13414	i0	47.8	1.92344497607656	67	35	96.2	0	9	209	14	80	MBN1941883.1 STAS/SEC14 domain-containing protein [Phycisphaerae bacterium]	diamond	402	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32088266	32088266	PRJEB50332_P_NODE_16538_length_204_cov_0.909091_g16456_i0	PRJEB50332	16538	204	0.909091	1.85454564	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	126	2.62e-36	NR	MFN4174350.1	2052176	g16456	i0	98.5	0.985294117647059	67	1	98.5	0	202	2	6	72	MFN4174350.1 adenylyltransferase/cytidyltransferase family protein [Parachlamydiaceae bacterium]	diamond	201	126	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32278331	32278331	PRJEB50332_P_NODE_3419_length_315_cov_1.228346_g3337_i0	PRJEB50332	3419	315	1.228346	3.8692899	Gemmataceae bacterium	2052164	Bacteria	Bacteria	74.7	8.3e-15	NR	MCI0458813.1	2052164	g3337	i0	49.3	3.1047619047619	67	34	63.8	0	4	204	29	95	MCI0458813.1 hypothetical protein [Gemmataceae bacterium]	diamond	978	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32563147	32563147	PRJEB50332_P_NODE_12559_length_211_cov_0.866667_g12477_i0	PRJEB50332	12559	211	0.866667	1.82866737	Planctomycetia bacterium	2052181	Bacteria	Bacteria	60.5	5.25e-9	NR	MCI0700422.1	2052181	g12477	i0	70.5	0.625592417061611	44	13	62.6	0	132	1	98	141	MCI0700422.1 SHOCT domain-containing protein [Planctomycetia bacterium]	diamond	132	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;