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

8 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax_phylum = "Verrucomicrobiota"

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
9842458	9842458	PRJNA939369_S_NODE_54848_length_251_cov_0.865169_g54431_i0	PRJNA939369	54848	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	176	7.08e-51	NR	HCG20426.1	2026799	g54431	i0	95.2	19.8406374501992	83	4	99.2	0	250	2	10	92	HCG20426.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase GatCAB subunit B [Verrucomicrobiota bacterium]	diamond	4980	177	0.994350282485876	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26993089	26993089	PRJNA939369_S_NODE_17402_length_353_cov_1.082143_g16985_i0	PRJNA939369	17402	353	1.082143	3.81996479	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	97.8	6.680000000000001e-21	NR	MBR6464573.1	2026799	g16985	i0	47.9	1.01133144475921	119	54	99.4	4	2	352	390	502	MBR6464573.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	357	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27024981	27024981	PRJNA939369_S_NODE_21642_length_330_cov_1.322957_g21225_i0	PRJNA939369	21642	330	1.322957	4.3657581	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.049	NR	MBK9989404.1	2026799	g21225	i0	41.7	0.654545454545455	72	37	61.8	4	5	208	263	333	MBK9989404.1 homocysteine S-methyltransferase family protein [Verrucomicrobiota bacterium]	diamond	216	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28067288	28067288	PRJNA939369_S_NODE_31025_length_298_cov_1.026667_g30608_i0	PRJNA939369	31025	298	1.026667	3.05946766	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	157	3.99e-42	NR	MBR6464573.1	2026799	g30608	i0	63.6	0.996644295302013	99	36	99.7	0	297	1	721	819	MBR6464573.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	297	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28919639	28919639	PRJNA939369_S_NODE_13908_length_380_cov_1.205212_g13491_i0	PRJNA939369	13908	380	1.205212	4.5798056	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	82.4	6.77e-16	NR	MBR6464572.1	2026799	g13491	i0	38.2	1.03421052631579	131	74	97.9	3	380	9	18	148	MBR6464572.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	393	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29677239	29677239	PRJNA939369_S_NODE_66850_length_245_cov_1.296512_g66433_i0	PRJNA939369	66850	245	1.296512	3.1764544	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	100	2.49e-22	NR	MBR6464573.1	2026799	g66433	i0	56.3	0.979591836734694	80	35	98	0	243	4	307	386	MBR6464573.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	240	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30151123	30151123	PRJNA939369_S_NODE_2232_length_746_cov_3.326895_g1851_i0	PRJNA939369	2232	746	3.326895	24.8186367	Akkermansia sp.	1872421	Bacteria	Bacteria	127	1.1399999999999999e-32	NR	MBR3927256.1	1872421	g1851	i0	38.2	0.715817694369973	178	110	71.6	0	205	738	1	178	MBR3927256.1 hypothetical protein [Akkermansia sp.]	diamond	534	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
30530450	30530450	PRJNA939369_S_NODE_65813_length_246_cov_0.890173_g65396_i0	PRJNA939369	65813	246	0.890173	2.18982558	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	140	1.65e-36	NR	MBR6464573.1	2026799	g65396	i0	79	0.98780487804878	81	17	98.8	0	244	2	16	96	MBR6464573.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	243	140	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);;