metadata: contig_metadata: 27 rows where bioproject = "PRJNA703759" and tax

27 rows where bioproject = "PRJNA703759" 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
684832	684832	PRJNA703759_P_NODE_50761_length_242_cov_0.923077_g50285_i0	PRJNA703759	50761	242	0.923077	2.23384634	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	150	7.509999999999998e-32	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g50285	i0	81.771	6.62809917355372	192	23	82	11	13	199	1530859	1530675	Leptotrichia sp. SK-5 DNA, complete genome	blastn	1604	150	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
1960610	1960610	PRJNA703759_P_NODE_40462_length_249_cov_0.886364_g39986_i0	PRJNA703759	40462	249	0.886364	2.20704636	Leptotrichia buccalis	40542	Bacteria	Bacteria	399	6.989999999999999e-107	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g39986	i0	95.582	19.9919678714859	249	11	100	0	1	249	640482	640730	Leptotrichia buccalis DSM 1135, complete genome	blastn	4978	399	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
5788081	5788081	PRJNA703759_P_NODE_38285_length_250_cov_1.762712_g37809_i0	PRJNA703759	38285	250	1.762712	4.40678	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g37809	i0	100	1	250	0	100	0	1	250	1399705	1399954	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	250	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
7062957	7062957	PRJNA703759_P_NODE_29406_length_269_cov_1.193878_g28930_i0	PRJNA703759	29406	269	1.193878	3.21153182	Fusobacterium varium	856	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1243298346\|dbj\|AP017968.1\|	856	g28930	i0	94.444	0.133828996282528	36	1	13	1	16	51	1393353	1393387	Fusobacterium varium Fv113-g1 DNA, complete genome	blastn	36	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
7562883	7562883	PRJNA703759_P_NODE_43266_length_247_cov_0.896552_g42790_i0	PRJNA703759	43266	247	0.896552	2.21448344	Fusobacterium	848	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g42790	i0	100	32.8704453441296	247	0	100	0	1	247	1834316	1834562	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	8119	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
8337770	8337770	PRJNA703759_P_NODE_38987_length_250_cov_0.881356_g38511_i0	PRJNA703759	38987	250	0.881356	2.20339	Fusobacterium nucleatum	851	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g38511	i0	100	63.228	250	0	100	0	1	250	1103063	1102814	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	15807	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
9613002	9613002	PRJNA703759_P_NODE_34708_length_253_cov_0.866667_g34232_i0	PRJNA703759	34708	253	0.866667	2.19266751	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	418	1.9599999999999994e-112	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g34232	i0	96.443	1	253	9	100	0	1	253	2251354	2251102	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	253	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9613296	9613296	PRJNA703759_P_NODE_48028_length_244_cov_0.912281_g47552_i0	PRJNA703759	48028	244	0.912281	2.22596564	Fusobacterium nucleatum	851	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2704972056\|gb\|CP077127.1\|	851	g47552	i0	100	99.8401639344262	244	0	100	0	1	244	759303	759546	Fusobacterium nucleatum strain KCOM3503 chromosome, complete genome	blastn	24361	451	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
10113581	10113581	PRJNA703759_P_NODE_43848_length_247_cov_0.896552_g43372_i0	PRJNA703759	43848	247	0.896552	2.21448344	Fusobacterium	848	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1721134154\|emb\|LR698955.1\|	851	g43372	i0	100	99.2955465587045	247	0	100	0	1	247	23466	23220	Fusobacterium nucleatum isolate MGYG-HGUT-01347 genome assembly, chromosome: 1	blastn	24526	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
10113614	10113614	PRJNA703759_P_NODE_48888_length_243_cov_0.917647_g48412_i0	PRJNA703759	48888	243	0.917647	2.22988221	Leptotrichia	32067	Bacteria	Bacteria	390	4.089999999999999e-104	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g48412	i0	95.851	8.95061728395062	241	10	99	0	1	241	2468471	2468231	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	2175	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
10888637	10888637	PRJNA703759_P_NODE_38029_length_251_cov_0.876404_g37553_i0	PRJNA703759	38029	251	0.876404	2.19977404	Leptotrichia wadei	157687	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g37553	i0	100	0.111553784860558	28	0	11	0	195	222	867022	867049	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
12163728	12163728	PRJNA703759_P_NODE_34190_length_253_cov_1.633333_g33714_i0	PRJNA703759	34190	253	1.633333	4.13233249	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g33714	i0	98.419	8.00790513833992	253	4	100	0	1	253	2326729	2326981	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	2026	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
12163969	12163969	PRJNA703759_P_NODE_45130_length_246_cov_0.901734_g44654_i0	PRJNA703759	45130	246	0.901734	2.21826564	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	366	6.99e-97	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g44654	i0	93.496	1.63008130081301	246	16	100	0	1	246	2134389	2134634	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	401	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
12664467	12664467	PRJNA703759_P_NODE_46150_length_245_cov_0.906977_g45674_i0	PRJNA703759	46150	245	0.906977	2.22209365	Fusobacterium	848	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2645857096\|gb\|CP141275.1\|	76857	g45674	i0	100	100	245	0	100	0	1	245	171199	170955	Fusobacterium polymorphum strain NCTC 10562 chromosome, complete genome	blastn	24500	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
13938945	13938945	PRJNA703759_P_NODE_50491_length_242_cov_0.923077_g50015_i0	PRJNA703759	50491	242	0.923077	2.23384634	Fusobacterium	848	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g50015	i0	100	86.9297520661157	242	0	100	0	1	242	2290842	2290601	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	21037	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
14713786	14713786	PRJNA703759_P_NODE_50112_length_242_cov_1.846154_g49636_i0	PRJNA703759	50112	242	1.846154	4.46769268	Fusobacterium polymorphum	76857	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2706501641\|gb\|CP084157.1\|	76857	g49636	i0	99.587	484.995867768595	242	1	100	0	1	242	2332495	2332736	Fusobacterium polymorphum strain KCOM2446 chromosome, complete genome	blastn	117369	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
15987409	15987409	PRJNA703759_P_NODE_48853_length_243_cov_0.917647_g48377_i0	PRJNA703759	48853	243	0.917647	2.22988221	Leptotrichia buccalis	40542	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g48377	i0	99.588	9.81481481481481	243	1	100	0	1	243	486141	486383	Leptotrichia buccalis DSM 1135, complete genome	blastn	2385	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
17262592	17262592	PRJNA703759_P_NODE_40854_length_249_cov_0.886364_g40378_i0	PRJNA703759	40854	249	0.886364	2.20704636	Fusobacterium polymorphum	76857	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g40378	i0	99.598	99.6787148594377	249	1	100	0	1	249	206912	206664	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	24820	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
17762702	17762702	PRJNA703759_P_NODE_29074_length_270_cov_1.243655_g28598_i0	PRJNA703759	29074	270	1.243655	3.3578685	Fusobacterium	848	Bacteria	Bacteria	499	7.349999999999998e-137	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g28598	i0	100	46	270	0	100	0	1	270	1715975	1716244	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	12420	499	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18536352	18536352	PRJNA703759_P_NODE_38795_length_250_cov_0.881356_g38319_i0	PRJNA703759	38795	250	0.881356	2.20339	Fusobacterium polymorphum	76857	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g38319	i0	100	59.752	250	0	100	0	1	250	433289	433538	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	14938	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
19811084	19811084	PRJNA703759_P_NODE_21576_length_301_cov_0.951754_g21100_i0	PRJNA703759	21576	301	0.951754	2.86477954	Leptotrichia buccalis	40542	Bacteria	Bacteria	534	2.28e-147	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g21100	i0	98.671	1.43189368770764	301	4	100	0	1	301	1666562	1666862	Leptotrichia buccalis DSM 1135, complete genome	blastn	431	534	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
19811678	19811678	PRJNA703759_P_NODE_47176_length_244_cov_1.409357_g46700_i0	PRJNA703759	47176	244	1.409357	3.43883108	Leptotrichia shahii	157691	Bacteria	Bacteria	433	6.73e-117	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g46700	i0	98.765	1.98360655737705	243	3	99	0	2	244	1551458	1551216	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	484	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
21087278	21087278	PRJNA703759_P_NODE_50817_length_242_cov_0.923077_g50341_i0	PRJNA703759	50817	242	0.923077	2.23384634	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	392	1.1299999999999999e-104	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g50341	i0	95.868	1	242	10	100	0	1	242	1663366	1663607	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	242	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
21587048	21587048	PRJNA703759_P_NODE_19117_length_315_cov_1.776860_g18641_i0	PRJNA703759	19117	315	1.77686	5.597109	Leptotrichia	32067	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g18641	i0	96.774	0.187301587301587	31	1	10	0	66	96	2527679	2527649	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	59	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
22361936	22361936	PRJNA703759_P_NODE_44998_length_246_cov_0.901734_g44522_i0	PRJNA703759	44998	246	0.901734	2.21826564	Fusobacterium nucleatum	851	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2705013194\|gb\|CP084126.1\|	851	g44522	i0	99.187	25.5853658536585	246	2	100	0	1	246	1000027	999782	Fusobacterium nucleatum strain KCOM2205 chromosome, complete genome	blastn	6294	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
24911102	24911102	PRJNA703759_P_NODE_47960_length_244_cov_0.912281_g47484_i0	PRJNA703759	47960	244	0.912281	2.22596564	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g47484	i0	98.77	99.9426229508197	244	3	100	0	1	244	701299	701056	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	24386	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
28104479	28104479	PRJNA703759_P_NODE_21805_length_299_cov_2.004425_g21329_i0	PRJNA703759	21805	299	2.004425	5.99323075	FCB group	1783270	Bacteria	Bacteria	96.7	8.029999999999999e-24	NR	MBZ4683857.1	2044942	g21329	i0	61.7	2.98996655518395	60	23	60.2	0	181	2	1	60	MBZ4683857.1 yidD [Fusobacteriales bacterium]	diamond	894	96.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales			Fusobacteriales bacterium

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