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

22 rows where bioproject = "PRJNA385064" and tax_phylum = "Fusobacteriota"

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
3626610	3626610	PRJNA385064_P_NODE_1523_length_382_cov_5.009009_g1398_i0	PRJNA385064	1523	382	5.009009	19.13441438	Leptotrichia	32067	Bacteria	Bacteria	656	0	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g1398	i0	99.721	188.510471204188	358	1	95	0	25	382	593021	592664	Leptotrichia sp. oral taxon 498, complete genome	blastn	72011	662	0.990936555891239	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
4232493	4232493	PRJNA385064_P_NODE_3324_length_240_cov_2.287958_g3199_i0	PRJNA385064	3324	240	2.287958	5.4910992	Leptotrichia wadei	157687	Bacteria	Bacteria	372	1.4599999999999997e-98	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g3199	i0	94.583	286.745833333333	240	13	100	0	1	240	2248840	2249079	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	68819	372	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4232514	4232514	PRJNA385064_P_NODE_8244_length_159_cov_2.318182_g8119_i0	PRJNA385064	8244	159	2.318182	3.68590938	Leptotrichia buccalis	40542	Bacteria	Bacteria	283	4.29e-72	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g8119	i0	98.742	72.0880503144654	159	2	100	0	1	159	119077	119235	Leptotrichia buccalis DSM 1135, complete genome	blastn	11462	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
8058662	8058662	PRJNA385064_P_NODE_5847_length_176_cov_1.188976_g5722_i0	PRJNA385064	5847	176	1.188976	2.09259776	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	58.4	3.19e-4	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g5722	i0	100	0.176136363636364	31	0	18	0	120	150	88098	88068	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
10609168	10609168	PRJNA385064_P_NODE_5109_length_189_cov_2.385714_g4984_i0	PRJNA385064	5109	189	2.385714	4.50899946	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	316	5.21e-82	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g4984	i0	96.825	14.4814814814815	189	6	100	0	1	189	51802	51990	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2737	316	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
10609178	10609178	PRJNA385064_P_NODE_669_length_621_cov_21.554196_g557_i0	PRJNA385064	669	621	21.554196	133.85155716	Leptotrichia wadei	157687	Bacteria	Bacteria	1136	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g557	i0	99.678	467.375201288245	621	2	100	0	1	621	1756023	1755403	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	290240	1136	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
11279085	11279085	PRJNA385064_P_NODE_4909_length_193_cov_2.104167_g4784_i0	PRJNA385064	4909	193	2.104167	4.06104231	Cetobacterium	180162	Bacteria	Bacteria	351	1.46e-92	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g4784	i0	99.485	523.476683937824	194	0	100	1	1	193	278496	278689	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	101031	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12554542	12554542	PRJNA385064_P_NODE_670_length_621_cov_14.954545_g558_i0	PRJNA385064	670	621	14.954545	92.86772445	Leptotrichia	32067	Bacteria	Bacteria	1142	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g558	i0	99.839	487.792270531401	621	1	100	0	1	621	2583	1963	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	302919	1142	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
13159103	13159103	PRJNA385064_P_NODE_6851_length_166_cov_0.871795_g6726_i0	PRJNA385064	6851	166	0.871795	1.4471797	Leptotrichia buccalis	40542	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g6726	i0	100	1	166	0	100	0	1	166	656351	656186	Leptotrichia buccalis DSM 1135, complete genome	blastn	166	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
15708113	15708113	PRJNA385064_P_NODE_53_length_1928_cov_29.687600_g35_i0	PRJNA385064	53	1928	29.6876	572.376928	Leptotrichia wadei	157687	Bacteria	Bacteria	3424	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g35	i0	98.855	469.69346473029	1922	19	99	3	2	1922	2288269	2290188	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	905569	3424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
16378378	16378378	PRJNA385064_P_NODE_3853_length_221_cov_5.034884_g3728_i0	PRJNA385064	3853	221	5.034884	11.12709364	Fusobacterium	848	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g3728	i0	100	470.085972850679	221	0	100	0	1	221	1932731	1932951	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	103889	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
16982748	16982748	PRJNA385064_P_NODE_54_length_1926_cov_23.867342_g35_i1	PRJNA385064	54	1926	23.867342	459.68500692	Leptotrichia wadei	157687	Bacteria	Bacteria	3013	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g35	i1	95.018	484.38785046729	1927	81	99	13	7	1925	2299309	2297390	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	932931	3013	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
17653476	17653476	PRJNA385064_P_NODE_2554_length_281_cov_2.310345_g2429_i0	PRJNA385064	2554	281	2.310345	6.49206945	Fusobacterium	848	Bacteria	Bacteria	514	2.75e-141	NTclustered	gi\|2706074160\|gb\|CP077112.1\|	76857	g2429	i0	99.644	471.092526690391	281	1	100	0	1	281	1884064	1884344	Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome	blastn	132377	514	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18927402	18927402	PRJNA385064_P_NODE_1695_length_357_cov_12.074675_g1570_i0	PRJNA385064	1695	357	12.074675	43.10658975	Leptotrichia	32067	Bacteria	Bacteria	654	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g1570	i0	99.72	201.59943977591	357	1	100	0	1	357	18	374	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	71971	654	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
18927404	18927404	PRJNA385064_P_NODE_2635_length_275_cov_5.115044_g2510_i0	PRJNA385064	2635	275	5.115044	14.066371	Fusobacterium	848	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g2510	i0	100	470.992727272727	275	0	100	0	1	275	106871	106597	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	129523	508	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19531235	19531235	PRJNA385064_P_NODE_8076_length_161_cov_0.910714_g7951_i0	PRJNA385064	8076	161	0.910714	1.46624954	Leptotrichia wadei	157687	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g7951	i0	100	10.9565217391304	161	0	100	0	1	161	1389108	1389268	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1764	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21477565	21477565	PRJNA385064_P_NODE_2537_length_282_cov_3.733906_g2412_i0	PRJNA385064	2537	282	3.733906	10.52961492	Fusobacterium	848	Bacteria	Bacteria	442	1.3199999999999993e-119	NTclustered	gi\|2704957570\|gb\|CP077164.1\|	851	g2412	i0	96.283	455.315602836879	269	10	95	0	14	282	127623	127355	Fusobacterium nucleatum strain SB049 chromosome, complete genome	blastn	128399	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
22081806	22081806	PRJNA385064_P_NODE_3938_length_218_cov_2.680473_g3813_i0	PRJNA385064	3938	218	2.680473	5.84343114	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	398	2.1499999999999996e-106	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g3813	i0	99.541	351.04128440367	218	1	100	0	1	218	53587	53804	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	76527	398	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24027632	24027632	PRJNA385064_P_NODE_2159_length_310_cov_3.145594_g2034_i0	PRJNA385064	2159	310	3.145594	9.7513414	Fusobacterium	848	Bacteria	Bacteria	568	2.3299999999999995e-157	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g2034	i0	99.677	490.538709677419	310	1	100	0	1	310	2087700	2087391	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	152067	568	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
24027638	24027638	PRJNA385064_P_NODE_3419_length_236_cov_5.834225_g3294_i0	PRJNA385064	3419	236	5.834225	13.768771	Fusobacterium	848	Bacteria	Bacteria	435	1.8e-117	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g3294	i0	100	480.03813559322	235	0	99	0	2	236	107854	107620	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	113289	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
24631748	24631748	PRJNA385064_P_NODE_1020_length_486_cov_18.432494_g896_i0	PRJNA385064	1020	486	18.432494	89.58192084	Leptotrichia wadei	157687	Bacteria	Bacteria	765	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g896	i0	95.062	378.051440329218	486	24	100	0	1	486	222083	222568	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	183733	765	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
27833204	27833204	PRJNA385064_P_NODE_5884_length_175_cov_1.619048_g5759_i0	PRJNA385064	5884	175	1.619048	2.833334	Leptotrichia sp. oral taxon 417	712365	Bacteria	Bacteria	110	1.5500000000000002e-26	NR	WP_178938102.1	712365	g5759	i0	96.6	0.994285714285714	58	2	99.4	0	174	1	735	792	WP_178938102.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia sp. oral taxon 417]	diamond	174	110	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 417

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