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

7 rows where analysis = "diamond", bioproject = "PRJEB29441" 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
8641442	8641442	PRJEB29441_P_NODE_27787_length_199_cov_1.360000_g27346_i0	PRJEB29441	27787	199	1.36	2.7064	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	72.8	1.5e-13	NR	MEY3000757.1	2026799	g27346	i0	55.6	0.949748743718593	63	28	95	0	9	197	98	160	MEY3000757.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	189	72.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27500897	27500897	PRJEB29441_P_NODE_40183_length_166_cov_0.871795_g39742_i0	PRJEB29441	40183	166	0.871795	1.4471797	root	1	Root_unresolved	Root_unresolved	73.2	2.12e-13	NR	MBP8256567.1	2006848	g39742	i0	53	14.7831325301205	66	19	97.6	2	4	165	146	211	MBP8256567.1 multicopper oxidase domain-containing protein [Opitutaceae bacterium]	diamond	2454	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27665294	27665294	PRJEB29441_P_NODE_41824_length_165_cov_0.879310_g41383_i0	PRJEB29441	41824	165	0.87931	1.4508615	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.00483	NR	MBS0625518.1	2026799	g41383	i0	52.6	0.690909090909091	38	18	69.1	0	159	46	203	240	MBS0625518.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	114	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27917584	27917584	PRJEB29441_P_NODE_31365_length_187_cov_1.260870_g30924_i0	PRJEB29441	31365	187	1.26087	2.3578269	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	79.3	1.45e-15	NR	RYD71398.1	2026800	g30924	i0	59	0.978609625668449	61	25	97.9	0	3	185	247	307	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	183	79.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30318182	30318182	PRJEB29441_P_NODE_39012_length_167_cov_0.864407_g38571_i0	PRJEB29441	39012	167	0.864407	1.44355969	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	41.6	0.035	NR	HEX5218075.1	2499141	g38571	i0	44.4	0.970059880239521	54	26	91.6	3	167	15	956	1008	HEX5218075.1 Ig-like domain-containing protein [Verrucomicrobiia bacterium]	diamond	162	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30879768	30879768	PRJEB29441_P_NODE_44834_length_163_cov_0.894737_g44393_i0	PRJEB29441	44834	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	43.9	0.00499	NR	MEI6177523.1	2026799	g44393	i0	51.4	1.93251533742331	35	17	64.4	0	58	162	273	307	MEI6177523.1 complex I subunit 1 family protein [Verrucomicrobiota bacterium]	diamond	315	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32650310	32650310	PRJEB29441_P_NODE_47440_length_161_cov_0.910714_g46999_i0	PRJEB29441	47440	161	0.910714	1.46624954	Prosthecobacter	48463	Bacteria	Bacteria	75.9	2.53e-14	NR	WP_184343614.1	48466	g46999	i0	60.4	2.94409937888199	53	21	98.8	0	160	2	37	89	WP_184343614.1 LTA synthase family protein [Prosthecobacter vanneervenii]	diamond	474	76.3	0.99475753604194	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii

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