metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1249042" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1249042" 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
354576	354576	PRJNA1249042_S_NODE_67321_length_190_cov_2.238095_g67107_i0	PRJNA1249042	67321	190	2.238095	4.2523805	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	279	6.88e-71	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g67107	i0	93.194	238.415789473684	191	11	100	2	1	190	2002496	2002685	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	45299	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11255500	11255500	PRJNA1249042_S_NODE_15389_length_280_cov_1.987342_g15175_i0	PRJNA1249042	15389	280	1.987342	5.5645576	Botrimarina	2795782	Bacteria	Bacteria	484	2.15e-132	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g15175	i0	97.857	310.957142857143	280	6	100	0	1	280	4247467	4247188	Planctomycetes bacterium K2D chromosome, complete genome	blastn	87068	484	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
13108334	13108334	PRJNA1249042_S_NODE_37731_length_227_cov_3.994565_g37517_i0	PRJNA1249042	37731	227	3.994565	9.06766255	Humisphaera borealis	2807512	Bacteria	Bacteria	231	2.4199999999999997e-56	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g37517	i0	85.526	50.4229074889868	228	26	99	7	4	227	5063116	5062892	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	11446	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13108786	13108786	PRJNA1249042_S_NODE_96251_length_164_cov_1.942149_g96037_i0	PRJNA1249042	96251	164	1.942149	3.18512436	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	191	2.78e-44	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g96037	i0	88.535	10.4146341463415	157	18	96	0	8	164	7956693	7956849	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	1708	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
16931904	16931904	PRJNA1249042_S_NODE_62774_length_195_cov_1.585526_g62560_i0	PRJNA1249042	62774	195	1.585526	3.0917757	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g62560	i0	100	0.143589743589744	28	0	14	0	93	120	914390	914417	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
17629993	17629993	PRJNA1249042_S_NODE_42534_length_220_cov_2.322034_g42320_i0	PRJNA1249042	42534	220	2.322034	5.1084748	Akkermansia	239934	Bacteria	Bacteria	213	8.44e-51	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g42320	i0	84.234	298.690909090909	222	31	100	4	1	220	139100	139319	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	65712	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
18206014	18206014	PRJNA1249042_S_NODE_18515_length_269_cov_1.840708_g18301_i0	PRJNA1249042	18515	269	1.840708	4.95150452	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	481	2.65e-131	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g18301	i0	98.885	146.226765799256	269	3	100	0	1	269	5171549	5171817	Lacipirellula limnantheis strain I41 chromosome	blastn	39335	481	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
24580498	24580498	PRJNA1249042_S_NODE_101920_length_160_cov_1.598291_g101706_i0	PRJNA1249042	101920	160	1.598291	2.5572656	Opitutia bacterium KCR 482	3034326	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|2707273910\|gb\|CP149973.1\|	3034326	g101706	i0	99.375	1	160	1	100	0	1	160	2274798	2274957	Opitutia bacterium KCR 482 chromosome, complete genome	blastn	160	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium KCR 482
24580832	24580832	PRJNA1249042_S_NODE_39180_length_225_cov_2.582418_g38966_i0	PRJNA1249042	39180	225	2.582418	5.8104405	Limnoglobus roseus	2598579	Bacteria	Bacteria	372	1.35e-98	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g38966	i0	96.444	41.1822222222222	225	8	100	0	1	225	2956669	2956893	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	9266	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus

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