metadata: contig_metadata: 18 rows where bioproject = "PRJNA1123309" and tax

18 rows where bioproject = "PRJNA1123309" 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
278200	278200	PRJNA1123309_P_NODE_2201_length_912_cov_4.170441_g1897_i1	PRJNA1123309	2201	912	4.170441	38.03442192	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1458	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g1897	i1	95.509	505.077850877193	913	40	100	1	1	912	52485	51573	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	460631	1458	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
278705	278705	PRJNA1123309_P_NODE_67821_length_231_cov_2.683544_g67441_i0	PRJNA1123309	67821	231	2.683544	6.19898664	Sneathia vaginalis	187101	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g67441	i0	100	391.220779220779	231	0	100	0	1	231	161131	161361	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	90372	427	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
1553022	1553022	PRJNA1123309_P_NODE_4922_length_654_cov_4.020654_g4583_i0	PRJNA1123309	4922	654	4.020654	26.29507716	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1018	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g4583	i0	95.327	441.487767584098	642	29	98	1	14	654	52514	53155	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	288733	1018	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
2304228	2304228	PRJNA1123309_P_NODE_20702_length_348_cov_2.989091_g20323_i0	PRJNA1123309	20702	348	2.989091	10.40203668	Fusobacterium	848	Bacteria	Bacteria	627	4.3099999999999996e-175	NTclustered	gi\|2704995109\|gb\|CP077144.1\|	851	g20323	i0	99.42	440.333333333333	345	2	99	0	2	346	130664	131008	Fusobacterium nucleatum strain KCOM2847 chromosome, complete genome	blastn	153236	627	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
5381418	5381418	PRJNA1123309_P_NODE_31505_length_291_cov_2.651376_g31125_i0	PRJNA1123309	31505	291	2.651376	7.71550416	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	359	1.42e-94	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g31125	i0	88.852	18.5463917525773	305	17	99	1	1	288	89863	89559	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	5397	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
5381707	5381707	PRJNA1123309_P_NODE_59165_length_246_cov_0.901734_g58785_i0	PRJNA1123309	59165	246	0.901734	2.21826564	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	132	8.37e-34	NR	WP_147005590.1	554406	g58785	i0	81	0.963414634146341	79	13	96.3	1	239	3	573	649	WP_147005590.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia hongkongensis]	diamond	237	132	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
6131823	6131823	PRJNA1123309_P_NODE_2145_length_920_cov_2.827627_g1897_i0	PRJNA1123309	2145	920	2.827627	26.0141684	Leptotrichia	32067	Bacteria	Bacteria	1434	0	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g1897	i0	95.364	464.14347826087	906	35	98	7	19	920	196665	197567	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	427012	1434	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
8682253	8682253	PRJNA1123309_P_NODE_56007_length_248_cov_0.891429_g55627_i0	PRJNA1123309	56007	248	0.891429	2.21074392	Fusobacterium	848	Bacteria	Bacteria	449	6.81e-122	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g55627	i0	100	62.8548387096774	243	0	98	0	3	245	271987	272229	Fusobacterium hwasookii ChDC F174, complete genome	blastn	15588	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
11232284	11232284	PRJNA1123309_P_NODE_269_length_1973_cov_7.807895_g190_i0	PRJNA1123309	269	1973	7.807895	154.04976835	Fusobacterium	848	Bacteria	Bacteria	3554	0	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g190	i0	99.338	477.410542321338	1965	9	99	3	11	1973	1604268	1602306	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	941931	3554	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
13032190	13032190	PRJNA1123309_P_NODE_56771_length_247_cov_1.637931_g56391_i0	PRJNA1123309	56771	247	1.637931	4.04568957	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	379	9.02e-101	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g56391	i0	95.378	27.0404858299595	238	11	96	0	10	247	448397	448634	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	6679	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14307479	14307479	PRJNA1123309_P_NODE_61272_length_245_cov_0.906977_g60892_i0	PRJNA1123309	61272	245	0.906977	2.22209365	Fusobacterium polymorphum	76857	Bacteria	Bacteria	446	8.68e-121	NTclustered	gi\|2704963975\|gb\|CP056021.1\|	76857	g60892	i0	100	98.0081632653061	241	0	98	0	4	244	1023550	1023310	Fusobacterium polymorphum strain SB005 chromosome, complete genome	blastn	24012	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
15581210	15581210	PRJNA1123309_P_NODE_41833_length_266_cov_1.321244_g41453_i0	PRJNA1123309	41833	266	1.321244	3.51450904	Leptotrichia wadei	157687	Bacteria	Bacteria	449	7.38e-122	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g41453	i0	97.701	41.6127819548872	261	6	98	0	5	265	696272	696532	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	11069	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
17606766	17606766	PRJNA1123309_P_NODE_66314_length_242_cov_0.923077_g65934_i0	PRJNA1123309	66314	242	0.923077	2.23384634	Fusobacterium	848	Bacteria	Bacteria	433	6.66e-117	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g65934	i0	100	7.71487603305785	234	0	97	0	4	237	2281322	2281089	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	1867	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
18130392	18130392	PRJNA1123309_P_NODE_67375_length_237_cov_2.420732_g66995_i0	PRJNA1123309	67375	237	2.420732	5.73713484	Sneathia vaginalis	187101	Bacteria	Bacteria	438	1.4e-118	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g66995	i0	100	474.936708860759	237	0	100	0	1	237	161068	160832	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	112560	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
21955355	21955355	PRJNA1123309_P_NODE_59498_length_246_cov_0.901734_g59118_i0	PRJNA1123309	59498	246	0.901734	2.21826564	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	399	6.889999999999999e-107	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g59118	i0	97.046	82.9186991869919	237	7	96	0	10	246	572144	571908	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	20398	399	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
23230341	23230341	PRJNA1123309_P_NODE_13859_length_412_cov_1.477876_g13482_i0	PRJNA1123309	13859	412	1.477876	6.08884912	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	555	2.48e-153	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g13482	i0	91.791	115.368932038835	402	28	97	5	1	400	51924	51526	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	47532	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24504466	24504466	PRJNA1123309_P_NODE_54400_length_249_cov_0.886364_g54020_i0	PRJNA1123309	54400	249	0.886364	2.20704636	Leptotrichia shahii	157691	Bacteria	Bacteria	448	2.46e-121	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g54020	i0	99.194	70.4497991967872	248	2	99	0	1	248	488347	488594	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	17542	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
25255274	25255274	PRJNA1123309_P_NODE_26160_length_315_cov_1.834711_g25780_i0	PRJNA1123309	26160	315	1.834711	5.77933965	Fusobacterium	848	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2704996929\|gb\|CP077149.1\|	851	g25780	i0	100	0.355555555555556	28	0	9	0	278	305	581516	581543	Fusobacterium nucleatum strain KCOM2013 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum

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