metadata: contig_metadata: 6 rows where bioproject = "PRJNA280983" and tax

6 rows where bioproject = "PRJNA280983" 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
371675	371675	PRJNA280983_P_NODE_8641_length_186_cov_1.839416_g8526_i0	PRJNA280983	8641	186	1.839416	3.42131376	planctomycete str. 449	79870	Bacteria	Bacteria	302	1.43e-77	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g8526	i0	98.817	96.010752688172	169	2	91	0	1	169	2259	2427	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	17858	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
5475042	5475042	PRJNA280983_P_NODE_405_length_1123_cov_6.821229_g342_i0	PRJNA280983	405	1123	6.821229	76.60240167	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	898	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g342	i0	81.69	562.195903829029	1136	157	98	37	6	1103	7050683	7051805	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	631346	898	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8024952	8024952	PRJNA280983_P_NODE_6147_length_245_cov_1.801020_g6032_i0	PRJNA280983	6147	245	1.80102	4.412499	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	433	6.76e-117	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g6032	i0	98.765	189.542857142857	243	3	99	0	3	245	3095921	3096163	Pirellula sp. SH-Sr6A, complete genome	blastn	46438	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
24010890	24010890	PRJNA280983_P_NODE_599_length_958_cov_4.562156_g523_i0	PRJNA280983	599	958	4.562156	43.70545448	Bacteria	2	Bacteria	Bacteria	763	0	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g523	i0	81.732	283.832985386221	947	143	97	23	26	958	720675	719745	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	271912	763	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32209906	32209906	PRJNA280983_P_NODE_7798_length_202_cov_1.666667_g7683_i0	PRJNA280983	7798	202	1.666667	3.36666734	Pseudomonadati	3379134	Bacteria	Bacteria	51.6	1.67e-5	NR	WP_145342364.1	1930277	g7683	i0	56.5	3.38613861386139	46	20	68.3	0	178	41	1246	1291	WP_145342364.1 Ig-like domain-containing protein [Rosistilla ulvae]	diamond	684	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
32350591	32350591	PRJNA280983_P_NODE_5379_length_271_cov_0.918919_g5264_i0	PRJNA280983	5379	271	0.918919	2.49027049	Opitutaceae bacterium	2006848	Bacteria	Bacteria	43.9	0.0207	NR	HYC73099.1	2006848	g5264	i0	35.1	0.819188191881919	74	42	77.5	2	56	265	276	347	HYC73099.1 hypothetical protein [Opitutaceae bacterium]	diamond	222	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;