metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA753704" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA753704" 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
19858131	19858131	PRJNA753704_P_NODE_26496_length_246_cov_0.901734_g26135_i0	PRJNA753704	26496	246	0.901734	2.21826564	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	89.7	6.61e-19	NR	MCC5845818.1	2026799	g26135	i0	50.6	4.9390243902439	81	40	98.8	0	244	2	205	285	MCC5845818.1 nucleoside monophosphate kinase [Verrucomicrobiota bacterium]	diamond	1215	89.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27558228	27558228	PRJNA753704_P_NODE_23244_length_254_cov_1.022099_g22883_i0	PRJNA753704	23244	254	1.022099	2.59613146	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	95.9	1.7199999999999995e-23	NR	RYD73501.1	2026800	g22883	i0	76.7	0.708661417322835	60	14	70.9	0	74	253	3	62	RYD73501.1 MAG: fructose-bisphosphate aldolase class I [Verrucomicrobiaceae bacterium]	diamond	180	95.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28474152	28474152	PRJNA753704_P_NODE_19986_length_272_cov_1.251256_g19625_i0	PRJNA753704	19986	272	1.251256	3.40341632	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	137	3.9899999999999996e-38	NR	MDA0751323.1	2026799	g19625	i0	76.7	6.04411764705882	90	21	99.3	0	270	1	27	116	MDA0751323.1 type II secretion system protein [Verrucomicrobiota bacterium]	diamond	1644	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28799436	28799436	PRJNA753704_P_NODE_18947_length_278_cov_3.565854_g18586_i0	PRJNA753704	18947	278	3.565854	9.91307412	Pseudomonadati	3379134	Bacteria	Bacteria	97.4	3.4e-21	NR	HSH40226.1	2201154	g18586	i0	53.9	6.65827338129496	89	41	96	0	268	2	43	131	HSH40226.1 M3 family metallopeptidase [Chthoniobacterales bacterium]	diamond	1851	97.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29326484	29326484	PRJNA753704_P_NODE_27289_length_244_cov_1.713450_g26928_i0	PRJNA753704	27289	244	1.71345	4.180818	Roseibacillus sp.	2024856	Bacteria	Bacteria	68.2	3.89e-11	NR	MDE0596873.1	2024856	g26928	i0	60.5	0.528688524590164	43	17	52.9	0	116	244	344	386	MDE0596873.1 caspase family protein [Roseibacillus sp.]	diamond	129	68.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus sp.
29368080	29368080	PRJNA753704_P_NODE_11889_length_344_cov_2.579336_g11528_i0	PRJNA753704	11889	344	2.579336	8.87291584	Pseudomonadati	3379134	Bacteria	Bacteria	103	7.65e-23	NR	MBK8476319.1	2006848	g11528	i0	47	2.51162790697674	100	48	87.2	1	45	344	234	328	MBK8476319.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Opitutaceae bacterium]	diamond	864	103	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29389879	29389879	PRJNA753704_P_NODE_25409_length_248_cov_3.525714_g25048_i0	PRJNA753704	25409	248	3.525714	8.74377072	Limisphaerales bacterium	2052186	Bacteria	Bacteria	65.5	3.54e-10	NR	MFN0069025.1	2052186	g25048	i0	49.3	0.834677419354839	69	35	83.5	0	2	208	88	156	MFN0069025.1 hypothetical protein [Limisphaerales bacterium]	diamond	207	65.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
29547422	29547422	PRJNA753704_P_NODE_19770_length_273_cov_2.100000_g19409_i0	PRJNA753704	19770	273	2.1	5.733	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	123	1.6100000000000002e-33	NR	MCX6964697.1	2026799	g19409	i0	67	1.95604395604396	88	29	96.7	0	6	269	1	88	MCX6964697.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	534	123	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29578914	29578914	PRJNA753704_P_NODE_10430_length_366_cov_1.006826_g10069_i0	PRJNA753704	10430	366	1.006826	3.68498316	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	184	1.01e-53	NR	RYD84285.1	2026800	g10069	i0	74.8	0.942622950819672	115	29	94.3	0	18	362	19	133	RYD84285.1 MAG: DEAD/DEAH box helicase [Verrucomicrobiaceae bacterium]	diamond	345	184	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29578929	29578929	PRJNA753704_P_NODE_4610_length_527_cov_2.944934_g4251_i0	PRJNA753704	4610	527	2.944934	15.51980218	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	272	1.4599999999999998e-88	NR	RYD65414.1	2026800	g4251	i0	75.7	0.984819734345351	173	40	98.5	1	521	3	165	335	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	519	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30084373	30084373	PRJNA753704_P_NODE_31092_length_205_cov_20.015152_g30731_i0	PRJNA753704	31092	205	20.015152	41.0310616	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	60.5	9.44e-9	NR	AOS45585.1	1838286	g30731	i0	55	0.878048780487805	60	26	87.8	1	23	202	89	147	AOS45585.1 hypothetical protein Verru16b_02668 [Lacunisphaera limnophila]	diamond	180	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
30274347	30274347	PRJNA753704_P_NODE_27012_length_245_cov_0.906977_g26651_i0	PRJNA753704	27012	245	0.906977	2.22209365	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	72.4	1.35e-12	NR	MBN9692091.1	2026799	g26651	i0	50	0.930612244897959	76	38	93.1	0	1	228	486	561	MBN9692091.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	228	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30526768	30526768	PRJNA753704_P_NODE_21933_length_261_cov_1.244681_g21572_i0	PRJNA753704	21933	261	1.244681	3.24861741	Prosthecobacter sp.	1965333	Bacteria	Bacteria	96.3	5.31e-22	NR	HEY1050242.1	1965333	g21572	i0	67.1	0.873563218390805	76	25	87.4	0	256	29	65	140	HEY1050242.1 EamA family transporter [Prosthecobacter sp.]	diamond	228	96.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31064196	31064196	PRJNA753704_P_NODE_25815_length_248_cov_0.891429_g25454_i0	PRJNA753704	25815	248	0.891429	2.21074392	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	136	3.86e-35	NR	MBL9172816.1	2026801	g25454	i0	100	0.858870967741935	71	0	85.9	0	247	35	181	251	MBL9172816.1 efflux RND transporter permease subunit [Verrucomicrobiales bacterium]	diamond	213	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31633066	31633066	PRJNA753704_P_NODE_12136_length_341_cov_1.138060_g11775_i0	PRJNA753704	12136	341	1.13806	3.8807846	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	120	8.62e-29	NR	MBS0645922.1	2026799	g11775	i0	52.7	1.93548387096774	110	52	96.8	0	337	8	756	865	MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	660	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31980974	31980974	PRJNA753704_P_NODE_24718_length_250_cov_0.881356_g24357_i0	PRJNA753704	24718	250	0.881356	2.20339	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	98.6	3.79e-22	NR	MBX3731859.1	2499141	g24357	i0	65.7	1.692	70	24	84	0	249	40	153	222	MBX3731859.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	423	98.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32424104	32424104	PRJNA753704_P_NODE_9239_length_385_cov_3.509615_g8878_i0	PRJNA753704	9239	385	3.509615	13.51201775	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.7	0.0388	NR	MDR3459128.1	2499141	g8878	i0	27.5	1.07532467532468	138	80	91.9	4	10	363	358	495	MDR3459128.1 filamentous hemagglutinin N-terminal domain-containing protein [Verrucomicrobiia bacterium]	diamond	414	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32455938	32455938	PRJNA753704_P_NODE_12479_length_336_cov_3.448669_g12118_i0	PRJNA753704	12479	336	3.448669	11.58752784	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	115	1.81e-29	NR	MEW6307245.1	2026799	g12118	i0	64	2.29464285714286	89	32	79.5	0	3	269	106	194	MEW6307245.1 TetR/AcrR family transcriptional regulator [Verrucomicrobiota bacterium]	diamond	771	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32487545	32487545	PRJNA753704_P_NODE_23919_length_252_cov_0.871508_g23558_i0	PRJNA753704	23919	252	0.871508	2.19620016	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	123	1.63e-30	NR	MBS0645922.1	2026799	g23558	i0	65.5	2	84	29	100	0	252	1	637	720	MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	504	123	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);;