metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA640143" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA640143" 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
609594	609594	PRJNA640143_S_NODE_11161_length_258_cov_43.420814_g10951_i0	PRJNA640143	11161	258	43.420814	112.02570012	Schlesneria sp. DSM 10557	3044399	Bacteria	Bacteria	326	1.25e-84	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g10951	i0	95.146	115.503875968992	206	10	80	0	38	243	4526365	4526570	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	29800	326	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
609671	609671	PRJNA640143_S_NODE_14401_length_229_cov_9.906250_g14191_i0	PRJNA640143	14401	229	9.90625	22.6853125	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	261	3.12e-65	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g14191	i0	90.769	57.9344978165939	195	18	85	0	1	195	7050400	7050206	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	13267	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1885829	1885829	PRJNA640143_S_NODE_11862_length_251_cov_12.107477_g11652_i0	PRJNA640143	11862	251	12.107477	30.38976727	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	195	3.57e-45	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g11652	i0	82.96	442.681274900398	223	30	88	7	1	221	1066116	1066332	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	111113	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
1885883	1885883	PRJNA640143_S_NODE_13922_length_233_cov_3.637755_g13712_i0	PRJNA640143	13922	233	3.637755	8.47596915	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	219	1.94e-52	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g13712	i0	88.827	37.931330472103	179	19	76	1	34	211	3833600	3833422	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	8838	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1885930	1885930	PRJNA640143_S_NODE_16102_length_217_cov_5.477778_g15892_i0	PRJNA640143	16102	217	5.477778	11.88677826	Rhodopirellula sp. P2	2127060	Bacteria	Bacteria	206	1.3899999999999998e-48	NTclustered	gi\|2447573959\|gb\|CP118225.1\|	2127060	g15892	i0	87.709	7.7926267281106	179	19	82	3	1	179	1834301	1834126	Rhodopirellula sp. P2 chromosome, complete genome	blastn	1691	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp. P2
3161005	3161005	PRJNA640143_S_NODE_29723_length_159_cov_1.852459_g29513_i0	PRJNA640143	29723	159	1.852459	2.94540981	Roseimaritima multifibrata	1930274	Bacteria	Bacteria	174	2.69e-39	NTclustered	gi\|1712444166\|gb\|CP036262.1\|	1930274	g29513	i0	86.747	10.7610062893082	166	10	100	8	1	159	5114675	5114835	Roseimaritima multifibrata strain FF011L chromosome, complete genome	blastn	1711	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima multifibrata
4437513	4437513	PRJNA640143_S_NODE_17664_length_208_cov_3.257310_g17454_i0	PRJNA640143	17664	208	3.25731	6.7752048	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	248	2.16e-61	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g17454	i0	90.426	24.8798076923077	188	18	90	0	18	205	2001607	2001794	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	5175	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8262896	8262896	PRJNA640143_S_NODE_12387_length_246_cov_46.282297_g12177_i0	PRJNA640143	12387	246	46.282297	113.85445062	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	270	5.639999999999999e-68	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g12177	i0	89.952	65.6341463414634	209	21	85	0	38	246	7631082	7630874	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	16146	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
9538203	9538203	PRJNA640143_S_NODE_12588_length_244_cov_35.618357_g12378_i0	PRJNA640143	12588	244	35.618357	86.90879108	Aureliella sp.	2795609	Bacteria	Bacteria	224	4.4099999999999997e-54	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g12378	i0	86.473	69.4426229508197	207	24	84	4	4	208	5640474	5640678	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	16944	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
9538595	9538595	PRJNA640143_S_NODE_29428_length_160_cov_1.674797_g29218_i0	PRJNA640143	29428	160	1.674797	2.6796752	Humisphaera borealis	2807512	Bacteria	Bacteria	117	4.64e-22	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g29218	i0	80.368	4.2125	163	25	99	7	2	160	5062873	5062714	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	674	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
10814061	10814061	PRJNA640143_S_NODE_20409_length_194_cov_13.171975_g20199_i0	PRJNA640143	20409	194	13.171975	25.5536315	Gemmata massiliana	1210884	Bacteria	Bacteria	237	4.31e-58	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g20199	i0	94.194	52.479381443299	155	9	80	0	2	156	3633509	3633355	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	10181	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
13363820	13363820	PRJNA640143_S_NODE_12611_length_244_cov_4.990338_g12401_i0	PRJNA640143	12611	244	4.990338	12.17642472	Pirellulales bacterium	2715253	Bacteria	Bacteria	169	2.09e-37	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g12401	i0	81.773	5.10655737704918	203	35	82	2	10	210	313048	312846	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	1246	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
13363863	13363863	PRJNA640143_S_NODE_14111_length_232_cov_1.225641_g13901_i0	PRJNA640143	14111	232	1.225641	2.84348712	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	315	2.4e-81	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g13901	i0	91.703	43.2801724137931	229	16	98	3	1	228	1599904	1600130	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	10041	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
14638871	14638871	PRJNA640143_S_NODE_25772_length_174_cov_1.357664_g25562_i0	PRJNA640143	25772	174	1.357664	2.36233536	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	294	2.1999999999999998e-75	NTclustered	gi\|134020509\|gb\|EF019085.1\|	120965	g25562	i0	97.126	99.7356321839081	174	5	100	0	1	174	781	608	Uncultured planctomycete clone Amb_16S_1677 16S ribosomal RNA gene, partial sequence	blastn	17354	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14638952	14638952	PRJNA640143_S_NODE_30272_length_157_cov_2.116667_g30062_i0	PRJNA640143	30272	157	2.116667	3.32316719	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	128	2.09e-25	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g30062	i0	81.707	64.343949044586	164	21	100	8	1	157	1830945	1831106	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	10102	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
15912915	15912915	PRJNA640143_S_NODE_29033_length_161_cov_3.443548_g28823_i0	PRJNA640143	29033	161	3.443548	5.54411228	Congregicoccus parvus	3081749	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g28823	i0	92.308	0.242236024844721	39	3	24	0	99	137	4161834	4161872	Opitutales bacterium ASA1 DNA, complete genome	blastn	39	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
17187571	17187571	PRJNA640143_S_NODE_11474_length_255_cov_7.458716_g11264_i0	PRJNA640143	11474	255	7.458716	19.0197258	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	135	2.24e-27	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g11264	i0	80.105	1.49803921568627	191	30	74	5	66	253	1845337	1845152	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	382	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
17187820	17187820	PRJNA640143_S_NODE_21894_length_188_cov_2.350993_g21684_i0	PRJNA640143	21894	188	2.350993	4.41986684	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	326	8.6e-85	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g21684	i0	97.872	134.212765957447	188	4	100	0	1	188	5093772	5093585	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	25232	326	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
17188080	17188080	PRJNA640143_S_NODE_4114_length_401_cov_5.337912_g3912_i0	PRJNA640143	4114	401	5.337912	21.40502712	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	381	4.319999999999999e-101	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3912	i0	85.714	78.2693266832918	378	35	91	17	1	365	655032	655403	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	31386	381	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19736566	19736566	PRJNA640143_S_NODE_18996_length_201_cov_3.091463_g18786_i0	PRJNA640143	18996	201	3.091463	6.21384063	Aureliella helgolandensis	2527968	Bacteria	Bacteria	219	1.6299999999999999e-52	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g18786	i0	90.909	103.805970149254	165	12	82	3	37	200	6998828	6998990	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	20865	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
21012020	21012020	PRJNA640143_S_NODE_11157_length_258_cov_54.366516_g10947_i0	PRJNA640143	11157	258	54.366516	140.26561128	Aureliella helgolandensis	2527968	Bacteria	Bacteria	230	1.0099999999999995e-55	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g10947	i0	86.893	72.8527131782946	206	25	79	2	37	240	6998803	6999008	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	18796	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
22287282	22287282	PRJNA640143_S_NODE_6058_length_338_cov_2.747508_g5848_i0	PRJNA640143	6058	338	2.747508	9.28657704	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	431	3.509999999999999e-116	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g5848	i0	90.663	159.301775147929	332	20	95	5	2	323	5936374	5936704	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	53844	431	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae 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);;