metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA551951" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA551951" 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
1796203	1796203	PRJNA551951_S_NODE_2802_length_561_cov_98.539924_g2695_i0	PRJNA551951	2802	561	98.539924	552.80897364	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	813	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2695	i0	95.155	157.966131907308	516	23	92	2	45	559	51590	52104	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	88619	813	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
1796233	1796233	PRJNA551951_S_NODE_462_length_1300_cov_46.343083_g393_i1	PRJNA551951	462	1300	46.343083	602.460079	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	2390	0	NTclustered	gi\|1276714546\|gb\|CP024702.1\|	2663009	g393	i1	99.846	481.932307692308	1300	2	100	0	1	1300	1174914	1176213	Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome	blastn	626512	2390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
1796241	1796241	PRJNA551951_S_NODE_542_length_1199_cov_91.604811_g347_i3	PRJNA551951	542	1199	91.604811	1098.34168389	Leptotrichia hofstadii	157688	Bacteria	Bacteria	2135	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g347	i3	99.239	510.040867389491	1183	9	99	0	17	1199	2454048	2455230	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	611539	2135	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
2398451	2398451	PRJNA551951_S_NODE_6422_length_333_cov_2.966443_g6304_i0	PRJNA551951	6422	333	2.966443	9.87825519	Fusobacterium	848	Bacteria	Bacteria	575	1.5099999999999999e-159	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g6304	i0	99.682	793.771771771772	314	1	95	0	1	314	1812905	1812592	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	264326	575	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
3071620	3071620	PRJNA551951_S_NODE_903_length_965_cov_99.598925_g347_i6	PRJNA551951	903	965	99.598925	961.12962625	Leptotrichia hofstadii	157688	Bacteria	Bacteria	1676	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g347	i6	99.141	549.382383419689	931	8	96	0	1	931	2454300	2455230	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	530154	1676	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
4951136	4951136	PRJNA551951_S_NODE_544_length_1198_cov_85.032674_g347_i4	PRJNA551951	544	1198	85.032674	1018.69143452	Leptotrichia	32067	Bacteria	Bacteria	2037	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g347	i4	97.8	501.419031719533	1182	25	99	1	17	1198	2373354	2374534	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	600700	2050	0.993658536585366	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
4951154	4951154	PRJNA551951_S_NODE_604_length_1143_cov_47.148917_g393_i2	PRJNA551951	604	1143	47.148917	538.91212131	Fusobacterium	848	Bacteria	Bacteria	2010	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g393	i2	98.424	499.055118110236	1142	18	99	0	2	1143	463206	462065	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	570420	2021	0.994557149925779	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
5624461	5624461	PRJNA551951_S_NODE_545_length_1198_cov_82.841788_g347_i5	PRJNA551951	545	1198	82.841788	992.44462024	Leptotrichia hofstadii	157688	Bacteria	Bacteria	2023	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g347	i5	97.549	500.465776293823	1183	28	99	1	17	1198	2454048	2455230	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	599558	2023	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
8173366	8173366	PRJNA551951_S_NODE_3927_length_459_cov_8.556604_g3812_i0	PRJNA551951	3927	459	8.556604	39.27481236	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	616	1.2599999999999999e-171	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g3812	i0	90.85	1	459	42	100	0	1	459	2147851	2147393	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	459	616	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9448961	9448961	PRJNA551951_S_NODE_17428_length_152_cov_2.880342_g17310_i0	PRJNA551951	17428	152	2.880342	4.37811984	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	276	6.770000000000001e-70	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g17310	i0	100	289.888157894737	149	0	98	0	2	150	25404	25256	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	44063	276	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
9449083	9449083	PRJNA551951_S_NODE_9148_length_254_cov_4.401826_g9030_i0	PRJNA551951	9148	254	4.401826	11.18063804	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	387	5.569999999999998e-103	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g9030	i0	98.624	48.6141732283465	218	3	86	0	37	254	592622	592839	Leptotrichia sp. oral taxon 498, complete genome	blastn	12348	387	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
10051373	10051373	PRJNA551951_S_NODE_368_length_1416_cov_69.971760_g347_i0	PRJNA551951	368	1416	69.97176	990.8001216	Leptotrichia	32067	Bacteria	Bacteria	2455	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g347	i0	98.423	464.872881355932	1395	22	99	0	1	1395	499062	497668	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	658260	2455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
13274629	13274629	PRJNA551951_S_NODE_411_length_1358_cov_74.167800_g347_i1	PRJNA551951	411	1358	74.1678	1007.198724	Leptotrichia hofstadii	157688	Bacteria	Bacteria	2231	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g347	i1	96.332	545.260677466863	1363	41	100	7	1	1358	2455230	2453872	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	740464	2231	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
14549580	14549580	PRJNA551951_S_NODE_16232_length_160_cov_2.208000_g16114_i0	PRJNA551951	16232	160	2.208	3.5328	Fusobacterium polymorphum	76857	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g16114	i0	100	99.94375	160	0	100	0	1	160	2276153	2276312	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	15991	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
15150948	15150948	PRJNA551951_S_NODE_14192_length_178_cov_2.097902_g14074_i0	PRJNA551951	14192	178	2.097902	3.73426556	Fusobacterium	848	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g14074	i0	100	22.2191011235955	178	0	100	0	1	178	1633914	1634091	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	3955	329	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
16425587	16425587	PRJNA551951_S_NODE_14533_length_174_cov_97.791367_g14415_i0	PRJNA551951	14533	174	97.791367	170.15697858	root	1	Root_unresolved	Root_unresolved	322	1.01e-83	NTclustered	gi\|531874300\|gb\|KF444264.1\|	851	g14415	i0	100	115	174	0	100	0	1	174	858	1031	Fusobacterium nucleatum strain YWH7413 16S ribosomal RNA gene, partial sequence	blastn	20010	322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
17098159	17098159	PRJNA551951_S_NODE_2394_length_616_cov_3.839931_g2297_i0	PRJNA551951	2394	616	3.839931	23.65397496	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1083	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2297	i0	98.377	1	616	10	100	0	1	616	2148037	2148652	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	616	1083	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
18372420	18372420	PRJNA551951_S_NODE_9075_length_256_cov_10.904977_g8957_i0	PRJNA551951	9075	256	10.904977	27.91674112	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	339	1.5999999999999998e-88	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g8957	i0	94.17	0.87109375	223	11	87	2	28	250	2146980	2147200	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	223	339	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
20249366	20249366	PRJNA551951_S_NODE_13636_length_183_cov_16.641892_g13518_i0	PRJNA551951	13636	183	16.641892	30.45466236	root	1	Root_unresolved	Root_unresolved	300	5.040000000000001e-77	NTclustered	gi\|285797932\|gb\|GU407914.1\|	851	g13518	i0	100	95.672131147541	162	0	89	0	22	183	330	491	Fusobacterium nucleatum clone WWP_SS7_C07 16S ribosomal RNA gene, partial sequence	blastn	17508	302	0.993377483443709	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20249492	20249492	PRJNA551951_S_NODE_416_length_1352_cov_46.958238_g393_i0	PRJNA551951	416	1352	46.958238	634.87537776	Fusobacterium	848	Bacteria	Bacteria	2416	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g393	i0	99.548	470.744082840237	1326	6	98	0	1	1326	463047	461722	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	636446	2438	0.990976210008203	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
22800194	22800194	PRJNA551951_S_NODE_4558_length_419_cov_9.596354_g4443_i0	PRJNA551951	4558	419	9.596354	40.20872326	Fusobacterium	848	Bacteria	Bacteria	704	0	NTclustered	gi\|2706424020\|gb\|CP077136.1\|	76857	g4443	i0	99.74	91.1217183770883	384	1	92	0	8	391	182929	182546	Fusobacterium polymorphum strain KCOM3036 chromosome, complete genome	blastn	38180	704	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
23473072	23473072	PRJNA551951_S_NODE_539_length_1203_cov_83.099315_g347_i2	PRJNA551951	539	1203	83.099315	999.68475945	Leptotrichia hofstadii	157688	Bacteria	Bacteria	1823	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g347	i2	94.44	524.097256857855	1187	62	99	3	17	1203	2454048	2455230	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	630489	1823	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
23473104	23473104	PRJNA551951_S_NODE_7559_length_294_cov_9.312741_g7441_i0	PRJNA551951	7559	294	9.312741	27.37945854	Fusobacterium polymorphum	76857	Bacteria	Bacteria	544	3.69e-150	NTclustered	gi\|2706424020\|gb\|CP077136.1\|	76857	g7441	i0	100	247.125850340136	294	0	100	0	1	294	563020	563313	Fusobacterium polymorphum strain KCOM3036 chromosome, complete genome	blastn	72655	544	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
24746746	24746746	PRJNA551951_S_NODE_13780_length_182_cov_1.931973_g13662_i0	PRJNA551951	13780	182	1.931973	3.51619086	Fusobacterium polymorphum	76857	Bacteria	Bacteria	331	1.7800000000000002e-86	NTclustered	gi\|2706074160\|gb\|CP077112.1\|	76857	g13662	i0	99.451	100	182	1	100	0	1	182	2178766	2178947	Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome	blastn	18200	331	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);;