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

14 rows where analysis = "diamond", bioproject = "PRJNA509429" 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
26697215	26697215	PRJNA509429_P_NODE_30841_length_220_cov_1.135135_g30013_i0	PRJNA509429	30841	220	1.135135	2.497297	unclassified Streptomyces	2593676	Bacteria	Bacteria	42	0.0276	NR	WP_141712220.1	2593676	g30013	i0	41.2	0.695454545454545	51	20	69.5	1	25	177	92	132	WP_141712220.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces]	diamond	153	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
27013814	27013814	PRJNA509429_P_NODE_30262_length_223_cov_1.313830_g29434_i0	PRJNA509429	30262	223	1.31383	2.9298409	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	42.7	0.0278	NR	MEE8376588.1	2080302	g29434	i0	37.1	0.834080717488789	62	39	83.4	0	2	187	210	271	MEE8376588.1 hypothetical protein [Acidimicrobiia bacterium]	diamond	186	42.7	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
27393373	27393373	PRJNA509429_P_NODE_34563_length_202_cov_1.179641_g33735_i0	PRJNA509429	34563	202	1.179641	2.38287482	Arthrobacter globiformis NBRC 12137	1077972	Bacteria	Bacteria	42	0.0416	NR	GAB15080.1	1077972	g33735	i0	45	0.891089108910891	60	30	89.1	1	1	180	319	375	GAB15080.1 hypothetical protein ARGLB_080_01455 [Arthrobacter globiformis NBRC 12137]	diamond	180	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter globiformis
27614412	27614412	PRJNA509429_P_NODE_28804_length_232_cov_1.086294_g27976_i0	PRJNA509429	28804	232	1.086294	2.52020208	Mycobacterium sp.	1785	Bacteria	Bacteria	44.3	0.00317	NR	WP_324396383.1	1785	g27976	i0	45.8	0.620689655172414	48	20	59.5	2	61	198	42	85	WP_324396383.1 hypothetical protein [Mycobacterium sp.]	diamond	144	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
27772344	27772344	PRJNA509429_P_NODE_47884_length_159_cov_0.959677_g47056_i0	PRJNA509429	47884	159	0.959677	1.52588643	Dactylosporangium thailandense	47849	Bacteria	Bacteria	41.2	0.0364	NR	BFE59973.1	47849	g47056	i0	60.6	0.622641509433962	33	13	62.3	0	59	157	5	37	BFE59973.1 hypothetical protein GCM10020063_044990 [Dactylosporangium thailandense]	diamond	99	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium thailandense
28403594	28403594	PRJNA509429_P_NODE_46246_length_163_cov_1.000000_g45418_i0	PRJNA509429	46246	163	1	1.63	Humibacter sp.	1940291	Bacteria	Bacteria	41.6	0.017	NR	HWU47418.1	1940291	g45418	i0	42.5	1.34355828220859	40	18	73.6	1	163	44	19	53	HWU47418.1 hypothetical protein [Humibacter sp.]	diamond	219	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Humibacter	Humibacter sp.
28719408	28719408	PRJNA509429_P_NODE_34487_length_202_cov_1.886228_g33659_i0	PRJNA509429	34487	202	1.886228	3.81018056	Streptomyces albospinus	285515	Bacteria	Bacteria	41.2	0.0151	NR	WP_189308268.1	285515	g33659	i0	40.4	0.698019801980198	47	24	69.8	1	142	2	3	45	WP_189308268.1 hypothetical protein [Streptomyces albospinus]	diamond	141	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albospinus
29476804	29476804	PRJNA509429_P_NODE_42410_length_173_cov_3.217391_g41582_i0	PRJNA509429	42410	173	3.217391	5.56608643	Streptomyces melanogenes	67326	Bacteria	Bacteria	39.3	0.0298	NR	WP_190088150.1	67326	g41582	i0	53.1	0.554913294797688	32	12	50.3	1	84	170	4	35	WP_190088150.1 hypothetical protein [Streptomyces melanogenes]	diamond	96	39.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces melanogenes
29697701	29697701	PRJNA509429_P_NODE_17930_length_324_cov_7.982699_g17102_i0	PRJNA509429	17930	324	7.982699	25.86394476	uncultured Microbacterium sp.	191216	Bacteria	Bacteria	43.9	0.036	NR	WP_295840303.1	191216	g17102	i0	32.6	0.824074074074074	89	48	81.5	3	19	282	4	81	WP_295840303.1 flavin monoamine oxidase family protein [uncultured Microbacterium sp.]	diamond	267	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	uncultured Microbacterium sp.
29982362	29982362	PRJNA509429_P_NODE_9891_length_462_cov_4.711944_g5835_i2	PRJNA509429	9891	462	4.711944	21.76918128	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	42.7	0.0475	NR	WP_362953358.1	3155267	g5835	i2	48.1	0.350649350649351	54	23	31.8	2	156	302	22	75	WP_362953358.1 hypothetical protein [Streptomyces sp. NPDC048669]	diamond	162	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC048669
31246214	31246214	PRJNA509429_P_NODE_43935_length_169_cov_1.246269_g43107_i0	PRJNA509429	43935	169	1.246269	2.10619461	Corynebacterium efficiens YS-314	196164	Bacteria	Bacteria	50.1	3.05e-5	NR	BAC18353.1	196164	g43107	i0	50	1.75739644970414	50	25	88.8	0	18	167	110	159	BAC18353.1 conserved hypothetical protein [Corynebacterium efficiens YS-314]	diamond	297	50.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium efficiens
32195249	32195249	PRJNA509429_P_NODE_33938_length_204_cov_8.644970_g33110_i0	PRJNA509429	33938	204	8.64497	17.6357388	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	47	7.1e-4	NR	HEX4539557.1	2201156	g33110	i0	39.7	1.07352941176471	73	31	97.1	2	5	202	169	235	HEX4539557.1 hypothetical protein [Acidimicrobiales bacterium]	diamond	219	47	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
32385096	32385096	PRJNA509429_P_NODE_28619_length_232_cov_23.258883_g27791_i0	PRJNA509429	28619	232	23.258883	53.96060856	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	42.4	0.043	NR	WP_383302644.1	3346067	g27791	i0	34.4	0.827586206896552	64	40	82.8	1	28	219	163	224	WP_383302644.1 sigma-70 family RNA polymerase sigma factor [Streptomyces sp. NPDC057249]	diamond	192	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC057249
32385098	32385098	PRJNA509429_P_NODE_42579_length_173_cov_1.384058_g41751_i0	PRJNA509429	42579	173	1.384058	2.39442034	Actinomycetota bacterium	2900548	Bacteria	Bacteria	40.4	0.0146	NR	MBA2615054.1	2900548	g41751	i0	47.4	0.658959537572254	38	20	65.9	0	39	152	2	39	MBA2615054.1 hypothetical protein [Actinomycetota bacterium]	diamond	114	40.4	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium

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