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

24 rows where analysis = "blastn", bioproject = "PRJNA168635" 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
2329459	2329459	PRJNA168635_P_NODE_15642_length_202_cov_11.026144_g15226_i0	PRJNA168635	15642	202	11.026144	22.27281088	Fusobacterium	848	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g15226	i0	100	479.534653465347	202	0	100	0	1	202	1633	1834	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	96866	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
2915013	2915013	PRJNA168635_P_NODE_14783_length_209_cov_3.681250_g14367_i0	PRJNA168635	14783	209	3.68125	7.6938125	Haliovirga abyssi	2996794	Bacteria	Bacteria	226	1.0199999999999997e-54	NTclustered	gi\|2502752323\|dbj\|AP027059.1\|	2996794	g14367	i0	86.538	472.215311004785	208	24	100	4	4	209	255660	255455	Fusobacteria bacterium IC12 DNA, complete genome	blastn	98693	226	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Haliovirgaceae	Haliovirga	Haliovirga abyssi
4191431	4191431	PRJNA168635_P_NODE_13844_length_217_cov_3.184524_g13428_i0	PRJNA168635	13844	217	3.184524	6.91041708	Leptotrichia wadei	157687	Bacteria	Bacteria	359	1.01e-94	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g13428	i0	96.744	480.617511520737	215	7	99	0	1	215	1757287	1757501	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	104294	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4191809	4191809	PRJNA168635_P_NODE_5804_length_351_cov_4.582781_g5398_i0	PRJNA168635	5804	351	4.582781	16.08556131	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	555	2.0699999999999998e-153	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g5398	i0	95.415	395.680911680912	349	15	99	1	1	348	52811	53159	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	138884	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4191867	4191867	PRJNA168635_P_NODE_8684_length_285_cov_13.262712_g8269_i0	PRJNA168635	8684	285	13.262712	37.7987292	Fusobacterium polymorphum	76857	Bacteria	Bacteria	257	5.2e-64	NTclustered	gi\|958164477\|gb\|CP013328.1\|	76857	g8269	i0	83.942	258.108771929825	274	39	95	4	2	272	162903	163174	Fusobacterium nucleatum subsp. polymorphum strain ChDC F319 genome	blastn	73561	257	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
6741994	6741994	PRJNA168635_P_NODE_11266_length_244_cov_3.082051_g10851_i0	PRJNA168635	11266	244	3.082051	7.52020444	Fusobacteria bacterium ZRK30	2970471	Bacteria	Bacteria	117	7.6900000000000005e-22	NTclustered	gi\|2284594148\|gb\|CP102404.1\|	2970471	g10851	i0	92.683	69.9262295081967	82	5	33	1	159	239	205381	205300	Fusobacteria bacterium ZRK30 chromosome 1, complete sequence	blastn	17062	117	1	Bacteria	Fusobacteriati	Fusobacteriota					Fusobacteria bacterium ZRK30
6742145	6742145	PRJNA168635_P_NODE_1986_length_574_cov_6.977143_g1620_i0	PRJNA168635	1986	574	6.977143	40.04880082	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	1055	0	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g1620	i0	99.826	480.709059233449	574	1	100	0	1	574	14531	13958	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	275927	1055	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
6742205	6742205	PRJNA168635_P_NODE_24426_length_170_cov_3.363636_g24010_i0	PRJNA168635	24426	170	3.363636	5.7181812	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	206	1.03e-48	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g24010	i0	88.757	4.97058823529412	169	17	99	2	2	169	52004	51837	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	845	206	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
7432087	7432087	PRJNA168635_P_NODE_15166_length_206_cov_3.949045_g14750_i0	PRJNA168635	15166	206	3.949045	8.1350327	Bacteria	2	Bacteria	Bacteria	171	4.76e-38	NTclustered	gi\|2921414533\|gb\|CP159325.1\|	851	g14750	i0	82.212	314.165048543689	208	28	99	8	1	205	2235344	2235545	Fusobacterium nucleatum strain CTI-2 chromosome, complete genome	blastn	64718	171	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7432176	7432176	PRJNA168635_P_NODE_23666_length_172_cov_1.934959_g23250_i0	PRJNA168635	23666	172	1.934959	3.32812948	Fusobacterium	848	Bacteria	Bacteria	315	1.6699999999999996e-81	NTclustered	gi\|2706069597\|gb\|CP077108.1\|	76857	g23250	i0	100	428.901162790698	170	0	99	0	1	170	1185213	1185044	Fusobacterium polymorphum strain KCOM1281 chromosome, complete genome	blastn	73771	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
8017876	8017876	PRJNA168635_P_NODE_26327_length_168_cov_0.873950_g25911_i0	PRJNA168635	26327	168	0.87395	1.468236	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	100	4.97e-17	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g25911	i0	79.856	6.375	139	26	82	2	22	159	94341	94204	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	1071	100	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
9982268	9982268	PRJNA168635_P_NODE_17528_length_191_cov_2.866197_g17112_i0	PRJNA168635	17528	191	2.866197	5.47443627	Fusobacterium	848	Bacteria	Bacteria	342	8.699999999999999e-90	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g17112	i0	98.953	410.010471204188	191	2	100	0	1	191	56341	56531	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	78312	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
11842891	11842891	PRJNA168635_P_NODE_11070_length_247_cov_0.994949_g10655_i0	PRJNA168635	11070	247	0.994949	2.45752403	Fusobacterium gonidiaformans	849	Bacteria	Bacteria	442	1.1299999999999995e-119	NTclustered	gi\|1370530246\|gb\|CP028106.1\|	469615	g10655	i0	99.184	287.303643724696	245	2	99	0	3	247	3911	4155	Fusobacterium gonidiaformans ATCC 25563 chromosome, complete genome	blastn	70964	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium gonidiaformans
11843358	11843358	PRJNA168635_P_NODE_7770_length_303_cov_3.818898_g7357_i0	PRJNA168635	7770	303	3.818898	11.57126094	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	544	3.82e-150	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g7357	i0	99.01	402.303630363036	303	3	100	0	1	303	200198	200500	Leptotrichia sp. SK-5 DNA, complete genome	blastn	121898	544	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
11843390	11843390	PRJNA168635_P_NODE_9350_length_273_cov_2.839286_g8935_i0	PRJNA168635	9350	273	2.839286	7.75125078	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	477	3.489999999999999e-130	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g8935	i0	98.168	88.3919413919414	273	5	100	0	1	273	197159	196887	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	24131	477	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
15081918	15081918	PRJNA168635_P_NODE_6412_length_334_cov_5.722807_g6001_i0	PRJNA168635	6412	334	5.722807	19.11417538	Fusobacterium	848	Bacteria	Bacteria	575	1.5099999999999999e-159	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g6001	i0	97.892	447.12874251497	332	7	99	0	3	334	336	5	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	149341	580	0.991379310344828	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
16941659	16941659	PRJNA168635_P_NODE_19394_length_184_cov_2.896296_g18978_i0	PRJNA168635	19394	184	2.896296	5.32918464	Leptotrichia wadei	157687	Bacteria	Bacteria	326	8.37e-85	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g18978	i0	98.387	83.0489130434783	186	1	100	1	1	184	220617	220432	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	15281	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19490332	19490332	PRJNA168635_P_NODE_16716_length_195_cov_6.595890_g16300_i0	PRJNA168635	16716	195	6.59589	12.8619855	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	302	1.5200000000000001e-77	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g16300	i0	97.191	95.3128205128205	178	5	93	0	4	181	49758	49935	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	18586	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19490438	19490438	PRJNA168635_P_NODE_2256_length_542_cov_6.095335_g1879_i0	PRJNA168635	2256	542	6.095335	33.0367157	Leptotrichia hofstadii	157688	Bacteria	Bacteria	957	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g1879	i0	98.524	501.088560885609	542	8	100	0	1	542	498389	498930	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	271590	957	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
22041265	22041265	PRJNA168635_P_NODE_33838_length_156_cov_5.691589_g33422_i0	PRJNA168635	33838	156	5.691589	8.87887884	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	283	4.1899999999999994e-72	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g33422	i0	100	15.724358974359	153	0	98	0	2	154	53844	53692	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2453	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
22731131	22731131	PRJNA168635_P_NODE_3658_length_437_cov_33.250000_g3258_i0	PRJNA168635	3658	437	33.25	145.3025	Fusobacterium	848	Bacteria	Bacteria	793	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g3258	i0	99.541	485.475972540046	436	0	99	2	2	435	504	939	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	212153	795	0.99748427672956	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
24006166	24006166	PRJNA168635_P_NODE_20079_length_182_cov_1.533835_g19663_i0	PRJNA168635	20079	182	1.533835	2.7915797	Leptotrichia	32067	Bacteria	Bacteria	331	1.7800000000000002e-86	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g19663	i0	99.451	356.730769230769	182	1	100	0	1	182	593428	593247	Leptotrichia sp. oral taxon 498, complete genome	blastn	64925	331	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
24591028	24591028	PRJNA168635_P_NODE_7760_length_303_cov_8.484252_g7347_i0	PRJNA168635	7760	303	8.484252	25.70728356	Leptotrichia wadei	157687	Bacteria	Bacteria	549	8.209999999999997e-152	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g7347	i0	99.34	441.468646864686	303	2	100	0	1	303	1695274	1694972	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	133765	549	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
25280312	25280312	PRJNA168635_P_NODE_23400_length_173_cov_1.379032_g22984_i0	PRJNA168635	23400	173	1.379032	2.38572536	Streptobacillus	34104	Bacteria	Bacteria	278	2.2e-70	NTclustered	gi\|470485174\|ref\|NR_076688.1\|	34105	g22984	i0	95.455	72.4566473988439	176	5	100	1	1	173	2725	2900	Streptobacillus moniliformis strain DSM 12112 23S ribosomal RNA gene, complete sequence	blastn	12535	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis

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