metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA1145997" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA1145997" 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
289478	289478	PRJNA1145997_P_NODE_37121_length_288_cov_1.404651_g34502_i0	PRJNA1145997	37121	288	1.404651	4.04539488	Fusobacterium polymorphum	76857	Bacteria	Bacteria	309	1.4300000000000002e-79	NTclustered	gi\|2706071841\|gb\|CP077111.1\|	76857	g34502	i0	86.207	51.125	290	34	99	6	2	288	1005102	1004816	Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome	blastn	14724	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
289570	289570	PRJNA1145997_P_NODE_43121_length_252_cov_0.871508_g40502_i0	PRJNA1145997	43121	252	0.871508	2.19620016	Fusobacterium sp. oral taxon 203	671211	Bacteria	Bacteria	440	4.1699999999999984e-119	NTclustered	gi\|1229037590\|gb\|CP016200.1\|	671211	g40502	i0	98.4	99.9920634920635	250	4	99	0	3	252	1065266	1065515	Fusobacterium sp. oral taxon 203 strain W7671 chromosome, partial genome	blastn	25198	440	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp. oral taxon 203
2840479	2840479	PRJNA1145997_P_NODE_47723_length_244_cov_0.912281_g45104_i0	PRJNA1145997	47723	244	0.912281	2.22596564	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	418	1.8799999999999994e-112	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g45104	i0	97.541	1	244	6	100	0	1	244	1593342	1593099	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	244	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4116451	4116451	PRJNA1145997_P_NODE_32764_length_337_cov_1.181818_g30145_i0	PRJNA1145997	32764	337	1.181818	3.98272666	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	595	1.1699999999999996e-165	NTclustered	gi\|958157244\|gb\|CP013336.1\|	1307443	g30145	i0	98.516	359.350148367952	337	5	100	0	1	337	1393516	1393180	Fusobacterium hwasookii ChDC F206, complete genome	blastn	121101	595	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
4116631	4116631	PRJNA1145997_P_NODE_44824_length_249_cov_0.886364_g42205_i0	PRJNA1145997	44824	249	0.886364	2.20704636	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	355	1.53e-93	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g42205	i0	93.333	0.963855421686747	240	16	96	0	1	240	578052	577813	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	240	355	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
6667502	6667502	PRJNA1145997_P_NODE_44086_length_250_cov_0.881356_g41467_i0	PRJNA1145997	44086	250	0.881356	2.20339	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g41467	i0	97.2	99.992	250	7	100	0	1	250	789461	789710	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	24998	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
6667518	6667518	PRJNA1145997_P_NODE_44726_length_249_cov_0.886364_g42107_i0	PRJNA1145997	44726	249	0.886364	2.20704636	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	383	7.04e-102	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g42107	i0	94.378	44.9879518072289	249	14	100	0	1	249	493453	493205	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	11202	383	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
7411288	7411288	PRJNA1145997_P_NODE_27966_length_430_cov_1.310924_g25349_i0	PRJNA1145997	27966	430	1.310924	5.6369732	Bacteria	2	Bacteria	Bacteria	789	0	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g25349	i0	99.767	101	430	1	100	0	1	430	1974781	1974352	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	43430	795	0.992452830188679	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7942603	7942603	PRJNA1145997_P_NODE_39567_length_270_cov_1.187817_g36948_i0	PRJNA1145997	39567	270	1.187817	3.2071059	Leptotrichia wadei	157687	Bacteria	Bacteria	444	3.49e-120	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g36948	i0	96.296	2	270	10	100	0	1	270	2286707	2286438	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	540	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
9961663	9961663	PRJNA1145997_P_NODE_42308_length_253_cov_0.866667_g39689_i0	PRJNA1145997	42308	253	0.866667	2.19266751	Fusobacterium	848	Bacteria	Bacteria	444	3.24e-120	NTclustered	gi\|2078814929\|gb\|CP071093.1\|	155615	g39689	i0	98.062	102.067193675889	258	0	100	1	1	253	1013601	1013858	Fusobacterium vincentii strain THCT14A3 chromosome, complete genome	blastn	25823	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium vincentii
10493242	10493242	PRJNA1145997_P_NODE_42349_length_253_cov_0.866667_g39730_i0	PRJNA1145997	42349	253	0.866667	2.19266751	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	451	1.94e-122	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g39730	i0	98.814	83.1185770750988	253	3	100	0	1	253	2477102	2477354	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	21029	451	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
11236700	11236700	PRJNA1145997_P_NODE_30329_length_378_cov_4.422951_g27710_i0	PRJNA1145997	30329	378	4.422951	16.71875478	Fusobacterium	848	Bacteria	Bacteria	652	0	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g27710	i0	99.443	472.978835978836	359	2	95	0	20	378	1740093	1740451	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	178786	658	0.990881458966565	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
11236809	11236809	PRJNA1145997_P_NODE_43449_length_251_cov_0.876404_g40830_i0	PRJNA1145997	43449	251	0.876404	2.19977404	Fusobacterium	848	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g40830	i0	100	99.8844621513944	251	0	100	0	1	251	114501	114251	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	25071	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
11768339	11768339	PRJNA1145997_P_NODE_47670_length_244_cov_0.912281_g45051_i0	PRJNA1145997	47670	244	0.912281	2.22596564	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g45051	i0	98.77	6	244	3	100	0	1	244	2317951	2318194	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1464	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
11768350	11768350	PRJNA1145997_P_NODE_48610_length_243_cov_0.917647_g45991_i0	PRJNA1145997	48610	243	0.917647	2.22988221	Leptotrichia shahii	157691	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g45991	i0	98.765	8.96707818930041	243	3	100	0	1	243	1519169	1519411	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	2179	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
15592535	15592535	PRJNA1145997_P_NODE_45833_length_247_cov_0.896552_g43214_i0	PRJNA1145997	45833	247	0.896552	2.21448344	Fusobacterium nucleatum	851	Bacteria	Bacteria	422	1.48e-113	NTclustered	gi\|2705036157\|gb\|CP084147.1\|	851	g43214	i0	97.561	99.5668016194332	246	6	99	0	2	247	1523204	1523449	Fusobacterium nucleatum strain KCOM2883 chromosome, complete genome	blastn	24593	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
16866737	16866737	PRJNA1145997_P_NODE_43834_length_250_cov_1.446328_g41215_i0	PRJNA1145997	43834	250	1.446328	3.61582	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|1276716588\|gb\|CP024703.1\|	2663009	g41215	i0	97.2	100	250	7	100	0	1	250	1612169	1611920	Fusobacterium pseudoperiodonticum strain KCOM 2305 chromosome, complete genome	blastn	25000	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
19415643	19415643	PRJNA1145997_P_NODE_42416_length_253_cov_0.866667_g39797_i0	PRJNA1145997	42416	253	0.866667	2.19266751	Fusobacterium polymorphum	76857	Bacteria	Bacteria	300	7.43e-77	NTclustered	gi\|2706067283\|gb\|CP077110.1\|	76857	g39797	i0	89.744	0.924901185770751	234	24	92	0	3	236	483315	483082	Fusobacterium polymorphum strain KCOM1278 chromosome, complete genome	blastn	234	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
19415724	19415724	PRJNA1145997_P_NODE_47176_length_245_cov_0.906977_g44557_i0	PRJNA1145997	47176	245	0.906977	2.22209365	Leptotrichia wadei	157687	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g44557	i0	100	12.8816326530612	245	0	100	0	1	245	554713	554957	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	3156	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
20159842	20159842	PRJNA1145997_P_NODE_34436_length_316_cov_1.283951_g31817_i0	PRJNA1145997	34436	316	1.283951	4.05728516	Fusobacterium	848	Bacteria	Bacteria	540	5.18e-149	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g31817	i0	97.468	100	316	8	100	0	1	316	1583110	1583425	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	31600	545	0.990825688073395	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20159920	20159920	PRJNA1145997_P_NODE_45916_length_247_cov_0.896552_g43297_i0	PRJNA1145997	45916	247	0.896552	2.21448344	Fusobacterium	848	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g43297	i0	100	99.2874493927125	247	0	100	0	1	247	1195333	1195579	Fusobacterium hwasookii ChDC F174, complete genome	blastn	24524	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
21435388	21435388	PRJNA1145997_P_NODE_37997_length_281_cov_1.461538_g35378_i0	PRJNA1145997	37997	281	1.461538	4.10692178	Leptotrichia	32067	Bacteria	Bacteria	466	7.81e-127	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g35378	i0	96.774	188.822064056939	279	9	100	0	2	280	34526	34804	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	53059	466	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21966435	21966435	PRJNA1145997_P_NODE_43038_length_252_cov_0.871508_g40419_i0	PRJNA1145997	43038	252	0.871508	2.19620016	Leptotrichia wadei	157687	Bacteria	Bacteria	392	1.1899999999999997e-104	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g40419	i0	95.161	6.94047619047619	248	12	100	0	1	248	870193	870440	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	1749	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
23985842	23985842	PRJNA1145997_P_NODE_51939_length_197_cov_7.346774_g49320_i0	PRJNA1145997	51939	197	7.346774	14.47314478	Fusobacterium	848	Bacteria	Bacteria	324	3.27e-84	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g49320	i0	100	413.873096446701	175	0	89	0	3	177	997085	997259	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	81533	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
24515560	24515560	PRJNA1145997_P_NODE_48400_length_243_cov_0.917647_g45781_i0	PRJNA1145997	48400	243	0.917647	2.22988221	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	357	4.1399999999999997e-94	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g45781	i0	93.361	71.8971193415638	241	16	99	0	3	243	2147528	2147288	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	17471	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
24515561	24515561	PRJNA1145997_P_NODE_48440_length_243_cov_0.917647_g45821_i0	PRJNA1145997	48440	243	0.917647	2.22988221	Leptotrichia wadei	157687	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g45821	i0	98.354	4.98353909465021	243	4	100	0	1	243	777826	778068	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	1211	427	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
25259860	25259860	PRJNA1145997_P_NODE_44740_length_249_cov_0.886364_g42121_i0	PRJNA1145997	44740	249	0.886364	2.20704636	Fusobacterium	848	Bacteria	Bacteria	405	1.5e-108	NTclustered	gi\|2705001187\|gb\|CP084066.1\|	859	g42121	i0	95.984	5.99598393574297	249	10	100	0	1	249	463758	463510	Fusobacterium necrophorum strain SB057 chromosome, complete genome	blastn	1493	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum

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