metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax

17 rows where analysis = "diamond", bioproject = "PRJEB11748" 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
20474	20474	PRJEB11748_P_NODE_91661_length_437_cov_6.021277_g89493_i0	PRJEB11748	91661	437	6.021277	26.31298049	Leptotrichia sp. oral taxon 417	712365	Bacteria	Bacteria	152	3.62e-41	NR	WP_178937391.1	712365	g89493	i0	70.6	0.700228832951945	102	30	70	0	2	307	351	452	WP_178937391.1 RNA-guided endonuclease InsQ/TnpB family protein [Leptotrichia sp. oral taxon 417]	diamond	306	152	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 417
3845448	3845448	PRJEB11748_P_NODE_43444_length_657_cov_2.649329_g41378_i0	PRJEB11748	43444	657	2.649329	17.40609153	Streptobacillus moniliformis	34105	Bacteria	Bacteria	205	2.61e-64	NR	WP_196762291.1	34105	g41378	i0	100	0.981735159817352	103	0	47	0	655	347	19	121	WP_196762291.1 terminase gpA endonuclease subunit, partial [Streptobacillus moniliformis]	diamond	645	205	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
26779815	26779815	PRJEB11748_P_NODE_35701_length_735_cov_3.375371_g33762_i0	PRJEB11748	35701	735	3.375371	24.80897685	Fusobacterium necrophorum	859	Bacteria	Bacteria	65.5	1.47e-9	NR	WP_285061471.1	859	g33762	i0	45.1	0.33469387755102	82	45	33.5	0	158	403	5	86	WP_285061471.1 tetratricopeptide repeat protein, partial [Fusobacterium necrophorum]	diamond	246	65.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
27500823	27500823	PRJEB11748_P_NODE_82603_length_461_cov_81.472500_g80438_i0	PRJEB11748	82603	461	81.4725	375.588225	Cetobacterium	180162	Bacteria	Bacteria	129	3.95e-35	NR	WP_047395587.1	1339239	g80438	i0	97.1	0.911062906724512	70	2	45.6	0	366	157	9	78	WP_047395587.1 hypothetical protein, partial [Cetobacterium sp. ZOR0034]	diamond	420	129	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
28390831	28390831	PRJEB11748_P_NODE_157106_length_326_cov_63.154717_g154924_i0	PRJEB11748	157106	326	63.154717	205.88437742	Fusobacterium ulcerans	861	Bacteria	Bacteria	125	5.55e-33	NR	WP_302820711.1	861	g154924	i0	90.3	0.662576687116564	72	6	66.3	1	19	234	48	118	WP_302820711.1 C-GCAxxG-C-C family (seleno)protein [Fusobacterium ulcerans]	diamond	216	125	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
28574133	28574133	PRJEB11748_P_NODE_383007_length_177_cov_6.775862_g380824_i0	PRJEB11748	383007	177	6.775862	11.99327574	Fusobacterium	848	Bacteria	Bacteria	67.8	2.08e-11	NR	MBS9776340.1	68766	g380824	i0	54.2	2	59	27	100	0	1	177	38	96	MBS9776340.1 iron-containing alcohol dehydrogenase [Fusobacterium sp.]	diamond	354	68.2	0.994134897360704	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
28763506	28763506	PRJEB11748_P_NODE_141047_length_347_cov_2.255245_g138868_i0	PRJEB11748	141047	347	2.255245	7.82570015	Bacteria	2	Bacteria	Bacteria	96.7	2.25e-21	NR	WP_071124239.1	1852388	g138868	i0	54.2	1.51296829971182	83	38	71.8	0	38	286	176	258	WP_071124239.1 hypothetical protein [Leptotrichia massiliensis]	diamond	525	97.4	0.992813141683778	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia massiliensis
29237322	29237322	PRJEB11748_P_NODE_209769_length_275_cov_18.570093_g207586_i0	PRJEB11748	209769	275	18.570093	51.06775575	Bacteria	2	Bacteria	Bacteria	67.8	8.66e-11	NR	WP_297486955.1	527638	g207586	i0	44.4	2.43272727272727	81	44	87.3	1	264	25	806	886	WP_297486955.1 phosphoribosylformylglycinamidine synthase [uncultured Cetobacterium sp.]	diamond	669	67.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
29773838	29773838	PRJEB11748_P_NODE_261571_length_240_cov_1.642458_g259388_i0	PRJEB11748	261571	240	1.642458	3.9418992	Bacteria	2	Bacteria	Bacteria	157	3.76e-45	NR	KAB0578304.1	77917	g259388	i0	98.7	1.975	79	1	98.8	0	2	238	146	224	KAB0578304.1 exonuclease domain-containing protein [Fusobacterium naviforme]	diamond	474	157	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium naviforme
30121303	30121303	PRJEB11748_P_NODE_284792_length_227_cov_2.337349_g282609_i0	PRJEB11748	284792	227	2.337349	5.30578223	Bacteria	2	Bacteria	Bacteria	66.2	6.56e-12	NR	WP_021768122.1	32067	g282609	i0	63	7.53303964757709	46	17	60.8	0	222	85	67	112	WP_021768122.1 MULTISPECIES: histidine triad nucleotide-binding protein [Leptotrichia]	diamond	1710	66.6	0.993993993993994	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia
30759733	30759733	PRJEB11748_P_NODE_41894_length_671_cov_10.881967_g39845_i0	PRJEB11748	41894	671	10.881967	73.01799857	Sebaldella sp.	2819260	Bacteria	Bacteria	217	3.74e-64	NR	MBP9479417.1	2819260	g39845	i0	50.7	0.934426229508197	209	102	93.4	1	660	34	292	499	MBP9479417.1 DHA2 family efflux MFS transporter permease subunit [Sebaldella sp.]	diamond	627	217	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella sp.
30784949	30784949	PRJEB11748_P_NODE_341294_length_202_cov_1.680851_g339111_i0	PRJEB11748	341294	202	1.680851	3.39531902	Bacteria	2	Bacteria	Bacteria	98.6	4.3e-23	NR	WP_367102152.1	1755100	g339111	i0	87.5	5.67326732673267	48	6	71.3	0	57	200	20	67	WP_367102152.1 3-keto-5-aminohexanoate cleavage protein [Fusobacterium gastrosuis]	diamond	1146	98.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium gastrosuis
30854361	30854361	PRJEB11748_P_NODE_341354_length_202_cov_1.659574_g339171_i0	PRJEB11748	341354	202	1.659574	3.35233948	Fusobacterium naviforme	77917	Bacteria	Bacteria	135	5.2e-35	NR	KAB0576586.1	77917	g339171	i0	98.5	0.995049504950495	67	1	99.5	0	201	1	29	95	KAB0576586.1 PolC-type DNA polymerase III [Fusobacterium naviforme]	diamond	201	135	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium naviforme
30949264	30949264	PRJEB11748_P_NODE_205274_length_279_cov_5.000000_g203091_i0	PRJEB11748	205274	279	5	13.95	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	145	1.56e-39	NR	MBP6408967.1	2053555	g203091	i0	98.7	1.63440860215054	76	1	81.7	0	278	51	365	440	MBP6408967.1 TolC family protein [Fusobacteriaceae bacterium]	diamond	456	145	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
31613116	31613116	PRJEB11748_P_NODE_314416_length_213_cov_1.289474_g312233_i0	PRJEB11748	314416	213	1.289474	2.74657962	Oceanivirga miroungae	1130046	Bacteria	Bacteria	92.8	8.8e-21	NR	WP_231679249.1	1130046	g312233	i0	64.1	0.901408450704225	64	23	90.1	0	22	213	216	279	WP_231679249.1 ROK family protein [Oceanivirga miroungae]	diamond	192	92.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Oceanivirga	Oceanivirga miroungae
32619001	32619001	PRJEB11748_P_NODE_144140_length_343_cov_1.407801_g141961_i0	PRJEB11748	144140	343	1.407801	4.82875743	Bacteria	2	Bacteria	Bacteria	57	9.39e-7	NR	MDO5789591.1	68766	g141961	i0	75.7	1.00583090379009	37	9	32.4	0	112	2	6	42	MDO5789591.1 LysR family transcriptional regulator [Fusobacterium sp.]	diamond	345	57	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
32625143	32625143	PRJEB11748_P_NODE_327500_length_207_cov_4.280822_g325317_i0	PRJEB11748	327500	207	4.280822	8.86130154	Fusobacterium massiliense	1852365	Bacteria	Bacteria	68.2	2.46e-11	NR	WP_074016579.1	1852365	g325317	i0	96.6	0.420289855072464	29	1	42	0	187	101	562	590	WP_074016579.1 acyltransferase family protein [Fusobacterium massiliense]	diamond	87	68.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium massiliense

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