metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA485080" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA485080" 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
449194	449194	PRJNA485080_P_NODE_27681_length_248_cov_1.320000_g27587_i0	PRJNA485080	27681	248	1.32	3.2736	Cetobacterium somerae	188913	Bacteria	Bacteria	440	4.0999999999999997e-119	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g27587	i0	98.79	5	248	2	100	1	1	248	1893105	1892859	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	1240	440	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2372890	2372890	PRJNA485080_P_NODE_15962_length_286_cov_1.403756_g15868_i0	PRJNA485080	15962	286	1.403756	4.01474216	Cetobacterium	180162	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g15868	i0	100	97.4405594405594	286	0	100	0	1	286	1878543	1878258	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	27868	529	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3648514	3648514	PRJNA485080_P_NODE_12783_length_310_cov_1.291139_g12689_i0	PRJNA485080	12783	310	1.291139	4.0025309	Cetobacterium	180162	Bacteria	Bacteria	569	6.469999999999998e-158	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g12689	i0	100	5.19354838709677	308	0	99	0	1	308	1384474	1384781	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1610	569	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3648540	3648540	PRJNA485080_P_NODE_3343_length_507_cov_1.419355_g3249_i0	PRJNA485080	3343	507	1.419355	7.19612985	Cetobacterium	180162	Bacteria	Bacteria	933	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g3249	i0	100	26.0532544378698	505	0	99	0	3	507	1877633	1878137	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	13209	933	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6200562	6200562	PRJNA485080_P_NODE_5085_length_424_cov_1.316239_g4991_i0	PRJNA485080	5085	424	1.316239	5.58085336	Cetobacterium	180162	Bacteria	Bacteria	784	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g4991	i0	100	12.2830188679245	424	0	100	0	1	424	1902079	1901656	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5208	784	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7475377	7475377	PRJNA485080_P_NODE_12686_length_311_cov_1.142857_g12592_i0	PRJNA485080	12686	311	1.142857	3.55428527	Cetobacterium	180162	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g12592	i0	100	5.93569131832797	311	0	100	0	1	311	1912513	1912823	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1846	575	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8750354	8750354	PRJNA485080_P_NODE_26387_length_249_cov_0.875000_g26293_i0	PRJNA485080	26387	249	0.875	2.17875	Cetobacterium	180162	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g26293	i0	100	5	249	0	100	0	1	249	401884	401636	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1245	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9376844	9376844	PRJNA485080_P_NODE_20048_length_259_cov_2.478495_g19954_i0	PRJNA485080	20048	259	2.478495	6.41930205	Cetobacterium somerae	188913	Bacteria	Bacteria	466	7.11e-127	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g19954	i0	99.228	11.2239382239382	259	1	100	1	1	259	408764	408507	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2907	466	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10025689	10025689	PRJNA485080_P_NODE_15608_length_288_cov_1.432558_g15514_i0	PRJNA485080	15608	288	1.432558	4.12576704	Cetobacterium	180162	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g15514	i0	100	5.56597222222222	288	0	100	0	1	288	68345	68632	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1603	532	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11300639	11300639	PRJNA485080_P_NODE_23749_length_250_cov_0.870056_g23655_i0	PRJNA485080	23749	250	0.870056	2.17514	Cetobacterium	180162	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g23655	i0	99.2	6.836	250	2	100	0	1	250	371022	371271	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	1709	451	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12576365	12576365	PRJNA485080_P_NODE_11950_length_317_cov_1.262295_g11856_i0	PRJNA485080	11950	317	1.262295	4.00147515	Cetobacterium	180162	Bacteria	Bacteria	586	6.579999999999998e-163	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g11856	i0	100	5.19558359621451	317	0	100	0	1	317	219067	219383	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1647	586	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13202990	13202990	PRJNA485080_P_NODE_4291_length_456_cov_1.608355_g4197_i0	PRJNA485080	4291	456	1.608355	7.3340988	Cetobacterium somerae	188913	Bacteria	Bacteria	843	0	NTclustered	gi\|2201062198\|gb\|CP092520.1\|	188913	g4197	i0	100	5	456	0	100	0	1	456	636385	636840	Cetobacterium somerae strain CS2105-BJ plasmid unnamed1, complete sequence	blastn	2280	843	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13851033	13851033	PRJNA485080_P_NODE_32891_length_246_cov_0.890173_g32797_i0	PRJNA485080	32891	246	0.890173	2.18982558	Cetobacterium	180162	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g32797	i0	100	5	246	0	100	0	1	246	411109	411354	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	1230	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15125399	15125399	PRJNA485080_P_NODE_4952_length_429_cov_1.617978_g4858_i0	PRJNA485080	4952	429	1.617978	6.94112562	Cetobacterium	180162	Bacteria	Bacteria	787	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g4858	i0	99.767	4.995337995338	429	1	100	0	1	429	1714006	1713578	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2143	787	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16399975	16399975	PRJNA485080_P_NODE_9373_length_342_cov_1.717472_g9279_i0	PRJNA485080	9373	342	1.717472	5.87375424	Cetobacterium	180162	Bacteria	Bacteria	632	9.079999999999999e-177	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g9279	i0	100	4.99415204678363	342	0	100	0	1	342	1384100	1384441	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1708	632	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16399976	16399976	PRJNA485080_P_NODE_9673_length_339_cov_1.154135_g9579_i0	PRJNA485080	9673	339	1.154135	3.91251765	Cetobacterium	180162	Bacteria	Bacteria	621	1.95e-173	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g9579	i0	99.705	5	339	1	100	0	1	339	128565	128903	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1695	621	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18300926	18300926	PRJNA485080_P_NODE_40295_length_242_cov_0.911243_g40201_i0	PRJNA485080	40295	242	0.911243	2.20520806	Cetobacterium somerae	188913	Bacteria	Bacteria	403	5.22e-108	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g40201	i0	96.694	9.91322314049587	242	8	100	0	1	242	68495	68254	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2399	403	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18948894	18948894	PRJNA485080_P_NODE_30535_length_247_cov_0.885057_g30441_i0	PRJNA485080	30535	247	0.885057	2.18609079	Cetobacterium	180162	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g30441	i0	100	5.26720647773279	247	0	100	0	1	247	1907442	1907196	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1301	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19574706	19574706	PRJNA485080_P_NODE_11276_length_323_cov_1.196000_g11182_i0	PRJNA485080	11276	323	1.196	3.86308	Cetobacterium somerae	188913	Bacteria	Bacteria	586	6.72e-163	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g11182	i0	99.381	11.1021671826625	323	2	100	0	1	323	276474	276796	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	3586	586	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21499237	21499237	PRJNA485080_P_NODE_27677_length_248_cov_1.320000_g27583_i0	PRJNA485080	27677	248	1.32	3.2736	Cetobacterium	180162	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g27583	i0	100	77.6612903225806	248	0	100	0	1	248	1899179	1898932	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	19260	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21499263	21499263	PRJNA485080_P_NODE_41997_length_241_cov_1.363095_g41903_i0	PRJNA485080	41997	241	1.363095	3.28505895	Cetobacterium	180162	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g41903	i0	100	8.0954356846473	241	0	100	0	1	241	1741855	1742095	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1951	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24049293	24049293	PRJNA485080_P_NODE_27639_length_248_cov_1.760000_g27545_i0	PRJNA485080	27639	248	1.76	4.3648	Cetobacterium	180162	Bacteria	Bacteria	418	1.9199999999999994e-112	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g27545	i0	100	137.032258064516	226	0	91	0	1	226	2004538	2004763	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	33984	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24675388	24675388	PRJNA485080_P_NODE_43320_length_241_cov_0.916667_g43226_i0	PRJNA485080	43320	241	0.916667	2.20916747	Cetobacterium somerae	188913	Bacteria	Bacteria	388	1.46e-103	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g43226	i0	98.63	9.49792531120332	219	3	91	0	23	241	270748	270530	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2289	388	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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