metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax

14 rows where analysis = "blastn", 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
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

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