metadata: contig_metadata: 5 rows where bioproject = "PRJNA385396" and tax

5 rows where bioproject = "PRJNA385396" 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
2957555	2957555	PRJNA385396_P_NODE_16743_length_247_cov_0.885057_g16651_i0	PRJNA385396	16743	247	0.885057	2.18609079	Cetobacterium somerae	188913	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2666491349\|gb\|CP143325.1\|	188913	g16651	i0	99.19	1	247	2	100	0	1	247	19891	19645	Cetobacterium somerae strain ceto plasmid p6, complete sequence	blastn	247	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6784492	6784492	PRJNA385396_P_NODE_13486_length_251_cov_0.865169_g13394_i0	PRJNA385396	13486	251	0.865169	2.17157419	Cetobacterium somerae	188913	Bacteria	Bacteria	344	3.3499999999999998e-90	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g13394	i0	91.566	4.9601593625498	249	21	99	0	3	251	1407416	1407664	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1245	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8729261	8729261	PRJNA385396_P_NODE_5867_length_344_cov_3.184502_g5775_i0	PRJNA385396	5867	344	3.184502	10.95468688	Cetobacterium	180162	Bacteria	Bacteria	551	2.629999999999999e-152	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g5775	i0	96.96	93.3808139534884	329	8	95	2	1	328	479374	479047	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	32123	551	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15104309	15104309	PRJNA385396_P_NODE_2192_length_506_cov_3.076212_g2100_i0	PRJNA385396	2192	506	3.076212	15.56563272	Cetobacterium	180162	Bacteria	Bacteria	682	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g2100	i0	91.566	30.8913043478261	498	37	98	5	10	504	1485420	1484925	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	15631	682	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24633299	24633299	PRJNA385396_P_NODE_1820_length_549_cov_2.262605_g1728_i0	PRJNA385396	1820	549	2.262605	12.42170145	Cetobacterium somerae	188913	Bacteria	Bacteria	974	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g1728	i0	98.725	524.083788706739	549	6	100	1	1	549	49434	48887	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	287722	974	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);;