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

9 rows where analysis = "blastn", bioproject = "PRJEB75230" 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
3962198	3962198	PRJEB75230_P_NODE_126504_length_250_cov_0.870056_g126322_i0	PRJEB75230	126504	250	0.870056	2.17514	Fusobacterium ulcerans	861	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1370545701\|gb\|CP028105.1\|	861	g126322	i0	100	0.224	28	0	11	0	79	106	2943830	2943803	Fusobacterium ulcerans strain ATCC 49185 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
9063496	9063496	PRJEB75230_P_NODE_138908_length_248_cov_0.880000_g138726_i0	PRJEB75230	138908	248	0.88	2.1824	Sneathia sanguinegens	40543	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g138726	i0	99.597	446.866935483871	248	1	100	0	1	248	72423	72670	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	110823	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
11199407	11199407	PRJEB75230_P_NODE_5669_length_584_cov_2.021526_g5488_i0	PRJEB75230	5669	584	2.021526	11.80571184	Fusobacterium	848	Bacteria	Bacteria	1062	0	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g5488	i0	99.486	481.244863013699	584	3	100	0	1	584	106310	106893	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	281047	1062	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
12474981	12474981	PRJEB75230_P_NODE_28790_length_352_cov_2.007168_g28608_i0	PRJEB75230	28790	352	2.007168	7.06523136	Fusobacterium	848	Bacteria	Bacteria	651	0	NTclustered	gi\|1721134154\|emb\|LR698955.1\|	851	g28608	i0	100	490.164772727273	352	0	100	0	1	352	84652	84301	Fusobacterium nucleatum isolate MGYG-HGUT-01347 genome assembly, chromosome: 1	blastn	172538	651	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
18847510	18847510	PRJEB75230_P_NODE_129875_length_249_cov_1.102273_g129693_i0	PRJEB75230	129875	249	1.102273	2.74465977	root	1	Root_unresolved	Root_unresolved	52.8	0.023	NTclustered	gi\|2704944210\|gb\|CP077182.1\|	851	g129693	i0	100	0.78714859437751	28	0	11	0	141	168	720536	720509	Fusobacterium nucleatum strain SB032 chromosome, complete genome	blastn	196	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19262252	19262252	PRJEB75230_P_NODE_176196_length_242_cov_0.911243_g176014_i0	PRJEB75230	176196	242	0.911243	2.20520806	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1276712381\|gb\|CP024701.1\|	2663009	g176014	i0	99.587	99.7148760330578	242	1	100	0	1	242	1632865	1632624	Fusobacterium pseudoperiodonticum strain KCOM 1277 chromosome, complete genome	blastn	24131	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
20122774	20122774	PRJEB75230_P_NODE_81156_length_279_cov_1.121359_g80974_i0	PRJEB75230	81156	279	1.121359	3.12859161	Fusobacterium	848	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g80974	i0	100	0.824372759856631	29	0	10	0	187	215	1801890	1801918	Fusobacterium hwasookii ChDC F174, complete genome	blastn	230	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
20538789	20538789	PRJEB75230_P_NODE_84177_length_276_cov_1.418719_g83995_i0	PRJEB75230	84177	276	1.418719	3.91566444	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g83995	i0	100	384.039855072464	276	0	100	0	1	276	70587	70862	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	105995	510	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
25221921	25221921	PRJEB75230_P_NODE_123000_length_250_cov_1.395480_g122818_i0	PRJEB75230	123000	250	1.39548	3.4887	Leptotrichia	32067	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g122818	i0	98.008	485.52	251	3	100	2	1	250	1694903	1695152	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	121380	435	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);;