metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA797655" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA797655" 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
788911	788911	PRJNA797655_S_NODE_80401_length_267_cov_2.937500_g79796_i0	PRJNA797655	80401	267	2.9375	7.843125	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	460	3.4299999999999996e-125	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g79796	i0	97.753	36.2097378277154	267	6	100	0	1	267	52068	51802	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	9668	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
789228	789228	PRJNA797655_S_NODE_91061_length_255_cov_2.264151_g90456_i0	PRJNA797655	91061	255	2.264151	5.77358505	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	58.4	4.98e-4	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g90456	i0	97.059	0.133333333333333	34	1	13	0	81	114	1591178	1591211	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
2064962	2064962	PRJNA797655_S_NODE_90222_length_256_cov_2.028169_g89617_i0	PRJNA797655	90222	256	2.028169	5.19211264	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	440	4.249999999999998e-119	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g89617	i0	97.656	64.83203125	256	6	100	0	1	256	134066	133811	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	16597	440	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
2065178	2065178	PRJNA797655_S_NODE_96662_length_249_cov_2.563107_g96057_i0	PRJNA797655	96662	249	2.563107	6.38213643	Leptotrichia buccalis	40542	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g96057	i0	99.598	5.78313253012048	249	1	100	0	1	249	559060	559308	Leptotrichia buccalis DSM 1135, complete genome	blastn	1440	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
3336728	3336728	PRJNA797655_S_NODE_231623_length_165_cov_1.770492_g231018_i0	PRJNA797655	231623	165	1.770492	2.9213118	Fusobacterium polymorphum	76857	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g231018	i0	99.394	438.381818181818	165	1	100	0	1	165	709183	709019	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	72333	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
3768795	3768795	PRJNA797655_S_NODE_131463_length_219_cov_1.636364_g130858_i0	PRJNA797655	131463	219	1.636364	3.58363716	Fusobacterium	848	Bacteria	Bacteria	396	7.769999999999997e-106	NTclustered	gi\|2705003210\|gb\|CP084117.1\|	851	g130858	i0	99.095	101.013698630137	221	0	100	1	1	219	1819762	1819982	Fusobacterium nucleatum strain KCOM3486 chromosome, complete genome	blastn	22122	396	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
3769200	3769200	PRJNA797655_S_NODE_51663_length_311_cov_3.518657_g51058_i0	PRJNA797655	51663	311	3.518657	10.94302327	Leptotrichia	32067	Bacteria	Bacteria	564	3.02e-156	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g51058	i0	99.357	491.311897106109	311	2	100	0	1	311	265351	265041	Leptotrichia buccalis DSM 1135, complete genome	blastn	152798	569	0.991212653778559	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
5045569	5045569	PRJNA797655_S_NODE_28644_length_372_cov_5.288754_g28040_i0	PRJNA797655	28644	372	5.288754	19.67416488	Fusobacterium	848	Bacteria	Bacteria	682	0	NTclustered	gi\|2706506546\|gb\|CP084156.1\|	76857	g28040	i0	99.731	480.983870967742	372	1	100	0	1	372	1842174	1841803	Fusobacterium polymorphum strain KCOM2510 chromosome	blastn	178926	682	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
6321245	6321245	PRJNA797655_S_NODE_182085_length_187_cov_3.027778_g181480_i0	PRJNA797655	182085	187	3.027778	5.66194486	Leptotrichia	32067	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g181480	i0	100	463.764705882353	187	0	100	0	1	187	2532	2346	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	86724	346	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
9711422	9711422	PRJNA797655_S_NODE_150508_length_206_cov_1.177914_g149903_i0	PRJNA797655	150508	206	1.177914	2.42650284	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g149903	i0	100	99.995145631068	206	0	100	0	1	206	1576435	1576230	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	20599	381	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
10985896	10985896	PRJNA797655_S_NODE_110649_length_236_cov_1.761658_g110044_i0	PRJNA797655	110649	236	1.761658	4.15751288	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g110044	i0	100	0.355932203389831	28	0	12	0	208	235	2076414	2076441	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
12261534	12261534	PRJNA797655_S_NODE_115290_length_232_cov_1.777778_g114685_i0	PRJNA797655	115290	232	1.777778	4.12444496	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	412	8.26e-111	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g114685	i0	98.712	1.00431034482759	233	2	100	1	1	232	509538	509770	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	233	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
14810299	14810299	PRJNA797655_S_NODE_106012_length_240_cov_2.243655_g105407_i0	PRJNA797655	106012	240	2.243655	5.384772	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g105407	i0	100	9.0125	240	0	100	0	1	240	46373	46134	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	2163	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
15245866	15245866	PRJNA797655_S_NODE_3652_length_694_cov_5.832565_g3223_i0	PRJNA797655	3652	694	5.832565	40.4780011	Fusobacterium	848	Bacteria	Bacteria	1266	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g3223	i0	99.568	480.004322766571	694	3	100	0	1	694	463054	462361	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	333123	1277	0.991386061080658	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
16090119	16090119	PRJNA797655_S_NODE_38773_length_340_cov_3.377104_g38168_i0	PRJNA797655	38773	340	3.377104	11.4821536	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	628	1.1699999999999999e-175	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g38168	i0	100	100	340	0	100	0	1	340	2443859	2443520	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	34000	628	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
16520196	16520196	PRJNA797655_S_NODE_212913_length_173_cov_1.476923_g212308_i0	PRJNA797655	212913	173	1.476923	2.55507679	Fusobacterium	848	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g212308	i0	100	99.028901734104	173	0	100	0	1	173	906979	906807	Fusobacterium hwasookii ChDC F174, complete genome	blastn	17132	320	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
17363567	17363567	PRJNA797655_S_NODE_217054_length_171_cov_1.804688_g216449_i0	PRJNA797655	217054	171	1.804688	3.08601648	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	193	8.089999999999999e-45	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g216449	i0	96.581	11.9181286549708	117	3	68	1	55	171	2200379	2200264	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	2038	193	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
18633957	18633957	PRJNA797655_S_NODE_127515_length_222_cov_1.608939_g126910_i0	PRJNA797655	127515	222	1.608939	3.57184458	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	263	8.36e-66	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g126910	i0	88.053	1.01801801801802	226	22	99	4	1	221	153463	153238	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	226	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
18634112	18634112	PRJNA797655_S_NODE_132135_length_218_cov_2.925714_g131530_i0	PRJNA797655	132135	218	2.925714	6.37805652	Leptotrichia wadei	157687	Bacteria	Bacteria	377	2.799999999999999e-100	NTclustered	gi\|1791353085\|dbj\|AP019829.2\|	157687	g131530	i0	98.148	4.94036697247706	216	4	99	0	1	216	805223	805438	Leptotrichia wadei JCM16777 DNA, complete genome	blastn	1077	377	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
18636320	18636320	PRJNA797655_S_NODE_203195_length_177_cov_2.089552_g202590_i0	PRJNA797655	203195	177	2.089552	3.69850704	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g202590	i0	100	13.954802259887	177	0	100	0	1	177	179545	179721	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	2470	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
20343751	20343751	PRJNA797655_S_NODE_202556_length_177_cov_3.708955_g201951_i0	PRJNA797655	202556	177	3.708955	6.56485035	Fusobacterium	848	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g201951	i0	99.435	98.9830508474576	177	1	100	0	1	177	1154713	1154537	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	17520	322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
22460387	22460387	PRJNA797655_S_NODE_153218_length_204_cov_1.490683_g152613_i0	PRJNA797655	153218	204	1.490683	3.04099332	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	377	2.59e-100	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g152613	i0	100	18.8480392156863	204	0	100	0	1	204	243363	243160	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	3845	377	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
22462178	22462178	PRJNA797655_S_NODE_210278_length_174_cov_1.557252_g209673_i0	PRJNA797655	210278	174	1.557252	2.70961848	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g209673	i0	100	6.01724137931035	174	0	100	0	1	174	46109	45936	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1047	322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
22464765	22464765	PRJNA797655_S_NODE_40878_length_335_cov_2.465753_g40273_i0	PRJNA797655	40878	335	2.465753	8.26027255	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	272	2.2299999999999997e-68	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g40273	i0	89.189	0.662686567164179	222	19	65	4	1	219	1633192	1633411	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	222	272	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
25014064	25014064	PRJNA797655_S_NODE_41600_length_333_cov_3.034483_g40995_i0	PRJNA797655	41600	333	3.034483	10.10482839	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	553	7.06e-153	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g40995	i0	99.026	466.564564564565	308	3	92	0	1	308	198002	197695	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	155366	553	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225

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