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

9 rows where analysis = "blastn", bioproject = "PRJNA669701" 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
2439166	2439166	PRJNA669701_P_NODE_133742_length_243_cov_1.435294_g133347_i0	PRJNA669701	133742	243	1.435294	3.48776442	Fusobacterium	848	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2705011345\|gb\|CP084124.1\|	851	g133347	i0	99.588	479.106995884774	243	1	100	0	1	243	1949289	1949531	Fusobacterium nucleatum strain KCOM3182 chromosome, complete genome	blastn	116423	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
3716435	3716435	PRJNA669701_P_NODE_84843_length_276_cov_1.517241_g84448_i0	PRJNA669701	84843	276	1.517241	4.18758516	Leptotrichia	32067	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g84448	i0	100	385.373188405797	276	0	100	0	1	276	593232	592957	Leptotrichia sp. oral taxon 498, complete genome	blastn	106363	510	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
7014232	7014232	PRJNA669701_P_NODE_33346_length_407_cov_2.206587_g32951_i0	PRJNA669701	33346	407	2.206587	8.98080909	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	603	8.6e-168	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g32951	i0	93.366	90.3882063882064	407	27	100	0	1	407	51609	52015	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	36788	603	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
10092358	10092358	PRJNA669701_P_NODE_107288_length_251_cov_1.646067_g106893_i0	PRJNA669701	107288	251	1.646067	4.13162817	Fusobacterium	848	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g106893	i0	99.602	420.254980079681	251	1	100	0	1	251	83789	84039	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	105484	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
14664930	14664930	PRJNA669701_P_NODE_56712_length_322_cov_1.855422_g56317_i0	PRJNA669701	56712	322	1.855422	5.97445884	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	479	1.17e-130	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g56317	i0	94.006	296.267080745342	317	18	98	1	1	316	52819	53135	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	95398	479	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14665312	14665312	PRJNA669701_P_NODE_85652_length_275_cov_1.579208_g85257_i0	PRJNA669701	85652	275	1.579208	4.342822	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	486	5.8499999999999985e-133	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g85257	i0	98.545	10.1709090909091	275	4	100	0	1	275	1505163	1505437	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	2797	486	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
15192804	15192804	PRJNA669701_P_NODE_30172_length_427_cov_2.025424_g29777_i0	PRJNA669701	30172	427	2.025424	8.64856048	Fusobacterium	848	Bacteria	Bacteria	761	0	NTclustered	gi\|2445153921\|gb\|CP117797.1\|	851	g29777	i0	98.829	497.173302107728	427	5	100	0	1	427	114788	115214	Fusobacterium nucleatum strain FNA chromosome, complete genome	blastn	212293	761	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
17213045	17213045	PRJNA669701_P_NODE_114554_length_249_cov_0.875000_g114159_i0	PRJNA669701	114554	249	0.875	2.17875	Leptotrichia hofstadii	157688	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g114159	i0	98.79	191.329317269076	248	3	100	0	1	248	497973	498220	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	47641	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
22312419	22312419	PRJNA669701_P_NODE_117418_length_248_cov_0.880000_g117023_i0	PRJNA669701	117418	248	0.88	2.1824	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g117023	i0	100	429.983870967742	248	0	100	0	1	248	200948	201195	Leptotrichia sp. SK-5 DNA, complete genome	blastn	106636	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5

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