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

15 rows where analysis = "diamond", bioproject = "PRJEB10140" and tax_phylum = "Deinococcota"

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
11185667	11185667	PRJEB10140_P_NODE_30449_length_1118_cov_11.699719_g18635_i0	PRJEB10140	30449	1118	11.699719	130.80285842	Deinococcus multiflagellatus	1656887	Bacteria	Bacteria	303	3.619999999999999e-95	NR	WP_224605023.1	1656887	g18635	i0	50.4	0.974060822898032	363	162	97.4	5	1117	29	59	403	WP_224605023.1 S8 family peptidase [Deinococcus multiflagellatus]	diamond	1089	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus multiflagellatus
11491002	11491002	PRJEB10140_P_NODE_29890_length_1135_cov_9.259669_g18235_i0	PRJEB10140	29890	1135	9.259669	105.09724315	root	1	Root_unresolved	Root_unresolved	257	4.04e-77	NR	WP_013623097.1	1298	g18235	i0	43.5	28.0017621145374	368	188	95.9	9	6	1094	66	418	WP_013623097.1 MULTISPECIES: S8 family peptidase [Deinococcus]	diamond	31782	259	0.992277992277992	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
14040580	14040580	PRJEB10140_P_NODE_256792_length_167_cov_0.881356_g239483_i0	PRJEB10140	256792	167	0.881356	1.47186452	uncultured Truepera sp.	543023	Bacteria	Bacteria	104	4.9e-26	NR	CAA9579776.1	543023	g239483	i0	92.6	0.970059880239521	54	4	97	0	167	6	75	128	CAA9579776.1 MAG: Transcriptional regulator, HxlR family [uncultured Truepera sp.]	diamond	162	104	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27380482	27380482	PRJEB10140_P_NODE_217443_length_184_cov_1.496296_g200134_i0	PRJEB10140	217443	184	1.496296	2.75318464	uncultured Truepera sp.	543023	Bacteria	Bacteria	106	1.65e-25	NR	CAA9572549.1	543023	g200134	i0	84.2	0.929347826086957	57	9	92.9	0	1	171	346	402	CAA9572549.1 MAG: Adenylosuccinate synthetase [uncultured Truepera sp.]	diamond	171	106	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27538298	27538298	PRJEB10140_P_NODE_284084_length_163_cov_0.903509_g266775_i0	PRJEB10140	284084	163	0.903509	1.47271967	Deinococcus proteolyticus	55148	Bacteria	Bacteria	93.2	1.68e-20	NR	WP_041222050.1	55148	g266775	i0	81.5	1.98773006134969	54	10	99.4	0	162	1	32	85	WP_041222050.1 RNB domain-containing ribonuclease [Deinococcus proteolyticus]	diamond	324	93.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
27822559	27822559	PRJEB10140_P_NODE_268324_length_165_cov_0.896552_g251015_i0	PRJEB10140	268324	165	0.896552	1.4793108	Allomeiothermus silvanus	52022	Bacteria	Bacteria	100	3.36e-23	NR	WP_273049399.1	52022	g251015	i0	92.6	0.981818181818182	54	4	98.2	0	3	164	352	405	WP_273049399.1 Trk system potassium transporter TrkA [Allomeiothermus silvanus]	diamond	162	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
28169664	28169664	PRJEB10140_P_NODE_251746_length_168_cov_0.873950_g234437_i0	PRJEB10140	251746	168	0.87395	1.468236	Deinococcus sp.	47478	Bacteria	Bacteria	103	6.4599999999999986e-24	NR	MDB5045222.1	47478	g234437	i0	98.2	0.982142857142857	55	1	98.2	0	3	167	435	489	MDB5045222.1 primosomal protein [Deinococcus sp.]	diamond	165	103	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
28485476	28485476	PRJEB10140_P_NODE_292387_length_162_cov_0.893805_g275078_i0	PRJEB10140	292387	162	0.893805	1.4479641	Trueperaceae bacterium	2026798	Bacteria	Bacteria	94.4	7.270000000000001e-21	NR	HET8985603.1	2026798	g275078	i0	96.3	1	54	2	100	0	162	1	84	137	HET8985603.1 potassium/proton antiporter [Trueperaceae bacterium]	diamond	162	94.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
28643445	28643445	PRJEB10140_P_NODE_245607_length_169_cov_0.866667_g228298_i0	PRJEB10140	245607	169	0.866667	1.46466723	Deinococcus hopiensis	309885	Bacteria	Bacteria	41.6	0.0048	NR	WP_084050496.1	309885	g228298	i0	53.3	0.532544378698225	30	14	53.3	0	7	96	27	56	WP_084050496.1 hypothetical protein [Deinococcus hopiensis]	diamond	90	41.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus hopiensis
28674959	28674959	PRJEB10140_P_NODE_284787_length_163_cov_0.894737_g267478_i0	PRJEB10140	284787	163	0.894737	1.45842131	Deinococcus kurensis	2662757	Bacteria	Bacteria	57	1.18e-7	NR	WP_155299040.1	2662757	g267478	i0	45.6	1.04907975460123	57	27	97.5	1	2	160	259	315	WP_155299040.1 hypothetical protein [Deinococcus kurensis]	diamond	171	57	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus kurensis
29022558	29022558	PRJEB10140_P_NODE_259568_length_167_cov_0.872881_g242259_i0	PRJEB10140	259568	167	0.872881	1.45771127	Deinococcus aquatilis	519440	Bacteria	Bacteria	110	2.52e-26	NR	WP_019008891.1	519440	g242259	i0	98.2	0.988023952095808	55	1	98.8	0	166	2	748	802	WP_019008891.1 FHA domain-containing serine/threonine-protein kinase [Deinococcus aquatilis]	diamond	165	110	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquatilis
30475109	30475109	PRJEB10140_P_NODE_278033_length_164_cov_0.895652_g260724_i0	PRJEB10140	278033	164	0.895652	1.46886928	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	79.7	1.17e-15	NR	WP_339096211.1	3385567	g260724	i0	73.1	0.951219512195122	52	14	95.1	0	162	7	879	930	WP_339096211.1 DNA methyltransferase [Deinococcus sp. VB343]	diamond	156	79.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
30822496	30822496	PRJEB10140_P_NODE_220554_length_182_cov_1.563910_g203245_i0	PRJEB10140	220554	182	1.56391	2.8463162	Trueperaceae bacterium	2026798	Bacteria	Bacteria	103	8.27e-24	NR	MCA9836966.1	2026798	g203245	i0	75	5.71978021978022	60	15	98.9	0	1	180	400	459	MCA9836966.1 S9 family peptidase [Trueperaceae bacterium]	diamond	1041	103	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
31360009	31360009	PRJEB10140_P_NODE_276576_length_164_cov_0.904348_g259267_i0	PRJEB10140	276576	164	0.904348	1.48313072	Meiothermus granaticius	863370	Bacteria	Bacteria	52	6.85e-6	NR	WP_147021149.1	863370	g259267	i0	60	1.57317073170732	45	17	80.5	1	136	5	4	48	WP_147021149.1 hypothetical protein [Meiothermus granaticius]	diamond	258	52	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus granaticius
32467361	32467361	PRJEB10140_P_NODE_281579_length_163_cov_0.912281_g264270_i0	PRJEB10140	281579	163	0.912281	1.48701803	Truepera radiovictrix	332249	Bacteria	Bacteria	73.6	9.03e-14	NR	WP_013178466.1	332249	g264270	i0	74	0.920245398773006	50	13	92	0	160	11	245	294	WP_013178466.1 pseudouridine-5'-phosphate glycosidase [Truepera radiovictrix]	diamond	150	73.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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