metadata: contig_metadata: 22 rows where bioproject = "PRJNA495391" and tax

22 rows where bioproject = "PRJNA495391" 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
4303789	4303789	PRJNA495391_S_NODE_57024_length_165_cov_1.223077_g55972_i0	PRJNA495391	57024	165	1.223077	2.01807705	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	132	1.72e-26	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g55972	i0	83.553	282.854545454545	152	13	88	9	5	149	3097293	3097439	Pirellula sp. SH-Sr6A, complete genome	blastn	46671	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
4935622	4935622	PRJNA495391_S_NODE_44764_length_184_cov_1.583893_g43712_i0	PRJNA495391	44764	184	1.583893	2.91436312	Bremerella	2714594	Bacteria	Bacteria	76.8	9.31e-10	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g43712	i0	91.071	2.2445652173913	56	5	30	0	129	184	2673360	2673415	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	413	76.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
6210562	6210562	PRJNA495391_S_NODE_23485_length_248_cov_2.140845_g22433_i0	PRJNA495391	23485	248	2.140845	5.3092956	Bacteria	2	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g22433	i0	91.77	353.866935483871	243	18	98	2	1	242	27243	27484	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	87759	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
8130184	8130184	PRJNA495391_S_NODE_65107_length_156_cov_1.165289_g64055_i0	PRJNA495391	65107	156	1.165289	1.81785084	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	267	4.2199999999999997e-67	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g64055	i0	97.436	275.673076923077	156	4	100	0	1	156	2748517	2748362	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	43005	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8130341	8130341	PRJNA495391_S_NODE_7427_length_447_cov_1.376214_g6376_i0	PRJNA495391	7427	447	1.376214	6.15167658	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	486	9.999999999999997e-133	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g6376	i0	86.444	364.022371364653	450	54	100	7	1	447	2583847	2583402	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	162718	486	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11955462	11955462	PRJNA495391_S_NODE_50550_length_174_cov_1.474820_g49498_i0	PRJNA495391	50550	174	1.47482	2.5661868	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	263	6.21e-66	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g49498	i0	94.253	88.4770114942529	174	6	99	4	3	174	27830	27659	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	15395	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
14504546	14504546	PRJNA495391_S_NODE_15932_length_300_cov_2.158491_g14880_i0	PRJNA495391	15932	300	2.158491	6.475473	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	331	3.2e-86	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g14880	i0	87.031	77.6366666666667	293	38	98	0	6	298	3454980	3455272	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	23291	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
22153183	22153183	PRJNA495391_S_NODE_45698_length_182_cov_2.000000_g44646_i0	PRJNA495391	45698	182	2	3.64	Lacipirellula parvula	2650471	Bacteria	Bacteria	220	4.01e-53	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g44646	i0	89.385	169.467032967033	179	13	96	5	8	182	5162981	5163157	Lacipirellula parvula PX69 DNA, complete genome	blastn	30843	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
27076970	27076970	PRJNA495391_S_NODE_23042_length_250_cov_2.674419_g21990_i0	PRJNA495391	23042	250	2.674419	6.6860475	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	1.23e-5	NR	MEE2939368.1	2026780	g21990	i0	55.8	2.748	43	17	49.2	1	101	223	686	728	MEE2939368.1 DUF6797 domain-containing protein [Planctomycetota bacterium]	diamond	687	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28056009	28056009	PRJNA495391_S_NODE_51525_length_172_cov_2.445255_g50473_i0	PRJNA495391	51525	172	2.445255	4.2058386	Planctomycetota bacterium	2026780	Bacteria	Bacteria	66.6	2.44e-11	NR	MEY3173574.1	2026780	g50473	i0	70	0.697674418604651	40	12	69.8	0	2	121	91	130	MEY3173574.1 hypothetical protein [Planctomycetota bacterium]	diamond	120	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28624649	28624649	PRJNA495391_S_NODE_42107_length_189_cov_1.928571_g41055_i0	PRJNA495391	42107	189	1.928571	3.64499919	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0342	NR	MAG55102.1	2026780	g41055	i0	44.4	0.857142857142857	54	27	81	2	31	183	212	265	MAG55102.1 ABC transporter [Planctomycetota bacterium]	diamond	162	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29192922	29192922	PRJNA495391_S_NODE_33969_length_209_cov_1.712644_g32917_i0	PRJNA495391	33969	209	1.712644	3.57942596	Planctomycetales bacterium	2053591	Bacteria	Bacteria	88.6	1.58e-20	NR	MCA9178134.1	2053591	g32917	i0	64.2	3.84688995215311	67	24	96.2	0	204	4	71	137	MCA9178134.1 aminoacyl-tRNA hydrolase [Planctomycetales bacterium]	diamond	804	88.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29413679	29413679	PRJNA495391_S_NODE_25389_length_239_cov_2.068627_g24337_i0	PRJNA495391	25389	239	2.068627	4.94401853	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0465	NR	HKD99663.1	2026780	g24337	i0	50.9	0.665271966527197	53	24	66.5	1	42	200	38	88	HKD99663.1 thiamine-phosphate kinase [Planctomycetota bacterium]	diamond	159	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29539974	29539974	PRJNA495391_S_NODE_6830_length_469_cov_3.214286_g5783_i0	PRJNA495391	6830	469	3.214286	15.07500134	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	79.3	1.58e-14	NR	MFA6358854.1	2035772	g5783	i0	45.5	0.70362473347548	110	55	69.7	2	469	143	134	239	MFA6358854.1 HNH endonuclease signature motif containing protein [Candidatus Omnitrophota bacterium]	diamond	330	79.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29855876	29855876	PRJNA495391_S_NODE_68671_length_152_cov_1.957265_g67619_i0	PRJNA495391	68671	152	1.957265	2.9750428	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.6	8.36e-12	NR	MCO5165503.1	2026780	g67619	i0	68.6	7.69736842105263	51	14	96.7	1	2	148	130	180	MCO5165503.1 von Willebrand factor type A domain-containing protein [Planctomycetota bacterium]	diamond	1170	68.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30803646	30803646	PRJNA495391_S_NODE_55934_length_166_cov_1.824427_g54882_i0	PRJNA495391	55934	166	1.824427	3.02854882	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	80.9	3.45e-18	NR	HIB64395.1	2052180	g54882	i0	67.3	3.92168674698795	55	16	95.8	1	6	164	11	65	HIB64395.1 hypothetical protein [Phycisphaerales bacterium]	diamond	651	80.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31657029	31657029	PRJNA495391_S_NODE_25037_length_241_cov_1.237864_g23985_i0	PRJNA495391	25037	241	1.237864	2.98325224	Pirellulales bacterium	2715253	Bacteria	Bacteria	42.4	0.0475	NR	HZZ72305.1	2715253	g23985	i0	41.3	0.572614107883817	46	27	57.3	0	241	104	99	144	HZZ72305.1 tetratricopeptide repeat protein [Pirellulales bacterium]	diamond	138	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32100107	32100107	PRJNA495391_S_NODE_39878_length_194_cov_1.754717_g38826_i0	PRJNA495391	39878	194	1.754717	3.40415098	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.1	0.0145	NR	MFO0918096.1	2026779	g38826	i0	51.1	0.695876288659794	45	18	64.9	2	43	168	532	575	MFO0918096.1 DUF1549 domain-containing protein [Planctomycetaceae bacterium]	diamond	135	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32290351	32290351	PRJNA495391_S_NODE_26759_length_233_cov_2.090909_g25707_i0	PRJNA495391	26759	233	2.090909	4.87181797	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.1	2.61e-9	NR	MEM0925828.1	2026780	g25707	i0	81.6	0.489270386266094	38	7	48.9	0	2	115	86	123	MEM0925828.1 hypothetical protein [Planctomycetota bacterium]	diamond	114	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32511786	32511786	PRJNA495391_S_NODE_8319_length_420_cov_2.324675_g7268_i0	PRJNA495391	8319	420	2.324675	9.763635	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	128	8.37e-33	NR	MDB5357711.1	2052180	g7268	i0	49	2.02142857142857	143	68	99.3	3	419	3	154	295	MDB5357711.1 hypothetical protein [Phycisphaerales bacterium]	diamond	849	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32527335	32527335	PRJNA495391_S_NODE_7159_length_456_cov_2.258907_g6109_i0	PRJNA495391	7159	456	2.258907	10.30061592	Bacteria	2	Bacteria	Bacteria	70.9	7.26e-12	NR	MBL7185283.1	2026778	g6109	i0	37.5	1.95394736842105	96	56	60.5	3	24	299	86	181	MBL7185283.1 hypothetical protein [Phycisphaerae bacterium]	diamond	891	71.2	0.995786516853933	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32858052	32858052	PRJNA495391_S_NODE_26120_length_236_cov_1.706468_g25068_i0	PRJNA495391	26120	236	1.706468	4.02726448	Chthoniobacter sp.	2510640	Bacteria	Bacteria	142	2.629999999999999e-38	NR	MDR3405335.1	2510640	g25068	i0	84.6	0.991525423728814	78	12	99.2	0	2	235	309	386	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	234	142	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.

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