metadata: contig_metadata: 22 rows where bioproject = "PRJNA1240804" and tax

22 rows where bioproject = "PRJNA1240804" 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
1621606	1621606	PRJNA1240804_P_NODE_11602_length_385_cov_3.735119_g11237_i0	PRJNA1240804	11602	385	3.735119	14.38020815	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	577	4.8999999999999986e-160	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g11237	i0	94.638	151.062337662338	373	19	97	1	1	372	51958	51586	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	58159	577	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
1623270	1623270	PRJNA1240804_P_NODE_61102_length_203_cov_2.467532_g60736_i0	PRJNA1240804	61102	203	2.467532	5.00908996	Leptotrichia hofstadii	157688	Bacteria	Bacteria	333	5.639999999999999e-87	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g60736	i0	98.925	248.128078817734	186	2	92	0	18	203	2257389	2257204	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	50370	333	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
1623333	1623333	PRJNA1240804_P_NODE_64062_length_200_cov_1.264901_g63696_i0	PRJNA1240804	64062	200	1.264901	2.529802	Sneathia vaginalis	187101	Bacteria	Bacteria	344	2.56e-90	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g63696	i0	100	159.635	186	0	93	0	15	200	161908	162093	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	31927	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
5451791	5451791	PRJNA1240804_P_NODE_44025_length_229_cov_1.672222_g43659_i0	PRJNA1240804	44025	229	1.672222	3.82938838	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	339	1.4e-88	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g43659	i0	94.545	202.903930131004	220	10	95	2	6	223	1997442	1997661	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	46465	339	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
9275100	9275100	PRJNA1240804_P_NODE_110148_length_169_cov_0.866667_g109782_i0	PRJNA1240804	110148	169	0.866667	1.46466723	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	279	5.95e-71	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g109782	i0	98.726	458.112426035503	157	2	93	0	12	168	53698	53854	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	77421	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9275772	9275772	PRJNA1240804_P_NODE_149128_length_162_cov_0.920354_g148762_i0	PRJNA1240804	149128	162	0.920354	1.49097348	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	254	3.44e-63	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g148762	i0	97.959	232.62962962963	147	2	90	1	15	160	25354	25500	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	37686	254	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
9277153	9277153	PRJNA1240804_P_NODE_75068_length_190_cov_1.219858_g74702_i0	PRJNA1240804	75068	190	1.219858	2.3177302	Leptotrichia buccalis	40542	Bacteria	Bacteria	315	1.89e-81	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g74702	i0	98.324	123.852631578947	179	3	94	0	1	179	119249	119071	Leptotrichia buccalis DSM 1135, complete genome	blastn	23532	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
13101483	13101483	PRJNA1240804_P_NODE_16591_length_335_cov_2.286713_g16226_i0	PRJNA1240804	16591	335	2.286713	7.66048855	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	595	1.1599999999999998e-165	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g16226	i0	100	456.065671641791	322	0	96	0	13	334	2228101	2227780	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	152782	595	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
13101577	13101577	PRJNA1240804_P_NODE_19871_length_312_cov_4.326996_g19505_i0	PRJNA1240804	19871	312	4.326996	13.50022752	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	462	1.14e-125	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g19505	i0	94.649	415.5	299	14	96	2	1	298	52250	51953	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	129636	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
13803612	13803612	PRJNA1240804_P_NODE_43751_length_230_cov_1.055249_g43385_i0	PRJNA1240804	43751	230	1.055249	2.4270727	Leptotrichia	32067	Bacteria	Bacteria	141	4.26e-29	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g43385	i0	85.612	120.773913043478	139	15	60	5	19	155	1995379	1995244	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	27778	141	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
14376907	14376907	PRJNA1240804_P_NODE_25472_length_283_cov_3.183761_g25106_i0	PRJNA1240804	25472	283	3.183761	9.01004363	Leptotrichia hofstadii	157688	Bacteria	Bacteria	490	4.67e-134	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g25106	i0	97.88	82.7031802120141	283	6	100	0	1	283	2374484	2374766	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	23405	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
15649917	15649917	PRJNA1240804_P_NODE_113733_length_168_cov_0.873950_g113367_i0	PRJNA1240804	113733	168	0.87395	1.468236	Fusobacterium gastrosuis	1755100	Bacteria	Bacteria	89.8	1.08e-13	NTclustered	gi\|1795735174\|emb\|LT607734.1\|	1755100	g113367	i0	100	83.2083333333333	48	0	29	0	3	50	846369	846322	Fusobacterium sp. P6 Po strain Fusobacterium gastrosuis sp. nov. CDW1, P6 Po genome assembly, chromosome: chr	blastn	13979	89.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium gastrosuis
15650623	15650623	PRJNA1240804_P_NODE_154173_length_153_cov_2.028846_g153807_i0	PRJNA1240804	154173	153	2.028846	3.10413438	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g153807	i0	99.351	493.019607843137	154	0	100	1	1	153	199325	199478	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	75432	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
15651694	15651694	PRJNA1240804_P_NODE_64073_length_200_cov_1.264901_g63707_i0	PRJNA1240804	64073	200	1.264901	2.529802	Leptotrichia wadei	157687	Bacteria	Bacteria	342	9.209999999999999e-90	NTclustered	gi\|1791353085\|dbj\|AP019829.2\|	157687	g63707	i0	99.468	32.58	188	1	94	0	12	199	633877	634064	Leptotrichia wadei JCM16777 DNA, complete genome	blastn	6516	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
16352793	16352793	PRJNA1240804_P_NODE_7613_length_455_cov_7.995074_g7251_i0	PRJNA1240804	7613	455	7.995074	36.3775867	Fusobacterium	848	Bacteria	Bacteria	501	3.64e-137	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g7251	i0	86.813	485.164835164835	455	52	99	8	3	455	157150	156702	Fusobacterium varium strain SB069 chromosome	blastn	220750	501	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
18901873	18901873	PRJNA1240804_P_NODE_77035_length_188_cov_2.323741_g76669_i0	PRJNA1240804	77035	188	2.323741	4.36863308	Fusobacterium	848	Bacteria	Bacteria	316	5.17e-82	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g76669	i0	99.425	360.781914893617	174	1	93	0	1	174	56565	56392	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	67827	316	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
22024249	22024249	PRJNA1240804_P_NODE_145298_length_163_cov_0.912281_g144932_i0	PRJNA1240804	145298	163	0.912281	1.48701803	Fusobacterium polymorphum	76857	Bacteria	Bacteria	270	3.4499999999999993e-68	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g144932	i0	99.329	90.7546012269939	149	1	91	0	2	150	856830	856682	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	14793	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
22727391	22727391	PRJNA1240804_P_NODE_98118_length_174_cov_2.368000_g97752_i0	PRJNA1240804	98118	174	2.368	4.12032	Bacteria	2	Bacteria	Bacteria	176	8.32e-40	NTclustered	gi\|2892346784\|dbj\|AP035781.1\|	2053555	g97752	i0	90	209.816091954023	140	8	79	6	10	146	3217	3081	Fusobacteriaceae bacterium 9N8 DNA, complete genome	blastn	36508	176	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
24002124	24002124	PRJNA1240804_P_NODE_21479_length_303_cov_1.937008_g21113_i0	PRJNA1240804	21479	303	1.937008	5.86913424	Streptobacillus	34104	Bacteria	Bacteria	472	1.83e-128	NTclustered	gi\|470485174\|ref\|NR_076688.1\|	34105	g21113	i0	95.318	457.679867986799	299	11	98	3	1	297	1112	1409	Streptobacillus moniliformis strain DSM 12112 23S ribosomal RNA gene, complete sequence	blastn	138677	472	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
27358098	27358098	PRJNA1240804_P_NODE_115903_length_168_cov_0.873950_g115537_i0	PRJNA1240804	115903	168	0.87395	1.468236	Leptotrichia sp. oral taxon 215	712359	Bacteria	Bacteria	84	8.29e-18	NR	WP_021766145.1	712359	g115537	i0	91.1	0.803571428571429	45	4	80.4	0	148	14	141	185	WP_021766145.1 Cof-type HAD-IIB family hydrolase [Leptotrichia sp. oral taxon 215]	diamond	135	84	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 215
28936714	28936714	PRJNA1240804_P_NODE_105748_length_170_cov_0.735537_g105382_i0	PRJNA1240804	105748	170	0.735537	1.2504129	Fusobacterium massiliense	1852365	Bacteria	Bacteria	57	1.3e-7	NR	WP_315522735.1	1852365	g105382	i0	72.7	0.776470588235294	44	10	74.1	1	33	158	1078	1121	WP_315522735.1 YadA-like family protein [Fusobacterium massiliense]	diamond	132	57	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium massiliense
29441561	29441561	PRJNA1240804_P_NODE_119750_length_167_cov_0.881356_g119384_i0	PRJNA1240804	119750	167	0.881356	1.47186452	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	60.1	9.63e-10	NR	MBU9916984.1	2053555	g119384	i0	64.6	1.58083832335329	48	17	86.2	0	146	3	61	108	MBU9916984.1 hypothetical protein [Fusobacteriaceae bacterium]	diamond	264	60.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium

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