metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392381	392381	PRJNA340009_P_NODE_56061_length_174_cov_3.976000_g55754_i0	PRJNA340009	56061	174	3.976	6.91824	Leptotrichia wadei	157687	Bacteria	Bacteria	294	2.1999999999999998e-75	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g55754	i0	97.126	1.98275862068966	174	5	100	0	1	174	353118	352945	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	345	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
2942556	2942556	PRJNA340009_P_NODE_18883_length_277_cov_1.342105_g18576_i0	PRJNA340009	18883	277	1.342105	3.71763085	Sneathia vaginalis	187101	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g18576	i0	99.639	3	277	1	100	0	1	277	603543	603819	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	831	507	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
4219121	4219121	PRJNA340009_P_NODE_14224_length_313_cov_1.920455_g13917_i0	PRJNA340009	14224	313	1.920455	6.01102415	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	573	5.049999999999998e-159	NTclustered	gi\|2078812864\|gb\|CP071092.1\|	1583098	g13917	i0	99.681	99.961661341853	313	1	100	0	1	313	744268	744580	Fusobacterium hwasookii strain THCT14E2 chromosome, complete genome	blastn	31288	573	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
4219242	4219242	PRJNA340009_P_NODE_23644_length_251_cov_2.915842_g23337_i0	PRJNA340009	23644	251	2.915842	7.31876342	Leptotrichia sp. oral taxon 847	1785996	Bacteria	Bacteria	357	4.3e-94	NTclustered	gi\|987458696\|gb\|CP014231.1\|	1785996	g23337	i0	96.313	389.577689243028	217	8	86	0	21	237	1478858	1479074	Leptotrichia sp. oral taxon 847 strain F0260 chromosome, complete genome	blastn	97784	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 847
4219595	4219595	PRJNA340009_P_NODE_54304_length_177_cov_1.546875_g53997_i0	PRJNA340009	54304	177	1.546875	2.73796875	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g53997	i0	99.435	1	177	1	100	0	1	177	677	501	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	177	322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
5496125	5496125	PRJNA340009_P_NODE_69005_length_164_cov_0.886957_g68698_i0	PRJNA340009	69005	164	0.886957	1.45460948	Leptotrichia wadei	157687	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g68698	i0	100	4	164	0	100	0	1	164	1178737	1178900	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	656	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
6172878	6172878	PRJNA340009_P_NODE_31345_length_223_cov_1.442529_g31038_i0	PRJNA340009	31345	223	1.442529	3.21683967	Fusobacterium	848	Bacteria	Bacteria	239	1.42e-58	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g31038	i0	100	62.0224215246637	129	0	100	0	1	129	740611	740739	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	13831	239	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9998297	9998297	PRJNA340009_P_NODE_66668_length_165_cov_0.879310_g66361_i0	PRJNA340009	66668	165	0.87931	1.4508615	Leptotrichia	32067	Bacteria	Bacteria	182	1.6899999999999996e-41	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g66361	i0	87.037	8.49090909090909	162	20	98	1	4	164	1969826	1969987	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	1401	182	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
10595863	10595863	PRJNA340009_P_NODE_36949_length_208_cov_1.496855_g36642_i0	PRJNA340009	36949	208	1.496855	3.1134584	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	379	7.359999999999998e-101	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g36642	i0	99.519	474.399038461538	208	1	100	0	1	208	197355	197562	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	98675	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
11870443	11870443	PRJNA340009_P_NODE_10250_length_358_cov_7.724919_g9943_i0	PRJNA340009	10250	358	7.724919	27.65521002	Sneathia sanguinegens	40543	Bacteria	Bacteria	628	1.2299999999999997e-175	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g9943	i0	98.324	1	358	6	100	0	1	358	80795	80438	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	358	628	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
14420709	14420709	PRJNA340009_P_NODE_18272_length_281_cov_1.318966_g17965_i0	PRJNA340009	18272	281	1.318966	3.70629446	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	475	1.2999999999999999e-129	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g17965	i0	97.153	3	281	8	100	0	1	281	1251964	1251684	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	843	475	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
14421138	14421138	PRJNA340009_P_NODE_59072_length_170_cov_3.181818_g58765_i0	PRJNA340009	59072	170	3.181818	5.4090906	uncultured Leptotrichia sp.	159271	Bacteria	Bacteria	298	1.65e-76	NTclustered	gi\|571048574\|gb\|KF422121.1\|	159271	g58765	i0	100	23.6529411764706	161	0	95	0	10	170	181	21	Uncultured Leptotrichia sp. clone VostokV6_rep_c139 genomic sequence	blastn	4021	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	uncultured Leptotrichia sp.
15694819	15694819	PRJNA340009_P_NODE_40213_length_201_cov_1.157895_g39906_i0	PRJNA340009	40213	201	1.157895	2.32736895	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	254	4.46e-63	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g39906	i0	90.625	399.626865671642	192	17	95	1	11	201	197764	197955	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	80325	254	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
16969827	16969827	PRJNA340009_P_NODE_6394_length_433_cov_7.190104_g6087_i0	PRJNA340009	6394	433	7.190104	31.13315032	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	701	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g6087	i0	95.843	1.07621247113164	433	18	100	0	1	433	2235194	2234762	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	466	701	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
17647520	17647520	PRJNA340009_P_NODE_14714_length_308_cov_5.459459_g14407_i0	PRJNA340009	14714	308	5.459459	16.81513372	Fusobacterium	848	Bacteria	Bacteria	553	6.46e-153	NTclustered	gi\|2704998788\|gb\|CP077147.1\|	851	g14407	i0	99.344	98.8701298701299	305	2	99	0	4	308	1076889	1077193	Fusobacterium nucleatum strain KCOM2373 chromosome, complete genome	blastn	30452	558	0.991039426523297	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19517745	19517745	PRJNA340009_P_NODE_17676_length_285_cov_1.220339_g17369_i0	PRJNA340009	17676	285	1.220339	3.47796615	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	414	2.9099999999999998e-111	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g17369	i0	93.818	281.873684210526	275	17	96	0	1	275	51878	52152	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	80334	414	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19518350	19518350	PRJNA340009_P_NODE_71016_length_163_cov_1.254386_g70709_i0	PRJNA340009	71016	163	1.254386	2.04464918	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	278	2.06e-70	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g70709	i0	99.346	373.104294478528	153	1	94	0	1	153	54131	53979	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	60816	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
21471734	21471734	PRJNA340009_P_NODE_35337_length_212_cov_1.294479_g35030_i0	PRJNA340009	35337	212	1.294479	2.74429548	Fusobacterium	848	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g35030	i0	100	481.669811320755	212	0	100	0	1	212	322219	322008	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	102114	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
22068938	22068938	PRJNA340009_P_NODE_65058_length_166_cov_0.871795_g64751_i0	PRJNA340009	65058	166	0.871795	1.4471797	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	206	1.01e-48	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g64751	i0	90.446	4.7289156626506	157	14	94	1	1	156	53833	53677	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	785	206	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24021925	24021925	PRJNA340009_P_NODE_66399_length_165_cov_0.879310_g66092_i0	PRJNA340009	66399	165	0.87931	1.4508615	Fusobacterium	848	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g66092	i0	100	456.993939393939	165	0	100	0	1	165	91818	91654	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	75404	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum

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