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

21 rows where bioproject = "PRJNA358490" 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
399071	399071	PRJNA358490_P_NODE_2961_length_833_cov_6.993703_g2760_i0	PRJNA358490	2961	833	6.993703	58.25754599	Leptotrichia wadei	157687	Bacteria	Bacteria	1500	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g2760	i0	100	87.8787515006002	812	0	97	0	1	812	2201690	2202501	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	73203	1500	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
399156	399156	PRJNA358490_P_NODE_8481_length_412_cov_12.946381_g8140_i0	PRJNA358490	8481	412	12.946381	53.33908972	Leptotrichia wadei	157687	Bacteria	Bacteria	665	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g8140	i0	97.442	11.881067961165	391	9	95	1	1	391	1963130	1963519	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	4895	665	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
1673830	1673830	PRJNA358490_P_NODE_8982_length_388_cov_2.925501_g8641_i0	PRJNA358490	8982	388	2.925501	11.35094388	Leptotrichia wadei	157687	Bacteria	Bacteria	457	6.719999999999999e-124	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g8641	i0	99.6	7.26030927835052	250	1	94	0	21	270	398291	398540	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	2817	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
2949662	2949662	PRJNA358490_P_NODE_443_length_1698_cov_320.530440_g400_i0	PRJNA358490	443	1698	320.53044	5442.6068712	Leptotrichia wadei	157687	Bacteria	Bacteria	2964	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g400	i0	98.455	421.304475853946	1683	26	99	0	16	1698	1756341	1758023	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	715375	2964	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4226227	4226227	PRJNA358490_P_NODE_2864_length_847_cov_6.676980_g2667_i0	PRJNA358490	2864	847	6.67698	56.5540206	Leptotrichia wadei	157687	Bacteria	Bacteria	1469	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g2667	i0	98.789	8.00236127508855	826	9	98	1	1	826	1979751	1980575	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	6778	1469	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4226296	4226296	PRJNA358490_P_NODE_7804_length_445_cov_3.209360_g7463_i0	PRJNA358490	7804	445	3.20936	14.281652	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	536	9.749999999999997e-148	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g7463	i0	89.51	342.716853932584	429	38	96	7	9	433	398325	398750	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	152509	536	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
5502667	5502667	PRJNA358490_P_NODE_445_length_1697_cov_206.165862_g400_i1	PRJNA358490	445	1697	206.165862	3498.63467814	Leptotrichia wadei	157687	Bacteria	Bacteria	2676	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g400	i1	95.371	432.969946965233	1685	75	99	3	14	1697	1756341	1758023	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	734750	2676	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
6776616	6776616	PRJNA358490_P_NODE_14946_length_183_cov_1.881944_g14602_i0	PRJNA358490	14946	183	1.881944	3.44395752	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	226	8.679999999999998e-55	NTclustered	gi\|2705022034\|gb\|CP084128.1\|	2663009	g14602	i0	91.566	8.19672131147541	166	10	89	2	22	183	1565724	1565889	Fusobacterium pseudoperiodonticum strain KCOM1322 chromosome, complete genome	blastn	1500	226	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
6776792	6776792	PRJNA358490_P_NODE_9866_length_339_cov_4.516667_g9524_i0	PRJNA358490	9866	339	4.516667	15.31150113	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	401	2.759999999999999e-107	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g9524	i0	97.059	3.51917404129794	238	7	70	0	83	320	1286658	1286895	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	1193	401	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
8052383	8052383	PRJNA358490_P_NODE_8127_length_429_cov_1.884615_g7786_i0	PRJNA358490	8127	429	1.884615	8.08499835	Leptotrichia wadei	157687	Bacteria	Bacteria	732	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g7786	i0	99.022	4.76923076923077	409	3	95	1	1	408	1670664	1671072	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	2046	732	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
8725905	8725905	PRJNA358490_P_NODE_8607_length_407_cov_1.122283_g8266_i0	PRJNA358490	8607	407	1.122283	4.56769181	Leptotrichia	32067	Bacteria	Bacteria	189	2.849999999999999e-43	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g8266	i0	96.491	4.21375921375921	114	4	48	0	1	114	2110800	2110913	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1715	189	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
14427717	14427717	PRJNA358490_P_NODE_12572_length_233_cov_1.675258_g12228_i0	PRJNA358490	12572	233	1.675258	3.90335114	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	353	5.1e-93	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g12228	i0	93.991	140.643776824034	233	14	100	0	1	233	52956	53188	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	32770	353	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14427840	14427840	PRJNA358490_P_NODE_4452_length_663_cov_6.089744_g4197_i0	PRJNA358490	4452	663	6.089744	40.37500272	Leptotrichia wadei	157687	Bacteria	Bacteria	1122	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g4197	i0	98.137	23.6229260935143	644	10	97	1	22	663	605356	605999	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	15662	1122	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
15701652	15701652	PRJNA358490_P_NODE_14433_length_191_cov_1.802632_g14089_i0	PRJNA358490	14433	191	1.802632	3.44302712	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	337	4.05e-88	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g14089	i0	98.429	100	191	3	100	0	1	191	320523	320713	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	19100	337	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
15701853	15701853	PRJNA358490_P_NODE_9813_length_342_cov_3.128713_g9471_i0	PRJNA358490	9813	342	3.128713	10.70019846	Leptotrichia wadei	157687	Bacteria	Bacteria	582	9.269999999999999e-162	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g9471	i0	99.379	10.7923976608187	322	1	94	1	1	321	825307	824986	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	3691	582	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
18250716	18250716	PRJNA358490_P_NODE_475_length_1662_cov_343.752311_g400_i2	PRJNA358490	475	1662	343.752311	5713.16340882	Leptotrichia wadei	157687	Bacteria	Bacteria	2826	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g400	i2	97.745	448.402527075812	1641	37	99	0	7	1647	1757981	1756341	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	745245	2826	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
18924674	18924674	PRJNA358490_P_NODE_16275_length_167_cov_1.914062_g15931_i0	PRJNA358490	16275	167	1.914062	3.19648354	Cetobacterium	180162	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g15931	i0	98.204	95.4790419161677	167	3	100	0	1	167	279461	279295	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	15945	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20199303	20199303	PRJNA358490_P_NODE_476_length_1660_cov_307.843307_g400_i3	PRJNA358490	476	1660	307.843307	5110.1988962	Leptotrichia	32067	Bacteria	Bacteria	2643	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g400	i3	95.734	456.874096385542	1641	70	99	0	7	1647	1757981	1756341	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	758411	2643	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
22075648	22075648	PRJNA358490_P_NODE_8138_length_428_cov_3.925450_g7797_i0	PRJNA358490	8138	428	3.92545	16.800926	Sneathia vaginalis	187101	Bacteria	Bacteria	708	0	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g7797	i0	100	298.163551401869	383	0	89	0	26	408	3514	3132	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	127614	708	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
24024961	24024961	PRJNA358490_P_NODE_1999_length_992_cov_15.937041_g1859_i0	PRJNA358490	1999	992	15.937041	158.09544672	Fusobacterium	848	Bacteria	Bacteria	1781	0	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g1859	i0	99.59	473.504032258065	976	4	98	0	4	979	2340512	2339537	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	469716	1781	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
24625365	24625365	PRJNA358490_P_NODE_9420_length_363_cov_3.666667_g9078_i0	PRJNA358490	9420	363	3.666667	13.31000121	Leptotrichia wadei	157687	Bacteria	Bacteria	612	1.2599999999999999e-170	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g9078	i0	98.834	89.168044077135	343	4	94	0	1	343	110505	110163	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	32368	612	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei

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