metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA826497" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA826497" 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
820719	820719	PRJNA826497_S_NODE_981_length_337_cov_7.496711_g941_i0	PRJNA826497	981	337	7.496711	25.26391607	Leptotrichia trevisanii	109328	Bacteria	Bacteria	577	4.2399999999999996e-160	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g941	i0	99.683	2.79821958456973	315	1	93	0	23	337	1991941	1992255	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	943	577	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
2096134	2096134	PRJNA826497_S_NODE_11902_length_177_cov_34.951389_g11862_i0	PRJNA826497	11902	177	34.951389	61.86395853	Leptotrichia hofstadii	157688	Bacteria	Bacteria	305	1.04e-78	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g11862	i0	97.74	11.225988700565	177	4	100	0	1	177	2221410	2221234	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	1987	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
2503728	2503728	PRJNA826497_S_NODE_10522_length_184_cov_3.860927_g10482_i0	PRJNA826497	10522	184	3.860927	7.10410568	Leptotrichia	32067	Bacteria	Bacteria	327	2.3299999999999996e-85	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g10482	i0	98.907	4.69021739130435	183	2	99	0	1	183	654706	654888	Leptotrichia sp. oral taxon 498, complete genome	blastn	863	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
7198752	7198752	PRJNA826497_S_NODE_16046_length_161_cov_20.695312_g16006_i0	PRJNA826497	16046	161	20.695312	33.31945232	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	230	5.7599999999999995e-56	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g16006	i0	92.547	1	161	10	99	2	1	160	132730	132889	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	161	230	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
7198798	7198798	PRJNA826497_S_NODE_4886_length_228_cov_7.328205_g4846_i0	PRJNA826497	4886	228	7.328205	16.7083074	Leptotrichia alba	3239304	Bacteria	Bacteria	60.2	1.21e-4	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g4846	i0	86.207	18.2368421052632	58	5	25	3	2	58	124885	124940	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	4158	60.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
21222642	21222642	PRJNA826497_S_NODE_14377_length_167_cov_5.432836_g14337_i0	PRJNA826497	14377	167	5.432836	9.07283612	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	224	2.81e-54	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g14337	i0	90.964	0.994011976047904	166	15	99	0	1	166	1043662	1043497	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	166	224	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
21222720	21222720	PRJNA826497_S_NODE_8257_length_198_cov_2.648485_g8217_i0	PRJNA826497	8257	198	2.648485	5.2440003	Fusobacterium polymorphum	76857	Bacteria	Bacteria	361	2.51e-95	NTclustered	gi\|2706424020\|gb\|CP077136.1\|	76857	g8217	i0	99.495	112.348484848485	198	1	100	0	1	198	1816359	1816556	Fusobacterium polymorphum strain KCOM3036 chromosome, complete genome	blastn	22245	361	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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