metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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
163657	163657	PRJNA1028258_P_NODE_14461_length_668_cov_1.652755_g13958_i0	PRJNA1028258	14461	668	1.652755	11.0404034	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	612	2.4299999999999998e-170	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g13958	i0	85.526	273.616766467066	608	63	98	21	79	668	2663913	2664513	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	182776	612	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
164859	164859	PRJNA1028258_P_NODE_45941_length_373_cov_3.348684_g45378_i0	PRJNA1028258	45941	373	3.348684	12.49059132	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	340	6.76e-89	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g45378	i0	83.333	661.061662198391	378	54	100	7	1	373	1830218	1829845	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	246576	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
1438557	1438557	PRJNA1028258_P_NODE_152182_length_231_cov_0.876543_g151619_i0	PRJNA1028258	152182	231	0.876543	2.02481433	Caulifigura coniformis	2527983	Bacteria	Bacteria	135	1.99e-27	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g151619	i0	78.243	2.06060606060606	239	32	99	16	1	229	6226270	6226498	Caulifigura coniformis strain Pan44 chromosome	blastn	476	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
1438982	1438982	PRJNA1028258_P_NODE_180082_length_219_cov_3.060000_g179519_i0	PRJNA1028258	180082	219	3.06	6.7014	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	211	3.02e-50	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g179519	i0	87.097	78.2328767123288	186	24	86	0	23	208	4555498	4555313	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	17133	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
5265734	5265734	PRJNA1028258_P_NODE_100485_length_260_cov_1.727749_g99922_i0	PRJNA1028258	100485	260	1.727749	4.4921474	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	368	2.07e-97	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g99922	i0	92.308	142.8	260	18	100	2	1	260	4466875	4467132	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	37128	368	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
6541487	6541487	PRJNA1028258_P_NODE_123326_length_241_cov_2.203488_g122763_i0	PRJNA1028258	123326	241	2.203488	5.31040608	Humisphaera borealis	2807512	Bacteria	Bacteria	228	3.3599999999999994e-55	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g122763	i0	84.483	183.784232365145	232	34	96	2	1	231	5063487	5063257	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	44292	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
7382215	7382215	PRJNA1028258_P_NODE_127486_length_238_cov_1.562130_g126923_i0	PRJNA1028258	127486	238	1.56213	3.7178694	Gemmata	113	Bacteria	Bacteria	147	9.53e-31	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g126923	i0	83.871	98.9831932773109	155	23	66	2	48	201	7182314	7182161	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	23558	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
9091345	9091345	PRJNA1028258_P_NODE_147948_length_231_cov_3.246914_g147385_i0	PRJNA1028258	147948	231	3.246914	7.50037134	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	233	6.87e-57	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g147385	i0	84.898	160.65367965368	245	21	99	6	1	229	2501977	2502221	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	37111	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
11642045	11642045	PRJNA1028258_P_NODE_12870_length_707_cov_3.534483_g12378_i0	PRJNA1028258	12870	707	3.534483	24.98879481	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	767	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g12378	i0	86.332	126.016973125884	717	83	100	12	1	707	1830552	1831263	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	89094	767	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
11642172	11642172	PRJNA1028258_P_NODE_136190_length_234_cov_0.860606_g135627_i0	PRJNA1028258	136190	234	0.860606	2.01381804	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	58.4	4.5e-4	NTclustered	gi\|1702190059\|gb\|CP030884.1\|	2026779	g135627	i0	100	2.7008547008547	31	0	13	0	199	229	5380422	5380392	Planctomycetaceae bacterium isolate ECT2AJA-110-A chromosome	blastn	632	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
12918533	12918533	PRJNA1028258_P_NODE_42771_length_387_cov_1.295597_g42208_i0	PRJNA1028258	42771	387	1.295597	5.01396039	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	575	1.7699999999999994e-159	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g42208	i0	93.54	95.8759689922481	387	24	100	1	1	387	1831864	1832249	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	37104	575	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
12918544	12918544	PRJNA1028258_P_NODE_43291_length_384_cov_3.800000_g42728_i0	PRJNA1028258	43291	384	3.8	14.592	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	383	1.1399999999999997e-101	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g42728	i0	84.715	271.1015625	386	56	100	3	1	384	1831841	1832225	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	104103	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
14192579	14192579	PRJNA1028258_P_NODE_161592_length_228_cov_1.503145_g161029_i0	PRJNA1028258	161592	228	1.503145	3.4271706	Limnoglobus roseus	2598579	Bacteria	Bacteria	289	1.42e-73	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g161029	i0	89.474	3.66666666666667	228	24	100	0	1	228	3599278	3599505	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	836	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
14193668	14193668	PRJNA1028258_P_NODE_51112_length_355_cov_1.489510_g50549_i0	PRJNA1028258	51112	355	1.48951	5.2877605	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	531	3.5399999999999993e-146	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g50549	i0	93.768	216.622535211268	353	22	99	0	1	353	1156091	1155739	Planctomyces sp. SH-PL62, complete genome	blastn	76901	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
15467010	15467010	PRJNA1028258_P_NODE_178513_length_225_cov_0.846154_g177950_i0	PRJNA1028258	178513	225	0.846154	1.9038465	Urbifossiella limnaea	2528023	Bacteria	Bacteria	89.8	1.52e-13	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g177950	i0	90.909	1.74666666666667	66	6	29	0	88	153	5108280	5108345	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	393	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
16741643	16741643	PRJNA1028258_P_NODE_36294_length_420_cov_4.219373_g35731_i0	PRJNA1028258	36294	420	4.219373	17.7213666	Humisphaera borealis	2807512	Bacteria	Bacteria	302	3.64e-77	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g35731	i0	80.14	94.3666666666667	428	65	100	16	1	420	5063277	5062862	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	39634	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
18016809	18016809	PRJNA1028258_P_NODE_49255_length_361_cov_1.972603_g48692_i0	PRJNA1028258	49255	361	1.972603	7.12109683	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	488	2.1999999999999997e-133	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g48692	i0	91.16	341.90027700831	362	28	99	4	2	361	1829829	1830188	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	123426	488	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
18855914	18855914	PRJNA1028258_P_NODE_107115_length_255_cov_1.155914_g106552_i0	PRJNA1028258	107115	255	1.155914	2.9475807	Humisphaera	2807511	Bacteria	Bacteria	135	2.24e-27	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g106552	i0	93.407	30.3450980392157	91	6	36	0	165	255	5064242	5064332	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	7738	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
18857651	18857651	PRJNA1028258_P_NODE_64455_length_318_cov_2.835341_g63892_i0	PRJNA1028258	64455	318	2.835341	9.01638438	Planctomycetaceae	126	Bacteria	Bacteria	422	1.97e-113	NTclustered	gi\|1712615819\|gb\|CP036277.1\|	2527978	g63892	i0	90.823	208.974842767296	316	28	99	1	1	316	2210468	2210154	Gimesia panareensis strain Pan110 chromosome, complete genome	blastn	66454	424	0.995283018867924	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia panareensis
21840267	21840267	PRJNA1028258_P_NODE_124938_length_240_cov_1.584795_g124375_i0	PRJNA1028258	124938	240	1.584795	3.803508	Gemmataceae bacterium	2052164	Bacteria	Bacteria	296	9.03e-76	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g124375	i0	89.212	139.35	241	21	99	5	1	238	320143	320381	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	33444	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23116535	23116535	PRJNA1028258_P_NODE_181299_length_214_cov_2.668966_g180735_i0	PRJNA1028258	181299	214	2.668966	5.71158724	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	209	1.06e-49	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g180735	i0	84.689	2.47196261682243	209	32	98	0	4	212	5513790	5513582	Planctomyces sp. SH-PL14, complete genome	blastn	529	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
24391784	24391784	PRJNA1028258_P_NODE_86280_length_278_cov_0.947368_g85717_i0	PRJNA1028258	86280	278	0.947368	2.63368304	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	261	3.91e-65	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g85717	i0	83.986	54.5143884892086	281	35	100	8	1	278	1831423	1831150	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	15155	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
24391788	24391788	PRJNA1028258_P_NODE_86520_length_277_cov_1.697115_g85957_i0	PRJNA1028258	86520	277	1.697115	4.70100855	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	424	4.69e-114	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g85957	i0	94.245	248.509025270758	278	14	100	2	1	277	2501017	2501293	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	68837	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae 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);;