metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA482207" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA482207" 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
448151	448151	PRJNA482207_P_NODE_28481_length_243_cov_0.905882_g28371_i0	PRJNA482207	28481	243	0.905882	2.20129326	Leifsonia aquatica	144185	Bacteria	Bacteria	158	2.6099999999999993e-43	NR	WP_183428274.1	144185	g28371	i0	97.5	1.97530864197531	80	2	98.8	0	242	3	229	308	WP_183428274.1 S9 family peptidase [Leifsonia aquatica]	diamond	480	158	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia aquatica
10651732	10651732	PRJNA482207_P_NODE_23369_length_248_cov_0.880000_g23259_i0	PRJNA482207	23369	248	0.88	2.1824	Pseudonocardia sp.	60912	Bacteria	Bacteria	106	2.12e-26	NR	HTK66115.1	60912	g23259	i0	79.7	0.834677419354839	69	14	83.5	0	42	248	5	73	HTK66115.1 helix-turn-helix domain-containing protein [Pseudonocardia sp.]	diamond	207	106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp.
11926760	11926760	PRJNA482207_P_NODE_27890_length_243_cov_0.905882_g27780_i0	PRJNA482207	27890	243	0.905882	2.20129326	Nocardiopsis tropica	109330	Bacteria	Bacteria	120	2.7e-32	NR	WP_330161433.1	109330	g27780	i0	77.3	1.83950617283951	75	17	92.6	0	18	242	10	84	WP_330161433.1 carbonic anhydrase [Nocardiopsis tropica]	diamond	447	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis tropica
20223539	20223539	PRJNA482207_P_NODE_15436_length_280_cov_1.357488_g15326_i0	PRJNA482207	15436	280	1.357488	3.8009664	Actinomycetota bacterium	2900548	Bacteria	Bacteria	130	6.779999999999999e-35	NR	MDQ2671276.1	2900548	g15326	i0	71.7	0.985714285714286	92	26	98.6	0	3	278	173	264	MDQ2671276.1 AAC(3) family N-acetyltransferase [Actinomycetota bacterium]	diamond	276	130	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27202505	27202505	PRJNA482207_P_NODE_27802_length_243_cov_0.905882_g27692_i0	PRJNA482207	27802	243	0.905882	2.20129326	Micromonospora auratinigra	261654	Bacteria	Bacteria	47	0.00114	NR	WP_091658452.1	261654	g27692	i0	38.2	0.839506172839506	68	32	71.6	2	24	197	321	388	WP_091658452.1 D-alanyl-D-alanine carboxypeptidase family protein [Micromonospora auratinigra]	diamond	204	47	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora auratinigra
27234315	27234315	PRJNA482207_P_NODE_20383_length_250_cov_0.870056_g20273_i0	PRJNA482207	20383	250	0.870056	2.17514	Micrococcus	1269	Bacteria	Bacteria	42.7	0.0237	NR	WP_224354747.1	1269	g20273	i0	40.8	1.764	49	28	58.8	1	76	222	19	66	WP_224354747.1 MULTISPECIES: peptide-methionine (R)-S-oxide reductase MsrB [Micrococcus]	diamond	441	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus
29097450	29097450	PRJNA482207_P_NODE_28448_length_243_cov_0.905882_g28338_i0	PRJNA482207	28448	243	0.905882	2.20129326	Streptosporangiaceae bacterium NEAU-GS5	2820291	Bacteria	Bacteria	79	1.38e-15	NR	MBO3752168.1	2820291	g28338	i0	58.4	0.950617283950617	77	32	95.1	0	4	234	1	77	MBO3752168.1 replication-relaxation family protein [Streptosporangiaceae bacterium NEAU-GS5]	diamond	231	79	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae		Streptosporangiaceae bacterium NEAU-GS5
29475945	29475945	PRJNA482207_P_NODE_22350_length_249_cov_0.869318_g22240_i0	PRJNA482207	22350	249	0.869318	2.16460182	Cellulomonas sp. 179-A 4D5 NHS	3142378	Bacteria	Bacteria	43.9	0.0149	NR	WP_412871527.1	3142378	g22240	i0	36.4	0.927710843373494	77	42	86.7	2	6	221	187	261	WP_412871527.1 RNA polymerase sigma factor [Cellulomonas sp. 179-A 4D5 NHS]	diamond	231	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas sp. 179-A 4D5 NHS
29696863	29696863	PRJNA482207_P_NODE_17550_length_264_cov_1.230366_g17440_i0	PRJNA482207	17550	264	1.230366	3.24816624	Streptomyces sp. TRM 7	1931	Bacteria	Bacteria	42.7	0.0467	NR	WP_330137847.1	3116552	g17440	i0	36.4	0.875	77	38	75	2	24	221	129	205	WP_330137847.1 hypothetical protein [Streptomyces sp. TRM 70351]	diamond	231	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. TRM 70351
30013195	30013195	PRJNA482207_P_NODE_20111_length_251_cov_0.865169_g20001_i0	PRJNA482207	20111	251	0.865169	2.17157419	Streptomyces filamentosus NRRL 15998	457431	Bacteria	Bacteria	42	0.00871	NR	EFE78180.1	457431	g20001	i0	46.2	0.466135458167331	39	21	46.6	0	251	135	21	59	EFE78180.1 conserved hypothetical protein [Streptomyces filamentosus NRRL 15998]	diamond	117	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces filamentosus
31372060	31372060	PRJNA482207_P_NODE_27436_length_244_cov_0.900585_g27326_i0	PRJNA482207	27436	244	0.900585	2.1974274	Leifsonia aquatica	144185	Bacteria	Bacteria	47.4	7.98e-4	NR	WP_400975647.1	144185	g27326	i0	43.3	1.38934426229508	60	34	73.8	0	182	3	2	61	WP_400975647.1 endonuclease domain-containing protein [Leifsonia aquatica]	diamond	339	47.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia aquatica
31514741	31514741	PRJNA482207_P_NODE_21556_length_249_cov_0.875000_g21446_i0	PRJNA482207	21556	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	159	1.21e-47	NR	MCH1435481.1	2201156	g21446	i0	90.2	1.97590361445783	82	8	98.8	0	3	248	89	170	MCH1435481.1 hypothetical protein [Acidimicrobiales bacterium]	diamond	492	160	0.99375	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
31688097	31688097	PRJNA482207_P_NODE_19717_length_251_cov_0.865169_g19607_i0	PRJNA482207	19717	251	0.865169	2.17157419	Nocardioides sp. KR1	35761	Bacteria	Bacteria	43.1	0.0283	NR	WP_348858936.1	3156615	g19607	i0	30.1	0.872509960159363	73	51	87.3	0	242	24	226	298	WP_348858936.1 VWA domain-containing protein [Nocardioides sp. KR10-350]	diamond	219	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides cheoyonin
32352833	32352833	PRJNA482207_P_NODE_24559_length_246_cov_1.173410_g24449_i0	PRJNA482207	24559	246	1.17341	2.8865886	Gulosibacter	256818	Bacteria	Bacteria	42.7	0.0168	NR	WP_125105932.1	256818	g24449	i0	33.3	0.768292682926829	63	39	74.4	2	7	189	20	81	WP_125105932.1 MULTISPECIES: group III truncated hemoglobin [Gulosibacter]	diamond	189	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Gulosibacter
32415981	32415981	PRJNA482207_P_NODE_24339_length_247_cov_0.885057_g24229_i0	PRJNA482207	24339	247	0.885057	2.18609079	Actinomycetota bacterium	2900548	Bacteria	Bacteria	82.4	1.34e-16	NR	MEM9562481.1	2900548	g24229	i0	74.1	0.65587044534413	54	14	65.6	0	1	162	170	223	MEM9562481.1 FAD binding domain-containing protein [Actinomycetota bacterium]	diamond	162	82.4	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
32605508	32605508	PRJNA482207_P_NODE_8640_length_346_cov_2.194139_g8530_i0	PRJNA482207	8640	346	2.194139	7.59172094	Kitasatospora herbaricolor	68217	Bacteria	Bacteria	107	2.91e-28	NR	GGV54946.1	68217	g8530	i0	95.7	0.398843930635838	46	2	39.9	0	198	61	1	46	GGV54946.1 hypothetical protein GCM10010495_82560 [Kitasatospora herbaricolor]	diamond	138	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora herbaricolor

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