metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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
15613300	15613300	PRJNA1160211_S_NODE_51133_length_572_cov_38.653307_g49967_i0	PRJNA1160211	51133	572	38.653307	221.09691604	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	273	7.83e-91	NR	WP_053392650.1	712357	g49967	i0	88.8	0.839160839160839	160	17	83.4	1	93	569	1	160	WP_053392650.1 OmpA family protein [Leptotrichia sp. oral taxon 212]	diamond	480	273	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
26964699	26964699	PRJNA1160211_S_NODE_145162_length_381_cov_22.415584_g143929_i0	PRJNA1160211	145162	381	22.415584	85.40337504	Leptotrichia	32067	Bacteria	Bacteria	44.3	0.00476	NR	MBF1333024.1	104608	g143929	i0	97.7	0.677165354330709	43	1	33.9	0	58	186	1	43	MBF1333024.1 hypothetical protein [Leptotrichia sp.]	diamond	258	44.3	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp.
27103513	27103513	PRJNA1160211_S_NODE_48102_length_582_cov_5.713163_g46942_i0	PRJNA1160211	48102	582	5.713163	33.25060866	Leptotrichia sp. oral taxon 879	1227267	Bacteria	Bacteria	251	3.75e-73	NR	WP_039901453.1	1227267	g46942	i0	67	1.01546391752577	197	62	100	1	1	582	2553	2749	WP_039901453.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia sp. oral taxon 879]	diamond	591	251	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 879
27514388	27514388	PRJNA1160211_S_NODE_123263_length_416_cov_1.122449_g122034_i0	PRJNA1160211	123263	416	1.122449	4.66938784	Fusobacterium ulcerans	861	Bacteria	Bacteria	210	6.04e-63	NR	WP_304160274.1	861	g122034	i0	89.1	0.987980769230769	137	15	98.8	0	4	414	113	249	WP_304160274.1 FMN-binding protein [Fusobacterium ulcerans]	diamond	411	210	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
27767173	27767173	PRJNA1160211_S_NODE_105064_length_447_cov_20.419786_g103837_i0	PRJNA1160211	105064	447	20.419786	91.27644342	Leptotrichiaceae bacterium	2782225	Bacteria	Bacteria	243	4.769999999999999e-74	NR	MDO5089531.1	2782225	g103837	i0	84.3	0.939597315436242	140	21	94	1	24	443	463	601	MDO5089531.1 1,3-beta-galactosyl-N-acetylhexosamine phosphorylase [Leptotrichiaceae bacterium]	diamond	420	243	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae		Leptotrichiaceae bacterium
28177210	28177210	PRJNA1160211_S_NODE_86906_length_483_cov_26.541463_g85684_i0	PRJNA1160211	86906	483	26.541463	128.19526629	Leptotrichia sp. oral taxon 215	712359	Bacteria	Bacteria	291	7.43e-88	NR	WP_021767792.1	712359	g85684	i0	100	0.919254658385093	148	0	91.9	0	31	474	1638	1785	WP_021767792.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia sp. oral taxon 215]	diamond	444	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 215
28430154	28430154	PRJNA1160211_S_NODE_229166_length_280_cov_5.077295_g227933_i0	PRJNA1160211	229166	280	5.077295	14.216426	Leptotrichia buccalis	40542	Bacteria	Bacteria	115	1.5800000000000002e-27	NR	WP_012806666.1	40542	g227933	i0	83.3	0.642857142857143	60	10	64.3	0	257	78	3147	3206	WP_012806666.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia buccalis]	diamond	180	115	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
28682801	28682801	PRJNA1160211_S_NODE_138507_length_391_cov_21.908805_g137275_i0	PRJNA1160211	138507	391	21.908805	85.66342755	Leptotrichia wadei	157687	Bacteria	Bacteria	197	1.0599999999999998e-55	NR	WP_304078618.1	157687	g137275	i0	87.8	0.882352941176471	115	14	88.2	0	364	20	656	770	WP_304078618.1 autotransporter-associated N-terminal domain-containing protein, partial [Leptotrichia wadei]	diamond	345	197	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
29554222	29554222	PRJNA1160211_S_NODE_158750_length_362_cov_9.695502_g157517_i0	PRJNA1160211	158750	362	9.695502	35.09771724	Leptotrichia	32067	Bacteria	Bacteria	150	3.22e-40	NR	WP_015769275.1	40542	g157517	i0	73.8	3.45580110497238	103	27	85.4	0	339	31	234	336	WP_015769275.1 zinc metalloprotease HtpX [Leptotrichia buccalis]	diamond	1251	150	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
30249534	30249534	PRJNA1160211_S_NODE_98192_length_461_cov_2.097938_g96967_i0	PRJNA1160211	98192	461	2.097938	9.67149418	Fusobacterium	848	Bacteria	Bacteria	213	2.55e-61	NR	MBF1204863.1	860	g96967	i0	82.4	1.99132321041215	153	27	99.6	0	459	1	649	801	MBF1204863.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium periodonticum]	diamond	918	214	0.995327102803738	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
31430812	31430812	PRJNA1160211_S_NODE_39496_length_611_cov_13.433086_g38359_i0	PRJNA1160211	39496	611	13.433086	82.07615546	Leptotrichia buccalis	40542	Bacteria	Bacteria	97.8	1.36e-19	NR	WP_012806666.1	40542	g38359	i0	49.2	0.97708674304419	199	88	95.7	10	13	597	424	613	WP_012806666.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia buccalis]	diamond	597	97.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
32000237	32000237	PRJNA1160211_S_NODE_194958_length_316_cov_7.654321_g193725_i0	PRJNA1160211	194958	316	7.654321	24.18765436	Fusobacterium	848	Bacteria	Bacteria	168	2.4599999999999993e-46	NR	WP_235243361.1	848	g193725	i0	94.4	0.844936708860759	89	5	84.5	0	16	282	604	692	WP_235243361.1 MULTISPECIES: peptidase U32 family protein [Fusobacterium]	diamond	267	168	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium
32190155	32190155	PRJNA1160211_S_NODE_231118_length_278_cov_8.634146_g229885_i0	PRJNA1160211	231118	278	8.634146	24.00292588	Leptotrichia wadei	157687	Bacteria	Bacteria	81.6	2.72e-18	NR	WP_021747207.1	157687	g229885	i0	88.1	0.453237410071942	42	5	45.3	0	139	14	1	42	WP_021747207.1 type II toxin-antitoxin system HicA family toxin [Leptotrichia wadei]	diamond	126	81.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei

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