metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA695273" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA695273" 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
679384	679384	PRJNA695273_P_NODE_98101_length_282_cov_1.172249_g97343_i0	PRJNA695273	98101	282	1.172249	3.30574218	Fusobacterium polymorphum	76857	Bacteria	Bacteria	516	7.67e-142	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g97343	i0	99.645	99.8617021276596	282	1	100	0	1	282	569555	569836	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	28161	516	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
1952843	1952843	PRJNA695273_P_NODE_129862_length_250_cov_0.870056_g129104_i0	PRJNA695273	129862	250	0.870056	2.17514	Sneathia sanguinegens	40543	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g129104	i0	98	1	250	5	100	0	1	250	1185324	1185075	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	250	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
3227184	3227184	PRJNA695273_P_NODE_102103_length_277_cov_1.764706_g101345_i0	PRJNA695273	102103	277	1.764706	4.88823562	Leptotrichia wadei	157687	Bacteria	Bacteria	422	1.69e-113	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g101345	i0	95.455	12.7617328519856	264	12	95	0	14	277	1596315	1596578	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	3535	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
3229107	3229107	PRJNA695273_P_NODE_40543_length_426_cov_1.759207_g39785_i0	PRJNA695273	40543	426	1.759207	7.49422182	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	761	0	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g39785	i0	99.287	482.821596244131	421	3	99	0	6	426	14325	13905	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	205682	761	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
3734126	3734126	PRJNA695273_P_NODE_161403_length_241_cov_0.863095_g160645_i0	PRJNA695273	161403	241	0.863095	2.08005895	Leptotrichia	32067	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|33860342\|gb\|AY349385.1\|	242674	g160645	i0	98.755	103.697095435685	241	3	100	0	1	241	279	39	Leptotrichia sp. oral clone GT020 16S ribosomal RNA gene, partial sequence	blastn	24991	429	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral clone GT020
4505681	4505681	PRJNA695273_P_NODE_160944_length_241_cov_0.916667_g160186_i0	PRJNA695273	160944	241	0.916667	2.20916747	uncultured Fusobacteriota bacterium	174329	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|401555839\|gb\|JX010890.1\|	174329	g160186	i0	98.34	100.016597510373	241	4	100	0	1	241	282	42	Uncultured Fusobacteria bacterium clone 9H3 16S ribosomal RNA gene, partial sequence	blastn	24104	424	1	Bacteria	Fusobacteriati	Fusobacteriota					uncultured Fusobacteriota bacterium
5010384	5010384	PRJNA695273_P_NODE_140564_length_247_cov_0.885057_g139806_i0	PRJNA695273	140564	247	0.885057	2.18609079	Fusobacterium	848	Bacteria	Bacteria	344	3.29e-90	NTclustered	gi\|2921414533\|gb\|CP159325.1\|	851	g139806	i0	91.87	99.497975708502	246	20	99	0	1	246	88162	88407	Fusobacterium nucleatum strain CTI-2 chromosome, complete genome	blastn	24576	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
5011005	5011005	PRJNA695273_P_NODE_3824_length_1586_cov_3.795770_g3387_i0	PRJNA695273	3824	1586	3.79577	60.2009122	Leptotrichia	32067	Bacteria	Bacteria	2699	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g3387	i0	97.357	455.353089533417	1589	39	100	3	1	1586	2257359	2255771	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	722190	2699	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
5781757	5781757	PRJNA695273_P_NODE_49605_length_386_cov_0.977636_g48847_i0	PRJNA695273	49605	386	0.977636	3.77367496	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	58.4	7.92e-4	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g48847	i0	100	0.0803108808290155	31	0	8	0	353	383	902590	902560	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	31	58.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
9605672	9605672	PRJNA695273_P_NODE_146068_length_245_cov_0.895349_g145310_i0	PRJNA695273	146068	245	0.895349	2.19360505	Leptotrichia alba	3239304	Bacteria	Bacteria	350	7e-92	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g145310	i0	93.469	1	245	1	100	1	1	245	1939529	1939758	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	245	350	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
12156354	12156354	PRJNA695273_P_NODE_143350_length_246_cov_0.890173_g142592_i0	PRJNA695273	143350	246	0.890173	2.18982558	Leptotrichia wadei	157687	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g142592	i0	99.593	16.0121951219512	246	1	100	0	1	246	395870	396115	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	3939	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
17255056	17255056	PRJNA695273_P_NODE_142834_length_246_cov_0.890173_g142076_i0	PRJNA695273	142834	246	0.890173	2.18982558	Leptotrichia wadei	157687	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g142076	i0	100	3	246	0	100	0	1	246	1945532	1945287	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	738	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19804839	19804839	PRJNA695273_P_NODE_34456_length_464_cov_1.061381_g33698_i0	PRJNA695273	34456	464	1.061381	4.92480784	Fusobacterium polymorphum	76857	Bacteria	Bacteria	846	0	NTclustered	gi\|2706433495\|gb\|CP077153.1\|	76857	g33698	i0	99.569	435.446120689655	464	2	100	0	1	464	1978967	1979430	Fusobacterium polymorphum strain KCOM1274 chromosome, complete genome	blastn	202047	846	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
20309066	20309066	PRJNA695273_P_NODE_35896_length_453_cov_2.918421_g35138_i0	PRJNA695273	35896	453	2.918421	13.22044713	Fusobacterium	848	Bacteria	Bacteria	832	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g35138	i0	99.779	476.366445916115	453	1	100	0	1	453	462638	462186	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	215794	837	0.994026284348865	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
22354122	22354122	PRJNA695273_P_NODE_125798_length_251_cov_0.865169_g125040_i0	PRJNA695273	125798	251	0.865169	2.17157419	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	431	2.4999999999999996e-116	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g125040	i0	97.619	12.0239043824701	252	4	100	2	1	251	685113	685363	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	3018	431	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
22354611	22354611	PRJNA695273_P_NODE_147078_length_245_cov_0.895349_g146320_i0	PRJNA695273	147078	245	0.895349	2.19360505	Leptotrichia shahii	157691	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g146320	i0	99.592	3	245	1	100	0	1	245	1713482	1713726	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	735	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
24902588	24902588	PRJNA695273_P_NODE_105460_length_273_cov_2.560000_g104702_i0	PRJNA695273	105460	273	2.56	6.9888	Leptotrichia hofstadii	157688	Bacteria	Bacteria	494	3.46e-135	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g104702	i0	99.267	142.531135531136	273	2	100	0	1	273	2374903	2374631	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	38911	494	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii

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