metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1066877" and tax

9 rows where analysis = "blastn", 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
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

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