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

24 rows where analysis = "blastn", bioproject = "PRJNA637328" 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
1155189	1155189	PRJNA637328_S_NODE_3721_length_161_cov_4.879032_g3644_i0	PRJNA637328	3721	161	4.879032	7.85524152	Fusobacterium	848	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g3644	i0	100	490	161	0	100	0	1	161	93934	94094	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	78890	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
1885357	1885357	PRJNA637328_P_NODE_9182_length_302_cov_1.577075_g8707_i0	PRJNA637328	9182	302	1.577075	4.7627665	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	518	2.31e-142	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g8707	i0	97.674	389.76158940397403	301	7	99	0	2	302	805325	805025	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	117708	518	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
1885381	1885381	PRJNA637328_S_NODE_3682_length_162_cov_1.952000_g3605_i0	PRJNA637328	3682	162	1.952	3.16224	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g3605	i0	98.773	489.388888888889	163	1	100	1	1	162	71578	71416	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	79281	289	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
2430342	2430342	PRJNA637328_P_NODE_9582_length_299_cov_3.852000_g9107_i0	PRJNA637328	9582	299	3.852	11.51748	Leptotrichia	32067	Bacteria	Bacteria	279	1.17e-70	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g9107	i0	100	11.5183946488294	151	0	100	0	149	299	1401127	1400977	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	3444	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
3160138	3160138	PRJNA637328_S_NODE_2483_length_204_cov_49.047904_g2406_i0	PRJNA637328	2483	204	49.047904	100.05772416	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	372	1.2e-98	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g2406	i0	99.512	461.196078431373	205	0	100	1	1	204	72148	72352	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	94084	372	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
4436613	4436613	PRJNA637328_P_NODE_10424_length_290_cov_4.468880_g9949_i0	PRJNA637328	10424	290	4.46888	12.959752	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	492	1.3399999999999996e-134	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g9949	i0	97.241	10.9827586206897	290	8	100	0	1	290	2485037	2484748	Leptotrichia sp. SK-5 DNA, complete genome	blastn	3185	492	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
4436914	4436914	PRJNA637328_S_NODE_3124_length_179_cov_2.711268_g3047_i0	PRJNA637328	3124	179	2.711268	4.85316972	Leptotrichia wadei	157687	Bacteria	Bacteria	320	3.76e-83	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g3047	i0	98.883	156.418994413408	179	2	100	0	1	179	221513	221691	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	27999	320	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4983353	4983353	PRJNA637328_P_NODE_16704_length_251_cov_1.257426_g16227_i0	PRJNA637328	16704	251	1.257426	3.15613926	Cetobacterium	180162	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g16227	i0	98.008	18.6892430278884	251	5	100	0	1	251	1902498	1902248	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4691	436	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
5712528	5712528	PRJNA637328_P_NODE_10045_length_294_cov_2.363265_g9570_i0	PRJNA637328	10045	294	2.363265	6.9479991	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	438	1.7899999999999995e-118	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g9570	i0	93.16	4.72108843537415	307	8	100	1	1	294	42646	42340	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	1388	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
6258759	6258759	PRJNA637328_P_NODE_1885_length_670_cov_2.441224_g1487_i0	PRJNA637328	1885	670	2.441224	16.3562008	Cetobacterium	180162	Bacteria	Bacteria	584	5.32e-162	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g1487	i0	82.519	6.26865671641791	675	109	99	8	2	670	408424	409095	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	4200	584	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6987712	6987712	PRJNA637328_P_NODE_9306_length_301_cov_4.238095_g8831_i0	PRJNA637328	9306	301	4.238095	12.75666595	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	263	1.19e-65	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g8831	i0	98.013	1.45514950166113	151	3	100	0	151	301	2292600	2292450	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	438	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
8262208	8262208	PRJNA637328_P_NODE_16727_length_251_cov_1.009901_g16250_i0	PRJNA637328	16727	251	1.009901	2.53485151	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	409	1.17e-109	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g16250	i0	96.016	3.92430278884462	251	10	100	0	1	251	83111	83361	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	985	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
8808059	8808059	PRJNA637328_S_NODE_3767_length_160_cov_2.634146_g3690_i0	PRJNA637328	3767	160	2.634146	4.2146336	root	1	Root_unresolved	Root_unresolved	296	5.55e-76	NTclustered	gi\|645319974\|ref\|NR_117292.1\|	860	g3690	i0	100	111.98125	160	0	100	0	1	160	710	551	Fusobacterium periodonticum strain ATCC 33693 16S ribosomal RNA, partial sequence	blastn	17917	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
8808060	8808060	PRJNA637328_S_NODE_3787_length_160_cov_1.520325_g3710_i0	PRJNA637328	3787	160	1.520325	2.43252	Cetobacterium	180162	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g3710	i0	100	490.6375	160	0	100	0	1	160	280722	280563	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	78502	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10083646	10083646	PRJNA637328_P_NODE_568_length_1274_cov_4.385306_g368_i0	PRJNA637328	568	1274	4.385306	55.86879844	Leptotrichia	32067	Bacteria	Bacteria	1807	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g368	i0	92.476	431.26295133438	1276	77	99	18	1	1268	2288679	2289943	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	549429	1810	0.998342541436464	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
10083651	10083651	PRJNA637328_P_NODE_7748_length_329_cov_1.457143_g7273_i0	PRJNA637328	7748	329	1.457143	4.79400047	Cetobacterium	180162	Bacteria	Bacteria	512	1.1799999999999998e-140	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g7273	i0	94.817	68.3313069908815	328	17	99	0	2	329	16465	16138	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	22481	512	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12634192	12634192	PRJNA637328_S_NODE_1270_length_327_cov_30.344828_g1193_i0	PRJNA637328	1270	327	30.344828	99.22758756	Fusobacterium	848	Bacteria	Bacteria	582	8.819999999999998e-162	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g1193	i0	98.777	482.495412844037	327	4	100	0	1	327	107609	107935	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	157776	582	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13909107	13909107	PRJNA637328_S_NODE_2271_length_217_cov_1.616667_g2194_i0	PRJNA637328	2271	217	1.616667	3.50816739	Fusobacterium	848	Bacteria	Bacteria	390	3.579999999999999e-104	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g2194	i0	99.078	456.820276497696	217	2	100	0	1	217	303	87	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	99130	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
16457847	16457847	PRJNA637328_P_NODE_2753_length_545_cov_3.614919_g2300_i0	PRJNA637328	2753	545	3.614919	19.70130855	Leptotrichia	32067	Bacteria	Bacteria	926	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g2300	i0	97.422	491.4	543	14	99	0	1	543	578501	577959	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	267813	926	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
17187051	17187051	PRJNA637328_P_NODE_4214_length_429_cov_1.952632_g3740_i0	PRJNA637328	4214	429	1.952632	8.37679128	Cetobacterium somerae	188913	Bacteria	Bacteria	335	3.6699999999999985e-87	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g3740	i0	81.075	0.997668997668998	428	74	99	5	5	429	409035	409458	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	428	335	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19735845	19735845	PRJNA637328_P_NODE_3956_length_444_cov_2.554430_g3483_i0	PRJNA637328	3956	444	2.55443	11.3416692	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	811	0	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g3483	i0	99.774	375.078828828829	442	1	99	0	1	442	198520	198079	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	166535	811	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
22286009	22286009	PRJNA637328_P_NODE_11398_length_281_cov_5.051724_g10922_i0	PRJNA637328	11398	281	5.051724	14.19534444	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	405	1.73e-108	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g10922	i0	92.908	415.797153024911	282	14	99	3	3	281	53581	53859	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	116839	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
23561713	23561713	PRJNA637328_P_NODE_3639_length_465_cov_5.072115_g3169_i0	PRJNA637328	3639	465	5.072115	23.58533475	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	656	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g3169	i0	92.258	263.247311827957	465	32	99	4	3	465	52804	53266	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	122410	656	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24107096	24107096	PRJNA637328_S_NODE_1079_length_366_cov_2.082067_g1002_i0	PRJNA637328	1079	366	2.082067	7.62036522	Cetobacterium	180162	Bacteria	Bacteria	604	2.129999999999999e-168	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g1002	i0	96.448	524.344262295082	366	13	100	0	1	366	1317877	1317512	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	191910	604	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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