metadata: contig_metadata: 5 rows where bioproject = "PRJNA888104" and tax

5 rows where bioproject = "PRJNA888104" 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
1241517	1241517	PRJNA888104_P_NODE_17781_length_244_cov_1.251429_g17712_i0	PRJNA888104	17781	244	1.251429	3.05348676	Gemmata	113	Bacteria	Bacteria	315	2.5399999999999992e-81	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g17712	i0	90.164	330.614754098361	244	21	100	2	1	244	2941790	2942030	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	80670	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
8515128	8515128	PRJNA888104_P_NODE_19307_length_235_cov_3.373494_g19238_i0	PRJNA888104	19307	235	3.373494	7.9277109	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	298	2.45e-76	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g19238	i0	89.451	191.910638297872	237	23	100	2	1	235	2002078	2002314	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	45099	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8515195	8515195	PRJNA888104_P_NODE_22327_length_229_cov_1.787500_g22258_i0	PRJNA888104	22327	229	1.7875	4.093375	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	228	3.159999999999999e-55	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g22258	i0	85.202	33.0698689956332	223	31	97	2	1	223	3082604	3082384	Stratiformator vulcanicus strain Pan189 chromosome	blastn	7573	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
22538885	22538885	PRJNA888104_P_NODE_13798_length_276_cov_1.990338_g13729_i0	PRJNA888104	13798	276	1.990338	5.49333288	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	363	1.03e-95	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g13729	i0	90.323	91.8260869565217	279	24	100	2	1	276	4961413	4961691	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	25344	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
32584956	32584956	PRJNA888104_P_NODE_14019_length_274_cov_2.517073_g13950_i0	PRJNA888104	14019	274	2.517073	6.89678002	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	44.7	0.0109	NR	NNE91183.1	2026801	g13950	i0	36.8	0.624087591240876	57	35	61.3	1	183	16	269	325	NNE91183.1 tRNA guanosine(34) transglycosylase Tgt [Verrucomicrobiales bacterium]	diamond	171	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;