metadata: contig_metadata: 19 rows where bioproject = "PRJNA283169", tax_clade = "PVC group" and tax

19 rows where bioproject = "PRJNA283169", tax_clade = "PVC group" 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
2922427	2922427	PRJNA283169_P_NODE_4403_length_201_cov_1.210526_g4340_i0	PRJNA283169	4403	201	1.210526	2.43315726	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	355	1.19e-93	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g4340	i0	98.507	290.338308457711	201	3	100	0	1	201	1321144	1320944	Luteolibacter sp. Populi chromosome, complete genome	blastn	58358	355	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
3609536	3609536	PRJNA283169_P_NODE_5463_length_183_cov_1.141791_g5400_i0	PRJNA283169	5463	183	1.141791	2.08947753	Methylacidiphilum (ex Ratnadevi et al. 2023)	511745	Bacteria	Bacteria	209	8.74e-50	NTclustered	gi\|189184875\|gb\|CP000975.1\|	481448	g5400	i0	87.845	112.595628415301	181	18	98	4	1	179	894475	894297	Methylacidiphilum infernorum V4, complete genome	blastn	20605	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum infernorum
6749435	6749435	PRJNA283169_P_NODE_1666_length_314_cov_1.132075_g1604_i0	PRJNA283169	1666	314	1.132075	3.5547155	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	348	3.35e-91	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1604	i0	86.901	315.433121019108	313	38	99	2	2	314	27876	28185	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	99046	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10575707	10575707	PRJNA283169_P_NODE_269_length_801_cov_4.973404_g217_i0	PRJNA283169	269	801	4.973404	39.83696604	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	898	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g217	i0	88.073	279.205992509363	763	84	95	6	2	762	4718743	4717986	Luteolibacter sp. SL250 chromosome	blastn	223644	898	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
13125622	13125622	PRJNA283169_P_NODE_5491_length_182_cov_1.563910_g5428_i0	PRJNA283169	5491	182	1.56391	2.8463162	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	335	1.3699999999999997e-87	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g5428	i0	100	274.56043956044	181	0	99	0	1	181	456786	456606	Luteolibacter sp. AS25 chromosome, complete genome	blastn	49970	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
14400807	14400807	PRJNA283169_P_NODE_7052_length_166_cov_0.880342_g6989_i0	PRJNA283169	7052	166	0.880342	1.46136772	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	219	1.3e-52	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g6989	i0	90.419	47.3493975903614	167	14	100	2	1	166	2216675	2216840	Luteolibacter sp. LG18 DNA, complete genome	blastn	7860	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
16361484	16361484	PRJNA283169_P_NODE_5773_length_178_cov_1.310078_g5710_i0	PRJNA283169	5773	178	1.310078	2.33193884	root	1	Root_unresolved	Root_unresolved	329	6.21e-86	NTclustered	gi\|1774728408\|gb\|MN684281.1\|	2736	g5710	i0	100	99.9550561797753	178	0	100	0	1	178	716	539	Verrucomicrobium spinosum strain MT_SG_E_24_27F.27F 16S ribosomal RNA gene, partial sequence	blastn	17792	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
18910419	18910419	PRJNA283169_P_NODE_2495_length_261_cov_2.066038_g2433_i0	PRJNA283169	2495	261	2.066038	5.39235918	Verrucomicrobiales	48461	Bacteria	Bacteria	200	8.029999999999999e-47	NTclustered	gi\|2240218473\|gb\|CP097283.1\|	239935	g2433	i0	82.609	264.275862068966	230	37	88	3	33	261	339980	339753	Akkermansia muciniphila strain NB2A-8-WC chromosome	blastn	68976	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
26947460	26947460	PRJNA283169_P_NODE_7402_length_165_cov_0.862069_g7339_i0	PRJNA283169	7402	165	0.862069	1.42241385	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.4	2.43e-4	NR	MBV8176842.1	2026799	g7339	i0	64.9	1.34545454545455	37	13	67.3	0	116	6	56	92	MBV8176842.1 DUF3560 domain-containing protein [Verrucomicrobiota bacterium]	diamond	222	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27579580	27579580	PRJNA283169_S_NODE_1984_length_200_cov_0.052980_g1970_i0	PRJNA283169	1984	200	0.05298	0.10596	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00107	NR	MEI6076722.1	2026799	g1970	i0	55.3	0.57	38	17	57	0	199	86	197	234	MEI6076722.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	114	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27895271	27895271	PRJNA283169_S_NODE_1145_length_251_cov_0.123762_g1131_i0	PRJNA283169	1145	251	0.123762	0.31064262	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	43.1	0.0286	NR	WP_404423401.1	3034021	g1131	i0	25.3	0.896414342629482	75	55	89.6	1	22	246	239	312	WP_404423401.1 LacI family DNA-binding transcriptional regulator [Nibricoccus sp. IMCC34717]	diamond	225	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
28148127	28148127	PRJNA283169_S_NODE_2365_length_186_cov_0.116788_g2351_i0	PRJNA283169	2365	186	0.116788	0.21722568	Limisphaerales bacterium	2052186	Bacteria	Bacteria	45.4	3.73e-4	NR	MEI9961334.1	2052186	g2351	i0	58.6	0.467741935483871	29	12	46.8	0	183	97	30	58	MEI9961334.1 hypothetical protein [Limisphaerales bacterium]	diamond	87	45.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
28179297	28179297	PRJNA283169_P_NODE_2906_length_243_cov_1.587629_g2843_i0	PRJNA283169	2906	243	1.587629	3.85793847	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	134	1.6299999999999998e-35	NR	RFC52986.1	2026799	g2843	i0	90.1	0.876543209876543	71	7	87.7	0	213	1	1	71	RFC52986.1 MAG: Outer membrane protein assembly factor BamB, contains PQQ-like beta-propeller repeat [Verrucomicrobiota bacterium]	diamond	213	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28368892	28368892	PRJNA283169_P_NODE_3046_length_237_cov_2.186170_g2983_i0	PRJNA283169	3046	237	2.18617	5.1812229	Opitutaceae bacterium	2006848	Bacteria	Bacteria	58.9	4.21e-8	NR	MBL9207032.1	2006848	g2983	i0	52.7	0.69620253164557	55	26	69.6	0	185	21	1	55	MBL9207032.1 GNAT family N-acetyltransferase [Opitutaceae bacterium]	diamond	165	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30295700	30295700	PRJNA283169_P_NODE_2112_length_282_cov_0.875536_g2050_i0	PRJNA283169	2112	282	0.875536	2.46901152	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	72.4	2.17e-12	NR	MDB6120228.1	2026800	g2050	i0	77.1	0.51063829787234	48	11	51.1	0	275	132	691	738	MDB6120228.1 glycosyl transferase group 1 [Verrucomicrobiaceae bacterium]	diamond	144	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30327397	30327397	PRJNA283169_P_NODE_4372_length_202_cov_0.980392_g4309_i0	PRJNA283169	4372	202	0.980392	1.98039184	Limisphaera sp.	2838792	Bacteria	Bacteria	80.9	8.05e-16	NR	MCS7090330.1	2838792	g4309	i0	62.7	3.98019801980198	67	24	99.5	1	2	202	65	130	MCS7090330.1 hypothetical protein [Limisphaera sp.]	diamond	804	80.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Limisphaeraceae	Limisphaera	Limisphaera sp.
31622698	31622698	PRJNA283169_S_NODE_1756_length_210_cov_0.093168_g1742_i0	PRJNA283169	1756	210	0.093168	0.1956528	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	42.4	0.00879	NR	HYZ72762.1	2201154	g1742	i0	38.9	1.02857142857143	72	38	94.3	2	1	198	27	98	HYZ72762.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	216	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32273360	32273360	PRJNA283169_P_NODE_7218_length_165_cov_0.896552_g7155_i0	PRJNA283169	7218	165	0.896552	1.4793108	Verrucomicrobiota	74201	Bacteria	Bacteria	102	3e-24	NR	MSU62835.1	2024890	g7155	i0	83.6	5	55	9	100	0	1	165	197	251	MSU62835.1 hypothetical protein [Pedosphaera sp.]	diamond	825	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
32823781	32823781	PRJNA283169_P_NODE_4300_length_203_cov_1.077922_g4237_i0	PRJNA283169	4300	203	1.077922	2.18818166	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	47.8	3.77e-4	NR	HXP82587.1	2499141	g4237	i0	39.3	0.901477832512315	61	36	90.1	1	14	196	43	102	HXP82587.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	183	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;