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

14 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax_phylum = "Actinomycetota"

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
878075	878075	PRJNA900999_S_NODE_1041_length_338_cov_3.411003_g985_i0	PRJNA900999	1041	338	3.411003	11.52919014	Actinomycetospora sp. TBRC 11914	2729387	Bacteria	Bacteria	125	5.5299999999999996e-34	NR	WP_312030173.1	2729387	g985	i0	62.9	1.74852071005917	97	36	86.1	0	322	32	1	97	WP_312030173.1 ATP-binding protein [Actinomycetospora sp. TBRC 11914]	diamond	591	125	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinomycetospora	Actinomycetospora sp. TBRC 11914
2153435	2153435	PRJNA900999_S_NODE_6802_length_174_cov_1.931034_g6746_i0	PRJNA900999	6802	174	1.931034	3.35999916	Actinomycetospora cinnamomea	663609	Bacteria	Bacteria	68.9	1.01e-12	NR	WP_116706488.1	663609	g6746	i0	76.9	4.44827586206897	52	12	89.7	0	156	1	63	114	WP_116706488.1 FxsA family protein [Actinomycetospora cinnamomea]	diamond	774	68.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinomycetospora	Actinomycetospora cinnamomea
9806040	9806040	PRJNA900999_S_NODE_7528_length_167_cov_2.021739_g7472_i0	PRJNA900999	7528	167	2.021739	3.37630413	Propionibacteriales bacterium	2015801	Bacteria	Bacteria	64.7	2.34e-10	NR	MCX6401035.1	2015801	g7472	i0	69.8	1.58083832335329	43	8	77.2	1	38	166	349	386	MCX6401035.1 amidase family protein [Propionibacteriales bacterium]	diamond	264	64.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales			Propionibacteriales bacterium
16180806	16180806	PRJNA900999_S_NODE_2993_length_238_cov_2.215311_g2937_i0	PRJNA900999	2993	238	2.215311	5.27244018	Jatrophihabitans sp. GAS493	1907575	Bacteria	Bacteria	94.4	1.68e-20	NR	WP_096302508.1	1907575	g2937	i0	66.7	2.55882352941176	69	23	87	0	226	20	149	217	WP_096302508.1 geranylgeranyl reductase family protein [Jatrophihabitans sp. GAS493]	diamond	609	94.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Jatrophihabitantales	Jatrophihabitantaceae	Jatrophihabitans	Jatrophihabitans sp. GAS493
17456304	17456304	PRJNA900999_S_NODE_2154_length_268_cov_2.322176_g2098_i0	PRJNA900999	2154	268	2.322176	6.22343168	Pseudonocardia sp.	60912	Bacteria	Bacteria	155	9.81e-44	NR	HZZ50329.1	60912	g2098	i0	92.1	0.996268656716418	89	7	99.6	0	2	268	210	298	HZZ50329.1 MarP family serine protease [Pseudonocardia sp.]	diamond	267	155	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp.
23830261	23830261	PRJNA900999_S_NODE_959_length_346_cov_2.785489_g903_i0	PRJNA900999	959	346	2.785489	9.63779194	Actinomycetes	1760	Bacteria	Bacteria	151	7.12e-43	NR	MDT4944229.1	2201155	g903	i0	83.1	12.4682080924855	89	15	77.2	0	323	57	175	263	MDT4944229.1 hypothetical protein [Pseudonocardiales bacterium]	diamond	4314	151	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales			Pseudonocardiales bacterium
26644149	26644149	PRJNA900999_S_NODE_6701_length_175_cov_1.678082_g6645_i0	PRJNA900999	6701	175	1.678082	2.9366435	Jatrophihabitantaceae bacterium	2811413	Bacteria	Bacteria	62.8	1.06e-9	NR	HSY15230.1	2811413	g6645	i0	55.2	3.97714285714286	58	24	99.4	1	175	2	193	248	HSY15230.1 cytochrome c oxidase assembly protein [Jatrophihabitantaceae bacterium]	diamond	696	62.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Jatrophihabitantales	Jatrophihabitantaceae		Jatrophihabitantaceae bacterium
26897752	26897752	PRJNA900999_S_NODE_5181_length_193_cov_3.268293_g5125_i0	PRJNA900999	5181	193	3.268293	6.30780549	Pseudonocardia sp.	60912	Bacteria	Bacteria	48.5	1.7e-4	NR	HTK63426.1	60912	g5125	i0	50	0.870466321243523	56	28	87	0	24	191	38	93	HTK63426.1 DUF4407 domain-containing protein [Pseudonocardia sp.]	diamond	168	48.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp.
28035100	28035100	PRJNA900999_S_NODE_7305_length_169_cov_1.692857_g7249_i0	PRJNA900999	7305	169	1.692857	2.86092833	Pseudonocardia sp.	60912	Bacteria	Bacteria	62	2.19e-9	NR	HEY9417311.1	60912	g7249	i0	65.9	0.781065088757396	44	15	78.1	0	169	38	282	325	HEY9417311.1 aldehyde dehydrogenase family protein [Pseudonocardia sp.]	diamond	132	62	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp.
28477005	28477005	PRJNA900999_S_NODE_2566_length_252_cov_3.291480_g2510_i0	PRJNA900999	2566	252	3.29148	8.2945296	Protaetiibacter sp.	2680007	Bacteria	Bacteria	43.1	0.0295	NR	MFT4029147.1	2680007	g2510	i0	43.4	0.630952380952381	53	30	63.1	0	58	216	96	148	MFT4029147.1 sugar ABC transporter permease [Protaetiibacter sp.]	diamond	159	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Protaetiibacter	Protaetiibacter sp.
28926599	28926599	PRJNA900999_S_NODE_1908_length_279_cov_2.332000_g1852_i0	PRJNA900999	1908	279	2.332	6.50628	Bacteria	2	Bacteria	Bacteria	59.7	5.64e-8	NR	HEX5096827.1	2080302	g1852	i0	67.6	1.19354838709677	37	12	39.8	0	2	112	303	339	HEX5096827.1 hypothetical protein [Acidimicrobiia bacterium]	diamond	333	59.7	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
29518875	29518875	PRJNA900999_S_NODE_2790_length_244_cov_7.074419_g2734_i0	PRJNA900999	2790	244	7.074419	17.26158236	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	43.1	0.026	NR	MCO6501732.1	2201156	g2734	i0	38.9	0.663934426229508	54	32	65.2	1	188	30	268	321	MCO6501732.1 HlyC/CorC family transporter [Acidimicrobiales bacterium]	diamond	162	43.1	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
31161329	31161329	PRJNA900999_S_NODE_4595_length_202_cov_4.797688_g4539_i0	PRJNA900999	4595	202	4.797688	9.69132976	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	85.1	2.18e-18	NR	MBA2280974.1	2080302	g4539	i0	72.9	0.876237623762376	59	16	87.6	0	24	200	114	172	MBA2280974.1 polyprenyl synthetase family protein [Acidimicrobiia bacterium]	diamond	177	85.1	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
31857366	31857366	PRJNA900999_S_NODE_6297_length_179_cov_4.306667_g6241_i0	PRJNA900999	6297	179	4.306667	7.70893393	Kribbella sp. CA-293567	3002436	Bacteria	Bacteria	70.1	7.66e-13	NR	WP_270138672.1	3002436	g6241	i0	82.6	0.770949720670391	46	8	77.1	0	36	173	11	56	WP_270138672.1 TetR/AcrR family transcriptional regulator [Kribbella sp. CA-293567]	diamond	138	70.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Kribbellaceae	Kribbella	Kribbella sp. CA-293567

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