metadata: contig_metadata: 4 rows where bioproject = "PRJNA951388" and tax

4 rows where bioproject = "PRJNA951388" 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
16237563	16237563	PRJNA951388_S_NODE_2713_length_466_cov_2.155216_g2586_i0	PRJNA951388	2713	466	2.155216	10.04330656	Opitutales bacterium	2026772	Bacteria	Bacteria	390	8.45e-104	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g2586	i0	82.189	273.332618025751	466	72	99	11	3	462	977704	977244	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	127373	390	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
27095322	27095322	PRJNA951388_S_NODE_962_length_660_cov_20.367973_g847_i0	PRJNA951388	962	660	20.367973	134.4286218	Pseudomonadati	3379134	Bacteria	Bacteria	204	2.0099999999999997e-61	NR	MBN1402941.1	2026772	g847	i0	55.1	13.6818181818182	198	85	90	3	1	594	123	316	MBN1402941.1 transaldolase [Opitutales bacterium]	diamond	9030	206	0.990291262135922	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
28636483	28636483	PRJNA951388_S_NODE_10747_length_250_cov_4.785311_g10620_i0	PRJNA951388	10747	250	4.785311	11.9632775	Spartobacteria bacterium	2052183	Bacteria	Bacteria	52.4	1.62e-5	NR	NCC52901.1	2052183	g10620	i0	48.2	1.308	56	29	67.2	0	2	169	70	125	NCC52901.1 hypothetical protein [Spartobacteria bacterium]	diamond	327	52.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium
32396854	32396854	PRJNA951388_S_NODE_4699_length_385_cov_4.137821_g4572_i0	PRJNA951388	4699	385	4.137821	15.93061085	Blastopirellula sediminis	2894196	Bacteria	Bacteria	45.4	0.0173	NR	WP_230222336.1	2894196	g4572	i0	30	0.545454545454545	70	47	53	1	60	263	280	349	WP_230222336.1 mannose-1-phosphate guanylyltransferase [Blastopirellula sediminis]	diamond	210	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sediminis

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);;