metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA312107" 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
6166392	6166392	PRJNA312107_P_NODE_20765_length_167_cov_0.881356_g20599_i0	PRJNA312107	20765	167	0.881356	1.47186452	PVC group	1783257	Bacteria	Bacteria	111	2.28e-20	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g20599	i0	89.011	3.61676646706587	91	8	54	2	25	114	417999	417910	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	604	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
8030801	8030801	PRJNA312107_P_NODE_17747_length_173_cov_1.346774_g17581_i0	PRJNA312107	17747	173	1.346774	2.32991902	Phycisphaerae bacterium RAS2	2528035	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1712788464\|gb\|CP036352.1\|	2528035	g17581	i0	96.875	0.184971098265896	32	1	18	0	68	99	2231249	2231280	Phycisphaerae bacterium RAS2 chromosome, complete genome	blastn	32	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium RAS2
8030831	8030831	PRJNA312107_P_NODE_21067_length_167_cov_0.881356_g20901_i0	PRJNA312107	21067	167	0.881356	1.47186452	Caulifigura coniformis	2527983	Bacteria	Bacteria	178	2.21e-40	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g20901	i0	86.31	84.497005988024	168	17	99	6	3	167	1443812	1443976	Caulifigura coniformis strain Pan44 chromosome	blastn	14111	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
11856268	11856268	PRJNA312107_P_NODE_23870_length_164_cov_0.904348_g23704_i0	PRJNA312107	23870	164	0.904348	1.48313072	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	172	1.0099999999999999e-38	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g23704	i0	85.542	85.0670731707317	166	22	100	2	1	164	2002354	2002189	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	13951	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13131304	13131304	PRJNA312107_P_NODE_12651_length_205_cov_1.121795_g12485_i0	PRJNA312107	12651	205	1.121795	2.29967975	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	276	9.76e-70	NTclustered	gi\|1710291850\|gb\|MN235841.1\|	120965	g12485	i0	91.262	96.0878048780488	206	12	99	3	2	205	219	18	Uncultured Planctomycetota bacterium clone oligPB-51 16S ribosomal RNA gene, partial sequence	blastn	19698	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
13131322	13131322	PRJNA312107_P_NODE_17411_length_175_cov_1.214286_g17245_i0	PRJNA312107	17411	175	1.214286	2.1250005	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	185	1.3899999999999996e-42	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g17245	i0	85.561	436.411428571429	187	15	100	5	1	175	2622919	2623105	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	76372	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14406488	14406488	PRJNA312107_P_NODE_16812_length_178_cov_1.612403_g16646_i0	PRJNA312107	16812	178	1.612403	2.87007734	uncultured soil bacterium PBS-22	110969	Bacteria	Bacteria	191	3.06e-44	NTclustered	gi\|11611276\|emb\|AJ390462.1\|	110969	g16646	i0	85.955	56.1292134831461	178	25	100	0	1	178	193	16	Uncultured soil bacterium PBS-22 partial 16S rRNA gene	blastn	9991	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured soil bacterium PBS-22
14406589	14406589	PRJNA312107_P_NODE_25612_length_162_cov_0.920354_g25446_i0	PRJNA312107	25612	162	0.920354	1.49097348	Humisphaera borealis	2807512	Bacteria	Bacteria	180	5.93e-41	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g25446	i0	87.421	30.5185185185185	159	16	97	4	1	157	5062822	5062978	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	4944	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
14406592	14406592	PRJNA312107_P_NODE_25692_length_162_cov_0.920354_g25526_i0	PRJNA312107	25692	162	0.920354	1.49097348	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	211	2.1e-50	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g25526	i0	91.026	0.962962962962963	156	14	96	0	1	156	92786	92631	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	156	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
15680351	15680351	PRJNA312107_P_NODE_20393_length_167_cov_1.525424_g20227_i0	PRJNA312107	20393	167	1.525424	2.54745808	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g20227	i0	98.802	165.047904191617	167	2	100	0	1	167	4961310	4961144	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	27563	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
16366107	16366107	PRJNA312107_P_NODE_26053_length_162_cov_0.920354_g25887_i0	PRJNA312107	26053	162	0.920354	1.49097348	Schlesneria	656899	Bacteria	Bacteria	178	2.13e-40	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g25887	i0	86.503	38.2839506172839	163	20	100	2	1	162	1427	1588	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	6202	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
18914992	18914992	PRJNA312107_P_NODE_9315_length_235_cov_1.489247_g9149_i0	PRJNA312107	9315	235	1.489247	3.49973045	Gimesia	1649453	Bacteria	Bacteria	231	2.5199999999999997e-56	NTclustered	gi\|1712615819\|gb\|CP036277.1\|	2527978	g9149	i0	87.94	135.204255319149	199	20	84	4	39	235	2210857	2210661	Gimesia panareensis strain Pan110 chromosome, complete genome	blastn	31773	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia panareensis
19503578	19503578	PRJNA312107_P_NODE_20896_length_167_cov_0.881356_g20730_i0	PRJNA312107	20896	167	0.881356	1.47186452	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	220	3.63e-53	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g20730	i0	90.419	91.4610778443114	167	16	100	0	1	167	3456413	3456247	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	15274	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
19503581	19503581	PRJNA312107_P_NODE_21216_length_167_cov_0.830508_g21050_i0	PRJNA312107	21216	167	0.830508	1.38694836	Gemmataceae bacterium	2052164	Bacteria	Bacteria	248	1.66e-61	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g21050	i0	93.413	83.9640718562874	167	11	100	0	1	167	319537	319703	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	14022	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
19503624	19503624	PRJNA312107_P_NODE_24796_length_163_cov_0.912281_g24630_i0	PRJNA312107	24796	163	0.912281	1.48701803	Symmachiella dynata	2527995	Bacteria	Bacteria	204	3.54e-48	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g24630	i0	91.837	156.840490797546	147	11	90	1	16	162	1041148	1041293	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	25565	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
20779175	20779175	PRJNA312107_P_NODE_26317_length_162_cov_0.884956_g26151_i0	PRJNA312107	26317	162	0.884956	1.43362872	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	97.1	6.14e-16	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g26151	i0	81.452	1.53086419753086	124	18	75	5	41	162	3097439	3097319	Pirellula sp. SH-Sr6A, complete genome	blastn	248	97.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
22054088	22054088	PRJNA312107_P_NODE_15498_length_186_cov_1.058394_g15332_i0	PRJNA312107	15498	186	1.058394	1.96861284	Paludisphaera borealis	1387353	Bacteria	Bacteria	235	1.4699999999999997e-57	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g15332	i0	90.909	46.005376344086	176	15	95	1	1	176	123148	123322	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	8557	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
23329697	23329697	PRJNA312107_P_NODE_25339_length_162_cov_1.769912_g25173_i0	PRJNA312107	25339	162	1.769912	2.86725744	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	207	2.72e-49	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g25173	i0	90.446	71.5925925925926	157	15	97	0	1	157	3096866	3096710	Pirellula sp. SH-Sr6A, complete genome	blastn	11598	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
24015463	24015463	PRJNA312107_P_NODE_17019_length_177_cov_1.429688_g16853_i0	PRJNA312107	17019	177	1.429688	2.53054776	Pirellula	123	Bacteria	Bacteria	289	1.05e-73	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g16853	i0	96.045	221.937853107345	177	7	100	0	1	177	2325	2501	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	39283	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
24603601	24603601	PRJNA312107_P_NODE_14780_length_190_cov_1.397163_g14614_i0	PRJNA312107	14780	190	1.397163	2.6546097	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	272	1.15e-68	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g14614	i0	92.593	132.084210526316	189	14	99	0	1	189	3454461	3454273	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	25096	272	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
24603675	24603675	PRJNA312107_P_NODE_22980_length_165_cov_0.896552_g22814_i0	PRJNA312107	22980	165	0.896552	1.4793108	Aquisphaera giovannonii	406548	Bacteria	Bacteria	75	2.94e-9	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g22814	i0	83.133	2.18787878787879	83	12	50	2	79	160	4428109	4428190	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	361	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii

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