metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA316313" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA316313" 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
387399	387399	PRJNA316313_P_NODE_351361_length_178_cov_1.914894_g349975_i0	PRJNA316313	351361	178	1.914894	3.40851132	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	65.8	1.93e-6	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g349975	i0	90	0.280898876404494	50	5	28	0	103	152	2097617	2097666	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	50	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
388152	388152	PRJNA316313_P_NODE_473541_length_151_cov_2.929825_g472155_i0	PRJNA316313	473541	151	2.929825	4.42403575	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	122	9.26e-24	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g472155	i0	81.699	6.70860927152318	153	22	99	4	3	151	1758369	1758519	Planctomycetes bacterium MalM25 chromosome	blastn	1013	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
1661222	1661222	PRJNA316313_P_NODE_205642_length_187_cov_3.373333_g204256_i0	PRJNA316313	205642	187	3.373333	6.30813271	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	63.9	7.39e-6	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g204256	i0	87.273	0.294117647058824	55	7	29	0	133	187	3862222	3862168	Tautonia plasticadhaerens strain ElP chromosome	blastn	55	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
3619076	3619076	PRJNA316313_P_NODE_443743_length_151_cov_3.824561_g442357_i0	PRJNA316313	443743	151	3.824561	5.77508711	Botrimarina	2795782	Bacteria	Bacteria	141	2.56e-29	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g442357	i0	100	2.02649006622517	76	0	100	0	76	151	1737546	1737621	Planctomycetes bacterium K2D chromosome, complete genome	blastn	306	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
4215320	4215320	PRJNA316313_P_NODE_454544_length_151_cov_3.421053_g453158_i0	PRJNA316313	454544	151	3.421053	5.16579003	Gemmataceae bacterium	2052164	Bacteria	Bacteria	145	1.98e-30	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g453158	i0	100	1.02649006622517	78	0	100	0	74	151	7045610	7045687	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	155	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
4895395	4895395	PRJNA316313_P_NODE_203584_length_187_cov_3.400000_g202198_i0	PRJNA316313	203584	187	3.4	6.358	Gimesia	1649453	Bacteria	Bacteria	69.4	1.59e-7	NTclustered	gi\|1712536321\|gb\|CP036341.1\|	122	g202198	i0	100	0.593582887700535	37	0	20	0	40	76	241395	241359	Gimesia maris strain Mal35 chromosome	blastn	111	69.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
10589930	10589930	PRJNA316313_P_NODE_134209_length_187_cov_5.900000_g132823_i0	PRJNA316313	134209	187	5.9	11.033	Humisphaera borealis	2807512	Bacteria	Bacteria	119	1.56e-22	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g132823	i0	94.737	28.7379679144385	76	4	41	0	1	76	4390203	4390278	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	5374	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
10591997	10591997	PRJNA316313_P_NODE_504289_length_150_cov_3.212389_g502903_i0	PRJNA316313	504289	150	3.212389	4.8185835	Lacipirellula parvula	2650471	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g502903	i0	100	0.186666666666667	28	0	19	0	113	140	5729968	5729941	Lacipirellula parvula PX69 DNA, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
13141800	13141800	PRJNA316313_P_NODE_485231_length_150_cov_5.097345_g483845_i0	PRJNA316313	485231	150	5.097345	7.6460175	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	154	3.26e-33	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g483845	i0	85.065	1.02666666666667	154	19	100	1	1	150	436369	436522	Pirellula sp. SH-Sr6A, complete genome	blastn	154	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
15689190	15689190	PRJNA316313_P_NODE_200453_length_187_cov_3.440000_g199067_i0	PRJNA316313	200453	187	3.44	6.4328	Limnoglobus roseus	2598579	Bacteria	Bacteria	75	3.42e-9	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g199067	i0	93.878	2.03208556149733	49	3	26	0	28	76	7245418	7245370	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	380	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16964245	16964245	PRJNA316313_P_NODE_262854_length_187_cov_2.686667_g261468_i0	PRJNA316313	262854	187	2.686667	5.02406729	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	91.6	3.39e-14	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g261468	i0	89.041	2.20855614973262	73	8	76	0	115	187	2426021	2425949	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	413	91.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
19512375	19512375	PRJNA316313_P_NODE_178376_length_187_cov_3.833333_g176990_i0	PRJNA316313	178376	187	3.833333	7.16833271	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	117	5.600000000000001e-22	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g176990	i0	95.833	0.550802139037433	72	3	39	0	112	183	2965268	2965197	Planctomyces sp. SH-PL62, complete genome	blastn	103	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19512485	19512485	PRJNA316313_P_NODE_202536_length_187_cov_3.413333_g201150_i0	PRJNA316313	202536	187	3.413333	6.38293271	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	73.1	1.23e-8	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g201150	i0	89.474	0.304812834224599	57	6	30	0	113	169	2252727	2252783	Planctomyces sp. SH-PL62, complete genome	blastn	57	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19513252	19513252	PRJNA316313_P_NODE_341536_length_183_cov_6.294521_g340150_i0	PRJNA316313	341536	183	6.294521	11.51897343	Roseimaritima ulvae	980254	Bacteria	Bacteria	63.9	7.2e-6	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g340150	i0	93.182	0.240437158469945	44	1	23	2	39	81	4941787	4941745	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	44	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
21469727	21469727	PRJNA316313_P_NODE_319797_length_187_cov_2.246667_g318411_i0	PRJNA316313	319797	187	2.246667	4.20126729	Planctomycetia	203683	Bacteria	Bacteria	124	3.34e-24	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g318411	i0	96.053	17.4705882352941	76	3	41	0	1	76	3909201	3909126	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	3267	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22063656	22063656	PRJNA316313_P_NODE_321698_length_187_cov_2.213333_g320312_i0	PRJNA316313	321698	187	2.213333	4.13893271	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	67.6	5.72e-7	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g320312	i0	90.196	0.272727272727273	51	5	27	0	1	51	6030870	6030920	Tautonia plasticadhaerens strain ElP chromosome	blastn	51	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
22064610	22064610	PRJNA316313_P_NODE_486098_length_150_cov_4.920354_g484712_i0	PRJNA316313	486098	150	4.920354	7.380531	Pirellulales bacterium	2715253	Bacteria	Bacteria	104	3.33e-18	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g484712	i0	90.909	19.4266666666667	77	7	51	0	74	150	2656546	2656470	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	2914	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
22744450	22744450	PRJNA316313_P_NODE_202378_length_187_cov_3.413333_g200992_i0	PRJNA316313	202378	187	3.413333	6.38293271	Planctomycetia	203683	Bacteria	Bacteria	91.6	3.39e-14	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g200992	i0	92.188	1.02673796791444	64	5	35	0	1	64	1866043	1865980	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	192	91.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
24613268	24613268	PRJNA316313_P_NODE_304920_length_187_cov_2.393333_g303534_i0	PRJNA316313	304920	187	2.393333	4.47553271	Urbifossiella limnaea	2528023	Bacteria	Bacteria	65.8	2.06e-6	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g303534	i0	86.885	0.556149732620321	61	4	32	2	16	74	1400181	1400239	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	104	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea

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