metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA615351" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA615351" and tax_kingdom = "Thermotogati"

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
27080427	27080427	PRJNA615351_P_NODE_20382_length_1449_cov_3.973126_g14153_i1	PRJNA615351	20382	1449	3.973126	57.57059574	Marinitoga aeolica	2809031	Bacteria	Bacteria	52	0.0061	NR	WP_280998107.1	2809031	g14153	i1	23.5	0.316770186335404	153	114	31.7	1	332	790	63	212	WP_280998107.1 methyl-accepting chemotaxis protein [Marinitoga aeolica]	diamond	459	52	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga aeolica
27093299	27093299	PRJNA615351_P_NODE_114582_length_266_cov_0.965368_g100483_i0	PRJNA615351	114582	266	0.965368	2.56787888	Bacteria	2	Bacteria	Bacteria	44.3	0.0143	NR	MBQ6969619.1	2053624	g100483	i0	38.9	2.3796992481203	54	23	60.9	1	163	2	672	715	MBQ6969619.1 hypothetical protein [Synergistaceae bacterium]	diamond	633	44.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
27680927	27680927	PRJNA615351_P_NODE_152284_length_187_cov_1.052632_g138184_i0	PRJNA615351	152284	187	1.052632	1.96842184	Trueperaceae bacterium	2026798	Bacteria	Bacteria	42.4	0.0244	NR	MEX2534109.1	2026798	g138184	i0	38.3	0.962566844919786	60	33	89.8	1	7	174	239	298	MEX2534109.1 hypothetical protein [Trueperaceae bacterium]	diamond	180	42.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
28217071	28217071	PRJNA615351_P_NODE_111866_length_274_cov_1.665272_g97767_i0	PRJNA615351	111866	274	1.665272	4.56284528	Thermovirga lienii	336261	Bacteria	Bacteria	45.8	0.00403	NR	WP_014163196.1	336261	g97767	i0	60.5	0.843065693430657	43	14	47.1	2	267	139	240	279	WP_014163196.1 polyamine aminopropyltransferase [Thermovirga lienii]	diamond	231	45.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Thermovirgaceae	Thermovirga	Thermovirga lienii
28596576	28596576	PRJNA615351_P_NODE_90467_length_363_cov_2.222561_g76388_i0	PRJNA615351	90467	363	2.222561	8.06789643	Deinococcus carri	1211323	Bacteria	Bacteria	74.3	1e-12	NR	GAA5511987.1	1211323	g76388	i0	41.9	0.768595041322314	93	52	76	2	332	57	18	109	GAA5511987.1 hypothetical protein Dcar01_00701 [Deinococcus carri]	diamond	279	74.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus carri
29303843	29303843	PRJNA615351_P_NODE_93169_length_349_cov_2.547771_g79083_i0	PRJNA615351	93169	349	2.547771	8.89172079	Deinococcus	1298	Bacteria	Bacteria	51.2	1.3e-4	NR	WP_052351547.1	309888	g79083	i0	33.3	5.77650429799427	111	70	95.4	3	14	346	153	259	WP_052351547.1 Ig-like domain-containing protein [Deinococcus pimensis]	diamond	2016	51.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus pimensis
30965204	30965204	PRJNA615351_P_NODE_158274_length_179_cov_1.243056_g144174_i0	PRJNA615351	158274	179	1.243056	2.22507024	Allomeiothermus silvanus	52022	Bacteria	Bacteria	49.3	6.79e-5	NR	WP_013158102.1	52022	g144174	i0	45.8	3.93854748603352	48	23	75.4	1	144	10	93	140	WP_013158102.1 serine/threonine-protein kinase [Allomeiothermus silvanus]	diamond	705	49.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
31280998	31280998	PRJNA615351_P_NODE_135195_length_215_cov_1.777778_g121095_i0	PRJNA615351	135195	215	1.777778	3.8222227	Deinococcus oregonensis	1805970	Bacteria	Bacteria	50.4	4.23e-5	NR	WP_380007841.1	1805970	g121095	i0	41	0.851162790697674	61	33	80.9	1	1	174	46	106	WP_380007841.1 trypsin-like serine peptidase [Deinococcus oregonensis]	diamond	183	50.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus oregonensis
31376046	31376046	PRJNA615351_P_NODE_122376_length_244_cov_1.655502_g108276_i0	PRJNA615351	122376	244	1.655502	4.03942488	Synergistaceae bacterium	2053624	Bacteria	Bacteria	92.8	8.82e-20	NR	HOU33238.1	2053624	g108276	i0	55.8	5.68032786885246	77	34	94.7	0	239	9	99	175	HOU33238.1 S8 family serine peptidase [Synergistaceae bacterium]	diamond	1386	92.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
31439170	31439170	PRJNA615351_P_NODE_19556_length_1483_cov_3.973066_g14153_i0	PRJNA615351	19556	1483	3.973066	58.92056878	Marinitoga aeolica	2809031	Bacteria	Bacteria	52	0.00634	NR	WP_280998107.1	2809031	g14153	i0	23.5	0.309507754551585	153	114	31	1	1118	660	63	212	WP_280998107.1 methyl-accepting chemotaxis protein [Marinitoga aeolica]	diamond	459	52	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga aeolica
31515728	31515728	PRJNA615351_P_NODE_38416_length_931_cov_3.946429_g28459_i0	PRJNA615351	38416	931	3.946429	36.74125399	Deinococcus	1298	Bacteria	Bacteria	202	1.59e-58	NR	WP_034388996.1	1540221	g28459	i0	40.5	6.83458646616541	299	155	95.1	6	38	922	82	361	WP_034388996.1 aldose epimerase family protein [Deinococcus sp. YIM 77859]	diamond	6363	202	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. YIM 77859
31660501	31660501	PRJNA615351_P_NODE_2397_length_3425_cov_5.661652_g1663_i0	PRJNA615351	2397	3425	5.661652	193.911581	Thermosipho africanus	2421	Bacteria	Bacteria	73.6	1.64e-9	NR	WP_051001529.1	2421	g1663	i0	29	0.362627737226277	207	126	17.3	7	478	1068	21	216	WP_051001529.1 M16 family metallopeptidase [Thermosipho africanus]	diamond	1242	73.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho africanus
31692346	31692346	PRJNA615351_P_NODE_40797_length_885_cov_2.283529_g30329_i0	PRJNA615351	40797	885	2.283529	20.20923165	Thermus sp. 2.9	1577051	Bacteria	Bacteria	53.1	3.96e-4	NR	WP_039459017.1	1577051	g30329	i0	37.5	0.271186440677966	80	47	26.1	1	470	240	115	194	WP_039459017.1 alpha/beta hydrolase [Thermus sp. 2.9]	diamond	240	53.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. 2.9
31831536	31831536	PRJNA615351_P_NODE_174957_length_160_cov_2.416000_g160857_i0	PRJNA615351	174957	160	2.416	3.8656	Bacteria	2	Bacteria	Bacteria	43.5	0.00626	NR	HOZ12969.1	2053689	g160857	i0	37.5	3.15	56	28	91.9	2	6	152	262	317	HOZ12969.1 glycosyltransferase family 4 protein [Thermotogota bacterium]	diamond	504	43.5	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
32167031	32167031	PRJNA615351_P_NODE_17778_length_1561_cov_11.463303_g12856_i0	PRJNA615351	17778	1561	11.463303	178.94215983	Thermotogota bacterium	2053689	Bacteria	Bacteria	61.2	7.13e-6	NR	HCZ05867.1	2053689	g12856	i0	23.2	0.390134529147982	203	136	38.4	5	1229	630	144	329	HCZ05867.1 glutamate--tRNA ligase [Thermotogota bacterium]	diamond	609	61.2	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
32452006	32452006	PRJNA615351_P_NODE_73259_length_474_cov_16.002278_g59299_i0	PRJNA615351	73259	474	16.002278	75.85079772	Geotoga petraea	28234	Bacteria	Bacteria	46.2	0.0165	NR	WP_135402796.1	28234	g59299	i0	30.4	0.436708860759494	69	48	43.7	0	13	219	4	72	WP_135402796.1 SDR family NAD(P)-dependent oxidoreductase [Geotoga petraea]	diamond	207	46.2	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Geotoga	Geotoga petraea

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