metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA737474" 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
25581150	25581150	PRJNA737474f_S_NODE_6961_length_787_cov_2.929972_g6399_i0	PRJNA737474	6961	787	2.929972	23.05887964	Pedosphaera parvula Ellin514	320771	Bacteria	Bacteria	758	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g6399	i0	84.774	69.9390088945362	775	97	97	21	24	787	1807	1043	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	55042	758	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
25584190	25584190	PRJNA737474g_S_NODE_193433_length_280_cov_1.057971_g192139_i0	PRJNA737474	193433	280	1.057971	2.9623188	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	86.1	2.54e-12	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g192139	i0	78.417	8.62142857142857	139	24	49	6	120	255	5751468	5751603	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	2414	86.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
25586652	25586652	PRJNA737474g_S_NODE_326265_length_250_cov_0.949153_g324971_i0	PRJNA737474	326265	250	0.949153	2.3728825	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	195	3.55e-45	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g324971	i0	91.489	4.332	141	12	56	0	108	248	3216162	3216302	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1083	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25720002	25720002	PRJNA737474g_S_NODE_17682_length_740_cov_1.764618_g16512_i0	PRJNA737474	17682	740	1.764618	13.0581732	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	534	6.04e-147	NTclustered	gi\|1966850802\|gb\|CP068472.1\|	1903058	g16512	i0	92.513	0.827027027027027	374	26	50	2	329	701	244070	244442	MAG: Candidatus Xiphinematobacter sp. isolate P3-11 chromosome, complete genome	blastn	612	534	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
25849532	25849532	PRJNA737474f_S_NODE_146139_length_268_cov_1.635897_g145461_i0	PRJNA737474	146139	268	1.635897	4.38420396	Lacipirellula parvula	2650471	Bacteria	Bacteria	259	1.35e-64	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g145461	i0	85.95	87.5298507462687	242	34	90	0	8	249	6427967	6428208	Lacipirellula parvula PX69 DNA, complete genome	blastn	23458	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
25987421	25987421	PRJNA737474f_S_NODE_26252_length_413_cov_1.852941_g25575_i0	PRJNA737474	26252	413	1.852941	7.65264633	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	239	2.84e-58	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g25575	i0	80.635	2.76513317191283	315	56	76	5	97	409	55578	55267	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1142	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25993463	25993463	PRJNA737474g_S_NODE_243660_length_265_cov_2.531250_g242366_i0	PRJNA737474	243660	265	2.53125	6.7078125	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	65.8	3.11e-6	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g242366	i0	88.679	0.80377358490566	53	6	20	0	213	265	3127755	3127703	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	213	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25995561	25995561	PRJNA737474g_S_NODE_38404_length_461_cov_1.896907_g37115_i0	PRJNA737474	38404	461	1.896907	8.74474127	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	322	3.09e-83	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g37115	i0	79.437	2.67678958785249	462	89	99	6	1	459	4560252	4559794	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1234	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25998188	25998188	PRJNA737474g_S_NODE_81428_length_347_cov_4.051095_g80134_i0	PRJNA737474	81428	347	4.051095	14.05729965	Actomonas aquatica	2866162	Bacteria	Bacteria	86.1	3.24e-12	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g80134	i0	97.959	13.9567723342939	49	1	14	0	20	68	2403704	2403656	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	4843	86.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
26037594	26037594	PRJNA737474f_S_NODE_222876_length_248_cov_0.880000_g222198_i0	PRJNA737474	222876	248	0.88	2.1824	Rosistilla	2795779	Bacteria	Bacteria	95.3	3.67e-15	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g222198	i0	86.364	1.75	88	10	35	2	147	233	359210	359296	Rosistilla ulvae strain EC9 chromosome	blastn	434	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
26118244	26118244	PRJNA737474d_S_NODE_38693_length_247_cov_1.051724_g38099_i0	PRJNA737474	38693	247	1.051724	2.59775828	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g38099	i0	96.875	0.129554655870445	32	1	13	0	54	85	1451984	1452015	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	32	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
26128611	26128611	PRJNA737474g_S_NODE_194813_length_279_cov_5.145631_g193519_i0	PRJNA737474	194813	279	5.145631	14.35631049	Planctomycetota bacterium	2026780	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2621705096\|emb\|OY763323.1\|	2026780	g193519	i0	94.444	0.129032258064516	36	1	13	1	51	86	720441	720407	MAG: Planctomycetota bacterium isolate 3a5a21b3-ef55-46fa-90a9-c954c41cad77 genome assembly, chromosome: 1	blastn	36	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26260563	26260563	PRJNA737474f_S_NODE_36470_length_372_cov_1.461538_g35792_i0	PRJNA737474	36470	372	1.461538	5.43692136	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	388	2.3699999999999997e-103	NTclustered	gi\|1966850802\|gb\|CP068472.1\|	1903058	g35792	i0	99.531	0.57258064516129	213	1	57	0	160	372	244442	244230	MAG: Candidatus Xiphinematobacter sp. isolate P3-11 chromosome, complete genome	blastn	213	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
26388179	26388179	PRJNA737474c_S_NODE_29103_length_241_cov_0.994048_g28272_i0	PRJNA737474	29103	241	0.994048	2.39565568	Botrimarina mediterranea	2528022	Bacteria	Bacteria	76.8	1.29e-9	NTclustered	gi\|1712762859\|gb\|CP036349.1\|	2528022	g28272	i0	100	22.195020746888	41	0	17	0	1	41	962777	962817	Botrimarina mediterranea strain Spa11 chromosome	blastn	5349	76.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Botrimarina	Botrimarina mediterranea
26389555	26389555	PRJNA737474d_S_NODE_24471_length_307_cov_4.799145_g23877_i0	PRJNA737474	24471	307	4.799145	14.73337515	Candidatus Uabimicrobium helgolandensis	3095367	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2793194503\|gb\|CP165719.1\|	3095367	g23877	i0	100	0.0912052117263844	28	0	9	0	67	94	2649601	2649574	Candidatus Uabimicrobium helgolandensis strain HlEnr_7 chromosome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium helgolandensis
26533253	26533253	PRJNA737474f_S_NODE_56632_length_330_cov_3.070039_g55954_i0	PRJNA737474	56632	330	3.070039	10.1311287	Paludisphaera borealis	1387353	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g55954	i0	100	0.0848484848484849	28	0	8	0	98	125	6497448	6497421	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
26541764	26541764	PRJNA737474g_S_NODE_62616_length_378_cov_2.940984_g61322_i0	PRJNA737474	62616	378	2.940984	11.11691952	Caulifigura coniformis	2527983	Bacteria	Bacteria	76.8	2.14e-9	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g61322	i0	97.727	11.484126984127	44	1	12	0	229	272	483385	483428	Caulifigura coniformis strain Pan44 chromosome	blastn	4341	76.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis

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