metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax_phylum = "Lentisphaerota"

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_species
577885	577885	PRJNA603943_P_NODE_63721_length_245_cov_0.895349_g63529_i0	PRJNA603943	63721	245	0.895349	2.19360505	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g63529	i0	100	1.12244897959184	245	0	100	0	1	245	2523436	2523192	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	275	453	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
578013	578013	PRJNA603943_P_NODE_67821_length_242_cov_0.911243_g67629_i0	PRJNA603943	67821	242	0.911243	2.20520806	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g67629	i0	98.76	1	242	3	100	0	1	242	4735275	4735516	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	242	431	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
1853712	1853712	PRJNA603943_P_NODE_64622_length_244_cov_0.900585_g64430_i0	PRJNA603943	64622	244	0.900585	2.1974274	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g64430	i0	98.361	1	244	4	100	0	1	244	1990884	1990641	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	244	429	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
3128647	3128647	PRJNA603943_P_NODE_55663_length_250_cov_0.870056_g55471_i0	PRJNA603943	55663	250	0.870056	2.17514	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g55471	i0	99.6	1	250	1	100	0	1	250	2974744	2974495	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	250	457	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
3128787	3128787	PRJNA603943_P_NODE_60543_length_247_cov_0.885057_g60351_i0	PRJNA603943	60543	247	0.885057	2.18609079	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g60351	i0	100	31.3279352226721	247	0	100	0	1	247	1728676	1728430	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	7738	457	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
4405011	4405011	PRJNA603943_P_NODE_44284_length_278_cov_1.126829_g44092_i0	PRJNA603943	44284	278	1.126829	3.13258462	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	514	2.7199999999999996e-141	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g44092	i0	100	1	278	0	100	0	1	278	1458160	1457883	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	278	514	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
4405423	4405423	PRJNA603943_P_NODE_58844_length_248_cov_0.880000_g58652_i0	PRJNA603943	58844	248	0.88	2.1824	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g58652	i0	100	1.9758064516129	248	0	100	0	1	248	3084176	3083929	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	490	459	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
4405470	4405470	PRJNA603943_P_NODE_60484_length_247_cov_0.885057_g60292_i0	PRJNA603943	60484	247	0.885057	2.18609079	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g60292	i0	99.19	1.23481781376518	247	2	100	0	1	247	3518402	3518648	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	305	446	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
4405699	4405699	PRJNA603943_P_NODE_68484_length_242_cov_0.911243_g68292_i0	PRJNA603943	68484	242	0.911243	2.20520806	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g68292	i0	99.587	1	242	1	100	0	1	242	1223472	1223231	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	242	442	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
8230760	8230760	PRJNA603943_P_NODE_50647_length_257_cov_1.255435_g50455_i0	PRJNA603943	50647	257	1.255435	3.22646795	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g50455	i0	100	1.11284046692607	257	0	100	0	1	257	1843920	1843664	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	286	475	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
8231040	8231040	PRJNA603943_P_NODE_59827_length_247_cov_0.885057_g59635_i0	PRJNA603943	59827	247	0.885057	2.18609079	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	309	1.2e-79	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g59635	i0	89.388	0.991902834008097	245	26	99	0	2	246	491890	492134	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	245	309	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
9505595	9505595	PRJNA603943_P_NODE_39608_length_293_cov_1.050000_g39416_i0	PRJNA603943	39608	293	1.05	3.0765	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g39416	i0	100	2.80887372013652	293	0	100	0	1	293	2395751	2396043	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	823	542	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
9506269	9506269	PRJNA603943_P_NODE_62888_length_245_cov_0.895349_g62696_i0	PRJNA603943	62888	245	0.895349	2.19360505	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g62696	i0	98.776	2.26530612244898	245	3	100	0	1	245	3655435	3655191	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	555	436	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
9506378	9506378	PRJNA603943_P_NODE_66548_length_243_cov_0.905882_g66356_i0	PRJNA603943	66548	243	0.905882	2.20129326	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g66356	i0	98.765	1	243	3	100	0	1	243	3354370	3354612	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	243	433	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria		Lentisphaeria bacterium
10782201	10782201	PRJNA603943_P_NODE_64069_length_245_cov_0.866279_g63877_i0	PRJNA603943	64069	245	0.866279	2.12238355	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	435	1.88e-117	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g63877	i0	98.77	0.995918367346939	244	3	99	0	1	244	3511705	3511948	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	244	435	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
12056881	12056881	PRJNA603943_P_NODE_54510_length_250_cov_0.870056_g54318_i0	PRJNA603943	54510	250	0.870056	2.17514	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g54318	i0	99.19	0.988	247	2	99	0	1	247	1592153	1592399	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	247	446	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
12056939	12056939	PRJNA603943_P_NODE_57090_length_249_cov_0.875000_g56898_i0	PRJNA603943	57090	249	0.875	2.17875	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g56898	i0	100	1	249	0	100	0	1	249	3654350	3654598	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	249	460	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
13331863	13331863	PRJNA603943_P_NODE_60271_length_247_cov_0.885057_g60079_i0	PRJNA603943	60271	247	0.885057	2.18609079	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g60079	i0	99.595	1	247	1	100	0	1	247	1848041	1847795	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	247	451	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
13331883	13331883	PRJNA603943_P_NODE_61151_length_246_cov_0.890173_g60959_i0	PRJNA603943	61151	246	0.890173	2.18982558	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	228	3.4399999999999986e-55	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g60959	i0	83.817	0.979674796747967	241	37	98	2	3	242	1482513	1482752	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	241	228	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria		Lentisphaeria bacterium
14605947	14605947	PRJNA603943_P_NODE_33792_length_314_cov_1.278008_g33600_i0	PRJNA603943	33792	314	1.278008	4.01294512	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	575	1.4099999999999994e-159	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g33600	i0	99.682	1	314	1	100	0	1	314	2776905	2776592	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	314	575	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
14607049	14607049	PRJNA603943_P_NODE_70172_length_241_cov_0.916667_g69980_i0	PRJNA603943	70172	241	0.916667	2.20916747	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g69980	i0	99.17	1	241	2	100	0	1	241	2600903	2601143	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	241	435	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
15880649	15880649	PRJNA603943_P_NODE_58933_length_248_cov_0.880000_g58741_i0	PRJNA603943	58933	248	0.88	2.1824	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	392	1.1599999999999999e-104	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g58741	i0	95.161	21.4838709677419	248	12	100	0	1	248	3095507	3095260	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	5328	392	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
15880780	15880780	PRJNA603943_P_NODE_63373_length_245_cov_0.895349_g63181_i0	PRJNA603943	63373	245	0.895349	2.19360505	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g63181	i0	99.184	1.76734693877551	245	2	100	0	1	245	133111	133355	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	433	442	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
17155506	17155506	PRJNA603943_P_NODE_59674_length_247_cov_0.885057_g59482_i0	PRJNA603943	59674	247	0.885057	2.18609079	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g59482	i0	99.19	1	247	2	100	0	1	247	1369493	1369247	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	247	446	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
19704582	19704582	PRJNA603943_P_NODE_67216_length_243_cov_0.905882_g67024_i0	PRJNA603943	67216	243	0.905882	2.20129326	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g67024	i0	99.588	1	243	1	100	0	1	243	3092884	3093126	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	243	444	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
22254770	22254770	PRJNA603943_P_NODE_57058_length_249_cov_0.875000_g56866_i0	PRJNA603943	57058	249	0.875	2.17875	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g56866	i0	100	1	249	0	100	0	1	249	1391610	1391858	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	249	460	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
22254798	22254798	PRJNA603943_P_NODE_57958_length_248_cov_0.880000_g57766_i0	PRJNA603943	57958	248	0.88	2.1824	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g57766	i0	99.194	1.12096774193548	248	2	100	0	1	248	987600	987353	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	278	448	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
22255015	22255015	PRJNA603943_P_NODE_65578_length_244_cov_0.900585_g65386_i0	PRJNA603943	65578	244	0.900585	2.1974274	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g65386	i0	100	1	244	0	100	0	1	244	1377046	1376803	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	244	451	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
23530112	23530112	PRJNA603943_P_NODE_53959_length_251_cov_0.865169_g53767_i0	PRJNA603943	53959	251	0.865169	2.17157419	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g53767	i0	100	1.99601593625498	251	0	100	0	1	251	5188588	5188338	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	501	464	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
23530135	23530135	PRJNA603943_P_NODE_54839_length_250_cov_0.870056_g54647_i0	PRJNA603943	54839	250	0.870056	2.17514	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g54647	i0	100	1	250	0	100	0	1	250	3801004	3801253	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	250	462	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
24803812	24803812	PRJNA603943_P_NODE_53200_length_251_cov_0.865169_g53008_i0	PRJNA603943	53200	251	0.865169	2.17157419	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g53008	i0	99.602	1	251	1	100	0	1	251	2329223	2328973	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	251	459	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
25369523	25369523	PRJNA603943_P_NODE_54640_length_250_cov_0.870056_g54448_i0	PRJNA603943	54640	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	239	1.62e-58	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g54448	i0	84.274	1.988	248	35	98	2	1	246	1948226	1948471	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	497	239	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria		Lentisphaeria 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);;