metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA1002816" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA1002816" 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
3551462	3551462	PRJNA1002816_P_NODE_14063_length_292_cov_1.054795_g13903_i0	PRJNA1002816	14063	292	1.054795	3.0800014	Cetobacterium	180162	Bacteria	Bacteria	446	1.06e-120	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g13903	i0	98.425	87.9383561643836	254	3	87	1	40	292	3731	3478	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	25678	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6104050	6104050	PRJNA1002816_P_NODE_16485_length_262_cov_2.185185_g16325_i0	PRJNA1002816	16485	262	2.185185	5.7251847	Cetobacterium	180162	Bacteria	Bacteria	399	7.409999999999998e-107	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g16325	i0	94.297	39.2900763358779	263	11	100	4	1	262	1858466	1858725	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	10294	399	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7805371	7805371	PRJNA1002816_P_NODE_14967_length_281_cov_1.379808_g14807_i0	PRJNA1002816	14967	281	1.379808	3.87726048	Cetobacterium somerae	188913	Bacteria	Bacteria	259	1.42e-64	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g14807	i0	84.47	4.66903914590747	264	40	94	1	11	274	1492494	1492756	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1312	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7805383	7805383	PRJNA1002816_P_NODE_15607_length_274_cov_1.134328_g15447_i0	PRJNA1002816	15607	274	1.134328	3.10805872	Cetobacterium somerae	188913	Bacteria	Bacteria	490	4.499999999999999e-134	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g15447	i0	98.905	30.1605839416058	274	3	100	0	1	274	1743664	1743391	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	8264	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22677725	22677725	PRJNA1002816_P_NODE_11138_length_333_cov_1.773077_g10978_i0	PRJNA1002816	11138	333	1.773077	5.90434641	Cetobacterium	180162	Bacteria	Bacteria	616	8.87e-172	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10978	i0	100	107.492492492492	333	0	100	0	1	333	1898769	1899101	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	35795	616	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24378821	24378821	PRJNA1002816_P_NODE_16140_length_267_cov_1.391753_g15980_i0	PRJNA1002816	16140	267	1.391753	3.71598051	Cetobacterium somerae	188913	Bacteria	Bacteria	385	2.12e-102	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g15980	i0	93.436	5.87640449438202	259	17	97	0	1	259	1903697	1903955	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1569	385	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);;