metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA437204" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA437204" 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
1706887	1706887	PRJNA437204_P_NODE_12722_length_488_cov_3.821687_g12424_i0	PRJNA437204	12722	488	3.821687	18.64983256	Alienimonas californiensis	2527989	Bacteria	Bacteria	686	0	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g12424	i0	92.041	147.612704918033	490	35	100	4	1	488	376160	375673	Alienimonas californiensis strain CA12 chromosome	blastn	72035	686	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
2983196	2983196	PRJNA437204_P_NODE_39623_length_325_cov_1.750000_g39324_i0	PRJNA437204	39623	325	1.75	5.6875	Gimesia aquarii	2527964	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1712555625\|gb\|CP037920.1\|	2527964	g39324	i0	100	0.0861538461538462	28	0	9	0	34	61	799062	799089	Gimesia aquarii strain V144 chromosome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia aquarii
5537259	5537259	PRJNA437204_P_NODE_91725_length_249_cov_0.875000_g91426_i0	PRJNA437204	91725	249	0.875	2.17875	Fontisphaera persica	2974023	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g91426	i0	100	0.116465863453815	29	0	12	0	151	179	3684527	3684555	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
10637336	10637336	PRJNA437204_P_NODE_85369_length_250_cov_0.870056_g85070_i0	PRJNA437204	85369	250	0.870056	2.17514	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	207	4.57e-49	NTclustered	gi\|2621713475\|emb\|OY771506.1\|	2026777	g85070	i0	82.101	30.62	257	33	99	10	1	249	3767885	3768136	MAG: Phycisphaeraceae bacterium isolate 5ced0416-64b5-4844-9ce5-ab75583fac57 genome assembly, chromosome: 1	blastn	7655	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11911691	11911691	PRJNA437204_P_NODE_60410_length_280_cov_1.487923_g60111_i0	PRJNA437204	60410	280	1.487923	4.1661844	Gemmataceae bacterium	2052164	Bacteria	Bacteria	150	8.89e-32	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g60111	i0	82.386	30.2107142857143	176	27	62	4	55	228	2058225	2058052	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	8459	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
15117251	15117251	PRJNA437204_P_NODE_1252_length_1191_cov_2.658318_g1092_i0	PRJNA437204	1252	1191	2.658318	31.66056738	Pirellula	123	Bacteria	Bacteria	1472	0	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g1092	i0	90.472	116.173803526448	1123	97	100	8	1	1117	1136	18	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	138363	1472	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
15735819	15735819	PRJNA437204_P_NODE_70973_length_263_cov_1.621053_g70674_i0	PRJNA437204	70973	263	1.621053	4.26336939	Rohdeia mirabilis	2528008	Bacteria	Bacteria	351	2.11e-92	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g70674	i0	91.44	206.965779467681	257	20	97	2	1	256	3893348	3893603	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	54432	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
20216190	20216190	PRJNA437204_P_NODE_57976_length_284_cov_2.516588_g57677_i0	PRJNA437204	57976	284	2.516588	7.14710992	Pirellulaceae	2691357	Bacteria	Bacteria	446	1.03e-120	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g57677	i0	95.374	293.109154929577	281	12	99	1	1	281	2524	2803	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	83243	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
22108550	22108550	PRJNA437204_P_NODE_123438_length_242_cov_0.911243_g123139_i0	PRJNA437204	123438	242	0.911243	2.20520806	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g123139	i0	100	0.115702479338843	28	0	12	0	33	60	1298705	1298732	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22766197	22766197	PRJNA437204_P_NODE_102478_length_246_cov_0.890173_g102179_i0	PRJNA437204	102478	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g102179	i0	100	4.29674796747967	30	0	12	0	216	245	1397908	1397937	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	1057	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23383993	23383993	PRJNA437204_P_NODE_11679_length_505_cov_4.537037_g11381_i0	PRJNA437204	11679	505	4.537037	22.91203685	Polystyrenella longa	2528007	Bacteria	Bacteria	449	1.5e-121	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g11381	i0	82.806	292.710891089109	506	84	100	3	1	505	1415979	1415476	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	147819	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
23384782	23384782	PRJNA437204_P_NODE_4159_length_760_cov_2.697234_g3891_i0	PRJNA437204	4159	760	2.697234	20.4989784	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	852	0	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3891	i0	88.547	115.398684210526	716	65	94	7	47	760	3082013	3082713	Stratiformator vulcanicus strain Pan189 chromosome	blastn	87703	852	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
24658774	24658774	PRJNA437204_P_NODE_36800_length_333_cov_1.750000_g36501_i0	PRJNA437204	36800	333	1.75	5.8275	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	488	2.0199999999999997e-133	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g36501	i0	93.093	96.996996996997	333	23	100	0	1	333	7629904	7629572	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	32300	488	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
25315913	25315913	PRJNA437204_P_NODE_340_length_1846_cov_2.360406_g277_i0	PRJNA437204	340	1846	2.360406	43.57309476	PVC group	1783257	Bacteria	Bacteria	56.5	0.015	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g277	i0	87.755	0.042795232936078	49	4	3	2	1514	1561	688886	688839	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	79	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;