metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJEB66218" and tax

13 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
1405622	1405622	PRJEB66218_P_NODE_135582_length_255_cov_5.407216_g133153_i0	PRJEB66218	135582	255	5.407216	13.7884008	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	444	3.27e-120	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g133153	i0	98.039	18.8941176470588	255	5	100	0	1	255	52056	51802	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	4818	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
2269923	2269923	PRJEB66218_P_NODE_249862_length_175_cov_4.719298_g247430_i0	PRJEB66218	249862	175	4.719298	8.2587715	Leptotrichia	32067	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g247430	i0	100	459.371428571429	175	0	100	0	1	175	577936	578110	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	80390	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
3959057	3959057	PRJEB66218_P_NODE_249584_length_178_cov_4.128205_g247152_i0	PRJEB66218	249584	178	4.128205	7.3482049	Pseudostreptobacillus hongkongensis	1162717	Bacteria	Bacteria	313	6.259999999999999e-81	NTclustered	gi\|601094156\|gb\|JQ087390.2\|	1162717	g247152	i0	99.419	109.494382022472	172	1	97	0	7	178	1390	1219	Pseudostreptobacillus hongkongensis strain HKU34 16S ribosomal RNA gene, complete sequence	blastn	19490	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudostreptobacillus	Pseudostreptobacillus hongkongensis
5234562	5234562	PRJEB66218_P_NODE_186445_length_217_cov_1.512821_g184015_i0	PRJEB66218	186445	217	1.512821	3.28282157	Leptotrichia wadei	157687	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g184015	i0	100	79.9861751152074	217	0	100	0	1	217	220551	220335	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	17357	401	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
7783024	7783024	PRJEB66218_P_NODE_115187_length_281_cov_4.154545_g112758_i0	PRJEB66218	115187	281	4.154545	11.67427145	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	484	2.1599999999999996e-132	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g112758	i0	97.857	332.886120996441	280	6	99	0	1	280	54217	54496	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	93541	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
10334515	10334515	PRJEB66218_P_NODE_154129_length_238_cov_2.203390_g151700_i0	PRJEB66218	154129	238	2.20339	5.2440682	Leptotrichia buccalis	40542	Bacteria	Bacteria	424	3.93e-114	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g151700	i0	98.739	2.89075630252101	238	3	100	0	1	238	518784	518547	Leptotrichia buccalis DSM 1135, complete genome	blastn	688	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
10335957	10335957	PRJEB66218_P_NODE_247429_length_191_cov_2.130769_g244997_i0	PRJEB66218	247429	191	2.130769	4.06976879	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	337	4.05e-88	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g244997	i0	98.429	207.089005235602	191	3	100	0	1	191	196947	196757	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	39554	337	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
12473337	12473337	PRJEB66218_P_NODE_169510_length_228_cov_0.832335_g167080_i0	PRJEB66218	169510	228	0.832335	1.8977238	Leptotrichia	32067	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|631253196\|ref\|NR_114394.1\|	40542	g167080	i0	100	103.776315789474	228	0	100	0	1	228	254	27	Leptotrichia buccalis strain C-1013-b 16S ribosomal RNA, partial sequence	blastn	23661	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
17572573	17572573	PRJEB66218_P_NODE_22714_length_807_cov_2.457105_g20563_i0	PRJEB66218	22714	807	2.457105	19.82883735	Leptotrichia	32067	Bacteria	Bacteria	1389	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g20563	i0	97.772	450.729863692689	808	15	100	3	1	807	2373133	2373938	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	363739	1389	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
18846355	18846355	PRJEB66218_P_NODE_232655_length_204_cov_0.881119_g230225_i0	PRJEB66218	232655	204	0.881119	1.79748276	Fusobacterium	848	Bacteria	Bacteria	366	5.599999999999998e-97	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g230225	i0	99.02	100.529411764706	204	2	100	0	1	204	1909424	1909221	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	20508	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
20121749	20121749	PRJEB66218_P_NODE_95036_length_316_cov_2.345098_g92608_i0	PRJEB66218	95036	316	2.345098	7.41050968	Cetobacterium	180162	Bacteria	Bacteria	584	2.359999999999999e-162	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g92608	i0	100	493.208860759494	316	0	100	0	1	316	279399	279084	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	155854	584	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20533901	20533901	PRJEB66218_P_NODE_249457_length_179_cov_4.813559_g247025_i0	PRJEB66218	249457	179	4.813559	8.61627061	uncultured Leptotrichia sp.	159271	Bacteria	Bacteria	329	6.26e-86	NTclustered	gi\|571048574\|gb\|KF422121.1\|	159271	g247025	i0	100	52.731843575419	178	0	99	0	2	179	235	58	Uncultured Leptotrichia sp. clone VostokV6_rep_c139 genomic sequence	blastn	9439	329	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	uncultured Leptotrichia sp.
21397169	21397169	PRJEB66218_P_NODE_67437_length_394_cov_1.660661_g65013_i0	PRJEB66218	67437	394	1.660661	6.54300434	Leptotrichia	32067	Bacteria	Bacteria	649	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g65013	i0	96.456	362.01269035533	395	10	100	4	1	394	2257110	2256719	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	142633	649	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);;