metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA631119" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA631119" 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
603164	603164	PRJNA631119_P_NODE_2081_length_738_cov_1.927820_g1976_i0	PRJNA631119	2081	738	1.92782	14.2273116	Actomonas aquatica	2866162	Bacteria	Bacteria	60.2	4.42e-4	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g1976	i0	100	0.043360433604336	32	0	4	0	542	573	779082	779051	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	32	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
3154036	3154036	PRJNA631119_P_NODE_15163_length_328_cov_3.470588_g15045_i0	PRJNA631119	15163	328	3.470588	11.38352864	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	309	1.66e-79	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g15045	i0	84.591	43.280487804878	318	41	95	6	3	312	7050823	7050506	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	14196	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8256382	8256382	PRJNA631119_P_NODE_28047_length_261_cov_1.228723_g27929_i0	PRJNA631119	28047	261	1.228723	3.20696703	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	364	2.689999999999999e-96	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g27929	i0	91.985	90.0727969348659	262	17	100	2	1	261	1600509	1600251	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	23509	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
12630940	12630940	PRJNA631119_P_NODE_26450_length_267_cov_1.587629_g26332_i0	PRJNA631119	26450	267	1.587629	4.23896943	Candidatus Protochlamydia	282132	Bacteria	Bacteria	449	7.410000000000001e-122	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g26332	i0	97.348	136.674157303371	264	7	99	0	1	264	1250359	1250622	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	36492	451	0.995565410199557	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
14632235	14632235	PRJNA631119_P_NODE_4132_length_548_cov_2.726316_g4017_i0	PRJNA631119	4132	548	2.726316	14.94021168	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	63.9	2.49e-5	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g4017	i0	97.368	0.454379562043796	38	0	7	1	321	357	2195003	2194966	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	249	63.9	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
15905978	15905978	PRJNA631119_P_NODE_14393_length_334_cov_3.084291_g14275_i0	PRJNA631119	14393	334	3.084291	10.30153194	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	547	3.2899999999999986e-151	NTclustered	gi\|317120536\|gb\|HQ010214.1\|	120965	g14275	i0	96.933	98.1047904191617	326	10	98	0	4	329	613	938	Uncultured planctomycete clone soil31_C7 16S ribosomal RNA gene, partial sequence	blastn	32767	547	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
15906015	15906015	PRJNA631119_P_NODE_22153_length_286_cov_1.446009_g22035_i0	PRJNA631119	22153	286	1.446009	4.13558574	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	350	8.369999999999999e-92	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g22035	i0	88.889	80.9510489510489	288	26	99	6	3	286	7052547	7052262	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	23152	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20278454	20278454	PRJNA631119_P_NODE_9856_length_385_cov_1.474359_g9738_i0	PRJNA631119	9856	385	1.474359	5.67628215	Opitutia	414999	Bacteria	Bacteria	257	7.26e-64	NTclustered	gi\|2626245913\|emb\|OY829953.1\|	2026772	g9738	i0	79.888	143.155844155844	358	66	92	6	3	357	679387	679033	MAG: Opitutales bacterium isolate cf0dc631-26ae-4be7-9546-4b6096dd6533 genome assembly, chromosome: 1	blastn	55115	257	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
23555912	23555912	PRJNA631119_P_NODE_9819_length_385_cov_3.272436_g9701_i0	PRJNA631119	9819	385	3.272436	12.5988786	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g9701	i0	96.875	0.0831168831168831	32	0	8	1	129	159	1377541	1377510	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	32	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
24829549	24829549	PRJNA631119_P_NODE_36680_length_244_cov_0.900585_g36562_i0	PRJNA631119	36680	244	0.900585	2.1974274	Mariniblastus fucicola	980251	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1730062935\|gb\|CP042912.1\|	980251	g36562	i0	100	0.114754098360656	28	0	11	0	188	215	5198891	5198918	Mariniblastus fucicola strain FC18 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Mariniblastus	Mariniblastus fucicola

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);;