metadata: contig_metadata: 16 rows where bioproject = "PRJNA879067", tax_kingdom = "Thermotogati" and tax

16 rows where bioproject = "PRJNA879067", tax_kingdom = "Thermotogati" and tax_phylum = "Thermotogota"

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
3405894	3405894	PRJNA879067_P_NODE_42963_length_591_cov_1.915058_g39503_i0	PRJNA879067	42963	591	1.915058	11.31799278	Fervidobacterium ngatamarikiense	3389972	Bacteria	Bacteria	1038	0	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g39503	i0	100	4.74450084602369	562	0	95	0	30	591	301641	302202	Fervidobacterium pennivorans strain DYC, complete genome	blastn	2804	1038	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
4682094	4682094	PRJNA879067_P_NODE_103304_length_251_cov_0.865169_g99818_i0	PRJNA879067	103304	251	0.865169	2.17157419	Fervidobacterium nodosum	2424	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g99818	i0	98.406	1	251	4	100	0	1	251	656111	656361	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	251	442	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
9782170	9782170	PRJNA879067_P_NODE_20568_length_991_cov_7.529412_g17619_i0	PRJNA879067	20568	991	7.529412	74.61647292	Fervidobacterium gondwanense	44754	Bacteria	Bacteria	1048	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g17619	i0	97.398	14.4853683148335	615	16	62	0	65	679	517046	517660	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	14355	1048	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
10167594	10167594	PRJNA879067_P_NODE_49608_length_528_cov_1.769231_g46128_i0	PRJNA879067	49608	528	1.769231	9.34153968	Fervidobacterium	2422	Bacteria	Bacteria	806	0	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g46128	i0	96.386	5.34848484848485	498	3	94	1	1	498	1990354	1990836	Fervidobacterium pennivorans strain DYC, complete genome	blastn	2824	806	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
11059845	11059845	PRJNA879067_P_NODE_83229_length_325_cov_3.353175_g79743_i0	PRJNA879067	83229	325	3.353175	10.89781875	Fervidobacterium nodosum	2424	Bacteria	Bacteria	527	4.1599999999999984e-145	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g79743	i0	98.653	1.00615384615385	297	4	91	0	1	297	1887971	1887675	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	327	527	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
13609490	13609490	PRJNA879067_P_NODE_70451_length_386_cov_0.984026_g66966_i0	PRJNA879067	70451	386	0.984026	3.79834036	Fervidobacterium nodosum	2424	Bacteria	Bacteria	702	0	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g66966	i0	99.739	1.34455958549223	383	1	99	0	4	386	656149	655767	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	519	702	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
14884490	14884490	PRJNA879067_P_NODE_9492_length_1609_cov_9.753255_g7448_i0	PRJNA879067	9492	1609	9.753255	156.92987295	Fervidobacterium ngatamarikiense	3389972	Bacteria	Bacteria	2955	0	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g7448	i0	99.814	12.0024860161591	1609	3	100	0	1	1609	15735	17343	Fervidobacterium pennivorans strain DYC, complete genome	blastn	19312	2955	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
15267013	15267013	PRJNA879067_P_NODE_56892_length_471_cov_3.218593_g53407_i0	PRJNA879067	56892	471	3.218593	15.15957303	Fervidobacterium	2422	Bacteria	Bacteria	806	0	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g53407	i0	99.109	4.70912951167728	449	3	95	1	23	471	1664895	1665342	Fervidobacterium pennivorans strain DYC, complete genome	blastn	2218	806	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
18706466	18706466	PRJNA879067_P_NODE_41715_length_604_cov_2.465160_g38262_i0	PRJNA879067	41715	604	2.46516	14.8895664	Fervidobacterium ngatamarikiense	3389972	Bacteria	Bacteria	1099	0	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g38262	i0	99.503	5.94039735099338	604	3	100	0	1	604	731505	732108	Fervidobacterium pennivorans strain DYC, complete genome	blastn	3588	1099	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
18707466	18707466	PRJNA879067_P_NODE_77855_length_348_cov_2.701818_g74369_i0	PRJNA879067	77855	348	2.701818	9.40232664	Fervidobacterium ngatamarikiense	3389972	Bacteria	Bacteria	569	7.36e-158	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g74369	i0	99.054	3.16091954022989	317	3	91	0	1	317	1998874	1998558	Fervidobacterium pennivorans strain DYC, complete genome	blastn	1100	569	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
19981692	19981692	PRJNA879067_P_NODE_40976_length_612_cov_2.278293_g37524_i0	PRJNA879067	40976	612	2.278293	13.94315316	Fervidobacterium ngatamarikiense	3389972	Bacteria	Bacteria	1118	0	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g37524	i0	99.673	10.6454248366013	611	2	99	0	1	611	978460	977850	Fervidobacterium pennivorans strain DYC, complete genome	blastn	6515	1118	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
21257503	21257503	PRJNA879067_P_NODE_55237_length_483_cov_4.414634_g51752_i0	PRJNA879067	55237	483	4.414634	21.32268222	Fervidobacterium ngatamarikiense	3389972	Bacteria	Bacteria	881	0	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g51752	i0	99.586	1.99171842650104	483	2	100	0	1	483	123629	124111	Fervidobacterium pennivorans strain DYC, complete genome	blastn	962	881	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
21641157	21641157	PRJNA879067_P_NODE_51677_length_511_cov_2.684932_g48193_i0	PRJNA879067	51677	511	2.684932	13.72000252	Fervidobacterium	2422	Bacteria	Bacteria	878	0	NTclustered	gi\|1563174866\|gb\|CP026721.1\|	310769	g48193	i0	99.584	22.6046966731898	481	2	94	0	1	481	1128640	1128160	Fervidobacterium changbaicum strain CBS-1 chromosome	blastn	11551	878	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium changbaicum
22532671	22532671	PRJNA879067_P_NODE_7298_length_1858_cov_9.960224_g5545_i0	PRJNA879067	7298	1858	9.960224	185.06096192	Fervidobacterium ngatamarikiense	3389972	Bacteria	Bacteria	3343	0	NTclustered	gi\|1028457653\|gb\|CP011393.1\|	3389972	g5545	i0	99.618	6.13939720129171	1832	6	99	1	1	1831	188535	190366	Fervidobacterium pennivorans strain DYC, complete genome	blastn	11407	3343	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium ngatamarikiense
24190504	24190504	PRJNA879067_P_NODE_40239_length_620_cov_5.731261_g36793_i0	PRJNA879067	40239	620	5.731261	35.5338182	Fervidobacterium	2422	Bacteria	Bacteria	1009	0	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g36793	i0	96.585	4.92741935483871	615	9	97	5	18	620	1485848	1486462	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	3055	1009	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
25465585	25465585	PRJNA879067_P_NODE_25860_length_848_cov_5.975484_g22656_i0	PRJNA879067	25860	848	5.975484	50.67210432	Fervidobacterium	2422	Bacteria	Bacteria	1406	0	NTclustered	gi\|1829530204\|gb\|CP050868.1\|	3022686	g22656	i0	98.139	7.10259433962264	806	15	95	0	43	848	1913538	1914343	Fervidobacterium pennivorans subsp. keratinolyticus strain T chromosome, complete genome	blastn	6023	1406	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans

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