metadata: contig_metadata: 20 rows where bioproject = "PRJNA393181" and tax

20 rows where bioproject = "PRJNA393181" 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
410980	410980	PRJNA393181_S_NODE_7181_length_443_cov_2.312808_g7075_i0	PRJNA393181	7181	443	2.312808	10.24573944	Pseudothermotoga hypogea	57487	Bacteria	Bacteria	60.2	2.56e-4	NTclustered	gi\|744795267\|gb\|CP007141.1\|	1123384	g7075	i0	100	1.00677200902935	32	0	7	0	412	443	1961313	1961344	Pseudothermotoga hypogea DSM 11164 = NBRC 106472 chromosome, complete genome	blastn	446	60.2	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Pseudothermotoga	Pseudothermotoga hypogea
1685104	1685104	PRJNA393181_S_NODE_19662_length_266_cov_2.170306_g19556_i0	PRJNA393181	19662	266	2.170306	5.77301396	Trueperaceae bacterium	2026798	Bacteria	Bacteria	119	2.0299999999999997e-31	NR	MEX2501306.1	2026798	g19556	i0	62.8	3.85714285714286	86	32	97	0	265	8	23	108	MEX2501306.1 sulfatase-like hydrolase/transferase [Trueperaceae bacterium]	diamond	1026	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
5514119	5514119	PRJNA393181_S_NODE_2485_length_651_cov_2.938111_g2404_i0	PRJNA393181	2485	651	2.938111	19.12710261	Bacteria	2	Bacteria	Bacteria	237	2.36e-72	NR	WP_126202989.1	37636	g2404	i0	58.9	2.88018433179723	214	86	98.2	2	646	8	233	445	WP_126202989.1 undecaprenyl-phosphate galactose phosphotransferase WbaP [Thermus scotoductus]	diamond	1875	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
5514361	5514361	PRJNA393181_S_NODE_345_length_1116_cov_2.803522_g303_i0	PRJNA393181	345	1116	2.803522	31.28730552	Bacteria	2	Bacteria	Bacteria	259	6.93e-80	NR	MEX2502762.1	2026798	g303	i0	54.3	3.50806451612903	265	119	70.7	1	801	13	7	271	MEX2502762.1 LacI family DNA-binding transcriptional regulator [Trueperaceae bacterium]	diamond	3915	260	0.996153846153846	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
6181657	6181657	PRJNA393181_S_NODE_42365_length_162_cov_3.104000_g42259_i0	PRJNA393181	42365	162	3.104	5.02848	Bacteria	2	Bacteria	Bacteria	86.7	1.98e-18	NR	WP_013178764.1	332249	g42259	i0	80.4	5.96296296296296	46	9	85.2	0	161	24	303	348	WP_013178764.1 ABC transporter ATP-binding protein [Truepera radiovictrix]	diamond	966	86.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
8063400	8063400	PRJNA393181_S_NODE_14747_length_313_cov_62.264493_g14641_i0	PRJNA393181	14747	313	62.264493	194.88786309	Bacteria	2	Bacteria	Bacteria	99.4	1.55e-23	NR	WP_245971562.1	1408545	g14641	i0	49.5	4.96485623003195	99	41	86.3	1	272	3	24	122	WP_245971562.1 transposase [Calidithermus terrae]	diamond	1554	100	0.994	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus terrae
8063517	8063517	PRJNA393181_S_NODE_19507_length_267_cov_2.543478_g19401_i0	PRJNA393181	19507	267	2.543478	6.79108626	Trueperaceae bacterium	2026798	Bacteria	Bacteria	134	8.480000000000001e-27	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g19401	i0	78.404	0.797752808988764	213	40	79	6	5	214	2655718	2655509	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	213	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
9339146	9339146	PRJNA393181_S_NODE_7588_length_432_cov_2.916456_g7482_i0	PRJNA393181	7588	432	2.916456	12.59908992	Deinococcus yunweiensis	367282	Bacteria	Bacteria	183	1.42e-41	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g7482	i0	79.245	0.613425925925926	265	53	61	2	23	286	3247467	3247730	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	265	183	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
10006663	10006663	PRJNA393181_S_NODE_37068_length_178_cov_1.900709_g36962_i0	PRJNA393181	37068	178	1.900709	3.38326202	Deinococcus	1298	Bacteria	Bacteria	113	6.81e-21	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g36962	i0	85.714	57.9943820224719	112	11	61	4	2	110	1311129	1311238	Deinococcus swuensis strain DY59, complete genome	blastn	10323	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
11889251	11889251	PRJNA393181_S_NODE_27170_length_218_cov_1.988950_g27064_i0	PRJNA393181	27170	218	1.98895	4.335911	Deinococcus pimensis	309888	Bacteria	Bacteria	87.4	1.99e-18	NR	WP_027481337.1	309888	g27064	i0	73.6	1.44495412844037	53	14	72.9	0	214	56	286	338	WP_027481337.1 ABC transporter ATP-binding protein [Deinococcus pimensis]	diamond	315	87.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus pimensis
19536324	19536324	PRJNA393181_S_NODE_2936_length_618_cov_2.557659_g2850_i0	PRJNA393181	2936	618	2.557659	15.80633262	Trueperaceae bacterium	2026798	Bacteria	Bacteria	203	3.0299999999999997e-61	NR	MEX2540587.1	2026798	g2850	i0	68.7	1.45145631067961	150	47	72.8	0	616	167	156	305	MEX2540587.1 ABC transporter permease [Trueperaceae bacterium]	diamond	897	203	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
23362545	23362545	PRJNA393181_S_NODE_27079_length_218_cov_2.906077_g26973_i0	PRJNA393181	27079	218	2.906077	6.33524786	Deinococcota bacterium	1913990	Bacteria	Bacteria	99.4	2.83e-22	NR	MDQ3398911.1	1913990	g26973	i0	62	1.94036697247706	71	27	97.7	0	5	217	329	399	MDQ3398911.1 ABC transporter substrate-binding protein [Deinococcota bacterium]	diamond	423	99.4	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
24637139	24637139	PRJNA393181_S_NODE_4000_length_556_cov_2.416185_g3241_i1	PRJNA393181	4000	556	2.416185	13.4339886	Oceanithermus profundus	187137	Bacteria	Bacteria	388	3.67e-103	NTclustered	gi\|313151615\|gb\|CP002361.1\|	670487	g3241	i1	81	96.9370503597122	500	85	89	9	46	540	746568	746074	Oceanithermus profundus DSM 14977, complete genome	blastn	53897	388	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Oceanithermus	Oceanithermus profundus
26822316	26822316	PRJNA393181_S_NODE_5301_length_501_cov_2.898707_g5195_i0	PRJNA393181	5301	501	2.898707	14.52252207	Trueperaceae bacterium	2026798	Bacteria	Bacteria	196	1.5100000000000002e-58	NR	MEX2541980.1	2026798	g5195	i0	67.7	0.92814371257485	155	47	92.8	1	35	499	73	224	MEX2541980.1 2-dehydropantoate 2-reductase [Trueperaceae bacterium]	diamond	465	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
28307037	28307037	PRJNA393181_S_NODE_39686_length_170_cov_1.744361_g39580_i0	PRJNA393181	39686	170	1.744361	2.9654137	Trueperaceae bacterium	2026798	Bacteria	Bacteria	85.1	1.46e-17	NR	MEX2540588.1	2026798	g39580	i0	73.2	0.988235294117647	56	14	97.1	1	166	2	94	149	MEX2540588.1 M20/M25/M40 family metallo-hydrolase [Trueperaceae bacterium]	diamond	168	85.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
29492026	29492026	PRJNA393181_S_NODE_33390_length_191_cov_1.642857_g33284_i0	PRJNA393181	33390	191	1.642857	3.13785687	Bacteria	2	Bacteria	Bacteria	79	3.12e-15	NR	HRP48343.1	2026798	g33284	i0	56.7	1.8848167539267	60	26	94.2	0	185	6	110	169	HRP48343.1 sulfatase-like hydrolase/transferase [Trueperaceae bacterium]	diamond	360	79	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
29538317	29538317	PRJNA393181_S_NODE_22550_length_245_cov_2.399038_g22444_i0	PRJNA393181	22550	245	2.399038	5.8776431	Synergistaceae bacterium	2053624	Bacteria	Bacteria	52.4	1.41e-5	NR	MDD3917632.1	2053624	g22444	i0	54.5	1.76326530612245	44	20	53.9	0	10	141	274	317	MDD3917632.1 GDP-mannose 4,6-dehydratase [Synergistaceae bacterium]	diamond	432	52.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29822340	29822340	PRJNA393181_S_NODE_151_length_1369_cov_3.611862_g116_i0	PRJNA393181	151	1369	3.611862	49.44639078	Thermus thermophilus	274	Bacteria	Bacteria	166	1.0099999999999999e-42	NR	WP_353300005.1	274	g116	i0	35.2	2.94740686632579	335	208	73	6	290	1288	8	335	WP_353300005.1 O-antigen ligase family protein [Thermus thermophilus]	diamond	4035	166	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
30612291	30612291	PRJNA393181_S_NODE_30613_length_202_cov_1.975758_g30507_i0	PRJNA393181	30613	202	1.975758	3.99103116	Trueperaceae bacterium	2026798	Bacteria	Bacteria	67.4	4.47e-11	NR	UCH24864.1	2026798	g30507	i0	74.4	0.638613861386139	43	11	63.9	0	129	1	3	45	UCH24864.1 MAG: AAA family ATPase [Trueperaceae bacterium]	diamond	129	67.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
31971826	31971826	PRJNA393181_S_NODE_15938_length_300_cov_2.467681_g15832_i0	PRJNA393181	15938	300	2.467681	7.403043	Calidithermus sp.	3069153	Bacteria	Bacteria	57.8	1.56e-7	NR	HXG17186.1	3069153	g15832	i0	47.9	1.93	94	41	93	2	5	283	95	181	HXG17186.1 hypothetical protein [Calidithermus sp.]	diamond	579	57.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Calidithermus	Calidithermus sp.

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