metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA853203" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA853203" 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	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
11045185	11045185	PRJNA853203_P_NODE_40969_length_245_cov_1.412791_g40820_i0	PRJNA853203	40969	245	1.412791	3.46133795	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	155	2.87e-44	NR	WP_299298978.1	1678694	g40820	i0	93.8	0.979591836734694	80	5	98	5	244	19	98	WP_299298978.1 glycosyltransferase [uncultured Fretibacterium sp.]	diamond	240	155	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
13595037	13595037	PRJNA853203_P_NODE_10611_length_287_cov_1.906542_g10462_i0	PRJNA853203	10611	287	1.906542	5.47177554	uncultured Truepera sp.	543023	Bacteria	Bacteria	132	7.53e-36	NR	CAA9554733.1	543023	g10462	i0	71.6	1.98606271777003	95	27	99.3	2	286	100	194	CAA9554733.1 MAG: Lysophospholipase; Monoglyceride lipase [uncultured Truepera sp.]	diamond	570	132	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27316296	27316296	PRJNA853203_P_NODE_40763_length_245_cov_1.779070_g40614_i0	PRJNA853203	40763	245	1.77907	4.3587215	Deinococcus	1298	Bacteria	Bacteria	147	1.57e-41	NR	WP_199776989.1	2080419	g40614	i0	86.4	1.98367346938776	81	11	99.2	244	2	216	296	WP_199776989.1 hypothetical protein [Deinococcus sp. NW-56]	diamond	486	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
27402784	27402784	PRJNA853203_P_NODE_14683_length_278_cov_1.234146_g14534_i0	PRJNA853203	14683	278	1.234146	3.43092588	Cloacibacillus porcorum	1197717	Bacteria	Bacteria	58.9	7.92e-8	NR	WP_066745707.1	1197717	g14534	i0	68.6	1.51079136690647	35	11	37.8	172	276	1	35	WP_066745707.1 DNA-methyltransferase [Cloacibacillus porcorum]	diamond	420	58.9	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Cloacibacillus	Cloacibacillus porcorum
29518059	29518059	PRJNA853203_P_NODE_14210_length_279_cov_1.296117_g14061_i0	PRJNA853203	14210	279	1.296117	3.61616643	Truepera radiovictrix	332249	Bacteria	Bacteria	109	1.47e-25	NR	WP_049772988.1	332249	g14061	i0	61.5	1.96774193548387	91	35	97.8	2	274	289	379	WP_049772988.1 sulfatase [Truepera radiovictrix]	diamond	549	109	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
30568464	30568464	PRJNA853203_P_NODE_37853_length_247_cov_0.896552_g37704_i0	PRJNA853203	37853	247	0.896552	2.21448344	Deinococcus	1298	Bacteria	Bacteria	105	3.97e-26	NR	QFP75002.1	2652443	g37704	i0	61	2.98785425101215	82	32	99.6	2	247	135	216	QFP75002.1 PIN domain-containing protein [Deinococcus sp. AJ005]	diamond	738	105	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
31128942	31128942	PRJNA853203_P_NODE_47275_length_242_cov_0.923077_g47126_i0	PRJNA853203	47275	242	0.923077	2.23384634	Deinococcus marmoris	249408	Bacteria	Bacteria	157	7.18e-47	NR	WP_075836378.1	249408	g47126	i0	87.5	0.991735537190083	80	10	99.2	241	2	5	84	WP_075836378.1 chloramphenicol phosphotransferase CPT family protein [Deinococcus marmoris]	diamond	240	157	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus marmoris
31983153	31983153	PRJNA853203_P_NODE_8478_length_293_cov_1.777273_g8329_i0	PRJNA853203	8478	293	1.777273	5.20740989	Thermus scotoductus	37636	Bacteria	Bacteria	96.7	7.85e-21	NR	WP_126188071.1	37636	g8329	i0	98	0.511945392491468	50	1	51.2	292	143	961	1010	WP_126188071.1 DUF1156 domain-containing protein [Thermus scotoductus]	diamond	150	96.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
32054661	32054661	PRJNA853203_P_NODE_46418_length_242_cov_2.733728_g46269_i0	PRJNA853203	46418	242	2.733728	6.61562176	Deinococcus	1298	Bacteria	Bacteria	135	1.2499999999999999e-34	NR	WP_229831785.1	1141878	g46269	i0	82.5	3.96694214876033	80	14	99.2	1	240	272	351	WP_229831785.1 translocation/assembly module TamB domain-containing protein [Deinococcus metalli]	diamond	960	136	0.992647058823529	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metalli
32458009	32458009	PRJNA853203_P_NODE_33919_length_249_cov_0.886364_g33770_i0	PRJNA853203	33919	249	0.886364	2.20704636	Deinococcus koreensis	2054903	Bacteria	Bacteria	114	1.75e-27	NR	WP_103312551.1	2054903	g33770	i0	76.5	0.975903614457831	81	19	97.6	248	6	65	145	WP_103312551.1 putative bifunctional diguanylate cyclase/phosphodiesterase [Deinococcus koreensis]	diamond	243	114	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus koreensis

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