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

9 rows where analysis = "blastn", bioproject = "PRJNA982106" 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
2239341	2239341	PRJNA982106_P_NODE_32602_length_241_cov_0.916667_g32362_i0	PRJNA982106	32602	241	0.916667	2.20916747	Fusobacterium mortiferum	850	Bacteria	Bacteria	139	1.62e-28	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g32362	i0	83.553	53.8340248962656	152	22	62	3	82	231	1644478	1644628	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	12974	139	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
8616609	8616609	PRJNA982106_P_NODE_12507_length_303_cov_1.004348_g12267_i0	PRJNA982106	12507	303	1.004348	3.04317444	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	555	1.7599999999999995e-153	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g12267	i0	99.67	475.19801980198	303	1	100	0	1	303	5979	6281	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	143985	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
14991668	14991668	PRJNA982106_P_NODE_19032_length_259_cov_1.241935_g18792_i0	PRJNA982106	19032	259	1.241935	3.21661165	Fusobacterium mortiferum	850	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g18792	i0	100	1.86872586872587	259	0	100	0	1	259	249377	249119	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	484	479	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
18815516	18815516	PRJNA982106_P_NODE_20475_length_251_cov_0.865169_g20235_i0	PRJNA982106	20475	251	0.865169	2.17157419	Fusobacterium mortiferum	850	Bacteria	Bacteria	420	5.41e-113	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g20235	i0	96.813	13.5498007968127	251	8	100	0	1	251	1386763	1386513	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	3401	420	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
18815683	18815683	PRJNA982106_P_NODE_28975_length_244_cov_0.900585_g28735_i0	PRJNA982106	28975	244	0.900585	2.1974274	Fusobacterium mortiferum	850	Bacteria	Bacteria	449	6.68e-122	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g28735	i0	100	1.15163934426229	243	0	99	0	2	244	2532124	2531882	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	281	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
21365860	21365860	PRJNA982106_P_NODE_20437_length_251_cov_0.865169_g20197_i0	PRJNA982106	20437	251	0.865169	2.17157419	Fusobacterium mortiferum	850	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g20197	i0	100	7.09163346613546	251	0	100	0	1	251	1288019	1288269	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	1780	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
22640982	22640982	PRJNA982106_P_NODE_26618_length_246_cov_0.890173_g26378_i0	PRJNA982106	26618	246	0.890173	2.18982558	Fusobacterium mortiferum	850	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g26378	i0	98.78	1	246	3	100	0	1	246	2568360	2568605	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	246	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
22640986	22640986	PRJNA982106_P_NODE_26778_length_246_cov_0.890173_g26538_i0	PRJNA982106	26778	246	0.890173	2.18982558	Fusobacterium nucleatum	851	Bacteria	Bacteria	167	7.61e-37	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g26538	i0	79.116	84.0121951219512	249	46	100	6	1	246	1435235	1435480	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	20667	167	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
25190041	25190041	PRJNA982106_P_NODE_23360_length_249_cov_0.875000_g23120_i0	PRJNA982106	23360	249	0.875	2.17875	Fusobacterium mortiferum	850	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g23120	i0	99.598	1	249	1	100	0	1	249	2219381	2219629	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	249	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum

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