metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA849172" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA849172" 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
22909762	22909762	PRJNA849172_P_NODE_143558_length_203_cov_8.807692_g143198_i0	PRJNA849172	143558	203	8.807692	17.87961476	Fusobacterium	848	Bacteria	Bacteria	130	1.74e-36	NR	WP_177160130.1	848	g143198	i0	100	0.990147783251232	67	0	99	0	1	201	63	129	WP_177160130.1 MULTISPECIES: ATP synthase F1 subunit delta [Fusobacterium]	diamond	201	130	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium
28128851	28128851	PRJNA849172_P_NODE_64505_length_275_cov_10.594059_g64145_i0	PRJNA849172	64505	275	10.594059	29.13366225	Leptotrichia wadei	157687	Bacteria	Bacteria	95.5	1.56e-20	NR	WP_304079843.1	157687	g64145	i0	52.8	0.970909090909091	89	41	97.1	1	270	4	117	204	WP_304079843.1 hypothetical protein [Leptotrichia wadei]	diamond	267	95.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
28444540	28444540	PRJNA849172_P_NODE_107906_length_242_cov_2.378698_g107546_i0	PRJNA849172	107906	242	2.378698	5.75644916	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	134	7.22e-38	NR	WP_374124611.1	554406	g107546	i0	85	0.991735537190083	80	12	99.2	0	241	2	13	92	WP_374124611.1 hypothetical protein [Leptotrichia hongkongensis]	diamond	240	134	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
28791632	28791632	PRJNA849172_P_NODE_90467_length_251_cov_3.185393_g90107_i0	PRJNA849172	90467	251	3.185393	7.99533643	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	67	1.18e-11	NR	MBN1467264.1	2053555	g90107	i0	42.4	1.01593625498008	85	47	99.2	2	2	250	20	104	MBN1467264.1 hypothetical protein [Fusobacteriaceae bacterium]	diamond	255	67	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
28917887	28917887	PRJNA849172_P_NODE_87088_length_253_cov_4.200000_g86728_i0	PRJNA849172	87088	253	4.2	10.626	Leptotrichia sp. oral taxon 879	1227267	Bacteria	Bacteria	127	5.17e-32	NR	WP_021744733.1	1227267	g86728	i0	97.1	0.8300395256917	70	2	83	0	1	210	720	789	WP_021744733.1 PP2C family protein-serine/threonine phosphatase [Leptotrichia sp. oral taxon 879]	diamond	210	127	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 879
29549381	29549381	PRJNA849172_P_NODE_99070_length_246_cov_9.658960_g98710_i0	PRJNA849172	99070	246	9.65896	23.7610416	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	139	3.28e-38	NR	MDO4639691.1	554406	g98710	i0	98.6	0.865853658536585	71	1	86.6	0	34	246	1	71	MDO4639691.1 capsular polysaccharide synthesis protein [Leptotrichia hongkongensis]	diamond	213	139	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
29747040	29747040	PRJNA849172_P_NODE_81510_length_258_cov_3.194595_g81150_i0	PRJNA849172	81510	258	3.194595	8.2420551	Fusobacteriales	203491	Bacteria	Bacteria	53.1	5.31e-6	NR	WP_231284688.1	157688	g81150	i0	41.9	3.48837209302326	74	40	86	2	1	222	106	176	WP_231284688.1 outer membrane beta-barrel protein [Leptotrichia hofstadii]	diamond	900	53.5	0.992523364485981	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
31255525	31255525	PRJNA849172_P_NODE_43155_length_315_cov_22.214876_g42795_i0	PRJNA849172	43155	315	22.214876	69.9768594	Fusobacterium perfoetens	852	Bacteria	Bacteria	119	1.59e-28	NR	WP_235246984.1	852	g42795	i0	98.5	0.628571428571429	66	1	62.9	0	198	1	1	66	WP_235246984.1 efflux RND transporter permease subunit [Fusobacterium perfoetens]	diamond	198	119	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
32086310	32086310	PRJNA849172_P_NODE_59818_length_281_cov_2.798077_g59458_i0	PRJNA849172	59818	281	2.798077	7.86259637	Leptotrichia	32067	Bacteria	Bacteria	79.7	6.1e-15	NR	WP_232056220.1	109328	g59458	i0	47.5	3.11743772241993	99	38	95	3	267	1	3192	3286	WP_232056220.1 hemagglutination protein [Leptotrichia trevisanii]	diamond	876	80.1	0.995006242197254	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
32615623	32615623	PRJNA849172_P_NODE_23240_length_426_cov_26.875354_g22881_i0	PRJNA849172	23240	426	26.875354	114.48900804	Fusobacterium	848	Bacteria	Bacteria	108	5.96e-26	NR	WP_177161792.1	848	g22881	i0	100	0.380281690140845	54	0	38	0	426	265	182	235	WP_177161792.1 MULTISPECIES: 50S ribosomal protein L1 [Fusobacterium]	diamond	162	108	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium
32781212	32781212	PRJNA849172_P_NODE_47660_length_303_cov_2.486957_g47300_i0	PRJNA849172	47660	303	2.486957	7.53547971	Bacteria	2	Bacteria	Bacteria	63.2	1.6e-9	NR	WP_300449449.1	68766	g47300	i0	62.5	0.98019801980198	48	17	47.5	1	155	298	1	47	WP_300449449.1 DNA adenine methylase [Fusobacterium sp.]	diamond	297	63.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.

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