metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA635397" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA635397" 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
8259189	8259189	PRJNA635397_P_NODE_44847_length_244_cov_1.134503_g44393_i0	PRJNA635397	44847	244	1.134503	2.76818732	Fusobacterium animalis	76859	Bacteria	Bacteria	377	3.1999999999999997e-100	NTclustered	gi\|2706410029\|gb\|CP077122.1\|	76859	g44393	i0	98.148	433.405737704918	216	4	89	0	1	216	582671	582886	Fusobacterium animalis strain KCOM3774 chromosome, complete genome	blastn	105751	377	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
10082181	10082181	PRJNA635397_P_NODE_19368_length_367_cov_3.081633_g18914_i0	PRJNA635397	19368	367	3.081633	11.30959311	Leptotrichia	32067	Bacteria	Bacteria	555	2.1799999999999994e-153	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g18914	i0	94.005	345.33242506812	367	21	100	1	1	367	2373835	2373470	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	126737	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
12632769	12632769	PRJNA635397_P_NODE_28730_length_297_cov_1.334821_g28276_i0	PRJNA635397	28730	297	1.334821	3.96441837	Fusobacterium	848	Bacteria	Bacteria	547	2.8899999999999992e-151	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g28276	i0	100	469.417508417508	296	0	99	0	1	296	106539	106834	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	139417	547	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13360145	13360145	PRJNA635397_P_NODE_44871_length_244_cov_0.912281_g44417_i0	PRJNA635397	44871	244	0.912281	2.22596564	Fusobacterium polymorphum	76857	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g44417	i0	100	99.827868852459	244	0	100	0	1	244	702185	701942	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	24358	451	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
19732629	19732629	PRJNA635397_P_NODE_44476_length_245_cov_0.895349_g44022_i0	PRJNA635397	44476	245	0.895349	2.19360505	Leptotrichia hofstadii	157688	Bacteria	Bacteria	418	1.8899999999999995e-112	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g44022	i0	97.541	14.7959183673469	244	6	99	0	1	244	1115156	1115399	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	3625	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
20280176	20280176	PRJNA635397_P_NODE_21436_length_347_cov_1.594891_g20982_i0	PRJNA635397	21436	347	1.594891	5.53427177	Fusobacterium	848	Bacteria	Bacteria	634	2.5599999999999996e-177	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g20982	i0	99.711	436.85590778098	346	1	99	0	1	346	20	365	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	151589	634	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
21007963	21007963	PRJNA635397_P_NODE_20937_length_352_cov_1.139785_g20483_i0	PRJNA635397	20937	352	1.139785	4.0120432	Leptotrichia trevisanii	109328	Bacteria	Bacteria	640	5.579999999999999e-179	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g20483	i0	99.432	474.849431818182	352	2	100	0	1	352	2726119	2726470	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	167147	640	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
23558137	23558137	PRJNA635397_P_NODE_18239_length_381_cov_1.610390_g17785_i0	PRJNA635397	18239	381	1.61039	6.1355859	Leptotrichia wadei	157687	Bacteria	Bacteria	676	0	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g17785	i0	98.691	142.354330708661	382	4	100	1	1	381	232737	232356	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	54237	676	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei

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