metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA495391" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA495391" 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
477186	477186	PRJNA495391_S_NODE_66181_length_155_cov_0.991667_g65129_i0	PRJNA495391	66181	155	0.991667	1.53708385	Fusobacterium polymorphum	76857	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|2706071841\|gb\|CP077111.1\|	76857	g65129	i0	100	99.6516129032258	155	0	100	0	1	155	2249997	2249843	Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome	blastn	15446	287	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
3027947	3027947	PRJNA495391_S_NODE_60503_length_161_cov_0.936508_g59451_i0	PRJNA495391	60503	161	0.936508	1.50777788	Fusobacterium polymorphum	76857	Bacteria	Bacteria	281	1.57e-71	NTclustered	gi\|2078819084\|gb\|CP071096.1\|	76857	g59451	i0	98.137	13.5714285714286	161	3	100	0	1	161	654295	654135	Fusobacterium polymorphum strain THCT7E2 chromosome, complete genome	blastn	2185	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
4302748	4302748	PRJNA495391_S_NODE_17484_length_286_cov_7.792829_g16432_i0	PRJNA495391	17484	286	7.792829	22.28749094	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	507	4.69e-139	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g16432	i0	98.606	417.534965034965	287	3	100	1	1	286	1997055	1997341	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	119415	507	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
4303686	4303686	PRJNA495391_S_NODE_53024_length_170_cov_2.125926_g51972_i0	PRJNA495391	53024	170	2.125926	3.6140742	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g51972	i0	100	1	170	0	100	0	1	170	1129896	1130065	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	170	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
5579929	5579929	PRJNA495391_S_NODE_36445_length_202_cov_2.077844_g35393_i0	PRJNA495391	36445	202	2.077844	4.19724488	Fusobacterium polymorphum	76857	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g35393	i0	100	449.579207920792	202	0	100	0	1	202	2358728	2358527	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	90815	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
8130349	8130349	PRJNA495391_S_NODE_7827_length_434_cov_6.160401_g6776_i0	PRJNA495391	7827	434	6.160401	26.73614034	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	691	0	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g6776	i0	95.423	614.345622119816	437	15	100	5	1	434	2227565	2227999	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	266626	691	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
8760698	8760698	PRJNA495391_S_NODE_70067_length_151_cov_1.379310_g69015_i0	PRJNA495391	70067	151	1.37931	2.0827581	Fusobacterium	848	Bacteria	Bacteria	239	8.81e-59	NTclustered	gi\|2706504035\|gb\|CP084159.1\|	76857	g69015	i0	97.163	441.543046357616	141	4	95	0	11	151	285014	284874	Fusobacterium polymorphum strain KCOM1330 chromosome, complete genome	blastn	66673	241	0.991701244813278	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
10036068	10036068	PRJNA495391_S_NODE_54888_length_168_cov_0.977444_g53836_i0	PRJNA495391	54888	168	0.977444	1.64210592	Fusobacterium	848	Bacteria	Bacteria	281	1.65e-71	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g53836	i0	97.024	429.738095238095	168	4	100	1	1	168	332248	332414	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	72196	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
11955267	11955267	PRJNA495391_S_NODE_42330_length_189_cov_1.233766_g41278_i0	PRJNA495391	42330	189	1.233766	2.33181774	Fusobacterium polymorphum	76857	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g41278	i0	100	359.703703703704	189	0	100	0	1	189	2359001	2359189	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	67984	350	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
13229630	13229630	PRJNA495391_S_NODE_15331_length_305_cov_3.255556_g14279_i0	PRJNA495391	15331	305	3.255556	9.9294458	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	551	2.2999999999999993e-152	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g14279	i0	99.344	1	305	1	100	1	1	305	1129581	1129278	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	305	551	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
13230836	13230836	PRJNA495391_S_NODE_6011_length_502_cov_2.985011_g4975_i0	PRJNA495391	6011	502	2.985011	14.98475522	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	826	0	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g4975	i0	96.414	482.314741035857	502	16	100	2	1	502	1997673	1997174	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	242122	826	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
13230916	13230916	PRJNA495391_S_NODE_63271_length_158_cov_1.130081_g62219_i0	PRJNA495391	63271	158	1.130081	1.78552798	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g62219	i0	100	10.126582278481	158	0	100	0	1	158	2126235	2126078	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1600	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
13860630	13860630	PRJNA495391_S_NODE_13811_length_321_cov_4.583916_g12759_i0	PRJNA495391	13811	321	4.583916	14.71437036	Cetobacterium	180162	Bacteria	Bacteria	560	4.05e-155	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g12759	i0	98.131	458.713395638629	321	6	100	0	1	321	9311	8991	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	147247	560	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14505924	14505924	PRJNA495391_S_NODE_69032_length_152_cov_1.358974_g67980_i0	PRJNA495391	69032	152	1.358974	2.06564048	Fusobacterium polymorphum	76857	Bacteria	Bacteria	145	1.99e-30	NTclustered	gi\|2707716151\|gb\|CP077166.1\|	76857	g67980	i0	84	19.7236842105263	150	24	99	0	1	150	2518506	2518655	Fusobacterium polymorphum strain SB047 chromosome	blastn	2998	145	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
15778671	15778671	PRJNA495391_S_NODE_23973_length_246_cov_1.601896_g22921_i0	PRJNA495391	23973	246	1.601896	3.94066416	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g22921	i0	99.593	8.29674796747967	246	1	100	0	1	246	397578	397333	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	2041	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
17054428	17054428	PRJNA495391_S_NODE_64994_length_156_cov_1.314050_g63942_i0	PRJNA495391	64994	156	1.31405	2.049918	Fusobacterium polymorphum	76857	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g63942	i0	100	99.5384615384615	156	0	100	0	1	156	654523	654678	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	15528	289	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
19601633	19601633	PRJNA495391_S_NODE_12676_length_336_cov_2.986711_g11624_i0	PRJNA495391	12676	336	2.986711	10.03534896	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	617	2.49e-172	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g11624	i0	100	10.0297619047619	334	0	99	0	3	336	1129889	1129556	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	3370	617	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
19602622	19602622	PRJNA495391_S_NODE_48576_length_177_cov_1.823944_g47524_i0	PRJNA495391	48576	177	1.823944	3.22838088	Fusobacterium polymorphum	76857	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g47524	i0	100	303.480225988701	177	0	100	0	1	177	806002	806178	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	53716	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
19602639	19602639	PRJNA495391_S_NODE_49336_length_176_cov_1.425532_g48284_i0	PRJNA495391	49336	176	1.425532	2.50893632	Fusobacterium polymorphum	76857	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g48284	i0	100	372.772727272727	176	0	100	0	1	176	2358885	2358710	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	65608	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
20879041	20879041	PRJNA495391_S_NODE_68557_length_152_cov_2.188034_g67505_i0	PRJNA495391	68557	152	2.188034	3.32581168	Leptotrichia sp. oral taxon 218	712361	Bacteria	Bacteria	276	6.770000000000001e-70	NTclustered	gi\|2028887161\|gb\|CP072377.1\|	712361	g67505	i0	99.342	3	152	1	100	0	1	152	471254	471103	Leptotrichia sp. oral taxon 218 strain F0707 chromosome, complete genome	blastn	456	276	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 218
21509651	21509651	PRJNA495391_S_NODE_65197_length_156_cov_0.983471_g64145_i0	PRJNA495391	65197	156	0.983471	1.53421476	Fusobacterium	848	Bacteria	Bacteria	183	4.369999999999999e-42	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g64145	i0	87.821	99.8653846153846	156	19	100	0	1	156	843013	843168	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	15579	183	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
22152810	22152810	PRJNA495391_S_NODE_31198_length_217_cov_2.258242_g30146_i0	PRJNA495391	31198	217	2.258242	4.90038514	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	390	3.579999999999999e-104	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g30146	i0	99.078	4.00460829493088	217	2	100	0	1	217	974267	974051	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	869	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
25334053	25334053	PRJNA495391_S_NODE_6940_length_464_cov_4.519814_g5892_i0	PRJNA495391	6940	464	4.519814	20.97193696	Leptotrichia	32067	Bacteria	Bacteria	797	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g5892	i0	97.634	466.200431034483	465	10	100	1	1	464	1059	1523	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	216317	802	0.993765586034913	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
25334062	25334062	PRJNA495391_S_NODE_70460_length_151_cov_0.931034_g69408_i0	PRJNA495391	70460	151	0.931034	1.40586134	Fusobacterium	848	Bacteria	Bacteria	254	3.15e-63	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g69408	i0	96.732	40.5298013245033	153	3	100	1	1	151	65469	65621	Fusobacterium hwasookii ChDC F174, complete genome	blastn	6120	254	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii

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