metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1088503" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1088503" and tax_clade = "FCB 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
194536	194536	PRJNA1088503_P_NODE_10661_length_174_cov_2.241379_g10289_i0	PRJNA1088503	10661	174	2.241379	3.89999946	Cloacibacterium caeni	2004710	Bacteria	Bacteria	305	1.02e-78	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g10289	i0	98.276	2	174	3	100	0	1	174	692669	692496	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	348	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
1469065	1469065	PRJNA1088503_P_NODE_10022_length_190_cov_133.273292_g9650_i0	PRJNA1088503	10022	190	133.273292	253.2192548	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	287	4.11e-73	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g9650	i0	98.182	1.73684210526316	165	2	87	1	1	165	959004	958841	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	330	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
1469105	1469105	PRJNA1088503_P_NODE_4602_length_393_cov_28123.673077_g4239_i0	PRJNA1088503	4602	393	28123.673077	110526.03519261	Chryseobacterium oryzae	2929799	Bacteria	Bacteria	584	2.999999999999999e-162	NTclustered	gi\|2216362202\|gb\|CP094529.1\|	2929799	g4239	i0	97.647	10.4554707379135	340	8	87	0	19	358	1038673	1038334	Chryseobacterium oryzae strain ADR-1 chromosome, complete genome	blastn	4109	584	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium oryzae
4021176	4021176	PRJNA1088503_P_NODE_8704_length_224_cov_48352.687179_g8332_i0	PRJNA1088503	8704	224	48352.687179	108310.01928096	Cloacibacterium normanense	237258	Bacteria	Bacteria	289	1.39e-73	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g8332	i0	93.782	3.41517857142857	193	10	85	2	34	224	2641985	2641793	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	765	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
5297343	5297343	PRJNA1088503_P_NODE_8665_length_225_cov_54136.341837_g8293_i0	PRJNA1088503	8665	225	54136.341837	121806.76913325	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	78.7	3.3e-10	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g8293	i0	94.231	0.231111111111111	52	2	23	1	10	61	2317831	2317881	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	52	78.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
6572355	6572355	PRJNA1088503_P_NODE_10086_length_188_cov_117.622642_g9714_i0	PRJNA1088503	10086	188	117.622642	221.13056696	Cloacibacterium normanense	237258	Bacteria	Bacteria	287	4.06e-73	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g9714	i0	98.765	3.4468085106383	162	1	86	1	27	188	866702	866542	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	648	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
9945694	9945694	PRJNA1088503_P_NODE_9568_length_202_cov_35483.375723_g9196_i0	PRJNA1088503	9568	202	35483.375723	71676.41896046	Cloacibacterium	501783	Bacteria	Bacteria	265	2.08e-66	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g9196	i0	94.253	4.74257425742574	174	9	86	1	30	202	2648692	2648519	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	958	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
12948204	12948204	PRJNA1088503_P_NODE_5251_length_354_cov_32514.449231_g4879_i0	PRJNA1088503	5251	354	32514.449231	115101.15027774	Cloacibacterium normanense	237258	Bacteria	Bacteria	551	2.709999999999999e-152	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g4879	i0	97.523	3.65536723163842	323	7	91	1	33	354	2251347	2251669	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1294	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
14223227	14223227	PRJNA1088503_P_NODE_10712_length_172_cov_1780.937063_g10340_i0	PRJNA1088503	10712	172	1780.937063	3063.21174836	Cloacibacterium normanense	237258	Bacteria	Bacteria	250	4.7699999999999995e-62	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g10340	i0	97.931	2.52325581395349	145	2	84	1	1	144	853255	853399	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	434	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
14223230	14223230	PRJNA1088503_P_NODE_1292_length_797_cov_11461.386719_g1142_i0	PRJNA1088503	1292	797	11461.386719	91347.25215043	Flavobacterium eburneipallidum	3003263	Bacteria	Bacteria	575	3.839999999999999e-159	NTclustered	gi\|2493280413\|gb\|CP114291.2\|	3003263	g1142	i0	83.654	2.43789209535759	624	89	77	10	42	657	2393869	2393251	Flavobacterium eburneipallidum strain IMCC36793 chromosome, complete genome	blastn	1943	575	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium eburneipallidum
14223243	14223243	PRJNA1088503_P_NODE_2812_length_541_cov_18135.347656_g2525_i0	PRJNA1088503	2812	541	18135.347656	98112.23081896	Cloacibacterium caeni	2004710	Bacteria	Bacteria	872	0	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g2525	i0	97.642	7.71349353049908	509	11	94	1	34	541	1492225	1492733	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	4173	872	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
16771533	16771533	PRJNA1088503_P_NODE_7594_length_259_cov_38237.052174_g7222_i0	PRJNA1088503	7594	259	38237.052174	99033.96513066	Cloacibacterium caeni	2004710	Bacteria	Bacteria	359	1.24e-94	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g7222	i0	95.536	2.54826254826255	224	10	86	0	3	226	2586549	2586772	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	660	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
21419521	21419521	PRJNA1088503_P_NODE_10017_length_190_cov_1494.652174_g9645_i0	PRJNA1088503	10017	190	1494.652174	2839.8391306	Flavobacterium	237	Bacteria	Bacteria	243	9.02e-60	NTclustered	gi\|2447257787\|gb\|CP092822.1\|	1454066	g9645	i0	92.814	86.7789473684211	167	12	88	0	24	190	1590636	1590802	Flavobacterium sp. WW92 chromosome, complete genome	blastn	16488	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WW92
23146694	23146694	PRJNA1088503_P_NODE_7919_length_248_cov_40178.863014_g7547_i0	PRJNA1088503	7919	248	40178.863014	99643.58027472	Cloacibacterium caeni	2004710	Bacteria	Bacteria	220	5.81e-53	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g7547	i0	98.4	2.4758064516129	125	2	50	0	34	158	468645	468521	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	614	220	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
23146702	23146702	PRJNA1088503_P_NODE_8879_length_219_cov_159.900000_g8507_i0	PRJNA1088503	8879	219	159.9	350.181	Cloacibacterium caeni	2004710	Bacteria	Bacteria	246	8.28e-61	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g8507	i0	91.209	3.74429223744292	182	14	88	2	28	208	728566	728746	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	820	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
24420328	24420328	PRJNA1088503_P_NODE_11080_length_164_cov_867.377778_g10708_i0	PRJNA1088503	11080	164	867.377778	1422.49955592	Cloacibacterium caeni	2004710	Bacteria	Bacteria	244	2.1e-60	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g10708	i0	99.259	0.823170731707317	135	1	82	0	29	163	2450541	2450407	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	135	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
24420392	24420392	PRJNA1088503_P_NODE_7280_length_269_cov_45358.891667_g6908_i0	PRJNA1088503	7280	269	45358.891667	122015.41858423	Cloacibacterium caeni	2004710	Bacteria	Bacteria	411	3.529999999999999e-110	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g6908	i0	98.291	2.60966542750929	234	4	87	0	3	236	1279513	1279280	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	702	411	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni

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