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

21 rows where bioproject = "PRJNA1143173" 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
286770	286770	PRJNA1143173_P_NODE_9781_length_310_cov_4.607595_g9755_i0	PRJNA1143173	9781	310	4.607595	14.2835445	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|1276714546\|gb\|CP024702.1\|	2663009	g9755	i0	100	52.2	150	0	97	0	1	150	542016	542165	Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome	blastn	16182	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
1032642	1032642	PRJNA1143173_P_NODE_17241_length_295_cov_2.707207_g17215_i0	PRJNA1143173	17241	295	2.707207	7.98626065	Fusobacterium	848	Bacteria	Bacteria	518	2.25e-142	NTclustered	gi\|2445153921\|gb\|CP117797.1\|	851	g17215	i0	98.305	99.593220338983	295	5	100	0	1	295	1226832	1227126	Fusobacterium nucleatum strain FNA chromosome, complete genome	blastn	29380	518	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
1560667	1560667	PRJNA1143173_P_NODE_16842_length_296_cov_2.959641_g16816_i0	PRJNA1143173	16842	296	2.959641	8.76053736	Sneathia vaginalis	187101	Bacteria	Bacteria	547	2.8799999999999986e-151	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g16816	i0	100	3	296	0	100	0	1	296	1025943	1025648	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	888	547	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
1560745	1560745	PRJNA1143173_P_NODE_20222_length_286_cov_5.568075_g20196_i0	PRJNA1143173	20222	286	5.568075	15.9246945	Fusobacterium polymorphum	76857	Bacteria	Bacteria	278	4.01e-70	NTclustered	gi\|2706056059\|gb\|CP077188.1\|	76857	g20196	i0	99.351	72.1258741258741	154	0	100	1	134	286	1794913	1795066	Fusobacterium polymorphum strain SB028 chromosome, complete genome	blastn	20628	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
3583277	3583277	PRJNA1143173_P_NODE_30343_length_257_cov_2.048913_g30317_i0	PRJNA1143173	30343	257	2.048913	5.26570641	Fusobacterium	848	Bacteria	Bacteria	464	2.5299999999999998e-126	NTclustered	gi\|2706506546\|gb\|CP084156.1\|	76857	g30317	i0	99.222	99.8132295719844	257	2	100	0	1	257	661216	660960	Fusobacterium polymorphum strain KCOM2510 chromosome	blastn	25652	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
6664101	6664101	PRJNA1143173_P_NODE_24326_length_274_cov_4.223881_g24300_i0	PRJNA1143173	24326	274	4.223881	11.57343394	Fusobacterium periodonticum	860	Bacteria	Bacteria	490	4.499999999999999e-134	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g24300	i0	98.905	99.9963503649635	274	3	100	0	1	274	561852	561579	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	27399	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
9214271	9214271	PRJNA1143173_P_NODE_27548_length_265_cov_2.197917_g27522_i0	PRJNA1143173	27548	265	2.197917	5.82448005	Fusobacterium polymorphum	76857	Bacteria	Bacteria	307	4.68e-79	NTclustered	gi\|2706041172\|gb\|CP056018.1\|	76857	g27522	i0	89.344	55.4264150943396	244	26	92	0	22	265	937235	937478	Fusobacterium polymorphum strain SB006 chromosome, complete genome	blastn	14688	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9960994	9960994	PRJNA1143173_P_NODE_41228_length_219_cov_6.294521_g41202_i0	PRJNA1143173	41228	219	6.294521	13.78500099	Fusobacterium	848	Bacteria	Bacteria	399	6.009999999999999e-107	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g41202	i0	99.543	99.8767123287671	219	1	100	0	1	219	2424622	2424404	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	21873	399	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
10490009	10490009	PRJNA1143173_P_NODE_34169_length_246_cov_1.716763_g34143_i0	PRJNA1143173	34169	246	1.716763	4.22323698	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g34143	i0	98.374	1	246	4	100	0	1	246	461287	461042	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	246	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
13040148	13040148	PRJNA1143173_P_NODE_35151_length_243_cov_2.964706_g35125_i0	PRJNA1143173	35151	243	2.964706	7.20423558	Leptotrichia wadei	157687	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g35125	i0	100	13.9876543209877	243	0	100	0	1	243	342336	342094	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	3399	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
14315194	14315194	PRJNA1143173_P_NODE_27552_length_265_cov_2.036458_g27526_i0	PRJNA1143173	27552	265	2.036458	5.3966137	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	331	2.78e-86	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g27526	i0	89.354	1.96603773584906	263	28	99	0	1	263	282135	281873	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	521	331	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14315639	14315639	PRJNA1143173_P_NODE_6112_length_346_cov_1.670330_g6086_i0	PRJNA1143173	6112	346	1.67033	5.7793418	Leptotrichia alba	3239304	Bacteria	Bacteria	342	1.7399999999999998e-89	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g6086	i0	93.478	3.32658959537572	230	15	66	0	1	230	846388	846159	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	1151	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
16863208	16863208	PRJNA1143173_P_NODE_21214_length_283_cov_5.695238_g21188_i0	PRJNA1143173	21214	283	5.695238	16.11752354	Leptotrichia sp. oral taxon 218	712361	Bacteria	Bacteria	462	1.02e-125	NTclustered	gi\|2028887161\|gb\|CP072377.1\|	712361	g21188	i0	96.429	30.2155477031802	280	10	99	0	4	283	1665562	1665841	Leptotrichia sp. oral taxon 218 strain F0707 chromosome, complete genome	blastn	8551	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 218
16863285	16863285	PRJNA1143173_P_NODE_24334_length_274_cov_4.094527_g24308_i0	PRJNA1143173	24334	274	4.094527	11.21900398	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	446	9.88e-121	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g24308	i0	96.642	2.97810218978102	268	9	98	0	7	274	2427261	2426994	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	816	446	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
16863731	16863731	PRJNA1143173_P_NODE_44854_length_196_cov_4.536585_g44828_i0	PRJNA1143173	44854	196	4.536585	8.8917066	Fusobacterium polymorphum	76857	Bacteria	Bacteria	363	6.899999999999998e-96	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g44828	i0	100	59.7857142857143	196	0	100	0	1	196	2003982	2003787	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	11718	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18884264	18884264	PRJNA1143173_P_NODE_21435_length_283_cov_1.466667_g21409_i0	PRJNA1143173	21435	283	1.466667	4.15066761	Leptotrichia	32067	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g21409	i0	100	5.3957597173144896	283	0	100	0	1	283	2355239	2355521	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	1527	523	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21962984	21962984	PRJNA1143173_P_NODE_25598_length_270_cov_6.304569_g25572_i0	PRJNA1143173	25598	270	6.304569	17.0223363	Leptotrichia wadei	157687	Bacteria	Bacteria	494	3.4199999999999996e-135	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g25572	i0	99.63	16	270	1	100	0	1	270	1825023	1824754	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	4320	494	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
22709645	22709645	PRJNA1143173_P_NODE_28998_length_260_cov_8.422460_g28972_i0	PRJNA1143173	28998	260	8.42246	21.898396	Fusobacterium	848	Bacteria	Bacteria	248	2.8199999999999997e-61	NTclustered	gi\|2645891705\|gb\|CP141279.1\|	76857	g28972	i0	99.27	67.2538461538462	137	1	100	0	1	137	1982270	1982134	Fusobacterium polymorphum strain 43A3 chromosome, complete genome	blastn	17486	248	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
23238655	23238655	PRJNA1143173_P_NODE_28179_length_263_cov_2.284211_g28153_i0	PRJNA1143173	28179	263	2.284211	6.00747493	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	425	1.2299999999999999e-114	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g28153	i0	95.817	6.08745247148289	263	11	100	0	1	263	2373127	2372865	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1601	425	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
23239186	23239186	PRJNA1143173_P_NODE_9199_length_310_cov_5.358650_g9173_i0	PRJNA1143173	9199	310	5.35865	16.611815	Leptotrichia rugosa	3239302	Bacteria	Bacteria	438	1.9e-118	NTclustered	gi\|2785246835\|gb\|CP165644.1\|	3239302	g9173	i0	90.606	2.12903225806452	330	11	100	1	1	310	647026	647355	Leptotrichia sp. HSP-334 chromosome, complete genome	blastn	660	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia rugosa
27038770	27038770	PRJNA1143173_P_NODE_42622_length_211_cov_4.181159_g42596_i0	PRJNA1143173	42622	211	4.181159	8.82224549	Sneathia sanguinegens	40543	Bacteria	Bacteria	70.5	1.46e-12	NR	WP_277285133.1	40543	g42596	i0	58.2	4.7345971563981	67	27	93.8	1	206	9	140	206	WP_277285133.1 ABC transporter ATP-binding protein [Sneathia sanguinegens]	diamond	999	70.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens

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