metadata: contig_metadata: 18 rows where bioproject = "PRJNA451191" and tax

18 rows where bioproject = "PRJNA451191" and tax_clade = "PVC group"

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
1714839	1714839	PRJNA451191_P_NODE_18602_length_334_cov_2.622711_g18331_i0	PRJNA451191	18602	334	2.622711	8.75985474	Kolteria novifilia	2527975	Bacteria	Bacteria	291	6.129999999999998e-74	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g18331	i0	86.567	78.4221556886228	268	30	79	4	72	334	1830709	1830443	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	26193	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
7470597	7470597	PRJNA451191_P_NODE_18406_length_336_cov_4.825455_g18135_i0	PRJNA451191	18406	336	4.825455	16.2135288	Simkaniaceae	92712	Bacteria	Bacteria	499	9.42e-137	NTclustered	gi\|1214145827\|gb\|KY427067.1\|	504270	g18135	i0	93.548	104.125	341	12	100	9	1	336	3421	3756	Candidatus Syngnamydia salmonis isolate H03/14Pp 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer 23S ribosomal RNA and 5S ribosomal RNA genes, complete sequence	blastn	34986	499	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia salmonis
7470641	7470641	PRJNA451191_P_NODE_28046_length_268_cov_2.502415_g27775_i0	PRJNA451191	28046	268	2.502415	6.7064722	Candidatus Syngnamydia	1803801	Bacteria	Bacteria	451	2.07e-122	NTclustered	gi\|2041293252\|gb\|CP073763.1\|	2698248	g27775	i0	97.015	137.977611940299	268	8	100	0	1	268	6629	6362	MAG: Simkaniaceae bacterium isolate M30B1 chromosome, complete genome	blastn	36978	451	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
8092890	8092890	PRJNA451191_P_NODE_12187_length_426_cov_1.224658_g11916_i0	PRJNA451191	12187	426	1.224658	5.21704308	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	676	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g11916	i0	95.508	69.1807511737089	423	19	99	0	4	426	3558061	3557639	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	29471	676	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
9369006	9369006	PRJNA451191_P_NODE_55868_length_198_cov_2.598540_g55597_i0	PRJNA451191	55868	198	2.59854	5.1451092	Rosistilla carotiformis	2528017	Bacteria	Bacteria	172	1.26e-38	NTclustered	gi\|1712756907\|gb\|CP036348.1\|	2528017	g55597	i0	85.89	69.2777777777778	163	21	82	2	1	162	1459841	1460002	Rosistilla carotiformis strain Poly24 chromosome	blastn	13717	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla carotiformis
11295810	11295810	PRJNA451191_P_NODE_35289_length_239_cov_3.022472_g35018_i0	PRJNA451191	35289	239	3.022472	7.22370808	Simkaniaceae	92712	Bacteria	Bacteria	350	6.8e-92	NTclustered	gi\|31747861\|gb\|AY140910.1\|	206681	g35018	i0	92.975	217.732217573222	242	13	100	2	1	239	7114	6874	Candidatus Fritschea bemisiae strain Falk YaeL (yaeL) gene, partial cds; putative glycosylhydrolase and putative transposase genes, complete cds; 16S ribosomal RNA and 23S ribosomal RNA genes, complete sequence; putative endonuclease gene, complete cds; 5S ribosomal RNA gene, complete sequence; argynyl tRNA synthetase (argS), YjeE (yjeE), probable GTP-binding protein, DNA polymerase III epsilon subunit, and phosphoglycerate kinase (pgk) genes, complete cds; and unknown gene	blastn	52038	350	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea bemisiae
13846153	13846153	PRJNA451191_P_NODE_17751_length_343_cov_2.450355_g17480_i0	PRJNA451191	17751	343	2.450355	8.40471765	Simkaniaceae	92712	Bacteria	Bacteria	545	1.22e-150	NTclustered	gi\|124021662\|gb\|EF177461.1\|	420390	g17480	i0	95.614	95.2973760932945	342	12	99	3	2	342	3421	3082	Chlamydiales symbiont of Xenoturbella westbladi 16S ribosomal RNA gene, partial sequence; 23S ribosomal RNA gene, complete sequence; and putative homing endonuclease gene, complete cds	blastn	32687	545	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Chlamydiales symbiont of Xenoturbella westbladi
14469413	14469413	PRJNA451191_P_NODE_41252_length_222_cov_1.211180_g40981_i0	PRJNA451191	41252	222	1.21118	2.6888196	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	206	1.43e-48	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g40981	i0	83.482	506.864864864865	224	34	100	3	1	222	7051812	7052034	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	112524	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18292231	18292231	PRJNA451191_P_NODE_35855_length_238_cov_1.152542_g35584_i0	PRJNA451191	35855	238	1.152542	2.74304996	Luteolibacter luteus	2728835	Bacteria	Bacteria	329	8.82e-86	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g35584	i0	91.983	283.957983193277	237	16	98	2	5	238	3804523	3804759	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	67582	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
18944095	18944095	PRJNA451191_P_NODE_16415_length_358_cov_2.622896_g16144_i0	PRJNA451191	16415	358	2.622896	9.38996768	Parachlamydia	83551	Bacteria	Bacteria	436	8.01e-118	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g16144	i0	92.739	121.877094972067	303	20	84	2	57	358	402	703	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	43632	440	0.990909090909091	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
19565554	19565554	PRJNA451191_P_NODE_12316_length_423_cov_2.378453_g12045_i0	PRJNA451191	12316	423	2.378453	10.06085619	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	749	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g12045	i0	98.582	89.0851063829787	423	6	100	0	1	423	3556760	3557182	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	37683	749	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
20842738	20842738	PRJNA451191_P_NODE_53377_length_203_cov_1.802817_g53106_i0	PRJNA451191	53377	203	1.802817	3.65971851	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	353	4.33e-93	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g53106	i0	98.03	37.512315270936	203	4	100	0	1	203	3556729	3556527	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	7615	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
22116525	22116525	PRJNA451191_P_NODE_20018_length_321_cov_1.746154_g19747_i0	PRJNA451191	20018	321	1.746154	5.60515434	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	268	2.7499999999999998e-67	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g19747	i0	83.007	94.0591900311527	306	42	93	10	22	321	3724183	3723882	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	30193	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
24666976	24666976	PRJNA451191_P_NODE_42060_length_219_cov_2.582278_g41789_i0	PRJNA451191	42060	219	2.582278	5.65518882	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|262409996\|gb\|GU074172.1\|	305355	g41789	i0	100	100.114155251142	219	0	100	0	1	219	392	174	Uncultured Chlamydiae bacterium clone 2H69 16S ribosomal RNA gene, partial sequence	blastn	21925	405	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
29633505	29633505	PRJNA451191_P_NODE_54190_length_203_cov_0.915493_g53919_i0	PRJNA451191	54190	203	0.915493	1.85845079	Victivallales bacterium	2212475	Bacteria	Bacteria	40	0.0224	NR	MBR4901995.1	2212475	g53919	i0	39	0.605911330049261	41	23	57.6	1	35	151	3	43	MBR4901995.1 hypothetical protein [Victivallales bacterium]	diamond	123	40	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
29760045	29760045	PRJNA451191_P_NODE_47531_length_209_cov_0.878378_g47260_i0	PRJNA451191	47531	209	0.878378	1.83581002	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42	0.0446	NR	MFN5655454.1	2026799	g47260	i0	32.7	0.789473684210526	55	35	78.9	1	43	207	354	406	MFN5655454.1 oligosaccharide flippase family protein [Verrucomicrobiota bacterium]	diamond	165	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29791611	29791611	PRJNA451191_P_NODE_34931_length_241_cov_1.288889_g34660_i0	PRJNA451191	34931	241	1.288889	3.10622249	Opitutia bacterium	2026771	Bacteria	Bacteria	43.5	0.0184	NR	MBI5425804.1	2026771	g34660	i0	44.7	1.1701244813278	47	26	58.5	0	39	179	247	293	MBI5425804.1 MFS transporter [Opitutia bacterium]	diamond	282	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
31972662	31972662	PRJNA451191_P_NODE_47478_length_209_cov_0.878378_g47207_i0	PRJNA451191	47478	209	0.878378	1.83581002	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	54.7	9.04e-7	NR	MCW5559863.1	2499141	g47207	i0	74.4	1.10526315789474	39	10	56	0	91	207	8	46	MCW5559863.1 type II secretion system protein [Verrucomicrobiia bacterium]	diamond	231	54.7	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);;