metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA399711" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA399711" 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
13834451	13834451	PRJNA399711_P_NODE_14531_length_176_cov_3.726619_g14465_i0	PRJNA399711	14531	176	3.726619	6.55884944	Fusobacterium	848	Bacteria	Bacteria	169	1.4099999999999998e-37	NTclustered	gi\|2706060613\|gb\|CP077190.1\|	76859	g14465	i0	100	80.0909090909091	91	0	94	0	1	91	1160511	1160601	Fusobacterium animalis strain SB026 chromosome, complete genome	blastn	14096	169	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
20814993	20814993	PRJNA399711_P_NODE_10377_length_194_cov_4.624204_g10311_i0	PRJNA399711	10377	194	4.624204	8.97095576	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	207	3.38e-49	NTclustered	gi\|1276716588\|gb\|CP024703.1\|	2663009	g10311	i0	88.636	74.860824742268	176	13	88	3	11	180	973037	972863	Fusobacterium pseudoperiodonticum strain KCOM 2305 chromosome, complete genome	blastn	14523	207	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
24032729	24032729	PRJNA399711_P_NODE_6859_length_219_cov_3.576923_g6793_i0	PRJNA399711	6859	219	3.576923	7.83346137	Fusobacterium	848	Bacteria	Bacteria	246	8.28e-61	NTclustered	gi\|2875932743\|gb\|PQ827193.1\|	68766	g6793	i0	100	95.4018264840183	133	0	95	0	1	133	96	228	Fusobacterium sp. strain Ab.287 TH 16S ribosomal RNA gene, partial sequence	blastn	20893	246	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
25563651	25563651	PRJNA399711_S_NODE_46609_length_204_cov_3.838323_g46467_i0	PRJNA399711	46609	204	3.838323	7.83017892	Leptotrichia wadei	157687	Bacteria	Bacteria	372	1.2e-98	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g46467	i0	99.51	6.67647058823529	204	1	100	0	1	204	1899838	1900041	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1362	372	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
25624469	25624469	PRJNA399711_S_NODE_101089_length_154_cov_4.290598_g100947_i0	PRJNA399711	101089	154	4.290598	6.60752092	Fusobacterium	848	Bacteria	Bacteria	219	1.1799999999999996e-52	NTclustered	gi\|2704993027\|gb\|CP077141.1\|	851	g100947	i0	92.208	25.7857142857143	154	12	100	0	1	154	15997	15844	Fusobacterium nucleatum strain KCOM2902 chromosome, complete genome	blastn	3971	219	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
25624477	25624477	PRJNA399711_S_NODE_102865_length_153_cov_4.767241_g102723_i0	PRJNA399711	102865	153	4.767241	7.29387873	Fusobacterium	848	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g102723	i0	99.351	463.006535947712	154	0	100	1	1	153	91665	91818	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	70840	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
25624758	25624758	PRJNA399711_S_NODE_73593_length_173_cov_2.536765_g73451_i0	PRJNA399711	73593	173	2.536765	4.38860345	Fusobacterium	848	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2704953188\|gb\|CP056010.1\|	76859	g73451	i0	100	0.971098265895954	28	0	16	0	128	155	1110169	1110142	Fusobacterium animalis strain SB012 chromosome, complete genome	blastn	168	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
25699381	25699381	PRJNA399711_S_NODE_36730_length_222_cov_5.351351_g36588_i0	PRJNA399711	36730	222	5.351351	11.87999922	Leptotrichia buccalis C-1	40542	Bacteria	Bacteria	401	1.6999999999999994e-107	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g36588	i0	99.545	0.990990990990991	220	1	99	0	2	221	1962844	1963063	Leptotrichia buccalis DSM 1135, complete genome	blastn	220	401	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
25699965	25699965	PRJNA399711_S_NODE_50802_length_198_cov_2.403727_g50660_i0	PRJNA399711	50802	198	2.403727	4.75937946	Leptotrichia wadei	157687	Bacteria	Bacteria	327	2.55e-85	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g50660	i0	96.465	13.9949494949495	198	7	100	0	1	198	259798	259995	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	2771	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
25701424	25701424	PRJNA399711_S_NODE_93058_length_159_cov_2.254098_g92916_i0	PRJNA399711	93058	159	2.254098	3.58401582	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	278	2e-70	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g92916	i0	98.113	32.4213836477987	159	3	100	0	1	159	1799207	1799365	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	5155	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
25835138	25835138	PRJNA399711_S_NODE_28819_length_242_cov_5.068293_g28677_i0	PRJNA399711	28819	242	5.068293	12.26526906	Sneathia sanguinegens	40543	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g28677	i0	98.76	4.07438016528926	242	3	100	0	1	242	1088661	1088902	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	986	431	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
25835227	25835227	PRJNA399711_S_NODE_30771_length_236_cov_35.065327_g30629_i0	PRJNA399711	30771	236	35.065327	82.75417172	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	398	2.36e-106	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g30629	i0	97.034	68.1906779661017	236	7	100	0	1	236	1724644	1724409	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	16093	398	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
25835453	25835453	PRJNA399711_S_NODE_35891_length_224_cov_2.978610_g35749_i0	PRJNA399711	35891	224	2.97861	6.6720864	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	394	2.87e-105	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g35749	i0	98.649	97.6294642857143	222	3	99	0	3	224	1282446	1282225	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	21869	394	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
25896666	25896666	PRJNA399711_S_NODE_45387_length_206_cov_3.857988_g45245_i0	PRJNA399711	45387	206	3.857988	7.94745528	Fusobacterium	848	Bacteria	Bacteria	329	7.43e-86	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g45245	i0	95.61	27.8640776699029	205	9	99	0	2	206	187857	187653	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	5740	329	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
25896721	25896721	PRJNA399711_S_NODE_57059_length_190_cov_1.019608_g56917_i0	PRJNA399711	57059	190	1.019608	1.9372552	Fusobacterium	848	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g56917	i0	100	98.6	190	0	100	0	1	190	989741	989552	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	18734	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
26107537	26107537	PRJNA399711_S_NODE_31757_length_234_cov_2.837563_g31615_i0	PRJNA399711	31757	234	2.837563	6.63989742	Fusobacterium animalis	76859	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2706483138\|gb\|CP084144.1\|	76859	g31615	i0	100	0.128205128205128	30	0	13	0	81	110	2159921	2159950	Fusobacterium animalis strain KCOM2952 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
26108915	26108915	PRJNA399711_S_NODE_66565_length_179_cov_5.563380_g66423_i0	PRJNA399711	66565	179	5.56338	9.9584502	Fusobacterium polymorphum	76857	Bacteria	Bacteria	191	3.08e-44	NTclustered	gi\|2706067283\|gb\|CP077110.1\|	76857	g66423	i0	90.411	6.75418994413408	146	12	81	2	3	147	649366	649510	Fusobacterium polymorphum strain KCOM1278 chromosome, complete genome	blastn	1209	191	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
26109594	26109594	PRJNA399711_S_NODE_86981_length_163_cov_1.920635_g86839_i0	PRJNA399711	86981	163	1.920635	3.13063505	Leptotrichia wadei	157687	Bacteria	Bacteria	217	4.5499999999999996e-52	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g86839	i0	94.366	1.04294478527607	142	7	87	1	1	141	2221890	2222031	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	170	217	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
26245355	26245355	PRJNA399711_S_NODE_73742_length_173_cov_2.058824_g73600_i0	PRJNA399711	73742	173	2.058824	3.56176552	Fusobacterium polymorphum	76857	Bacteria	Bacteria	285	1.32e-72	NTclustered	gi\|2706076557\|gb\|CP077115.1\|	76857	g73600	i0	98.75	138.543352601156	160	2	92	0	1	160	2026111	2025952	Fusobacterium polymorphum strain KCOM1271 chromosome, complete genome	blastn	23968	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
26245639	26245639	PRJNA399711_S_NODE_82390_length_166_cov_3.449612_g82248_i0	PRJNA399711	82390	166	3.449612	5.72635592	Fusobacterium polymorphum	76857	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g82248	i0	100	2.53012048192771	28	0	17	0	128	155	1834175	1834148	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	420	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
26304947	26304947	PRJNA399711_S_NODE_51326_length_197_cov_4.075000_g51184_i0	PRJNA399711	51326	197	4.075	8.02775	Fusobacterium	848	Bacteria	Bacteria	322	1.18e-83	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g51184	i0	100	88.3248730964467	174	0	88	0	1	174	1505704	1505531	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	17400	322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
26378263	26378263	PRJNA399711_S_NODE_104903_length_152_cov_3.660870_g104761_i0	PRJNA399711	104903	152	3.66087	5.5645224	Fusobacterium canifelinum	285729	Bacteria	Bacteria	276	6.770000000000001e-70	NTclustered	gi\|1948622963\|gb\|CP066022.1\|	285729	g104761	i0	100	97.7236842105263	149	0	98	0	4	152	1475676	1475528	Fusobacterium canifelinum strain FDAARGOS_999 chromosome, complete genome	blastn	14854	276	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium canifelinum
26378869	26378869	PRJNA399711_S_NODE_19295_length_279_cov_3.995868_g19153_i0	PRJNA399711	19295	279	3.995868	11.14847172	Fusobacterium animalis	76859	Bacteria	Bacteria	512	9.81e-141	NTclustered	gi\|2706469457\|gb\|CP084078.1\|	76859	g19153	i0	100	98.8136200716846	277	0	99	0	1	277	1662674	1662398	Fusobacterium animalis strain SB053 chromosome, complete genome	blastn	27569	512	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
26379840	26379840	PRJNA399711_S_NODE_39023_length_218_cov_1.254144_g38881_i0	PRJNA399711	39023	218	1.254144	2.73403392	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	396	7.729999999999997e-106	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g38881	i0	99.541	1	218	0	100	1	1	218	642732	642516	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	218	396	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
26380834	26380834	PRJNA399711_S_NODE_66311_length_179_cov_27.373239_g66169_i0	PRJNA399711	66311	179	27.373239	48.99809781	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	320	3.76e-83	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g66169	i0	98.883	93.5754189944134	179	2	100	0	1	179	2175953	2176131	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	16750	320	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
26380970	26380970	PRJNA399711_S_NODE_70247_length_176_cov_2.359712_g70105_i0	PRJNA399711	70247	176	2.359712	4.15309312	Leptotrichia sp. HSP-536	3239304	Bacteria	Bacteria	292	8.04e-75	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g70105	i0	96.591	1	176	6	100	0	1	176	256111	255936	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	176	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
26381833	26381833	PRJNA399711_S_NODE_96335_length_157_cov_2.558333_g96193_i0	PRJNA399711	96335	157	2.558333	4.01658281	Fusobacterium polymorphum	76857	Bacteria	Bacteria	241	2.5800000000000007e-59	NTclustered	gi\|2706056059\|gb\|CP077188.1\|	76857	g96193	i0	98.529	32.7133757961783	136	2	100	0	1	136	111331	111466	Fusobacterium polymorphum strain SB028 chromosome, complete genome	blastn	5136	241	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
26441083	26441083	PRJNA399711_S_NODE_43679_length_209_cov_3.837209_g43537_i0	PRJNA399711	43679	209	3.837209	8.01976681	Fusobacterium	848	Bacteria	Bacteria	374	3.4399999999999996e-99	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g43537	i0	99.038	97.3349282296651	208	2	99	0	2	209	1883684	1883477	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	20343	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
26515046	26515046	PRJNA399711_S_NODE_16824_length_292_cov_6.149020_g16682_i0	PRJNA399711	16824	292	6.14902	17.9551384	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	505	1.73e-138	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g16682	i0	97.938	99.5719178082192	291	6	99	0	1	291	2172612	2172902	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	29075	505	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
26518023	26518023	PRJNA399711_S_NODE_93920_length_158_cov_6.247934_g93778_i0	PRJNA399711	93920	158	6.247934	9.87173572	Fusobacterium periodonticum	860	Bacteria	Bacteria	84.2	4.63e-12	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g93778	i0	83	40.7025316455696	100	10	98	7	8	104	327773	327678	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	6431	84.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
26576722	26576722	PRJNA399711_S_NODE_102928_length_153_cov_4.396552_g102786_i0	PRJNA399711	102928	153	4.396552	6.72672456	Fusobacterium	848	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g102786	i0	99.346	99.5947712418301	153	1	100	0	1	153	1595818	1595970	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	15238	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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