metadata: contig_metadata: 16 rows where bioproject = "PRJNA1132896", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJNA1132896", 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
283670	283670	PRJNA1132896_P_NODE_8141_length_247_cov_0.885057_g8050_i0	PRJNA1132896	8141	247	0.885057	2.18609079	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	71.2	3.66e-12	NR	MES2709712.1	2026799	g8050	i0	55.8	0.935222672064777	77	32	91.1	1	19	243	423	499	MES2709712.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	231	71.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
1558270	1558270	PRJNA1132896_P_NODE_9462_length_243_cov_0.905882_g9371_i0	PRJNA1132896	9462	243	0.905882	2.20129326	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g9371	i0	100	258.172839506173	234	0	96	0	10	243	5624923	5625156	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	62736	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
11762204	11762204	PRJNA1132896_P_NODE_10250_length_241_cov_0.916667_g10159_i0	PRJNA1132896	10250	241	0.916667	2.20916747	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	133	2.21e-35	NR	RFC52446.1	2026799	g10159	i0	73.8	0.995850622406639	80	20	98.3	1	238	2	261	340	RFC52446.1 MAG: Formylglycine-generating enzyme, required for sulfatase activity, contains SUMF1/FGE domain [Verrucomicrobiota bacterium]	diamond	240	133	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
23984096	23984096	PRJNA1132896_P_NODE_7119_length_250_cov_0.870056_g7028_i0	PRJNA1132896	7119	250	0.870056	2.17514	Akkermansia	239934	Bacteria	Bacteria	455	1.48e-123	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g7028	i0	99.598	98.472	249	1	99	0	2	250	1475791	1476039	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	24618	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
26849012	26849012	PRJNA1132896_P_NODE_9921_length_242_cov_0.911243_g9830_i0	PRJNA1132896	9921	242	0.911243	2.20520806	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	47.4	8.81e-4	NR	MFT5467573.1	2026801	g9830	i0	43.5	1.7603305785124	62	35	76.9	0	45	230	1027	1088	MFT5467573.1 VCBS repeat-containing protein [Verrucomicrobiales bacterium]	diamond	426	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27481113	27481113	PRJNA1132896_P_NODE_3643_length_298_cov_0.915556_g3552_i0	PRJNA1132896	3643	298	0.915556	2.72835688	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	58.2	2.67e-7	NR	MDB6036733.1	2026801	g3552	i0	29.3	3.12080536912752	75	53	75.5	0	279	55	58	132	MDB6036733.1 putative Cytochrome [Verrucomicrobiales bacterium]	diamond	930	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27954783	27954783	PRJNA1132896_P_NODE_8445_length_246_cov_0.890173_g8354_i0	PRJNA1132896	8445	246	0.890173	2.18982558	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	143	1.88e-37	NR	HEX2749854.1	2026801	g8354	i0	80.2	0.98780487804878	81	16	98.8	0	2	244	840	920	HEX2749854.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	243	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28018001	28018001	PRJNA1132896_P_NODE_6865_length_251_cov_0.865169_g6774_i0	PRJNA1132896	6865	251	0.865169	2.17157419	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	88.6	7.770000000000001e-21	NR	MEO0018394.1	2026799	g6774	i0	85.1	1.12350597609562	47	7	56.2	0	109	249	1	47	MEO0018394.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	282	88.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29154834	29154834	PRJNA1132896_P_NODE_8109_length_247_cov_0.885057_g8018_i0	PRJNA1132896	8109	247	0.885057	2.18609079	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	115	1.02e-27	NR	PYI83746.1	2026799	g8018	i0	72.5	0.97165991902834	80	21	96	1	246	10	712	791	PYI83746.1 MAG: hypothetical protein DME26_14500, partial [Verrucomicrobiota bacterium]	diamond	240	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29659331	29659331	PRJNA1132896_P_NODE_5810_length_263_cov_1.584211_g5719_i0	PRJNA1132896	5810	263	1.584211	4.16647493	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	90.5	7.43e-19	NR	MDH4475827.1	2026800	g5719	i0	63.6	0.752851711026616	66	24	75.3	0	262	65	552	617	MDH4475827.1 prenyltransferase/squalene oxidase repeat-containing protein [Verrucomicrobiaceae bacterium]	diamond	198	90.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29785951	29785951	PRJNA1132896_P_NODE_7771_length_248_cov_0.880000_g7680_i0	PRJNA1132896	7771	248	0.88	2.1824	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	146	3.54e-40	NR	RYD77701.1	2026800	g7680	i0	84.3	1.00403225806452	83	12	99.2	1	3	248	77	159	RYD77701.1 MAG: acyltransferase [Verrucomicrobiaceae bacterium]	diamond	249	146	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29849286	29849286	PRJNA1132896_P_NODE_1011_length_514_cov_1.746032_g920_i0	PRJNA1132896	1011	514	1.746032	8.97460448	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	112	5.28e-25	NR	MDH4455805.1	2026799	g920	i0	49.1	1.97859922178988	163	65	87	5	456	10	2315	2473	MDH4455805.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1017	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29944089	29944089	PRJNA1132896_P_NODE_6911_length_251_cov_0.865169_g6820_i0	PRJNA1132896	6911	251	0.865169	2.17157419	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	96.7	1.21e-22	NR	MBC8127297.1	2026801	g6820	i0	77.6	0.800796812749004	67	15	80.1	0	49	249	15	81	MBC8127297.1 preprotein translocase subunit SecG [Verrucomicrobiales bacterium]	diamond	201	96.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30133169	30133169	PRJNA1132896_P_NODE_7092_length_250_cov_0.870056_g7001_i0	PRJNA1132896	7092	250	0.870056	2.17514	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	101	6.409999999999999e-23	NR	MDF1810896.1	2026801	g7001	i0	63.9	0.996	83	22	99.6	1	1	249	24	98	MDF1810896.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	249	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31713843	31713843	PRJNA1132896_P_NODE_10197_length_241_cov_0.916667_g10106_i0	PRJNA1132896	10197	241	0.916667	2.20916747	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	60.1	4.47e-10	NR	MCL4179540.1	2026799	g10106	i0	65.3	0.609958506224066	49	17	61	0	240	94	1	49	MCL4179540.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	147	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32568338	32568338	PRJNA1132896_P_NODE_8199_length_247_cov_0.885057_g8108_i0	PRJNA1132896	8199	247	0.885057	2.18609079	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	119	9.809999999999999e-32	NR	RPJ35906.1	2026800	g8108	i0	76.8	1.97975708502024	82	19	99.6	0	246	1	106	187	RPJ35906.1 MAG: hypothetical protein EHM17_00565 [Verrucomicrobiaceae bacterium]	diamond	489	119	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);;