metadata: contig_metadata: 24 rows where bioproject = "PRJNA631796" and tax

24 rows where bioproject = "PRJNA631796" 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
603364	603364	PRJNA631796_P_NODE_6841_length_261_cov_1.475000_g6563_i0	PRJNA631796	6841	261	1.475	3.84975	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	405	1.59e-108	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g6563	i0	94.636	181.272030651341	261	14	100	0	1	261	5637139	5636879	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	47312	405	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
1152013	1152013	PRJNA631796_P_NODE_2381_length_460_cov_2.192982_g2105_i0	PRJNA631796	2381	460	2.192982	10.0877172	Verrucomicrobiota	74201	Bacteria	Bacteria	470	1.04e-127	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g2105	i0	85.435	108.773913043478	460	57	98	9	1	453	85	541	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	50036	472	0.995762711864407	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
3154310	3154310	PRJNA631796_S_NODE_12643_length_285_cov_1.915179_g12476_i0	PRJNA631796	12643	285	1.915179	5.45826015	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	255	1.87e-63	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g12476	i0	83.045	191.056140350877	289	41	100	8	1	285	2750277	2749993	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	54451	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4431078	4431078	PRJNA631796_P_NODE_11824_length_206_cov_0.882759_g11546_i0	PRJNA631796	11824	206	0.882759	1.81848354	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	135	1.74e-27	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g11546	i0	79.147	39.6990291262136	211	33	99	10	2	206	2749669	2749464	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	8178	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4431164	4431164	PRJNA631796_S_NODE_20244_length_266_cov_2.317073_g20077_i0	PRJNA631796	20244	266	2.317073	6.16341418	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	219	2.27e-52	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g20077	i0	82.836	296.263157894737	268	22	93	16	1	247	631173	631437	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	78806	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
6255678	6255678	PRJNA631796_P_NODE_12745_length_202_cov_2.099291_g12467_i0	PRJNA631796	12745	202	2.099291	4.24056782	Opitutaceae	134623	Bacteria	Bacteria	324	3.38e-84	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g12467	i0	95.545	134.386138613861	202	9	100	0	1	202	2558381	2558180	Lacunisphaera limnophila strain IG16b, complete genome	blastn	27146	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
6255698	6255698	PRJNA631796_P_NODE_4905_length_312_cov_4.525896_g4627_i0	PRJNA631796	4905	312	4.525896	14.12079552	Opitutaceae	134623	Bacteria	Bacteria	532	8.549999999999998e-147	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g4627	i0	97.436	105.458333333333	312	8	100	0	1	312	848	1159	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	32903	532	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
6255700	6255700	PRJNA631796_P_NODE_5385_length_297_cov_1.627119_g5107_i0	PRJNA631796	5385	297	1.627119	4.83254343	Prosthecobacter	48463	Bacteria	Bacteria	460	3.87e-125	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g5107	i0	94.613	62.6296296296296	297	16	100	0	1	297	1513	1217	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	18601	464	0.991379310344828	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
8256582	8256582	PRJNA631796_P_NODE_8047_length_239_cov_2.775281_g7769_i0	PRJNA631796	8047	239	2.775281	6.63292159	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	403	5.15e-108	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g7769	i0	97.071	234.401673640167	239	7	100	0	1	239	3921009	3921247	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	56022	403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10080501	10080501	PRJNA631796_P_NODE_8428_length_235_cov_0.936782_g8150_i0	PRJNA631796	8428	235	0.936782	2.2014377	Actomonas	3138693	Bacteria	Bacteria	270	5.3399999999999985e-68	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g8150	i0	89.623	24.5957446808511	212	22	90	0	12	223	2149892	2149681	Opitutaceae bacterium TAV5, complete genome	blastn	5780	272	0.992647058823529	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
14632355	14632355	PRJNA631796_P_NODE_8572_length_233_cov_1.337209_g8294_i0	PRJNA631796	8572	233	1.337209	3.11569697	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	392	1.08e-104	NTclustered	gi\|105990409\|gb\|DQ514140.1\|	156588	g8294	i0	96.996	100.017167381974	233	7	100	0	1	233	176	408	Uncultured Verrucomicrobia bacterium clone 500M1_D10 16S ribosomal RNA gene, partial sequence	blastn	23304	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
14632366	14632366	PRJNA631796_P_NODE_9512_length_223_cov_1.111111_g9234_i0	PRJNA631796	9512	223	1.111111	2.47777753	Luteolibacter luteus	2728835	Bacteria	Bacteria	300	6.4e-77	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g9234	i0	91.743	130.686098654709	218	14	97	3	8	223	3803747	3803532	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	29143	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
15906189	15906189	PRJNA631796_P_NODE_10973_length_209_cov_1.297297_g10695_i0	PRJNA631796	10973	209	1.297297	2.71135073	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	292	9.92e-75	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g10695	i0	91.866	180.296650717703	209	17	100	0	1	209	3048786	3048578	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	37682	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
15906236	15906236	PRJNA631796_P_NODE_5213_length_302_cov_2.012448_g4935_i0	PRJNA631796	5213	302	2.012448	6.07759296	Prosthecobacter debontii	48467	Bacteria	Bacteria	538	1.7699999999999994e-148	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g4935	i0	98.684	130.069536423841	304	2	100	2	1	302	2665	2968	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	39281	538	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
15906266	15906266	PRJNA631796_P_NODE_9853_length_219_cov_2.202532_g9575_i0	PRJNA631796	9853	219	2.202532	4.82354508	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	204	5.0599999999999997e-48	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g9575	i0	83.71	290.835616438356	221	31	100	5	1	219	2748825	2749042	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	63693	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17181450	17181450	PRJNA631796_S_NODE_66354_length_219_cov_1.563291_g66187_i0	PRJNA631796	66354	219	1.563291	3.42360729	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	195	3.04e-45	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g66187	i0	83.732	152.657534246575	209	30	95	4	1	207	913712	913506	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	33432	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18455480	18455480	PRJNA631796_P_NODE_6335_length_272_cov_2.331754_g6057_i0	PRJNA631796	6335	272	2.331754	6.34237088	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	464	2.7099999999999998e-126	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g6057	i0	98.485	44.9264705882353	264	3	97	1	1	264	2558651	2558389	Lacunisphaera limnophila strain IG16b, complete genome	blastn	12220	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
19003462	19003462	PRJNA631796_P_NODE_2175_length_484_cov_1.267139_g1899_i0	PRJNA631796	2175	484	1.267139	6.13295276	Prosthecobacter	48463	Bacteria	Bacteria	717	0	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g1899	i0	93.388	166.107438016529	484	32	100	0	1	484	1284	1767	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	80396	717	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
22280471	22280471	PRJNA631796_P_NODE_13938_length_189_cov_2.835938_g13660_i0	PRJNA631796	13938	189	2.835938	5.35992282	Fontisphaera persica	2974023	Bacteria	Bacteria	200	5.47e-47	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g13660	i0	85.641	20.8730158730159	195	22	100	4	1	189	3862149	3862343	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	3945	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
22829493	22829493	PRJNA631796_P_NODE_8978_length_228_cov_3.934132_g8700_i0	PRJNA631796	8978	228	3.934132	8.96982096	Prosthecobacter	48463	Bacteria	Bacteria	363	8.269999999999999e-96	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g8700	i0	95.575	261.565789473684	226	10	99	0	1	226	1036	1261	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	59637	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
23555990	23555990	PRJNA631796_P_NODE_8639_length_232_cov_2.046784_g8361_i0	PRJNA631796	8639	232	2.046784	4.74853888	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	215	2.5e-51	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g8361	i0	83.691	48.3491379310345	233	32	99	6	2	231	3989893	3989664	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	11217	215	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
24829720	24829720	PRJNA631796_S_NODE_30100_length_251_cov_2.810526_g29933_i0	PRJNA631796	30100	251	2.810526	7.05442026	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	267	7.459999999999999e-67	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g29933	i0	88.584	253.199203187251	219	25	87	0	33	251	26476	26258	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	63553	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
28375700	28375700	PRJNA631796_S_NODE_41086_length_239_cov_1.533708_g40919_i0	PRJNA631796	41086	239	1.533708	3.66556212	Opitutaceae bacterium	2006848	Bacteria	Bacteria	42.7	0.0346	NR	MFO1449013.1	2006848	g40919	i0	30.1	0.916317991631799	73	40	82.8	2	219	22	32	100	MFO1449013.1 SWIM zinc finger family protein [Opitutaceae bacterium]	diamond	219	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30744454	30744454	PRJNA631796_P_NODE_12014_length_205_cov_0.888889_g11736_i0	PRJNA631796	12014	205	0.888889	1.82222245	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42	0.043	NR	MCX6908558.1	2026799	g11736	i0	52.8	0.526829268292683	36	15	49.8	1	10	111	73	108	MCX6908558.1 DUF4838 domain-containing protein [Verrucomicrobiota bacterium]	diamond	108	42	1	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);;