metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA429937" 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
1701165	1701165	PRJNA429937_P_NODE_24782_length_737_cov_5.285311_g14810_i0	PRJNA429937	24782	737	5.285311	38.95274207	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	754	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g14810	i0	97.517	2.76390773405699	443	8	60	3	10	452	135976	136415	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2037	754	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4915885	4915885	PRJNA429937_P_NODE_83144_length_355_cov_29.861963_g60656_i0	PRJNA429937	83144	355	29.861963	106.00996865	Fusobacterium	848	Bacteria	Bacteria	580	3.4599999999999993e-161	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g60656	i0	100	420.335211267606	314	0	88	0	20	333	106695	106382	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	149219	580	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
5531197	5531197	PRJNA429937_P_NODE_84385_length_352_cov_1.684211_g61880_i0	PRJNA429937	84385	352	1.684211	5.92842272	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	438	2.1899999999999993e-118	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g61880	i0	96.591	2.29261363636364	264	9	87	0	89	352	2104017	2103754	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	807	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
6190663	6190663	PRJNA429937_P_NODE_44905_length_533_cov_70.662698_g28858_i0	PRJNA429937	44905	533	70.662698	376.63218034	Leptotrichia	32067	Bacteria	Bacteria	412	2.0799999999999996e-110	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g28858	i0	96.761	237.621013133208	247	8	46	0	8	254	2454878	2454632	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	126652	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
6804392	6804392	PRJNA429937_P_NODE_40046_length_569_cov_8.531481_g25315_i0	PRJNA429937	40046	569	8.531481	48.54412689	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	623	9.479999999999998e-174	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g25315	i0	97.541	89.2636203866432	366	6	64	3	206	569	51737	52101	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	50791	623	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
8740447	8740447	PRJNA429937_P_NODE_49067_length_506_cov_18.228512_g31998_i0	PRJNA429937	49067	506	18.228512	92.23627072	Fusobacterium	848	Bacteria	Bacteria	924	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g31998	i0	99.605	481.098814229249	506	2	100	0	1	506	51	556	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	243436	924	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
9354501	9354501	PRJNA429937_P_NODE_27128_length_703_cov_3.605341_g16317_i0	PRJNA429937	27128	703	3.605341	25.34554723	Leptotrichia hofstadii	157688	Bacteria	Bacteria	601	5.559999999999999e-167	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g16317	i0	99.695	198.557610241821	328	1	67	0	200	527	577703	577376	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	139586	601	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
14454979	14454979	PRJNA429937_P_NODE_158192_length_152_cov_3.536585_g135565_i0	PRJNA429937	158192	152	3.536585	5.3756092	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g135565	i0	100	448.901315789474	152	0	100	0	1	152	201409	201258	Leptotrichia sp. SK-5 DNA, complete genome	blastn	68233	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
14455229	14455229	PRJNA429937_P_NODE_26172_length_716_cov_6.045124_g15688_i0	PRJNA429937	26172	716	6.045124	43.28308784	Leptotrichia wadei	157687	Bacteria	Bacteria	1262	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g15688	i0	99.566	14.5041899441341	692	3	97	0	23	714	2199909	2200600	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	10385	1262	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
15729042	15729042	PRJNA429937_P_NODE_27393_length_699_cov_6.501493_g16483_i0	PRJNA429937	27393	699	6.501493	45.44543607	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1151	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g16483	i0	97.341	3.3447782546495	677	18	97	0	1	677	2105178	2105854	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2338	1151	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15729906	15729906	PRJNA429937_P_NODE_69033_length_407_cov_1.902116_g47649_i0	PRJNA429937	69033	407	1.902116	7.74161212	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	424	7.19e-114	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g47649	i0	97.571	1.95331695331695	247	6	78	0	118	364	2102730	2102976	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	795	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
17003988	17003988	PRJNA429937_P_NODE_40894_length_563_cov_1.947566_g25917_i0	PRJNA429937	40894	563	1.947566	10.96479658	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	510	7.62e-140	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g25917	i0	88.471	46.8614564831261	425	26	96	5	71	473	2103198	2103621	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	26383	510	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
18278968	18278968	PRJNA429937_P_NODE_74695_length_384_cov_7.909859_g52650_i0	PRJNA429937	74695	384	7.909859	30.37385856	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	603	8.069999999999998e-168	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g52650	i0	99.399	408.450520833333	333	1	94	1	31	362	25648	25316	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	156845	603	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
19551898	19551898	PRJNA429937_P_NODE_150656_length_179_cov_5.193333_g128029_i0	PRJNA429937	150656	179	5.193333	9.29606607	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	324	2.91e-84	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g128029	i0	100	13.7597765363128	175	0	98	0	5	179	51590	51764	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2463	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19552667	19552667	PRJNA429937_P_NODE_44036_length_539_cov_21.549020_g28201_i0	PRJNA429937	44036	539	21.54902	116.1492178	Leptotrichia hofstadii	157688	Bacteria	Bacteria	769	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g28201	i0	95.287	491.792207792208	488	18	90	5	55	539	2374004	2374489	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	265076	769	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
20213985	20213985	PRJNA429937_P_NODE_84136_length_352_cov_7.523220_g61633_i0	PRJNA429937	84136	352	7.52322	26.4817344	Fusobacterium	848	Bacteria	Bacteria	634	2.5999999999999988e-177	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g61633	i0	99.148	427.142045454545	352	3	100	0	1	352	461963	461612	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	150354	634	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
20827764	20827764	PRJNA429937_P_NODE_158237_length_152_cov_3.024390_g135610_i0	PRJNA429937	158237	152	3.02439	4.5970728	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g135610	i0	100	448.901315789474	152	0	100	0	1	152	201258	201409	Leptotrichia sp. SK-5 DNA, complete genome	blastn	68233	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
24039286	24039286	PRJNA429937_P_NODE_28879_length_678_cov_299.246533_g17464_i0	PRJNA429937	28879	678	299.246533	2028.89149374	Leptotrichia	32067	Bacteria	Bacteria	774	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g17464	i0	91.652	191.097345132743	563	41	97	6	1	559	497748	498308	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	129564	780	0.992307692307692	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
24039612	24039612	PRJNA429937_P_NODE_96179_length_313_cov_44.176056_g73581_i0	PRJNA429937	96179	313	44.176056	138.27105528	Leptotrichia	32067	Bacteria	Bacteria	412	1.1699999999999996e-110	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g73581	i0	96.761	302.274760383387	247	8	98	0	7	253	2454878	2454632	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	94612	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
24653853	24653853	PRJNA429937_P_NODE_87880_length_340_cov_3.720257_g65315_i0	PRJNA429937	87880	340	3.720257	12.6488738	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	580	3.31e-161	NTclustered	gi\|1890961934\|gb\|CP060115.1\|	1583098	g65315	i0	99.685	93.1029411764706	317	1	93	0	24	340	911529	911213	Fusobacterium hwasookii strain KCOM 1253 chromosome, complete genome	blastn	31655	580	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii

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