metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA757618" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA757618" 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
3283888	3283888	PRJNA757618_P_NODE_33863_length_249_cov_0.880682_g32811_i0	PRJNA757618	33863	249	0.880682	2.19289818	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	231	2.7e-56	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g32811	i0	85.022	0.911646586345382	227	34	91	0	23	249	2377360	2377586	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	227	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
5836185	5836185	PRJNA757618_P_NODE_40045_length_246_cov_0.890173_g38993_i0	PRJNA757618	40045	246	0.890173	2.18982558	Urbifossiella limnaea	2528023	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g38993	i0	89.754	5.7520325203252	244	23	99	2	4	246	6400692	6400450	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1415	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10936658	10936658	PRJNA757618_P_NODE_33969_length_249_cov_0.880682_g32917_i0	PRJNA757618	33969	249	0.880682	2.19289818	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	333	7.189999999999999e-87	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g32917	i0	90.763	6.61044176706827	249	23	100	0	1	249	1251079	1251327	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1646	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
10936796	10936796	PRJNA757618_P_NODE_44229_length_244_cov_0.900585_g43177_i0	PRJNA757618	44229	244	0.900585	2.1974274	Gemmataceae bacterium	2052164	Bacteria	Bacteria	329	9.08e-86	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g43177	i0	91.632	0.979508196721312	239	18	98	2	2	239	1578688	1578925	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	239	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
10936950	10936950	PRJNA757618_P_NODE_9749_length_358_cov_1.073684_g8697_i0	PRJNA757618	9749	358	1.073684	3.84378872	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	473	6.11e-129	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g8697	i0	90.503	275.991620111732	358	34	100	0	1	358	1320102	1319745	Luteolibacter sp. Populi chromosome, complete genome	blastn	98805	473	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
12212033	12212033	PRJNA757618_P_NODE_27950_length_252_cov_0.871508_g26898_i0	PRJNA757618	27950	252	0.871508	2.19620016	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	283	7.44e-72	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g26898	i0	87.149	0.988095238095238	249	32	99	0	1	249	5492947	5492699	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	249	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15231063	15231063	PRJNA757618_P_NODE_38772_length_246_cov_0.901734_g37720_i0	PRJNA757618	38772	246	0.901734	2.21826564	Gemmata	113	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g37720	i0	97.967	181.967479674797	246	5	100	0	1	246	2109	2354	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	44764	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
23685793	23685793	PRJNA757618_P_NODE_48419_length_242_cov_0.911243_g47367_i0	PRJNA757618	48419	242	0.911243	2.20520806	Pirellulales bacterium	2715253	Bacteria	Bacteria	67.6	7.78e-7	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g47367	i0	84.286	11.5909090909091	70	9	29	2	46	114	2422647	2422715	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	2805	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales 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);;