metadata: contig_metadata: 25 rows where bioproject = "PRJNA641707" and tax

25 rows where bioproject = "PRJNA641707" 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_family	tax_species
611216	611216	PRJNA641707_P_NODE_117801_length_245_cov_12.520408_g115138_i0	PRJNA641707	117801	245	12.520408	30.6749996	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	156	1.64e-33	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g115138	i0	96.774	2.65714285714286	93	3	38	0	7	99	949492	949400	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	651	156	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
1890238	1890238	PRJNA641707_P_NODE_242182_length_185_cov_8.654412_g239519_i0	PRJNA641707	242182	185	8.654412	16.0106622	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	289	1.11e-73	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g239519	i0	95.135	32.1081081081081	185	6	99	3	2	185	3113440	3113622	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	5940	289	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
3166468	3166468	PRJNA641707_P_NODE_306363_length_162_cov_8.752212_g303700_i0	PRJNA641707	306363	162	8.752212	14.17858344	Victivallaceae bacterium	2793042	Bacteria	Bacteria	169	1.28e-37	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g303700	i0	86.364	96.2160493827161	154	21	95	0	9	162	1447261	1447414	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	15587	169	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallaceae bacterium
4439128	4439128	PRJNA641707_P_NODE_128384_length_244_cov_7.923077_g125721_i0	PRJNA641707	128384	244	7.923077	19.33230788	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	60.2	1.32e-4	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g125721	i0	94.737	0.155737704918033	38	2	16	0	56	93	3004689	3004652	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	38	60.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium CCUG 44730
4443042	4443042	PRJNA641707_P_NODE_299524_length_164_cov_6.469565_g296861_i0	PRJNA641707	299524	164	6.469565	10.6100866	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	121	3.7e-23	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g296861	i0	84.127	78.0975609756098	126	18	76	2	6	130	2963898	2964022	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	12808	121	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium CCUG 44730
7534593	7534593	PRJNA641707_P_NODE_195586_length_198_cov_5.469799_g192923_i0	PRJNA641707	195586	198	5.469799	10.83020202	Bacteria	2	Bacteria	Bacteria	115	2.16e-21	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g192923	i0	94.595	64.030303030303	74	4	37	0	29	102	2382820	2382893	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	12678	115	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerae bacterium WC36
9540824	9540824	PRJNA641707_P_NODE_16828_length_530_cov_8.162162_g14427_i0	PRJNA641707	16828	530	8.162162	43.2594586	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	189	3.8e-43	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g14427	i0	95.763	41.4056603773585	118	4	77	1	316	432	2341277	2341160	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	21945	189	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium CCUG 44730
13910234	13910234	PRJNA641707_P_NODE_143811_length_240_cov_14.549738_g141148_i0	PRJNA641707	143811	240	14.549738	34.9193712	Bacteria	2	Bacteria	Bacteria	174	4.42e-39	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g141148	i0	98	31.2041666666667	100	2	82	0	2	101	1133946	1134045	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	7489	174	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
18469191	18469191	PRJNA641707_P_NODE_64975_length_262_cov_6.544601_g62312_i0	PRJNA641707	64975	262	6.544601	17.14685462	Victivallaceae bacterium	2793042	Bacteria	Bacteria	132	2.98e-26	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g62312	i0	88.991	145.137404580153	109	8	42	4	145	253	1447201	1447097	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	38026	132	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallaceae bacterium
20284744	20284744	PRJNA641707_P_NODE_94756_length_246_cov_4.969543_g92093_i0	PRJNA641707	94756	246	4.969543	12.22507578	Pseudomonadati	3379134	Bacteria	Bacteria	121	6.01e-23	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g92093	i0	88.889	110.20325203252	99	10	40	1	147	244	2340534	2340436	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	27110	122	0.991803278688525	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium CCUG 44730
21014290	21014290	PRJNA641707_P_NODE_149457_length_238_cov_2.873016_g146794_i0	PRJNA641707	149457	238	2.873016	6.83777808	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	93.5	1.26e-14	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g146794	i0	90.141	8.28151260504202	71	7	32	0	28	98	873262	873192	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	1971	93.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium CCUG 44730
21019405	21019405	PRJNA641707_P_NODE_66937_length_257_cov_14.115385_g64274_i0	PRJNA641707	66937	257	14.115385	36.27653945	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	209	1.31e-49	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g64274	i0	88.889	122.785992217899	171	17	99	2	3	172	950606	950775	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	31556	209	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
22289925	22289925	PRJNA641707_P_NODE_192138_length_198_cov_11.221477_g189475_i0	PRJNA641707	192138	198	11.221477	22.21852446	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	80.5	1.01e-15	NR	NLF16927.1	1932692	g189475	i0	51.2	1.3030303030303	86	17	92.4	1	12	194	90	175	NLF16927.1 DEAD/DEAH box helicase family protein [Lentisphaerota bacterium]	diamond	258	80.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
22293039	22293039	PRJNA641707_P_NODE_325218_length_156_cov_3.355140_g322555_i0	PRJNA641707	325218	156	3.35514	5.2340184	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	198	1.56e-46	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g322555	i0	91.667	36.5897435897436	144	11	92	1	2	145	2341393	2341251	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	5708	198	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium CCUG 44730
24838442	24838442	PRJNA641707_P_NODE_158040_length_219_cov_7.364706_g155377_i0	PRJNA641707	158040	219	7.364706	16.12870614	Victivallaceae bacterium	2793042	Bacteria	Bacteria	167	6.6299999999999994e-37	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g155377	i0	87.5	324.821917808219	144	18	66	0	41	184	1448355	1448212	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	71136	167	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallaceae bacterium
26796261	26796261	PRJNA641707_P_NODE_112581_length_246_cov_2.507614_g109918_i0	PRJNA641707	112581	246	2.507614	6.16873044	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	95.9	7.6e-21	NR	MEI6055088.1	1932692	g109918	i0	57	1.92682926829268	79	26	96.3	1	9	245	185	255	MEI6055088.1 TIM-barrel domain-containing protein [Lentisphaerota bacterium]	diamond	474	95.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
27143988	27143988	PRJNA641707_P_NODE_52042_length_298_cov_5.971888_g49384_i0	PRJNA641707	52042	298	5.971888	17.79622624	Victivallales bacterium	2212475	Bacteria	Bacteria	57.4	5.23e-7	NR	HJO91876.1	2212475	g49384	i0	29.1	1.59060402684564	158	46	92.6	1	295	20	232	389	HJO91876.1 hypothetical protein [Victivallales bacterium]	diamond	474	57.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
27428955	27428955	PRJNA641707_P_NODE_12943_length_601_cov_4.619565_g10740_i0	PRJNA641707	12943	601	4.619565	27.76358565	Victivallales bacterium	2212475	Bacteria	Bacteria	57.4	9.23e-6	NR	HJO91876.1	2212475	g10740	i0	34.8	0.444259567387687	89	53	44.4	2	317	583	19	102	HJO91876.1 hypothetical protein [Victivallales bacterium]	diamond	267	57.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
27681690	27681690	PRJNA641707_P_NODE_231524_length_189_cov_11.385714_g228861_i0	PRJNA641707	231524	189	11.385714	21.51899946	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	119	3.36e-30	NR	MBE6362191.1	1932692	g228861	i0	88.7	3.93650793650794	62	7	98.4	0	186	1	186	247	MBE6362191.1 trigger factor [Lentisphaerota bacterium]	diamond	744	119	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
27725693	27725693	PRJNA641707_P_NODE_187684_length_199_cov_5.866667_g185021_i0	PRJNA641707	187684	199	5.866667	11.67466733	PVC group	1783257	Bacteria	Bacteria	72	9.92e-13	NR	MBT3379166.1	1932692	g185021	i0	50	31.7185929648241	72	27	95	1	190	2	271	342	MBT3379166.1 F0F1 ATP synthase subunit alpha [Lentisphaerota bacterium]	diamond	6312	72.4	0.994475138121547	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
28628818	28628818	PRJNA641707_P_NODE_26727_length_420_cov_5.495957_g24135_i0	PRJNA641707	26727	420	5.495957	23.0830194	Victivallales bacterium	2212475	Bacteria	Bacteria	57.4	2.02e-6	NR	HJO91876.1	2212475	g24135	i0	34.8	0.635714285714286	89	53	63.6	2	285	19	19	102	HJO91876.1 hypothetical protein [Victivallales bacterium]	diamond	267	57.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
29070758	29070758	PRJNA641707_P_NODE_147348_length_239_cov_7.615789_g144685_i0	PRJNA641707	147348	239	7.615789	18.20173571	Victivallales bacterium	2212475	Bacteria	Bacteria	47.8	6.12e-4	NR	HJO91876.1	2212475	g144685	i0	38.4	0.916317991631799	73	41	87.9	2	5	214	143	214	HJO91876.1 hypothetical protein [Victivallales bacterium]	diamond	219	47.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
29638643	29638643	PRJNA641707_P_NODE_285750_length_168_cov_5.394958_g283087_i0	PRJNA641707	285750	168	5.394958	9.06352944	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	60.1	9.43e-9	NR	NQT94315.1	1932692	g283087	i0	60.4	0.857142857142857	48	19	85.7	0	149	6	220	267	NQT94315.1 sulfatase-like hydrolase/transferase [Lentisphaerota bacterium]	diamond	144	60.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
29796703	29796703	PRJNA641707_P_NODE_255431_length_180_cov_3.244275_g252768_i0	PRJNA641707	255431	180	3.244275	5.839695	Victivallales bacterium	2212475	Bacteria	Bacteria	47	5.3e-4	NR	HJO91876.1	2212475	g252768	i0	46.9	0.816666666666667	49	21	73.3	2	7	138	232	280	HJO91876.1 hypothetical protein [Victivallales bacterium]	diamond	147	47	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
31218202	31218202	PRJNA641707_P_NODE_252935_length_181_cov_3.810606_g250272_i0	PRJNA641707	252935	181	3.810606	6.89719686	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	63.9	5.4e-10	NR	MCJ8331776.1	2053569	g250272	i0	49.2	2.93370165745856	59	30	97.8	0	177	1	52	110	MCJ8331776.1 protein kinase [Lentisphaeria bacterium]	diamond	531	63.9	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);;