metadata: contig_metadata: 12 rows where bioproject = "PRJNA690234" and tax

12 rows where bioproject = "PRJNA690234" 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
670412	670412	PRJNA690234_P_NODE_32461_length_233_cov_2.831250_g32094_i0	PRJNA690234	32461	233	2.83125	6.5968125	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	303	5.21e-78	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g32094	i0	90.435	73.2103004291845	230	22	99	0	4	233	5363654	5363425	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	17058	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
1945989	1945989	PRJNA690234_P_NODE_12382_length_360_cov_1.358885_g12015_i0	PRJNA690234	12382	360	1.358885	4.891986	planctomycete str. 139	149588	Bacteria	Bacteria	494	4.72e-135	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g12015	i0	91.413	59.2083333333333	361	30	100	1	1	360	1415	1775	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	21315	494	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
8323184	8323184	PRJNA690234_P_NODE_19247_length_289_cov_1.143519_g18880_i0	PRJNA690234	19247	289	1.143519	3.30476991	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	340	5.0999999999999986e-89	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g18880	i0	87.889	6.2076124567474	289	35	100	0	1	289	7872801	7873089	Planctomyces sp. SH-PL14, complete genome	blastn	1794	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
10873939	10873939	PRJNA690234_P_NODE_11529_length_374_cov_1.790698_g11163_i0	PRJNA690234	11529	374	1.790698	6.69721052	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	344	5.24e-90	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g11163	i0	83.463	199.885026737968	387	47	99	11	1	373	2664416	2664033	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	74757	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13424273	13424273	PRJNA690234_P_NODE_5991_length_529_cov_1.557018_g5627_i0	PRJNA690234	5991	529	1.557018	8.23662522	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	542	2.53e-149	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g5627	i0	93.261	73.3005671077505	371	20	70	3	1	369	1155480	1155113	Planctomyces sp. SH-PL62, complete genome	blastn	38776	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19797021	19797021	PRJNA690234_P_NODE_19436_length_287_cov_2.864486_g19069_i0	PRJNA690234	19436	287	2.864486	8.22107482	Symmachiella dynata	2527995	Bacteria	Bacteria	424	4.88e-114	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g19069	i0	93.38	125.390243902439	287	17	99	2	1	286	1041543	1041258	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	35987	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
22347394	22347394	PRJNA690234_P_NODE_17418_length_304_cov_1.350649_g17051_i0	PRJNA690234	17418	304	1.350649	4.10597296	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	510	3.89e-140	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g17051	i0	97.039	235.148026315789	304	8	100	1	1	304	1256	954	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	71485	510	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
27019131	27019131	PRJNA690234_P_NODE_28502_length_247_cov_0.896552_g28135_i0	PRJNA690234	28502	247	0.896552	2.21448344	Pirellulales bacterium	2715253	Bacteria	Bacteria	124	9.63e-31	NR	MEX2091435.1	2715253	g28135	i0	70.7	0.995951417004049	82	24	99.6	0	2	247	275	356	MEX2091435.1 endo-1,4-beta-xylanase [Pirellulales bacterium]	diamond	246	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27177030	27177030	PRJNA690234_P_NODE_19922_length_284_cov_1.734597_g19555_i0	PRJNA690234	19922	284	1.734597	4.92625548	Gemmataceae bacterium	2052164	Bacteria	Bacteria	54.7	3.03e-6	NR	MFN4258049.1	2052164	g19555	i0	35.9	0.823943661971831	78	50	82.4	0	51	284	5	82	MFN4258049.1 tetratricopeptide repeat protein [Gemmataceae bacterium]	diamond	234	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27714618	27714618	PRJNA690234_P_NODE_26824_length_250_cov_0.881356_g26457_i0	PRJNA690234	26824	250	0.881356	2.20339	Planctomyces sp.	37635	Bacteria	Bacteria	142	1.47e-39	NR	MBA4029640.1	37635	g26457	i0	84.3	0.996	83	13	99.6	0	250	2	96	178	MBA4029640.1 nucleotide pyrophosphatase [Planctomyces sp.]	diamond	249	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
31725839	31725839	PRJNA690234_P_NODE_6097_length_524_cov_1.620843_g5733_i0	PRJNA690234	6097	524	1.620843	8.49321732	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	183	7.559999999999998e-54	NR	MCI5051869.1	2698248	g5733	i0	54.6	1.9236641221374	174	76	99.6	2	524	3	140	310	MCI5051869.1 transaldolase [Simkaniaceae bacterium]	diamond	1008	183	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
32169056	32169056	PRJNA690234_P_NODE_14498_length_333_cov_2.630769_g14131_i0	PRJNA690234	14498	333	2.630769	8.76046077	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	45.1	0.00974	NR	HEU0273395.1	2665650	g14131	i0	30.7	1.86486486486486	114	66	92.8	3	326	18	40	151	HEU0273395.1 YdeI family protein [Candidatus Udaeobacter sp.]	diamond	621	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter 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);;