metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA533623" 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
505885	505885	PRJNA533623_P_NODE_10681_length_718_cov_3.377473_g9104_i0	PRJNA533623	10681	718	3.377473	24.25025614	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	785	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g9104	i0	90.516	171.373259052925	601	48	97	5	100	696	2581693	2582288	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	123046	785	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
506611	506611	PRJNA533623_P_NODE_40821_length_340_cov_2.329749_g39047_i0	PRJNA533623	40821	340	2.329749	7.9211466	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	270	8.149999999999999e-68	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g39047	i0	82.581	0.911764705882353	310	50	91	3	17	324	3884952	3885259	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	310	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
1781420	1781420	PRJNA533623_P_NODE_22442_length_489_cov_28.196262_g20688_i0	PRJNA533623	22442	489	28.196262	137.87972118	Urbifossiella limnaea	2528023	Bacteria	Bacteria	366	1.4999999999999999e-96	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g20688	i0	85.475	5.99795501022495	358	44	72	8	106	459	5672997	5672644	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	2933	366	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1781770	1781770	PRJNA533623_P_NODE_36402_length_366_cov_20.911475_g34630_i0	PRJNA533623	36402	366	20.911475	76.5359985	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	134	1.21e-26	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g34630	i0	88.393	0.62568306010929	112	11	30	2	23	133	8816472	8816582	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	229	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
6883495	6883495	PRJNA533623_P_NODE_13346_length_644_cov_102.523156_g11678_i0	PRJNA533623	13346	644	102.523156	660.24912464	Urbifossiella limnaea	2528023	Bacteria	Bacteria	178	1.01e-39	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g11678	i0	88.889	20.5046583850932	144	16	25	0	456	599	2682368	2682225	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	13205	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
7495778	7495778	PRJNA533623_P_NODE_11846_length_683_cov_79.545016_g10225_i0	PRJNA533623	11846	683	79.545016	543.29245928	Parachlamydia	83551	Bacteria	Bacteria	726	0	NTclustered	gi\|1491674\|emb\|Y07555.1\|	83552	g10225	i0	87.023	137.93850658858	655	71	95	14	14	663	978	1623	Parachlamydia acanthamoebae genomic LSU rRNA	blastn	94212	726	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
8158796	8158796	PRJNA533623_P_NODE_17207_length_566_cov_9.394059_g15481_i0	PRJNA533623	17207	566	9.394059	53.17037394	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	267	1.83e-66	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g15481	i0	82.724	2.0547703180212	301	50	53	2	9	308	2899978	2900277	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1163	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
8159380	8159380	PRJNA533623_P_NODE_43167_length_327_cov_7.609023_g41393_i0	PRJNA533623	43167	327	7.609023	24.88150521	Candidatus Methylacidiphilum infernorum	511746	Bacteria	Bacteria	193	1.74e-44	NTclustered	gi\|189184875\|gb\|CP000975.1\|	481448	g41393	i0	85.185	4.02446483180428	189	26	58	2	27	214	1875858	1875671	Methylacidiphilum infernorum V4, complete genome	blastn	1316	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum infernorum
8159500	8159500	PRJNA533623_P_NODE_48447_length_301_cov_4.795833_g46668_i0	PRJNA533623	48447	301	4.795833	14.43545733	Gimesia panareensis	2527978	Bacteria	Bacteria	183	9.519999999999997e-42	NTclustered	gi\|1712480035\|gb\|CP037421.1\|	2527978	g46668	i0	83.59	6.82724252491694	195	32	65	0	53	247	5103047	5103241	Gimesia panareensis strain Enr10 chromosome	blastn	2055	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia panareensis
10710039	10710039	PRJNA533623_P_NODE_18409_length_546_cov_37.758763_g16672_i0	PRJNA533623	18409	546	37.758763	206.16284598	Gemmataceae bacterium	2052164	Bacteria	Bacteria	257	1.06e-63	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g16672	i0	82.935	12.0201465201465	293	42	53	7	253	541	7115189	7114901	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	6563	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
10710508	10710508	PRJNA533623_P_NODE_37869_length_358_cov_1.841751_g36097_i0	PRJNA533623	37869	358	1.841751	6.59346858	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	159	1.9399999999999993e-34	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g36097	i0	81.633	2.34916201117318	196	32	54	3	34	226	3693083	3692889	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	841	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
11985114	11985114	PRJNA533623_P_NODE_34330_length_380_cov_4.169279_g32559_i0	PRJNA533623	34330	380	4.169279	15.8432602	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	239	2.59e-58	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g32559	i0	84.583	1.37105263157895	240	37	63	0	50	289	7619125	7619364	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	521	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11985931	11985931	PRJNA533623_P_NODE_72650_length_212_cov_1.291391_g70869_i0	PRJNA533623	72650	212	1.291391	2.73774892	Lignipirellula cremea	2528010	Bacteria	Bacteria	298	2.17e-76	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g70869	i0	94.33	114.853773584906	194	11	92	0	1	194	1143789	1143982	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	24349	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
14534669	14534669	PRJNA533623_P_NODE_13732_length_636_cov_13.787826_g12055_i0	PRJNA533623	13732	636	13.787826	87.69057336	Thermogutta terrifontis	1331910	Bacteria	Bacteria	486	1.4599999999999997e-132	NTclustered	gi\|1238331385\|gb\|CP018477.1\|	1331910	g12055	i0	85.294	29.9056603773585	476	65	75	5	9	482	3673855	3673383	Thermogutta terrifontis strain R1 chromosome, complete genome	blastn	19020	486	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae	Thermogutta	Thermogutta terrifontis
14535790	14535790	PRJNA533623_P_NODE_6152_length_927_cov_23.692841_g4850_i0	PRJNA533623	6152	927	23.692841	219.63263607	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	455	6.11e-123	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g4850	i0	84.615	35.9762675296656	468	61	50	11	96	558	1689968	1690429	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	33350	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15810120	15810120	PRJNA533623_P_NODE_8753_length_791_cov_1.372603_g7266_i0	PRJNA533623	8753	791	1.372603	10.85728973	Candidatus Methylacidiphilum infernorum	511746	Bacteria	Bacteria	508	3.92e-139	NTclustered	gi\|189184875\|gb\|CP000975.1\|	481448	g7266	i0	83.045	28.8672566371681	578	80	73	11	220	791	1877017	1876452	Methylacidiphilum infernorum V4, complete genome	blastn	22834	508	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum infernorum
17083598	17083598	PRJNA533623_P_NODE_27014_length_441_cov_8.763158_g25245_i0	PRJNA533623	27014	441	8.763158	38.64552678	Pirellulimonas nuda	2528009	Bacteria	Bacteria	143	2.4599999999999996e-29	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g25245	i0	89.381	47.3764172335601	113	12	26	0	25	137	1067788	1067900	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	20893	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
18358127	18358127	PRJNA533623_P_NODE_45815_length_314_cov_2.320158_g44039_i0	PRJNA533623	45815	314	2.320158	7.28529612	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	265	3.47e-66	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g44039	i0	85.115	19.7547770700637	262	35	83	4	27	286	1013348	1013089	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	6203	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
19632868	19632868	PRJNA533623_P_NODE_52276_length_284_cov_3.672646_g50497_i0	PRJNA533623	52276	284	3.672646	10.43031464	Phycisphaera sp.	2030824	Bacteria	Bacteria	185	2.4799999999999993e-42	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g50497	i0	82.547	14.1725352112676	212	35	74	2	59	268	730543	730332	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	4025	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
20244412	20244412	PRJNA533623_P_NODE_45376_length_316_cov_4.309804_g43600_i0	PRJNA533623	45376	316	4.309804	13.61898064	Planctomycetaceae	126	Bacteria	Bacteria	130	1.33e-25	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g43600	i0	91.489	2.46518987341772	94	8	30	0	1	94	2924697	2924790	Caulifigura coniformis strain Pan44 chromosome	blastn	779	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
24732494	24732494	PRJNA533623_P_NODE_43400_length_326_cov_3.362264_g41626_i0	PRJNA533623	43400	326	3.362264	10.96098064	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	309	1.6500000000000002e-79	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g41626	i0	90	4.85276073619632	240	22	73	2	67	305	2597627	2597389	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	1582	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;