metadata: contig_metadata: 17 rows where bioproject = "PRJNA1227535", tax_clade = "PVC group" and tax

17 rows where bioproject = "PRJNA1227535", 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
2886040	2886040	PRJNA1227535_P_NODE_11263_length_288_cov_1.451163_g11140_i0	PRJNA1227535	11263	288	1.451163	4.17934944	Luteolibacter luteus	2728835	Bacteria	Bacteria	200	8.99e-47	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g11140	i0	81.557	10.7777777777778	244	43	84	2	1	243	4046240	4046482	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	3104	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
9263453	9263453	PRJNA1227535_P_NODE_28428_length_245_cov_0.906977_g28304_i0	PRJNA1227535	28428	245	0.906977	2.22209365	Akkermansia muciniphila	239935	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g28304	i0	100	99.1265306122449	245	0	100	0	1	245	2046344	2046588	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	24286	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
19461245	19461245	PRJNA1227535_P_NODE_19156_length_261_cov_2.186170_g19032_i0	PRJNA1227535	19156	261	2.18617	5.7059037	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	140	1.4e-38	NR	HEV8419302.1	2665650	g19032	i0	97.2	0.816091954022989	71	2	81.6	0	1	213	249	319	HEV8419302.1 MupA/Atu3671 family FMN-dependent luciferase-like monooxygenase [Candidatus Udaeobacter sp.]	diamond	213	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
19461418	19461418	PRJNA1227535_P_NODE_29696_length_243_cov_1.452941_g29572_i0	PRJNA1227535	29696	243	1.452941	3.53064663	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	204	5.71e-48	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g29572	i0	84.466	95.0123456790123	206	32	85	0	2	207	1875545	1875750	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	23088	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
26629581	26629581	PRJNA1227535_P_NODE_21281_length_254_cov_2.436464_g21157_i0	PRJNA1227535	21281	254	2.436464	6.18861856	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.6	0.0018600000000000001	NR	MEK0449885.1	2026799	g21157	i0	42.2	0.755905511811024	64	36	75.6	1	193	2	14	76	MEK0449885.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	192	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26883090	26883090	PRJNA1227535_P_NODE_17161_length_268_cov_1.317949_g17038_i0	PRJNA1227535	17161	268	1.317949	3.53210332	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	189	1.3199999999999998e-55	NR	MBK9139825.1	2026799	g17038	i0	98.9	0.996268656716418	89	1	99.6	0	267	1	272	360	MBK9139825.1 PQQ-binding-like beta-propeller repeat protein [Verrucomicrobiota bacterium]	diamond	267	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27452206	27452206	PRJNA1227535_P_NODE_29743_length_243_cov_0.917647_g29619_i0	PRJNA1227535	29743	243	0.917647	2.22988221	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	63.9	4.35e-10	NR	MEO0017661.1	2026799	g29619	i0	50.7	0.851851851851852	69	21	75.3	2	61	243	40	103	MEO0017661.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	207	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28304434	28304434	PRJNA1227535_P_NODE_17406_length_267_cov_1.567010_g17283_i0	PRJNA1227535	17406	267	1.56701	4.1839167	Pedosphaera sp.	2024890	Bacteria	Bacteria	171	3.36e-50	NR	MDB6122879.1	2024890	g17283	i0	93.2	0.98876404494382	88	6	98.9	0	265	2	254	341	MDB6122879.1 Response regulator receiver sensor signal transduction histidine kinase [Pedosphaera sp.]	diamond	264	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
28620399	28620399	PRJNA1227535_P_NODE_29947_length_243_cov_0.917647_g29823_i0	PRJNA1227535	29947	243	0.917647	2.22988221	Prosthecobacter algae	1144682	Bacteria	Bacteria	130	2.05e-33	NR	WP_345738873.1	1144682	g29823	i0	74.1	2	81	21	100	0	1	243	383	463	WP_345738873.1 amidase [Prosthecobacter algae]	diamond	486	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter algae
28683537	28683537	PRJNA1227535_P_NODE_17047_length_268_cov_1.600000_g16924_i0	PRJNA1227535	17047	268	1.6	4.288	Luteolibacter sp. SL25	1962973	Bacteria	Bacteria	134	9.85e-37	NR	WP_267672868.1	2995170	g16924	i0	86.3	1.63432835820896	73	10	81.7	0	48	266	1	73	WP_267672868.1 S1 RNA-binding domain-containing protein [Luteolibacter sp. SL250]	diamond	438	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
29030905	29030905	PRJNA1227535_P_NODE_25488_length_248_cov_1.765714_g25364_i0	PRJNA1227535	25488	248	1.765714	4.37897072	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	120	1.79e-29	NR	HRJ70900.1	2832348	g25364	i0	72	2.9758064516129	82	19	99.2	1	246	1	29	106	HRJ70900.1 2-oxoglutarate dehydrogenase E1 component [Terrimicrobiaceae bacterium]	diamond	738	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
29175888	29175888	PRJNA1227535_P_NODE_18989_length_262_cov_1.476190_g18865_i0	PRJNA1227535	18989	262	1.47619	3.8676178	Roseimicrobium	1348508	Bacteria	Bacteria	147	9.19e-40	NR	OAI58152.1	1799659	g18865	i0	89.5	1.96946564885496	86	9	98.5	0	3	260	207	292	OAI58152.1 ABC transporter ATP-binding protein [Verrucomicrobiaceae bacterium SCGC AG-212-N21]	diamond	516	148	0.993243243243243	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium SCGC AG-212-N21
30104242	30104242	PRJNA1227535_P_NODE_30952_length_242_cov_0.923077_g30828_i0	PRJNA1227535	30952	242	0.923077	2.23384634	Luteolibacter marinus	2776705	Bacteria	Bacteria	55.5	1.24e-6	NR	WP_193213683.1	2776705	g30828	i0	49.4	1.00413223140496	81	40	99.2	1	241	2	56	136	WP_193213683.1 LamG-like jellyroll fold domain-containing protein [Luteolibacter marinus]	diamond	243	55.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter marinus
31052499	31052499	PRJNA1227535_P_NODE_32115_length_234_cov_2.621118_g31991_i0	PRJNA1227535	32115	234	2.621118	6.13341612	Luteolibacter sp. SL25	1962973	Bacteria	Bacteria	108	1.3399999999999999e-25	NR	WP_267672916.1	2995170	g31991	i0	85.5	0.705128205128205	55	8	70.5	0	3	167	510	564	WP_267672916.1 FMN-binding protein [Luteolibacter sp. SL250]	diamond	165	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
31083849	31083849	PRJNA1227535_P_NODE_14075_length_278_cov_1.775610_g13952_i0	PRJNA1227535	14075	278	1.77561	4.9361958	Prosthecobacter sp.	1965333	Bacteria	Bacteria	113	9.97e-27	NR	HEY1081856.1	1965333	g13952	i0	58.7	0.992805755395683	92	38	99.3	0	277	2	344	435	HEY1081856.1 PSD1 and planctomycete cytochrome C domain-containing protein [Prosthecobacter sp.]	diamond	276	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31241689	31241689	PRJNA1227535_P_NODE_7795_length_312_cov_2.585774_g7672_i0	PRJNA1227535	7795	312	2.585774	8.06761488	Prosthecobacter sp.	1965333	Bacteria	Bacteria	155	2.09e-41	NR	HEY1053391.1	1965333	g7672	i0	56.8	1.33653846153846	139	25	100	1	312	1	131	269	HEY1053391.1 FtsX-like permease family protein [Prosthecobacter sp.]	diamond	417	155	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32209652	32209652	PRJNA1227535_P_NODE_21138_length_255_cov_1.587912_g21014_i0	PRJNA1227535	21138	255	1.587912	4.0491756	Pseudomonadati	3379134	Bacteria	Bacteria	87.8	5.52e-18	NR	MBS0648367.1	2026799	g21014	i0	49.4	3.94117647058824	85	43	100	0	255	1	168	252	MBS0648367.1 leucyl aminopeptidase [Verrucomicrobiota bacterium]	diamond	1005	88.6	0.99097065462754	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);;