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

5 rows where bioproject = "PRJNA492406", tax_kingdom = "Fusobacteriati" 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
1099204	1099204	PRJNA492406_P_NODE_16321_length_310_cov_1.506329_g16022_i0	PRJNA492406	16321	310	1.506329	4.6696199	Cetobacterium	180162	Bacteria	Bacteria	534	2.3599999999999998e-147	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g16022	i0	97.742	134.877419354839	310	7	100	0	1	310	1899195	1899504	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	41812	534	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2374781	2374781	PRJNA492406_P_NODE_25562_length_255_cov_4.604396_g25263_i0	PRJNA492406	25562	255	4.604396	11.7412098	Cetobacterium	180162	Bacteria	Bacteria	335	2.0499999999999993e-87	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g25263	i0	91.016	5.01960784313725	256	12	99	8	3	255	1218714	1218961	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1280	335	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8752113	8752113	PRJNA492406_P_NODE_15587_length_317_cov_11.196721_g15288_i0	PRJNA492406	15587	317	11.196721	35.49360557	Cetobacterium	180162	Bacteria	Bacteria	534	2.42e-147	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g15288	i0	97.152	18.9179810725552	316	9	99	0	2	317	1948430	1948745	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5997	534	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20854089	20854089	PRJNA492406_P_NODE_20317_length_282_cov_1.339713_g20018_i0	PRJNA492406	20317	282	1.339713	3.77799066	Cetobacterium somerae	188913	Bacteria	Bacteria	388	1.7499999999999998e-103	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g20018	i0	91.519	95.1524822695036	283	22	100	2	1	282	1990816	1990535	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	26833	388	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
32826083	32826083	PRJNA492406_P_NODE_20680_length_280_cov_1.468599_g20381_i0	PRJNA492406	20680	280	1.468599	4.1120772	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	154	1.84e-44	NR	WP_052193983.1	1339239	g20381	i0	100	0.996428571428571	93	0	99.6	0	2	280	4	96	WP_052193983.1 outer membrane beta-barrel protein [Cetobacterium sp. ZOR0034]	diamond	279	154	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034

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