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

21 rows where analysis = "blastn", bioproject = "PRJEB76780" 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
1413362	1413362	PRJEB76780_P_NODE_12482_length_245_cov_0.906977_g12382_i0	PRJEB76780	12482	245	0.906977	2.22209365	Flavobacterium oreochromis	2906078	Bacteria	Bacteria	209	1.24e-49	NTclustered	gi\|2079163087\|gb\|CP067377.1\|	2906078	g12382	i0	93.617	30.9020408163265	141	7	57	2	101	240	1688477	1688338	Flavobacterium oreochromis strain Costa Rica 04-02-TN chromosome, complete genome	blastn	7571	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium oreochromis
1413401	1413401	PRJEB76780_P_NODE_3102_length_465_cov_1.385204_g3002_i0	PRJEB76780	3102	465	1.385204	6.4411986	Flavobacterium covae	2906076	Bacteria	Bacteria	425	2.31e-114	NTclustered	gi\|2811406943\|gb\|CP097867.1\|	2906076	g3002	i0	88.385	3.83655913978495	353	41	76	0	1	353	2001535	2001887	Flavobacterium covae strain AH-01 chromosome, complete genome	blastn	1784	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
2271544	2271544	PRJEB76780_P_NODE_11782_length_248_cov_0.874286_g11682_i0	PRJEB76780	11782	248	0.874286	2.16822928	Flavobacterium	237	Bacteria	Bacteria	209	1.26e-49	NTclustered	gi\|2679314462\|gb\|CP085725.1\|	1176532	g11682	i0	91.447	3.05241935483871	152	13	61	0	1	152	3370444	3370595	Flavobacterium hankyongi strain KTce-4 chromosome, complete genome	blastn	757	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium hankyongi
2688886	2688886	PRJEB76780_P_NODE_7323_length_298_cov_2.080000_g7223_i0	PRJEB76780	7323	298	2.08	6.1984	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	374	5.2e-99	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g7223	i0	89.562	116.687919463087	297	27	99	4	1	294	801531	801236	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	34773	374	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
5241308	5241308	PRJEB76780_P_NODE_10925_length_251_cov_0.876404_g10825_i0	PRJEB76780	10925	251	0.876404	2.19977404	Flavobacterium sp. N502536	2986837	Bacteria	Bacteria	333	7.249999999999999e-87	NTclustered	gi\|2324023936\|gb\|CP110011.1\|	2986837	g10825	i0	90.763	61.5139442231076	249	23	99	0	1	249	3713652	3713900	Flavobacterium sp. N502536 chromosome, complete genome	blastn	15440	333	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N502536
6516933	6516933	PRJEB76780_P_NODE_6166_length_325_cov_1.849206_g6066_i0	PRJEB76780	6166	325	1.849206	6.0099195	Belliella baltica	232259	Bacteria	Bacteria	346	1.25e-90	NTclustered	gi\|390415094\|gb\|CP003281.1\|	866536	g6066	i0	85.976	313.341538461538	328	40	100	5	1	325	1941305	1941629	Belliella baltica DSM 15883, complete genome	blastn	101836	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Belliella	Belliella baltica
7373937	7373937	PRJEB76780_P_NODE_12586_length_245_cov_0.906977_g12486_i0	PRJEB76780	12586	245	0.906977	2.22209365	Flavobacterium	237	Bacteria	Bacteria	259	1.21e-64	NTclustered	gi\|2220360491\|gb\|CP090376.1\|	1341165	g12486	i0	85.95	99.4612244897959	242	34	99	0	2	243	1284234	1283993	Flavobacterium enshiense strain R6S-5-6 chromosome, complete genome	blastn	24368	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium enshiense
7373951	7373951	PRJEB76780_P_NODE_6066_length_328_cov_0.917647_g5966_i0	PRJEB76780	6066	328	0.917647	3.00988216	Flavobacterium	237	Bacteria	Bacteria	206	2.24e-48	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g5966	i0	78.116	40.3262195121951	329	68	100	4	1	328	1931098	1931423	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	13227	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
10341745	10341745	PRJEB76780_P_NODE_10949_length_251_cov_0.876404_g10849_i0	PRJEB76780	10949	251	0.876404	2.19977404	Patiriisocius sp. Uisw_017	3230968	Bacteria	Bacteria	132	2.84e-26	NTclustered	gi\|2908917483\|gb\|CP159835.1\|	3230968	g10849	i0	82.39	65.5856573705179	159	20	62	7	28	182	2225337	2225491	Patiriisocius sp. Uisw_017 chromosome, complete genome	blastn	16462	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Patiriisocius	Patiriisocius sp. Uisw_017
10341848	10341848	PRJEB76780_P_NODE_7349_length_298_cov_1.275556_g7249_i0	PRJEB76780	7349	298	1.275556	3.80115688	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|730604893\|gb\|CP010105.1\|	336810	g7249	i0	100	0.0939597315436242	28	0	9	0	113	140	120881	120908	Candidatus Sulcia muelleri strain ML, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
12892264	12892264	PRJEB76780_P_NODE_5311_length_351_cov_1.949640_g5211_i0	PRJEB76780	5311	351	1.94964	6.8432364	Adhaeribacter radiodurans	2745197	Bacteria	Bacteria	263	1.41e-65	NTclustered	gi\|1885831791\|gb\|CP055153.1\|	2745197	g5211	i0	80.682	387.820512820513	352	56	99	12	1	346	2248613	2248958	Adhaeribacter radiodurans strain KUDC8001 chromosome, complete genome	blastn	136125	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter radiodurans
14167106	14167106	PRJEB76780_P_NODE_13072_length_243_cov_0.917647_g12972_i0	PRJEB76780	13072	243	0.917647	2.22988221	Flavobacterium oreochromis	2906078	Bacteria	Bacteria	344	3.23e-90	NTclustered	gi\|2079163087\|gb\|CP067377.1\|	2906078	g12972	i0	92.181	39.0411522633745	243	19	100	0	1	243	140722	140964	Flavobacterium oreochromis strain Costa Rica 04-02-TN chromosome, complete genome	blastn	9487	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium oreochromis
14167117	14167117	PRJEB76780_P_NODE_232_length_1513_cov_6.806944_g193_i0	PRJEB76780	232	1513	6.806944	102.98906272	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	283	5.06e-71	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g193	i0	79.157	0.282220753469927	427	75	28	12	1070	1489	456869	457288	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	427	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
15441269	15441269	PRJEB76780_P_NODE_8293_length_281_cov_1.500000_g8193_i0	PRJEB76780	8293	281	1.5	4.215	Myroides sp. mNGS23_01	3047542	Bacteria	Bacteria	451	2.19e-122	NTclustered	gi\|2509449404\|gb\|CP125972.1\|	3047542	g8193	i0	98.819	4.47686832740214	254	2	90	1	28	281	2228793	2228541	Myroides sp. mNGS23_01 chromosome, complete genome	blastn	1258	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides sp. mNGS23_01
16715407	16715407	PRJEB76780_P_NODE_11254_length_250_cov_0.881356_g11154_i0	PRJEB76780	11254	250	0.881356	2.20339	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	399	7.019999999999998e-107	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g11154	i0	95.6	69.148	250	9	100	1	1	250	801921	801674	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	17287	399	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19264241	19264241	PRJEB76780_P_NODE_10656_length_252_cov_0.871508_g10556_i0	PRJEB76780	10656	252	0.871508	2.19620016	Flavobacterium oreochromis	2906078	Bacteria	Bacteria	267	7.499999999999999e-67	NTclustered	gi\|2079163087\|gb\|CP067377.1\|	2906078	g10556	i0	85.714	14.9047619047619	252	36	100	0	1	252	611010	610759	Flavobacterium oreochromis strain Costa Rica 04-02-TN chromosome, complete genome	blastn	3756	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium oreochromis
20122931	20122931	PRJEB76780_P_NODE_6876_length_308_cov_0.991489_g6776_i0	PRJEB76780	6876	308	0.991489	3.05378612	Flavobacterium	237	Bacteria	Bacteria	381	3.2299999999999995e-101	NTclustered	gi\|2679314462\|gb\|CP085725.1\|	1176532	g6776	i0	89.286	75.8441558441558	308	28	99	4	1	307	2830362	2830665	Flavobacterium hankyongi strain KTce-4 chromosome, complete genome	blastn	23360	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium hankyongi
20539694	20539694	PRJEB76780_P_NODE_2197_length_559_cov_1.925926_g2097_i0	PRJEB76780	2197	559	1.925926	10.76592634	Flavobacterium sp. N2270	2986831	Bacteria	Bacteria	368	4.81e-97	NTclustered	gi\|2324023718\|gb\|CP110005.1\|	2986831	g2097	i0	79.356	10.742397137746	528	105	94	4	6	531	1197142	1197667	Flavobacterium sp. N2270 chromosome, complete genome	blastn	6005	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2270
20539755	20539755	PRJEB76780_P_NODE_8657_length_276_cov_0.802956_g8557_i0	PRJEB76780	8657	276	0.802956	2.2161585600000002	Hymenobacter monticola	1705399	Bacteria	Bacteria	459	1.28e-124	NTclustered	gi\|2216376139\|gb\|CP094534.1\|	1705399	g8557	i0	96.751	315.065217391304	277	5	100	4	1	276	1094913	1095186	Hymenobacter monticola strain KACC 22596 chromosome, complete genome	blastn	86958	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter monticola
20539763	20539763	PRJEB76780_P_NODE_9497_length_263_cov_2.336842_g9397_i0	PRJEB76780	9497	263	2.336842	6.14589446	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	357	4.54e-94	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g9397	i0	91.353	184.524714828897	266	15	99	7	2	263	802185	801924	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	48530	357	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21815515	21815515	PRJEB76780_P_NODE_7618_length_293_cov_0.786364_g7518_i0	PRJEB76780	7618	293	0.786364	2.30404652	Chryseobacterium sp. PMSZPI	1033900	Bacteria	Bacteria	464	2.9399999999999994e-126	NTclustered	gi\|2894512347\|gb\|CP178384.1\|	1033900	g7518	i0	95.222	416.262798634812	293	14	100	0	1	293	1703178	1702886	Chryseobacterium sp. PMSZPI chromosome, complete genome	blastn	121965	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. PMSZPI

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