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

19 rows where analysis = "blastn", bioproject = "PRJNA414225" and tax_clade = "PVC group"

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
418881	418881	PRJNA414225_P_NODE_18401_length_189_cov_1.121429_g18314_i0	PRJNA414225	18401	189	1.121429	2.11950081	uncultured Planctomycetales bacterium	100371	Bacteria	Bacteria	333	5.169999999999999e-87	NTclustered	gi\|2676011387\|gb\|PP344119.1\|	100371	g18314	i0	98.413	96.9417989417989	189	3	100	0	1	189	136	324	Uncultured Planctomycetales bacterium clone OTU887_spo782 16S ribosomal RNA gene, partial sequence	blastn	18322	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
4246004	4246004	PRJNA414225_P_NODE_47684_length_167_cov_1.203390_g47597_i0	PRJNA414225	47684	167	1.20339	2.0096613	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	169	1.33e-37	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g47597	i0	86.755	1.73652694610778	151	20	90	0	1	151	1465638	1465488	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	290	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
4246045	4246045	PRJNA414225_P_NODE_65744_length_165_cov_0.879310_g65657_i0	PRJNA414225	65744	165	0.87931	1.4508615	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	128	2.23e-25	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g65657	i0	85.484	3.38787878787879	124	17	75	1	15	137	3506049	3506172	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	559	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
6796650	6796650	PRJNA414225_P_NODE_2786_length_278_cov_2.349345_g2699_i0	PRJNA414225	2786	278	2.349345	6.5311791	Gemmataceae bacterium	2052164	Bacteria	Bacteria	355	1.7399999999999997e-93	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g2699	i0	89.892	183.446043165468	277	26	99	2	1	277	320005	319731	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	50998	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
6796711	6796711	PRJNA414225_P_NODE_5986_length_234_cov_1.654054_g5899_i0	PRJNA414225	5986	234	1.654054	3.87048636	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	182	2.56e-41	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5899	i0	81.197	77.7564102564103	234	36	97	8	1	226	7051523	7051756	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	18195	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8072275	8072275	PRJNA414225_P_NODE_70307_length_164_cov_0.886957_g70220_i0	PRJNA414225	70307	164	0.886957	1.45460948	Adhaeretor mobilis	1930276	Bacteria	Bacteria	132	1.71e-26	NTclustered	gi\|1712449852\|gb\|CP036263.1\|	1930276	g70220	i0	82.993	0.896341463414634	147	23	89	2	7	152	4214176	4214321	Adhaeretor mobilis strain HG15A2 chromosome, complete genome	blastn	147	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
8736061	8736061	PRJNA414225_P_NODE_707_length_489_cov_3.981818_g624_i0	PRJNA414225	707	489	3.981818	19.47109002	Gemmata	113	Bacteria	Bacteria	555	2.979999999999999e-153	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g624	i0	87.373	319.566462167689	491	53	99	8	1	487	3633374	3633859	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	156268	556	0.998201438848921	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
10622877	10622877	PRJNA414225_P_NODE_729_length_481_cov_3.534722_g646_i0	PRJNA414225	729	481	3.534722	17.00201282	Humisphaera borealis	2807512	Bacteria	Bacteria	453	1.1e-122	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g646	i0	83.918	175.370062370062	485	66	99	10	3	481	5063163	5062685	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	84353	453	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
11897864	11897864	PRJNA414225_P_NODE_81930_length_163_cov_0.894737_g81843_i0	PRJNA414225	81930	163	0.894737	1.45842131	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	274	2.66e-69	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g81843	i0	96.933	139.527607361963	163	5	100	0	1	163	2622488	2622650	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	22743	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13172704	13172704	PRJNA414225_P_NODE_63651_length_165_cov_0.879310_g63564_i0	PRJNA414225	63651	165	0.87931	1.4508615	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	143	7.96e-30	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g63564	i0	83.333	2.07878787878788	156	24	94	2	1	155	1578604	1578450	Lacipirellula limnantheis strain I41 chromosome	blastn	343	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
14447796	14447796	PRJNA414225_P_NODE_4072_length_254_cov_1.492683_g3985_i0	PRJNA414225	4072	254	1.492683	3.79141482	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	326	1.23e-84	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g3985	i0	90.079	519.610236220472	252	23	98	2	5	254	4959592	4959843	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	131981	326	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
14447871	14447871	PRJNA414225_P_NODE_74492_length_164_cov_0.886957_g74405_i0	PRJNA414225	74492	164	0.886957	1.45460948	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	82.4	1.75e-11	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g74405	i0	94.34	4.32317073170732	53	3	32	0	94	146	1915802	1915750	Planctomyces sp. SH-PL14, complete genome	blastn	709	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
15110853	15110853	PRJNA414225_P_NODE_3892_length_256_cov_6.869565_g3805_i0	PRJNA414225	3892	256	6.869565	17.5860864	Humisphaera	2807511	Bacteria	Bacteria	226	1.3e-54	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g3805	i0	83.525	394.01171875	261	23	95	13	1	243	5065253	5065511	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	100867	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
16996447	16996447	PRJNA414225_P_NODE_77714_length_163_cov_0.894737_g77627_i0	PRJNA414225	77714	163	0.894737	1.45842131	Gemmataceae bacterium	2052164	Bacteria	Bacteria	265	1.6e-66	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g77627	i0	98.026	0.932515337423313	152	3	93	0	12	163	406173	406324	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	152	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
19544757	19544757	PRJNA414225_P_NODE_52476_length_167_cov_0.864407_g52389_i0	PRJNA414225	52476	167	0.864407	1.44355969	Isosphaera pallida	128	Bacteria	Bacteria	198	1.7e-46	NTclustered	gi\|319748837\|gb\|CP002353.1\|	575540	g52389	i0	88.024	1	167	20	100	0	1	167	3522852	3523018	Isosphaera pallida ATCC 43644, complete genome	blastn	167	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
20209354	20209354	PRJNA414225_P_NODE_53596_length_166_cov_2.452991_g53509_i0	PRJNA414225	53596	166	2.452991	4.07196506	Gimesia	1649453	Bacteria	Bacteria	115	1.75e-21	NTclustered	gi\|1712472787\|gb\|CP036266.1\|	2605989	g53509	i0	80.255	3.91566265060241	157	27	93	4	4	158	5982806	5982652	Gimesia chilikensis strain HG66A1 chromosome	blastn	650	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia chilikensis
20820590	20820590	PRJNA414225_P_NODE_2557_length_284_cov_6.119149_g2470_i0	PRJNA414225	2557	284	6.119149	17.37838316	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	416	8.069999999999999e-112	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g2470	i0	93.286	291.278169014084	283	17	99	2	2	284	4961693	4961413	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	82723	416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
22095364	22095364	PRJNA414225_P_NODE_518_length_573_cov_1.931298_g438_i0	PRJNA414225	518	573	1.931298	11.06633754	Humisphaera borealis	2807512	Bacteria	Bacteria	254	1.44e-62	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g438	i0	85.271	23.9389179755672	258	25	76	2	1	245	5063142	5063399	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	13717	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
24034870	24034870	PRJNA414225_P_NODE_40079_length_171_cov_2.508197_g39992_i0	PRJNA414225	40079	171	2.508197	4.28901687	Gemmata	113	Bacteria	Bacteria	285	1.3e-72	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g39992	i0	97.041	162.859649122807	169	5	99	0	1	169	934	766	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	27849	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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