metadata: contig_metadata: 9 rows where bioproject = "PRJNA766854" and tax

9 rows where bioproject = "PRJNA766854" 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
744984	744984	PRJNA766854_P_NODE_18621_length_212_cov_6.551913_g18494_i0	PRJNA766854	18621	212	6.551913	13.89005556	Leptotrichia wadei	157687	Bacteria	Bacteria	270	4.729999999999999e-68	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g18494	i0	90.291	96.5377358490566	206	20	97	0	4	209	2369809	2369604	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	20466	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
2020986	2020986	PRJNA766854_P_NODE_362_length_584_cov_139.974775_g289_i0	PRJNA766854	362	584	139.974775	817.452686	Cetobacterium somerae	188913	Bacteria	Bacteria	1038	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g289	i0	98.801	513.861301369863	584	6	100	1	1	584	49433	48851	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	300095	1038	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7584048	7584048	PRJNA766854_P_NODE_986_length_424_cov_1.045570_g871_i0	PRJNA766854	986	424	1.04557	4.4332168	Cetobacterium	180162	Bacteria	Bacteria	119	3.97e-22	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g871	i0	100	1.26179245283019	64	0	25	0	183	246	1901601	1901664	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	535	119	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11409779	11409779	PRJNA766854_P_NODE_1609_length_327_cov_1.929530_g1484_i0	PRJNA766854	1609	327	1.92953	6.3095631	Cetobacterium	180162	Bacteria	Bacteria	132	3.84e-26	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1484	i0	85.816	3.05810397553517	141	0	61	1	3	143	1908575	1908695	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1000	132	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12685593	12685593	PRJNA766854_P_NODE_1530_length_335_cov_2.552288_g1405_i0	PRJNA766854	1530	335	2.552288	8.5501648	Cetobacterium	180162	Bacteria	Bacteria	141	6.55e-29	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1405	i0	100	6.61791044776119	76	0	58	0	84	159	481020	481095	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2217	141	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13498714	13498714	PRJNA766854_P_NODE_2031_length_299_cov_267.274074_g1906_i0	PRJNA766854	2031	299	267.274074	799.14948126	Cetobacterium somerae	188913	Bacteria	Bacteria	425	1.42e-114	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g1906	i0	92.333	497.09364548495	300	21	100	2	1	299	941035	941333	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	148631	425	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13498723	13498723	PRJNA766854_P_NODE_291_length_623_cov_2.176768_g230_i0	PRJNA766854	291	623	2.176768	13.56126464	Leptotrichia wadei	157687	Bacteria	Bacteria	161	9.84e-35	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g230	i0	89.683	28.7736757624398	126	13	20	0	166	291	368360	368235	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	17926	161	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
18596676	18596676	PRJNA766854_P_NODE_715_length_470_cov_2.589569_g609_i0	PRJNA766854	715	470	2.589569	12.1709743	Cetobacterium somerae	188913	Bacteria	Bacteria	472	2.9599999999999997e-128	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g609	i0	94.719	33.931914893617	303	16	89	0	62	364	67561	67259	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	15948	472	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24157654	24157654	PRJNA766854_P_NODE_39_length_1208_cov_359.394402_g15_i1	PRJNA766854	39	1208	359.394402	4341.48437616	Cetobacterium	180162	Bacteria	Bacteria	1886	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g15	i1	99.517	510.328642384106	1036	5	98	0	155	1190	279703	278668	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	616477	1886	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);;