metadata: contig_metadata: 14 rows where bioproject = "PRJEB65099" and tax

14 rows where bioproject = "PRJEB65099" 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
9057201	9057201	PRJEB65099_P_NODE_1028_length_625_cov_5.400362_g924_i0	PRJEB65099	1028	625	5.400362	33.7522625	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	734	0	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g924	i0	88.226	120.8656	620	65	99	8	1	617	2623595	2622981	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	75541	734	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11608455	11608455	PRJEB65099_P_NODE_2750_length_348_cov_1.134545_g2645_i0	PRJEB65099	2750	348	1.134545	3.9482166	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	521	2.089999999999999e-143	NTclustered	gi\|523452411\|gb\|KF182831.1\|	120965	g2645	i0	93.696	100.896551724138	349	20	100	2	1	348	17	364	Uncultured planctomycete clone S1-090 16S ribosomal RNA gene, partial sequence	blastn	35112	521	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
12883554	12883554	PRJEB65099_P_NODE_5511_length_250_cov_0.881356_g5406_i0	PRJEB65099	5511	250	0.881356	2.20339	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	100	7.97e-17	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g5406	i0	74.803	20.596	254	49	97	14	5	246	2664206	2663956	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	5149	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17981512	17981512	PRJEB65099_P_NODE_6935_length_242_cov_0.923077_g6830_i0	PRJEB65099	6935	242	0.923077	2.23384634	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g6830	i0	94.215	104.652892561983	242	14	100	0	1	242	1230266	1230507	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	25326	370	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23081885	23081885	PRJEB65099_P_NODE_6719_length_243_cov_0.917647_g6614_i0	PRJEB65099	6719	243	0.917647	2.22988221	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g6614	i0	98.765	319.954732510288	243	3	100	0	1	243	3412709	3412951	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	77749	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
26590414	26590414	PRJEB65099_P_NODE_5321_length_251_cov_0.876404_g5216_i0	PRJEB65099	5321	251	0.876404	2.19977404	Chthoniobacter sp.	2510640	Bacteria	Bacteria	72.4	6.83e-14	NR	MDB6151496.1	2510640	g5216	i0	47.4	0.908366533864542	76	37	90.8	1	250	23	57	129	MDB6151496.1 hypothetical protein [Chthoniobacter sp.]	diamond	228	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
26900400	26900400	PRJEB65099_P_NODE_6621_length_243_cov_0.917647_g6516_i0	PRJEB65099	6621	243	0.917647	2.22988221	Pseudomonadati	3379134	Bacteria	Bacteria	82.4	4.01e-16	NR	OGX18345.1	1801848	g6516	i0	70	2.22222222222222	60	18	74.1	0	181	2	748	807	OGX18345.1 MAG: hypothetical protein A2105_01985 [Omnitrophica WOR_2 bacterium GWF2_63_9]	diamond	540	83.2	0.990384615384615	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Omnitrophica WOR_2 bacterium GWF2_63_9
27690693	27690693	PRJEB65099_P_NODE_5484_length_250_cov_0.881356_g5379_i0	PRJEB65099	5484	250	0.881356	2.20339	Bacteria	2	Bacteria	Bacteria	144	5.49e-40	NR	MBX3316661.1	2026777	g5379	i0	96.2	1.884	79	3	94.8	0	239	3	195	273	MBX3316661.1 periplasmic heavy metal sensor [Phycisphaeraceae bacterium]	diamond	471	145	0.993103448275862	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28013260	28013260	PRJEB65099_P_NODE_5765_length_248_cov_0.891429_g5660_i0	PRJEB65099	5765	248	0.891429	2.21074392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	117	1.05e-28	NR	MBL8752114.1	2026780	g5660	i0	76.5	0.979838709677419	81	19	98	0	4	246	118	198	MBL8752114.1 hypothetical protein [Planctomycetota bacterium]	diamond	243	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28518363	28518363	PRJEB65099_P_NODE_3607_length_293_cov_1.918182_g3502_i0	PRJEB65099	3607	293	1.918182	5.62027326	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	67.4	2.97e-11	NR	HEV8051868.1	2052176	g3502	i0	66	0.511945392491468	50	17	51.2	0	152	3	60	109	HEV8051868.1 MarC family protein [Parachlamydiaceae bacterium]	diamond	150	67.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29150134	29150134	PRJEB65099_P_NODE_1389_length_524_cov_0.895787_g1284_i0	PRJEB65099	1389	524	0.895787	4.69392388	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47	0.0142	NR	MEY4687148.1	2026799	g1284	i0	34.3	0.784351145038168	137	65	74.4	6	63	452	198	316	MEY4687148.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	411	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30191794	30191794	PRJEB65099_P_NODE_6052_length_246_cov_0.901734_g5947_i0	PRJEB65099	6052	246	0.901734	2.21826564	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	149	1.23e-42	NR	MFN0010158.1	2052180	g5947	i0	95.1	0.98780487804878	81	4	98.8	0	3	245	52	132	MFN0010158.1 BtpA/SgcQ family protein [Phycisphaerales bacterium]	diamond	243	149	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30444794	30444794	PRJEB65099_P_NODE_6413_length_244_cov_1.461988_g6308_i0	PRJEB65099	6413	244	1.461988	3.56725072	Verrucomicrobiales bacterium VVV1	2015575	Bacteria	Bacteria	109	1.32e-25	NR	OYV05812.1	2015575	g6308	i0	88.9	0.663934426229508	54	6	66.4	0	3	164	631	684	OYV05812.1 MAG: hypothetical protein CFE26_09630 [Verrucomicrobiales bacterium VVV1]	diamond	162	109	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium VVV1
31329413	31329413	PRJEB65099_P_NODE_5436_length_250_cov_0.881356_g5331_i0	PRJEB65099	5436	250	0.881356	2.20339	Gemmataceae bacterium	2052164	Bacteria	Bacteria	81.3	1.08e-15	NR	HVS37301.1	2052164	g5331	i0	45.1	0.984	82	45	98.4	0	3	248	581	662	HVS37301.1 C39 family peptidase [Gemmataceae bacterium]	diamond	246	81.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;