metadata: contig_metadata: 13 rows where bioproject = "PRJNA663960" and tax

13 rows where bioproject = "PRJNA663960" 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
3179543	3179543	PRJNA663960_S_NODE_2303_length_526_cov_3.206681_g2081_i0	PRJNA663960	2303	526	3.206681	16.86714206	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	881	0	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g2081	i0	97.126	432.214828897338	522	15	99	0	5	526	197258	196737	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	227345	881	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
3179773	3179773	PRJNA663960_S_NODE_56943_length_162_cov_1.330435_g56707_i0	PRJNA663960	56943	162	1.330435	2.1553047	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g56707	i0	99.383	97.2654320987654	162	1	100	0	1	162	2460479	2460640	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	15757	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
4990463	4990463	PRJNA663960_S_NODE_7444_length_364_cov_2.570978_g7208_i0	PRJNA663960	7444	364	2.570978	9.35835992	Fusobacterium	848	Bacteria	Bacteria	667	0	NTclustered	gi\|958157244\|gb\|CP013336.1\|	1307443	g7208	i0	99.725	100.06043956044	364	1	100	0	1	364	410062	409699	Fusobacterium hwasookii ChDC F206, complete genome	blastn	36422	667	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
7539951	7539951	PRJNA663960_S_NODE_23106_length_250_cov_1.507389_g22870_i0	PRJNA663960	23106	250	1.507389	3.7684725	Fusobacterium	848	Bacteria	Bacteria	250	7.48e-62	NTclustered	gi\|1721134154\|emb\|LR698955.1\|	851	g22870	i0	88.208	81.992	212	22	85	1	39	250	1475356	1475564	Fusobacterium nucleatum isolate MGYG-HGUT-01347 genome assembly, chromosome: 1	blastn	20498	250	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
9557059	9557059	PRJNA663960_S_NODE_12168_length_315_cov_3.272388_g11932_i0	PRJNA663960	12168	315	3.272388	10.3080222	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	582	8.459999999999998e-162	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g11932	i0	100	112.888888888889	315	0	100	0	1	315	397490	397176	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	35560	582	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
9557404	9557404	PRJNA663960_S_NODE_62708_length_157_cov_1.263636_g62472_i0	PRJNA663960	62708	157	1.263636	1.98390852	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g62472	i0	100	99.9808917197452	157	0	100	0	1	157	1395728	1395884	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	15697	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
12108075	12108075	PRJNA663960_S_NODE_34730_length_206_cov_2.245283_g34494_i0	PRJNA663960	34730	206	2.245283	4.62528298	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g34494	i0	100	338.203883495146	206	0	100	0	1	206	308849	308644	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	69670	381	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
13382983	13382983	PRJNA663960_S_NODE_751_length_772_cov_10.071724_g610_i0	PRJNA663960	751	772	10.071724	77.75370928	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1214	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g610	i0	95.762	489.380829015544	755	28	97	3	21	772	51583	52336	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	377802	1214	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14657495	14657495	PRJNA663960_S_NODE_12032_length_316_cov_3.743494_g11796_i0	PRJNA663960	12032	316	3.743494	11.82944104	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	571	1.84e-158	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g11796	i0	99.365	99.8227848101266	315	2	99	0	1	315	1560534	1560220	Fusobacterium hwasookii ChDC F174, complete genome	blastn	31544	571	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
19013698	19013698	PRJNA663960_S_NODE_4315_length_432_cov_5.994805_g4080_i0	PRJNA663960	4315	432	5.994805	25.8975576	Fusobacterium	848	Bacteria	Bacteria	793	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g4080	i0	99.769	471.00462962963	432	1	100	0	1	432	1234	803	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	203474	793	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20288500	20288500	PRJNA663960_S_NODE_59016_length_160_cov_1.805310_g58780_i0	PRJNA663960	59016	160	1.80531	2.888496	Fusobacterium	848	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g58780	i0	100	100.13125	160	0	100	0	1	160	240998	240839	Fusobacterium hwasookii ChDC F174, complete genome	blastn	16021	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
24114119	24114119	PRJNA663960_S_NODE_9079_length_343_cov_4.260135_g8843_i0	PRJNA663960	9079	343	4.260135	14.61226305	Fusobacterium	848	Bacteria	Bacteria	634	2.5299999999999996e-177	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g8843	i0	100	476.422740524781	343	0	100	0	1	343	963606	963948	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	163413	634	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
28881427	28881427	PRJNA663960_S_NODE_17148_length_281_cov_3.833333_g16912_i0	PRJNA663960	17148	281	3.833333	10.77166573	Fusobacterium necrophorum	859	Bacteria	Bacteria	54.3	3.75e-7	NR	WP_187114587.1	859	g16912	i0	60.3	0.672597864768683	63	24	67.3	1	193	5	9	70	WP_187114587.1 hypothetical protein, partial [Fusobacterium necrophorum]	diamond	189	54.3	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum

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