metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA534016" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA534016" 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
507577	507577	PRJNA534016_P_NODE_18621_length_238_cov_2.715152_g18531_i0	PRJNA534016	18621	238	2.715152	6.46206176	Cloacibacterium caeni	2004710	Bacteria	Bacteria	355	1.45e-93	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g18531	i0	93.697	2.99579831932773	238	13	99	2	1	237	1972852	1973088	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	713	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
1118139	1118139	PRJNA534016_P_NODE_11181_length_269_cov_3.596939_g11091_i0	PRJNA534016	11181	269	3.596939	9.67576591	Cloacibacterium	501783	Bacteria	Bacteria	479	9.539999999999999e-131	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g11091	i0	99.245	3.96654275092937	265	2	99	0	3	267	934053	933789	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1067	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
3058477	3058477	PRJNA534016_P_NODE_5443_length_356_cov_2.911661_g5353_i0	PRJNA534016	5443	356	2.911661	10.36551316	Lutibacter sp. A80	2918453	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2201055896\|gb\|CP092480.1\|	2918453	g5353	i0	100	0.0786516853932584	28	0	8	0	260	287	2095110	2095137	Lutibacter sp. A80 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Lutibacter	Lutibacter sp. A80
5611199	5611199	PRJNA534016_P_NODE_10525_length_275_cov_1.282178_g10435_i0	PRJNA534016	10525	275	1.282178	3.5259895	Flavobacterium aestivum	3003257	Bacteria	Bacteria	433	7.72e-117	NTclustered	gi\|2477602438\|gb\|CP113977.2\|	3003257	g10435	i0	95.255	99.0945454545455	274	12	99	1	2	275	27032	27304	Flavobacterium aestivum isolate IMCC34774 chromosome, complete genome	blastn	27251	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium aestivum
6885037	6885037	PRJNA534016_P_NODE_10126_length_278_cov_1.502439_g10036_i0	PRJNA534016	10126	278	1.502439	4.17678042	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	514	2.7199999999999996e-141	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g10036	i0	100	294.194244604317	278	0	100	0	1	278	2979901	2980178	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	81786	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
6885134	6885134	PRJNA534016_P_NODE_16826_length_244_cov_0.900585_g16736_i0	PRJNA534016	16826	244	0.900585	2.1974274	Elizabethkingia miricola	172045	Bacteria	Bacteria	427	3.13e-115	NTclustered	gi\|2461920362\|gb\|CP119595.1\|	172045	g16736	i0	98.354	14.9508196721311	243	4	99	0	2	244	2589273	2589515	Elizabethkingia miricola strain NW-2-4 chromosome, complete genome	blastn	3648	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
7496371	7496371	PRJNA534016_P_NODE_15886_length_246_cov_1.335260_g15796_i0	PRJNA534016	15886	246	1.33526	3.2847396	Flavobacterium	237	Bacteria	Bacteria	451	1.87e-122	NTclustered	gi\|1421732866\|gb\|CP030261.1\|	2249356	g15796	i0	100	99.0609756097561	244	0	99	0	3	246	397249	397492	Flavobacterium fluviale strain HYN0086 chromosome, complete genome	blastn	24369	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium fluviale
9435918	9435918	PRJNA534016_P_NODE_828_length_910_cov_20.758662_g753_i0	PRJNA534016	828	910	20.758662	188.9038242	Chryseobacterium sp. POE27	3138177	Bacteria	Bacteria	54.7	0.026	NTclustered	gi\|2735000326\|gb\|CP152475.1\|	3138177	g753	i0	100	0.0318681318681319	29	0	3	0	67	95	2115413	2115385	Chryseobacterium sp. POE27 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. POE27
10711489	10711489	PRJNA534016_P_NODE_12849_length_257_cov_1.206522_g12759_i0	PRJNA534016	12849	257	1.206522	3.10076154	Flavobacterium sp.	239	Bacteria	Bacteria	163	1.04e-35	NTclustered	gi\|1834819635\|gb\|CP051546.1\|	239	g12759	i0	80.18	4.04669260700389	222	40	86	4	5	224	2013729	2013510	MAG: Flavobacterium sp. isolate NK2020 chromosome	blastn	1040	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
11321364	11321364	PRJNA534016_P_NODE_8669_length_290_cov_1.078341_g8579_i0	PRJNA534016	8669	290	1.078341	3.1271889	Flavobacterium	237	Bacteria	Bacteria	291	5.23e-74	NTclustered	gi\|2886049151\|gb\|CP176806.1\|	96345	g8579	i0	84.775	99.5034482758621	289	44	99	0	2	290	794693	794981	Flavobacterium psychrophilum strain 2022-503 chromosome, complete genome	blastn	28856	292	0.996575342465753	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
11986159	11986159	PRJNA534016_P_NODE_12250_length_261_cov_2.047872_g12160_i0	PRJNA534016	12250	261	2.047872	5.34494592	Alkalitalea saponilacus	889453	Bacteria	Bacteria	152	2.2799999999999998e-32	NTclustered	gi\|1208601938\|gb\|CP021904.1\|	889453	g12160	i0	95.745	3.48275862068966	94	4	44	0	2	95	3973183	3973276	Alkalitalea saponilacus strain SC/BZ-SP2 chromosome, complete genome	blastn	909	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Alkalitalea	Alkalitalea saponilacus
11986198	11986198	PRJNA534016_P_NODE_15130_length_248_cov_0.880000_g15040_i0	PRJNA534016	15130	248	0.88	2.1824	Flavobacterium eburneipallidum	3003263	Bacteria	Bacteria	340	4.27e-89	NTclustered	gi\|2493280413\|gb\|CP114291.2\|	3003263	g15040	i0	91.566	26.5040322580645	249	17	99	3	1	247	3777414	3777660	Flavobacterium eburneipallidum strain IMCC36793 chromosome, complete genome	blastn	6573	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium eburneipallidum
11986332	11986332	PRJNA534016_P_NODE_8530_length_291_cov_1.848624_g8440_i0	PRJNA534016	8530	291	1.848624	5.37949584	Flavobacterium sp. M31R6	2739062	Bacteria	Bacteria	379	1.09e-100	NTclustered	gi\|1850342179\|gb\|CP054141.1\|	2739062	g8440	i0	95.378	384.037800687285	238	11	82	0	1	238	3829230	3829467	Flavobacterium sp. M31R6 chromosome, complete genome	blastn	111755	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. M31R6
14536393	14536393	PRJNA534016_P_NODE_5412_length_357_cov_1.760563_g5322_i0	PRJNA534016	5412	357	1.760563	6.28520991	Tenacibaculum ovolyticum	104270	Bacteria	Bacteria	58.4	7.26e-4	NTclustered	gi\|2429892916\|gb\|CP115918.1\|	104270	g5322	i0	97.059	0.0952380952380952	34	1	10	0	299	332	540929	540962	Tenacibaculum ovolyticum strain 20-4135-2 chromosome, complete genome	blastn	34	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum ovolyticum
17696224	17696224	PRJNA534016_P_NODE_18574_length_239_cov_2.397590_g18484_i0	PRJNA534016	18574	239	2.39759	5.7302401	root	1	Root_unresolved	Root_unresolved	202	2.0199999999999999e-47	NTclustered	gi\|2884834703\|gb\|CP176634.1\|	28117	g18484	i0	82.008	407.640167364017	239	41	99	2	2	239	548561	548798	Alistipes putredinis strain SFAD35 chromosome, complete genome	blastn	97426	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes putredinis
20244756	20244756	PRJNA534016_P_NODE_7396_length_311_cov_1.941176_g7306_i0	PRJNA534016	7396	311	1.941176	6.03705736	Olivibacter	376469	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1733420476\|gb\|CP041643.1\|	2592345	g7306	i0	96.875	0.205787781350482	32	0	10	1	217	247	5599559	5599590	Olivibacter sp. LS-1 chromosome, complete genome	blastn	64	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Olivibacter	Olivibacter sp. LS-1
20909454	20909454	PRJNA534016_P_NODE_12517_length_259_cov_2.166667_g12427_i0	PRJNA534016	12517	259	2.166667	5.61166753	Segatella oris	28135	Bacteria	Bacteria	457	4.279999999999999e-124	NTclustered	gi\|1540054687\|emb\|LR134384.1\|	28135	g12427	i0	98.456	1	259	4	100	0	1	259	2052338	2052596	Prevotella oris strain NCTC13071 genome assembly, chromosome: 1	blastn	259	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella oris
20909506	20909506	PRJNA534016_P_NODE_16117_length_246_cov_0.890173_g16027_i0	PRJNA534016	16117	246	0.890173	2.18982558	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	296	9.3e-76	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g16027	i0	97.674	90.6463414634146	172	4	100	0	75	246	2584011	2583840	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	22299	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
20909578	20909578	PRJNA534016_P_NODE_3857_length_419_cov_2.037572_g3767_i0	PRJNA534016	3857	419	2.037572	8.53742668	Flavobacterium nitratireducens	992289	Bacteria	Bacteria	281	4.72e-71	NTclustered	gi\|2482055250\|gb\|CP121111.1\|	992289	g3767	i0	82.371	3.17422434367542	329	52	78	6	6	331	2468093	2467768	Flavobacterium nitratireducens strain JCM 17678 chromosome, complete genome	blastn	1330	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium nitratireducens
20909613	20909613	PRJNA534016_P_NODE_657_length_1007_cov_2.264454_g588_i0	PRJNA534016	657	1007	2.264454	22.80305178	Winogradskyella helgolandensis	2697010	Bacteria	Bacteria	56.5	0.008	NTclustered	gi\|1866746734\|gb\|CP053352.1\|	2697010	g588	i0	96.97	0.0327706057596822	33	1	3	0	75	107	2609649	2609681	Winogradskyella helgolandensis strain Z354 chromosome, complete genome	blastn	33	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Winogradskyella	Winogradskyella helgolandensis
21520318	21520318	PRJNA534016_P_NODE_5957_length_342_cov_2.565056_g5867_i0	PRJNA534016	5957	342	2.565056	8.77249152	Flavobacterium	237	Bacteria	Bacteria	531	3.409999999999999e-146	NTclustered	gi\|2474883472\|gb\|CP113948.2\|	3002900	g5867	i0	94.737	102.777777777778	342	16	100	1	1	342	2660060	2660399	Flavobacterium praedii strain IMCC34515 chromosome, complete genome	blastn	35150	531	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium praedii
22184283	22184283	PRJNA534016_P_NODE_16358_length_245_cov_0.895349_g16268_i0	PRJNA534016	16358	245	0.895349	2.19360505	Elizabethkingia ursingii	1756150	Bacteria	Bacteria	355	1.51e-93	NTclustered	gi\|1153153613\|gb\|CP016377.1\|	1756150	g16268	i0	97.585	67.2040816326531	207	5	84	0	39	245	3898642	3898848	Elizabethkingia ursingii strain G4123 chromosome, complete genome	blastn	16465	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia ursingii
22184390	22184390	PRJNA534016_P_NODE_7958_length_301_cov_1.013158_g7868_i0	PRJNA534016	7958	301	1.013158	3.04960558	Elizabethkingia ursingii	1756150	Bacteria	Bacteria	278	4.25e-70	NTclustered	gi\|1153153613\|gb\|CP016377.1\|	1756150	g7868	i0	96.97	87.9767441860465	165	5	100	0	137	301	1688123	1687959	Elizabethkingia ursingii strain G4123 chromosome, complete genome	blastn	26481	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia ursingii
22795450	22795450	PRJNA534016_P_NODE_15578_length_247_cov_0.885057_g15488_i0	PRJNA534016	15578	247	0.885057	2.18609079	Elizabethkingia	308865	Bacteria	Bacteria	368	1.95e-97	NTclustered	gi\|2461920362\|gb\|CP119595.1\|	172045	g15488	i0	100	6.4412955465587	199	0	81	0	49	247	4132039	4131841	Elizabethkingia miricola strain NW-2-4 chromosome, complete genome	blastn	1591	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
24070256	24070256	PRJNA534016_P_NODE_19059_length_228_cov_3.483871_g18969_i0	PRJNA534016	19059	228	3.483871	7.94322588	Prevotella	838	Bacteria	Bacteria	405	1.35e-108	NTclustered	gi\|485099155\|ref\|NR_102550.1\|	52227	g18969	i0	98.684	138.618421052632	228	3	100	0	1	228	1691	1464	Prevotella dentalis strain ES2772 23S ribosomal RNA gene, complete sequence	blastn	31605	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella dentalis
24733548	24733548	PRJNA534016_P_NODE_8620_length_290_cov_1.419355_g8530_i0	PRJNA534016	8620	290	1.419355	4.1161295	Cloacibacterium normanense	237258	Bacteria	Bacteria	459	1.3499999999999999e-124	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g8530	i0	95.189	4.56896551724138	291	12	99	1	2	290	444706	444996	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1325	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense

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