metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA694557" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA694557" and tax_phylum = "Planctomycetota"

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
1949131	1949131	PRJNA694557_P_NODE_11822_length_389_cov_2.430380_g11602_i0	PRJNA694557	11822	389	2.43038	9.4541782	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	401	3.199999999999999e-107	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g11602	i0	99.545	1.15938303341902	220	1	57	0	170	389	2836345	2836564	Gemmata sp. SH-PL17, complete genome	blastn	451	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
1949393	1949393	PRJNA694557_P_NODE_26962_length_224_cov_4.682119_g26742_i0	PRJNA694557	26962	224	4.682119	10.48794656	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	148	2.47e-31	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g26742	i0	88	0.558035714285714	125	15	56	0	90	214	7882060	7881936	Tautonia plasticadhaerens strain ElP chromosome	blastn	125	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
7557567	7557567	PRJNA694557_P_NODE_3966_length_763_cov_55.030435_g3760_i0	PRJNA694557	3966	763	55.030435	419.88221905	Planctomycetaceae	126	Bacteria	Bacteria	601	6.0599999999999996e-167	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g3760	i0	81.88	185.041939711664	734	113	94	16	26	746	1415474	1416200	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	141187	601	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
8326289	8326289	PRJNA694557_P_NODE_12147_length_382_cov_2.734628_g11927_i0	PRJNA694557	12147	382	2.734628	10.44627896	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g11927	i0	94.444	0.240837696335079	36	2	9	0	284	319	6370434	6370399	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	92	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13933595	13933595	PRJNA694557_P_NODE_26971_length_223_cov_6.913333_g26751_i0	PRJNA694557	26971	223	6.913333	15.41673259	Tautonia	2680020	Bacteria	Bacteria	357	3.75e-94	NTclustered	gi\|109649518\|gb\|DQ648480.1\|	120965	g26751	i0	98.515	93.9506726457399	202	3	91	0	22	223	127	328	Uncultured planctomycete clone 987-3b2 16S ribosomal RNA gene, partial sequence	blastn	20951	357	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
15976173	15976173	PRJNA694557_P_NODE_26273_length_236_cov_2.177914_g26053_i0	PRJNA694557	26273	236	2.177914	5.13987704	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	381	2.379999999999999e-101	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g26053	i0	95.781	167.224576271186	237	8	100	2	1	236	267405	267170	Tautonia plasticadhaerens strain ElP chromosome	blastn	39465	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
18525516	18525516	PRJNA694557_P_NODE_975_length_1673_cov_19.070625_g893_i0	PRJNA694557	975	1673	19.070625	319.05155625	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	2723	0	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g893	i0	96.218	411.711894799761	1666	57	99	5	10	1673	265134	266795	Tautonia plasticadhaerens strain ElP chromosome	blastn	688794	2723	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
19800137	19800137	PRJNA694557_P_NODE_15736_length_325_cov_2.980159_g15516_i0	PRJNA694557	15736	325	2.980159	9.68551675	Paludisphaera borealis	1387353	Bacteria	Bacteria	457	5.5399999999999986e-124	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g15516	i0	92.5	147.781538461538	320	22	98	2	4	322	122929	123247	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	48029	457	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
23625866	23625866	PRJNA694557_P_NODE_11179_length_403_cov_1.996970_g10959_i0	PRJNA694557	11179	403	1.99697	8.0477891	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	337	9.529999999999998e-88	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g10959	i0	83.516	4.51116625310174	364	56	90	4	32	393	5464429	5464790	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	1818	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23626056	23626056	PRJNA694557_P_NODE_22219_length_260_cov_1.796791_g21999_i0	PRJNA694557	22219	260	1.796791	4.6716566	Polystyrenella longa	2528007	Bacteria	Bacteria	361	3.469999999999999e-95	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g21999	i0	94.093	107.057692307692	237	14	91	0	24	260	1417634	1417870	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	27835	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
24899769	24899769	PRJNA694557_P_NODE_3480_length_823_cov_4.494667_g3280_i0	PRJNA694557	3480	823	4.494667	36.99110941	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	56.5	0.006	NTclustered	gi\|2921913114\|gb\|CP182803.1\|	2026777	g3280	i0	100	0.0364520048602673	30	0	4	0	454	483	982643	982672	MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25405866	25405866	PRJNA694557_P_NODE_11940_length_386_cov_6.712460_g11720_i0	PRJNA694557	11940	386	6.71246	25.9100956	Planctomycetia	203683	Bacteria	Bacteria	608	1.739999999999999e-169	NTclustered	gi\|219903967\|emb\|AM935706.1\|	100371	g11720	i0	96.477	97.2383419689119	369	12	95	1	19	386	1056	688	Uncultured Planctomycetales bacterium partial 16S rRNA gene, clone AMCA8	blastn	37534	614	0.990228013029316	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales 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);;