metadata: contig_metadata: 16 rows where bioproject = "PRJEB10320" and tax

16 rows where bioproject = "PRJEB10320" 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_species
5115883	5115883	PRJEB10320_P_NODE_15805_length_227_cov_1.744792_g15547_i0	PRJEB10320	15805	227	1.744792	3.96067784	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	67.4	4.79e-11	NR	MEC8013354.1	2026799	g15547	i0	74.4	2.90748898678414	43	11	56.8	0	93	221	16	58	MEC8013354.1 transaldolase [Verrucomicrobiota bacterium]	diamond	660	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
16590440	16590440	PRJEB10320_P_NODE_434_length_1408_cov_4.582666_g342_i0	PRJEB10320	434	1408	4.582666	64.52393728	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	290	1.63e-90	NR	RYD71398.1	2026800	g342	i0	45.1	0.756392045454545	355	182	74.4	6	107	1153	14	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	1065	290	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
26811232	26811232	PRJEB10320_P_NODE_10641_length_298_cov_1.148289_g10383_i0	PRJEB10320	10641	298	1.148289	3.42190122	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	74.3	5.93e-13	NR	MFM8364075.1	2026799	g10383	i0	44.8	1.80201342281879	87	45	86.6	2	297	40	552	636	MFM8364075.1 S8 family serine peptidase [Verrucomicrobiota bacterium]	diamond	537	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
27222159	27222159	PRJEB10320_P_NODE_24183_length_168_cov_1.203008_g23925_i0	PRJEB10320	24183	168	1.203008	2.02105344	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	83.2	4.11e-17	NR	RYD84284.1	2026800	g23925	i0	67.3	0.982142857142857	55	18	98.2	0	2	166	193	247	RYD84284.1 MAG: hypothetical protein EOP84_05935 [Verrucomicrobiaceae bacterium]	diamond	165	83.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
27317392	27317392	PRJEB10320_P_NODE_1423_length_876_cov_8.424495_g1274_i0	PRJEB10320	1423	876	8.424495	73.7985762	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	264	1.98e-84	NR	MEY4488007.1	2026799	g1274	i0	57.3	4.25	246	105	84.2	0	84	821	11	256	MEY4488007.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	3723	264	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
27601645	27601645	PRJEB10320_P_NODE_2584_length_668_cov_2.292259_g2383_i0	PRJEB10320	2584	668	2.292259	15.31229012	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	202	2.0299999999999998e-62	NR	RYD70704.1	2026800	g2383	i0	60.7	0.732035928143713	163	64	73.2	0	138	626	6	168	RYD70704.1 MAG: hypothetical protein EOP84_26230 [Verrucomicrobiaceae bacterium]	diamond	489	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
28106494	28106494	PRJEB10320_P_NODE_1465_length_866_cov_7.756919_g1274_i1	PRJEB10320	1465	866	7.756919	67.17491854	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	265	8.84e-85	NR	MEY4488007.1	2026799	g1274	i1	58.1	1.72517321016166	246	102	84.9	1	783	49	11	256	MEY4488007.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1494	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
29111020	29111020	PRJEB10320_P_NODE_18728_length_202_cov_0.958084_g18470_i0	PRJEB10320	18728	202	0.958084	1.93532968	Rariglobus	2706524	Bacteria	Bacteria	69.7	5.49e-13	NR	HRE08725.1	2006848	g18470	i0	70.7	12.1930693069307	41	12	60.9	0	125	3	75	115	HRE08725.1 class I SAM-dependent methyltransferase [Opitutaceae bacterium]	diamond	2463	70.1	0.994293865905849	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutaceae bacterium
29243331	29243331	PRJEB10320_P_NODE_12669_length_265_cov_1.560870_g12411_i0	PRJEB10320	12669	265	1.56087	4.1363055	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.7	0.00993	NR	HEX3856245.1	2499141	g12411	i0	42.3	1.3811320754717	52	24	58.9	1	54	209	314	359	HEX3856245.1 sialidase family protein [Verrucomicrobiia bacterium]	diamond	366	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia			Verrucomicrobiia bacterium
29527529	29527529	PRJEB10320_P_NODE_24570_length_166_cov_1.427481_g24312_i0	PRJEB10320	24570	166	1.427481	2.36961846	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	43.1	0.00978	NR	NJM54946.1	2499141	g24312	i0	54.3	0.632530120481928	35	16	63.3	0	157	53	30	64	NJM54946.1 DUF1552 domain-containing protein [Verrucomicrobiia bacterium]	diamond	105	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia			Verrucomicrobiia bacterium
30127229	30127229	PRJEB10320_P_NODE_1232_length_926_cov_3.070707_g1092_i0	PRJEB10320	1232	926	3.070707	28.43474682	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	283	6.81e-92	NR	MEY4488007.1	2026799	g1092	i0	61.4	1.5939524838013	246	95	79.7	0	757	20	11	256	MEY4488007.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1476	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
30727788	30727788	PRJEB10320_P_NODE_20574_length_189_cov_1.038961_g20316_i0	PRJEB10320	20574	189	1.038961	1.96363629	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	41.6	0.0459	NR	MBS0649192.1	2026799	g20316	i0	41.1	0.888888888888889	56	28	88.9	1	18	185	271	321	MBS0649192.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	168	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
31201352	31201352	PRJEB10320_P_NODE_14035_length_247_cov_1.787736_g13777_i0	PRJEB10320	14035	247	1.787736	4.41570792	Opitutaceae bacterium	2006848	Bacteria	Bacteria	127	3.96e-32	NR	MBX3750296.1	2006848	g13777	i0	81.3	3.88663967611336	80	15	97.2	0	8	247	535	614	MBX3750296.1 transketolase [Opitutaceae bacterium]	diamond	960	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutaceae bacterium
32087487	32087487	PRJEB10320_P_NODE_2478_length_680_cov_8.607752_g1274_i2	PRJEB10320	2478	680	8.607752	58.5327136	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	230	3.5199999999999995e-72	NR	HEY6205988.1	2201154	g1274	i2	58.3	3.53382352941176	206	86	90.9	0	618	1	1	206	HEY6205988.1 glucose 1-dehydrogenase [Chthoniobacterales bacterium]	diamond	2403	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales		Chthoniobacterales bacterium
32530689	32530689	PRJEB10320_P_NODE_459_length_1376_cov_13.343773_g367_i0	PRJEB10320	459	1376	13.343773	183.61031648	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	440	6.149999999999998e-150	NR	RYD65414.1	2026800	g367	i0	77	0.617005813953488	283	63	61.7	1	336	1184	56	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	849	440	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
32813965	32813965	PRJEB10320_P_NODE_5160_length_466_cov_1.552204_g4913_i0	PRJEB10320	5160	466	1.552204	7.23327064	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	252	8.700000000000001e-81	NR	RYD81270.1	2026800	g4913	i0	76.1	0.997854077253219	155	37	99.8	0	2	466	73	227	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	465	252	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae 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);;