metadata: contig_metadata: 18 rows where bioproject = "PRJNA891846" and tax

18 rows where bioproject = "PRJNA891846" 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
867419	867419	PRJNA891846_P_NODE_41121_length_247_cov_0.885057_g40901_i0	PRJNA891846	41121	247	0.885057	2.18609079	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	191	4.53e-44	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g40901	i0	80.723	38.4817813765182	249	44	100	3	1	247	453747	453501	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	9505	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
7244995	7244995	PRJNA891846_P_NODE_19726_length_343_cov_2.340741_g19507_i0	PRJNA891846	19726	343	2.340741	8.02874163	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	255	2.3e-63	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g19507	i0	97.333	96.3381924198251	150	4	87	0	194	343	5935493	5935344	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	33044	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9795212	9795212	PRJNA891846_P_NODE_37988_length_250_cov_0.870056_g37768_i0	PRJNA891846	37988	250	0.870056	2.17514	Planctomycetia bacterium	2052181	Bacteria	Bacteria	174	4.1199999999999996e-54	NR	MFM9194273.1	2052181	g37768	i0	94	2.988	83	5	99.6	0	249	1	65	147	MFM9194273.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetia bacterium]	diamond	747	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27213430	27213430	PRJNA891846_P_NODE_46762_length_241_cov_1.476190_g46542_i0	PRJNA891846	46762	241	1.47619	3.5576179	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	112	1.09e-26	NR	MBF0387537.1	2035772	g46542	i0	74.7	0.983402489626556	79	20	98.3	0	239	3	611	689	MBF0387537.1 response regulator [Candidatus Omnitrophota bacterium]	diamond	237	112	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
27624451	27624451	PRJNA891846_P_NODE_46304_length_242_cov_0.911243_g46084_i0	PRJNA891846	46304	242	0.911243	2.20520806	Planctomycetota bacterium	2026780	Bacteria	Bacteria	122	4.35e-31	NR	MFN9606295.1	2026780	g46084	i0	74.7	0.979338842975207	79	20	97.9	0	2	238	237	315	MFN9606295.1 cysteine desulfurase family protein [Planctomycetota bacterium]	diamond	237	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27876841	27876841	PRJNA891846_P_NODE_44905_length_243_cov_0.905882_g44685_i0	PRJNA891846	44905	243	0.905882	2.20129326	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	130	1.25e-36	NR	MFO0067820.1	2699754	g44685	i0	88	2.04938271604938	83	6	97.5	1	2	238	63	145	MFO0067820.1 hypothetical protein [Pirellulaceae bacterium]	diamond	498	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27908143	27908143	PRJNA891846_P_NODE_46145_length_242_cov_0.911243_g45925_i0	PRJNA891846	46145	242	0.911243	2.20520806	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	122	3.52e-30	NR	MAD26228.1	2026801	g45925	i0	69.6	0.979338842975207	79	24	97.9	0	239	3	1303	1381	MAD26228.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	237	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27940103	27940103	PRJNA891846_P_NODE_37625_length_250_cov_0.870056_g37405_i0	PRJNA891846	37625	250	0.870056	2.17514	Prosthecobacter sp.	1965333	Bacteria	Bacteria	136	4.58e-35	NR	WP_395716847.1	1965333	g37405	i0	92.8	1.992	83	6	99.6	0	2	250	196	278	WP_395716847.1 tetratricopeptide repeat protein [Prosthecobacter sp.]	diamond	498	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
28350426	28350426	PRJNA891846_P_NODE_44966_length_243_cov_0.905882_g44746_i0	PRJNA891846	44966	243	0.905882	2.20129326	Opitutaceae bacterium	2006848	Bacteria	Bacteria	64.3	9.33e-10	NR	HEX2852909.1	2006848	g44746	i0	53.3	0.740740740740741	60	27	72.8	1	178	2	669	728	HEX2852909.1 immunoglobulin domain-containing protein [Opitutaceae bacterium]	diamond	180	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28666333	28666333	PRJNA891846_P_NODE_37247_length_251_cov_0.865169_g37027_i0	PRJNA891846	37247	251	0.865169	2.17157419	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	167	7.9e-50	NR	MFM8327302.1	2699754	g37027	i0	97.6	5.8804780876494	82	2	98	0	250	5	192	273	MFM8327302.1 LamG-like jellyroll fold domain-containing protein [Pirellulaceae bacterium]	diamond	1476	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28982156	28982156	PRJNA891846_P_NODE_37688_length_250_cov_0.870056_g37468_i0	PRJNA891846	37688	250	0.870056	2.17514	Pirellula sp.	117	Bacteria	Bacteria	166	4.58e-49	NR	MFM8398533.1	117	g37468	i0	97.6	3.936	82	2	98.4	0	3	248	146	227	MFM8398533.1 hypothetical protein [Pirellula sp.]	diamond	984	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
29140071	29140071	PRJNA891846_P_NODE_37929_length_250_cov_0.870056_g37709_i0	PRJNA891846	37929	250	0.870056	2.17514	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	145	1.55e-41	NR	MFO0979471.1	2026779	g37709	i0	83.3	1.008	84	13	99.6	1	2	250	126	209	MFO0979471.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex dimerization subunit type 1 TsaB [Planctomycetaceae bacterium]	diamond	252	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30150132	30150132	PRJNA891846_P_NODE_44132_length_244_cov_0.900585_g43912_i0	PRJNA891846	44132	244	0.900585	2.1974274	Pirellula sp.	117	Bacteria	Bacteria	98.2	1.2e-21	NR	MEQ1825597.1	117	g43912	i0	59.5	1.95491803278689	79	32	97.1	0	2	238	460	538	MEQ1825597.1 PA14 domain-containing protein [Pirellula sp.]	diamond	477	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
30403582	30403582	PRJNA891846_P_NODE_40013_length_248_cov_0.880000_g39793_i0	PRJNA891846	40013	248	0.88	2.1824	Novipirellula galeiformis	2528004	Bacteria	Bacteria	57.4	2.68e-7	NR	WP_146593588.1	2528004	g39793	i0	38.3	0.979838709677419	81	43	98	1	3	245	321	394	WP_146593588.1 acyl-CoA synthetase [Novipirellula galeiformis]	diamond	243	57.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Novipirellula	Novipirellula galeiformis
30497968	30497968	PRJNA891846_P_NODE_16833_length_370_cov_1.845118_g16614_i0	PRJNA891846	16833	370	1.845118	6.8269366	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0495	NR	MEY4394394.1	2026780	g16614	i0	29.9	0.543243243243243	67	47	54.3	0	138	338	226	292	MEY4394394.1 hypothetical protein [Planctomycetota bacterium]	diamond	201	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31793756	31793756	PRJNA891846_P_NODE_36797_length_251_cov_0.865169_g36577_i0	PRJNA891846	36797	251	0.865169	2.17157419	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.2	0.0456	NR	MFT5422601.1	2052180	g36577	i0	41.8	0.657370517928287	55	32	65.7	0	17	181	18	72	MFT5422601.1 hypothetical protein [Phycisphaerales bacterium]	diamond	165	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31983706	31983706	PRJNA891846_P_NODE_39878_length_248_cov_0.880000_g39658_i0	PRJNA891846	39878	248	0.88	2.1824	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	75.1	1.6e-13	NR	RPH79137.1	2026779	g39658	i0	44	0.907258064516129	75	42	90.7	0	226	2	508	582	RPH79137.1 MAG: hypothetical protein EHM77_06210, partial [Planctomycetaceae bacterium]	diamond	225	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32205337	32205337	PRJNA891846_P_NODE_43238_length_245_cov_0.895349_g43018_i0	PRJNA891846	43238	245	0.895349	2.19360505	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	163	1.24e-45	NR	NBV38207.1	2026799	g43018	i0	95.1	0.991836734693878	81	4	99.2	0	244	2	62	142	NBV38207.1 2-succinyl-5-enolpyruvyl-6-hydroxy-3-cyclohexene-1-carboxylic-acid synthase [Verrucomicrobiota bacterium]	diamond	243	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;