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

31 rows where analysis = "blastn", bioproject = "PRJDB3785" 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
981164	981164	PRJDB3785_S_NODE_25981_length_163_cov_0.894737_g25828_i0	PRJDB3785	25981	163	0.894737	1.45842131	Cetobacterium	180162	Bacteria	Bacteria	279	5.73e-71	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g25828	i0	97.546	5.95092024539877	163	4	100	0	1	163	480527	480365	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	970	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2256434	2256434	PRJDB3785_S_NODE_27342_length_161_cov_0.910714_g27189_i0	PRJDB3785	27342	161	0.910714	1.46624954	Cetobacterium	180162	Bacteria	Bacteria	185	1.2599999999999999e-42	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g27189	i0	87.5	3.97515527950311	160	20	99	0	1	160	438558	438399	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	640	185	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4809116	4809116	PRJDB3785_S_NODE_7704_length_270_cov_2.063348_g7551_i0	PRJDB3785	7704	270	2.063348	5.5710396	Cetobacterium	180162	Bacteria	Bacteria	285	2.24e-72	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g7551	i0	90.045	4.06666666666667	221	21	81	1	3	222	25610	25390	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1098	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6084353	6084353	PRJDB3785_S_NODE_825_length_888_cov_2.216925_g740_i0	PRJDB3785	825	888	2.216925	19.686294	Cetobacterium	180162	Bacteria	Bacteria	795	0	NTclustered	gi\|2666490175\|gb\|CP143320.1\|	188913	g740	i0	83.2	4.95608108108108	875	140	98	7	13	883	624608	623737	Cetobacterium somerae strain ceto plasmid p1, complete sequence	blastn	4401	800	0.99375	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7358858	7358858	PRJDB3785_S_NODE_14046_length_206_cov_1.420382_g13893_i0	PRJDB3785	14046	206	1.420382	2.92598692	Cetobacterium	180162	Bacteria	Bacteria	255	1.28e-63	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g13893	i0	89.268	5.87378640776699	205	20	99	2	1	205	17552	17754	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1210	255	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7358859	7358859	PRJDB3785_S_NODE_14166_length_205_cov_2.269231_g14013_i0	PRJDB3785	14166	205	2.269231	4.65192355	Cetobacterium	180162	Bacteria	Bacteria	302	1.61e-77	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g14013	i0	93.171	42.1365853658537	205	14	100	0	1	205	1484860	1485064	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	8638	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7661167	7661167	PRJDB3785_S_NODE_25467_length_163_cov_2.631579_g25314_i0	PRJDB3785	25467	163	2.631579	4.28947377	Cetobacterium somerae	188913	Bacteria	Bacteria	202	1.27e-47	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g25314	i0	89.157	5.0920245398773	166	12	99	6	1	161	67070	67234	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	830	202	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11184480	11184480	PRJDB3785_S_NODE_2089_length_547_cov_3.584337_g1943_i0	PRJDB3785	2089	547	3.584337	19.60632339	Cetobacterium	180162	Bacteria	Bacteria	580	5.55e-161	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1943	i0	86.304	4.88848263254113	533	73	97	0	4	536	119152	118620	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2674	580	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11486688	11486688	PRJDB3785_S_NODE_16650_length_192_cov_1.783217_g16497_i0	PRJDB3785	16650	192	1.783217	3.42377664	Cetobacterium somerae	188913	Bacteria	Bacteria	252	1.52e-62	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g16497	i0	90.526	4.93229166666667	190	18	99	0	1	190	1611615	1611426	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	947	252	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12460368	12460368	PRJDB3785_S_NODE_22330_length_169_cov_1.691667_g22177_i0	PRJDB3785	22330	169	1.691667	2.85891723	Cetobacterium	180162	Bacteria	Bacteria	287	3.55e-73	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g22177	i0	97.605	4.94082840236686	167	4	99	0	2	168	761774	761608	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	835	287	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12460375	12460375	PRJDB3785_S_NODE_27950_length_155_cov_2.132075_g27797_i0	PRJDB3785	27950	155	2.132075	3.30471625	Cetobacterium	180162	Bacteria	Bacteria	226	7.1e-55	NTclustered	gi\|2865369153\|gb\|CP122300.1\|	188913	g27797	i0	92.903	6.94838709677419	155	11	100	0	1	155	10444	10290	Cetobacterium somerae strain MSU41 plasmid p41_t14, complete sequence	blastn	1077	226	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12762366	12762366	PRJDB3785_S_NODE_21551_length_172_cov_1.243902_g21398_i0	PRJDB3785	21551	172	1.243902	2.13951144	Cetobacterium somerae	188913	Bacteria	Bacteria	241	2.87e-59	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g21398	i0	91.86	76.8255813953488	172	14	100	0	1	172	1086571	1086742	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	13214	241	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12762517	12762517	PRJDB3785_S_NODE_7611_length_272_cov_1.609865_g7458_i0	PRJDB3785	7611	272	1.609865	4.3788328	Cetobacterium somerae	188913	Bacteria	Bacteria	265	2.94e-66	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g7458	i0	84.444	4.95588235294118	270	40	99	2	4	272	1612890	1613158	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1348	265	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13734658	13734658	PRJDB3785_S_NODE_25051_length_164_cov_0.886957_g24898_i0	PRJDB3785	25051	164	0.886957	1.45460948	Cetobacterium	180162	Bacteria	Bacteria	281	1.6000000000000001e-71	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g24898	i0	97.561	34.9024390243902	164	4	100	0	1	164	1900698	1900861	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5724	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14036803	14036803	PRJDB3785_S_NODE_15852_length_196_cov_1.285714_g15699_i0	PRJDB3785	15852	196	1.285714	2.51999944	Cetobacterium somerae	188913	Bacteria	Bacteria	220	4.39e-53	NTclustered	gi\|2666491293\|gb\|CP143324.1\|	188913	g15699	i0	94.444	1.47448979591837	144	7	73	1	53	196	6492	6350	Cetobacterium somerae strain ceto plasmid p5, complete sequence	blastn	289	220	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14036870	14036870	PRJDB3785_S_NODE_2132_length_541_cov_2.997967_g1986_i0	PRJDB3785	2132	541	2.997967	16.21900147	Cetobacterium somerae	188913	Bacteria	Bacteria	580	5.479999999999998e-161	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g1986	i0	86.111	4.92236598890943	540	73	99	2	3	541	1461347	1460809	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2663	580	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18832920	18832920	PRJDB3785_S_NODE_10235_length_237_cov_0.904255_g10082_i0	PRJDB3785	10235	237	0.904255	2.14308435	Cetobacterium	180162	Bacteria	Bacteria	372	1.44e-98	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10082	i0	95.319	96.042194092827	235	9	99	2	1	234	16069	16302	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	22762	372	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19134287	19134287	PRJDB3785_S_NODE_16616_length_192_cov_2.608392_g16463_i0	PRJDB3785	16616	192	2.608392	5.00811264	Cetobacterium somerae	188913	Bacteria	Bacteria	228	2.5599999999999995e-55	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g16463	i0	88.205	5.078125	195	17	100	6	1	192	270825	271016	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	975	228	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19134334	19134334	PRJDB3785_S_NODE_20316_length_176_cov_2.716535_g20163_i0	PRJDB3785	20316	176	2.716535	4.7811016	Cetobacterium somerae	188913	Bacteria	Bacteria	296	6.21e-76	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g20163	i0	97.143	62.1420454545455	175	5	99	0	2	176	1612414	1612588	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	10937	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20107714	20107714	PRJDB3785_S_NODE_4476_length_360_cov_2.334405_g4323_i0	PRJDB3785	4476	360	2.334405	8.403858	Cetobacterium	180162	Bacteria	Bacteria	326	1.82e-84	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g4323	i0	85.948	3.52777777777778	306	41	85	2	2	306	26220	26524	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1270	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20107717	20107717	PRJDB3785_S_NODE_5676_length_317_cov_1.250000_g5523_i0	PRJDB3785	5676	317	1.25	3.9625	Cetobacterium	180162	Bacteria	Bacteria	529	1.1299999999999997e-145	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g5523	i0	96.835	59.3690851735016	316	10	99	0	2	317	1568529	1568844	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	18820	529	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20409356	20409356	PRJDB3785_S_NODE_15077_length_200_cov_1.350993_g14924_i0	PRJDB3785	15077	200	1.350993	2.701986	Cetobacterium somerae	188913	Bacteria	Bacteria	320	4.31e-83	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g14924	i0	95.5	6	200	9	100	0	1	200	907473	907672	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1200	320	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21383335	21383335	PRJDB3785_S_NODE_10357_length_235_cov_1.913978_g10204_i0	PRJDB3785	10357	235	1.913978	4.4978483	Cetobacterium	180162	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g10204	i0	100	5	235	0	100	0	1	235	366594	366360	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	1175	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21383347	21383347	PRJDB3785_S_NODE_25077_length_164_cov_0.886957_g24924_i0	PRJDB3785	25077	164	0.886957	1.45460948	Cetobacterium	180162	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g24924	i0	98.78	113.073170731707	164	2	100	0	1	164	276196	276033	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	18544	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21383356	21383356	PRJDB3785_S_NODE_537_length_1073_cov_29.410156_g483_i0	PRJDB3785	537	1073	29.410156	315.57097388	Cetobacterium	180162	Bacteria	Bacteria	878	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g483	i0	81.991	5.1789375582479	1055	170	97	18	20	1063	409463	408418	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	5557	878	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22658186	22658186	PRJDB3785_S_NODE_4678_length_351_cov_2.625828_g4525_i0	PRJDB3785	4678	351	2.625828	9.21665628	Cetobacterium	180162	Bacteria	Bacteria	453	7.780000000000001e-123	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g4525	i0	90.23	4.95726495726496	348	33	99	1	1	348	168113	168459	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1740	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22960779	22960779	PRJDB3785_S_NODE_24699_length_165_cov_0.879310_g24546_i0	PRJDB3785	24699	165	0.87931	1.4508615	Cetobacterium somerae	188913	Bacteria	Bacteria	167	4.72e-37	NTclustered	gi\|2201062198\|gb\|CP092520.1\|	188913	g24546	i0	85.366	5.02424242424242	164	20	97	3	6	165	492111	491948	Cetobacterium somerae strain CS2105-BJ plasmid unnamed1, complete sequence	blastn	829	167	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22960864	22960864	PRJDB3785_S_NODE_5199_length_332_cov_1.826855_g5046_i0	PRJDB3785	5199	332	1.826855	6.0651586	Cetobacterium somerae	188913	Bacteria	Bacteria	359	1.6499999999999998e-94	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g5046	i0	86.322	4.96385542168675	329	45	99	0	1	329	1714075	1714403	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1648	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
23933624	23933624	PRJDB3785_S_NODE_7399_length_276_cov_1.647577_g7246_i0	PRJDB3785	7399	276	1.647577	4.54731252	Cetobacterium	180162	Bacteria	Bacteria	303	6.35e-78	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g7246	i0	87.085	4.90217391304348	271	32	98	3	7	276	144909	145177	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1353	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25207252	25207252	PRJDB3785_S_NODE_13440_length_210_cov_1.236025_g13287_i0	PRJDB3785	13440	210	1.236025	2.5956525	Cetobacterium	180162	Bacteria	Bacteria	327	2.73e-85	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g13287	i0	94.762	5	210	11	100	0	1	210	957027	957236	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1050	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25207269	25207269	PRJDB3785_S_NODE_27120_length_161_cov_0.910714_g26967_i0	PRJDB3785	27120	161	0.910714	1.46624954	Cetobacterium	180162	Bacteria	Bacteria	252	1.23e-62	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g26967	i0	95	4.96894409937888	160	8	99	0	1	160	1392821	1392662	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	800	252	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);;