metadata: contig_metadata: 14 rows where bioproject = "PRJNA1066877" and tax

14 rows where bioproject = "PRJNA1066877" 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
1012888	1012888	PRJNA1066877_S_NODE_10161_length_175_cov_1.349206_g10126_i0	PRJNA1066877	10161	175	1.349206	2.3611105	Capnocytophaga	1016	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|1242555297\|gb\|CP022382.1\|	28188	g10126	i0	100	10.9942857142857	175	0	100	0	1	175	2095568	2095394	Capnocytophaga canimorsus strain 7120 chromosome, complete genome	blastn	1924	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga canimorsus
4841043	4841043	PRJNA1066877_S_NODE_4284_length_242_cov_1.227979_g4249_i0	PRJNA1066877	4284	242	1.227979	2.97170918	Capnocytophaga	1016	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1242555297\|gb\|CP022382.1\|	28188	g4249	i0	100	9.99586776859504	242	0	100	0	1	242	2114137	2113896	Capnocytophaga canimorsus strain 7120 chromosome, complete genome	blastn	2419	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga canimorsus
5283205	5283205	PRJNA1066877_S_NODE_4145_length_245_cov_1.301020_g4110_i0	PRJNA1066877	4145	245	1.30102	3.187499	Rufibacter ruber	1783499	Bacteria	Bacteria	82.8	2.94e-16	NR	WP_066833853.1	1783499	g4110	i0	50.6	4.37142857142857	89	29	90.6	1	3	224	114	202	WP_066833853.1 mercury(II) reductase [Rufibacter ruber]	diamond	1071	82.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Rufibacter	Rufibacter ruber
6558211	6558211	PRJNA1066877_S_NODE_10186_length_175_cov_1.214286_g10151_i0	PRJNA1066877	10186	175	1.214286	2.1250005	Prevotella sp. oral taxon 299	652716	Bacteria	Bacteria	226	8.209999999999999e-55	NTclustered	gi\|532126075\|gb\|CP003667.1\|	575614	g10151	i0	90.173	0.988571428571429	173	17	99	0	3	175	103594	103422	Prevotella sp. oral taxon 299 str. F0039 plasmid, complete sequence	blastn	173	226	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 299
9941188	9941188	PRJNA1066877_S_NODE_5648_length_218_cov_1.076923_g5613_i0	PRJNA1066877	5648	218	1.076923	2.34769214	Porphyromonas	836	Bacteria	Bacteria	320	4.78e-83	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g5613	i0	93.119	361.045871559633	218	15	100	0	1	218	1547778	1547561	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	78708	320	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
11658957	11658957	PRJNA1066877_S_NODE_4310_length_241_cov_1.666667_g4275_i0	PRJNA1066877	4310	241	1.666667	4.01666747	Capnocytophaga endodontalis	2708117	Bacteria	Bacteria	370	5.27e-98	NTclustered	gi\|1211193516\|gb\|CP022022.1\|	2708117	g4275	i0	94.583	429.029045643154	240	11	99	2	3	241	1152502	1152740	Capnocytophaga endodontalis strain ChDC OS43 chromosome, complete genome	blastn	103396	370	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga endodontalis
15483053	15483053	PRJNA1066877_S_NODE_10953_length_169_cov_1.700000_g10918_i0	PRJNA1066877	10953	169	1.7	2.873	Amniculibacterium sp. G2-70	2767188	Bacteria	Bacteria	224	2.8299999999999995e-54	NTclustered	gi\|1898132275\|gb\|CP060698.1\|	2767188	g10918	i0	90.533	98.5562130177515	169	16	100	0	1	169	1784177	1784345	Amniculibacterium sp. G2-70 chromosome, complete genome	blastn	16656	224	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Amniculibacterium	Amniculibacterium sp. G2-70
15483172	15483172	PRJNA1066877_S_NODE_5533_length_219_cov_1.758824_g5498_i0	PRJNA1066877	5533	219	1.758824	3.85182456	Capnocytophaga canimorsus	28188	Bacteria	Bacteria	403	4.64e-108	NTclustered	gi\|1242555297\|gb\|CP022382.1\|	28188	g5498	i0	100	10.9360730593607	218	0	99	0	1	218	976340	976557	Capnocytophaga canimorsus strain 7120 chromosome, complete genome	blastn	2395	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga canimorsus
16757314	16757314	PRJNA1066877_S_NODE_5214_length_224_cov_2.040000_g5179_i0	PRJNA1066877	5214	224	2.04	4.5696	Capnocytophaga sp. ARDL2	3238809	Bacteria	Bacteria	195	3.1299999999999996e-45	NTclustered	gi\|2794131501\|gb\|CP168034.1\|	3238809	g5179	i0	85.87	0.821428571428571	184	24	82	2	9	191	406701	406519	Capnocytophaga sp. ARDL2 chromosome, complete genome	blastn	184	195	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sp. ARDL2
20581388	20581388	PRJNA1066877_S_NODE_12737_length_162_cov_0.876106_g12702_i0	PRJNA1066877	12737	162	0.876106	1.41929172	Capnocytophaga canimorsus	28188	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|1242572053\|gb\|CP022389.1\|	28188	g12702	i0	98.765	13.6234567901235	162	2	100	0	1	162	36876	37037	Capnocytophaga canimorsus strain H3936 chromosome, complete genome	blastn	2207	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga canimorsus
28417031	28417031	PRJNA1066877_S_NODE_12666_length_162_cov_0.902655_g12631_i0	PRJNA1066877	12666	162	0.902655	1.4623011	Porphyromonas	836	Bacteria	Bacteria	111	1.19e-27	NR	MFC2631995.1	1583331	g12631	i0	100	3	54	0	100	0	1	162	95	148	MFC2631995.1 SusF/SusE family outer membrane protein [Porphyromonas pasteri]	diamond	486	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas pasteri
29972349	29972349	PRJNA1066877_S_NODE_12251_length_163_cov_2.026316_g12216_i0	PRJNA1066877	12251	163	2.026316	3.30289508	Bacteroides uniformis	820	Bacteria	Bacteria	51.6	5.14e-7	NR	WP_208081217.1	820	g12216	i0	100	0.496932515337423	27	0	49.7	0	2	82	26	52	WP_208081217.1 hypothetical protein, partial [Bacteroides uniformis]	diamond	81	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
30604173	30604173	PRJNA1066877_S_NODE_9033_length_184_cov_1.044444_g8998_i0	PRJNA1066877	9033	184	1.044444	1.92177696	Bergeyella zoohelcum	1015	Bacteria	Bacteria	125	1.95e-34	NR	WP_260199964.1	1015	g8998	i0	100	0.978260869565217	60	0	97.8	0	182	3	77	136	WP_260199964.1 hypothetical protein [Bergeyella zoohelcum]	diamond	180	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella zoohelcum
31742152	31742152	PRJNA1066877_S_NODE_11897_length_165_cov_0.879310_g11862_i0	PRJNA1066877	11897	165	0.87931	1.4508615	Candidatus Kapaibacteriota bacterium	3377422	Bacteria	Bacteria	47	3.37e-5	NR	MFN3782156.1	3377422	g11862	i0	65.6	0.581818181818182	32	11	58.2	0	97	2	8	39	MFN3782156.1 flagellar assembly protein FliW [Candidatus Kapaibacteriota bacterium]	diamond	96	47	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota					Candidatus Kapaibacteriota bacterium

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