metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA888821" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA888821" 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
26714801	26714801	PRJNA888821_P_NODE_42521_length_230_cov_4.203822_g42438_i0	PRJNA888821	42521	230	4.203822	9.6687906	Thermus	270	Bacteria	Bacteria	122	5.37e-32	NR	WP_126165588.1	270	g42438	i0	80.3	2.77826086956522	71	14	92.6	0	18	230	180	250	WP_126165588.1 MULTISPECIES: ABC transporter ATP-binding protein [Thermus]	diamond	639	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus
27063331	27063331	PRJNA888821_P_NODE_3522_length_372_cov_11.732441_g3441_i0	PRJNA888821	3522	372	11.732441	43.64468052	Bacteria candidate phyla	1783234	Bacteria	Bacteria	89.7	4.65e-18	NR	WP_299079334.1	1678694	g3441	i0	62.7	4.2741935483871	75	28	60.5	0	2	226	61	135	WP_299079334.1 ATPase domain-containing protein, partial [uncultured Fretibacterium sp.]	diamond	1590	90.1	0.995560488346282	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
27813856	27813856	PRJNA888821_P_NODE_50784_length_203_cov_10.992308_g50701_i0	PRJNA888821	50784	203	10.992308	22.31438524	Deinococcus sp. JMULE3	2518341	Bacteria	Bacteria	129	9.35e-37	NR	WP_174366166.1	2518341	g50701	i0	95.5	0.990147783251232	67	3	99	0	203	3	59	125	WP_174366166.1 hypothetical protein [Deinococcus sp. JMULE3]	diamond	201	129	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. JMULE3
28129449	28129449	PRJNA888821_P_NODE_39225_length_241_cov_3.809524_g39142_i0	PRJNA888821	39225	241	3.809524	9.18095284	Deinococcus sp. DB	47478	Bacteria	Bacteria	154	2.84e-41	NR	WP_198297316.1	2479203	g39142	i0	100	0.983402489626556	79	0	98.3	0	239	3	337	415	WP_198297316.1 AAA family ATPase [Deinococcus sp. DB0503]	diamond	237	154	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. DB0503
28950495	28950495	PRJNA888821_P_NODE_19288_length_310_cov_3.291139_g19206_i0	PRJNA888821	19288	310	3.291139	10.2025309	Thermus scotoductus	37636	Bacteria	Bacteria	194	3.4e-55	NR	WP_279165029.1	37636	g19206	i0	97.1	1.99354838709677	103	3	99.7	0	309	1	93	195	WP_279165029.1 hypothetical protein [Thermus scotoductus]	diamond	618	194	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
28989983	28989983	PRJNA888821_P_NODE_25928_length_288_cov_9.711628_g25846_i0	PRJNA888821	25928	288	9.711628	27.96948864	Pyramidobacter	638847	Bacteria	Bacteria	59.7	7.45e-8	NR	WP_244389476.1	638849	g25846	i0	44.3	2.46875	79	30	67.7	1	1	195	1026	1104	WP_244389476.1 hypothetical protein [Pyramidobacter piscolens]	diamond	711	59.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
29392417	29392417	PRJNA888821_P_NODE_45369_length_220_cov_5.612245_g45286_i0	PRJNA888821	45369	220	5.612245	12.346939	Thermus albus	2908146	Bacteria	Bacteria	115	1.17e-28	NR	WP_243028551.1	2908146	g45286	i0	95.1	0.831818181818182	61	3	83.2	0	183	1	1	61	WP_243028551.1 phage portal protein [Thermus albus]	diamond	183	115	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus albus
29392419	29392419	PRJNA888821_P_NODE_47129_length_214_cov_8.702128_g47046_i0	PRJNA888821	47129	214	8.702128	18.62255392	Thermus sp. PS18	2849039	Bacteria	Bacteria	94	1.82e-20	NR	WP_267262229.1	2849039	g47046	i0	69.7	0.925233644859813	66	20	92.5	0	3	200	158	223	WP_267262229.1 DUF2586 family protein [Thermus sp. PS18]	diamond	198	94	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
29518504	29518504	PRJNA888821_P_NODE_28730_length_275_cov_9.990099_g28648_i0	PRJNA888821	28730	275	9.990099	27.47277225	Deinococcus sp. UR1	1704277	Bacteria	Bacteria	108	2.98e-25	NR	WP_099749518.1	1704277	g28648	i0	63.3	1.96363636363636	90	32	98.2	1	274	5	1419	1507	WP_099749518.1 helicase-related protein [Deinococcus sp. UR1]	diamond	540	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. UR1
30086980	30086980	PRJNA888821_P_NODE_22812_length_307_cov_6.606838_g22730_i0	PRJNA888821	22812	307	6.606838	20.28299266	Deinococcus multiflagellatus	1656887	Bacteria	Bacteria	107	2.12e-24	NR	WP_224612457.1	1656887	g22730	i0	84.2	0.55700325732899	57	9	55.7	0	307	137	50	106	WP_224612457.1 tyrosine-type recombinase/integrase [Deinococcus multiflagellatus]	diamond	171	107	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus multiflagellatus
30284922	30284922	PRJNA888821_P_NODE_26412_length_286_cov_5.633803_g26330_i0	PRJNA888821	26412	286	5.633803	16.11267658	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	138	1.43e-36	NR	MDQ3461275.1	1913990	g26330	i0	80.3	8.75874125874126	76	15	79.7	0	232	5	1	76	MDQ3461275.1 glycine--tRNA ligase [Deinococcota bacterium]	diamond	2505	139	0.992805755395683	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
30403458	30403458	PRJNA888821_P_NODE_27713_length_280_cov_3.888889_g27631_i0	PRJNA888821	27713	280	3.888889	10.8888892	Deinococcus sp. HSC-46F16	2910968	Bacteria	Bacteria	105	5.2099999999999996e-24	NR	WP_253581580.1	2910968	g27631	i0	70.7	0.878571428571429	82	22	85.7	2	241	2	1	82	WP_253581580.1 ATP-binding protein [Deinococcus sp. HSC-46F16]	diamond	246	105	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. HSC-46F16
31097996	31097996	PRJNA888821_P_NODE_49875_length_206_cov_5.240602_g49792_i0	PRJNA888821	49875	206	5.240602	10.79564012	Deinococcus xianganensis	1507289	Bacteria	Bacteria	137	1.14e-35	NR	WP_160978575.1	1507289	g49792	i0	100	0.990291262135922	68	0	99	0	204	1	604	671	WP_160978575.1 CRISPR-associated helicase Cas3' [Deinococcus xianganensis]	diamond	204	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xianganensis
32553515	32553515	PRJNA888821_P_NODE_19379_length_310_cov_3.194093_g19297_i0	PRJNA888821	19379	310	3.194093	9.9016883	Deinococcus budaensis	1665626	Bacteria	Bacteria	91.7	2.09e-21	NR	WP_380003166.1	1665626	g19297	i0	95.7	0.445161290322581	46	2	44.5	0	161	298	6	51	WP_380003166.1 TniQ family protein [Deinococcus budaensis]	diamond	138	91.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis

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