metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA841653" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA841653" 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
3381416	3381416	PRJNA841653_P_NODE_39243_length_263_cov_1.610526_g38569_i0	PRJNA841653	39243	263	1.610526	4.23568338	Trueperaceae bacterium	2026798	Bacteria	Bacteria	62.4	4.95e-9	NR	MCA9835286.1	2026798	g38569	i0	46.3	0.935361216730038	82	44	93.5	0	5	250	165	246	MCA9835286.1 TolC family protein [Trueperaceae bacterium]	diamond	246	62.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
17408289	17408289	PRJNA841653_P_NODE_13894_length_442_cov_1.346883_g13223_i0	PRJNA841653	13894	442	1.346883	5.95322286	Bacteria	2	Bacteria	Bacteria	157	1.17e-44	NR	WP_309570828.1	47478	g13223	i0	65.2	25.0995475113122	138	48	93.7	0	421	8	21	158	WP_309570828.1 S8 family serine peptidase, partial [Deinococcus sp.]	diamond	11094	157	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
26706232	26706232	PRJNA841653_P_NODE_45761_length_250_cov_0.870056_g45087_i0	PRJNA841653	45761	250	0.870056	2.17514	Fervidobacterium sp.	1871331	Bacteria	Bacteria	134	6.91e-35	NR	HUM44566.1	1871331	g45087	i0	93.2	0.888	74	3	86.4	1	248	33	485	558	HUM44566.1 hypothetical protein [Fervidobacterium sp.]	diamond	222	134	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
27307759	27307759	PRJNA841653_P_NODE_53343_length_246_cov_0.890173_g52669_i0	PRJNA841653	53343	246	0.890173	2.18982558	Allomeiothermus silvanus	52022	Bacteria	Bacteria	168	2.99e-46	NR	MBI5813394.1	52022	g52669	i0	100	0.963414634146341	79	0	96.3	0	9	245	390	468	MBI5813394.1 hypothetical protein [Allomeiothermus silvanus]	diamond	237	168	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
27434165	27434165	PRJNA841653_P_NODE_35443_length_276_cov_1.280788_g34769_i0	PRJNA841653	35443	276	1.280788	3.53497488	Deinococcus betulae	2873312	Bacteria	Bacteria	137	3.829999999999999e-37	NR	WP_224571999.1	2873312	g34769	i0	71.9	0.967391304347826	89	25	96.7	0	10	276	119	207	WP_224571999.1 nucleotidyltransferase [Deinococcus betulae]	diamond	267	137	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus betulae
28317981	28317981	PRJNA841653_P_NODE_25086_length_326_cov_0.913043_g24412_i0	PRJNA841653	25086	326	0.913043	2.97652018	Deinococcota bacterium	1913990	Bacteria	Bacteria	103	3.89e-23	NR	MEM6427694.1	1913990	g24412	i0	56.6	2.88036809815951	106	36	89.3	2	1	291	367	471	MEM6427694.1 DHA2 family efflux MFS transporter permease subunit [Deinococcota bacterium]	diamond	939	103	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
28317999	28317999	PRJNA841653_P_NODE_54566_length_245_cov_0.895349_g53892_i0	PRJNA841653	54566	245	0.895349	2.19360505	Synergistaceae bacterium OttesenSCG-928-D05	2885227	Bacteria	Bacteria	105	1.94e-25	NR	MDL2298784.1	2885227	g53892	i0	59	0.955102040816327	78	32	95.5	0	11	244	147	224	MDL2298784.1 hypothetical protein [Synergistaceae bacterium OttesenSCG-928-D05]	diamond	234	105	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium OttesenSCG-928-D05
29107469	29107469	PRJNA841653_P_NODE_59308_length_242_cov_0.911243_g58634_i0	PRJNA841653	59308	242	0.911243	2.20520806	Deinococcus aquiradiocola	393059	Bacteria	Bacteria	158	7.23e-43	NR	WP_188964856.1	393059	g58634	i0	97.4	0.966942148760331	78	2	96.7	0	241	8	733	810	WP_188964856.1 GAF domain-containing protein [Deinococcus aquiradiocola]	diamond	234	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquiradiocola
30474064	30474064	PRJNA841653_P_NODE_59653_length_242_cov_0.911243_g58979_i0	PRJNA841653	59653	242	0.911243	2.20520806	Truepera	332248	Bacteria	Bacteria	132	4.63e-34	NR	CAA9560764.1	543023	g58979	i0	88.6	3.91735537190083	79	9	97.9	0	5	241	34	112	CAA9560764.1 MAG: D-3-phosphoglycerate dehydrogenase [uncultured Truepera sp.]	diamond	948	132	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
31634859	31634859	PRJNA841653_P_NODE_48916_length_248_cov_0.880000_g48242_i0	PRJNA841653	48916	248	0.88	2.1824	Deinococcus	1298	Bacteria	Bacteria	122	3.83e-30	NR	WP_013614556.1	1298	g48242	i0	76.5	0.979838709677419	81	19	98	0	245	3	315	395	WP_013614556.1 MULTISPECIES: DNA-directed RNA polymerase subunit beta' [Deinococcus]	diamond	243	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
32046261	32046261	PRJNA841653_P_NODE_39318_length_263_cov_1.336842_g38644_i0	PRJNA841653	39318	263	1.336842	3.51589446	uncultured Truepera sp.	543023	Bacteria	Bacteria	94.7	7.88e-21	NR	CAA9579596.1	543023	g38644	i0	69.4	0.707224334600761	62	19	70.7	0	254	69	219	280	CAA9579596.1 MAG: Glycine betaine/L-proline transport ATP-binding protein ProV [uncultured Truepera sp.]	diamond	186	94.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera 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);;