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

21 rows where analysis = "blastn", bioproject = "PRJNA683902" 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
1941171	1941171	PRJNA683902_S_NODE_14522_length_315_cov_18.392086_g14078_i0	PRJNA683902	14522	315	18.392086	57.9350709	Paludisphaera borealis	1387353	Bacteria	Bacteria	412	1.1699999999999996e-110	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g14078	i0	90.645	177.990476190476	310	29	98	0	1	310	121938	121629	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	56067	412	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
3216230	3216230	PRJNA683902_S_NODE_34163_length_164_cov_2.614173_g33719_i0	PRJNA683902	34163	164	2.614173	4.28724372	planctomycete str. 139	149588	Bacteria	Bacteria	254	3.5e-63	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g33719	i0	94.512	104.243902439024	164	9	100	0	1	164	1320	1483	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	17096	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
3216343	3216343	PRJNA683902_S_NODE_7403_length_644_cov_28.242175_g7015_i0	PRJNA683902	7403	644	28.242175	181.879607	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	715	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g7015	i0	87.011	122.989130434783	639	78	99	3	4	639	2583149	2582513	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	79205	715	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
3727197	3727197	PRJNA683902_S_NODE_22763_length_216_cov_5.083799_g22319_i0	PRJNA683902	22763	216	5.083799	10.98100584	Schlesneria	656899	Bacteria	Bacteria	315	2.2e-81	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g22319	i0	93.056	138.958333333333	216	14	100	1	1	216	6999460	6999246	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	30015	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
3727637	3727637	PRJNA683902_S_NODE_7063_length_676_cov_6.589984_g6688_i0	PRJNA683902	7063	676	6.589984	44.54829184	Schlesneria	656899	Bacteria	Bacteria	704	0	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g6688	i0	85.756	172.89349112426	681	79	100	11	1	676	709	42	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	116876	704	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
8318545	8318545	PRJNA683902_S_NODE_36867_length_157_cov_1.950000_g36423_i0	PRJNA683902	36867	157	1.95	3.0615	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	163	5.74e-36	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g36423	i0	85.535	12.1337579617834	159	19	100	3	1	157	7051895	7051739	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	1905	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13419270	13419270	PRJNA683902_S_NODE_27231_length_191_cov_1.227273_g26787_i0	PRJNA683902	27231	191	1.227273	2.34409143	Gemmata massiliana	1210884	Bacteria	Bacteria	298	1.91e-76	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g26787	i0	95.676	44.2931937172775	185	8	97	0	1	185	3634990	3634806	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	8460	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
13929881	13929881	PRJNA683902_S_NODE_9351_length_496_cov_4.681917_g8919_i0	PRJNA683902	9351	496	4.681917	23.22230832	Schlesneria	656899	Bacteria	Bacteria	595	1.7799999999999994e-165	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g8919	i0	88.485	290.243951612903	495	54	99	3	3	496	1783	1291	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	143961	595	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
14694111	14694111	PRJNA683902_S_NODE_11492_length_396_cov_3.562674_g11048_i0	PRJNA683902	11492	396	3.562674	14.10818904	Isosphaera pallida	128	Bacteria	Bacteria	412	1.5099999999999994e-110	NTclustered	gi\|319748837\|gb\|CP002353.1\|	575540	g11048	i0	85.464	109.212121212121	399	54	100	4	1	396	4715776	4716173	Isosphaera pallida ATCC 43644, complete genome	blastn	43248	412	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
15203861	15203861	PRJNA683902_S_NODE_16392_length_282_cov_2.922449_g15948_i0	PRJNA683902	16392	282	2.922449	8.24130618	Planctomycetota	203682	Bacteria	Bacteria	241	5.17e-59	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g15948	i0	82.609	379.124113475177	276	44	98	3	1	275	7629860	7630132	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	106913	243	0.991769547325103	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
15204307	15204307	PRJNA683902_S_NODE_35532_length_160_cov_3.544715_g35088_i0	PRJNA683902	35532	160	3.544715	5.671544	Planctomycetia	203683	Bacteria	Bacteria	261	2.0300000000000002e-65	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g35088	i0	96.815	67.675	157	4	99	1	1	156	4317368	4317524	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	10828	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17243192	17243192	PRJNA683902_S_NODE_21774_length_223_cov_3.774194_g21330_i0	PRJNA683902	21774	223	3.774194	8.41645262	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	235	1.83e-57	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g21330	i0	85.59	189.551569506726	229	27	100	3	1	223	1601973	1601745	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	42270	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
18517409	18517409	PRJNA683902_S_NODE_28095_length_186_cov_4.946309_g27651_i0	PRJNA683902	28095	186	4.946309	9.20013474	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	222	1.15e-53	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g27651	i0	88.235	166.327956989247	187	21	100	1	1	186	1157154	1157340	Planctomyces sp. SH-PL62, complete genome	blastn	30937	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19792196	19792196	PRJNA683902_S_NODE_18776_length_251_cov_2.000000_g18332_i0	PRJNA683902	18776	251	2	5.02	Candidatus Uabimicrobium helgolandensis	3095367	Bacteria	Bacteria	121	6.149999999999999e-23	NTclustered	gi\|2793194503\|gb\|CP165719.1\|	3095367	g18332	i0	88.35	17.3426294820717	103	8	40	4	97	197	51529	51429	Candidatus Uabimicrobium helgolandensis strain HlEnr_7 chromosome	blastn	4353	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium helgolandensis
20301996	20301996	PRJNA683902_S_NODE_31496_length_173_cov_1.977941_g31052_i0	PRJNA683902	31496	173	1.977941	3.42183793	root	1	Root_unresolved	Root_unresolved	315	1.68e-81	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g31052	i0	99.422	153.606936416185	173	1	100	0	1	173	3635618	3635446	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	26574	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
20302072	20302072	PRJNA683902_S_NODE_35536_length_160_cov_3.317073_g35092_i0	PRJNA683902	35536	160	3.317073	5.3073168	Bacteria	2	Bacteria	Bacteria	213	5.75e-51	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g35092	i0	90.683	251.425	161	14	100	1	1	160	7050741	7050581	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	40228	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22342415	22342415	PRJNA683902_S_NODE_10078_length_457_cov_3.488095_g9640_i0	PRJNA683902	10078	457	3.488095	15.94059415	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	457	8.039999999999999e-124	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g9640	i0	85.275	689.984682713348	455	54	98	13	1	448	1600200	1600648	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	315323	457	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
22853140	22853140	PRJNA683902_S_NODE_4678_length_1016_cov_30.620020_g4417_i0	PRJNA683902	4678	1016	30.62002	311.0994032	Bacteria	2	Bacteria	Bacteria	1064	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g4417	i0	85.714	355.001968503937	1029	123	100	21	1	1016	2583387	2584404	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	360682	1064	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
24127362	24127362	PRJNA683902_S_NODE_23359_length_212_cov_6.154286_g22915_i0	PRJNA683902	23359	212	6.154286	13.04708632	Planctomycetaceae	126	Bacteria	Bacteria	348	2.12e-91	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g22915	i0	96.226	113.316037735849	212	8	100	0	1	212	2386	2175	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	24023	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
24891317	24891317	PRJNA683902_S_NODE_14520_length_315_cov_22.543165_g14076_i0	PRJNA683902	14520	315	22.543165	71.01096975	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	411	4.2199999999999996e-110	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g14076	i0	90.221	453.066666666667	317	27	100	4	1	315	1867224	1867538	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	142716	411	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25401618	25401618	PRJNA683902_S_NODE_12880_length_353_cov_3.889241_g12436_i0	PRJNA683902	12880	353	3.889241	13.72902073	Isosphaera	127	Bacteria	Bacteria	473	6.01e-129	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g12436	i0	91.193	81.8271954674221	352	26	99	4	1	350	683	1031	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	28885	473	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida

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