metadata: contig_metadata: 9 rows where bioproject = "PRJNA1188114" and tax

9 rows where bioproject = "PRJNA1188114" and tax_kingdom = "Fusobacteriati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2870850	2870850	PRJNA1188114_P_NODE_8543_length_181_cov_2.083333_g8491_i0	PRJNA1188114	8543	181	2.083333	3.77083273	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g8491	i0	100	15.0386740331492	181	0	100	0	1	181	2483224	2483404	Leptotrichia sp. SK-5 DNA, complete genome	blastn	2722	335	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
10523679	10523679	PRJNA1188114_P_NODE_14849_length_165_cov_0.879310_g14797_i0	PRJNA1188114	14849	165	0.87931	1.4508615	Cetobacterium	180162	Bacteria	Bacteria	105	1.98e-25	NR	WP_297407539.1	527638	g14797	i0	96.4	3	55	2	100	0	1	165	175	229	WP_297407539.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [uncultured Cetobacterium sp.]	diamond	495	106	0.990566037735849	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
11798605	11798605	PRJNA1188114_P_NODE_15310_length_164_cov_1.773913_g15258_i0	PRJNA1188114	15310	164	1.773913	2.90921732	Fusobacterium animalis	76859	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2706064790\|gb\|CP077192.1\|	76859	g15258	i0	98.78	100	164	2	100	0	1	164	66306	66469	Fusobacterium animalis strain SB024 chromosome, complete genome	blastn	16400	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
12520737	12520737	PRJNA1188114_P_NODE_13430_length_166_cov_0.871795_g13378_i0	PRJNA1188114	13430	166	0.871795	1.4471797	Fusobacterium	848	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2445153921\|gb\|CP117797.1\|	851	g13378	i0	99.398	114.210843373494	166	1	100	0	1	166	2441519	2441684	Fusobacterium nucleatum strain FNA chromosome, complete genome	blastn	18959	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13073600	13073600	PRJNA1188114_P_NODE_20591_length_151_cov_2.578431_g20539_i0	PRJNA1188114	20591	151	2.578431	3.89343081	Leptotrichia wadei	157687	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g20539	i0	99.338	8.99337748344371	151	1	100	0	1	151	2277556	2277706	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	1358	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
15069788	15069788	PRJNA1188114_P_NODE_13772_length_166_cov_0.871795_g13720_i0	PRJNA1188114	13772	166	0.871795	1.4471797	Leptotrichia	32067	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g13720	i0	100	26.0421686746988	166	0	100	0	1	166	2658118	2657953	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	4323	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
20168386	20168386	PRJNA1188114_P_NODE_18956_length_161_cov_1.812500_g18904_i0	PRJNA1188114	18956	161	1.8125	2.918125	Fusobacterium	848	Bacteria	Bacteria	270	3.389999999999999e-68	NTclustered	gi\|958157244\|gb\|CP013336.1\|	1307443	g18904	i0	97.468	9.86335403726708	158	4	98	0	1	158	2190008	2190165	Fusobacterium hwasookii ChDC F206, complete genome	blastn	1588	272	0.992647058823529	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
22718946	22718946	PRJNA1188114_P_NODE_17778_length_162_cov_1.663717_g17726_i0	PRJNA1188114	17778	162	1.663717	2.69522154	Leptotrichia	32067	Bacteria	Bacteria	182	1.6499999999999996e-41	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g17726	i0	93.548	1.53086419753086	124	5	75	1	1	121	81703	81580	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	248	182	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
24545998	24545998	PRJNA1188114_P_NODE_15520_length_164_cov_0.886957_g15468_i0	PRJNA1188114	15520	164	0.886957	1.45460948	Leptotrichia trevisanii	109328	Bacteria	Bacteria	156	1.01e-33	NTclustered	gi\|1708584775\|dbj\|AP019845.1\|	109328	g15468	i0	83.951	1.97560975609756	162	26	99	0	1	162	415490	415651	Leptotrichia trevisanii JMUB4039 DNA, complete genome	blastn	324	156	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii

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