metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA807685" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA807685" 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
1222820	1222820	PRJNA807685_P_NODE_5301_length_930_cov_11.235162_g4519_i0	PRJNA807685	5301	930	11.235162	104.4870066	Empedobacter	59734	Bacteria	Bacteria	1609	0	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g4519	i0	98.364	474.248387096774	917	14	98	1	15	930	523535	522619	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	441051	1609	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
2082176	2082176	PRJNA807685_P_NODE_18242_length_337_cov_1.636667_g17170_i0	PRJNA807685	18242	337	1.636667	5.51556779	Cloacibacterium normanense	237258	Bacteria	Bacteria	551	2.5699999999999992e-152	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g17170	i0	96.142	3.99109792284866	337	13	100	0	1	337	1422888	1422552	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1345	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
2082257	2082257	PRJNA807685_P_NODE_26982_length_252_cov_2.325581_g25909_i0	PRJNA807685	26982	252	2.325581	5.86046412	Cloacibacterium caeni	2004710	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g25909	i0	99.603	96.0992063492064	252	1	100	0	1	252	851582	851833	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	24217	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
2082274	2082274	PRJNA807685_P_NODE_29042_length_239_cov_3.341584_g27969_i0	PRJNA807685	29042	239	3.341584	7.98638576	Cloacibacterium normanense	237258	Bacteria	Bacteria	370	5.22e-98	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g27969	i0	97.248	45.1422594142259	218	6	91	0	22	239	836547	836764	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	10789	370	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
2082389	2082389	PRJNA807685_P_NODE_46082_length_180_cov_1.349650_g45009_i0	PRJNA807685	46082	180	1.34965	2.42937	Sphingobacterium multivorum	28454	Bacteria	Bacteria	303	3.82e-78	NTclustered	gi\|1958275331\|gb\|CP068224.1\|	28454	g45009	i0	98.266	12.4944444444444	173	3	96	0	1	173	3474533	3474361	Sphingobacterium multivorum strain FDAARGOS_1141 chromosome, complete genome	blastn	2249	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium multivorum
2498362	2498362	PRJNA807685_P_NODE_5122_length_965_cov_7.378233_g4358_i0	PRJNA807685	5122	965	7.378233	71.19994845	Niabella	379899	Bacteria	Bacteria	1720	0	NTclustered	gi\|2636479872\|gb\|CP139960.1\|	577386	g4358	i0	99.893	278.280829015544	934	1	97	0	12	945	1091119	1092052	Niabella yanshanensis strain HAMBI_3031 chromosome, complete genome	blastn	268541	1720	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella yanshanensis
3774545	3774545	PRJNA807685_P_NODE_24483_length_270_cov_2.296137_g23410_i0	PRJNA807685	24483	270	2.296137	6.1995699	Empedobacter	59734	Bacteria	Bacteria	451	2.09e-122	NTclustered	gi\|2514088624\|gb\|CP106831.1\|	343874	g23410	i0	97.037	445.855555555556	270	5	100	2	1	270	1112532	1112266	Empedobacter falsenii strain YWS9-3_T chromosome, complete genome	blastn	120381	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
5910205	5910205	PRJNA807685_P_NODE_9665_length_547_cov_2.323529_g8638_i0	PRJNA807685	9665	547	2.323529	12.70970363	Cloacibacterium caeni	2004710	Bacteria	Bacteria	1005	0	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g8638	i0	99.817	7.91224862888483	547	1	100	0	1	547	493963	493417	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	4328	1005	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
6326768	6326768	PRJNA807685_P_NODE_3285_length_1617_cov_11.911392_g2764_i0	PRJNA807685	3285	1617	11.911392	192.60720864	Cloacibacterium	501783	Bacteria	Bacteria	1581	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g2764	i0	89.47	339.698206555349	1263	117	78	14	18	1273	1872410	1873663	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	549292	1589	0.994965387035872	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
8459419	8459419	PRJNA807685_P_NODE_16787_length_359_cov_1.975155_g15717_i0	PRJNA807685	16787	359	1.975155	7.09080645	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	462	1.33e-125	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g15717	i0	89.944	86.7688022284123	358	36	99	0	2	359	501116	501473	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	31150	462	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
8459707	8459707	PRJNA807685_P_NODE_52907_length_168_cov_1.183206_g51834_i0	PRJNA807685	52907	168	1.183206	1.98778608	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	267	4.63e-67	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g51834	i0	95.238	2	168	8	100	0	1	168	125322	125489	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	336	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
9734678	9734678	PRJNA807685_P_NODE_47168_length_178_cov_1.092199_g46095_i0	PRJNA807685	47168	178	1.092199	1.94411422	uncultured Draconibacterium sp.	1573823	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2621785513\|emb\|OY781971.1\|	1573823	g46095	i0	100	0.157303370786517	28	0	16	0	151	178	859454	859481	MAG: uncultured Draconibacterium sp. isolate 4b4401df-a607-4228-8dea-8fc876f44265 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Draconibacterium	uncultured Draconibacterium sp.
10151368	10151368	PRJNA807685_P_NODE_47068_length_178_cov_1.368794_g45995_i0	PRJNA807685	47068	178	1.368794	2.43645332	FCB group	1783270	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1187407156\|gb\|CP020873.1\|	1974213	g45995	i0	100	0.314606741573034	28	0	16	0	123	150	1887423	1887450	Prosthecochloris sp. HL-130-GSB chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. HL-130-GSB
11010372	11010372	PRJNA807685_P_NODE_27989_length_246_cov_1.430622_g26916_i0	PRJNA807685	27989	246	1.430622	3.51933012	Prevotella bivia	28125	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2679196903\|dbj\|AP029375.1\|	28125	g26916	i0	100	9.28048780487805	246	0	100	0	1	246	324744	324499	Prevotella bivia TOH-2715 DNA, chromosome 1, complete sequence	blastn	2283	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
13560378	13560378	PRJNA807685_P_NODE_65431_length_152_cov_2.052174_g64358_i0	PRJNA807685	65431	152	2.052174	3.11930448	Cytophagales bacterium Alg240-R148	2305985	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|1805798709\|emb\|LS999826.1\|	2305985	g64358	i0	100	0.190789473684211	29	0	19	0	93	121	945590	945562	Cytophagales bacterium Alg240-R148 genome assembly, chromosome: I	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales			Cytophagales bacterium Alg240-R148
14834713	14834713	PRJNA807685_P_NODE_25412_length_263_cov_1.871681_g24339_i0	PRJNA807685	25412	263	1.871681	4.92252103	Capnocytophaga ochracea	1018	Bacteria	Bacteria	451	2.03e-122	NTclustered	gi\|2127704703\|gb\|CP085961.1\|	1018	g24339	i0	99.2	2.85171102661597	250	2	95	0	1	250	2467481	2467730	Capnocytophaga ochracea strain FDAARGOS_1550 chromosome, complete genome	blastn	750	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga ochracea
16109045	16109045	PRJNA807685_P_NODE_43233_length_186_cov_1.818792_g42160_i0	PRJNA807685	43233	186	1.818792	3.38295312	Flavobacterium sp. KACC 22758	3025667	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2446139215\|gb\|CP117878.1\|	3025667	g42160	i0	100	0.161290322580645	30	0	16	0	114	143	368576	368547	Flavobacterium sp. KACC 22758 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. KACC 22758
16525537	16525537	PRJNA807685_P_NODE_23993_length_274_cov_2.042194_g22920_i0	PRJNA807685	23993	274	2.042194	5.59561156	Hymenobacter	89966	Bacteria	Bacteria	457	4.5599999999999985e-124	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g22920	i0	96.727	264.259124087591	275	7	100	2	1	274	1424017	1424290	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	72407	460	0.993478260869565	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
17384995	17384995	PRJNA807685_P_NODE_57674_length_161_cov_1.782258_g56601_i0	PRJNA807685	57674	161	1.782258	2.86943538	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	193	7.55e-45	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g56601	i0	88.272	1.00621118012422	162	17	100	2	1	161	2762612	2762772	Flavobacterium sp. N1719 chromosome, complete genome	blastn	162	193	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
19074475	19074475	PRJNA807685_P_NODE_44095_length_184_cov_2.006803_g43022_i0	PRJNA807685	44095	184	2.006803	3.69251752	Cloacibacterium	501783	Bacteria	Bacteria	307	3.0300000000000004e-79	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g43022	i0	96.739	2	184	6	100	0	1	184	2527812	2527995	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	368	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
19074530	19074530	PRJNA807685_P_NODE_67615_length_150_cov_1.778761_g66542_i0	PRJNA807685	67615	150	1.778761	2.6681415	Emticicia	312278	Bacteria	Bacteria	206	8.86e-49	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g66542	i0	91.333	12.12	150	13	100	0	1	150	1545	1396	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	1818	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
19933042	19933042	PRJNA807685_P_NODE_10896_length_497_cov_14.295652_g9850_i0	PRJNA807685	10896	497	14.295652	71.04939044	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	505	3.1e-138	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g9850	i0	86.037	234.169014084507	487	49	96	15	1	479	359765	360240	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	116382	505	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
21208681	21208681	PRJNA807685_P_NODE_14517_length_401_cov_2.381868_g13449_i0	PRJNA807685	14517	401	2.381868	9.55129068	Niabella yanshanensis	577386	Bacteria	Bacteria	730	0	NTclustered	gi\|2636479872\|gb\|CP139960.1\|	577386	g13449	i0	99.501	264.456359102244	401	2	100	0	1	401	1092443	1092843	Niabella yanshanensis strain HAMBI_3031 chromosome, complete genome	blastn	106047	730	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella yanshanensis
22900362	22900362	PRJNA807685_P_NODE_31278_length_227_cov_2.631579_g30205_i0	PRJNA807685	31278	227	2.631579	5.97368433	Flavobacterium	237	Bacteria	Bacteria	381	2.2699999999999995e-101	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g30205	i0	100	416.471365638767	206	0	91	0	22	227	980497	980702	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	94539	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
23759099	23759099	PRJNA807685_P_NODE_27019_length_252_cov_1.720930_g25946_i0	PRJNA807685	27019	252	1.72093	4.3367436	Niabella yanshanensis	577386	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2636479872\|gb\|CP139960.1\|	577386	g25946	i0	100	210.519841269841	252	0	100	0	1	252	1092834	1093085	Niabella yanshanensis strain HAMBI_3031 chromosome, complete genome	blastn	53051	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella yanshanensis
25032872	25032872	PRJNA807685_P_NODE_17700_length_345_cov_1.649351_g16628_i0	PRJNA807685	17700	345	1.649351	5.69026095	Niabella yanshanensis	577386	Bacteria	Bacteria	472	2.1099999999999999e-128	NTclustered	gi\|2636479872\|gb\|CP139960.1\|	577386	g16628	i0	92.424	0.956521739130435	330	25	96	0	16	345	4240922	4240593	Niabella yanshanensis strain HAMBI_3031 chromosome, complete genome	blastn	330	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella yanshanensis
25449365	25449365	PRJNA807685_P_NODE_18560_length_332_cov_2.738983_g17488_i0	PRJNA807685	18560	332	2.738983	9.09342356	Bacteroides	816	Bacteria	Bacteria	606	5.319999999999998e-169	NTclustered	gi\|2571189838\|gb\|CP133097.1\|	817	g17488	i0	99.699	558.153614457831	332	0	100	1	1	332	129207	129537	Bacteroides fragilis strain GS084 chromosome, complete genome	blastn	185307	606	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
25449422	25449422	PRJNA807685_P_NODE_33580_length_217_cov_1.072222_g32507_i0	PRJNA807685	33580	217	1.072222	2.32672174	Cloacibacterium	501783	Bacteria	Bacteria	326	1.02e-84	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g32507	i0	96	13.6221198156682	200	8	92	0	18	217	240700	240501	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	2956	329	0.990881458966565	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);;