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

9 rows where analysis = "blastn", bioproject = "PRJNA977246" 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
2544447	2544447	PRJNA977246_S_NODE_18302_length_329_cov_7.956667_g17310_i0	PRJNA977246	18302	329	7.956667	26.17743443	Leptotrichia	32067	Bacteria	Bacteria	436	7.319999999999998e-118	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g17310	i0	92.763	302.73556231003	304	18	92	3	24	326	198191	198491	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	99600	436	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
3501483	3501483	PRJNA977246_S_NODE_15083_length_376_cov_9.054755_g14093_i0	PRJNA977246	15083	376	9.054755	34.0458788	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	592	1.71e-164	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g14093	i0	95.187	385.603723404255	374	18	99	0	1	374	51745	52118	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	144987	592	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
6054545	6054545	PRJNA977246_S_NODE_27405_length_243_cov_8825.630841_g26413_i0	PRJNA977246	27405	243	8825.630841	21446.28294363	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	357	4.1399999999999997e-94	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g26413	i0	100	68.2181069958848	193	0	79	0	1	193	51775	51583	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	16577	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
6055016	6055016	PRJNA977246_S_NODE_48585_length_157_cov_2.578125_g47593_i0	PRJNA977246	48585	157	2.578125	4.04765625	Leptotrichia buccalis	40542	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g47593	i0	100	15	157	0	100	0	1	157	824306	824462	Leptotrichia buccalis DSM 1135, complete genome	blastn	2355	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
11154495	11154495	PRJNA977246_S_NODE_18029_length_332_cov_6278.148515_g17037_i0	PRJNA977246	18029	332	6278.148515	20843.4530698	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	490	5.589999999999999e-134	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g17037	i0	98.214	194.951807228916	280	5	84	0	3	282	52118	51839	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	64724	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
13704554	13704554	PRJNA977246_S_NODE_16431_length_354_cov_4.169231_g15440_i0	PRJNA977246	16431	354	4.169231	14.75907774	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	616	9.469999999999999e-172	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g15440	i0	98.305	80.3022598870056	354	0	100	1	1	354	1446742	1446395	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	28427	616	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
20077565	20077565	PRJNA977246_S_NODE_18636_length_325_cov_4.226351_g17644_i0	PRJNA977246	18636	325	4.226351	13.73564075	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	595	1.1299999999999995e-165	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g17644	i0	99.692	11.8523076923077	325	1	100	0	1	325	1456907	1457231	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	3852	595	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
20077832	20077832	PRJNA977246_S_NODE_28456_length_236_cov_3.536232_g27464_i0	PRJNA977246	28456	236	3.536232	8.34550752	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	396	8.489999999999996e-106	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g27464	i0	98.655	11.3516949152542	223	3	94	0	14	236	1445830	1446052	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	2679	396	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
24220499	24220499	PRJNA977246_S_NODE_26099_length_253_cov_3.254464_g25107_i0	PRJNA977246	26099	253	3.254464	8.23379392	Fusobacterium	848	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g25107	i0	99.605	499.00790513834	253	1	100	0	1	253	2306314	2306566	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	126249	462	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);;