metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJDB12578" and tax

19 rows where analysis = "blastn", bioproject = "PRJDB12578" 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
3085	3085	PRJDB12578_S_NODE_173281_length_183_cov_1.156716_g150223_i0	PRJDB12578	173281	183	1.156716	2.11679028	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g150223	i0	100	0.153005464480874	28	0	15	0	108	135	2349885	2349912	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
2256078	2256078	PRJDB12578_S_NODE_204262_length_165_cov_1.318966_g181204_i0	PRJDB12578	204262	165	1.318966	2.1762939	Cetobacterium	180162	Bacteria	Bacteria	255	9.8e-64	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g181204	i0	94.545	70.969696969697	165	9	100	0	1	165	1861253	1861089	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	11710	255	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2553962	2553962	PRJDB12578_S_NODE_200383_length_166_cov_1.760684_g177325_i0	PRJDB12578	200383	166	1.760684	2.92273544	Cetobacterium somerae	188913	Bacteria	Bacteria	250	4.59e-62	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g177325	i0	96.104	15.4698795180723	154	5	92	1	1	153	708289	708442	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	2568	250	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3531392	3531392	PRJDB12578_S_NODE_160043_length_194_cov_1.034483_g136985_i0	PRJDB12578	160043	194	1.034483	2.00689702	Cetobacterium	180162	Bacteria	Bacteria	348	1.91e-91	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g136985	i0	98.969	99.8453608247423	194	2	100	0	1	194	1906222	1906029	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	19370	348	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3531435	3531435	PRJDB12578_S_NODE_196863_length_168_cov_0.865546_g173805_i0	PRJDB12578	196863	168	0.865546	1.45411728	Cetobacterium	180162	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g173805	i0	98.214	5	168	3	100	0	1	168	1901633	1901800	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	840	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4808668	4808668	PRJDB12578_S_NODE_155444_length_198_cov_1.053691_g132386_i0	PRJDB12578	155444	198	1.053691	2.08630818	Cetobacterium	180162	Bacteria	Bacteria	361	2.51e-95	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g132386	i0	99.495	5	198	1	100	0	1	198	1909373	1909570	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	990	361	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6083919	6083919	PRJDB12578_S_NODE_130265_length_226_cov_1.728814_g107207_i0	PRJDB12578	130265	226	1.728814	3.90711964	Cetobacterium	180162	Bacteria	Bacteria	318	1.8e-82	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g107207	i0	92.035	97.9513274336283	226	18	100	0	1	226	346070	346295	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	22137	318	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6083997	6083997	PRJDB12578_S_NODE_199305_length_167_cov_0.872881_g176247_i0	PRJDB12578	199305	167	0.872881	1.45771127	Cetobacterium	180162	Bacteria	Bacteria	268	1.28e-67	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g176247	i0	95.808	13.1616766467066	167	6	100	1	1	167	1999298	1999133	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2198	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6084010	6084010	PRJDB12578_S_NODE_207005_length_164_cov_1.347826_g183947_i0	PRJDB12578	207005	164	1.347826	2.21043464	Fusobacterium	848	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2706054094\|gb\|CP077189.1\|	76859	g183947	i0	100	0.914634146341463	30	0	18	0	27	56	1999846	1999817	Fusobacterium animalis strain SB027 chromosome, complete genome	blastn	150	56.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
8633805	8633805	PRJDB12578_S_NODE_106987_length_271_cov_1.635135_g83929_i0	PRJDB12578	106987	271	1.635135	4.43121585	Cetobacterium	180162	Bacteria	Bacteria	424	4.57e-114	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g83929	i0	94.834	19.8929889298893	271	14	100	0	1	271	1902765	1903035	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5391	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9908854	9908854	PRJDB12578_S_NODE_107868_length_269_cov_1.154545_g84810_i0	PRJDB12578	107868	269	1.154545	3.10572605	Cetobacterium	180162	Bacteria	Bacteria	464	2.67e-126	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g84810	i0	98.12	26.8327137546468	266	5	99	0	4	269	1903370	1903105	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	7218	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12459903	12459903	PRJDB12578_S_NODE_144190_length_209_cov_1.387500_g121132_i0	PRJDB12578	144190	209	1.3875	2.899875	Cetobacterium	180162	Bacteria	Bacteria	243	1.01e-59	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g121132	i0	87.981	20.4114832535885	208	22	99	3	1	208	1899375	1899171	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4266	243	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12756292	12756292	PRJDB12578_S_NODE_163431_length_191_cov_1.084507_g140373_i0	PRJDB12578	163431	191	1.084507	2.07140837	Cetobacterium somerae	188913	Bacteria	Bacteria	270	4.17e-68	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g140373	i0	92.147	65.3717277486911	191	15	100	0	1	191	1561552	1561362	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	12486	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18832472	18832472	PRJDB12578_S_NODE_140795_length_213_cov_1.250000_g117737_i0	PRJDB12578	140795	213	1.25	2.6625	Cetobacterium	180162	Bacteria	Bacteria	339	1.28e-88	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g117737	i0	95.305	16.868544600939	213	10	100	0	1	213	1860465	1860253	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3593	339	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22657726	22657726	PRJDB12578_S_NODE_120978_length_241_cov_2.583333_g97920_i0	PRJDB12578	120978	241	2.583333	6.22583253	Cetobacterium	180162	Bacteria	Bacteria	385	1.88e-102	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g97920	i0	95.436	178.879668049793	241	11	100	0	1	241	1898640	1898400	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	43110	385	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24226481	24226481	PRJDB12578_S_NODE_109240_length_265_cov_2.157407_g86182_i0	PRJDB12578	109240	265	2.157407	5.71712855	Fusobacterium gonidiaformans	849	Bacteria	Bacteria	113	1.1e-20	NTclustered	gi\|1370530246\|gb\|CP028106.1\|	469615	g86182	i0	82.222	0.509433962264151	135	21	51	3	17	150	1420105	1420237	Fusobacterium gonidiaformans ATCC 25563 chromosome, complete genome	blastn	135	113	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium gonidiaformans
24226568	24226568	PRJDB12578_S_NODE_111320_length_261_cov_0.957547_g88262_i0	PRJDB12578	111320	261	0.957547	2.49919767	Cetobacterium somerae	188913	Bacteria	Bacteria	399	7.379999999999998e-107	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g88262	i0	94.253	79.8582375478927	261	15	100	0	1	261	384746	384486	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	20843	399	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25206835	25206835	PRJDB12578_S_NODE_129120_length_228_cov_1.156425_g106062_i0	PRJDB12578	129120	228	1.156425	2.636649	Cetobacterium	180162	Bacteria	Bacteria	411	2.909999999999999e-110	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g106062	i0	99.123	100.723684210526	228	2	100	0	1	228	1903676	1903449	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	22965	411	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25207015	25207015	PRJDB12578_S_NODE_92540_length_320_cov_1.512915_g69482_i0	PRJDB12578	92540	320	1.512915	4.841328	Cetobacterium	180162	Bacteria	Bacteria	468	2.51e-127	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g69482	i0	93.354	125.746875	316	21	99	0	5	320	1899190	1898875	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	40239	468	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);;