metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA395690" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA395690" 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
411416	411416	PRJNA395690_P_NODE_1101_length_744_cov_9.985612_g978_i0	PRJNA395690	1101	744	9.985612	74.29295328	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	933	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g978	i0	89.362	127.586021505376	752	66	99	10	2	744	1599284	1600030	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	94924	933	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
411458	411458	PRJNA395690_P_NODE_13621_length_220_cov_3.157895_g13469_i0	PRJNA395690	13621	220	3.157895	6.947369	Lacipirellula parvula	2650471	Bacteria	Bacteria	407	3.61e-109	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g13469	i0	100	431.05	220	0	100	0	1	220	5161933	5162152	Lacipirellula parvula PX69 DNA, complete genome	blastn	94831	407	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
2354527	2354527	PRJNA395690_P_NODE_642_length_955_cov_5.003311_g543_i0	PRJNA395690	642	955	5.003311	47.78162005	Bacteria	2	Bacteria	Bacteria	1168	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g543	i0	88.901	137.340314136126	955	97	99	7	1	950	1866232	1867182	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	131160	1168	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
2962275	2962275	PRJNA395690_P_NODE_17823_length_192_cov_2.000000_g17671_i0	PRJNA395690	17823	192	2	3.84	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	119	1.61e-22	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g17671	i0	78.431	1.0625	204	29	99	4	1	190	2297652	2297854	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	204	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2962450	2962450	PRJNA395690_P_NODE_30743_length_165_cov_0.974138_g30591_i0	PRJNA395690	30743	165	0.974138	1.6073277	Limnoglobus roseus	2598579	Bacteria	Bacteria	283	4.4899999999999995e-72	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g30591	i0	97.576	34.6909090909091	165	4	100	0	1	165	2957363	2957199	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	5724	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
4238670	4238670	PRJNA395690_P_NODE_20864_length_184_cov_2.340741_g20712_i0	PRJNA395690	20864	184	2.340741	4.30696344	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	335	1.3899999999999996e-87	NTclustered	gi\|209969263\|emb\|FM253642.1\|	120965	g20712	i0	99.457	96.5652173913043	184	1	100	0	1	184	841	1024	Uncultured planctomycetes bacterium 16S rRNA gene, clone B12-2	blastn	17768	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
6182032	6182032	PRJNA395690_P_NODE_18245_length_190_cov_3.375887_g18093_i0	PRJNA395690	18245	190	3.375887	6.4141853	Lacipirellula	2691417	Bacteria	Bacteria	340	3.1099999999999993e-89	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g18093	i0	98.947	258.189473684211	190	2	100	0	1	190	5169273	5169084	Lacipirellula limnantheis strain I41 chromosome	blastn	49056	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
6789203	6789203	PRJNA395690_P_NODE_11886_length_236_cov_1.267380_g11734_i0	PRJNA395690	11886	236	1.26738	2.9910168	Lacipirellula parvula	2650471	Bacteria	Bacteria	431	2.33e-116	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g11734	i0	99.576	206.618644067797	236	1	100	0	1	236	5163457	5163222	Lacipirellula parvula PX69 DNA, complete genome	blastn	48762	431	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
8064809	8064809	PRJNA395690_P_NODE_13987_length_217_cov_2.672619_g13835_i0	PRJNA395690	13987	217	2.672619	5.79958323	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	351	1.69e-92	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g13835	i0	95.853	117.571428571429	217	9	100	0	1	217	558522	558738	Gemmata sp. SH-PL17, complete genome	blastn	25513	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
8064827	8064827	PRJNA395690_P_NODE_14887_length_211_cov_0.944444_g14735_i0	PRJNA395690	14887	211	0.944444	1.99277684	Urbifossiella limnaea	2528023	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g14735	i0	100	0.270142180094787	29	0	14	0	132	160	5504907	5504879	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	57	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
8064900	8064900	PRJNA395690_P_NODE_19747_length_187_cov_1.471014_g19595_i0	PRJNA395690	19747	187	1.471014	2.75079618	Lacipirellula parvula	2650471	Bacteria	Bacteria	281	1.8800000000000002e-71	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g19595	i0	94.054	0.989304812834225	185	11	99	0	2	186	5261555	5261371	Lacipirellula parvula PX69 DNA, complete genome	blastn	185	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
9339657	9339657	PRJNA395690_P_NODE_14588_length_213_cov_1.243902_g14436_i0	PRJNA395690	14588	213	1.243902	2.64951126	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	244	2.88e-60	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g14436	i0	87.324	63.6854460093897	213	27	100	0	1	213	7050741	7050529	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	13565	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9339812	9339812	PRJNA395690_P_NODE_26168_length_172_cov_1.243902_g26016_i0	PRJNA395690	26168	172	1.243902	2.13951144	Isosphaera pallida	128	Bacteria	Bacteria	158	2.9699999999999993e-34	NTclustered	gi\|34596597\|gb\|AY371118.1\|	575540	g26016	i0	95	53.7906976744186	100	5	58	0	3	102	142	241	Isosphaera pallida RNase P RNA subunit (rnpB) gene, partial sequence	blastn	9252	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
14440323	14440323	PRJNA395690_P_NODE_1312_length_683_cov_10.059937_g978_i1	PRJNA395690	1312	683	10.059937	68.70936971	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	944	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g978	i1	91.594	130.742313323572	690	48	100	8	1	683	1600030	1599344	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	89297	944	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
15106658	15106658	PRJNA395690_P_NODE_16492_length_200_cov_1.013245_g16340_i0	PRJNA395690	16492	200	1.013245	2.02649	Gemmata	113	Bacteria	Bacteria	316	5.58e-82	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g16340	i0	96.373	116.775	193	6	96	1	1	192	3635018	3634826	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	23355	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
15106783	15106783	PRJNA395690_P_NODE_3532_length_418_cov_2.214092_g3383_i0	PRJNA395690	3532	418	2.214092	9.25490456	Gemmata	113	Bacteria	Bacteria	710	0	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g3383	i0	97.375	168.248803827751	419	8	100	3	1	418	3634055	3633639	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	70328	710	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
15714147	15714147	PRJNA395690_P_NODE_12213_length_233_cov_1.527174_g12061_i0	PRJNA395690	12213	233	1.527174	3.55831542	Aquisphaera giovannonii	406548	Bacteria	Bacteria	355	1.42e-93	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g12061	i0	94.043	104.236051502146	235	12	100	2	1	233	5179838	5180072	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	24287	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
16381359	16381359	PRJNA395690_P_NODE_16573_length_199_cov_3.006667_g16421_i0	PRJNA395690	16573	199	3.006667	5.98326733	Gemmata	113	Bacteria	Bacteria	368	1.51e-97	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g16421	i0	100	165.130653266332	199	0	100	0	1	199	3635456	3635654	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	32861	368	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
18263233	18263233	PRJNA395690_P_NODE_20715_length_185_cov_1.286765_g20563_i0	PRJNA395690	20715	185	1.286765	2.38051525	Lacipirellula parvula	2650471	Bacteria	Bacteria	243	8.73e-60	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g20563	i0	90.323	1.00540540540541	186	16	100	2	1	185	1245355	1245171	Lacipirellula parvula PX69 DNA, complete genome	blastn	186	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
18930470	18930470	PRJNA395690_P_NODE_235_length_1604_cov_6.285531_g185_i0	PRJNA395690	235	1604	6.285531	100.81991724	Bacteria	2	Bacteria	Bacteria	1736	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g185	i0	86.502	244.363466334165	1615	177	100	31	1	1604	1866225	1867809	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	391959	1736	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
19537768	19537768	PRJNA395690_P_NODE_9156_length_269_cov_1.313636_g9004_i0	PRJNA395690	9156	269	1.313636	3.53368084	Gemmata-like str. JW3-8s0	121116	Bacteria	Bacteria	420	5.86e-113	NTclustered	gi\|10436088\|gb\|AF239694.1\|AF239694	121116	g9004	i0	94.815	110.159851301115	270	12	100	2	1	269	1205	1473	Gemmata-like str. JW3-8s0 16S ribosomal RNA gene, partial sequence	blastn	29633	420	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Gemmata-like str. JW3-8s0
20813500	20813500	PRJNA395690_P_NODE_9257_length_267_cov_1.839450_g9105_i0	PRJNA395690	9257	267	1.83945	4.9113315	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	320	6.07e-83	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g9105	i0	88.846	161.722846441948	260	29	97	0	1	260	1156126	1156385	Planctomyces sp. SH-PL62, complete genome	blastn	43180	320	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
23363670	23363670	PRJNA395690_P_NODE_20079_length_186_cov_2.058394_g19927_i0	PRJNA395690	20079	186	2.058394	3.82861284	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	305	1.11e-78	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g19927	i0	96.237	74.6182795698925	186	7	100	0	1	186	4955918	4955733	Planctomyces sp. SH-PL14, complete genome	blastn	13879	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
24638210	24638210	PRJNA395690_P_NODE_6480_length_316_cov_2.086142_g6329_i0	PRJNA395690	6480	316	2.086142	6.59220872	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	451	2.5e-122	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g6329	i0	92.405	612.253164556962	316	24	100	0	1	316	1868931	1868616	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	193472	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;