metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA326068" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA326068" 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
2940075	2940075	PRJNA326068_P_NODE_4863_length_500_cov_40.267516_g4055_i0	PRJNA326068	4863	500	40.267516	201.33758	Cetobacterium somerae	188913	Bacteria	Bacteria	889	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g4055	i0	98.8	521.232	500	5	100	1	1	500	48913	49411	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	260616	889	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14418284	14418284	PRJNA326068_P_NODE_3512_length_591_cov_364.820285_g2803_i0	PRJNA326068	3512	591	364.820285	2156.08788435	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	599	1.6599999999999995e-166	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g2803	i0	85.593	89.2825719120135	590	64	99	10	1	587	23504	24075	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	52766	599	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
15097033	15097033	PRJNA326068_P_NODE_19072_length_163_cov_3.619403_g18109_i0	PRJNA326068	19072	163	3.619403	5.89962689	Cetobacterium	180162	Bacteria	Bacteria	285	1.23e-72	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g18109	i0	98.16	13.2822085889571	163	3	100	0	1	163	1774391	1774229	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2165	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16966792	16966792	PRJNA326068_P_NODE_2914_length_645_cov_9.977273_g2283_i0	PRJNA326068	2914	645	9.977273	64.35341085	Cetobacterium somerae	188913	Bacteria	Bacteria	876	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g2283	i0	91.244	70.768992248062	651	45	99	9	4	644	67704	67056	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	45646	876	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18920644	18920644	PRJNA326068_P_NODE_2915_length_645_cov_9.519481_g2283_i1	PRJNA326068	2915	645	9.519481	61.40065245	Cetobacterium	180162	Bacteria	Bacteria	872	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g2283	i1	90.992	71.7240310077519	655	47	100	8	1	645	1484807	1485459	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	46262	872	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20195249	20195249	PRJNA326068_P_NODE_17316_length_193_cov_13.871951_g16353_i0	PRJNA326068	17316	193	13.871951	26.77286543	Cetobacterium	180162	Bacteria	Bacteria	346	6.82e-91	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g16353	i0	98.964	505.015544041451	193	2	100	0	1	193	278722	278914	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	97468	346	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20790907	20790907	PRJNA326068_P_NODE_16577_length_203_cov_3.758621_g15614_i0	PRJNA326068	16577	203	3.758621	7.63000063	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	370	4.3e-98	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g15614	i0	99.507	125.684729064039	203	1	100	0	1	203	28206	28004	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	25514	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
22746073	22746073	PRJNA326068_P_NODE_1358_length_906_cov_99.242873_g981_i0	PRJNA326068	1358	906	99.242873	899.14042938	Cetobacterium	180162	Bacteria	Bacteria	1454	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g981	i0	95.7	517.870860927152	907	34	99	5	3	906	278714	279618	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	469191	1454	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24615552	24615552	PRJNA326068_P_NODE_6100_length_443_cov_4.826087_g5217_i0	PRJNA326068	6100	443	4.826087	21.37956541	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	815	0	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g5217	i0	100	191.805869074492	441	0	99	0	3	443	25333	25773	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	84970	815	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221

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