metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA774958" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA774958" 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_species
9680959	9680959	PRJNA774958_P_NODE_1368_length_1268_cov_4.610879_g1254_i0	PRJNA774958	1368	1268	4.610879	58.46594572	root	1	Root_unresolved	Root_unresolved	505	4.379999999999999e-174	NR	MBL8900762.1	2026780	g1254	i0	58.5	10.8430599369085	414	170	97.5	1	1245	10	46	459	MBL8900762.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	13749	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
27085041	27085041	PRJNA774958_P_NODE_28062_length_286_cov_1.323944_g27815_i0	PRJNA774958	28062	286	1.323944	3.78647984	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	173	8.199999999999998e-53	NR	RYD67753.1	2026800	g27815	i0	86.3	0.996503496503496	95	13	99.7	0	2	286	93	187	RYD67753.1 MAG: hypothetical protein EOP83_02210 [Verrucomicrobiaceae bacterium]	diamond	285	173	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
27600170	27600170	PRJNA774958_P_NODE_23704_length_321_cov_1.020161_g23457_i0	PRJNA774958	23704	321	1.020161	3.27471681	root	1	Root_unresolved	Root_unresolved	53.1	1.8e-5	NR	MFA7345307.1	2832348	g23457	i0	44.3	1.22429906542056	70	38	65.4	1	101	310	20	88	MFA7345307.1 2-enoyl thioester reductase domain-containing protein [Terrimicrobiaceae bacterium]	diamond	393	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobiaceae bacterium
29453030	29453030	PRJNA774958_P_NODE_30110_length_272_cov_1.160804_g29863_i0	PRJNA774958	30110	272	1.160804	3.15738688	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	165	6.229999999999999e-48	NR	RYD65414.1	2026800	g29863	i0	81.1	0.992647058823529	90	17	99.3	0	2	271	234	323	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	270	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
30969819	30969819	PRJNA774958_P_NODE_22434_length_332_cov_2.621622_g22187_i0	PRJNA774958	22434	332	2.621622	8.70378504	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.4	0.00216	NR	MBM4009064.1	2026780	g22187	i0	40.9	0.795180722891566	44	23	37	1	52	174	135	178	MBM4009064.1 DMT family transporter [Planctomycetota bacterium]	diamond	264	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
31854949	31854949	PRJNA774958_P_NODE_11717_length_477_cov_1.903465_g11470_i0	PRJNA774958	11717	477	1.903465	9.07952805	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.1	0.0371	NR	MEM6277946.1	2026799	g11470	i0	40	0.408805031446541	65	38	40.3	1	467	276	6	70	MEM6277946.1 D-Ala-D-Ala carboxypeptidase family metallohydrolase [Verrucomicrobiota bacterium]	diamond	195	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
32488016	32488016	PRJNA774958_P_NODE_35259_length_248_cov_0.880000_g35012_i0	PRJNA774958	35259	248	0.88	2.1824	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0486	NR	MDQ3624016.1	2026799	g35012	i0	27.3	0.798387096774194	66	48	79.8	0	219	22	95	160	MDQ3624016.1 diacylglycerol kinase family lipid kinase [Verrucomicrobiota bacterium]	diamond	198	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota 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);;