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

26 rows where analysis = "blastn", bioproject = "PRJNA554794" and tax_phylum = "Bacteroidota"

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
1123566	1123566	PRJNA554794_P_NODE_23561_length_164_cov_0.886957_g19632_i0	PRJNA554794	23561	164	0.886957	1.45460948	Pseudomonadati	3379134	Bacteria	Bacteria	143	7.9e-30	NTclustered	gi\|1799015622\|gb\|CP047647.1\|	2607656	g19632	i0	83.66	3.8109756097561	153	23	93	2	5	156	3028512	3028663	Hymenobacter busanensis strain BT182 chromosome, complete genome	blastn	625	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter busanensis
2398974	2398974	PRJNA554794_P_NODE_22902_length_166_cov_0.871795_g18973_i0	PRJNA554794	22902	166	0.871795	1.4471797	Elizabethkingia	308865	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1020913994\|gb\|CP014805.2\|	1117645	g18973	i0	100	91.7349397590361	166	0	100	0	1	166	3376044	3375879	Elizabethkingia anophelis strain CSID_3015183678, complete genome	blastn	15228	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
4348050	4348050	PRJNA554794_P_NODE_24324_length_162_cov_0.893805_g20395_i0	PRJNA554794	24324	162	0.893805	1.4479641	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1020913994\|gb\|CP014805.2\|	1117645	g20395	i0	100	82.5617283950617	162	0	100	0	1	162	2643348	2643509	Elizabethkingia anophelis strain CSID_3015183678, complete genome	blastn	13375	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
4951720	4951720	PRJNA554794_P_NODE_24124_length_162_cov_1.345133_g20195_i0	PRJNA554794	24124	162	1.345133	2.17911546	Elizabethkingia	308865	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1352861641\|gb\|CP023010.2\|	1117645	g20195	i0	100	91.5864197530864	162	0	100	0	1	162	323856	324017	Elizabethkingia anophelis strain FDAARGOS_198 chromosome, complete genome	blastn	14837	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
8776489	8776489	PRJNA554794_P_NODE_23207_length_165_cov_0.879310_g19278_i0	PRJNA554794	23207	165	0.87931	1.4508615	Phocaeicola	909656	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1966883226\|gb\|CP068488.1\|	821	g19278	i0	100	28.0909090909091	165	0	100	0	1	165	1143281	1143445	Phocaeicola vulgatus strain FDAARGOS_1098 chromosome	blastn	4635	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
8776506	8776506	PRJNA554794_P_NODE_24507_length_161_cov_1.357143_g20578_i0	PRJNA554794	24507	161	1.357143	2.18500023	Elizabethkingia	308865	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1020913994\|gb\|CP014805.2\|	1117645	g20578	i0	100	89.9254658385093	161	0	100	0	1	161	3357520	3357360	Elizabethkingia anophelis strain CSID_3015183678, complete genome	blastn	14478	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
9449324	9449324	PRJNA554794_P_NODE_23188_length_165_cov_0.879310_g19259_i0	PRJNA554794	23188	165	0.87931	1.4508615	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1979345949\|gb\|CP069277.1\|	1117645	g19259	i0	100	89.5212121212121	165	0	100	0	1	165	337888	338052	Elizabethkingia anophelis strain SEA01 chromosome, complete genome	blastn	14771	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
9449331	9449331	PRJNA554794_P_NODE_23668_length_164_cov_0.869565_g19739_i0	PRJNA554794	23668	164	0.869565	1.4260866	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1352861641\|gb\|CP023010.2\|	1117645	g19739	i0	100	85.0487804878049	164	0	100	0	1	164	3141308	3141471	Elizabethkingia anophelis strain FDAARGOS_198 chromosome, complete genome	blastn	13948	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
11326875	11326875	PRJNA554794_P_NODE_6169_length_804_cov_2.939073_g3007_i0	PRJNA554794	6169	804	2.939073	23.63014692	Flavobacterium	237	Bacteria	Bacteria	1474	0	NTclustered	gi\|2799939107\|gb\|PQ288737.1\|	239	g3007	i0	99.875	156.871890547264	801	1	99	0	1	801	801	1	Flavobacterium sp. strain YJ03 16S ribosomal RNA gene, partial sequence	blastn	126125	1474	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
12602526	12602526	PRJNA554794_P_NODE_23930_length_163_cov_0.885965_g20001_i0	PRJNA554794	23930	163	0.885965	1.44412295	Elizabethkingia	308865	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1352861641\|gb\|CP023010.2\|	1117645	g20001	i0	100	78.4907975460123	163	0	100	0	1	163	770473	770311	Elizabethkingia anophelis strain FDAARGOS_198 chromosome, complete genome	blastn	12794	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
13274987	13274987	PRJNA554794_P_NODE_24251_length_162_cov_0.902655_g20322_i0	PRJNA554794	24251	162	0.902655	1.4623011	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1352861641\|gb\|CP023010.2\|	1117645	g20322	i0	100	27.9938271604938	162	0	100	0	1	162	3734280	3734441	Elizabethkingia anophelis strain FDAARGOS_198 chromosome, complete genome	blastn	4535	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
13877475	13877475	PRJNA554794_P_NODE_21891_length_175_cov_0.785714_g17962_i0	PRJNA554794	21891	175	0.785714	1.3749995	Flavobacteriales	200644	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|1546192757\|gb\|MK348767.1\|	250	g17962	i0	100	111.697142857143	175	0	100	0	1	175	690	516	Chryseobacterium gleum strain EC14N70 16S ribosomal RNA gene, partial sequence	blastn	19547	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
16426237	16426237	PRJNA554794_P_NODE_23173_length_165_cov_0.879310_g19244_i0	PRJNA554794	23173	165	0.87931	1.4508615	Elizabethkingia	308865	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1020913994\|gb\|CP014805.2\|	1117645	g19244	i0	100	96.7090909090909	165	0	100	0	1	165	2792243	2792079	Elizabethkingia anophelis strain CSID_3015183678, complete genome	blastn	15957	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
18974703	18974703	PRJNA554794_P_NODE_12215_length_282_cov_1.180258_g8286_i0	PRJNA554794	12215	282	1.180258	3.32832756	Elizabethkingia	308865	Bacteria	Bacteria	516	7.67e-142	NTclustered	gi\|2461920362\|gb\|CP119595.1\|	172045	g8286	i0	99.645	172.737588652482	282	1	100	0	1	282	2931079	2930798	Elizabethkingia miricola strain NW-2-4 chromosome, complete genome	blastn	48712	521	0.990403071017274	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
18974931	18974931	PRJNA554794_P_NODE_22995_length_166_cov_0.863248_g19066_i0	PRJNA554794	22995	166	0.863248	1.43299168	Elizabethkingia	308865	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1979345949\|gb\|CP069277.1\|	1117645	g19066	i0	100	96.4759036144578	166	0	100	0	1	166	819630	819795	Elizabethkingia anophelis strain SEA01 chromosome, complete genome	blastn	16015	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
19647300	19647300	PRJNA554794_P_NODE_23556_length_164_cov_0.886957_g19627_i0	PRJNA554794	23556	164	0.886957	1.45460948	Sphingobacterium spiritivorum	258	Bacteria	Bacteria	246	5.8499999999999995e-61	NTclustered	gi\|1958211526\|gb\|CP068082.1\|	258	g19627	i0	94.375	8.76829268292683	160	9	98	0	1	160	998188	998347	Sphingobacterium spiritivorum strain FDAARGOS_1146 chromosome, complete genome	blastn	1438	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium spiritivorum
20250050	20250050	PRJNA554794_P_NODE_22976_length_166_cov_0.863248_g19047_i0	PRJNA554794	22976	166	0.863248	1.43299168	Elizabethkingia	308865	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1352861641\|gb\|CP023010.2\|	1117645	g19047	i0	100	98.3313253012048	166	0	100	0	1	166	1764450	1764615	Elizabethkingia anophelis strain FDAARGOS_198 chromosome, complete genome	blastn	16323	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
20923057	20923057	PRJNA554794_P_NODE_14097_length_228_cov_1.318436_g10168_i0	PRJNA554794	14097	228	1.318436	3.00603408	Fluviicola taffensis	191579	Bacteria	Bacteria	252	1.87e-62	NTclustered	gi\|327317519\|gb\|CP002542.1\|	755732	g10168	i0	87.281	1	228	20	97	5	7	228	3059969	3059745	Fluviicola taffensis DSM 16823 chromosome, complete genome	blastn	228	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
20923116	20923116	PRJNA554794_P_NODE_23757_length_163_cov_1.789474_g19828_i0	PRJNA554794	23757	163	1.789474	2.91684262	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2844224223\|gb\|CP172267.1\|	1117645	g19828	i0	100	88.638036809816	163	0	100	0	1	163	2741541	2741703	Elizabethkingia anophelis strain Eli1 chromosome, complete genome	blastn	14448	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
20923119	20923119	PRJNA554794_P_NODE_23837_length_163_cov_0.894737_g19908_i0	PRJNA554794	23837	163	0.894737	1.45842131	Hymenobacter swuensis	1446467	Bacteria	Bacteria	241	2.7000000000000008e-59	NTclustered	gi\|586953861\|gb\|CP007145.1\|	1227739	g19908	i0	93.252	90.8895705521472	163	11	100	0	1	163	1537501	1537339	Hymenobacter swuensis DY53, complete genome	blastn	14815	241	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter swuensis
21525603	21525603	PRJNA554794_P_NODE_23137_length_165_cov_0.879310_g19208_i0	PRJNA554794	23137	165	0.87931	1.4508615	Elizabethkingia	308865	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1020913994\|gb\|CP014805.2\|	1117645	g19208	i0	100	76.6545454545455	165	0	100	0	1	165	1828572	1828736	Elizabethkingia anophelis strain CSID_3015183678, complete genome	blastn	12648	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
21525605	21525605	PRJNA554794_P_NODE_23237_length_165_cov_0.870690_g19308_i0	PRJNA554794	23237	165	0.87069	1.4366385	Elizabethkingia	308865	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1979345949\|gb\|CP069277.1\|	1117645	g19308	i0	100	89.4060606060606	165	0	100	0	1	165	2497047	2497211	Elizabethkingia anophelis strain SEA01 chromosome, complete genome	blastn	14752	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
22197821	22197821	PRJNA554794_P_NODE_22558_length_167_cov_1.728814_g18629_i0	PRJNA554794	22558	167	1.728814	2.88711938	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2428391947\|gb\|CP115634.1\|	1117645	g18629	i0	100	89.8383233532934	167	0	100	0	1	167	3054978	3054812	Elizabethkingia anophelis strain 2022CK-00262 chromosome, complete genome	blastn	15003	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
22197825	22197825	PRJNA554794_P_NODE_23478_length_164_cov_0.886957_g19549_i0	PRJNA554794	23478	164	0.886957	1.45460948	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2269436631\|gb\|CP071542.1\|	1117645	g19549	i0	100	26	164	0	100	0	1	164	990935	991098	Elizabethkingia anophelis strain 347-10 chromosome, complete genome	blastn	4264	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
23473373	23473373	PRJNA554794_P_NODE_21139_length_184_cov_1.088889_g17210_i0	PRJNA554794	21139	184	1.088889	2.00355576	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|1154263508\|gb\|CP014339.1\|	1117645	g17210	i0	100	4	184	0	100	0	1	184	4000888	4001071	Elizabethkingia anophelis strain E6809 chromosome, complete genome	blastn	736	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
25349894	25349894	PRJNA554794_P_NODE_22620_length_167_cov_0.864407_g18691_i0	PRJNA554794	22620	167	0.864407	1.44355969	Elizabethkingia	308865	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1979345949\|gb\|CP069277.1\|	1117645	g18691	i0	100	95.5868263473054	167	0	100	0	1	167	2789818	2789984	Elizabethkingia anophelis strain SEA01 chromosome, complete genome	blastn	15963	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis

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