metadata: contig_metadata: 11 rows where bioproject = "PRJNA682078" and tax

11 rows where bioproject = "PRJNA682078" 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
661014	661014	PRJNA682078_P_NODE_241121_length_248_cov_1.320000_g239344_i0	PRJNA682078	241121	248	1.32	3.2736	Leptotrichia sp. oral taxon 218	712361	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2028887161\|gb\|CP072377.1\|	712361	g239344	i0	99.194	3	248	2	100	0	1	248	224947	224700	Leptotrichia sp. oral taxon 218 strain F0707 chromosome, complete genome	blastn	744	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 218
662377	662377	PRJNA682078_P_NODE_293901_length_238_cov_2.606061_g292124_i0	PRJNA682078	293901	238	2.606061	6.20242518	Fusobacterium polymorphum	76857	Bacteria	Bacteria	424	3.93e-114	NTclustered	gi\|2706506546\|gb\|CP084156.1\|	76857	g292124	i0	98.739	99.9411764705882	238	3	100	0	1	238	244367	244130	Fusobacterium polymorphum strain KCOM2510 chromosome	blastn	23786	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
2446944	2446944	PRJNA682078_P_NODE_116062_length_330_cov_1.198444_g114285_i0	PRJNA682078	116062	330	1.198444	3.9548652	Fusobacterium	848	Bacteria	Bacteria	599	8.849999999999995e-167	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g114285	i0	99.394	479.545454545455	330	2	100	0	1	330	463065	462736	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	158250	604	0.991721854304636	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
9589292	9589292	PRJNA682078_P_NODE_228448_length_250_cov_1.096045_g226671_i0	PRJNA682078	228448	250	1.096045	2.7401125	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g226671	i0	97.2	1	250	7	100	0	1	250	2168733	2168484	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	250	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
10865557	10865557	PRJNA682078_P_NODE_260129_length_245_cov_1.790698_g258352_i0	PRJNA682078	260129	245	1.790698	4.3872101	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g258352	i0	99.184	461.175510204082	245	2	100	0	1	245	199525	199281	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	112988	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
15202141	15202141	PRJNA682078_P_NODE_287572_length_241_cov_1.410714_g285795_i0	PRJNA682078	287572	241	1.410714	3.39982074	Leptotrichia	32067	Bacteria	Bacteria	396	8.7e-106	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g285795	i0	97.425	499.95020746888	233	5	96	1	10	241	660	892	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	120488	396	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
19787892	19787892	PRJNA682078_P_NODE_236516_length_249_cov_0.875000_g234739_i0	PRJNA682078	236516	249	0.875	2.17875	Leptotrichia buccalis	40542	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g234739	i0	99.197	15.9116465863454	249	2	100	0	1	249	1944715	1944467	Leptotrichia buccalis DSM 1135, complete genome	blastn	3962	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
22339089	22339089	PRJNA682078_P_NODE_269998_length_244_cov_0.900585_g268221_i0	PRJNA682078	269998	244	0.900585	2.1974274	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|1276707709\|gb\|CP024699.1\|	2663009	g268221	i0	96.721	99.6680327868852	244	8	100	0	1	244	1860089	1859846	Fusobacterium pseudoperiodonticum strain KCOM 1261 chromosome, complete genome	blastn	24319	407	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
23612081	23612081	PRJNA682078_P_NODE_165279_length_283_cov_5.242857_g163502_i0	PRJNA682078	165279	283	5.242857	14.83728531	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g163502	i0	94.118	0.120141342756184	34	2	12	0	229	262	1247371	1247404	Leptotrichia sp. SK-5 DNA, complete genome	blastn	34	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
26733520	26733520	PRJNA682078_P_NODE_264221_length_245_cov_0.895349_g262444_i0	PRJNA682078	264221	245	0.895349	2.19360505	Leptotrichia wadei	157687	Bacteria	Bacteria	110	2.06e-26	NR	BBM41780.1	157687	g262444	i0	61.7	6.94285714285714	81	31	99.2	0	244	2	14	94	BBM41780.1 hypothetical protein JCM16777_0003 [Leptotrichia wadei]	diamond	1701	110	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
28535025	28535025	PRJNA682078_P_NODE_248347_length_247_cov_0.885057_g246570_i0	PRJNA682078	248347	247	0.885057	2.18609079	Fusobacteriota bacterium	2060921	Bacteria	Bacteria	79	4.73e-15	NR	HCB64138.1	2060921	g246570	i0	45.5	0.935222672064777	77	42	93.5	0	3	233	292	368	HCB64138.1 hypothetical protein [Fusobacteriota bacterium]	diamond	231	79	1	Bacteria	Fusobacteriati	Fusobacteriota					Fusobacteriota bacterium

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