metadata: contig_metadata: 7 rows where bioproject = "PRJNA177642" and tax

7 rows where bioproject = "PRJNA177642" 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
1640404	1640404	PRJNA177642_P_NODE_5962_length_572_cov_3.151013_g4854_i0	PRJNA177642	5962	572	3.151013	18.02379436	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	621	3.4299999999999994e-173	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g4854	i0	86.538	7.26748251748252	572	68	100	3	1	572	3216479	3215917	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	4157	621	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8018757	8018757	PRJNA177642_P_NODE_11507_length_324_cov_1.294915_g10282_i0	PRJNA177642	11507	324	1.294915	4.1955246	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	78.7	5.02e-10	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g10282	i0	87.143	0.70679012345679	70	7	21	2	4	72	614763	614831	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	229	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13119280	13119280	PRJNA177642_P_NODE_17411_length_167_cov_1.028986_g16186_i0	PRJNA177642	17411	167	1.028986	1.71840662	Bacteria	2	Bacteria	Bacteria	100	9.6e-24	NR	MDE2506368.1	2026780	g16186	i0	87.3	3.93413173652695	55	7	98.8	0	1	165	74	128	MDE2506368.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Planctomycetota bacterium]	diamond	657	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
22042107	22042107	PRJNA177642_P_NODE_17018_length_169_cov_1.007143_g15793_i0	PRJNA177642	17018	169	1.007143	1.70207167	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	255	1e-63	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g15793	i0	94.048	0.994082840236686	168	10	99	0	2	169	1332086	1331919	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	168	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
26852685	26852685	PRJNA177642_P_NODE_15821_length_180_cov_1.688742_g14596_i0	PRJNA177642	15821	180	1.688742	3.0397356	Planctomycetota bacterium	2026780	Bacteria	Bacteria	61.6	3.62e-9	NR	HEY3322403.1	2026780	g14596	i0	62.3	3.38333333333333	61	16	90	1	162	1	670	730	HEY3322403.1 Ig-like domain repeat protein [Planctomycetota bacterium]	diamond	609	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28007879	28007879	PRJNA177642_P_NODE_18865_length_157_cov_3.117188_g17640_i0	PRJNA177642	18865	157	3.117188	4.89398516	Planctomycetota	203682	Bacteria	Bacteria	69.3	4.67e-12	NR	MBN2560503.1	2026778	g17640	i0	58.8	9.74522292993631	51	21	97.5	0	3	155	265	315	MBN2560503.1 protein kinase [Phycisphaerae bacterium]	diamond	1530	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31577222	31577222	PRJNA177642_P_NODE_10836_length_338_cov_0.987055_g9612_i0	PRJNA177642	10836	338	0.987055	3.3362459	Pseudomonadati	3379134	Bacteria	Bacteria	57.4	7.57e-7	NR	MCH8270949.1	2026780	g9612	i0	100	0.532544378698225	30	0	26.6	0	241	330	268	297	MCH8270949.1 asparaginase [Planctomycetota bacterium]	diamond	180	57.4	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);;