metadata: contig_metadata: 20 rows where bioproject = "PRJNA751877" and tax

20 rows where bioproject = "PRJNA751877" 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
9655141	9655141	PRJNA751877_P_NODE_9788_length_350_cov_1.111913_g9666_i0	PRJNA751877	9788	350	1.111913	3.8916955	Limisphaera ngatamarikiensis	1324935	Bacteria	Bacteria	57	1.3e-6	NR	WP_165107131.1	1324935	g9666	i0	38.6	0.711428571428571	83	51	71.1	0	22	270	535	617	WP_165107131.1 tetratricopeptide repeat protein [Limisphaera ngatamarikiensis]	diamond	249	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Limisphaeraceae	Limisphaera	Limisphaera ngatamarikiensis
12205885	12205885	PRJNA751877_P_NODE_25650_length_247_cov_0.885057_g25528_i0	PRJNA751877	25650	247	0.885057	2.18609079	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	150	7.7e-32	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g25528	i0	94.792	40.6153846153846	96	5	39	0	127	222	751037	750942	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	10032	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
12679944	12679944	PRJNA751877_P_NODE_27650_length_244_cov_0.900585_g27528_i0	PRJNA751877	27650	244	0.900585	2.1974274	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	151	1.8799999999999993e-40	NR	WP_170266723.1	748831	g27528	i0	93.8	0.983606557377049	80	5	98.4	0	242	3	96	175	WP_170266723.1 phosphoenolpyruvate carboxylase [Brevifollis gellanilyticus]	diamond	240	151	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
17304496	17304496	PRJNA751877_P_NODE_24874_length_248_cov_0.880000_g24752_i0	PRJNA751877	24874	248	0.88	2.1824	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	89	1.41e-18	NR	WP_146852628.1	748831	g24752	i0	91.7	0.580645161290323	48	4	58.1	0	104	247	1	48	WP_146852628.1 thymidine phosphorylase [Brevifollis gellanilyticus]	diamond	144	89	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
19051813	19051813	PRJNA751877_P_NODE_155_length_1627_cov_3.868726_g97_i0	PRJNA751877	155	1627	3.868726	62.94417202	Chthoniobacter sp.	2510640	Bacteria	Bacteria	844	3.38e-305	NR	MDR3405335.1	2510640	g97	i0	88.6	0.855562384757222	464	53	85.6	0	36	1427	1	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	1392	844	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
26863283	26863283	PRJNA751877_P_NODE_25561_length_247_cov_0.885057_g25439_i0	PRJNA751877	25561	247	0.885057	2.18609079	Roseimicrobium sp.	3069589	Bacteria	Bacteria	103	1.16e-23	NR	HSH93947.1	3069589	g25439	i0	62.8	0.947368421052632	78	29	94.7	0	246	13	133	210	HSH93947.1 hypothetical protein [Roseimicrobium sp.]	diamond	234	103	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp.
26926216	26926216	PRJNA751877_P_NODE_24382_length_249_cov_0.875000_g24260_i0	PRJNA751877	24382	249	0.875	2.17875	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	152	1.2e-40	NR	WP_170267079.1	748831	g24260	i0	92.8	1.98795180722892	83	6	100	0	1	249	1536	1618	WP_170267079.1 lamin tail domain-containing protein [Brevifollis gellanilyticus]	diamond	495	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
27495211	27495211	PRJNA751877_P_NODE_25543_length_247_cov_0.885057_g25421_i0	PRJNA751877	25543	247	0.885057	2.18609079	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	162	1.0499999999999999e-47	NR	WP_146849155.1	748831	g25421	i0	96.3	0.983805668016194	81	3	98.4	0	245	3	159	239	WP_146849155.1 ABC transporter ATP-binding protein [Brevifollis gellanilyticus]	diamond	243	162	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
27558105	27558105	PRJNA751877_P_NODE_29324_length_242_cov_0.911243_g29202_i0	PRJNA751877	29324	242	0.911243	2.20520806	Prosthecobacter sp.	1965333	Bacteria	Bacteria	92	2.61e-20	NR	WP_397382604.1	1965333	g29202	i0	94.9	0.483471074380165	39	2	48.3	0	242	126	249	287	WP_397382604.1 sugar phosphate isomerase/epimerase family protein [Prosthecobacter sp.]	diamond	117	92	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
28221194	28221194	PRJNA751877_P_NODE_23046_length_250_cov_0.870056_g22924_i0	PRJNA751877	23046	250	0.870056	2.17514	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	120	2.13e-30	NR	WP_198141320.1	2736	g22924	i0	63.5	4.02	85	29	99.6	1	1	249	99	183	WP_198141320.1 polysaccharide pyruvyl transferase family protein [Verrucomicrobium spinosum]	diamond	1005	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
28862656	28862656	PRJNA751877_P_NODE_20628_length_261_cov_1.611702_g20506_i0	PRJNA751877	20628	261	1.611702	4.20654222	Bacteria	2	Bacteria	Bacteria	66.6	1.82e-10	NR	HEY1793481.1	2006848	g20506	i0	97	9.62068965517241	33	1	37.9	0	99	1	1	33	HEY1793481.1 GMC family oxidoreductase [Opitutaceae bacterium]	diamond	2511	66.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29083915	29083915	PRJNA751877_P_NODE_19708_length_267_cov_1.335052_g19586_i0	PRJNA751877	19708	267	1.335052	3.56458884	Pseudomonadati	3379134	Bacteria	Bacteria	82.8	4.29e-16	NR	HXC34131.1	2499141	g19586	i0	48.8	2.8876404494382	84	41	94.4	2	267	16	503	584	HXC34131.1 SDR family NAD(P)-dependent oxidoreductase [Verrucomicrobiia bacterium]	diamond	771	83.6	0.990430622009569	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29799966	29799966	PRJNA751877_P_NODE_14191_length_305_cov_2.000000_g14069_i0	PRJNA751877	14191	305	2	6.1	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	60.1	2.74e-8	NR	HEX3818319.1	2201154	g14069	i0	36	1.85901639344262	100	56	96.4	4	3	296	125	218	HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	567	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29957943	29957943	PRJNA751877_P_NODE_11911_length_327_cov_1.212598_g11789_i0	PRJNA751877	11911	327	1.212598	3.96519546	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	64.3	2.51e-9	NR	MDA7675033.1	2562705	g11789	i0	34.8	4.55045871559633	89	58	81.7	0	325	59	150	238	MDA7675033.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	1488	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
30306019	30306019	PRJNA751877_P_NODE_24932_length_248_cov_0.880000_g24810_i0	PRJNA751877	24932	248	0.88	2.1824	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	110	9.24e-29	NR	MCB1212107.1	2026801	g24810	i0	71.8	1.63306451612903	71	20	85.9	0	213	1	1	71	MCB1212107.1 sulfatase-like hydrolase/transferase [Verrucomicrobiales bacterium]	diamond	405	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30747913	30747913	PRJNA751877_P_NODE_23734_length_249_cov_1.539773_g23612_i0	PRJNA751877	23734	249	1.539773	3.83403477	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	154	1.1499999999999999e-42	NR	MCX6853541.1	2026799	g23612	i0	94	3.95180722891566	83	5	100	0	1	249	222	304	MCX6853541.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	984	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30906004	30906004	PRJNA751877_P_NODE_23834_length_249_cov_0.875000_g23712_i0	PRJNA751877	23834	249	0.875	2.17875	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.4	7.62e-5	NR	MFM2143340.1	2026799	g23712	i0	63.4	1.36144578313253	41	14	49.4	1	126	248	135	174	MFM2143340.1 aspartate--tRNA ligase [Verrucomicrobiota bacterium]	diamond	339	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31727797	31727797	PRJNA751877_P_NODE_29977_length_241_cov_0.916667_g29855_i0	PRJNA751877	29977	241	0.916667	2.20916747	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	157	2.57e-44	NR	WP_146851029.1	748831	g29855	i0	92.4	0.983402489626556	79	6	98.3	0	239	3	244	322	WP_146851029.1 hypothetical protein [Brevifollis gellanilyticus]	diamond	237	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
32171067	32171067	PRJNA751877_P_NODE_23998_length_249_cov_0.875000_g23876_i0	PRJNA751877	23998	249	0.875	2.17875	Brevifollis gellanilyticus	748831	Bacteria	Bacteria	164	2.29e-46	NR	WP_146855482.1	748831	g23876	i0	95.1	3.95180722891566	82	4	98.8	0	2	247	294	375	WP_146855482.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Brevifollis gellanilyticus]	diamond	984	164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
32202503	32202503	PRJNA751877_P_NODE_16878_length_285_cov_1.089623_g16756_i0	PRJNA751877	16878	285	1.089623	3.10542555	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	101	1.7000000000000002e-22	NR	MBL9116487.1	2026800	g16756	i0	55.9	0.978947368421053	93	37	96.8	2	9	284	324	413	MBL9116487.1 DUF11 domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	279	101	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);;