metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1104180" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1104180" 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
10415880	10415880	PRJNA1104180_P_NODE_27069_length_235_cov_2.444444_g26926_i0	PRJNA1104180	27069	235	2.444444	5.7444434	Truepera radiovictrix	332249	Bacteria	Bacteria	139	4.39e-37	NR	WP_013179101.1	332249	g26926	i0	80.8	0.995744680851064	78	15	99.6	0	234	1	347	424	WP_013179101.1 SDR family oxidoreductase [Truepera radiovictrix]	diamond	234	139	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
15514984	15514984	PRJNA1104180_P_NODE_21193_length_249_cov_1.750000_g21050_i0	PRJNA1104180	21193	249	1.75	4.3575	Deinococcus metallilatus	1211322	Bacteria	Bacteria	151	5.46e-45	NR	WP_129120003.1	1211322	g21050	i0	90.2	2.96385542168675	82	8	98.8	0	249	4	43	124	WP_129120003.1 hypothetical protein [Deinococcus metallilatus]	diamond	738	151	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
21889025	21889025	PRJNA1104180_P_NODE_12658_length_291_cov_1.908257_g12516_i0	PRJNA1104180	12658	291	1.908257	5.55302787	Bacteria	2	Bacteria	Bacteria	179	2.98e-50	NR	1TAQ_A	271	g12516	i0	100	2.96907216494845	96	0	99	0	3	290	714	809	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	864	179	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
26814643	26814643	PRJNA1104180_P_NODE_14781_length_279_cov_1.004854_g14639_i0	PRJNA1104180	14781	279	1.004854	2.80354266	Deinococcus soli (ex Cha et al. 2	1309411	Bacteria	Bacteria	104	9.719999999999999e-24	NR	WP_309856082.1	1309411	g14639	i0	56.8	0.946236559139785	88	38	94.6	0	7	270	164	251	WP_309856082.1 DUF4132 domain-containing protein [Deinococcus soli (ex Cha et al. 2016)]	diamond	264	104	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
27731409	27731409	PRJNA1104180_P_NODE_24524_length_244_cov_0.900585_g24381_i0	PRJNA1104180	24524	244	0.900585	2.1974274	Deinococcus fonticola	2528713	Bacteria	Bacteria	87.4	7.07e-19	NR	WP_240738273.1	2528713	g24381	i0	95.7	0.565573770491803	46	2	56.6	0	138	1	1	46	WP_240738273.1 HepT-like ribonuclease domain-containing protein [Deinococcus fonticola]	diamond	138	87.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus fonticola
28385419	28385419	PRJNA1104180_P_NODE_22606_length_247_cov_0.885057_g22463_i0	PRJNA1104180	22606	247	0.885057	2.18609079	Deinococcus	1298	Bacteria	Bacteria	134	8.8e-39	NR	WP_233554463.1	2320857	g22463	i0	97.1	1.65182186234818	68	2	82.6	0	204	1	1	68	WP_233554463.1 Uma2 family endonuclease [Deinococcus cavernae]	diamond	408	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
28930981	28930981	PRJNA1104180_P_NODE_12488_length_292_cov_2.351598_g12346_i0	PRJNA1104180	12488	292	2.351598	6.86666616	Deinococcus terrestris	2651870	Bacteria	Bacteria	189	2.79e-53	NR	WP_152872309.1	2651870	g12346	i0	94.1	3.14383561643836	102	1	99.7	1	1	291	687	788	WP_152872309.1 Tn3 family transposase [Deinococcus terrestris]	diamond	918	189	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus terrestris
29435774	29435774	PRJNA1104180_P_NODE_12530_length_292_cov_1.570776_g12388_i0	PRJNA1104180	12530	292	1.570776	4.58666592	Deinococcus planocerae	1737569	Bacteria	Bacteria	72.4	2.54e-12	NR	WP_102128478.1	1737569	g12388	i0	41.1	0.976027397260274	95	54	97.6	1	291	7	198	290	WP_102128478.1 type IV secretory system conjugative DNA transfer family protein [Deinococcus planocerae]	diamond	285	72.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus planocerae
29435776	29435776	PRJNA1104180_P_NODE_21390_length_249_cov_0.875000_g21247_i0	PRJNA1104180	21390	249	0.875	2.17875	Trueperaceae bacterium	2026798	Bacteria	Bacteria	62.8	3.17e-9	NR	HKI57679.1	2026798	g21247	i0	55.6	0.650602409638554	54	23	65.1	1	163	2	300	352	HKI57679.1 SPOR domain-containing protein [Trueperaceae bacterium]	diamond	162	62.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
30320999	30320999	PRJNA1104180_P_NODE_12872_length_290_cov_1.165899_g12730_i0	PRJNA1104180	12872	290	1.165899	3.3811071	Truepera radiovictrix	332249	Bacteria	Bacteria	73.2	1.27e-12	NR	WP_041947694.1	332249	g12730	i0	69.2	0.537931034482759	52	16	53.8	0	157	2	1	52	WP_041947694.1 ABC transporter substrate-binding protein [Truepera radiovictrix]	diamond	156	73.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
31299995	31299995	PRJNA1104180_P_NODE_19375_length_254_cov_2.718232_g19232_i0	PRJNA1104180	19375	254	2.718232	6.90430928	Truepera radiovictrix	332249	Bacteria	Bacteria	132	4.7200000000000004e-36	NR	WP_245523520.1	332249	g19232	i0	76.2	0.992125984251969	84	20	99.2	0	253	2	158	241	WP_245523520.1 polyphosphate--glucose phosphotransferase [Truepera radiovictrix]	diamond	252	132	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
31521564	31521564	PRJNA1104180_P_NODE_19376_length_254_cov_2.569061_g19233_i0	PRJNA1104180	19376	254	2.569061	6.52541494	Deinococcus aestuarii	2774531	Bacteria	Bacteria	96.3	4.99e-22	NR	WP_216326410.1	2774531	g19233	i0	87.7	1.41732283464567	57	6	67.3	1	254	84	209	264	WP_216326410.1 urea ABC transporter ATP-binding protein UrtD [Deinococcus aestuarii]	diamond	360	96.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
32027610	32027610	PRJNA1104180_P_NODE_22958_length_246_cov_1.780347_g22815_i0	PRJNA1104180	22958	246	1.780347	4.37965362	Truepera radiovictrix	332249	Bacteria	Bacteria	87.4	6.49e-18	NR	WP_041947208.1	332249	g22815	i0	51.3	0.975609756097561	80	39	97.6	0	244	5	215	294	WP_041947208.1 hypothetical protein [Truepera radiovictrix]	diamond	240	87.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
32122664	32122664	PRJNA1104180_P_NODE_22718_length_247_cov_0.885057_g22575_i0	PRJNA1104180	22718	247	0.885057	2.18609079	Truepera radiovictrix	332249	Bacteria	Bacteria	77.8	1.82e-14	NR	WP_013177318.1	332249	g22575	i0	72.5	0.619433198380567	51	14	61.9	0	95	247	1	51	WP_013177318.1 preprotein translocase subunit SecA [Truepera radiovictrix]	diamond	153	77.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
32470742	32470742	PRJNA1104180_P_NODE_18399_length_259_cov_1.354839_g18257_i0	PRJNA1104180	18399	259	1.354839	3.50903301	Deinococcus aestuarii	2774531	Bacteria	Bacteria	56.6	4.16e-7	NR	WP_216317549.1	2774531	g18257	i0	100	0.28957528957529	25	0	29	0	77	3	1	25	WP_216317549.1 intradiol ring-cleavage dioxygenase [Deinococcus aestuarii]	diamond	75	56.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii

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