metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA561212" 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
1130731	1130731	PRJNA561212_P_NODE_1081_length_1027_cov_1.342767_g931_i0	PRJNA561212	1081	1027	1.342767	13.79021709	Cetobacterium	180162	Bacteria	Bacteria	1753	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g931	i0	97.468	40.4089581304771	1027	26	100	0	1	1027	1903320	1902294	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	41500	1753	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1820932	1820932	PRJNA561212_P_NODE_13242_length_307_cov_0.965812_g13031_i0	PRJNA561212	13242	307	0.965812	2.96504284	Cetobacterium somerae	188913	Bacteria	Bacteria	230	1.2299999999999995e-55	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g13031	i0	81.25	4.70684039087948	288	50	93	4	10	295	1358504	1358219	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1445	230	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3096261	3096261	PRJNA561212_P_NODE_14923_length_291_cov_1.032110_g14712_i0	PRJNA561212	14923	291	1.03211	3.0034401	Fusobacterium hominis	2764326	Bacteria	Bacteria	156	1.9999999999999998e-33	NTclustered	gi\|1897733338\|gb\|CP060637.1\|	2764326	g14712	i0	84.146	0.563573883161512	164	22	56	4	10	171	2056364	2056525	Fusobacterium hominis strain NSJ-57 chromosome, complete genome	blastn	164	156	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hominis
3681993	3681993	PRJNA561212_P_NODE_11443_length_328_cov_0.909804_g11232_i0	PRJNA561212	11443	328	0.909804	2.98415712	Cetobacterium	180162	Bacteria	Bacteria	568	2.4799999999999995e-157	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g11232	i0	98.746	49.6280487804878	319	4	97	0	1	319	1900823	1901141	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	16278	568	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4958817	4958817	PRJNA561212_P_NODE_3584_length_584_cov_0.866928_g3377_i0	PRJNA561212	3584	584	0.866928	5.06285952	Cetobacterium	180162	Bacteria	Bacteria	468	4.83e-127	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g3377	i0	81.786	4.86986301369863	571	92	97	10	12	576	1996675	1997239	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2844	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
5649353	5649353	PRJNA561212_P_NODE_6445_length_434_cov_1.199446_g6234_i0	PRJNA561212	6445	434	1.199446	5.20559564	Cetobacterium somerae	188913	Bacteria	Bacteria	612	1.53e-170	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g6234	i0	93.062	23.8986175115207	418	29	96	0	9	426	1679293	1679710	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	10372	612	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6234267	6234267	PRJNA561212_P_NODE_21085_length_251_cov_1.382022_g20874_i0	PRJNA561212	21085	251	1.382022	3.46887522	Cetobacterium	180162	Bacteria	Bacteria	363	9.249999999999997e-96	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g20874	i0	94.468	4.68127490039841	235	13	94	0	9	243	1776415	1776649	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1175	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8198266	8198266	PRJNA561212_P_NODE_18987_length_261_cov_1.297872_g18776_i0	PRJNA561212	18987	261	1.297872	3.3874459200000002	Cetobacterium somerae	188913	Bacteria	Bacteria	444	3.36e-120	NTclustered	gi\|2666491349\|gb\|CP143325.1\|	188913	g18776	i0	99.588	1.04980842911877	243	1	93	0	10	252	19971	19729	Cetobacterium somerae strain ceto plasmid p6, complete sequence	blastn	274	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8783623	8783623	PRJNA561212_P_NODE_3327_length_606_cov_1.272045_g3121_i0	PRJNA561212	3327	606	1.272045	7.7085927	Cetobacterium	180162	Bacteria	Bacteria	1011	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g3121	i0	97.623	96.7029702970297	589	14	97	0	9	597	1740829	1741417	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	58602	1011	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10059270	10059270	PRJNA561212_P_NODE_9648_length_355_cov_0.773050_g9437_i0	PRJNA561212	9648	355	0.77305	2.7443275	Cetobacterium	180162	Bacteria	Bacteria	422	2.22e-113	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g9437	i0	95.785	15.9746478873239	261	11	74	0	1	261	1905567	1905827	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5671	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11333837	11333837	PRJNA561212_P_NODE_25429_length_243_cov_0.917647_g25218_i0	PRJNA561212	25429	243	0.917647	2.22988221	Cetobacterium	180162	Bacteria	Bacteria	292	1.19e-74	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g25218	i0	90.708	42.9753086419753	226	12	90	7	10	228	476626	476849	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	10443	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11333839	11333839	PRJNA561212_P_NODE_26209_length_237_cov_2.121951_g25998_i0	PRJNA561212	26209	237	2.121951	5.02902387	Cetobacterium	180162	Bacteria	Bacteria	401	1.8299999999999998e-107	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g25998	i0	99.545	89.6751054852321	220	1	93	0	9	228	3721	3502	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	21253	401	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12024542	12024542	PRJNA561212_P_NODE_25550_length_243_cov_0.917647_g25339_i0	PRJNA561212	25550	243	0.917647	2.22988221	Cetobacterium somerae	188913	Bacteria	Bacteria	287	5.52e-73	NTclustered	gi\|2865362888\|gb\|CP122284.1\|	188913	g25339	i0	89.732	4.60905349794239	224	23	92	0	11	234	1437286	1437509	Cetobacterium somerae strain MSU49 chromosome, complete genome	blastn	1120	287	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12609692	12609692	PRJNA561212_P_NODE_8950_length_367_cov_1.704082_g8739_i0	PRJNA561212	8950	367	1.704082	6.25398094	Cetobacterium	180162	Bacteria	Bacteria	599	9.929999999999998e-167	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g8739	i0	97.436	10.8147138964578	351	9	96	0	9	359	1906871	1907221	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3969	599	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13299368	13299368	PRJNA561212_P_NODE_14871_length_291_cov_1.348624_g14660_i0	PRJNA561212	14871	291	1.348624	3.92449584	Cetobacterium somerae	188913	Bacteria	Bacteria	250	8.909999999999999e-62	NTclustered	gi\|2201062198\|gb\|CP092520.1\|	188913	g14660	i0	86.017	1.60824742268041	236	30	81	2	3	237	613267	613034	Cetobacterium somerae strain CS2105-BJ plasmid unnamed1, complete sequence	blastn	468	250	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13299389	13299389	PRJNA561212_P_NODE_15951_length_283_cov_1.071429_g15740_i0	PRJNA561212	15951	283	1.071429	3.03214407	Cetobacterium somerae	188913	Bacteria	Bacteria	435	2.22e-117	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g15740	i0	95.896	6.57243816254417	268	11	95	0	10	277	1913948	1914215	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1860	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13884540	13884540	PRJNA561212_P_NODE_11011_length_334_cov_0.827586_g10800_i0	PRJNA561212	11011	334	0.827586	2.76413724	Cetobacterium	180162	Bacteria	Bacteria	427	4.48e-115	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10800	i0	90.214	14.0688622754491	327	32	98	0	1	327	1896987	1897313	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4699	427	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14574396	14574396	PRJNA561212_P_NODE_21312_length_251_cov_0.876404_g21101_i0	PRJNA561212	21312	251	0.876404	2.19977404	Cetobacterium somerae	188913	Bacteria	Bacteria	257	4.49e-64	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g21101	i0	87.168	4.66135458167331	226	29	90	0	13	238	269865	270090	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1170	257	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15158737	15158737	PRJNA561212_P_NODE_17332_length_273_cov_1.085000_g17121_i0	PRJNA561212	17332	273	1.085	2.96205	Cetobacterium	180162	Bacteria	Bacteria	433	7.66e-117	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g17121	i0	96.212	4.79120879120879	264	10	97	0	1	264	1858568	1858305	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1308	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15848152	15848152	PRJNA561212_P_NODE_14173_length_297_cov_1.540179_g13962_i0	PRJNA561212	14173	297	1.540179	4.57433163	Cetobacterium somerae	188913	Bacteria	Bacteria	361	4.04e-95	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g13962	i0	89.236	6.52861952861953	288	31	97	0	1	288	1915030	1914743	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1939	361	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15848327	15848327	PRJNA561212_P_NODE_25293_length_243_cov_0.917647_g25082_i0	PRJNA561212	25293	243	0.917647	2.22988221	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	217	7.34e-52	NTclustered	gi\|2892346784\|dbj\|AP035781.1\|	2053555	g25082	i0	88.701	0.728395061728395	177	20	73	0	48	224	608809	608633	Fusobacteriaceae bacterium 9N8 DNA, complete genome	blastn	177	217	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
16433383	16433383	PRJNA561212_P_NODE_14333_length_296_cov_0.941704_g14122_i0	PRJNA561212	14333	296	0.941704	2.78744384	Cetobacterium	180162	Bacteria	Bacteria	398	3.059999999999999e-106	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g14122	i0	91.638	5.625	287	24	97	0	10	296	1869078	1868792	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1665	398	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17708640	17708640	PRJNA561212_P_NODE_10694_length_338_cov_1.588679_g10483_i0	PRJNA561212	10694	338	1.588679	5.36973502	Cetobacterium	180162	Bacteria	Bacteria	521	2.0199999999999993e-143	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g10483	i0	95.95	55.5236686390533	321	13	95	0	9	329	1582837	1583157	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	18767	521	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18397175	18397175	PRJNA561212_P_NODE_13335_length_306_cov_1.137339_g13124_i0	PRJNA561212	13335	306	1.137339	3.48025734	Cetobacterium somerae	188913	Bacteria	Bacteria	292	1.54e-74	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g13124	i0	85.612	4.34640522875817	278	40	91	0	19	296	1241902	1241625	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1330	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18982083	18982083	PRJNA561212_P_NODE_20575_length_252_cov_1.569832_g20364_i0	PRJNA561212	20575	252	1.569832	3.95597664	Cetobacterium	180162	Bacteria	Bacteria	353	5.59e-93	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g20364	i0	94.043	8.03174603174603	235	10	93	3	10	244	962502	962732	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2024	353	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18982097	18982097	PRJNA561212_P_NODE_9735_length_353_cov_2.046429_g9524_i0	PRJNA561212	9735	353	2.046429	7.22389437	Cetobacterium	180162	Bacteria	Bacteria	564	3.47e-156	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g9524	i0	97.015	7.12747875354108	335	10	95	0	9	343	899217	898883	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2516	564	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20257223	20257223	PRJNA561212_P_NODE_5096_length_490_cov_1.338129_g4885_i0	PRJNA561212	5096	490	1.338129	6.5568321	Cetobacterium	180162	Bacteria	Bacteria	795	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g4885	i0	96.842	21.8244897959184	475	15	97	0	9	483	1904925	1904451	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	10694	795	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22222362	22222362	PRJNA561212_P_NODE_14438_length_295_cov_0.986486_g14227_i0	PRJNA561212	14438	295	0.986486	2.9101337	Fusobacterium animalis	76859	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2706471657\|gb\|CP084079.1\|	76859	g14227	i0	100	0.284745762711864	28	0	9	0	70	97	1608461	1608434	Fusobacterium animalis strain SB052 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
22222509	22222509	PRJNA561212_P_NODE_25518_length_243_cov_0.917647_g25307_i0	PRJNA561212	25518	243	0.917647	2.22988221	Cetobacterium somerae	188913	Bacteria	Bacteria	285	1.98e-72	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g25307	i0	89.381	4.65020576131687	226	24	93	0	8	233	829282	829057	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	1130	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
23497814	23497814	PRJNA561212_P_NODE_25139_length_243_cov_1.470588_g24928_i0	PRJNA561212	25139	243	1.470588	3.57352884	Cetobacterium somerae	188913	Bacteria	Bacteria	239	1.57e-58	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g24928	i0	86.574	15.8271604938272	216	29	89	0	14	229	1804028	1803813	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	3846	239	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24082625	24082625	PRJNA561212_P_NODE_12499_length_315_cov_0.942149_g12288_i0	PRJNA561212	12499	315	0.942149	2.96776935	Fusobacterium	848	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g12288	i0	96.875	0.203174603174603	32	0	10	1	62	92	1274774	1274805	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	64	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);;