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

14 rows where analysis = "diamond", bioproject = "PRJNA611476" 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
1864922	1864922	PRJNA611476_P_NODE_115002_length_241_cov_1.511905_g114211_i0	PRJNA611476	115002	241	1.511905	3.64369105	Deinococcus	1298	Bacteria	Bacteria	144	1.79e-40	NR	WP_102128013.1	1737569	g114211	i0	92.5	1.99170124481328	80	6	99.6	0	1	240	99	178	WP_102128013.1 ABC transporter substrate-binding protein [Deinococcus planocerae]	diamond	480	144	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus planocerae
18441185	18441185	PRJNA611476_P_NODE_17635_length_471_cov_1.248744_g16845_i0	PRJNA611476	17635	471	1.248744	5.88158424	Mesotoga sp.	2053577	Bacteria	Bacteria	240	7.77e-74	NR	MCB1222954.1	2053577	g16845	i0	73.5	3.95541401273885	155	41	98.7	0	466	2	129	283	MCB1222954.1 molecular chaperone DnaK [Mesotoga sp.]	diamond	1863	240	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga sp.
26636919	26636919	PRJNA611476_P_NODE_104461_length_244_cov_0.900585_g103670_i0	PRJNA611476	104461	244	0.900585	2.1974274	Deinococcus budaensis	1665626	Bacteria	Bacteria	110	5.37e-26	NR	WP_184030793.1	1665626	g103670	i0	65.8	0.971311475409836	79	27	97.1	0	6	242	310	388	WP_184030793.1 type III restriction-modification system endonuclease [Deinococcus budaensis]	diamond	237	110	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
27396493	27396493	PRJNA611476_P_NODE_96163_length_247_cov_0.885057_g95372_i0	PRJNA611476	96163	247	0.885057	2.18609079	Trueperaceae bacterium	2026798	Bacteria	Bacteria	161	8.59e-45	NR	HZW27853.1	2026798	g95372	i0	100	0.995951417004049	82	0	99.6	0	2	247	32	113	HZW27853.1 GGDEF domain-containing protein [Trueperaceae bacterium]	diamond	246	161	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
27522464	27522464	PRJNA611476_P_NODE_117663_length_241_cov_0.916667_g116872_i0	PRJNA611476	117663	241	0.916667	2.20916747	Deinococcus antarcticus	1298767	Bacteria	Bacteria	125	4.02e-31	NR	WP_380075556.1	1298767	g116872	i0	74.4	2.91286307053942	78	20	97.1	0	8	241	761	838	WP_380075556.1 phage tail tape measure protein [Deinococcus antarcticus]	diamond	702	125	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
27693821	27693821	PRJNA611476_P_NODE_86024_length_249_cov_0.875000_g85233_i0	PRJNA611476	86024	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	86.7	1.39e-17	NR	MEM7735487.1	1913990	g85233	i0	53.8	4.81927710843374	80	36	95.2	1	3	239	113	192	MEM7735487.1 MBG domain-containing protein [Deinococcota bacterium]	diamond	1200	86.7	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
28280190	28280190	PRJNA611476_P_NODE_94086_length_247_cov_0.885057_g93295_i0	PRJNA611476	94086	247	0.885057	2.18609079	uncultured Cloacibacillus sp.	889794	Bacteria	Bacteria	165	1.64e-49	NR	WP_303149558.1	889794	g93295	i0	98.8	0.995951417004049	82	1	99.6	0	247	2	92	173	WP_303149558.1 hypothetical protein [uncultured Cloacibacillus sp.]	diamond	246	165	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Cloacibacillus	uncultured Cloacibacillus sp.
28343430	28343430	PRJNA611476_P_NODE_108526_length_243_cov_0.905882_g107735_i0	PRJNA611476	108526	243	0.905882	2.20129326	Deinococcales bacterium	2478479	Bacteria	Bacteria	118	2.21e-29	NR	NLG09778.1	2478479	g107735	i0	69.2	1.93827160493827	78	24	96.3	0	241	8	360	437	NLG09778.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Deinococcales bacterium]	diamond	471	118	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales			Deinococcales bacterium
29019914	29019914	PRJNA611476_P_NODE_43268_length_327_cov_0.909449_g42477_i0	PRJNA611476	43268	327	0.909449	2.97389823	Synergistes	2753	Bacteria	Bacteria	44.3	0.0286	NR	NLD06472.1	2053624	g42477	i0	29.4	4.67889908256881	85	46	78	3	43	297	153	223	NLD06472.1 glutamine synthetase type III [Synergistaceae bacterium]	diamond	1530	44.7	0.991051454138702	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29038435	29038435	PRJNA611476_P_NODE_87508_length_249_cov_0.875000_g86717_i0	PRJNA611476	87508	249	0.875	2.17875	Trueperaceae bacterium	2026798	Bacteria	Bacteria	42.7	0.0399	NR	MDZ7706041.1	2026798	g86717	i0	44.6	0.674698795180723	56	30	67.5	1	168	1	4	58	MDZ7706041.1 extracellular solute-binding protein [Trueperaceae bacterium]	diamond	168	42.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
31230577	31230577	PRJNA611476_P_NODE_83995_length_250_cov_0.870056_g83204_i0	PRJNA611476	83995	250	0.870056	2.17514	Deinococcus	1298	Bacteria	Bacteria	53.5	6.24e-6	NR	WP_380040596.1	309884	g83204	i0	35.4	2.952	82	49	98.4	1	1	246	75	152	WP_380040596.1 ROK family protein [Deinococcus navajonensis]	diamond	738	53.9	0.992578849721707	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus navajonensis
31818529	31818529	PRJNA611476_P_NODE_61577_length_282_cov_1.397129_g60786_i0	PRJNA611476	61577	282	1.397129	3.93990378	Trueperaceae bacterium	2026798	Bacteria	Bacteria	73.6	2.99e-13	NR	HEX7040708.1	2026798	g60786	i0	74.5	0.5	47	12	50	0	1	141	214	260	HEX7040708.1 EAL domain-containing protein [Trueperaceae bacterium]	diamond	141	73.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
31881724	31881724	PRJNA611476_P_NODE_35157_length_354_cov_0.928826_g34366_i0	PRJNA611476	35157	354	0.928826	3.28804404	Thermotogota bacterium	2053689	Bacteria	Bacteria	45.1	0.0179	NR	NPB04398.1	2053689	g34366	i0	36.9	0.711864406779661	84	33	60.2	3	311	99	125	201	NPB04398.1 DnaJ domain-containing protein [Thermotogota bacterium]	diamond	252	45.1	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
32293613	32293613	PRJNA611476_P_NODE_81759_length_250_cov_1.305085_g80968_i0	PRJNA611476	81759	250	1.305085	3.2627125	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	67	2.74e-12	NR	WP_367174111.1	158789	g80968	i0	52.2	0.828	69	33	82.8	0	3	209	4	72	WP_367174111.1 helix-turn-helix domain-containing protein [uncultured Deinococcus sp.]	diamond	207	67	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus 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);;