metadata: contig_metadata: 11 rows where bioproject = "PRJEB2925", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJEB2925", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
3852264	3852264	PRJEB2925_P_NODE_3304_length_800_cov_3.036601_g2527_i0	PRJEB2925	3304	800	3.036601	24.292808	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1029	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g2527	i0	89.841	198.00375	817	62	100	13	1	800	5935845	5936657	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	158403	1029	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10228903	10228903	PRJEB2925_P_NODE_3289_length_802_cov_4.559322_g2515_i0	PRJEB2925	3289	802	4.559322	36.56576244	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	560	1.0799999999999998e-154	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g2515	i0	82.105	349.573566084788	665	110	83	9	141	802	1867452	1866794	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	280358	560	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
14054345	14054345	PRJEB2925_P_NODE_9612_length_379_cov_2.773256_g8341_i0	PRJEB2925	9612	379	2.773256	10.51064024	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	673	0	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g8341	i0	98.681	188.348284960422	379	5	100	0	1	379	3095845	3096223	Pirellula sp. SH-Sr6A, complete genome	blastn	71384	673	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
15328339	15328339	PRJEB2925_P_NODE_9513_length_382_cov_6.432277_g8243_i0	PRJEB2925	9513	382	6.432277	24.57129814	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	508	1.8e-139	NTclustered	gi\|134020509\|gb\|EF019085.1\|	120965	g8243	i0	90.814	99.0811518324607	381	33	99	2	3	382	564	943	Uncultured planctomycete clone Amb_16S_1677 16S ribosomal RNA gene, partial sequence	blastn	37849	508	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
16602861	16602861	PRJEB2925_P_NODE_11854_length_316_cov_2.992883_g10579_i0	PRJEB2925	11854	316	2.992883	9.45751028	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	584	2.359999999999999e-162	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g10579	i0	100	126.446202531646	316	0	100	0	1	316	3095323	3095638	Pirellula sp. SH-Sr6A, complete genome	blastn	39957	584	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
16602932	16602932	PRJEB2925_P_NODE_3114_length_835_cov_4.682500_g2375_i0	PRJEB2925	3114	835	4.6825	39.098875	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	987	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g2375	i0	88.249	118.050299401198	834	86	99	10	8	835	2190145	2190972	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	98572	987	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
17565964	17565964	PRJEB2925_P_NODE_3014_length_855_cov_2.597561_g2288_i0	PRJEB2925	3014	855	2.597561	22.20914655	Planctomyces	118	Bacteria	Bacteria	782	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g2288	i0	93.548	131.273684210526	527	31	90	3	4	529	5936778	5937302	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	112239	782	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17877735	17877735	PRJEB2925_P_NODE_15655_length_252_cov_3.732719_g14377_i0	PRJEB2925	15655	252	3.732719	9.40645188	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	235	2.11e-57	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g14377	i0	96.479	55.1190476190476	142	5	100	0	111	252	3097616	3097757	Pirellula sp. SH-Sr6A, complete genome	blastn	13890	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
17877744	17877744	PRJEB2925_P_NODE_1855_length_1270_cov_75.888259_g850_i1	PRJEB2925	1855	1270	75.888259	963.7808893	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1461	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g850	i1	87.549	117.423622047244	1277	141	100	18	1	1270	1868496	1867231	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	149128	1461	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
26780156	26780156	PRJEB2925_P_NODE_9181_length_394_cov_3.169916_g7914_i0	PRJEB2925	9181	394	3.169916	12.48946904	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.1	0.0306	NR	MCC6660190.1	2052180	g7914	i0	40	0.609137055837564	80	38	60.2	3	17	253	60	130	MCC6660190.1 hypothetical protein [Phycisphaerales bacterium]	diamond	240	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27697037	27697037	PRJEB2925_P_NODE_15864_length_250_cov_1.069767_g14586_i0	PRJEB2925	15864	250	1.069767	2.6744175	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.2	7.54e-8	NR	MFN0008317.1	2026780	g14586	i0	64.3	0.504	42	15	50.4	0	245	120	75	116	MFN0008317.1 helix-turn-helix domain-containing protein [Planctomycetota bacterium]	diamond	126	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;