metadata: contig_metadata: 22 rows where bioproject = "PRJNA849646", tax_kingdom = "Fusobacteriati" and tax

22 rows where bioproject = "PRJNA849646", tax_kingdom = "Fusobacteriati" 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
2113789	2113789	PRJNA849646_P_NODE_40022_length_235_cov_2.759259_g39904_i0	PRJNA849646	40022	235	2.759259	6.48425865	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	424	3.87e-114	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g39904	i0	99.149	392.195744680851	235	2	100	0	1	235	70599	70833	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	92166	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
3388875	3388875	PRJNA849646_P_NODE_21823_length_265_cov_1.427083_g21705_i0	PRJNA849646	21823	265	1.427083	3.78176995	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g21705	i0	100	10.7018867924528	265	0	100	0	1	265	2358822	2358558	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2836	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4666740	4666740	PRJNA849646_P_NODE_32144_length_248_cov_0.880000_g32026_i0	PRJNA849646	32144	248	0.88	2.1824	Fusobacterium polymorphum	76857	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2706056059\|gb\|CP077188.1\|	76857	g32026	i0	100	99.2983870967742	248	0	100	0	1	248	1452613	1452860	Fusobacterium polymorphum strain SB028 chromosome, complete genome	blastn	24626	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
8491252	8491252	PRJNA849646_P_NODE_5167_length_310_cov_3.113924_g5049_i0	PRJNA849646	5167	310	3.113924	9.6531644	Fusobacterium polymorphum	76857	Bacteria	Bacteria	527	3.9499999999999986e-145	NTclustered	gi\|2704950824\|gb\|CP056007.1\|	76857	g5049	i0	96.774	100.103225806452	310	7	100	1	1	310	2090308	2090614	Fusobacterium polymorphum strain SB013 chromosome, complete genome	blastn	31032	527	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9766251	9766251	PRJNA849646_P_NODE_26468_length_256_cov_1.683060_g26350_i0	PRJNA849646	26468	256	1.68306	4.3086336	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	446	9.139999999999999e-121	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g26350	i0	98.047	193.65234375	256	5	100	0	1	256	52893	53148	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	49575	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
10161848	10161848	PRJNA849646_P_NODE_31588_length_248_cov_3.177143_g31470_i0	PRJNA849646	31588	248	3.177143	7.87931464	Cetobacterium	180162	Bacteria	Bacteria	375	1.1699999999999999e-99	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g31470	i0	93.952	5	248	15	100	0	1	248	1931663	1931910	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1240	375	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11437063	11437063	PRJNA849646_P_NODE_29929_length_250_cov_2.180791_g29811_i0	PRJNA849646	29929	250	2.180791	5.4519775	Leptotrichia	32067	Bacteria	Bacteria	444	3.1999999999999986e-120	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g29811	i0	98.795	150.808	249	3	99	0	2	250	452	204	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	37702	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
12712832	12712832	PRJNA849646_P_NODE_2070_length_378_cov_4.298361_g1952_i0	PRJNA849646	2070	378	4.298361	16.24780458	Cetobacterium	180162	Bacteria	Bacteria	665	0	NTclustered	gi\|2666490175\|gb\|CP143320.1\|	188913	g1952	i0	98.417	5.01058201058201	379	5	100	1	1	378	71312	71690	Cetobacterium somerae strain ceto plasmid p1, complete sequence	blastn	1894	665	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12712991	12712991	PRJNA849646_P_NODE_42530_length_220_cov_4.632653_g42412_i0	PRJNA849646	42530	220	4.632653	10.1918366	Fusobacterium	848	Bacteria	Bacteria	405	1.2999999999999997e-108	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g42412	i0	100	99.4318181818182	219	0	99	0	2	220	1504500	1504282	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	21875	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13986964	13986964	PRJNA849646_P_NODE_10591_length_286_cov_3.807512_g10473_i0	PRJNA849646	10591	286	3.807512	10.88948432	Fusobacterium	848	Bacteria	Bacteria	512	1.01e-140	NTclustered	gi\|586941090\|dbj\|AB910749.1\|	860	g10473	i0	98.951	292.300699300699	286	3	100	0	1	286	289	4	Fusobacterium periodonticum gene for 16S ribosomal RNA, partial sequence	blastn	83598	512	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
14866345	14866345	PRJNA849646_P_NODE_37872_length_241_cov_3.857143_g37754_i0	PRJNA849646	37872	241	3.857143	9.29571463	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|958159838\|gb\|CP013334.1\|	1307444	g37754	i0	99.585	65.2863070539419	241	1	100	0	1	241	1524609	1524849	Fusobacterium hwasookii ChDC F300, complete genome	blastn	15734	440	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
15261288	15261288	PRJNA849646_P_NODE_27912_length_253_cov_2.133333_g27794_i0	PRJNA849646	27912	253	2.133333	5.39733249	Fusobacterium	848	Bacteria	Bacteria	466	6.9199999999999996e-127	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g27794	i0	100	99.604743083004	252	0	99	0	1	252	1849457	1849206	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	25200	466	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
15261383	15261383	PRJNA849646_P_NODE_41032_length_231_cov_2.455696_g40914_i0	PRJNA849646	41032	231	2.455696	5.67265776	Leptotrichia	32067	Bacteria	Bacteria	394	2.98e-105	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g40914	i0	97.403	492.450216450216	231	6	100	0	1	231	2370	2140	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	113756	394	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
16141131	16141131	PRJNA849646_P_NODE_42413_length_223_cov_4.426667_g42295_i0	PRJNA849646	42413	223	4.426667	9.87146741	Fusobacterium polymorphum	76857	Bacteria	Bacteria	401	1.7099999999999992e-107	NTclustered	gi\|2673502234\|gb\|CP144257.1\|	76857	g42295	i0	99.103	43.0044843049327	223	2	100	0	1	223	357955	358177	Fusobacterium polymorphum strain IOOS_98 chromosome	blastn	9590	401	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
16535998	16535998	PRJNA849646_P_NODE_37793_length_242_cov_0.911243_g37675_i0	PRJNA849646	37793	242	0.911243	2.20520806	Fusobacterium	848	Bacteria	Bacteria	387	5.26e-103	NTclustered	gi\|2705003210\|gb\|CP084117.1\|	851	g37675	i0	95.473	100.061983471074	243	10	100	1	1	242	1030863	1031105	Fusobacterium nucleatum strain KCOM3486 chromosome, complete genome	blastn	24215	387	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
16536049	16536049	PRJNA849646_P_NODE_6673_length_307_cov_3.649573_g6555_i0	PRJNA849646	6673	307	3.649573	11.20418911	Fusobacterium	848	Bacteria	Bacteria	226	1.59e-54	NTclustered	gi\|2704998788\|gb\|CP077147.1\|	851	g6555	i0	93.96	8.55374592833876	149	9	95	0	159	307	1463253	1463105	Fusobacterium nucleatum strain KCOM2373 chromosome, complete genome	blastn	2626	226	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
18689549	18689549	PRJNA849646_P_NODE_28055_length_253_cov_1.711111_g27937_i0	PRJNA849646	28055	253	1.711111	4.32911083	Leptotrichia wadei	157687	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g27937	i0	100	379.466403162055	253	0	100	0	1	253	2288638	2288386	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	96005	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19084875	19084875	PRJNA849646_P_NODE_34235_length_246_cov_0.890173_g34117_i0	PRJNA849646	34235	246	0.890173	2.18982558	Cetobacterium	180162	Bacteria	Bacteria	350	7.04e-92	NTclustered	gi\|2666491163\|gb\|CP143323.1\|	188913	g34117	i0	92.276	5	246	19	100	0	1	246	11349	11594	Cetobacterium somerae strain ceto plasmid p4, complete sequence	blastn	1230	350	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21635500	21635500	PRJNA849646_P_NODE_717_length_580_cov_4.069034_g602_i0	PRJNA849646	717	580	4.069034	23.6003972	Fusobacterium	848	Bacteria	Bacteria	1020	0	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g602	i0	98.448	480.012068965517	580	8	100	1	1	580	1602875	1603453	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	278407	1020	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
25064294	25064294	PRJNA849646_P_NODE_21120_length_266_cov_2.051813_g21002_i0	PRJNA849646	21120	266	2.051813	5.45782258	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	481	2.62e-131	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g21002	i0	99.248	12	266	2	100	0	1	266	299409	299674	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	3192	481	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
30623436	30623436	PRJNA849646_P_NODE_33413_length_246_cov_3.670520_g33295_i0	PRJNA849646	33413	246	3.67052	9.0294792	Fusobacterium sp.	68766	Bacteria	Bacteria	43.5	0.0204	NR	WP_320949167.1	68766	g33295	i0	47.8	1.1219512195122	46	24	56.1	0	4	141	343	388	WP_320949167.1 site-specific DNA-methyltransferase [Fusobacterium sp.]	diamond	276	43.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
30655089	30655089	PRJNA849646_P_NODE_26593_length_256_cov_1.404372_g26475_i0	PRJNA849646	26593	256	1.404372	3.59519232	Cetobacterium sp. 2G large	2759680	Bacteria	Bacteria	176	2.6799999999999996e-54	NR	WP_185891584.1	2759680	g26475	i0	98.8	0.9609375	82	1	96.1	0	247	2	2	83	WP_185891584.1 YbhB/YbcL family Raf kinase inhibitor-like protein [Cetobacterium sp. 2G large]	diamond	246	176	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. 2G large

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