metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA857143" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA857143" 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
5947335	5947335	PRJNA857143_S_NODE_44245_length_411_cov_4.355030_g43152_i0	PRJNA857143	44245	411	4.35503	17.8991733	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	448	4.309999999999999e-121	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g43152	i0	87.595	86.5961070559611	395	37	95	10	23	411	1866195	1866583	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	35591	448	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7221419	7221419	PRJNA857143_S_NODE_145226_length_270_cov_1.979695_g144133_i0	PRJNA857143	145226	270	1.979695	5.3451765	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	327	3.67e-85	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g144133	i0	90.947	20.9703703703704	243	22	90	0	23	265	173361	173603	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	5662	327	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
8888251	8888251	PRJNA857143_S_NODE_11807_length_639_cov_1.833922_g10790_i0	PRJNA857143	11807	639	1.833922	11.71876158	Schlesneria	656899	Bacteria	Bacteria	857	0	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g10790	i0	92.157	503.9593114241	612	41	96	5	28	639	1	605	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	322030	861	0.995354239256678	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
9771912	9771912	PRJNA857143_S_NODE_21048_length_522_cov_2.485523_g19966_i0	PRJNA857143	21048	522	2.485523	12.97443006	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	695	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g19966	i0	91.984	150.463601532567	499	34	95	6	27	522	2058829	2059324	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	78542	695	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
9772666	9772666	PRJNA857143_S_NODE_97748_length_316_cov_0.962963_g96655_i0	PRJNA857143	97748	316	0.962963	3.04296308	Schlesneria sp. DSM 10557	3044399	Bacteria	Bacteria	507	5.25e-139	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g96655	i0	95.57	79.1550632911392	316	14	100	0	1	316	4527640	4527955	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	25013	507	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
11047369	11047369	PRJNA857143_S_NODE_189149_length_244_cov_1.508772_g188056_i0	PRJNA857143	189149	244	1.508772	3.68140368	Saltatorellus ferox	2528018	Bacteria	Bacteria	202	2.07e-47	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g188056	i0	85.864	180.446721311475	191	25	78	2	31	220	2930692	2930503	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	44029	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
13597042	13597042	PRJNA857143_S_NODE_147191_length_269_cov_1.193878_g146098_i0	PRJNA857143	147191	269	1.193878	3.21153182	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	302	2.22e-77	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g146098	i0	87.085	5.50557620817844	271	29	99	6	2	269	1867798	1867531	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1481	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
14870848	14870848	PRJNA857143_S_NODE_106632_length_306_cov_1.090129_g105539_i0	PRJNA857143	106632	306	1.090129	3.33579474	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	333	9.1e-87	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g105539	i0	86.731	85.8104575163399	309	30	99	10	3	306	1867415	1867717	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	26258	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16146881	16146881	PRJNA857143_S_NODE_54593_length_385_cov_1.823718_g53500_i0	PRJNA857143	54593	385	1.823718	7.0213143	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	231	4.399999999999999e-56	NTclustered	gi\|1702190059\|gb\|CP030884.1\|	2026779	g53500	i0	78.771	215.280519480519	358	66	91	9	22	372	437318	436964	Planctomycetaceae bacterium isolate ECT2AJA-110-A chromosome	blastn	82883	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
17422657	17422657	PRJNA857143_S_NODE_88234_length_327_cov_3.271654_g87141_i0	PRJNA857143	88234	327	3.271654	10.69830858	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	130	1.38e-25	NTclustered	gi\|559134048\|tpe\|HG788966.1\|	264201	g87141	i0	76.984	3.0519877675841	252	43	74	14	1	243	389	144	TPA: Candidatus Protochlamydia amoebophila UWE25 transfer-messenger mRNA Proto_amoeb_UWE25, single chain mature transcript	blastn	998	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
17812826	17812826	PRJNA857143_S_NODE_92454_length_322_cov_1.734940_g91361_i0	PRJNA857143	92454	322	1.73494	5.5865068	Schlesneria	656899	Bacteria	Bacteria	545	1.14e-150	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g91361	i0	97.214	145.754658385093	323	8	100	1	1	322	593	915	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	46933	545	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
18694594	18694594	PRJNA857143_S_NODE_143035_length_272_cov_1.567839_g141942_i0	PRJNA857143	143035	272	1.567839	4.26452208	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621786302\|emb\|OY782760.1\|	2026780	g141942	i0	100	0.110294117647059	30	0	11	0	83	112	760504	760533	MAG: Planctomycetota bacterium isolate 4c5731f0-34ce-4739-be05-23ee86c4296e genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
18694769	18694769	PRJNA857143_S_NODE_15995_length_573_cov_3.306000_g14935_i0	PRJNA857143	15995	573	3.306	18.94338	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	760	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g14935	i0	90.592	115.401396160558	574	52	100	2	1	573	1727355	1727927	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	66125	760	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19086865	19086865	PRJNA857143_S_NODE_67955_length_358_cov_2.189474_g66862_i0	PRJNA857143	67955	358	2.189474	7.83831692	Opitutus	178440	Bacteria	Bacteria	590	5.8099999999999986e-164	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g66862	i0	96.389	98.108938547486	360	9	100	4	1	358	1028	671	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	35123	595	0.991596638655462	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
20361686	20361686	PRJNA857143_S_NODE_73416_length_349_cov_1.405797_g72323_i0	PRJNA857143	73416	349	1.405797	4.90623153	Candidatus Protochlamydia	282132	Bacteria	Bacteria	551	2.669999999999999e-152	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g72323	i0	95.143	169.676217765043	350	15	100	2	1	349	1249939	1249591	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	59217	556	0.991007194244604	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
21245081	21245081	PRJNA857143_S_NODE_12237_length_630_cov_3.184919_g11214_i0	PRJNA857143	12237	630	3.184919	20.0649897	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	619	1.37e-172	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g11214	i0	84.977	136.698412698413	639	64	100	18	1	630	1867769	1867154	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	86120	619	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21245977	21245977	PRJNA857143_S_NODE_2097_length_1157_cov_4.687269_g249_i1	PRJNA857143	2097	1157	4.687269	54.23170233	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1482	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g249	i1	90.297	253.509075194468	1144	93	98	17	25	1157	1314920	1316056	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	293310	1482	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21246090	21246090	PRJNA857143_S_NODE_337_length_1898_cov_3.467945_g249_i0	PRJNA857143	337	1898	3.467945	65.8215961	Pedosphaera parvula	1032527	Bacteria	Bacteria	2248	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g249	i0	88.49	259.27133825079	1894	173	99	43	29	1898	1	1873	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	492097	2248	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
22520153	22520153	PRJNA857143_S_NODE_16278_length_570_cov_1.615694_g15217_i0	PRJNA857143	16278	570	1.615694	9.2094558	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	793	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g15217	i0	91.769	139.964912280702	571	46	100	1	1	570	1867127	1866557	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	79780	793	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22520944	22520944	PRJNA857143_S_NODE_59078_length_375_cov_2.649007_g57985_i0	PRJNA857143	59078	375	2.649007	9.93377625	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	497	3.81e-136	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g57985	i0	90.885	305.109333333333	373	30	99	4	1	373	1866897	1866529	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	114416	497	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23795084	23795084	PRJNA857143_S_NODE_110299_length_302_cov_1.362445_g109206_i0	PRJNA857143	110299	302	1.362445	4.1145839	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	411	4.0299999999999996e-110	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g109206	i0	93.214	106.08940397351	280	18	93	1	23	302	1314920	1315198	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	32039	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23795574	23795574	PRJNA857143_S_NODE_157999_length_260_cov_3.016043_g156906_i0	PRJNA857143	157999	260	3.016043	7.8417118	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	392	1.2299999999999999e-104	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g156906	i0	95.181	148.434615384615	249	11	95	1	13	260	1866810	1866562	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	38593	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25070194	25070194	PRJNA857143_S_NODE_45540_length_408_cov_1.417910_g44447_i0	PRJNA857143	45540	408	1.41791	5.7850728	Fontisphaera persica	2974023	Bacteria	Bacteria	412	1.5599999999999998e-110	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g44447	i0	85.024	60.5882352941176	414	52	100	7	1	408	3862473	3862882	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	24720	412	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica

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);;