metadata: contig_metadata: 21 rows where bioproject = "PRJNA1104180" and tax

21 rows where bioproject = "PRJNA1104180" 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
212289	212289	PRJNA1104180_P_NODE_14601_length_280_cov_0.980676_g14459_i0	PRJNA1104180	14601	280	0.980676	2.7458928	Leptotrichia wadei	157687	Bacteria	Bacteria	488	1.6599999999999998e-133	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g14459	i0	98.214	492.264285714286	280	4	100	1	1	280	1757207	1756929	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	137834	488	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
1487088	1487088	PRJNA1104180_P_NODE_24182_length_244_cov_1.801170_g24039_i0	PRJNA1104180	24182	244	1.80117	4.3948548	Fusobacterium polymorphum	76857	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2706426664\|gb\|CP077146.1\|	76857	g24039	i0	100	99.6188524590164	244	0	100	0	1	244	2330359	2330116	Fusobacterium polymorphum strain KCOM2500 chromosome, complete genome	blastn	24307	451	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
2295755	2295755	PRJNA1104180_P_NODE_25002_length_243_cov_0.905882_g24859_i0	PRJNA1104180	25002	243	0.905882	2.20129326	Leptotrichia	32067	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g24859	i0	96.708	14.761316872428	243	8	100	0	1	243	830815	830573	Leptotrichia buccalis DSM 1135, complete genome	blastn	3587	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
2295761	2295761	PRJNA1104180_P_NODE_25822_length_242_cov_0.911243_g25679_i0	PRJNA1104180	25822	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	448	2.3799999999999995e-121	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g25679	i0	100	12.9090909090909	242	0	100	0	1	242	309361	309602	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	3124	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
2762991	2762991	PRJNA1104180_P_NODE_15623_length_274_cov_1.149254_g15481_i0	PRJNA1104180	15623	274	1.149254	3.14895596	Fusobacterium necrogenes	858	Bacteria	Bacteria	479	9.74e-131	NTclustered	gi\|13447140\|gb\|AF342856.1\|	858	g15481	i0	98.175	425.375912408759	274	5	100	0	1	274	482	755	Fusobacterium necrogenes strain ATCC 25556 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	116553	479	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrogenes
4039317	4039317	PRJNA1104180_P_NODE_9524_length_323_cov_2.968000_g9382_i0	PRJNA1104180	9524	323	2.968	9.58664	Fusobacterium animalis	76859	Bacteria	Bacteria	592	1.4499999999999999e-164	NTclustered	gi\|2706438296\|gb\|CP084062.1\|	76859	g9382	i0	99.69	499	323	1	100	0	1	323	459513	459191	Fusobacterium animalis strain SB008 chromosome, complete genome	blastn	161177	592	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
6590311	6590311	PRJNA1104180_P_NODE_13046_length_289_cov_1.162037_g12904_i0	PRJNA1104180	13046	289	1.162037	3.35828693	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	518	2.19e-142	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g12904	i0	98.962	406.079584775087	289	3	100	0	1	289	71537	71249	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	117357	518	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
6590351	6590351	PRJNA1104180_P_NODE_15526_length_274_cov_2.014925_g15384_i0	PRJNA1104180	15526	274	2.014925	5.5208945	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	494	3.48e-135	NTclustered	gi\|2078812864\|gb\|CP071092.1\|	1583098	g15384	i0	99.631	97.9124087591241	271	0	99	1	5	274	1429936	1430206	Fusobacterium hwasookii strain THCT14E2 chromosome, complete genome	blastn	26828	494	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
7398055	7398055	PRJNA1104180_P_NODE_18806_length_257_cov_1.614130_g18664_i0	PRJNA1104180	18806	257	1.61413	4.1483141	Leptotrichia	32067	Bacteria	Bacteria	411	3.349999999999999e-110	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g18664	i0	96.032	10.7470817120623	252	10	98	0	6	257	755196	754945	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	2762	411	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
7865085	7865085	PRJNA1104180_P_NODE_21467_length_249_cov_0.875000_g21324_i0	PRJNA1104180	21467	249	0.875	2.17875	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g21324	i0	100	30.5220883534137	249	0	100	0	1	249	2150893	2151141	Leptotrichia sp. SK-5 DNA, complete genome	blastn	7600	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
9139836	9139836	PRJNA1104180_P_NODE_13448_length_286_cov_2.375587_g13306_i0	PRJNA1104180	13448	286	2.375587	6.79417882	Fusobacterium polymorphum	76857	Bacteria	Bacteria	278	4.01e-70	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g13306	i0	100	19.6853146853147	150	0	100	0	1	150	765257	765108	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	5630	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
14241082	14241082	PRJNA1104180_P_NODE_16532_length_269_cov_1.372449_g16390_i0	PRJNA1104180	16532	269	1.372449	3.69188781	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	435	2.09e-117	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g16390	i0	95.896	487.397769516729	268	11	99	0	2	269	52277	52010	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	131110	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15048077	15048077	PRJNA1104180_P_NODE_7972_length_345_cov_1.496324_g7830_i0	PRJNA1104180	7972	345	1.496324	5.1623178	Fusobacterium	848	Bacteria	Bacteria	616	9.229999999999999e-172	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g7830	i0	98.841	475.626086956522	345	4	100	0	1	345	1933020	1932676	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	164091	621	0.99194847020934	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18064051	18064051	PRJNA1104180_P_NODE_21075_length_250_cov_0.870056_g20932_i0	PRJNA1104180	21075	250	0.870056	2.17514	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g20932	i0	100	9.88	250	0	100	0	1	250	254436	254685	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	2470	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
18064134	18064134	PRJNA1104180_P_NODE_27415_length_230_cov_2.770701_g27272_i0	PRJNA1104180	27415	230	2.770701	6.3726123	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g27272	i0	100	19.4826086956522	230	0	100	0	1	230	2253599	2253828	Leptotrichia sp. SK-5 DNA, complete genome	blastn	4481	425	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
18871821	18871821	PRJNA1104180_P_NODE_13715_length_285_cov_1.334906_g13573_i0	PRJNA1104180	13715	285	1.334906	3.8044821	Leptotrichia	32067	Bacteria	Bacteria	521	1.6699999999999996e-143	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g13573	i0	99.649	13.9508771929825	285	1	100	0	1	285	593502	593218	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	3976	521	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
19338054	19338054	PRJNA1104180_P_NODE_1236_length_781_cov_1.782486_g1100_i0	PRJNA1104180	1236	781	1.782486	13.92121566	Fusobacterium polymorphum	76857	Bacteria	Bacteria	1421	0	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g1100	i0	99.488	487.769526248399	781	4	100	0	1	781	190380	189600	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	380948	1421	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
20613447	20613447	PRJNA1104180_P_NODE_15097_length_277_cov_1.191176_g14955_i0	PRJNA1104180	15097	277	1.191176	3.29955752	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g14955	i0	99.639	1	277	1	100	0	1	277	2019298	2019022	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	277	507	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
21422422	21422422	PRJNA1104180_P_NODE_9577_length_323_cov_0.940000_g9435_i0	PRJNA1104180	9577	323	0.94	3.0362	Leptotrichia	32067	Bacteria	Bacteria	569	6.769999999999998e-158	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g9435	i0	98.452	497.798761609907	323	5	100	0	1	323	2465	2143	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	160789	569	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
23164660	23164660	PRJNA1104180_P_NODE_22079_length_248_cov_0.880000_g21936_i0	PRJNA1104180	22079	248	0.88	2.1824	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g21936	i0	99.194	310.721774193548	248	2	100	0	1	248	549970	550217	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	77059	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
24438139	24438139	PRJNA1104180_P_NODE_12480_length_292_cov_2.844749_g12338_i0	PRJNA1104180	12480	292	2.844749	8.30666708	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	279	1.14e-70	NTclustered	gi\|1276720946\|gb\|CP024705.1\|	2663009	g12338	i0	100	292.246575342466	151	0	96	0	142	292	2031895	2032045	Fusobacterium pseudoperiodonticum strain KCOM 2653 chromosome, complete genome	blastn	85336	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum

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