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

16 rows where bioproject = "PRJNA942359", 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
923111	923111	PRJNA942359_P_NODE_7261_length_317_cov_1.729508_g7146_i0	PRJNA942359	7261	317	1.729508	5.48254036	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	322	2.05e-83	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g7146	i0	87.589	278.81072555205	282	29	88	6	5	284	1634431	1634708	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	88383	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
2198294	2198294	PRJNA942359_P_NODE_17482_length_246_cov_0.901734_g17367_i0	PRJNA942359	17482	246	0.901734	2.21826564	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	200	7.5e-47	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g17367	i0	81.377	76.0040650406504	247	44	100	2	1	246	3139204	3138959	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	18697	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
2198438	2198438	PRJNA942359_P_NODE_5882_length_346_cov_0.934066_g5767_i0	PRJNA942359	5882	346	0.934066	3.23186836	uncultured Verrucomicrobiales bacterium	100234	Bacteria	Bacteria	579	1.2199999999999999e-160	NTclustered	gi\|220682226\|gb\|FJ542833.1\|	100234	g5767	i0	97.093	97.0924855491329	344	9	99	1	4	346	1	344	Uncultured Verrucomicrobiales bacterium clone A03-04A 16S ribosomal RNA gene, partial sequence	blastn	33594	579	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium
2198485	2198485	PRJNA942359_P_NODE_8442_length_298_cov_2.248889_g8327_i0	PRJNA942359	8442	298	2.248889	6.70168922	Chthoniobacter flavus	191863	Bacteria	Bacteria	457	5.02e-124	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g8327	i0	94.295	263.694630872483	298	17	100	0	1	298	2220	1923	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	78581	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
3473967	3473967	PRJNA942359_P_NODE_9663_length_284_cov_1.464455_g9548_i0	PRJNA942359	9663	284	1.464455	4.1590522	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	414	2.8999999999999993e-111	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g9548	i0	93.286	102.961267605634	283	16	99	2	3	284	2365614	2365334	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	29241	414	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4751371	4751371	PRJNA942359_P_NODE_18444_length_245_cov_0.906977_g18329_i0	PRJNA942359	18444	245	0.906977	2.22209365	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	79	6.88e-15	NR	HYJ06632.1	2201154	g18329	i0	94.7	0.46530612244898	38	2	46.5	0	245	132	908	945	HYJ06632.1 zinc-dependent metalloprotease family protein [Chthoniobacterales bacterium]	diamond	114	79	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
6026320	6026320	PRJNA942359_P_NODE_8705_length_294_cov_1.411765_g8590_i0	PRJNA942359	8705	294	1.411765	4.1505891	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	230	1.1699999999999995e-55	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g8590	i0	80.952	138.139455782313	294	52	100	2	1	294	276718	276429	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	40613	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
9850849	9850849	PRJNA942359_P_NODE_11008_length_270_cov_1.741117_g10893_i0	PRJNA942359	11008	270	1.741117	4.7010159	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	313	1.03e-80	NTclustered	gi\|1966854496\|gb\|CP068475.1\|	1903058	g10893	i0	87.591	117.974074074074	274	28	99	6	1	269	914980	915252	MAG: Candidatus Xiphinematobacter sp. isolate P21 chromosome, complete genome	blastn	31853	313	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
14950990	14950990	PRJNA942359_P_NODE_2172_length_530_cov_4.426696_g2058_i0	PRJNA942359	2172	530	4.426696	23.4614888	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	723	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g2058	i0	91.635	231.905660377358	526	38	99	5	1	523	15386	15908	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	122910	723	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18774798	18774798	PRJNA942359_P_NODE_2275_length_519_cov_2.609865_g2161_i0	PRJNA942359	2275	519	2.609865	13.54519935	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	536	1.15e-147	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g2161	i0	85.413	168.329479768786	521	70	99	6	2	519	2749400	2749917	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	87363	536	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20049444	20049444	PRJNA942359_P_NODE_10396_length_277_cov_1.147059_g10281_i0	PRJNA942359	10396	277	1.147059	3.17735343	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	462	9.929999999999999e-126	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g10281	i0	96.751	142.812274368231	277	9	100	0	1	277	2748362	2748638	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	39559	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21661112	21661112	PRJNA942359_P_NODE_6957_length_323_cov_1.560000_g6842_i0	PRJNA942359	6957	323	1.56	5.0388	Akkermansia	239934	Bacteria	Bacteria	307	5.860000000000001e-79	NTclustered	gi\|2051350654\|gb\|CP072036.1\|	2927224	g6842	i0	84.146	301.120743034056	328	41	100	11	1	323	334721	335042	Akkermansia massiliensis strain Akk1573 chromosome, complete genome	blastn	97262	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia massiliensis
22600103	22600103	PRJNA942359_P_NODE_398_length_1144_cov_2.156863_g336_i0	PRJNA942359	398	1144	2.156863	24.67451272	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1110	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g336	i0	84.582	249.917832167832	1148	146	99	22	2	1144	1346	2467	Luteolibacter sp. SL250 chromosome	blastn	285906	1110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
28926855	28926855	PRJNA942359_P_NODE_18228_length_245_cov_0.906977_g18113_i0	PRJNA942359	18228	245	0.906977	2.22209365	Verrucomicrobiota	74201	Bacteria	Bacteria	131	1.68e-33	NR	MEA3186286.1	2510640	g18113	i0	83.8	6.86938775510204	80	10	98	2	240	1	487	563	MEA3186286.1 formate dehydrogenase beta subunit [Chthoniobacter sp.]	diamond	1683	131	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
29519909	29519909	PRJNA942359_P_NODE_18170_length_245_cov_0.906977_g18055_i0	PRJNA942359	18170	245	0.906977	2.22209365	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	115	7.15e-28	NR	MEW6304817.1	2026799	g18055	i0	72.8	1.97142857142857	81	18	99.2	2	245	3	117	193	MEW6304817.1 DUF2514 family protein [Verrucomicrobiota bacterium]	diamond	483	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31486000	31486000	PRJNA942359_P_NODE_19236_length_243_cov_0.917647_g19121_i0	PRJNA942359	19236	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	81.3	8.81e-16	NR	MSU68344.1	2006848	g19121	i0	88.4	4.39506172839506	43	5	53.1	0	131	3	1	43	MSU68344.1 sugar porter family MFS transporter [Opitutaceae bacterium]	diamond	1068	81.6	0.996323529411765	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;