metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA312899" 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
380304	380304	PRJNA312899_P_NODE_85281_length_168_cov_1.663866_g84839_i0	PRJNA312899	85281	168	1.663866	2.79529488	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	270	3.5799999999999998e-68	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g84839	i0	95.808	0.994047619047619	167	7	99	0	1	167	530805	530639	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	167	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
2340393	2340393	PRJNA312899_P_NODE_92322_length_165_cov_0.879310_g91880_i0	PRJNA312899	92322	165	0.87931	1.4508615	Fusobacterium	848	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g91880	i0	100	99.9757575757576	165	0	100	0	1	165	82206	82042	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	16496	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
2930404	2930404	PRJNA312899_P_NODE_53783_length_235_cov_1.629032_g53341_i0	PRJNA312899	53783	235	1.629032	3.8282252	Leptotrichia hofstadii	157688	Bacteria	Bacteria	407	3.9e-109	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g53341	i0	97.881	2.00851063829787	236	4	100	1	1	235	2296214	2296449	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	472	407	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
2930807	2930807	PRJNA312899_P_NODE_77123_length_183_cov_1.522388_g76681_i0	PRJNA312899	77123	183	1.522388	2.78597004	Leptotrichia wadei	157687	Bacteria	Bacteria	305	1.08e-78	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g76681	i0	96.721	11.9016393442623	183	6	100	0	1	183	1010591	1010409	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	2178	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4892653	4892653	PRJNA312899_P_NODE_63504_length_209_cov_2.550000_g63062_i0	PRJNA312899	63504	209	2.55	5.3295	Fusobacterium	848	Bacteria	Bacteria	375	9.57e-100	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g63062	i0	99.048	13.8755980861244	210	0	99	1	2	209	666133	665924	Fusobacterium hwasookii ChDC F174, complete genome	blastn	2900	375	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
6167807	6167807	PRJNA312899_P_NODE_78465_length_181_cov_1.545455_g78023_i0	PRJNA312899	78465	181	1.545455	2.79727355	Fusobacterium	848	Bacteria	Bacteria	291	2.9899999999999993e-74	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g78023	i0	95.58	47.4972375690608	181	8	100	0	1	181	2192869	2193049	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	8597	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
6757571	6757571	PRJNA312899_P_NODE_61546_length_214_cov_1.854545_g61104_i0	PRJNA312899	61546	214	1.854545	3.9687263	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	370	4.58e-98	NTclustered	gi\|1276714546\|gb\|CP024702.1\|	2663009	g61104	i0	98.113	79.8504672897196	212	4	99	0	3	214	1435563	1435774	Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome	blastn	17088	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
6758164	6758164	PRJNA312899_P_NODE_96926_length_163_cov_0.894737_g96484_i0	PRJNA312899	96926	163	0.894737	1.45842131	Leptotrichia wadei	157687	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g96484	i0	98.773	15.2883435582822	163	2	100	0	1	163	289890	289728	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	2492	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
8032119	8032119	PRJNA312899_P_NODE_101347_length_161_cov_0.910714_g100905_i0	PRJNA312899	101347	161	0.910714	1.46624954	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g100905	i0	100	1	161	0	100	0	1	161	2898	2738	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	161	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9306933	9306933	PRJNA312899_P_NODE_103388_length_160_cov_4.396396_g102946_i0	PRJNA312899	103388	160	4.396396	7.0342336	Cetobacterium somerae	188913	Bacteria	Bacteria	267	4.35e-67	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g102946	i0	96.875	57.00625	160	4	100	1	1	160	420161	420319	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	9121	267	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9308205	9308205	PRJNA312899_P_NODE_78908_length_180_cov_2.335878_g78466_i0	PRJNA312899	78908	180	2.335878	4.2045804	Fusobacterium polymorphum	76857	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g78466	i0	100	98.5611111111111	180	0	100	0	1	180	879572	879751	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	17741	333	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9308277	9308277	PRJNA312899_P_NODE_83888_length_171_cov_1.672131_g83446_i0	PRJNA312899	83888	171	1.672131	2.85934401	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	311	2.14e-80	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g83446	i0	99.415	65.1695906432749	171	1	100	0	1	171	272796	272966	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	11144	311	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
9993114	9993114	PRJNA312899_P_NODE_74628_length_186_cov_2.087591_g74186_i0	PRJNA312899	74628	186	2.087591	3.88291926	Fusobacterium	848	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g74186	i0	100	245.860215053763	186	0	100	0	1	186	1867899	1867714	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	45730	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
10583042	10583042	PRJNA312899_P_NODE_19229_length_430_cov_31.732283_g18788_i0	PRJNA312899	19229	430	31.732283	136.4488169	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	778	0	NTclustered	gi\|1276720946\|gb\|CP024705.1\|	2663009	g18788	i0	99.532	15.9279069767442	427	2	99	0	1	427	1014385	1014811	Fusobacterium pseudoperiodonticum strain KCOM 2653 chromosome, complete genome	blastn	6849	778	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
11267507	11267507	PRJNA312899_P_NODE_12129_length_543_cov_16.052632_g11702_i0	PRJNA312899	12129	543	16.052632	87.16579176	Bacteria	2	Bacteria	Bacteria	610	7.02e-170	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g11702	i0	90.021	51.0349907918969	471	47	87	0	1	471	708314	707844	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	27712	610	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
11267567	11267567	PRJNA312899_P_NODE_19689_length_425_cov_2.029255_g19248_i0	PRJNA312899	19689	425	2.029255	8.62433375	Fusobacterium	848	Bacteria	Bacteria	747	0	NTclustered	gi\|515473282\|gb\|KF149938.1\|	1307442	g19248	i0	98.353	100.428235294118	425	7	100	0	1	425	619	1043	Fusobacterium hwasookii ChDC F174 DNA helicase (dnaB) gene, partial cds	blastn	42682	747	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
11857807	11857807	PRJNA312899_P_NODE_22130_length_399_cov_9.817143_g21688_i0	PRJNA312899	22130	399	9.817143	39.17040057	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	736	0	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g21688	i0	100	167.739348370927	398	0	99	0	1	398	197177	196780	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	66928	736	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
14407876	14407876	PRJNA312899_P_NODE_12372_length_537_cov_58.809426_g11943_i0	PRJNA312899	12372	537	58.809426	315.80661762	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	931	0	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g11943	i0	99.608	95.9106145251397	510	2	100	0	1	510	416023	415514	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	51504	931	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
15092376	15092376	PRJNA312899_P_NODE_47912_length_253_cov_2.289216_g47470_i0	PRJNA312899	47912	253	2.289216	5.79171648	Leptotrichia	32067	Bacteria	Bacteria	436	5.419999999999999e-118	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g47470	i0	98.008	345.486166007905	251	5	99	0	1	251	2373514	2373764	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	87408	440	0.990909090909091	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
15683161	15683161	PRJNA312899_P_NODE_98213_length_163_cov_0.877193_g97771_i0	PRJNA312899	98213	163	0.877193	1.42982459	Fusobacterium nucleatum	851	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2704981563\|gb\|CP077131.1\|	851	g97771	i0	100	99.0061349693252	163	0	100	0	1	163	2309062	2309224	Fusobacterium nucleatum strain KCOM3321 chromosome, complete genome	blastn	16138	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
18916577	18916577	PRJNA312899_P_NODE_93155_length_164_cov_4.513043_g92713_i0	PRJNA312899	93155	164	4.513043	7.40139052	Streptobacillus	34104	Bacteria	Bacteria	243	7.57e-60	NTclustered	gi\|1356701568\|gb\|CP027400.1\|	34105	g92713	i0	93.333	496.689024390244	165	9	100	2	1	164	409199	409362	Streptobacillus moniliformis strain FDAARGOS_310 chromosome, complete genome	blastn	81457	243	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
19506320	19506320	PRJNA312899_P_NODE_87776_length_167_cov_0.864407_g87334_i0	PRJNA312899	87776	167	0.864407	1.44355969	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g87334	i0	99.401	2	167	1	100	0	1	167	2329362	2329528	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	334	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
23332209	23332209	PRJNA312899_P_NODE_77059_length_183_cov_1.522388_g76617_i0	PRJNA312899	77059	183	1.522388	2.78597004	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	316	5.009999999999999e-82	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g76617	i0	97.814	6.79234972677596	183	4	100	0	1	183	754695	754513	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	1243	316	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
23332546	23332546	PRJNA312899_P_NODE_99639_length_162_cov_0.902655_g99197_i0	PRJNA312899	99639	162	0.902655	1.4623011	Fusobacterium polymorphum	76857	Bacteria	Bacteria	272	9.51e-69	NTclustered	gi\|2645888909\|gb\|CP141281.1\|	76857	g99197	i0	98.693	94.4444444444444	153	2	94	0	1	153	590398	590550	Fusobacterium polymorphum strain 40A2 chromosome, complete genome	blastn	15300	272	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
24606279	24606279	PRJNA312899_P_NODE_80440_length_178_cov_1.240310_g79998_i0	PRJNA312899	80440	178	1.24031	2.2077518	Fusobacterium nucleatum	851	Bacteria	Bacteria	313	6.259999999999999e-81	NTclustered	gi\|2705007409\|gb\|CP084122.1\|	851	g79998	i0	98.315	7.56179775280899	178	3	100	0	1	178	1873571	1873394	Fusobacterium nucleatum strain KCOM3412 chromosome, complete genome	blastn	1346	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum

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