metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA588137" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA588137" 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
11341824	11341824	PRJNA588137_S_NODE_4869_length_276_cov_1.201970_g4836_i0	PRJNA588137	4869	276	1.20197	3.3174372	Gemmataceae bacterium	2052164	Bacteria	Bacteria	98.6	1.25e-21	NR	MFO0800185.1	2052164	g4836	i0	91.1	0.608695652173913	56	5	60.9	0	221	54	539	594	MFO0800185.1 hypothetical protein [Gemmataceae bacterium]	diamond	168	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
24090312	24090312	PRJNA588137_S_NODE_11159_length_241_cov_0.916667_g11126_i0	PRJNA588137	11159	241	0.916667	2.20916747	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	160	5.449999999999999e-46	NR	WP_146677811.1	1632865	g11126	i0	98.7	1.94190871369295	78	1	97.1	0	7	240	30	107	WP_146677811.1 phosphoribosylformylglycinamidine cyclo-ligase [Pirellula sp. SH-Sr6A]	diamond	468	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
26826669	26826669	PRJNA588137_S_NODE_2241_length_352_cov_1.103943_g2208_i0	PRJNA588137	2241	352	1.103943	3.88587936	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	62.8	1.02e-8	NR	HEV3410536.1	2201154	g2208	i0	45.3	0.545454545454545	64	35	54.5	0	198	7	21	84	HEV3410536.1 fatty acid desaturase [Chthoniobacterales bacterium]	diamond	192	62.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27711945	27711945	PRJNA588137_S_NODE_8124_length_247_cov_0.885057_g8091_i0	PRJNA588137	8124	247	0.885057	2.18609079	Pirellulales bacterium	2715253	Bacteria	Bacteria	53.1	8.71e-6	NR	MFO0923652.1	2715253	g8091	i0	41.2	1.03238866396761	85	43	94.7	2	235	2	236	320	MFO0923652.1 SdrD B-like domain-containing protein [Pirellulales bacterium]	diamond	255	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
28784834	28784834	PRJNA588137_S_NODE_627_length_582_cov_1.713163_g596_i0	PRJNA588137	627	582	1.713163	9.97060866	Pirellula sp.	117	Bacteria	Bacteria	55.8	2.47e-5	NR	MFM7931657.1	117	g596	i0	41.6	1.56185567010309	101	54	51	3	286	582	14	111	MFM7931657.1 SdrD B-like domain-containing protein [Pirellula sp.]	diamond	909	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
31470347	31470347	PRJNA588137_S_NODE_7956_length_248_cov_0.880000_g7923_i0	PRJNA588137	7956	248	0.88	2.1824	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	112	5.11e-30	NR	MCU0702655.1	1914235	g7923	i0	80	0.786290322580645	65	12	77.4	1	192	1	1	65	MCU0702655.1 hypothetical protein [Fimbriiglobus sp.]	diamond	195	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
32229599	32229599	PRJNA588137_S_NODE_7058_length_250_cov_0.870056_g7025_i0	PRJNA588137	7058	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	138	1.1199999999999999e-40	NR	MEN9404541.1	2026799	g7025	i0	93.2	0.876	73	5	87.6	0	221	3	1	73	MEN9404541.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	219	138	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32243209	32243209	PRJNA588137_S_NODE_7978_length_248_cov_0.880000_g7945_i0	PRJNA588137	7978	248	0.88	2.1824	Verrucomicrobiota	74201	Bacteria	Bacteria	86.7	3.49e-18	NR	WP_170266573.1	748831	g7945	i0	58.2	3.32661290322581	67	28	81	0	46	246	218	284	WP_170266573.1 DMT family transporter [Brevifollis gellanilyticus]	diamond	825	87	0.996551724137931	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus

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