metadata: contig_metadata: 5 rows where bioproject = "PRJNA827593", tax_kingdom = "Fusobacteriati" and tax

5 rows where bioproject = "PRJNA827593", tax_kingdom = "Fusobacteriati" and tax_superkingdom = "Bacteria"

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
3371981	3371981	PRJNA827593_P_NODE_36103_length_340_cov_1.812734_g35804_i0	PRJNA827593	36103	340	1.812734	6.1632956	Sebaldella termitidis	826	Bacteria	Bacteria	60.2	1.92e-4	NTclustered	gi\|268612520\|gb\|CP001739.1\|	526218	g35804	i0	85	0.176470588235294	60	7	18	2	134	193	31463	31520	Sebaldella termitidis ATCC 33386, complete genome	blastn	60	60.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella termitidis
8473648	8473648	PRJNA827593_P_NODE_14547_length_568_cov_4.357576_g14252_i0	PRJNA827593	14547	568	4.357576	24.75103168	Cetobacterium somerae	188913	Bacteria	Bacteria	623	9.469999999999999e-174	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g14252	i0	86.491	11.9154929577465	570	73	100	4	1	568	1403791	1403224	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	6768	623	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13575123	13575123	PRJNA827593_P_NODE_61711_length_250_cov_1.361582_g61412_i0	PRJNA827593	61711	250	1.361582	3.403955	uncultured Propionigenium sp.	259317	Bacteria	Bacteria	449	6.87e-122	NTclustered	gi\|453201797\|gb\|JQ999705.1\|	259317	g61412	i0	99.197	345.056	249	2	99	0	1	249	365	117	Uncultured Propionigenium sp. clone GKJWQY101AW14Z 23S ribosomal RNA gene, partial sequence	blastn	86264	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Propionigenium	uncultured Propionigenium sp.
15256362	15256362	PRJNA827593_P_NODE_27652_length_396_cov_1.452012_g27353_i0	PRJNA827593	27652	396	1.452012	5.74996752	Cetobacterium	180162	Bacteria	Bacteria	708	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g27353	i0	98.99	505.941919191919	396	2	99	1	3	396	1317539	1317144	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	200353	708	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22497548	22497548	PRJNA827593_P_NODE_15978_length_540_cov_2.593148_g15681_i0	PRJNA827593	15978	540	2.593148	14.0029992	Cetobacterium somerae	188913	Bacteria	Bacteria	649	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g15681	i0	88.577	6.94444444444444	534	61	99	0	7	540	1404316	1403783	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	3750	649	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);;