metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
1013200	1013200	PRJNA1067370_P_NODE_114881_length_241_cov_0.916667_g114332_i0	PRJNA1067370	114881	241	0.916667	2.20916747	Gemmata	113	Bacteria	Bacteria	316	6.97e-82	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g114332	i0	90.417	10.1120331950207	240	23	99	0	1	240	7659293	7659054	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	2437	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
1013384	1013384	PRJNA1067370_P_NODE_99321_length_245_cov_1.343023_g98772_i0	PRJNA1067370	99321	245	1.343023	3.29040635	root	1	Root_unresolved	Root_unresolved	344	3.26e-90	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g98772	i0	91.935	68.2897959183673	248	16	100	4	1	245	7051196	7050950	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	16731	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1455231	1455231	PRJNA1067370_P_NODE_106862_length_243_cov_0.905882_g106313_i0	PRJNA1067370	106862	243	0.905882	2.20129326	Gemmataceae bacterium	2052164	Bacteria	Bacteria	307	4.23e-79	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g106313	i0	89.516	2.4320987654321	248	18	100	6	1	243	1991410	1991654	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	591	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
1455732	1455732	PRJNA1067370_P_NODE_71502_length_262_cov_1.629630_g70953_i0	PRJNA1067370	71502	262	1.62963	4.2696306	uncultured Planctomyces sp.	179110	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|459463901\|gb\|KC502949.1\|	179110	g70953	i0	99.618	99.7137404580153	262	1	100	0	1	262	1367	1106	Uncultured Planctomyces sp. clone AHy34 16S ribosomal RNA gene, partial sequence	blastn	26125	479	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	uncultured Planctomyces sp.
2731445	2731445	PRJNA1067370_P_NODE_51603_length_293_cov_1.218182_g51054_i0	PRJNA1067370	51603	293	1.218182	3.56927326	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	405	1.81e-108	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g51054	i0	91.554	126.211604095563	296	22	100	3	1	293	5085903	5086198	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	36980	405	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
4007474	4007474	PRJNA1067370_P_NODE_64464_length_273_cov_1.295000_g63915_i0	PRJNA1067370	64464	273	1.295	3.53535	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	191	5.09e-44	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g63915	i0	85.106	2.73260073260073	188	27	68	1	1	187	1742117	1742304	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	746	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11659539	11659539	PRJNA1067370_P_NODE_51010_length_294_cov_1.687783_g50461_i0	PRJNA1067370	51010	294	1.687783	4.96208202	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	298	3.17e-76	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g50461	i0	85.567	127.741496598639	291	34	98	8	8	294	5085933	5085647	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	37556	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
15483992	15483992	PRJNA1067370_P_NODE_97693_length_246_cov_0.890173_g97144_i0	PRJNA1067370	97693	246	0.890173	2.18982558	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	316	7.14e-82	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g97144	i0	89.837	4.16666666666667	246	25	100	0	1	246	6734174	6733929	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1025	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20581644	20581644	PRJNA1067370_P_NODE_10617_length_559_cov_1.222222_g10077_i0	PRJNA1067370	10617	559	1.222222	6.83222098	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	640	9.24e-179	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g10077	i0	87.544	116.468694096601	562	59	100	10	1	559	1844905	1844352	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	65106	640	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
23132864	23132864	PRJNA1067370_P_NODE_108079_length_243_cov_0.905882_g107530_i0	PRJNA1067370	108079	243	0.905882	2.20129326	Gemmataceae bacterium	2052164	Bacteria	Bacteria	307	4.23e-79	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g107530	i0	89.958	2.92592592592593	239	23	98	1	1	238	2296568	2296806	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	711	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23133344	23133344	PRJNA1067370_P_NODE_70339_length_264_cov_1.345550_g69790_i0	PRJNA1067370	70339	264	1.34555	3.552252	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	329	9.95e-86	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g69790	i0	89.098	159.162878787879	266	27	100	2	1	264	2002050	2002315	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	42019	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23133508	23133508	PRJNA1067370_P_NODE_93579_length_247_cov_0.885057_g93030_i0	PRJNA1067370	93579	247	0.885057	2.18609079	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	265	2.63e-66	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g93030	i0	86.29	163.522267206478	248	28	100	4	1	247	1600297	1600539	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	40390	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
24406835	24406835	PRJNA1067370_P_NODE_50580_length_295_cov_1.846847_g50032_i0	PRJNA1067370	50580	295	1.846847	5.44819865	Humisphaera borealis	2807512	Bacteria	Bacteria	313	1.14e-80	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g50032	i0	85.859	229.213559322034	297	39	100	3	1	295	5062933	5063228	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	67618	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis

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